iam trying to perform this query in mysql
CREATE TABLE forum_asb_sideboxes(
id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
display_order INT(10) NOT NULL,
box_type VARCHAR(25) NOT NULL,
title TEXT,
title_link VARCHAR(128) NOT NULL,
POSITION INT(2),
scripts TEXT,
groups TEXT,
themes TEXT,
settings TEXT,
wrap_content INT(1),
dateline INT(10)
) ENGINE = myisam CHARACTER SET utf8 COLLATE utf8_general_ci;
Iam getting this 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,themes TEXT,settings TEXT,wrap_content INT(1),dateline INT(10)) ENGI' at line 1
The thing is this is a mybb plugin that iam trying to install this plugin works on alot of other mybb based forums i dont really know what is happening maybe the query is only available for another mysql version
can you tell me how to fix it please
