Applicable to:
- Plesk for Linux
- Plesk for Windows
-
One of the following errors is displayed when trying to access the Web Presence Builder from Plesk either after a clean installation or after the upgrade from previous versions:
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
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
-
Disable MySQL strict mode by modifying the MySQL configuration file in any text editor, for example, in the vi text editor.
WithdrawSTRICT_TRANS_TABLESandSTRICT_ALL_TABLESfrom thesql-modeconfiguration 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
# systemctl restart mysql || systemctl restart mariadb || systemctl restart mysqld
-
Recreate Web Presence Builder database
-
For 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
-
For the 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
-
-
Connect to the server via RDP
-
Disable MySQL strict mode by modifying the MySQL configuration file:
-
Windows platform 32bit --
C:Program FilesMySQLMySQL 5.1 Servermy.ini -
Windows platform 64bit --
C:Program Files (x86)MySQLMySQL 5.1 Servermy.ini -
For modern Plesk installations --
%plesk_dir%MySQLmy.iniand%plesk_dir%DatabasesMySQLDatamy.ini
Withdraw
STRICT_TRANS_TABLESandSTRICT_ALL_TABLESfrom thesql-modeconfiguration directive or comment it out altogether:#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
-
-
Restart MySQL to apply changes:
C:> sc stop MySQL
sc start MySQLFor Modern Plesk installations use Plesk Services Monitor: select Plesk SQL Server and SQL server checkboxes, click on the Restart button.
-
Recreate Web Presence Builder database:
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"
