Symptoms
-
When accessing Plesk, the following error message appears in a web-browser:
PLESK_INFO: ERROR: Call to a member function getSkinUrl() on null (SkinUrl.php:18)
-
When running the
plesk login
command or repairing the Plesk database with the commandplesk repair db
, the process fails with: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
Cause
The Plesk ‘psa’ database is corrupted: The “psa.misc” table is missing.
Resolution
-
Connect to the Plesk server via SSH.
-
Switch to the directory with daily dumps:
# cd /var/lib/psa/dumps
-
List all available Plesk daily dumps:
# ls -l 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-
where
mysql.daily.dump.0.gz
is the most recent daily dump.
-
-
Restore the ‘psa’ database from the most recent daily dump. In this example, the ‘psa’ database is restored from
mysql.daily.dump.0.gz
:# zcat mysql.daily.dump.0.gz | sed -n ‘/– Current Database: `psa`/,/– Current Database:*/p’ | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin
-
Open Plesk.