Plesk upgrade or WordPress installation fails: Column count of mysql.proc is wrong

Created:

2016-11-16 13:13:48 UTC

Modified:

2017-08-17 19:24:58 UTC

5

Was this article helpful?


Have more questions?

Submit a request

Plesk upgrade or WordPress installation fails: Column count of mysql.proc is wrong

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux

Symptoms

  • 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 /var/log/plesk/install/plesk_12.0.18_installation.log :

    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.

    or

    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.

  • WordPress installation fails with the same error.

Cause

The mysql.proc table has an incorrect schema (was not upgraded during MySQL upgrade).

Resolution

  1. Connect to the server using SSH .
  2. Create databases backups:

    # cp -rp /var/lib/mysql/ /root/

    Note: Make sure there is enough disk space on the server
  3. Run mysql_upgrade:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin

  4. Make sure that mysql.proc has been upgraded and has 20 columns:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql -Nse "desc proc" | wc -l
    20

  5. Continue WordPress installation or Plesk upgrade with Tools & Settings > Updates & Upgrades or using CLI:

    # plesk installer

Have more questions? Submit a request
Please sign in to leave a comment.