Database Error when opening unread Xenforo alert for trophy with vaultwiki conditions
Unknown column 'vw_lastalerttime' in 'field list'
I have configured two trophies that are awarded based on VaultWiki contributions however when attempting to read the associated alert for the first time a Database Error is displayed showing. I haven't received any other alerts (trophy related or not) so I cannot provide more details about this at this time - this is a development Xenforo forum installation without any threads/posts or other accounts (except ID 1 admin account) to simplify Xenforo's import process later which means alerts are next to non-existent.
Error:
Code:
XenForo_Exception: Database Error: UPDATE `vw_usercount` SET `vw_lastalerttime` = 1486308086 WHERE userid = 1 LIMIT 1 Mysqli prepare error: Unknown column 'vw_lastalerttime' in 'field list' - vault/core/controller/db/xf.php:173
Stack Trace
Code:
#0 /home/user/public_html/vault/core/controller/db/xf.php(157): vw_DB_Controller_XF->throw_error(Object(Zend_Db_Statement_Mysqli_Exception), 'UPDATE `vw_use...')
#1 /home/user/public_html/vault/core/model/db/mysql/vw.php(1105): vw_DB_Controller_XF->query_write('UPDATE `vw_use...')
#2 /home/user/public_html/vault/core/model/db/mysql/vw.php(768): vw_DB_MySQL_Model->shutdown_or_run('UPDATE `vw_use...', false)
#3 /home/user/public_html/library/vw/XenForo/Model/Alert.php(248): vw_DB_MySQL_Model->update(Array)
#4 /home/user/public_html/library/XenForo/ControllerPublic/Account.php(79): vw_XenForo_Model_Alert->markAllAlertsReadForUser(1)
#5 /home/user/public_html/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Account->actionAlertsPopup()
#6 /home/user/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#7 /home/user/public_html/index.php(13): XenForo_FrontController->run()
#8 {main}
Request State
Code:
array(3) {
["url"] => string(191) "https://path/to/account/alerts-popup?&_xfRequestUri=%2Fwiki%2F&_xfNoRedirect=1&_xfToken=1%2C1486305699%2Cc80ac4883c15a9bd19f3d50a71b3a0e6b33525c7&_xfResponseType=json"
["_GET"] => array(4) {
["_xfRequestUri"] => string(6) "/wiki/"
["_xfNoRedirect"] => string(1) "1"
["_xfToken"] => string(53) "1,1486305699,c80ac4883c15a9bd19f3d50a71b3a0e6b33525c7"
["_xfResponseType"] => string(4) "json"
}
["_POST"] => array(0) {
}
}