Invision Community 5: A video walkthrough creating a custom theme and homepage By Matt Thursday at 04:02 PM
xdmin Posted August 19, 2021 Posted August 19, 2021 I need to mass move topics and have found a way I think will work. In the database table forums_topics I plan on move all topics containing a keyword in "title" and change "forum_id" from 909 to "forum_id" 414. This successfully moved a topic from one sub forum to another. Is there anything else I need to think of when doing this? Are there any other dependencies that might crash this method?
WP V0RT3X Posted August 19, 2021 Posted August 19, 2021 (edited) ... Edited August 19, 2021 by Darth Vortex
Daniel F Posted August 19, 2021 Posted August 19, 2021 13 minutes ago, xdmin said: Is there anything else I need to think of when doing this? Please avoid to change any data direct in the DB. By changing the forum id in the topics table you're missing to rebuild: Search Index Tag Index Container Counts Last Item & Last Comment Data Total Posts from the author
xdmin Posted August 19, 2021 Author Posted August 19, 2021 @Daniel F Thanks for the helpful response. Thats exactly what I needed to hear. Since this task is more complex than I'm comfortable with. Are there any ways to hire Invision/others here to do such a job?
Nathan Explosion Posted August 19, 2021 Posted August 19, 2021 (edited) What is the criteria for the topics to be moved? All? Some - how many, and how are you identifying them? Edited August 19, 2021 by Nathan Explosion
xdmin Posted August 19, 2021 Author Posted August 19, 2021 The topics are being identified by a keyword in the title. I will make a list of tasks, like If title contains "word1", then move to forum_id: 4 If title contains "word2", then move to forum_id: 8 If title contains "word5", then move to forum_id: 100
Recommended Posts