Unable to open site in a Webpresence Builder

Created:

2016-11-16 13:10:59 UTC

Modified:

2017-04-24 11:55:24 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to open site in a Webpresence Builder

Applicable to:

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

Symptoms

Unable to open site in Webpresence Builder, the following error displayed

PHP Notice : Trying to get property of non-object
Stack trace:
#0 /usr/local/sb/include/Base/SyntaxException.php(51): Base_SyntaxException::handleError()
#1 /usr/local/sb/include/SB/ORM/SitePage.php(156): Base_SyntaxException::handleError(8, 'Trying to get p...', '/usr/local/sb/i...', 156, Array)
#2 /usr/local/sb/include/SB/Facade/Service/Page.php(62): SB_ORM_SitePage->serialize()
#3 /usr/local/sb/include/SB/Facade/ServiceWrapper.php(52): SB_Facade_Service_Page->read('e4481775-9fb3-9...', 'szxwdqwv70n')
#4 /usr/local/sb/include/SB/Facade/Service/Site.php(329): SB_Facade_ServiceWrapper->__call('read', Array)
#5 /usr/local/sb/include/SB/Facade/ServiceWrapper.php(52): SB_Facade_Service_Site->getSettings('e4481775-9fb3-9...')
#6 [internal function]: SB_Facade_ServiceWrapper->__call('getSettings', Array)

Cause

Database inconsistency

Resolution

  1. Find ' id ' of affected site:

    mysql> select id, target_url from sitebuilder5.site_publish_settings where url like '%domain.tld%'\\G
    *************************** 1. row ***************************
    id: 2441
    target_url: ftp://user726:%24AES-128-CBC%24oSdfE43uLp97m7bngmnCqBw%3D%3D%24MYYnM8BebEYgbi57g%2BGiFaFqaSq%2BsW6AAzu8bD9TKyI%3D@10.140.12.242/www/domain.tld
    1 row in set (0.00 sec)
  2. Find in ' site ' table ' site_page_id ' by using id from step #1:

    mysql> select site_page_id from sitebuilder5.site where site_publish_settings_id=2441;
    +--------------+
    | site_page_id |
    +--------------+
    | 58932 |
    +--------------+
    1 row in set (0.00 sec)
  3. Find ' widget_id ' from ' site_page ' table by using ' site_page_id ' from step #2:

    mysql> select widget_id from sitebuilder5.site_page where id=58932;
    +-----------+
    | widget_id |
    +-----------+
    | 756081 |
    +-----------+
    1 row in set (0.00 sec)
  4. Ensure that ' widget ' table does not contain ' widget_id ' from the step #3:

    mysql> select * from sitebuilder5.widget where id=756081;
    Empty set (0.00 sec);
  5. Add required record in ' widget ' table

Note: You you may use this tool to generate UUID , however you have to check that this ' uuid ' is not present in the ' widget ' table.

mysql> insert into sitebuilder5.widget values (756081, '4c854c58-feab-4d50-139a-c0c1c65f6a78', 1);
Query OK, 1 row affected (0.00 sec)
Have more questions? Submit a request
Please sign in to leave a comment.