Article ID: 119283, created on Dec 24, 2013, last review on Aug 9, 2016

  • Applies to:
  • Plesk


I've recently upgraded Web Presence Builder (WPB) to version 11.5 or 12.0. Now WPB does not work correctly:

  1. The following error is shown when attempting to open a site in WPB:

    Table 'site' - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_changed_since_last_publication' in 'field list'


    Internal error: Undefined property "logoName"


    An internal Presence Builder error has occurred.
    Your website could not be upgraded. You can contact your hosting provider for assistance or start over and create a new site from scratch. If you choose to start over, all your website content will be lost.
  2. The following error is shown in sitebuilder.log:

    SB_Exception: Site version are not latest


A database sitebuilder5 was not properly upgraded to version 11.5:

    # rpm -q pp-sitebuilder
    # mysql -u%mysql_user% -p%mysql_password% sitebuilder5 -e"select * from config_param where name='version'"
    | id | config_section_id | name    | value   | in_backup |
    |  1 |                 1 | version | 11.0.10 |         0 |

The database upgrade log is stored in /usr/local/sb/tmp/upgrade.log. The following error may be found in the log (for example):

    2013-07-21T20:56:07+02:00       [EMERG]         Zend_Db_Statement_Exception: Table 'site_template' - SQLSTATE[23000]: Integrity constraint violation: 1062 
    Duplicate entry 'construction_company_new_m4jy1i0' for key 'code'


  1. Dump the existing WPB database:

    # mysqldump -u%mysql_user% -p%mysql_password% --skip-extended-insert sitebuilder5 > sitebuilder5.dump.`date +%F.%s`.sql
  2. Delete the problem record (shown in the upgrade log):

    mysql> delete from sitebuilder5.site_template where code='construction_company_new_m4jy1i0';
  3. Reinstall the base package of Web Presence Builder 11.5:

    # wget
     rpm -Uvh pp-sitebuilder-11.5.7-41714.13100419.noarch.rpm  --force
  4. For Web Presence Builder 12.0, reinstall the base package using:

    # wget
     rpm -Uvh wpb-core-12.0.5-43480.14051315.noarch.rpm --force

Alternative solution

  • Run the following command to restart the upgrade process in Plesk for Linux:

    ~# /usr/local/psa/bin/sw-engine-pleskrun /usr/local/sb/utils/upgrade.php
    ~# /usr/local/psa/bin/sw-engine-pleskrun /usr/local/sb/utils/post_configure.php
    ~# /usr/local/psa/admin/sbin/autoinstaller --select-release-current --reinstall-patch --install-component base
  • In Plesk for Windows:

    > %plesk_bin%\php.exe -d auto_prepend_file="" "%plesk_dir%\sb\utils\post_configure.php"
    > %plesk_bin%\php.exe -d auto_prepend_file="" "%plesk_dir%\admin\plib\scripts\upgrade-complete.php"
    > %plesk_bin%\ai.exe --select-product-id panel --select-release-current --reinstall-patch --install-component base

    Where %plesk_bin% and %plesk_dir% are pathes for Plesk installation directories.

  • For Web Presence Builder Standalone:

    ~# /usr/bin/sw-engine /usr/local/sb/utils/upgrade.php
    ~# /usr/bin/sw-engine /usr/local/sb/utils/post_configure.php

Search Words

Произошла внутренняя ошибка Parallels Presence Builder

Internal error: Undefined property "logoName"

Column not found: 1054 Unknown column 'is_changed_since_last_publication' in 'field list'

Произошла внутренняя ошибка Parallels Presence Builder.

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF