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.
-
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
andSTRICT_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” -
Restart MySQL service to apply changes
Linux platform :
# service mysqld restart
Windows platform :
C:> sc stop MySQL
sc start MySQL -
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”