rafaelsteil/jforum2 — Issue #8: MySQL error
Author: luminaryone
Created: 2012-01-18 16:02:53+00:00
State: open

Hi,

Got this one when trying to set up jForum on JBoss AS 7 and MySQL 5.5.18 (after realising I had to set up the MySQL properties BEFORE installing. Might want to put a note on that in the install instructions).

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 'TYPE=InnoDB' at line 1
CREATE TABLE jforum_banlist ( banlist_id INT NOT NULL auto_increment, user_id INT, banlist_ip varchar(15), banlist_email varchar(255), PRIMARY KEY (banlist_id), INDEX idx_user (user_id), INDEX (banlist_ip), INDEX (banlist_email)) TYPE=InnoDB

Google gave me this http://www.zabbix.com/forum/showthread.php?t=17543 for what it's worth.

Thanks