Error while accessing Web Presence Builder: Base table or view not found

Symptoms

The following error is displayed when trying to access the Web Presence Builder, either after a clean installation or upgrade from previous versions:

PLESK_INFO: Message SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘sitebuilder5.site_version’ doesn’t exist
File Generic.php
Line 32
Type SB_Facade_Exception_Generic

or

PLESK_INFO: A fatal error has occurred
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘share_parents’ in ‘field list’
Details have been logged for the administrator.

Cause

Web Presence Builder database was not created during an installation or upgrade procedure because the MySQL strict mode is enabled.

Resolution

Connect to the server via SSH/RDP and disable strict mode in MySQL and recreate the Web Presence Builder database.

1. Edit MySQL configuration file

   Linux platform — /etc/mysql/my.cnf

   Windows platform 32bit — C:Program FilesMySQLMySQL 5.1 Servermy.ini

   Windows platform 64bit — C:Program Files (x86)MySQLMySQL 5.1 Servermy.ini

   Withdraw STRICT_TRANS_TABLES and STRICT_ALL_TABLES from the sql-mode configuration directive or comment it out altogether:

   # cat /etc/mysql/my.cnf|grep sql-mode
   sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

2. Restart MySQL service to apply changes

   Linux platform :

   # service mysqld restart

   Windows platform :

   C:> sc stop MySQL
   sc start MySQL

3. Recreate Web Presence Builder database

   Linux platform clean installation:

   # /usr/local/psa/bin/sw-engine-pleskrun /usr/local/sb/utils/configure.php –init_db –merge_config –db_admin_name=admin –db_admin_passwd=`cat /etc/psa/.psa.shadow` –sb_db_user_passwd=<random_password>

   # /usr/local/psa/bin/sw-engine-pleskrun /usr/local/sb/utils/post_configure.php

   Linux platform after upgrade from previous version:

   # /usr/local/psa/bin/sw-engine-pleskrun /usr/local/sb/utils/configure.php –init_db –merge_config –db_admin_name=admin –db_admin_passwd=`cat /etc/psa/.psa.shadow`

   # /usr/local/psa/bin/sw-engine-pleskrun /usr/local/sb/utils/post_configure.php

   Windows platform :

   C:> “%plesk_dir%adminbinlocal_mysql_helper.exe” –create-database-and-user -database “sitebuilder5” -database-user “<DB_USER>” -database-user-password “<DB_USER_PASSWORD>”

   C:> “%plesk_dir%adminbinphp.exe” -c “%plesk_dir%adminphp.ini” -dauto_prepend_file=”” “%plesk_dir%sbutilsconfigure.php” –init_db –skip_database_creation –merge_config

   C:> “%plesk_dir%adminbinphp.exe” -c “%plesk_dir%adminphp.ini” -dauto_prepend_file=”” “%plesk_dir%sbutilspost_configure.php”