Cannot open a site in Web Presence Builder: "Undefined property "controlPanelLink" in object "SB_ORM_TokenAccess"

Created:

2016-11-16 13:06:00 UTC

Modified:

2017-04-24 11:20:54 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Cannot open a site in Web Presence Builder: "Undefined property "controlPanelLink" in object "SB_ORM_TokenAccess"

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk Sitebuilder 4.5 for Linux
  • Web Presence Builder 12.0 for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Windows
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux
  • Web Presence Builder 11.5 for Linux

Symptoms

The following error occurs when attempting to open a site with Web Presence Builder:

Internal Presence Builder error.
File: /usr/local/sb/include/Base/ORM/Object.php; Line: 210
Message: Undefined property "controlPanelLink" in object "SB_ORM_TokenAccess".; Code: 0

Updates have already been installed according to Database of Web Presence Builder was not upgraded to version 11.5 , but the issue persists.

Cause

  1. Database inconsistency.

  2. The column control_panel_link is missing in the token_access table.

Resolution

1) Backup the sitebuilder5 database:

    #MYSQL_PWD=`cat /etc/psa/.psa.shadow`  mysqldump -uadmin sitebuilder5 > sitebuilder5dump.sql

2) Connect to the sitebuilder5 database and check the token_access table:

    #MYSQL_PWD=`cat /etc/psa/.psa.shadow` sitebuilder5


mysql> desc token_access;
+--------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| token_id | varchar(32) | YES | | | |
| site_id | int(11) | NO | | 0 | |
| is_authorized | int(11) | NO | | 0 | |
| creation_date | varchar(25) | YES | | | |
| locale_id | int(11) | NO | | 0 | |
| skin_code | varchar(255) | YES | | | |
| control_panel_link | varchar(255) | YES | | | |
| session_id | varchar(32) | YES | UNI | | |
| session_life_time | int(11) | NO | | 0 | |
| is_permanent | int(11) | NO | | 0 | |
+--------------------+--------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)

The column control_panel_link should exist in the table. This column has been in Web Presence Builder since version 11.5.

3) If the column is missing, add it manually in the table:

    mysql> ALTER TABLE `token_access` ADD `control_panel_link` VARCHAR( 255 ) NULL DEFAULT '' AFTER `skin_code`;

4) Also, this issue may occur when the Web Presence Builder database was not upgraded properly. To help with this, it is necessary to upgrade it using this script:

    /usr/local/psa/bin/sw-engine-pleskrun /usr/local/sb/utils/post_configure.php

Related Articles

Web Presence Builder fails to open: "Failed to update your site"

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