Trying to get property of non-object while lauching web presence builder for one site

[adalfa]

Hello to all,

suddenly with no apparent reason, launching web presence builder (plesk panel 11.0.9) for a site that worked before we get an error during step 3 of the waiting image.

by enabling debug as of http://kb.parallels.com/en/114568 we get:

#0 /usr/local/sb/include/SB/Site/Serialization/Strategy/Ui.php(94): Base_SyntaxException::handleError(8, 'Trying to get p...', '/usr/local/sb/i...', 94, Array)
#1 /usr/local/sb/include/SB/Widget/Container/Abstract.php(470): SB_Site_Serialization_Strategy_Ui->serializeChildWidgets(Object(SB_Widget_Columns_Column), Array)
#2 /usr/local/sb/include/SB/Site/Serialization/Strategy/Ui.php(96): SB_Widget_Container_Abstract->serialize(Object(SB_Site_Serialization_Strategy_Ui))
#3 /usr/local/sb/include/SB/Widget/Container/Abstract.php(470): SB_Site_Serialization_Strategy_Ui->serializeChildWidgets(Object(SB_Widget_Columns), Array)
#4 /usr/local/sb/include/SB/Site/Serialization/Strategy/Ui.php(96): SB_Widget_Container_Abstract->serialize(Object(SB_Site_Serialization_Strategy_Ui))
#5 /usr/local/sb/include/SB/Widget/Container/Abstract.php(470): SB_Site_Serialization_Strategy_Ui->serializeChildWidgets(Object(SB_Widget_Container_Vertical), Array)
#6 /usr/local/sb/include/SB/Site/Serialization/Strategy/Ui.php(96): SB_Widget_Container_Abstract->serialize(Object(SB_Site_Serialization_Strategy_Ui))
#7 /usr/local/sb/include/SB/Widget/Container/Abstract.php(470): SB_Site_Serialization_Strategy_Ui->serializeChildWidgets(Object(SB_Widget_Container_Fixed), Array)
#8 /usr/local/sb/include/SB/Widget/Container/Fixed.php(108): SB_Widget_Container_Abstract->serialize(Object(SB_Site_Serialization_Strategy_Ui))
#9 /usr/local/sb/include/SB/ORM/SitePage.php(153): SB_Widget_Container_Fixed->serialize(Object(SB_Site_Serialization_Strategy_Ui))
#10 /usr/local/sb/include/SB/ORM/SitePage.php(162): SB_ORM_SitePage->serialize(Object(SB_Site_Serialization_Strategy_Ui))
#11 /usr/local/sb/include/SB/Facade/Service/Page.php(66): SB_ORM_SitePage->serialize(Object(SB_Site_Serialization_Strategy_Ui))
#12 [internal function]: SB_Facade_Service_Page->_read('8350f248-48e5-0...', 'szxwdqwv70n')
#13 /usr/local/sb/include/SB/Facade/Service.php(36): call_user_func_array(Array, Array)
#14 /usr/local/sb/include/SB/Facade/Service/Page.php(59): SB_Facade_Service->_execute('_read', Array)
#15 /usr/local/sb/include/SB/Facade/Service/Site.php(379): SB_Facade_Service_Page->read('8350f248-48e5-0...', 'szxwdqwv70n')
#16 [internal function]: SB_Facade_Service_Site->_getSettings('8350f248-48e5-0...')
#17 /usr/local/sb/include/SB/Facade/Service.php(36): call_user_func_array(Array, Array)
#18 /usr/local/sb/include/SB/Facade/Service/Site.php(372): SB_Facade_Service->_execute('_getSettings', Array)
#19 [internal function]: SB_Facade_Service_Site->getSettings('8350f248-48e5-0...')
#20 /usr/local/sb/include/SB/Controllers/JsonApi.php(518): call_user_func_array(Array, Array)
#21 /usr/local/sb/include/SB/Controllers/JsonApi.php(443): SB_Controllers_JsonApi->_processRequest(Array)
#22 /usr/local/psa/admin/plib/Zend/Controller/Action.php(513): SB_Controllers_JsonApi->defaultAction()
#23 /usr/local/psa/admin/plib/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('defaultAction')
#24 /usr/local/psa/admin/plib/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(SB_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#25 /usr/local/sb/include/SB/Application/Web.php(252): Zend_Controller_Front->dispatch()
#26 /usr/local/sb/htdocs/index.php(3): SB_Application_Web::run()
#27 {main}

with no message on /usr/local/psa/tmp/util_exec.log.
I followed http://kb.parallels.com/en/114873 but i do not have the same data missing on the database.
for a new site we have no problem at all.

is there anyone with any clue?
is there a way to trace the sql executed, since it seems a issue with the data?
is there a way to reset the site (without losing the snapshots)?

many thanks

andrea dal farra

 

[adalfa]

By enabling the general log in /etc/my.cnf we were able to see the specific query (sorry cannot attach); in the wrong case it seems that after reading page and widget from the site it suddenly stops working: the results are empty, but also in the good case.
by manually delete all the page (related to the problematic site) in the page table, we were able to enter the editor and restore the last snapshot. no problem so far.