Invision Community 5: A video walkthrough creating a custom theme and homepage By Matt Yesterday at 04:02 PM
PoC2 Posted May 21, 2020 Posted May 21, 2020 I archived a fair number of site topics a few years ago when I needed to be careful with my site resources. I'd now like to unarchive everything. Is there a simple way to mass unarchive? Running 4.4.10 Many thanks for any info.
DawPi Posted May 21, 2020 Posted May 21, 2020 (edited) Disable archive function? 🤔 Edited May 21, 2020 by DawPi
Miss_B Posted May 21, 2020 Posted May 21, 2020 28 minutes ago, PoC2 said: I did that, but many are still archived. You can unarchive all your topics by running this sql query. UPDATE forums_topics SET topic_archive_status = 0;
Morrigan Posted May 21, 2020 Posted May 21, 2020 I don't recommend that. Let the unarchiving process do its work especially if you moved topics to another table in the database. Its probably running background processes and taking its time to do the work to not affect your sites performance.
PoC2 Posted May 21, 2020 Author Posted May 21, 2020 The ACP says that no background processes are running.
Morrigan Posted May 21, 2020 Posted May 21, 2020 Then submit a ticket. Trying to take the short route could negatively impact your site and upgrades. Turning off archiving initializes a process or task that takes archived topics and makes them non-archived again. I've personally done this at least twice and know that turning it off works. DawPi 1
Morrigan Posted May 21, 2020 Posted May 21, 2020 Its the best route, trust me. They can determine the issue and assist you better than any of us here without access to your site.
Miss_B Posted May 21, 2020 Posted May 21, 2020 40 minutes ago, Morrigan said: I don't recommend that. Let the unarchiving process do its work especially if you moved topics to another table in the database. Its probably running background processes and taking its time to do the work to not affect your sites performance. How can topics be moved to another table in the database? Afaik that is not possible...
Morrigan Posted May 21, 2020 Posted May 21, 2020 Its one of the settings in the archive process @Miss_B So first off it moves them to a separate table no matter what (the purpose of archiving) or you can move it to a completely different database (the second option there). So again, quick fixes are actually more damaging than you are assuming. Miss_B 1
Miss_B Posted May 21, 2020 Posted May 21, 2020 2 minutes ago, Morrigan said: Its one of the settings in the archive process @Miss_B So first off it moves them to a separate table no matter what (the purpose of archiving) or you can move it to a completely different database (the second option there). So again, quick fixes are actually more damaging than you are assuming. Thanks for the screenshot. I was not aware of this. I assume that the archived topics will be moved to a separate table within the database as sort of backup. But the question is, will they be gone from the forums_topics table as well? I doubt it though, because the archived field indicates that not to be the case.
Morrigan Posted May 21, 2020 Posted May 21, 2020 They are last time I checked. The Archived field IIRC is more for whether or not you've removed something from the archive that was archived, manually. Its intended to make sure that it doesn't re-archive something that you resurrected from the archive. Miss_B 1
bfarber Posted May 22, 2020 Posted May 22, 2020 You cannot just run a query on the topics table to unarchive. The post content is moved out of forums_posts and placed into another table (which can be in a separate database as mentioned). The posts need to be moved back. Disabling the feature should cause a task (NOT a background process) to unarchive everything. Morrigan 1
Recommended Posts