Plesk upgrade error: PleskMainDBException: DB query failed: Unknown column '<description>' in 'field list' (db.php:61)"

Created:

2016-11-16 12:42:24 UTC

Modified:

2017-08-16 17:02:20 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Plesk upgrade error: PleskMainDBException: DB query failed: Unknown column '<description>' in 'field list' (db.php:61)"

Applicable to:

  • Plesk 11.x for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

Symptoms

Plesk upgrade failed. Plesk is not accessible. The following errors can be found in logs or shown in Plesk after log in:

ERROR: PleskMainDBException: DB query failed: Unknown column 'description' in 'field list' (db.php:61)

OR

MSI: Error! Critical action 'Creating bayes database...' failed:
Command "C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\local_mysql_helper.exe" --create-database-and-user -database sa_bayes -database-user sa_bayes -database-user-password * failed with code 1. Output: ERROR: PleskMainDBException: DB query failed: Unknown column 'description' in 'field list' (db.php:70)<br />

Cause

Plesk database is not upgraded properly.

Resolution

  1. Back up Plesk database:

    "%plesk_dir%"\\Mysql\\bin\\mysqldump.exe -uadmin -p<plesk_admin_password> -P8306 psa > psa_dump.sql
  2. Add missing table manually:

    mysql> ALTER TABLE clients ADD description  varchar(255) DEFAULT NULL;
  3. Upgrade the database manually. For example, use the following command in case of upgrade from Plesk 11.5 to Plesk 12.0:

    "%plesk_dir%"\\admin\\bin\\dbupgrade.exe --upgrade --from-version=11.5.30 --to-version=12.0.18
  4. If upgrade was performed to Plesk 12.5 or Plesk Onyx, it is also required to run the following command:

    "%plesk_bin%\\php.exe" -q "%plesk_bin%\\admin\\upgrade\\db\\db.php" migrate --force
  5. Run Plesk installer and finish upgrade if required.

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