Unknown column 'vw_lastalerttime' in 'field list' - vault/core/controller/db/xf.php:173
Right after install of 4.0.17 on my site, no admincp options work and this error is caused:
Code:
Error Info
XenForo_Exception: Database Error: UPDATE `vw_usercount` SET `vw_lastalerttime` = 1489605504 WHERE userid = 28132 LIMIT 1 Mysqli prepare error: Unknown column 'vw_lastalerttime' in 'field list' - vault/core/controller/db/xf.php:173
Generated By: staples, 3 minutes ago
Stack Trace
#0 /vault/core/controller/db/xf.php(157): vw_DB_Controller_XF->throw_error(Object(Zend_Db_Statement_Mysqli_Exception), 'UPDATE `vw_use...')
#1 /vault/core/model/db/mysql/vw.php(1105): vw_DB_Controller_XF->query_write('UPDATE `vw_use...')
#2 /vault/core/model/db/mysql/vw.php(768): vw_DB_MySQL_Model->shutdown_or_run('UPDATE `vw_use...', false)
#3 /library/vw/XenForo/Model/Alert.php(257): vw_DB_MySQL_Model->update(Array)
#4 /library/XenForo/ControllerPublic/Account.php(79): vw_XenForo_Model_Alert->markAllAlertsReadForUser(28132)
#5 /library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Account->actionAlertsPopup()
#6 /library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#7 /index.php(13): XenForo_FrontController->run()
#8 {main}
Request State
array(3) {
["url"] => string(180) "https://forum.com/account/alerts-popup?&_xfRequestUri=%2Fforums%2F&_xfNoRedirect=1&_xfToken=28132%2C1489605492%2C7e200b664af1da2b50d25b6b74c2056969577a71&_xfResponseType=json"
["_GET"] => array(4) {
["_xfRequestUri"] => string(8) "/forums/"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(57) "28132,1489605492,7e200b664af1da2b50d25b6b74c2056969577a71"
["_xfResponseType"] => string(4) "json"
}
["_POST"] => array(0) {
}
}