z929669 Posted September 5, 2023 Share Posted September 5, 2023 (edited) 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, 2023 by z929669 Link to comment Share on other sites More sharing options...
Jim M Posted September 5, 2023 Share Posted September 5, 2023 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. Link to comment Share on other sites More sharing options...
z929669 Posted September 5, 2023 Author Share Posted September 5, 2023 Just now, 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? Link to comment Share on other sites More sharing options...
Jim M Posted September 5, 2023 Share Posted September 5, 2023 Just now, 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. Link to comment Share on other sites More sharing options...
z929669 Posted September 5, 2023 Author Share Posted September 5, 2023 Just now, 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? Link to comment Share on other sites More sharing options...
Jim M Posted September 5, 2023 Share Posted September 5, 2023 Yes, if you want everything else to be part of a topic but that first post, that would need to be done. Link to comment Share on other sites More sharing options...
Solution z929669 Posted September 5, 2023 Author Solution Share Posted September 5, 2023 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. Link to comment Share on other sites More sharing options...
Jim M Posted September 5, 2023 Share Posted September 5, 2023 10 minutes ago, 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. z929669 1 Link to comment Share on other sites More sharing options...
Recommended Posts