- Plesk 10.x for Linux
- Plesk 11.x for Linux
- Plesk 11.x for Windows
- Plesk 12.0 for Linux
- Plesk 12.0 for Windows
- Plesk 12.5 for Linux
- Plesk 12.5 for Windows
Plesk database is not upgraded to version 12.5.
The following error is shown in Plesk:
DB query failed: Unknown column 'icpStatus' in 'field list'
Specified column "plesk_max_version" is not in the row
Plesk upgrade failed. The following error is shown when trying to access Plesk:
ERROR: Zend_Db_Table_Row_Exception: Specified column "plesk_max_version" is not in the row
WARNING: in case the upgrade was performed to Plesk Onyx, do not apply the solution below but execute '
plesk repair db' command via the command line. This article is not applicable for Plesk Onyx.
- Restore pre-upgrade
- Upgrade database manually running
"%plesk_bin%\\dbupgrade.exe"in command prompt:
If upgrade was performed from 12.0.18 version:
C:\> "%plesk_bin%\\dbupgrade.exe" --upgrade "--from-version=12.0.18" "--to-version=12.5.16193"
If upgrade was performed from 11.0.9 version:
C:\> "%plesk_bin%\\dbupgrade.exe" --upgrade "--from-version=11.0.9" "--to-version=12.5.16193"
- Run the following command to apply the changes to Plesk database scheme:
C:\> "%plesk_bin%\\php.exe" -q "%plesk_dir%\\admin\\upgrade\\db\\db.php" migrate --force
Note: If there is no pre-upgrade dumps, try to run steps 2 and 3. Make sure first that you created current database state dump.
- Restore pre-upgrade
apscdatabases dumps from
CONFIG_TEXT: 12.0.18 CentOS 6 1200180000.00
Note : This is an example. It should contain your OS.
- Run the following command to re-run post-upgrade check:
# /usr/local/psa/bootstrapper/pp12.5.30-bootstrapper/bootstrapper.sh rerun
- If previous command fails with the same message:
CONFIG_TEXT: Unknown column '********' in 'field list'4.1. Install a new server with Plesk 12.5.30, or find a Plesk 12.5.30 that you can connect to its database to get a dump with:
# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa --no-data > 12.5.30-db-struct.sql4.2. Identify the columns that are missing from the error message shown with bootstrapper commandline ran in point 3.
The message should be like:
CONFIG_TEXT: Unknown column '********' in 'field list'
4.3. Then, restore the DB of Plesk of point 1.
4.4. Connect to the "
plesk db"and in another terminal open the file from the other server "
12.5.30-db-struct.sql"Then, search for the column name in the SQL file.
4.5. Then keep adding the missing columns with in mysql with:
ALTER TABLE `********` ADD COLUMNand copy the column structure from the file
The column will look like:
CONFIG_TEXT: `********` int(1) NOT NULL DEFAULT '0'
All this line has to be added after ADD COLUMN in ALTER statement from MySQL.
More info at MySQL manual: http://dev.mysql.com/doc/refman/5.7/en/alter-table.html
4.6. Once you've finished with tables from PSA database, return to point 2 of this guide for Linux.
- Finish the upgrade