Jump to content

UnArchive topics


Loren

Recommended Posts

Hi Loren, this is a little of a catch 22 here with the unarchiving and moving, you first need to unarchive all topics, then move them, however if you re-enable archiving at that point, those topics won't be re-archived. If a topic is unarchived, the system thinks it was done for a reason and won't archive that topic again.

 

This isn't ideal in my opinion and leave room for improvement, if you wanted, after unarchiving, we could reset that flag, to clear it, then it would re-archive according to the rules you have set.

 

Let me know if you have any questions, thank you 

Link to comment
Share on other sites

14,382 topics to unarchive.

 

So if I did

UPDATE `ibf_topics` SET `topic_archive_status` = '0' WHERE `topic_archive_status` = '1'

then did a "Resynchronize Topics".

Wouldn't that do it?

Edited by Loren
Link to comment
Share on other sites

Loren, I would very much not recommend doing that. Yes, it will "unflag" the topics as Archived, however the posts for that topic will still be contained within the forums_archive_posts table, and will really break them considerably.

 

When a topic is flagged as "Not Archived" then it does not reference the forums_archive_posts table at all, so the topics would not display ANY posts if that query were run without the unarchival process having fully completed.

 

Your best bet is to just wait it out, as that is the only surefire way to ensure everything is unarchived properly. :)

  • Like 1

Ryan Ashbrook

Tier II Technical Support

Invision Power Services, Inc.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...