- Plesk 12.5 for Linux
- Plesk 12.0 for Windows
- Plesk 12.0 for Linux
- Plesk Onyx for Linux
- Plesk upgrade fails with a similar to the below error message:
CONFIG_TEXT: ERROR while trying to upgrade APSC SQL database from 11.1.0
Check the error reason(see log file: /var/log/plesk/install/plesk_12.5.30_repair.log), fix and try again
The following error can be found in the
CONFIG_TEXT: ERROR 1558 (HY000) at line 67: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50095, now running 50538. Please use mysql_upgrade to fix this error.
Unable to create a database in Plesk:
CONFIG_TEXT: Connection to the database server failed: Column count of mysql.user is wrong. Expected 42, found 39. Created with MySQL 50173, now running 50556. Please use mysql_upgrade to fix this error.
- Also some other actions may lead to the same error like WordPress installation, new PHP handler installtion or password reset.
mysql.proc/mysql.user table has an incorrect schema (was not upgraded during MySQL upgrade).
- Connect to the server using SSH .
Create databases backups:
# cp -rp /var/lib/mysql/ /root/Note: Make sure there is enough disk space on the server
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
Make sure that
mysql.prochas been upgraded and has 20 columns:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql -Nse "desc proc" | wc -l
Make sure that
mysql.userhas been upgraded and has 42 columns:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql -Nse "desc user" | wc -l