I found this post with instructions on how to use the rails console to mass close topics: Auto-close old topics from a migrated forum - #10 by zogstrip A couple of questions about it, though: Is there a newer way to do this? If I wanted to do the close based on the last activity date (rather tha…

I did end up setting up a staging server (was pretty easy to do, actually - just restored a backup from prod and logged in using the admin recovery procedure, since it’s configured for OIDC only). Looks like we have about 160K topics, and a quick test on just one category with about 7500 took 6 min…

On #2, using the data explorer plugin (which I wasn’t aware of), it looks like updated_at is probably the value where the ‘last reply timestamp’ would be. Is that an accurate assessment?

[image] Administrative Bulk Operations sysadmin Below you will find a collection of bulk operations that can be initiated from the command line. You will need SSH access, so if you are a hosted customer, you will need to contact the Discourse team about running these comma…

Thanks for this pointer - that’s very useful for my first three questions, I think. Would appreciate some clarity on updated_at and planning to operate on our extended history of posts & topics.

[image] hendersj: Just trying to make sure (with #4) that we don’t impact system performance too much. I’d definitely test with a small batch first. I’ve, uh, taken down a community site with bulk actions and wished I tested a subset first. [image] Calvin and Hobbes by Bill Watterso…

Thanks - I suspected that might be the case. Good to have confirmation on the approach. I think what I may do is see about pulling one of the recent backups and setting up a sandbox environment separate from my test environment. Not sure how the SSO piece will work in that setup, but it would be …

That’s a good idea: [image] Set up a staging server Sysadmins There are several tricks that can help when you are setting up a staging server. What is a staging server? A staging server is essentially a clone of a production site. It also resides on a server,…

Definitely - appreciate the pointer to the staging server post as well - that will be quite helpful. Yeah, user load is not likely to be a huge issue - looks like our page views per day is around 50K on average across all (crawlers, anonymous, and registered users). Understanding the potential inc…

Mass closing topics

Support

ondrej February 3, 2024, 12:16am 3

Topic		Replies	Views
Auto-close old topics from a migrated forum Migration rails-console	12	3073	November 16, 2015
Mass close topics? Support	9	2277	June 27, 2023
Need To Reopen All Topics! Support	3	1015	May 24, 2021
Mass close existing topics older than x? Support	5	115	September 26, 2024
Administrative Bulk Operations Self-Hosting configuring , reference	8	14119	February 25, 2026

Mass closing topics

Related topics