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 12-14-2006, 03:59 AM
caislander caislander is offline
Junior Member
 
Join Date: Mar 2006
Posts: 3
Geek Article and Review System License Holder 
Default db restore problem

Evening,

I am trying to move my db to a new server account, I have made a dump of my db but each time I try to restore it at the other end it dies when it trys to create the gars_custom_fields table. This is the error I get
Quote:
ERROR 1064 (42000) at line 1056: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'default smallint(6) NOT NULL default '0', allowhtml tinyint(4) NOT NULL defaul' at line 10
and here is that section of code
CREATE TABLE gars_custom_fields (
id int(11) NOT NULL auto_increment,
title varchar(50) NOT NULL default '',
description varchar(250) NOT NULL default '',
required tinyint(4) NOT NULL default '0',
maxlength smallint(6) NOT NULL default '0',
displayorder smallint(6) NOT NULL default '0',
editable tinyint(4) NOT NULL default '0',
type enum('input','select','radio','textarea','checkbox ','select_multiple') NOT NULL default 'input',
default smallint(6) NOT NULL default '0',
allowhtml tinyint(4) NOT NULL default '0',
bbcode tinyint(4) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM
can someone tell me what is wrong and what I have to do to fix it.. I am guessing that it has something to do with default at the begining of the line

thanks

btw if it makes any difference I have version 1.01 of Gars

Last edited by caislander; 12-14-2006 at 04:30 AM..
Reply With Quote
  #2  
Old 12-14-2006, 10:30 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

Try putting ` around the word type (as in `type` enum....)
Reply With Quote
  #3  
Old 12-14-2006, 02:47 PM
caislander caislander is offline
Junior Member
 
Join Date: Mar 2006
Posts: 3
Geek Article and Review System License Holder 
Default

I will give it a try but if that doesn't work where can i find the instructions for removing Gar so that I can transfer my db then we can install the newer version once we get back up and running
Reply With Quote
  #4  
Old 12-17-2006, 05:47 AM
caislander caislander is offline
Junior Member
 
Join Date: Mar 2006
Posts: 3
Geek Article and Review System License Holder 
Default next table

OK, I got the custom_fields table to go in by putting ` both type and default but now I have problems with this one

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 ;

any clue anybody?
Reply With Quote
  #5  
Old 12-17-2006, 08:55 PM
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

put ` around order and page
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
mysql error during restore clearchannel Geek Article and Review System 23 01-23-2007 06:38 PM


All times are GMT. The time now is 04:09 PM.


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