Welcome to Geeklog, Anonymous Thursday, April 25 2024 @ 12:00 pm EDT

Geeklog Forums

UID migration problem / sql error / gl_sesssions WHERE uid=


Status: offline

greenhil

Forum User
Chatty
Registered: 07/20/04
Posts: 51
ok...i am almost done with my new site migration except for the user tables and sync of uids

root admin users are fine...when a regular user tries to login...they get the vanilla sql error msg which corresponds to this in the error log:

Wed Feb 9 13:00:25 2005 - 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: DELETE FROM gl_sessions WHERE uid =

i believe i have done a proper restore of the data from all the user tables (comment, index, etc.) from the older 1.3.9 site but clearly i am missing something...

i am hoping for some very specific guidance - i.e.: down to the level of how i should export the data (insert, replace, extended, etc.)

also, if there is a 'work around' let me know...there isnt much user data that i have to have other than the basic info
thanks,

jonathan
 Quote

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