Welcome to Geeklog, Anonymous Saturday, April 20 2024 @ 06:18 am 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.
 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.
 Quote

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