Welcome to Geeklog, Anonymous Wednesday, April 24 2024 @ 10:32 am EDT

Geeklog Forums

Another SQL error.1064; and the mystery of the lost tables.


Frawo

Anonymous
Hi

I tries to upgrade to latest version, but after installation I get this:

- 1064: You have an error in your SQL syntax near 'Wink' 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 ()

Bye the way: I moved from one server to another (copied), all the tables where lost (and text/pictures for 3 years). Only the datebases was left. And of course no back-up. The provider of the server moved the site.

Je regret...
 Quote

Frawo

Anonymous
Another thing: I upgraded the database first, got only 30 tables.
Second I made another database, and under installation of Geeklog took a new database and got 40 tables. Why? Could it be because the database had no old tables (lost in the change in server)?
 Quote

Status: offline

Vapour71

Forum User
Chatty
Registered: 02/10/05
Posts: 55
Location:Great White North Eh!
How did you end up resolving this issue or have you not resolved it as of yet?
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 EDT. The time is now 10:32 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