I'm no newbie when it comes to installing vbulletin. I tried to install vbulletin 3.5.1 as a clean installation, new database, and it gives me the following error at step 3.
ERROR BELOW:
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
------------------------
I meet the requirements:
Php 4.3.11 (can't upgrade any further at this moment)
mysql 3.23.58 (can't upgrade any further at this moment)
ERROR BELOW:
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
------------------------
I meet the requirements:
Php 4.3.11 (can't upgrade any further at this moment)
mysql 3.23.58 (can't upgrade any further at this moment)
Comment