Welcome to Geeklog, Anonymous Friday, December 27 2024 @ 07:40 pm EST
Geeklog Forums
SQL error blocking access to site
When I try to go to my site I get this error...
"An SQL error has occured. Please see error.log for details."
the error log has this...
"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 have no idea what this means, but I can't get to my site. This seemed to have just happened. I've made no changes since I installed the weather block last night, and it was working fine since then. I tried to log in as a regluar user and got this error.
Apache version 1.3.33 (Unix)
MySQL version 4.0.22-standard
PHP version 4.3.9
One thing I did change was to add the 'target attribute to the 'a' tag in config.php admins html so I could have a memorial pop up.
"An SQL error has occured. Please see error.log for details."
the error log has this...
"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 have no idea what this means, but I can't get to my site. This seemed to have just happened. I've made no changes since I installed the weather block last night, and it was working fine since then. I tried to log in as a regluar user and got this error.
Apache version 1.3.33 (Unix)
MySQL version 4.0.22-standard
PHP version 4.3.9
One thing I did change was to add the 'target attribute to the 'a' tag in config.php admins html so I could have a memorial pop up.
7
6
Quote
Status: offline
scroff
Forum User
Regular Poster
Registered: 02/19/03
Posts: 111
Sorry Dirk. I panicked. Came back wishing I could delete my post
I forgot I was playing with the user ban hack yesterday and the regular user I was trying to log in as was left with no security groups when I stopped playing with the user ban hack... um, duh
Sorry...
I forgot I was playing with the user ban hack yesterday and the regular user I was trying to log in as was left with no security groups when I stopped playing with the user ban hack... um, duh
Sorry...
14
11
Quote
All times are EST. The time is now 07:40 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