Welcome to Geeklog, Anonymous Friday, December 27 2024 @ 07:40 pm EST

Geeklog Forums

SQL error blocking access to site


Status: offline

scroff

Forum User
Regular Poster
Registered: 02/19/03
Posts: 111
confused
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. Doh! - that was a mistake

Can someone help me

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.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
A quick search for the error message would have brought up this thread, amongst others.

bye, Dirk
 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 Embarassed

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...
 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