Any one now what this error could be?

[fried-chicken]

hi,

trying to the intall.php on one of my scripts

i have not got a clue!

-------------------------

Error on line 0 of Query:
CREATE TABLE `chat` ( `id` int(32) NOT NULL auto_increment, `user` varchar(100) NOT NULL default '', `chat` text NOT NULL, `timem` int(2) NOT NULL default '0', `stamp` varchar(32) NOT NULL default '0:0', `show` varchar(32) NOT NULL default 'yes', UNIQUE KEY `id` (`id`), FULLTEXT KEY `chat` (`chat`), FULLTEXT KEY `user` (`user`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1715

 

[RJ]

The query executed fine on my server. Could it have to do with your MySQL version? I am on MySQL 5.

 

[Kate]

It could be a problem with your version.
Try the query with phpmyadmin to see where it stops parsing properly
or removing the ENGINE=MyISAM part

 

[monaco]

Could also be that your version of MySQL wasn't compiled with unicode support too. Try removing the charset specifier.