Articles in this section

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

Vincent Lauton
Updated
Plesk for Windows DoNotDelete:docref Plesk for Linux kb: technical ABT: Group B

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:

    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

    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

Plesk for Linux

  1. Connect to the server via SSH

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

  3. Restart MySQL service to apply changes

    # systemctl restart mysql || systemctl restart mariadb || systemctl restart mysqld

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

Plesk for Windows

  1. Connect to the server via RDP

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

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

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

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.