Pelsk is not accessible ERROR: PleskMainDBException: DB query failed: Table doesn't exist (db.php:61)

Created:

2016-11-16 13:09:13 UTC

Modified:

2017-08-08 13:36:30 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Pelsk is not accessible ERROR: PleskMainDBException: DB query failed: Table doesn't exist (db.php:61)

Applicable to:

  • Plesk for Windows

Symptoms

Plesk is not accessible. The following error appears on Plesk login page:

ERROR: PleskMainDBException: DB query failed: Table 'psa.domains' doesn't exist (db.php:61)

Cause

Plesk database is corrupted.

Resolution

To resolve the issue follow the steps bellow:

  1. Create backup of current psa database:

    "%plesk_dir%"\\MySQL\\bin>mysqldump -uadmin -p<plesk_admin_pass> -P8306 psa > C:\\psa_current.sql
  2. Drop current psa database:

    "%plesk_dir%"\\MySQL\\bin>mysql -uadmin -p<plesk_admin_pass> -P8306 psa -Ne"drop database psa;"
  3. Restore psa database from backup storage "%plesk_dir%"\MySQL\Backup

    "%plesk_dir%"\\MySQL\\bin>mysqldump -uadmin -p<plesk_admin_pass> -P8306 psa < "%plesk_dir%"\\MySQL\\Backup\\psa-20150710171500.sql
  4. Validate Plesk configuration by running plesk Reconfigurator utility:

    "%plesk_bin%"\\reconfigurator.exe
Have more questions? Submit a request
Please sign in to leave a comment.