Articles in this section

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

Plesk for Windows kb: technical

Applicable to:

  • Plesk for Windows

Symptoms

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

PLESK_INFO: 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:

  1. Connect to the Plesk server via RDP.

  2. Restore the database dump of sitebuilder5:

    C:\> "%plesk_dir%\Mysql\bin\mysql.exe" -usitebuilder -p<password> -P3306 sitebuilder5 < C:\path\to\sitebuilder5_dump

    Note: The password is located in the %plesk_dir%sb\config 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:

  1. Connect to the Plesk server via RDP.

  2. Create a backup of the Plesk database:

    C:\> plesk db dump psa > C:\psa.sql

  3. Remove the broken records from the Plesk database:

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

 

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.