I've received this same error using the installation wizard, attempting a manual import via SQLyog and through the MySQL CLI. The error is as follows follows:
CREATE TABLE jforum_banlist (
banlist_id INT NOT NULL auto_increment,
PRIMARY KEY (banlist_id),
INDEX idx_user (user_id),
Error occured at:2008-01-14 13:47:14
Error Code: 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 'TYPE=InnoDB' at line 10
I'm somewhat of a SQL newbie, but I don't see any syntax errors here.
Any help or insight would be much appreciated. Thanks! [originally posted on jforum.net by evelmike]
Migrated From Jforum.net
posted 12 years ago
After a bit of digging and help from the guys over at mysql.com, I found that TYPE was a synonym for ENGINE as of MySQL 5.0, but that support appears to have been dropped in MySQL 5.1.
heh, easy fix. Replace TYPE with ENGINE. ;) [originally posted on jforum.net by evelmike]