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?
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?
7
6
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