Issue: Unknown column 'v.vw_extra' in 'field list'

Issue Tools
- View Changes

November 5, 2015 1:22 PM

Alfa1

Distinguished Member

Unknown column 'v.vw_extra' in 'field list'

Upgrade to 4.0.7 on XF:

Code:

Updating data in table: xf_bb_code
An exception occurred: Database Error: UPDATE `xf_bb_code` `x` LEFT JOIN `vw_bbcode` `v` ON (`x`.`vw_varname` = `v`.`varname`) SET `x`.`vw_extra` = `v`.`vw_extra` WHERE `v`.`varname` IS NOT NULL Mysqli statement execute error : Unknown column 'v.vw_extra' in 'field list' in /vault/core/controller/db/xf.php on line 171
1.	vw_DB_Controller_XF->throw_error() in vault/core/controller/db/xf.php at line 157
2.	vw_DB_Controller_XF->query_write() in vault/core/model/db/mysql/vw.php at line 951
3.	vw_DB_MySQL_Model->shutdown_or_run() in vault/core/model/db/mysql/vw.php at line 720
4.	vw_DB_MySQL_Model->update() in vault/core/controller/install/upgradepath/steps/4/0/7/XF130/xf.php at line 95
5.	vw_Install_UpgradePath_Steps_407_XF130_Controller_XF->{closure}() in vault/core/controller/install/upgradepath/vw.php at line 63
6.	vw_Install_UpgradePath_Controller->call() in vault/core/controller/cp/install/vw.php at line 361
7.	vw_CP_Install_Controller->exec_step() in vault/core/controller/cp/install/vw.php at line 326
8.	vw_CP_Install_Controller->upgrade_type() in vault/core/controller/cp/install/vw.php at line 263
9.	vw_CP_Install_Controller->upgrade() in vault/core/controller/cp/install/vw.php at line 59
10.	vw_CP_Install_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 113
11.	vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 170
12.	vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in library/XenForo/FrontController.php at line 351
13.	XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
14.	XenForo_FrontController->run() in admin.php at line 13

Issue Details

Issue Number 4413

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.7

Fixed Version 4.0.7

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)

November 5, 2015 3:46 PM
pegasus

VaultWiki Team
I think this error occurs only if you skipped the previous version 4.0.6 and are upgrading from 4.0.5 or earlier to 4.0.7.

I am working on a way to handle this case, but for now, you can continue by manually running this query:

Code:

ALTER TABLE vw_bbcode ADD vw_extra TEXT NULL
Reply
November 5, 2015 3:57 PM

pegasus

VaultWiki Team

Fixed in build 002.

Reply

+ Reply

All times are GMT -4. The time now is 4:22 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 'v.vw_extra' in 'field list'

Issue Tools