The vB Geek

The vB Geek (http://www.thevbgeek.com/index.php)
-   Geek Article and Review System (http://www.thevbgeek.com/forumdisplay.php?f=26)
-   -   Transfer servers got minor problem (http://www.thevbgeek.com/showthread.php?t=2240)

htscpl 10-05-2006 12:53 AM

Transfer servers got minor problem
 
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...

Code:

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 :confused:

The Geek 10-05-2006 07:43 AM

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 10-05-2006 08:20 PM

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


All times are GMT. The time now is 12:17 PM.

Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.