The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Article and Review System

Geek Article and Review System GARS is the mega popular system for turning forums into articles, tutorials, or even reviews.

Advertisement
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 10-05-2006, 12:53 AM
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
  #2  
Old 10-05-2006, 07:43 AM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

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
Reply With Quote
  #3  
Old 10-05-2006, 08:20 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

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
__________________
Get Your Heart On - Your HTS Heart that is! Visit us at HTS Lifestyle
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Minor first-time glitch cheesegrits Geek Auto-Linker 1 12-23-2008 03:08 AM
Can't save settings after moving servers Serendib Geek Article and Review System 1 01-18-2008 10:30 PM
GARS transfer? Ohiosweetheart Geek Article and Review System 8 07-23-2007 05:14 PM
Need help with fixing minor issue smitts Geek Article and Review System 2 05-18-2007 01:48 PM
License transfer? smacklan GeekMart 2 02-02-2006 09:55 PM


All times are GMT. The time now is 05:22 AM.


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