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
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.