Welcome to Geeklog, Anonymous Wednesday, December 07 2022 @ 09:51 pm EST

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 EST. The time is now 09:51 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