Jump to content
Loren

UnArchive topics

Recommended Posts

Rhett,

 

Do you know the SQL to unarchive topics?

I want to reorganize some sub-forums and you need to unarchive to be allowed to do that.

 

Thanks in advance!

Share this post


Link to post
Share on other sites

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 

Share this post


Link to post
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

Share this post


Link to post
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.

Share this post


Link to post
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...