latest Socialnetworking.solutions Blog Plugin error

    • 78 posts
    March 16, 2021 1:50 PM EDT

    Just recently upgraded to module-sesblog-5.4.1p1 and module-sesbasic-5.4.1 and got the following errors in the log. Plus, blog browsing page not showing no blogs

    2021-03-16T17:40:33+00:00 CRIT (2): Zend_Db_Adapter_Mysqli_Exception: Table 'xxxx.engine4_sesblogpackage_orderspackages' doesn't exist in /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Db/Adapter/Mysqli.php:204
    Stack trace:
    #0 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Db/Table/Abstract.php(836): Zend_Db_Adapter_Mysqli->describeTable('engine4_sesblog...', NULL)
    #1 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Db/Table/Abstract.php(875): Zend_Db_Table_Abstract->_setupMetadata()
    #2 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Db/Table/Abstract.php(983): Zend_Db_Table_Abstract->_setupPrimaryKey()
    #3 /var/www/vhosts/xxxx/httpdocs/application/modules/Sesblog/Model/DbTable/Blogs.php(182): Zend_Db_Table_Abstract->info('name')
    #4 /var/www/vhosts/xxxx/httpdocs/application/modules/Sesblog/Model/DbTable/Blogs.php(31): Sesblog_Model_DbTable_Blogs->getSesblogsSelect(Array, Array)
    #5 /var/www/vhosts/xxxx/httpdocs/application/modules/Sesblog/widgets/related-blogs/Controller.php(59): Sesblog_Model_DbTable_Blogs->getSesblogsPaginator(Array)
    #6 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Widget/Abstract.php(254): Sesblog_Widget_RelatedBlogsController->indexAction()
    #7 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Element/Widget.php(73): Engine_Content_Widget_Abstract->render('index')
    #8 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Element/Abstract.php(583): Engine_Content_Element_Widget->_render()
    #9 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Decorator/Children.php(31): Engine_Content_Element_Abstract->render()
    #10 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Element/Abstract.php(594): Engine_Content_Decorator_Children->render('')
    #11 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Decorator/Children.php(31): Engine_Content_Element_Abstract->render()
    #12 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Element/Abstract.php(594): Engine_Content_Decorator_Children->render('')
    #13 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Decorator/Children.php(31): Engine_Content_Element_Abstract->render()
    #14 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Element/Abstract.php(594): Engine_Content_Decorator_Children->render('')
    #15 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content.php(219): Engine_Content_Element_Abstract->render()
    #16 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Controller/Action/Helper/Content.php(136): Engine_Content->render('sesblog_index_v...')
    #17 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Controller/Action/Helper/Content.php(38): Engine_Content_Controller_Action_Helper_Content->render()
    #18 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Controller/Action/HelperBroker.php(277): Engine_Content_Controller_Action_Helper_Content->postDispatch()
    #19 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch()
    #20 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('viewAction')
    #21 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
    #22 /var/www/vhosts/xxxx/httpdocs/application/modules/Core/Bootstrap.php(86): Zend_Controller_Front->dispatch()
    #23 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Application.php(160): Core_Bootstrap->run()
    #24 /var/www/vhosts/xxxx/httpdocs/application/index.php(224): Engine_Application->run()
    #25 /var/www/vhosts/xxxx/httpdocs/boot.php(47): include('/var/www/vhosts...')
    #26 /var/www/vhosts/xxxx/httpdocs/index.php(24): Engine_Boot->boot()
    #27 {main}
    
    2021-03-16T17:40:33+00:00 CRIT (2): Zend_Db_Table_Row_Exception: Specified column "package_id" is not in the row in /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Db/Table/Row/Abstract.php:179
    Stack trace:
    #0 /var/www/vhosts/xxxx/httpdocs/application/modules/Sesblog/Model/Blog.php(297): Zend_Db_Table_Row_Abstract->__get('package_id')
    #1 /var/www/vhosts/xxxx/httpdocs/application/modules/Sesblog/widgets/blog-reviews/Controller.php(41): Sesblog_Model_Blog->getPackage()
    #2 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Widget/Abstract.php(254): Sesblog_Widget_BlogReviewsController->indexAction()
    #3 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Element/Widget.php(73): Engine_Content_Widget_Abstract->render('index')
    #4 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Element/Abstract.php(583): Engine_Content_Element_Widget->_render()
    #5 /var/www/vhosts/xxxx/httpdocs/application/modules/Core/widgets/container-tabs/Controller.php(56): Engine_Content_Element_Abstract->render()
    #6 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Widget/Abstract.php(254): Core_Widget_ContainerTabsController->indexAction()
    #7 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Element/Widget.php(73): Engine_Content_Widget_Abstract->render('index')
    #8 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Element/Abstract.php(583): Engine_Content_Element_Widget->_render()
    #9 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Decorator/Children.php(31): Engine_Content_Element_Abstract->render()
    #10 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Element/Abstract.php(594): Engine_Content_Decorator_Children->render('')
    #11 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Decorator/Children.php(31): Engine_Content_Element_Abstract->render()
    #12 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Element/Abstract.php(594): Engine_Content_Decorator_Children->render('')
    #13 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Decorator/Children.php(31): Engine_Content_Element_Abstract->render()
    #14 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Element/Abstract.php(594): Engine_Content_Decorator_Children->render('')
    #15 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content.php(219): Engine_Content_Element_Abstract->render()
    #16 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Controller/Action/Helper/Content.php(136): Engine_Content->render('sesblog_index_v...')
    #17 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Content/Controller/Action/Helper/Content.php(38): Engine_Content_Controller_Action_Helper_Content->render()
    #18 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Controller/Action/HelperBroker.php(277): Engine_Content_Controller_Action_Helper_Content->postDispatch()
    #19 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch()
    #20 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('viewAction')
    #21 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
    #22 /var/www/vhosts/xxxx/httpdocs/application/modules/Core/Bootstrap.php(86): Zend_Controller_Front->dispatch()
    #23 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Application.php(160): Core_Bootstrap->run()
    #24 /var/www/vhosts/xxxx/httpdocs/application/index.php(224): Engine_Application->run()
    #25 /var/www/vhosts/xxxx/httpdocs/boot.php(47): include('/var/www/vhosts...')
    #26 /var/www/vhosts/xxxx/httpdocs/index.php(24): Engine_Boot->boot()
    #27 {main}

    When adding new blog, error

     

    Zend_Db_Adapter_Mysqli_Exception: Table 'xxxx.engine4_sesblogpackage_packages' doesn't exist in /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Db/Adapter/Mysqli.php:204
    Stack trace:
    #0 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Db/Table/Abstract.php(836): Zend_Db_Adapter_Mysqli->describeTable('engine4_sesblog...', NULL)
    #1 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Db/Table/Abstract.php(875): Zend_Db_Table_Abstract->_setupMetadata()
    #2 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Db/Table/Abstract.php(1290): Zend_Db_Table_Abstract->_setupPrimaryKey()
    #3 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Api.php(308): Zend_Db_Table_Abstract->find(0)
    #4 /var/www/vhosts/xxxx/httpdocs/application/modules/Sesblog/controllers/IndexController.php(577): Engine_Api->getItem('sesblogpackage_...', 0)
    #5 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Controller/Action.php(516): Sesblog_IndexController->createAction()
    #6 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('createAction')
    #7 /var/www/vhosts/xxxx/httpdocs/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
    #8 /var/www/vhosts/xxxx/httpdocs/application/modules/Core/Bootstrap.php(86): Zend_Controller_Front->dispatch()
    #9 /var/www/vhosts/xxxx/httpdocs/application/libraries/Engine/Application.php(160): Core_Bootstrap->run()
    #10 /var/www/vhosts/xxxx/httpdocs/application/index.php(224): Engine_Application->run()
    #11 /var/www/vhosts/xxxx/httpdocs/boot.php(47): include('/var/www/vhosts...')
    #12 /var/www/vhosts/xxxx/httpdocs/index.php(24): Engine_Boot->boot()
    #13 {main}
    • Moderator
    • 6886 posts
    March 17, 2021 5:32 AM EDT

    Have you sent this to them? One thing to check as many hosting companies are updating their servers to use MariaDB without letting clients know - make sure your db hasn't changed as SEPHP does not yet support MariaDB.

    • 78 posts
    March 18, 2021 4:19 PM EDT

    I figured out what that error occured

    With this latest version I believe they have included this new "package extension" to the blog seen here

    So automatically that extension is enabled after upgraded but not necessarily mean the extension has been properly installed or database tables were added. Therefore, the script see that the extension is enabled but cannot find the tables information hence, i got those error above. It's solved after I disabled the extension.

    I hope that they have mentioned this somewhere with new releases and proper change logs so we know what's going. Unless there is a change logs that I missed

     


    This post was edited by Donna at March 19, 2021 5:05 AM EDT
    • Moderator
    • 6886 posts
    March 19, 2021 5:04 AM EDT

    Thank you for posting your solution. I'm sure it will help other clients.