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

Created:

2016-11-16 13:22:47 UTC

Modified:

2017-04-24 11:17:12 UTC

0

Was this article helpful?


Have more questions?

Submit a request

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

Applicable to:

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

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

Complete upgrading using the 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.