Welcome to Geeklog, Anonymous Sunday, December 29 2024 @ 08:45 am EST

Geeklog Forums

restore database


Status: offline

frawo

Forum User
Junior
Registered: 10/09/02
Posts: 29
Hi
I cant upgrade the database (backup from 1.3.8) to a new installation of 1.3.9. Gets this in the error log:

Mar 31 10:17:21 2004 - 1064: You have an error in your SQL syntax near ')' at line 1. SQL in question: SELECT DISTINCT ft_name FROM gl_access,gl_features WHERE ft_id = acc_ft_id AND acc_grp_id IN ()

Is there any other way to backup?

frawo
...what, me?
 Quote

Status: offline

frawo

Forum User
Junior
Registered: 10/09/02
Posts: 29
Well
I managed it Rolling Eyes :
I edited the sql backup, kept only the INSERT INTO.
Then in the new database (with phpMyAdmin) I emptied the tables and with SQL location of the textfile mostly went smoothly (execpt some pictures).

I am up again Mr. Green
...what, me?
 Quote

Status: offline

Vapour71

Forum User
Chatty
Registered: 02/10/05
Posts: 55
Location:Great White North Eh!
Could you possibly explain this proceedure a little more clearly? I have done a fefw backups and for some strange reason I all of a sudden start to get this same error showing up in my error log. Any help would be greatly appreciated Wink
I've Gone To Find Myself. If I Show Up Before I Return, Make Me Wait Here Until I Get Back.
 Quote

All times are EST. The time is now 08:45 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content