Welcome to Geeklog, Anonymous Wednesday, November 27 2024 @ 04:49 am EST

Geeklog Forums

SQL error


TVDSB

Anonymous
I think I may have a large problem with my database. I pray that Dirk might have a solution.
When I try to log out, I get the following error in the error.log:

Mon Dec 6 09:20:14 2004 - 1064: 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 ')' 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 ()

Some insight:
one row may have been deleted from the database last friday, and I think it was in the "location" row of the personal events database. I tried to re-insert, but I am not that familliar with MySql. What are the fields supposed to contain?
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
See here.

Always try searching for the error message first ...

bye, Dirk
 Quote

All times are EST. The time is now 04:49 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