Re: #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'

[Ryan Ward]

Thank you very much, I got that all updated, now when I try to load the second one I get this...

Error at the line 31: ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Query: CREATE TABLE `race_powers` ( `power_name` varchar(15) NOT NULL default '', `race_id` int(11) NOT NULL default '0', PRIMARY KEY (`race_id`,`power_name`), KEY `race_id` (`race_id`), KEY `power_name` (`power_name`), KEY `power_name_2` (`power_name`), CONSTRAINT `0_2190` FOREIGN KEY (`race_id`) REFERENCES `races` (`race_id`), CONSTRAINT `0_2191` FOREIGN KEY (`power_name`) REFERENCES `powers` (`power_name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

MySQL: Can't create table './retroeqdb/race_powers.frm' (errno: 150)

Stopped on error