Issue: "Unknown column 'vw_options' in 'field list'"

Issue Tools
- View Changes

March 15, 2013 4:12 PM
Dark Pulse

New Member
"Unknown column 'vw_options' in 'field list'"

Attempting a clean install...

Just purchased VaultWiki and am attempting to do an install of 4.0.0 Alpha 1 on vBulletin 4.2.0, but it showstops on Step 3 while trying to edit the BBCode table.

Code:

Step 3 Adding data to table: bbcode Warning: mysqli_query(): (42S22/1054): Unknown column 'vw_options' in 'field list' in [path]/includes/class_core.php on line 1391[/QUOTE]

It is slightly (ever so slightly) possible that this is related to a just-fixed bug. Specifically, this one, as I think my forum uses no Prefix stuff.

Issue Details

Issue Number 2956

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 Alpha 1 Depot

Fixed Version 4.0.0 Alpha 1

Milestone VaultWiki 4 Alpha 1

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

March 15, 2013 4:19 PM

pegasus

VaultWiki Team

It seems that the Install_DB_Alter controller may not be loading its children properly. You can bear with me while I setup a new test to run a fresh install and debug the issue, you can opt for a complimentary Install Service (no charge), or if you have some technical ability, you can look in vault/core/controller/install/db/alter's children and apply the changes to the database manually (it's 2 columns total).

Reply
March 15, 2013 4:25 PM

Dark Pulse

New Member

If you can tell me what files and what to edit, I'm comfortable editing them, reuploading them, and retrying.

Should I uninstall before I retry, or would it just work to re-try the install, as Steps 1 and 2 were successful.

Reply
March 15, 2013 4:48 PM
pegasus

VaultWiki Team
It will take a bit to debug this, so run the following queries on your database. You don't need to uninstall before retrying.

Code:

ALTER TABLE bbcode ADD COLUMN vw_options INT(10) UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE session ADD COLUMN vw_location VARCHAR(255) NOT NULL DEFAULT '';
Reply

March 15, 2013 4:56 PM

Dark Pulse Dark Pulse is offline

New Member

Altered the tables and retried. Got a little further, but then it bombed out with something else.

Code:

Adding data to table: bbcode
Adding data to table: vw_nodetype
Adding data to table: product
Adding data to table: productcode
Adding data to table: productdependency
Fatal error: Call to undefined method vw_URL_Model_vB3::form_path() in /[...]/vault/core/model/url/vw.php on line 113

March 15, 2013 5:04 PM
pegasus

VaultWiki Team
line 113, where it says 'form_path' should be 'forum_path'

As for the Alter not working, got it sorted. vault/core/controller/install/db/alter/vw.php, has:

Code:

$this->values

Should be:

Code:

$this->fields

Weird that the warning for the invalid foreach wasn't showing for you though.
Reply
March 15, 2013 5:18 PM

Dark Pulse

New Member

Edited files, reuploaded, retried. Step 3 is now passed, but it now fatals on Step 10. As that is separate from Step 3, however, I will open another topic on it.

Reply

+ Reply

All times are GMT -4. The time now is 4:47 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_options' in 'field list'"

Issue Tools