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 04-13-2006, 12:24 PM
clearchannel clearchannel is offline
Member
 
Join Date: Oct 2005
Posts: 32
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder 
Default mysql error during restore

I tried to restore my database after installing gars and received the following error message:

ERROR 1064 at line 1415: 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)

The restore stalls at the gars table. I tried to restore an earlier backup of the database before the install of gars with no problem.

What might you suggest.
Reply With Quote
  #2  
Old 04-13-2006, 12:56 PM
Southpaw Southpaw is offline
Junior Member
 
Join Date: Apr 2006
Posts: 14
Geek Article and Review System License Holder 
Default

Can you paste the whole query here? (line 1415)
Reply With Quote
  #3  
Old 04-13-2006, 08:22 PM
clearchannel clearchannel is offline
Member
 
Join Date: Oct 2005
Posts: 32
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder 
Default

How do I go about finding the query?
Reply With Quote
  #4  
Old 04-13-2006, 09:06 PM
Southpaw Southpaw is offline
Junior Member
 
Join Date: Apr 2006
Posts: 14
Geek Article and Review System License Holder 
Default

Open up the SQL file and then scroll to line 1415. Copy and paste the query here.
Reply With Quote
  #5  
Old 04-14-2006, 11:48 AM
clearchannel clearchannel is offline
Member
 
Join Date: Oct 2005
Posts: 32
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder 
Default

Can you recommend a program to open the database backup? It is of course a sql file. The file is 420 megs in size. I have tried notetab pro, windows word pad, and filemaker pro, they all seem to run out of memory before I can acually see the file.

Thank you in advance.
Reply With Quote
  #6  
Old 04-14-2006, 02:21 PM
Southpaw Southpaw is offline
Junior Member
 
Join Date: Apr 2006
Posts: 14
Geek Article and Review System License Holder 
Default

You can give notepad ++ a try: http://notepad-plus.sourceforge.net/uk/site.htm
Reply With Quote
  #7  
Old 04-14-2006, 09:14 PM
clearchannel clearchannel is offline
Member
 
Join Date: Oct 2005
Posts: 32
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder 
Default

Thank you for the suggestion. The query is:

CREATE TABLE gars_custom_fields (
Reply With Quote
  #8  
Old 04-14-2006, 11:49 PM
Southpaw Southpaw is offline
Junior Member
 
Join Date: Apr 2006
Posts: 14
Geek Article and Review System License Holder 
Default

The full query should look something like this right?
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`)
)
Reply With Quote
  #9  
Old 04-15-2006, 07:54 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

Thats pretty odd. For now, just delete what southpaw posted above as that table isnt needed yet.
Reply With Quote
  #10  
Old 04-15-2006, 07:54 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

IN fact, if everything else got created... and there isnt anything else after that bit... then you should be good to go.
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 every day Hengis Geek Advertising Banner System 8 12-09-2009 06:21 PM
Getting mysql error truCido Geek Advertising Banner System 6 08-11-2008 08:27 AM
Mysql error after reinstall? CAMS GeekMart 11 07-03-2006 01:10 AM
Products - Items MySQL Error... DerTobi75 GeekMart 21 12-07-2005 12:20 PM
[fixed][3.0.8] - Vendor mysql db error GoTTi GeekMart 4 08-23-2005 09:53 PM


All times are GMT. The time now is 12:59 AM.


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