I get the following error message while doing a fresh install:
Any help on how to get over this will be appreciated.
Thanks.
Database error in vBulletin :
Invalid SQL:
CREATE TABLE deletionlog (
primaryid INT UNSIGNED NOT NULL DEFAULT '0',
type ENUM('post', 'thread') DEFAULT 'post',
userid INT UNSIGNED NOT NULL DEFAULT '0',
username VARCHAR(100) NOT NULL DEFAULT '',
reason VARCHAR(125) NOT NULL DEFAULT '',
PRIMARY KEY (primaryid, type)
);
MySQL Error : All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead
Error Number : 1171
Date : Wednesday, November 2nd 2005 @ 10:50:24 AM
Script : http://domain.com/install/install.ph...e&confirm=true
Referrer :
IP Address : 123.123.456.789
Username :
Classname : vb_database
Invalid SQL:
CREATE TABLE deletionlog (
primaryid INT UNSIGNED NOT NULL DEFAULT '0',
type ENUM('post', 'thread') DEFAULT 'post',
userid INT UNSIGNED NOT NULL DEFAULT '0',
username VARCHAR(100) NOT NULL DEFAULT '',
reason VARCHAR(125) NOT NULL DEFAULT '',
PRIMARY KEY (primaryid, type)
);
MySQL Error : All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead
Error Number : 1171
Date : Wednesday, November 2nd 2005 @ 10:50:24 AM
Script : http://domain.com/install/install.ph...e&confirm=true
Referrer :
IP Address : 123.123.456.789
Username :
Classname : vb_database
Thanks.
Comment