How do I unarchive all my archived topics?

[PoC2]

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]

Disable archive function? 🤔

 

Edited May 21, 2020 by DawPi

[PoC2]

I did that, but many are still archived.

[Miss_B]

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;

 

[PoC2]

Thank you!

[Morrigan]

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]

The ACP says that no background processes are running.

[Morrigan]

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.

[PoC2]

Not working for me.

May have to submit a ticket.

[Morrigan]

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]

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]

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]

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]

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.

[bfarber]

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.