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. |
Can you paste the whole query here? (line 1415)
|
How do I go about finding the query?
|
Open up the SQL file and then scroll to line 1415. Copy and paste the query here.
|
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. |
You can give notepad ++ a try: http://notepad-plus.sourceforge.net/uk/site.htm
|
Thank you for the suggestion. The query is:
CREATE TABLE gars_custom_fields ( |
The full query should look something like this right?
Code:
CREATE TABLE `gars_custom_fields` ( |
Thats pretty odd. For now, just delete what southpaw posted above as that table isnt needed yet.
|
IN fact, if everything else got created... and there isnt anything else after that bit... then you should be good to go.
|
All times are GMT. The time now is 09:22 AM. |
Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.