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

Refers 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

Created:

2016-11-16 13:24:36 UTC

Modified:

2016-12-21 20:39:12 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Error while accessing Parallels 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:

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

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

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
    sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  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.