2017-01-29, 04:16 PM
Hi, I changed the compatibility so it could be installed for 1.8.10 but when I click Install I get the following error:
SQL Error:
1101 - BLOB, TEXT, GEOMETRY or JSON column 'buddylist' can't have a default value
Query:
CREATE TABLE mybb_serversboard (
EDIT: Fixed by disabling strict mode on MySQL
SQL Error:
1101 - BLOB, TEXT, GEOMETRY or JSON column 'buddylist' can't have a default value
Query:
CREATE TABLE mybb_serversboard (
sid
int(10) unsigned NOT NULL AUTO_INCREMENT, ip
varchar(35) NOT NULL DEFAULT '0', arma2qport
varchar(30) NOT NULL DEFAULT '', arma3qport
varchar(30) NOT NULL DEFAULT '', bf3qport
varchar(30) NOT NULL DEFAULT '', bf4qport
varchar(30) NOT NULL DEFAULT '', dayzqport
varchar(30) NOT NULL DEFAULT '', dayzmodqport
varchar(30) NOT NULL DEFAULT '', minecraftqport
varchar(30) NOT NULL DEFAULT '', mtaqport
varchar(30) NOT NULL DEFAULT '', mumbleqport
varchar(30) NOT NULL DEFAULT '', rustqport
varchar(30) NOT NULL DEFAULT '', terrariaqport
varchar(30) NOT NULL DEFAULT '', ts3qport
varchar(30) NOT NULL DEFAULT '10011', type
varchar(20) NOT NULL DEFAULT '0', offlinehostname
varchar(100) NOT NULL DEFAULT '', cuthostname
varchar(3) NOT NULL DEFAULT '', disporder
int(10) NOT NULL DEFAULT '0', field
int(1) NOT NULL default '0', field_link
varchar(100) NOT NULL DEFAULT '', field_icon
varchar(100) NOT NULL DEFAULT '', visible
int(1) NOT NULL default '1', new
int(1) NOT NULL default '0', new_color
varchar(20) NOT NULL DEFAULT '', new_text
varchar(20) NOT NULL DEFAULT '', forumid
varchar(20) NOT NULL DEFAULT '', buddylist
TEXT NOT NULL DEFAULT '', cache
LONGTEXT NOT NULL DEFAULT '', lastupdate
bigint(30) NOT NULL DEFAULT '0', recordplayers
int(10) NOT NULL DEFAULT '0', owner
varchar(100) NOT NULL DEFAULT '', administrators
varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (sid
) ) ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;EDIT: Fixed by disabling strict mode on MySQL