Plesk is not accessible, the following error message is displayed under
ERR [panel] Cannot load settings: DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: select param, val from misc
DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: replace into misc (param, val) values(:param, :val)
Note: table name may be different
Plesk was recently upgraded:
# plesk db “select * from upgrade_history”
| upgrade_date | version_info | db_version | os | mu | update_ticket |
| 2020-04-03 02:54:58 | 18.0.28 | NULL | CentOS 7.7.1908 | 2 | |
psa was not fully upgraded during the Plesk upgrade.
Connect to the server via SSH
List all available Plesk daily database dumps sorted by the date:
# ls -lt /var/lib/psa/dumps/mysql.daily.*
-rw——- 1 root root 236253 Feb 3 01:51 mysql.daily.dump.0.gz
-rw——- 1 root root 229653 Feb 2 01:48 mysql.daily.dump.1.gz
-rw——- 1 root root 222485 Feb 1 01:56 mysql.daily.dump.2.gz
mysql.daily.dump.0.gzis the most recent daily database dump.
psadatabase from the most recent daily dump:
# zcat mysql.daily.dump.0.gz | sed -n ‘/– Current Database:
psa/,/– Current Database:*/p’ | MYSQL_PWD=
cat /etc/psa/.psa.shadowmysql -uadmin
If restoration of the
psadatabase fails with the below error, restore from the next most recent backup:
ERROR 1265 (01000) at line 3375: Data truncated for column 'event_type' at row 2362
- Rerun the Plesk upgrade operation: How to upgrade Plesk?