Disable strict mode cPanel?

browey

• July 23, 2019 14:15

Hi, I have an error and I cannot install a plugin and I get this error I know that it is not possible because of the mysql and I want to deactivate the mysql this is the error that skips me 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;

• 

  GOT

  • July 23, 2019 19:34

  I've probably answered this five times in the forums. :)

  0
• 

  cPanelLauren

  • July 23, 2019 21:08

  Thanks @GOT @browey please let us know if you continue to experience issues once that's complete.

  0

Please sign in to leave a comment.