Issue: Just installed, can't create new posts now.

Issue Tools
- View Changes

April 27, 2010 4:20 PM

Trekkan

Junior Member

Just installed, can't create new posts now.

SQL Error when making new post

I get this SQL error when creating a new post now (regular forum post).

Installation seemed to go fine, at least no errors reported.

Code:

Database error in vBulletin 4.0.3:

Invalid SQL:
INSERT INTO dhv_post
	(showsignature, allowsmilie, htmlstate, username, userid, title, pagetext, iconid, visible, vault_options, dateline, ipaddress, attach, threadid)
VALUES
	(1, 1, 'on_nl2br', 'Trekkan', 1, 'test', 'test', 0, 1, 1, 1272399347, '134.134.139.72', 0, 5795);

MySQL Error   : Unknown column 'vault_options' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, April 27th 2010 @ 03:15:47 PM
Error Date    : Tuesday, April 27th 2010 @ 03:15:48 PM
Script        : http://www.darkhandofvalor.com/newthread.php?do=postthread&f=36
Referrer      : http://www.darkhandofvalor.com/newthread.php?do=newthread&f=36

Issue Details

Issue Number 1491

Issue Type Bug

Project VaultWiki 3.x Series

Category Non-Wiki Threads / Posts

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 3.0.0 RC 2

Fixed Version 3.0.0 RC 2

Milestone VaultWiki 3.0.0

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

April 27, 2010 4:24 PM

Trekkan

Junior Member

Manually created the vault_options column as an INT as that's what it looks like it was trying to put in there. I can post now anyway. heh

Please let me know how this column should be configured.

Reply
April 27, 2010 4:29 PM
pegasus

VaultWiki Team
Fixed in the current ZIP.

Run vault/install/upgrade_3x300rc2.php. It will say you're already running the version, so click the option to run the script anyway. Once it completes the first step, just exit the upgrader.

EDIT: Since you've already added the column, its an:

Code:

INT(3) UNSIGNED NOT NULL DEFAULT '1'
Reply

+ Reply

All times are GMT -4. The time now is 12:05 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: Just installed, can't create new posts now.

Issue Tools