Search

Language:  
Search for:

Available article translations:

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

APPLIES TO:
  • Parallels Presence Builder 11.5
  • Parallels Plesk Panel 11.5 for Linux
  • Parallels Plesk Panel 11.5 for Windows

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"
    

Search words:

recreate database

MySQL strict mode

STRICT_ALL_TABLES

Base table or view not found

STRICT_TRANS_TABLES

database does not exists

Unknown column

A fatal error has occurred

Column not found




49af2da0f2dd4c81e962790bbbd0c2b4 5d735c0e028ee5b991e4fb80d34fb87f 5fc602d72ea565f353b9320e2ef62a1b 56797cefb1efc9130f7c48a7d1db0f0c e31a9debb6ab77383997c35d0dcf4649 bbe0373935bc886984e30ddeb0b46919 6d7d554563b7b77c7f8e8a903a4c0630 c7658ac2f68d6572a213687c1077afff 7c0c4de90795ba55552416733d7d5fed f36c5c36aad86685b6f729cd4414053c

FEEDBACK
Was this article helpful?
Tell us how we may improve it.
Yes No
 
 
 
 
 
 
Desktop Virtualization
- Parallels Desktop 8 for Mac
- Parallels Transporter
- Parallels Desktop Switch to Mac Edition
- Parallels Desktop for Mac Enterprise Edition
- Parallels Management-Mac for Microsoft SCCM
Server Virtualization
- Parallels Cloud Server
- Parallels Containers for Windows 6.0 Beta
- Parallels Virtuozzo Containers
Automation
- Parallels Automation
- Parallels Automation for Cloud Infrastructure
- Parallels Business Automation Standard
- Parallels Virtual Automation
- Parallels Plesk Panel Suite
- Web Presence Builder
- Parallels Plesk Automation
- Parallels Small Business Panel
- Value-added Services for Hosters
- Parallels Partner Storefront
Services & Resources
- Cloud Acceleration Services
- Professional Services
- Support Services
- Training & Certification