Can't login to magento cms SQLSTATE[42S22]:?

Question

Magento

Hello, I need help, after the weekend I can’t get into the magento admin panel, the whole site works, but the admin panel doesn’t, error text

There has been an error processing your request
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.assert_id' in 'on clause'
Trace:
#0 ***/lib/Varien/Db/Statement/Pdo/Mysql. php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 ***/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 ***/lib/ Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 ***/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `r`.*, `...', Array)
#4 ***/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `r`.*, `...', Array)
#5 ***/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 ***/app/code/core/Mage/Admin/Model /Resource/Acl.php(81): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select))
#7 ***/app/code/core/Mage/Admin/Model/Session.php(127): Mage_Admin_Model_Resource_Acl->loadAcl( )
#8 ***/app/code/core/Mage/Admin/Model/Observer.php(73): Mage_Admin_Model_Session->login('alex', 'alex123456', Object(Mage_Core_Controller_Request_Http))
#9 ***/ app/code/core/Mage/Core/Model/App.php(1338): Mage_Admin_Model_Observer->actionPreDispatchAdmin(Object(Varien_Event_Observer))
#10 ***/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Admin_Model_Observer), 'actionPreDispat...', Object(Varien_Event_Observer))
#11 * **/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent('controller_acti...', Array)
#12 ***/app/code/core/Mage/Core/Controller/Varien/Action.php( 527): Mage::dispatchEvent('controller_acti...', Array)
#13 ***/app/code/core/Mage/Adminhtml/Controller/Action.php(160): Mage_Core_Controller_Varien_Action->preDispatch()
#14 ***/app/code/core/Mage/Core/Controller/Varien/Action.php(407): Mage_Adminhtml_Controller_Action->preDispatch()
#15 ***/app/code/core/Mage/Core/Controller/Varien /Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('index')
#16 ***/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17 ***/app/code/core/Mage /Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#18 ***/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#19 ***/index.php( 87): Mage::run('', 'store')
#20 {main}

in what there can be problems or at least in what party to dig?
vps rebooted, cleared the cache, created the 'a.assert_id' table in the database, the site backup for the 29th is also not working

Answer 1

How did it happen that the field was missing in the database schema? :)

Answer 2

I figured it out, maybe it will come in handy for someone, in the admin_assert table it was necessary to add the assert_id and type field