Day_ Posted February 24, 2015 Share Posted February 24, 2015 I archived a load of posts, later unarchived them to edit the threads and move a few around...didn't realise I wouldn't be able to archive them again. I'm looking to rearchive them again if possible to decrease the post table and hopefully speed things up a bit, now I know there is no reset archive button so I'm looking at a SQL query, I can see in forums_topics I have topic_archive_status 3 Would the below query reset the archive status so I can go again? like I say I know this isn't supported and I would take a backup first, I've looked in the post table but not seeing any archive status, am I missing anything else?UPDATE `forums_topics` SET `topic_archive_status` = '0' WHERE `topic_archive_status` = '3' Link to comment Share on other sites More sharing options...
TSP Posted February 24, 2015 Share Posted February 24, 2015 Don't run queries like that. There is a lot more going on behind the scenes than a simple query like that. You would likely cause the system to be confused, lose control of posts etc.I doubt there is anything stopping you from rearchiving them again. But this is done at the archive page in ACP. What have you tried? Link to comment Share on other sites More sharing options...
Day_ Posted February 24, 2015 Author Share Posted February 24, 2015 I've set any threads which haven't been posted in for 2 years to be archived, in all forums, no restrictions at all. 0 threads are being archived Link to comment Share on other sites More sharing options...
Cabola Posted February 25, 2015 Share Posted February 25, 2015 There actually exists 2 mods for the archive system, and both are free, one does the re-archive trick the other has some more options plus the re-archive feature.Re-Archive Topics by Adriano Faria - http://community.invisionpower.com/files/file/6987-re-archive-topics/This hook will allow users from selected groups to re-archive unarchived topics. A log entry will be created on Moderator Logs when someone use the feature.(Wolf) Archive Options by Wolfie - http://community.invisionpower.com/files/file/5973-wolf-archive-options/It adds options to the 'Topic Moderation' menu (when in Topic View) to allow you to flag a topic to be archived (or re-archived), or to exclude it from being archived or if it's been restored, to allow it to be automatically archived by the system. #2 haven't been lightly tested and is in alpha stage. So if you're only after an re-archive feature then I'd choose #1 Link to comment Share on other sites More sharing options...
Day_ Posted February 25, 2015 Author Share Posted February 25, 2015 These plugins are for 3 I'm running 4.0 rc 2 Link to comment Share on other sites More sharing options...
Cabola Posted February 25, 2015 Share Posted February 25, 2015 I'm so sorry I didn't even look at the forum this topic was in! But I'm sure they'll be upgraded to v4 too! Link to comment Share on other sites More sharing options...
Genadii Skaraev Posted October 19, 2015 Share Posted October 19, 2015 UPDATE `forums_topics` SET `topic_archive_status` = '0' WHERE `topic_archive_status` = '3' Quote Don't run queries like that. There is a lot more going on behind the scenes than a simple query like that. You would likely cause the system to be confused, lose control of posts etc. Are you sure? Link to comment Share on other sites More sharing options...
.thumb.png.72c24494603afd7a572d55d4a71e4af2.png)
Recommended Posts
Archived
This topic is now archived and is closed to further replies.