1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Recovering Conversations for Previously Deleted User

Discussion in 'General PHP and MySQL Discussions' started by MattM, Jan 20, 2015.

  1. MattM

    MattM Member

    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?
    Last edited: Jan 20, 2015
  2. MattM

    MattM Member

    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.

Share This Page