Issue: Database Error on upgrade script.

Issue Tools
- View Changes

March 14, 2010 10:26 AM

vimto

Regular Member

Database Error on upgrade script.

Database error in vBulletin 4.0.2

I've just tried upgrading from the vb3 version and have come across this error while running the upgrade script.

Any help is appreciated.

Code:

Database error in vBulletin 4.0.2:

Invalid SQL:

			SHOW COLUMNS FROM vault_category
			WHERE Field IN ('categoryid', 'title_lower');

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Field IN ('categoryid', 'title_lower')' at line 2
Error Number  : 1064
Request Date  : Sunday, March 14th 2010 @ 02:21:13 PM
Error Date    : Sunday, March 14th 2010 @ 02:21:13 PM
Script        : http://www.mywebsite.co.uk/forums/vault/install/upgrade_3p300b1.php?step=2
Referrer      : http://www.mywebsite.co.uk/forums/vault/install/upgrade_3p300b1.php?step=1
IP Address    : xxxxxxx
Username      : xxxxxx
Classname     : vB_Database
MySQL Version : 4.1.22-log

Issue Details

Issue Number 1267

Issue Type Bug

Project VaultWiki 3.x Series

Category Install / Upgrade

Status Fixed

Priority 1 - Security / Login / Data Loss

Affected Version 3.0.0 Beta 6

Fixed Version 3.0.0 Beta 6

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)

March 14, 2010 12:50 PM
pegasus

VaultWiki Team
Fixed in the current ZIP.

This is a conflict with MySQL < 5, because it doesn't yet accept WHERE expressions in the SHOW syntax. In vault/install/upgrade_3p300b1.php, find:

Code:

SHOW COLUMNS FROM " . TABLE_PREFIX . "vault_category WHERE Field IN ('categoryid', 'title_lower')

Replace with:

Code:

SHOW COLUMNS FROM " . TABLE_PREFIX . "vault_category
Reply
March 14, 2010 1:13 PM

vimto

Regular Member

Many thanks, The rest of the install worked fine.

Reply

+ Reply

All times are GMT -4. The time now is 10:24 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 on upgrade script.

Issue Tools