|
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 |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Can you paste the whole query here? (line 1415)
|
#3
|
|||
|
|||
How do I go about finding the query?
|
#4
|
|||
|
|||
Open up the SQL file and then scroll to line 1415. Copy and paste the query here.
|
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
You can give notepad ++ a try: http://notepad-plus.sourceforge.net/uk/site.htm
|
#7
|
|||
|
|||
Thank you for the suggestion. The query is:
CREATE TABLE gars_custom_fields ( |
#8
|
|||
|
|||
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`) ) |
#9
|
||||
|
||||
Thats pretty odd. For now, just delete what southpaw posted above as that table isnt needed yet.
|
#10
|
||||
|
||||
IN fact, if everything else got created... and there isnt anything else after that bit... then you should be good to go.
|
Thread Tools | |
Display Modes | |
|
|
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 |