Database error in vBulletin :
Invalid SQL:
CREATE TABLE vb_noticecriteria (
noticeid INT UNSIGNED NOT NULL DEFAULT '0',
criteriaid VARCHAR(250) NOT NULL DEFAULT '',
condition1 VARCHAR(250) NOT NULL DEFAULT '',
condition2 VARCHAR(250) NOT NULL DEFAULT '',
condition3 VARCHAR(250) NOT NULL DEFAULT '',
PRIMARY KEY (noticeid,criteriaid)
);
MySQL Error : Specified key was too long; max key length is 1000 bytes
Error Number : 1071
Request Date : Thursday, June 29th 2017 @ 11:48:52 PM
Error Date : Thursday, June 29th 2017 @ 11:48:54 PM
Script : http:///install/install.php?step=3
Referrer : http:///install/install.php?step=2
IP Address : IPADDRESS
Username :
Classname : vB_Database_MySQLi
MySQL Version : 5.6.35
Server : 107.161.186.90
User Agent :
Totally not sure what's going on with this... someone help, please.
Invalid SQL:
CREATE TABLE vb_noticecriteria (
noticeid INT UNSIGNED NOT NULL DEFAULT '0',
criteriaid VARCHAR(250) NOT NULL DEFAULT '',
condition1 VARCHAR(250) NOT NULL DEFAULT '',
condition2 VARCHAR(250) NOT NULL DEFAULT '',
condition3 VARCHAR(250) NOT NULL DEFAULT '',
PRIMARY KEY (noticeid,criteriaid)
);
MySQL Error : Specified key was too long; max key length is 1000 bytes
Error Number : 1071
Request Date : Thursday, June 29th 2017 @ 11:48:52 PM
Error Date : Thursday, June 29th 2017 @ 11:48:54 PM
Script : http:///install/install.php?step=3
Referrer : http:///install/install.php?step=2
IP Address : IPADDRESS
Username :
Classname : vB_Database_MySQLi
MySQL Version : 5.6.35
Server : 107.161.186.90
User Agent :
Totally not sure what's going on with this... someone help, please.
Comment