xf.php:173

Issue Tools
- View Changes

March 15, 2017 3:26 PM

Alfa1

Distinguished Member

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) {
  }
}

Issue Details

Issue Number 4954

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.17

Fixed Version 4.0.17

Milestone (none)

Software DependencyXenForo 1.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

March 16, 2017 9:22 AM
pegasus

VaultWiki Team
It looks like the fix for this appeared on a duplicate head on the branch and was not automatically merged by our VCS back into 4.0.17. I've merged the duplicate head manually and will release it as build 002. Users who had fresh installations using 4.0.17 build 001 should run the following MySQL query:

Code:

ALTER TABLE vw_usercount ADD COLUMN vw_lastalerttime INT(10) UNSIGNED NOT NULL DEFAULT '0', ADD INDEX vw_lastalerttime (vw_lastalerttime)
Reply

+ Reply

All times are GMT -4. The time now is 4:52 PM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Unknown column 'vw_lastalerttime' in 'field list' - vault/core/controller/db/xf.php:173

Issue Tools