Hello:
Can someone help me decipher what this means and what I have to do? I ran the install twice and still keep getting this error message below.
Thanks!
----------------------
Database error in vBulletin :
Invalid SQL:
CREATE TABLE attachmentpermission (
attachmentpermissionid INT UNSIGNED NOT NULL AUTO_INCREMENT,
extension VARCHAR(20) BINARY NOT NULL DEFAULT '',
usergroupid INT UNSIGNED NOT NULL DEFAULT '0',
size INT UNSIGNED NOT NULL DEFAULT '0',
width SMALLINT UNSIGNED NOT NULL DEFAULT '0',
height SMALLINT UNSIGNED NOT NULL DEFAULT '0',
attachmentpermissions INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (attUMTEXT,
twoparams SMALLINT NOT NULL DEFAULT '0',
title VARCHAR(100) NOT NULL DEFAULT '',
buttonimage VARCHAR(250) NOT NULL DEFAULT '',
options INT UNSIGNED NOT NULL DEFAULT '1',
PRIMARY KEY (bbcodeid),
UNIQUE KEY uniquetag (bbcodetag, twoparams)
);
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 'SMALLINT NOT NULL DEFAULT '0',
title VARCHAR(100) NOT NULL DEFAULT '',
buttoni' at line 10
Error Number : 1064
Request Date : Friday, May 16th 2008 @ 11:34:33 PM
Error Date : Friday, May 16th 2008 @ 11:34:34 PM
Username :
Classname : vb_database
MySQL Version : 4.1.22-standard
Can someone help me decipher what this means and what I have to do? I ran the install twice and still keep getting this error message below.
Thanks!
----------------------
Database error in vBulletin :
Invalid SQL:
CREATE TABLE attachmentpermission (
attachmentpermissionid INT UNSIGNED NOT NULL AUTO_INCREMENT,
extension VARCHAR(20) BINARY NOT NULL DEFAULT '',
usergroupid INT UNSIGNED NOT NULL DEFAULT '0',
size INT UNSIGNED NOT NULL DEFAULT '0',
width SMALLINT UNSIGNED NOT NULL DEFAULT '0',
height SMALLINT UNSIGNED NOT NULL DEFAULT '0',
attachmentpermissions INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (attUMTEXT,
twoparams SMALLINT NOT NULL DEFAULT '0',
title VARCHAR(100) NOT NULL DEFAULT '',
buttonimage VARCHAR(250) NOT NULL DEFAULT '',
options INT UNSIGNED NOT NULL DEFAULT '1',
PRIMARY KEY (bbcodeid),
UNIQUE KEY uniquetag (bbcodetag, twoparams)
);
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 'SMALLINT NOT NULL DEFAULT '0',
title VARCHAR(100) NOT NULL DEFAULT '',
buttoni' at line 10
Error Number : 1064
Request Date : Friday, May 16th 2008 @ 11:34:33 PM
Error Date : Friday, May 16th 2008 @ 11:34:34 PM
Username :
Classname : vb_database
MySQL Version : 4.1.22-standard
Comment