Status: offline

gotroot801

Forum User
Junior
Registered: 04/26/02
Posts: 25

OK - I upgraded to 1.3.7, and now my users can't log in:

1064: You have an error in your SQL syntax near '' at line 1

If I check the error log, here's the full text of the error:

Sun Apr 20 18:17:58 2003 - error in get_userdata
Sun Apr 20 18:17:58 2003 - 1064: You have an error in your SQL syntax near ' 1050877078, '24.191.19.63')' at line 1 SQL in question: INSERT INTO gl_sessions (seb ss_id, md5_sess_id, uid, start_time, remote_ip) VALUES (254962029, '', , 1050877078, '24.191.19.63')

I had the same problem, but when I recreated my user account (and used some SQL trickery to update my UID) it went away... and I don't want to have to do this for every user I have.

I know there was another user who had the same problem back in February, but there didn't appear to be a resolution. Any ideas?

System particulars: Apache 1.3.27, php 4.2.3, mysql 3.23.55


Status: offline

gotroot801

Forum User
Junior
Registered: 04/26/02
Posts: 25
Forgot to clarify - I'm running apache/php/mysql under Linux, not Windows.

Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
What version did you upgrade from?

Status: offline

gotroot801

Forum User
Junior
Registered: 04/26/02
Posts: 25
Upgraded from 1.3.6