Recovering Conversations for Previously Deleted User

[MattM]

I used Waindigo's add-on to "undelete" a user.

I re-inserted the rows into xf_conversation_user from a backup, using their old userid.

I updated the userid from the old to the new for the owner_user_id and the last_message_user_id.

I rebuilt the conversation cache (and several others)

Still no conversations for this user! Other user's conversations with this individual seem intact but the "conversation participants" list shows "Unknown User".

If anyone can provide some insight into this matter, it would be much appreciated. Are there other tables that require manipulation?

 

[MattM]

Quick update:

I needed to update the user_id in xf_conversation_recipient

All seems well now, hopefully someone else finds this helpful in the future.