通过数据库查询更改许多用户的界面语言？

[jahan_gagan]

您不能通过数据浏览器插件运行 UPDATE 查询，因为它严格限制为只读。

对于此类批量更新，请改用 Rails 控制台：

User.where(locale: 'en').update_all(locale: 'en_GB')

有关批量更新用户偏好的更多示例，请参阅：

Edit a user preference for everyone or a subset of users

This guide explains how to edit a user preference for everyone or a subset of users in Discourse. Required user level: System Administrator Console access is required. If you need to update the user preference for all of your users or a large subset of users, you can do so via the rails console. Summary In this guide, you’ll learn: How to access the Rails console for making bulk changes Examples of modifying user preferences How to identify set…