Cannot edit website: "Internal Parallels Presence Builder error"

Refers to:

  • Plesk 11.5 for Windows

Created:

2016-11-16 12:59:31 UTC

Modified:

2016-12-21 19:42:33 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Cannot edit website: "Internal Parallels Presence Builder error"

Symptoms

After upgrading Parallels Plesk Panel to version 11.5 sites cannot be opened in Parallels Web Presence Builder.The following error appears when try to open any site in Wizard ( Home > Subscriptions > DOMAIN.TLD > Websites & Domains > Presence Builder > Edit Website ):

Internal Parallels Presence Builder error.
File: C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\externals\\Zend\\Db\\Statement\\Pdo.php; Line: 234
Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sitebuilder5.trial_message' doesn't exist; Code: 42

or

Internal Parallels Presence Builder error.
File: D:\\Program Files (x86)\\Parallels\\Plesk\\admin\\externals\\Zend\\Db\\Statement\\Pdo.php; Line: 234
Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'site_id' in 'where clause'; Code: 4

Cause

Sitebuilder database was not upgraded to version 11.5 completely.

mysql> select * from sitebuilder5.config_param;
+----+-------------------+----------+------------+-----------+
| id | config_section_id | name | value | in_backup |
+----+-------------------+----------+------------+-----------+
| 1 | 1 | version | 11.0.10 | 0 |

Resolution

Run upgrade manually:

[PLESK_INSTALLDIR]\\admin\\bin\\php.exe -d auto_prepend_file="[PLESK_INSTALLDIR]\\admin\\plib\\scripts\\upgrade-complete.php"

For example:

C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin>php.exe -d auto_prepend_file="C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\plib\\scripts\\upgrade-complete.php"
Have more questions? Submit a request
Please sign in to leave a comment.