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

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.
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"

Restart MySQL service to apply changes

# service mysql restart || service mariadb restart || service mysqld restart

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 Files\MySQL\MySQL 5.1 Server\my.ini

• Windows platform 64bit -- C:\Program Files (x86)\MySQL\MySQL 5.1 Server\my.ini

• For modern Plesk installations -- %plesk_dir%MySQL\my.ini and %plesk_dir%Databases\MySQL\Data\my.ini

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

CONFIG_TEXT: #sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Restart MySQL to apply changes:

C:\> sc stop MySQL
sc start MySQL

For 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%\admin\bin\local_mysql_helper.exe" --create-database-and-user -database "sitebuilder5" -database-user "<DB_USER>" -database-user-password "<DB_USER_PASSWORD>"

C:\> "%plesk_dir%\admin\bin\php.exe" -c "%plesk_dir%\admin\php.ini" -dauto_prepend_file="" "%plesk_dir%\sb\utils\configure.php" --init_db --skip_database_creation --merge_config

C:\> "%plesk_dir%\admin\bin\php.exe" -c "%plesk_dir%\admin\php.ini" -dauto_prepend_file="" "%plesk_dir%\sb\utils\post_configure.php"