Issue: SQL error with clean installation of 2.5.0 on Step 1.

Issue Tools
- View Changes

August 4, 2009 1:03 AM

SAS

New Member

SQL error with clean installation of 2.5.0 on Step 1.

When I beginning installation of VaultWiki, on Step 1) I got this error:

Code:

Invalid SQL:

			CREATE TABLE IF NOT EXISTS vb_vault_article (
			
	threadid INT(11) UNSIGNED NOT NULL DEFAULT '0',
	bookid INT(11) UNSIGNED NOT NULL DEFAULT '0',
	lastmodified INT(11) UNSIGNED NOT NULL DEFAULT '0',
	lastmodifiedbyid INT(11) UNSIGNED NOT NULL DEFAULT '0',
	lastposterid INT(11) UNSIGNED NOT NULL DEFAULT '0',
	pending INT(1) UNSIGNED NOT NULL DEFAULT '0',
	templatelist TEXT NOT NULL DEFAULT '',
	starting VARCHAR(1) NOT NULL DEFAULT '',
	PRIMARY KEY (threadid),
	INDEX bookid (bookid),
	INDEX lastposterid (lastposterid),
	INDEX pending (pending),
	INDEX starting (starting)

			);
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 'starting VARCHAR(1) NOT NULL DEFAULT '',
	PRIMARY KEY (threadid),
	INDEX bookid ' at line 10


My soft:
OS: Windows (testing on localhost)
PHP: 5.2.6
MySQL: 5.0.45

Issue Details

Issue Number 752

Issue Type Bug

Project VaultWiki 3.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 2.5.0

Fixed Version 2.5.0

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

August 4, 2009 1:12 AM

SAS

New Member

Hmm...when I change all 'starting' to (for example) 'asdasd', SQL query running correctly...

As I see, STARTING - is a reserved MySQL word --> http://dev.mysql.com/doc/refman/5.0/...ved-words.html

Reply

August 4, 2009 1:32 AM

SAS

New Member

Issue solved:
In the file /vault/install/mysql-create.php
Search:

Code:

###### ARTICLE ######
vw_create_table('vault_article', "
	threadid INT(11) UNSIGNED NOT NULL DEFAULT '0',
	bookid INT(11) UNSIGNED NOT NULL DEFAULT '0',
	lastmodified INT(11) UNSIGNED NOT NULL DEFAULT '0',
	lastmodifiedbyid INT(11) UNSIGNED NOT NULL DEFAULT '0',
	lastposterid INT(11) UNSIGNED NOT NULL DEFAULT '0',
	pending INT(1) UNSIGNED NOT NULL DEFAULT '0',
	templatelist TEXT NOT NULL DEFAULT '',
	starting VARCHAR(1) NOT NULL DEFAULT '',
	PRIMARY KEY (threadid),
	INDEX bookid (bookid),
	INDEX lastposterid (lastposterid),
	INDEX pending (pending),
	INDEX starting (starting)
");

And replace with:

Code:

###### ARTICLE ######
vw_create_table('vault_article', "
	threadid INT(11) UNSIGNED NOT NULL DEFAULT '0',
	bookid INT(11) UNSIGNED NOT NULL DEFAULT '0',
	lastmodified INT(11) UNSIGNED NOT NULL DEFAULT '0',
	lastmodifiedbyid INT(11) UNSIGNED NOT NULL DEFAULT '0',
	lastposterid INT(11) UNSIGNED NOT NULL DEFAULT '0',
	pending INT(1) UNSIGNED NOT NULL DEFAULT '0',
	templatelist TEXT NOT NULL DEFAULT '',
	`starting` VARCHAR(1) NOT NULL DEFAULT '',
	PRIMARY KEY (threadid),
	INDEX bookid (bookid),
	INDEX lastposterid (lastposterid),
	INDEX pending (pending),
	INDEX `starting` (`starting`)
");

August 4, 2009 6:17 AM

pegasus

VaultWiki Team

This was reported a week ago, so I'm surprised the ZIP still contained the problem. Thanks. Fixed now.

Reply
August 7, 2009 7:35 AM

John

New Member

Not fixed at all... I just downloaded the latest version and I got this bug at step 1 also.. Pretty sloppy that such a bug is still there...

EDIT:
By the way: Thanks SAS, your solution worked for me.

Reply

+ Reply

All times are GMT -4. The time now is 7:18 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: SQL error with clean installation of 2.5.0 on Step 1.

Issue Tools