Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted September 5, 20231 yr What's the 'proper' way to undo this? Here's the topic, and the second post should be the OP. https://stepmodifications.org/forum/topic/17510-dyndolod-300-alpha-142/ Source Topic: https://stepmodifications.org/forum/topic/19046-dyndolod-hangs Ideally, I'd like to undo this merge action, but I don't see a way to do that. I can manually do things at the DB level via phpMyAdmin or MySQL, but this might cause PK/FK issues or other unintended consequences. I searched the forums, but found nothing useful ... this MUST be a recurring problem, so hoping for a fast solution. Edited September 5, 20231 yr by z929669
September 5, 20231 yr Unfortunately, there is no undo back to what you had prior to the merge other than a full database restore. If you don’t want to do that, you can manually split each post that was merged into a new topic. That will be time consuming if there are a lot of posts though.
September 5, 20231 yr Author On 9/5/2023 at 5:54 PM, Jim M said: Unfortunately, there is no undo back to what you had prior to the merge other than a full database restore. If you don’t want to do that, you can manually split each post that was merged into a new topic. That will be time consuming if there are a lot of posts though. It's only a single post replacing the OP I want to get back. The problem is that it's the OP I want to get rid of. Can I somehow just delete it so the OP (now the second post) is restored?
September 5, 20231 yr On 9/5/2023 at 5:56 PM, z929669 said: It's only a single post replacing the OP I want to get back. The problem is that it's the OP I want to get rid of. Can I somehow just delete it so the OP (now the second post) is restored? You cannot. As the OP was changed in this action because it is the older date.
September 5, 20231 yr Author On 9/5/2023 at 5:57 PM, Jim M said: You cannot. As the OP was changed in this action because it is the older date. So I assume I must split the entire Topic starting at the second post then? (first creating a placeholder topic). To restore the source topic, I would then maybe merge the now defunct topic?
September 5, 20231 yr Yes, if you want everything else to be part of a topic but that first post, that would need to be done.
September 5, 20231 yr Author Solution Simplest solution was to manually edit the relevant two records in forum_posts and forum_topics, keeping the original record IDs intact but changing all other variables. Then I simply deleted the second post. I previously copied the defunct OP into the new OP of the source.
September 5, 20231 yr On 9/5/2023 at 7:21 PM, z929669 said: Simplest solution was to manually edit the relevant two records in forum_posts and forum_topics, keeping the original record IDs intact but changing all other variables. Then I simply deleted the second post. I previously copied the defunct OP into the new OP of the source. Keep in mind that a manual edit of your database is not recommended or supported (Any issues resulting from this change will not be supported.) so while that may work for you, it is not something we suggest.