Welcome to Geeklog, Anonymous Saturday, September 07 2024 @ 09:22 pm EDT
Geeklog Forums
Changing user ID
Anonymous
Anonymous
User mistakenly deleted. All his posts and contributions are still there, but he's registered again. Now, he's ID is not the same as it was and his submissions don't "belong to him" or anyone anymore. How do I change his id to the one that existed before? I tried changing it in 2 tables, users and userprefs, but he got sql error when he tried to login afterwards.
5
2
Quote
Status: offline
ndarlow
Forum User
Junior
Registered: 06/30/02
Posts: 31
It might be easier to convert his original GeekLog submissions to use his new ID.
It's likely that GeekLog uses the same field name throughout the database to specify the user ID so using the search feature of newer versions of phpMyAdmin should allow you to find them easily.
Regards,
Neil Darlow M.Sc.
4
5
Quote
All times are EDT. The time is now 09:22 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