Geeklog Forums

for no reason i can discern, today i suddenly started getting the following error when i try to log in to my admin account: 1064: You have an error in your SQL syntax near ' 1044377337, '24.148.3.11')' at line 1 any ideas what this is all about and/or what to do about it? thanks.

Please quote the corresponding line from Geeklog's error.log file since that will include the actual SQL request that caused the problem. bye, Dirk

it seems to produce three lines, one of which is the actual 1064: Tue Feb 4 11:48:51 2003 - Could not open the file. /home/jfisher/www/backend/geeklog.rdf Tue Feb 4 11:48:57 2003 - error in get_userdata Tue Feb 4 11:48:57 2003 - 1064: You have an error in your SQL syntax near ' 1044377337, '24.148.3.11')' at line 1 SQL in question: INSERT INTO gl_sessions (sess_id, md5_sess_id, uid, start_time, remote_ip) VALUES (1445376006, '', , 1044377337, '24.148.3.11') now that i look at the log file, i see the first error (re: geeklog.rdf) has been happening forever. i presume that's a permissions thing? both the second and third errors are new -- they only started happening today, and i've been running this since november. thanks. j

Yes, the first one is a permission issue with the geeklog.rdf file or the backend directory. If you don't use the RDF file, you could simply switch it off in config.php. The other one is odd. It seems to be losing the userid when it's trying to create a new session. Which version of Geeklog is that? Does this also happen when you try to login with another browser? bye, Dirk

it does happen with another browser. i normally use chimera. when this first happened, i downloaded the latest chimera nightly build, and it still happened. when i read your post, i tried with IE and it happened again, but checking the log file, this is what was logged: Tue Feb 4 16:52:15 2003 - error in get_userdata Tue Feb 4 16:52:15 2003 - 1064: You have an error in your SQL syntax near '' at line 1 SQL in question: DELETE FROM gl_sessions WHERE uid = incidentally, when i try to login with the wrong password, i get bumped back to the login page, as usual. this only happens when the login is correct, apparently. still puzzled. and there's nothing i've changed that could possibly cause this. is it possible that the database has become corrupted, somehow, and that that's what's causing the problem? i'm using 1.3.6. j

any more thoughts on this? i'm effectively unable to log in as administrator until i get it resolved . . .

Sorry, no ... Unless you are really running Geeklog 1.3.6rc1 (not 1.3.6) - then you could give the lib-sessions.php from 1.3.6 (or 1.3.7) a try. But at the moment you seem to be the only one with this problem ... bye, Dirk

i don't know. it looks awfully similar to what's happening here.

i reckon if we can get one figured out, we can get the other. it also resembles the anonymous email problem, but i can't figure out how to cross-apply that -- if it's even applicable.

and i'm running 1.3.6, not rc1. just for the record.

thanks,

jeff

and please note, as i posted a couple of days ago, the original error i posted stopped as mysteriously as it started, but was just as mysteriously replaced with the following errors, which are the ones resembling surf3r's: Tue Feb 4 16:52:15 2003 - error in get_userdata Tue Feb 4 16:52:15 2003 - 1064: You have an error in your SQL syntax near '' at line 1 SQL in question: DELETE FROM gl_sessions WHERE uid = thanks jeff

btw -- just for the heck of it, i tried dropping in lib-sessions.php from 1.3.7 and it had no effect. fwiw.

so, after some tinkering, i have no idea how much progress i've made, but i know i'm getting something different that, alas, no one else seems to be getting, either. in any case, i hope that maybe it will be more obvious what's happening with this. when i try to log in, i just get kicked back to the home page. the error in the error log is an "error with get_userdata", leading me to this: /** * Gets a user's data * * Gets user's data based on their username * * @param string $username Username of user to get data for * @return array returns user's data in an array * */ function SESS_getUserData($username) { global $_TABLES; $sql = "SELECT *,format FROM {$_TABLES['users']}, {$_TABLES['userprefs']}, {$_TABLES['dateformats']} " . "WHERE {$_TABLES['dateformats']}.dfid = {$_TABLES['userprefs']}.dfid AND " . "{$_TABLES['userprefs']}.uid = {$_TABLES['users']}.uid AND username = '$username'"; if(!$result = DB_query($sql)) { COM_errorLog("error in get_userdata"; } if(!$myrow = DB_fetchArray($result)) { COM_errorLog("error in get_userdata"; } return($myrow); } with some experimenting, i know the error message is the second error, not the first. but i'm at a loss for where to go from here. i've submitted a support ticket with my host, wondering if they've updated versions of php or mysql. it's the only other thing i can think of. thanks for any help. obviously, this is driving me nuts. i've been working on this for a long time, today, and gotten basically nowhere. thanks jeff