Knowledge Base

Unable to log in to Plesk: Base table or view not found: 1146 Table ‘sitebuilder5.site’ doesn’t exist

Symptoms

When logging in to Plesk, the following error message is shown in a web-browser:

Server Error
500
SB_Facade_Exception_Generic
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sitebuilder5.site' doesn't exist, query was: DESCRIBE `site`

Cause

The Web Presence Builder database sitebuilder5 is empty or corrupted.

Resolution

Apply one of the following solutions:

Solution I: Restore the sitebuilder5 database from a backup

If you have a database dump of the sitebuilder5 database, restore it:

Connect to the Plesk server via RDP.
Restore the database dump of sitebuilder5:

C:> "%plesk_dir%Mysqlbinmysql.exe" -usitebuilder -p<password> -P3306 sitebuilder5 < C:pathtositebuilder5_dump

Note: The password is located in the %plesk_dir%sbconfig file. The path to the database backup should be adjusted.

Solution II: Remove the reference from the Plesk database

If there is no backup of sitebuilder5 database - remove references for sitebuilder5 database from psa database:

Connect to the Plesk server via RDP.
Create a backup of the Plesk database:

C:> plesk db dump psa > C:psa.sql
Remove the broken records from the Plesk database:

C:> plesk db "delete from dom_param where param='site_builder_site_id'"