Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
PaleoCris Posted May 5, 2017 Posted May 5, 2017 Okay, so here's my problem... A few years back, two members on my community began exchanging messages. Nearly 500 pages of messages and quite a few years later and they have literally traveled across the world (Australia to the US), met up, developed a relationship, they became engaged and are planning marriage. They still converse through the original conversation on my site, though. Yesterday, the woman accidentally deleted the 500 page message while trying to delete something else and the guy isn't able to add her back into it. Neither am I. Any ideas how I can restore her to the message? I thought I might be able to go into the database via phpMyAdmin and find her member ID number in the message, remove it (or change it to another member) and have him just add her back into it....But it doesn't seem that simple. I set up a test PM and am able to easily change who the author of the individual messages is, edit the contents of the message, etc...I just don't see how to completely remove somebody from a message so it isn't remembered that they were ever part of the conversation so they can be readded. Can anybody think of how to do this? Could I have them create a new account, merge all their content into the new account, change the name back to the original and have him add her back in? Or is there a simpler solution to this? Thanks for the help. If it wasn't such a sentimental thing to them, I wouldn't be that worried about it. -Cris
Adriano Faria Posted May 5, 2017 Posted May 5, 2017 You can add her back via database or even removing this restriction via file/template edit. Can't help you now. If no one else does, I'll try tomorrow.
PaleoCris Posted May 5, 2017 Author Posted May 5, 2017 Thank you Adriano! I just spent some more time in the database trying to get it figured out, then tried to find the file to edit, without success. At least I try.
Morrigan Posted May 5, 2017 Posted May 5, 2017 It's in the table: core_message_topic_user_map Find the ID of the conversation (should be in the URL of it). In this table look for that number under map_topic_id and change the 0 to a 1 where her map_user_id matches her user ID number. That should fix it. @PaleoCris
PaleoCris Posted May 5, 2017 Author Posted May 5, 2017 Morrigan, You got it! Thanks for the help. I've never had the need to go wading around manually in the database before. I was in that same table earlier, looking at the same conversation ID, just couldn't find her ID, only his. Didn't realize two rows are created, one for each member in the conversation. I just went a page back and found what I needed. Thanks again! They will be very glad to be able to continue their conversation there. -Cris
Recommended Posts
Archived
This topic is now archived and is closed to further replies.