Cannot configure a promotional footer: "Table 'sitebuilder5.promo_footer' doesn't exist"

Refers to:

  • Plesk 11.5 for Windows
  • Plesk 11.5 for Linux
  • Web Presence Builder 11.5 for Linux

Created:

2016-11-16 13:22:47 UTC

Modified:

2016-12-21 20:35:21 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Cannot configure a promotional footer: "Table 'sitebuilder5.promo_footer' doesn't exist"

Symptoms

The following error appears when I try the http request for promotional footer:

"{"error":{"message":"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sitebuilder5.promo_footer' doesn't exist"}}"

Cause

It's by design that table " promo_footer " was added into database of Parallels Web Presence Builder since version 11.5.

It's missing because one of the following reasons:

  1. installation of Parallels Web Presence Builder 11.5 Standalone was not completed;
  2. upgrading from previous version was not completed. Here are up-to-date version of the packages and the database:

    ~# rpm -qa | grep sitebuilder 
    pp-sitebuilder-skins-11.5.8-41849.13102415.noarch
    pp-sitebuilder-11.5.8-41849.13102415.noarch
    pp-sitebuilder-default-templates-11.5.8-41849.13102415.noarch
    ~#
    ~# 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.5.8 | 0 |
    +----+-------------------+---------+--------+-----------+
    ~#

    Upgrading was not complete if packages have version 11.5.8 but version of the database does not match.

Resolution

  1. Verify installation of Parallels Web Presence Builder 11.5 Standalone according to this KB .

  2. Complete upgrading using " Alternative solution " from this KB .

Additional information

Cannot open sites in Web Presence Builder: Undefined property "localeCode"

Windows: Parallels Web Presence Builder 11.5 does not work after upgrade: "An internal Parallels Presence Builder error has occurred"

Have more questions? Submit a request
Please sign in to leave a comment.