Posted on: 01/18/06 02:09am
By: Anonymous (Looterdude)
This happened earlier this evening, essentially out of the blue. Once logged out of my Geeklog site, you can't get back on. The error is
An SQL error has occured. Please see error.log for details.
The error log states...
Tue Jan 17 16:36:49 2006 - 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 ()
Users who have remained logged in can access the site fine. It's once you log out that the site essentially disappears. No changes have been made to the database, and no upgrades have been performed.
Any ideas?
'Out of the blue' 1064 SQL prob
Posted on: 01/18/06 10:56pm
By: Anonymous (Looterdude)
Problem solved. Found the solution in an older post of Dirk's.
Try this: Find the place in phpMyAdmin where you can enter SQL requests and type
SELECT * FROM gl_group_assignments WHERE ug_uid = 1;
This should list one entry where ug_main_grp_id = 2.
Only(!) if you do not get that entry, do this:
INSERT INTO gl_group_assignments VALUES (2, 1, NULL);
Also check that in your gl_groups table, there is a group with grp_id = 2 and grp_name = "All Users".
'Out of the blue' 1064 SQL prob
Posted on: 02/12/06 07:13am
By: Dinosys
Same problem, but a bit different message in the error.log
Sun Feb 12 12:43:41 2006 - 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 'WHERE remote_ip = '' AND uid = 1' at line 1. SQL in question: DELETE FROM WHERE remote_ip = '' AND uid = 1
No upgrades or changes have been made....
Th only place I can find th remote_ip is in the gl_sessions table...
This makes no sence to me.... anyone got any good ideas?
'Out of the blue' 1064 SQL prob
Posted on: 02/12/06 08:28am
By: Dinosys
After a little more digging I found the fault
http://www.geeklog.net/forum/viewtopic.php?showtopic=41265
A lesson to myself not to just copy a file and not editing it
Oh well... up and running again
'Out of the blue' 1064 SQL prob
Posted on: 05/12/06 10:13am
By: Anonymous (sapran)
2 Looterdude
thanks, this worked out for me.
Re: 'Out of the blue' 1064 SQL prob
Posted on: 12/21/06 03:27pm
By: Anonymous (juntriaji)
Quote by: sapran<b>2 Looterdude</b><br />
thanks, this worked out for me.
hurray.... thnks for this forum... special 4 Looterdude