Welcome to Geeklog, Anonymous Saturday, November 23 2024 @ 08:24 pm EST
Geeklog Forums
Dreaded SQL error 1024
Status: offline
horkulated.com
Forum User
Newbie
Registered: 01/28/04
Posts: 10
I was futzing with user/group permissions and now I can't even access my site (instead of the index.php, I get a SQL Error, check your error.log)
This is what the log says:
Fri May 28 14:46:33 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 ()
I searched through the forums on this topic, and I think this post has the solution. Unfortunately, I can't log into my site to make the changes he discusses through the Groups admin control panel... I can't even get to the index page. Can this be done through PhpMyAdmin? can anyone walk me thru it??
Thanks in advance... any and all help is sincerely appreciated.
Horkulated -- Where Great Ideas go to Die
This is what the log says:
Fri May 28 14:46:33 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 ()
I searched through the forums on this topic, and I think this post has the solution. Unfortunately, I can't log into my site to make the changes he discusses through the Groups admin control panel... I can't even get to the index page. Can this be done through PhpMyAdmin? can anyone walk me thru it??
Thanks in advance... any and all help is sincerely appreciated.
Horkulated -- Where Great Ideas go to Die
11
8
Quote
All times are EST. The time is now 08:24 pm.
- 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