Welcome to Geeklog, Anonymous Thursday, April 18 2024 @ 10:37 pm EDT

Geeklog Forums

Just upgraded to 1.3.7rc1, and now no one can log in!


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

 Quote

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

Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
Location:Colorado, USA
What version did you upgrade from?
 Quote

Status: offline

gotroot801

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

All times are EDT. The time is now 10:37 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