# 更改所有类别的默认自动关闭设置

**URL:** <https://meta.discourse.org/t/change-default-auto-close-on-all-categories/114841>\
**Category:** Product Support\
**Created:** [2019 年4 月 12 日 09:29 UTC](https://meta.discourse.org/t/change-default-auto-close-on-all-categories/114841 "2019-04-12T09:29:54Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

作者： ![wjjjjt](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/wjjjjt/32/138195_2.png) [@wjjjjt](https://meta.discourse.org/u/wjjjjt)\
发布日期： [2019 年4 月 12 日 09:29 UTC](https://meta.discourse.org/t/change-default-auto-close-on-all-categories/114841/1 "2019-04-12T09:29:54Z")

</div>

[We](https://community.endlessos.com/)’ve found that our users like to add new comments on very old topics, often only tangentially related to their problem. I would like to set all categories to auto-close topics some time after the last post (7 days – just for the sake of argument!).

I have found [this thread](https://meta.discourse.org/t/apply-auto-close-to-existing-topics/70450) on how to apply a new auto-close configuration to existing topics, but I can’t find any way to adjust the auto-close configuration for all categories. I don’t especially want to do this by hand for two dozen (sub-)categories or so.

Perhaps it’d be safe to `UPDATE categories SET auto_close_hours = 168, auto_close_based_on_last_post = true;` if I had access to the database?

---

_[View the full topic](https://meta.discourse.org/t/change-default-auto-close-on-all-categories/114841)._