Is it possible to restore a user?

[jonsidneyb]

I think I caused one to vanish from the forum.

 

[jonsidneyb]

The migration had just been done and the forum had not been reopened yet. The migration took I think about 12 hours. I was changing some people in their user groups and I deleted someone.

 

[jonsidneyb]

I looked and found their threads. They have their user name on the posts but they are labeled as guest.

I don't know if this bit of information helps any.

 

[CTXMedia]

Have you looked in the post table to see if there is a USER ID value for this person's posts?

Presumably the user account has been deleted but everything else is still there - posts/threads etc.? If so, you may be able to simply manually recreate the user account in the user table (with that ID) and that would fix it.

Anyone able to confirm if this is possible?

Thanks,
Shaun

 

[borbole]

I looked and found their threads. They have their user name on the posts but they are labeled as guest.

I don't know if this bit of information helps any.

Give my suggestion at this thread a try.

Restore a Deleted User Account?

 

[jonsidneyb]

Give my suggestion at this thread a try.

Restore a Deleted User Account?

Thanks,

I was looking at that. I noticed the other person didn't post if it worked or not.

 

[borbole]

Thanks,

I was looking at that. I noticed the other person didn't post if it worked or not.

Maybe he forgot to post an update. But the queries will work for sure.

 

[jonsidneyb]

Maybe he forgot to post an update. But the queries will work for sure.

Thanks a bunch. You don't happen to know what to do for messages do you?

 

[borbole]

Thanks a bunch. You don't happen to know what to do for messages do you?

For the private messages you mean? Atm I do not have the free time needed to look into it.

 

[jonsidneyb]

For the private messages you mean? Atm I do not have the free time needed to look into it.

Thanks, what you have provided is very appreciated./

 

[borbole]

Thanks, what you have provided is very appreciated./

You are welcome

 

[SchmitzIT]

Maybe he forgot to post an update. But the queries will work for sure.

Actually, they failed. There's no "s" at the end of the xf_thread and xf_post tables

 

[SchmitzIT]

I would assume that when a user is deleted, though, all user-related tables (profiles, options, privacy, and pms) will have the proper lines for the user deleted as well (proper line being their part of the messages, for instance. If I started a message with someone and the user then gets deleted, I'd assume my original message will still be available for me). The threads and posts are different in that respect, as they are public, and part of the site anyone would be able to see.

 

[borbole]

Actually, they failed. There's no "s" at the end of the xf_thread and xf_post tables

Ah, it was a typo, thanks for bringing it to my attention. But I do not see a reason for failing as that is very catchable 'mistake'.

 

[jonsidneyb]

My user is back.

 

[SchmitzIT]

Ah, it was a typo, thanks for bringing it to my attention. But I do not see a reason for failing as that is very catchable 'mistake'.

True, and it was spotted easily enough