Plesk is not working after the upgrade:

[mahesh]

Question:
Plesk is not working after the upgrade: Specified column "status" is not in the row
Symptoms

• Unable to log in to Plesk:

Server Error
500
Zend_Db_Table_Row_Exception

Specified column "status" is not in the row
Type Zend_Db_Table_Row_Exception
Message Specified column "status" is not in the row
File Abstract.php
Line 179

Internal error:
Specified column "status" is not in the row
Message Specified column "status" is not in the row
File Abstract.php
Line 179
Type Zend_Db_Table_Row_Exception

• The following entries are found in /var/log/plesk/panel.log:

ERR [panel] Specified column "status" is not in the row:
0: /usr/local/psa/admin/externals/Zend/Db/Table/Row/Abstract.php:179
Zend_Db_Table_Row_Abstract->__get(string 'status')
...
ERROR: Zend_Db_Table_Row_Exception: Specified column "status" is not in the row (Abstract.php:179)
Some steps of upgrade failed. Run upgrade with option --repair to rerun failed steps.

Cause
Plesk database inconsistency, possibly during a failed database upgrade.

Resolution
Restore Plesk database from a pre-upgrade dump and run plesk repair utility to fix other conflicts:

1.Connect to the server via SSH.

2.Create a backup of Plesk database:

Code Select Expand

#plesk db dump > psa.current.sql
3.to the directory with pre-upgrade dumps:

Code Select Expand

#cd /var/lib/psa/dumps
4.all available pre-upgrade dumps:

Code Select Expand

#ls -l mysql.preupgrade*
-rw------- 1 root root 221821 May 4 18:03 mysql.preupgrade.18.0.25-18.0.26.20200504-180302.dump.gz
-rw------- 1 root root 236912 May 24 14:02 mysql.preupgrade.18.0.26-18.0.27.20200524-140248.dump.gz
In the example below, we are restoring all system databases from a dump file that was created before an upgrade from Plesk Obsidian 18.0.26 to 18.0.27:

5.Restore system databases:

Code Select Expand

#zcat mysql.preupgrade.18.0.25-18.0.26.20200504-180302.dump.gz | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin
6.Run Plesk repair installation to fix possible database version conflicts:

Code Select Expand

#plesk repair installation