Issue: Database Error when opening unread Xenforo alert for trophy with vaultwiki conditions

Issue Tools
- View Changes

February 5, 2017 10:41 AM

ACL

Regular Member

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

Issue Details

Issue Number 4904

Issue Type Bug

Project VaultWiki 4.x Series

Category User Alerts / Likes

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.16

Fixed Version 4.0.16

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)

February 5, 2017 10:55 AM
pegasus

VaultWiki Team
This was fixed on 2/1. There was a file missing from the ZIP. If you downloaded your ZIP before then, you need to 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
February 5, 2017 11:14 AM

ACL

Regular Member

I see, yes my copy of the ZIP was downloaded 31 Jan. Cheers.

Reply

+ Reply

All times are GMT -4. The time now is 4:43 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: Database Error when opening unread Xenforo alert for trophy with vaultwiki conditions

Issue Tools