Issue: Error Message after upgrading to 4.18b3

Issue Tools
- View Changes

July 21, 2017 9:28 PM

dvsDave

Regular Member

Error Message after upgrading to 4.18b3

Mysqli prepare error: Unknown column 'loghash' in 'where clause'

Delete the /lib folder, then go to the Wiki Admin panel and get the following error:

Code:

Database Error: SELECT * FROM `vw_log` WHERE logtype = 'fsremove' AND loghash = '4.0.18' Mysqli prepare error: Unknown column 'loghash' in 'where clause'

vw_DB_Controller_XF->throw_error() in /home/nginx/domains/controlbooth.com/public/vault/core/controller/db/xf.php at line 268
vw_DB_Controller_XF->query_first() in /home/nginx/domains/controlbooth.com/public/vault/core/model/db/mysql/vw.php at line 27
vw_DB_MySQL_Model->select() in /home/nginx/domains/controlbooth.com/public/vault/core/controller/cp/vw.php at line 199
vw_CP_Controller->removed_file_check() in vw/XenForo/ControllerAdmin/Wiki.php at line 146
vw_XenForo_ControllerAdmin_Wiki->assert_permission() in vw/XenForo/ControllerAdmin/Wiki.php at line 114
vw_XenForo_ControllerAdmin_Wiki->actionIndex() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/nginx/domains/controlbooth.com/public/admin.php at line 13

Issue Details

Issue Number 5180

Issue Type Bug

Project VaultWiki 4.x Series

Category Admin Panel

Status Not a Bug

Priority 2 - Fatal / Database Errors

Affected Version 4.0.18

Fixed Version (none)

Milestone (none)

Software DependencyvBulletin 4.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

July 22, 2017 9:45 AM
pegasus

VaultWiki Team
This tells me that step 1 when upgrading from 4.0.0 Beta 6 to 4.0.0 Beta 7 (October 2013) was never completed. This is probably due to this old bug (resolved February 2016): https://www.vaultwiki.org/issues/4489/
And will not be treated as a new bug. This report is treated as leftover damage from that bug, which must now be cleaned up.

Run the following MySQL query:

Code:

ALTER TABLE vw_log ADD COLUMN loghash VARCHAR(32) NOT NULL DEFAULT '', DROP PRIMARY KEY, ADD PRIMARY KEY (logtype, dateline, loghash)
Reply
July 22, 2017 11:31 AM

dvsDave

Regular Member

That solved it! Thanks.

Reply

+ Reply

All times are GMT -4. The time now is 6:26 AM.

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: Error Message after upgrading to 4.18b3

Issue Tools