Search

Language:  
Search for:

Available article translations:

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

Article ID: 112453, created on Oct 5, 2011, last review on May 11, 2014

APPLIES TO:
  • Web Presence Builder 11.5
  • Plesk 11.5 for Linux
  • Plesk 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




a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 85a92ca67f2200d36506862eaa6ed6b8 56797cefb1efc9130f7c48a7d1db0f0c 46a8e394d6fa13134808921036a34da8 bd7fc88cf1b01f097749ae6f87272128 01bc4c8cf5b7f01f815a7ada004154a2 0a53c5a9ca65a74d37ef5c5eaeb55d7f 18f5eb2d7a7972323627b40f015d5a19 9305481d3bd31663b68451e3bfdec5a5

FEEDBACK
Was this article helpful?
Tell us how we may improve it.
Yes No
 
 
 
 
 
 
Server Virtualization
- Odin Cloud Server
- Odin Containers for Windows 6.0
- Odin Virtuozzo Containers
Automation
- Odin Automation
- Odin Automation for Cloud Infrastructure
- Odin Business Automation Standard
- Odin Virtual Automation
- Odin Plesk Panel Suite
- Web Presence Builder
- Odin Plesk Automation
- Odin Small Business Panel
- Value-added Services for Hosters
- Odin Partner Storefront
Services & Resources
- Cloud Acceleration Services
- Professional Services
- Support Services
- Training & Certification