2019-06-04, 08:54 AM
always get the following error during installation
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups text NOT NULL, active tinyint(1) NOT NULL default '1', PRIMARY KE' at line 5
Query:
CREATE TABLE mybb_arcadecategories ( cid smallint unsigned NOT NULL auto_increment, name varchar(50) NOT NULL default '', image varchar(200) NOT NULL default '', groups text NOT NULL, active tinyint(1) NOT NULL default '1', PRIMARY KEY(cid) ) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups text NOT NULL, active tinyint(1) NOT NULL default '1', PRIMARY KE' at line 5
Query:
CREATE TABLE mybb_arcadecategories ( cid smallint unsigned NOT NULL auto_increment, name varchar(50) NOT NULL default '', image varchar(200) NOT NULL default '', groups text NOT NULL, active tinyint(1) NOT NULL default '1', PRIMARY KEY(cid) ) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;