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


2016-11-16 13:24:36 UTC


2017-06-05 06:13:10 UTC


Was this article helpful?

Have more questions?

Submit a request

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

Applicable to:

  • Plesk 11.5 for Windows
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux
  • Web Presence Builder 11.5 for Linux
  • Plesk 12.5 for Windows


The following error is displayed when trying to access the Web Presence Builder, either after a clean installation or 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.


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


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

    Windows platform 64bit -- C:\\Program Files (x86)\\MySQL\\MySQL 5.1 Server\\my.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
  2. Restart MySQL service to apply changes

    Linux platform :

    /etc/init.d/mysqld restart

    Windows platform :

    > sc stop MySQL
    > sc start MySQL
  3. Recreate Parallels 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 :

    > "%plesk_dir%\\admin\\bin\\local_mysql_helper.exe" --create-database-and-user -database "sitebuilder5" -database-user "<DB_USER>" -database-user-password "<DB_USER_PASSWORD>"
    > "%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
    > "%plesk_dir%\\admin\\bin\\php.exe" -c "%plesk_dir%\\admin\\php.ini" -dauto_prepend_file="" "%plesk_dir%\\sb\\utils\\post_configure.php"
Have more questions? Submit a request
Please sign in to leave a comment.