Transfer servers got minor problem

[htscpl]

The Tech who is helping me move to a new updated server has asked me about this problem and I don't know the answer. Since it involves your the GARs script I was hoping you could help...

I've found possible error: due to different versions of mysql it fails to restore database. Failed statement was:
CREATE TABLE gars_module_set_details (
id int(11) NOT NULL auto_increment,
setid smallint(6) NOT NULL default '0',
page tinyint(4) NOT NULL default '0',
section smallint(6) NOT NULL default '0',
order smallint(6) NOT NULL default '0',
modid smallint(6) NOT NULL default '0',
settings mediumtext NOT NULL,
cacheon tinyint(4) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

Please advise how should I change it to create table properly. Rest tables seems ok.

Regards,
Yevgeny.

Thanks for your help!

Henry

[The Geek]

fully qualify the table names with the ` character. In this case, I think the order column is crapping out mysql so put `order` in instead of order.

HTHs

[htscpl]

Thanks, tech guy at hosting co. figured it out also, said I should change the table name to something like 'ord' so as to not conflict with mysql keywords.

Not sure if I can just change the table name but not the script since I'm sure it refers to the table at some point.

Henry