Welcome to Geeklog, Anonymous Thursday, November 28 2024 @ 03:40 am EST
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
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
12
8
Quote
All times are EST. The time is now 03:40 am.
- 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