Day_ Posted February 24, 2015 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'
TSP Posted February 24, 2015 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?
Day_ Posted February 24, 2015 Author 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
Cabola Posted February 25, 2015 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
Day_ Posted February 25, 2015 Author Posted February 25, 2015 These plugins are for 3 I'm running 4.0 rc 2
Cabola Posted February 25, 2015 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!
Genadii Skaraev Posted October 19, 2015 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?
Recommended Posts
Archived
This topic is now archived and is closed to further replies.