Parallels Plesk fails to load after an upgrade. The following errors may appear:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'parentDomainId' in 'where clause'
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.serviceinstallations' doesn't exist
DB query failed: Unknown column 'php_handler_id' in 'field list'
The Parallels Plesk database was not converted successfully.
Create a backup of your current
"%plesk_dir%\MySQL\bin\mysqldump.exe" -uadmin -P8306 -p<PleskPanelPasswordHere> psa > c:\psa.sql
Upgrade the database manually, making sure to specify the correct
toversions. You can get the database version from the
For example, if Plesk was upgraded from version 9.5.4 to version 10.4.4, run the following:
"%plesk_bin%\dbupgrade.exe" --upgrade --from-version=9.5.4 --to-version=10.4.4
Or, from version 11.0.9 to version 11.5.30:
"%plesk_bin%\dbupgrade.exe" --upgrade --from-version=11.0.9 --to-version=11.5.30