View Single Post
  #1  
Old 10-04-2006, 11:53 PM
htscpl's Avatar
htscpl htscpl is offline
Junior Member
 
Join Date: Oct 2005
Location: Houston
Posts: 4
Geek Article and Review System License Holder Geek Gazette License Holder 
Default 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
__________________
Get Your Heart On - Your HTS Heart that is! Visit us at HTS Lifestyle
Reply With Quote