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}
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.
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
Thank you for posting your solution. I'm sure it will help other clients.