PG::ReadOnlySqlTransaction: 错误：无法在只读事务中执行 SELECT

[Shubham_Ranjan]

我想通过在数据浏览器中运行查询并将 closed 字段设置为 true 来关闭一些旧主题。但似乎即使拥有 管理员 权限，我也无法修改数据。有没有办法可以在不逐个手动关闭这些主题的情况下完成此操作？

系统总是报错：PG::ReadOnlySqlTransaction: ERROR: 无法在只读事务中执行 SELECT

[RGJ (Richard - Communiteq)]

That’s why it’s called data explorer and not the data modifier

[Shubham_Ranjan]

HI @RGJ,

Thanks for you response

@Shubham_Ranjan

I wanted to close some old topics

Is there any way I can accomplish this ?

[bts (Brendan Schlagel)]

I haven’t used it yet but if for running direct SQL queries I believe this is what you’re looking for! —

New official direct SQL access API for Discourse (mini_sql)

I just finished “officializing” and “extracting” our direct DB access helpers in Discourse. I would like to cover what was done and what this means to plugin authors and core contributors. From the very first version of Discourse, @eviltrout introduced some helpers internally for safely executing direct SQL in Discourse. It looked like this. ActiveRecord::Base.exec_sql("select * from topics where id = :id", id: 1) # or Topic.exec_sql("select * from topics where id = :id", id: 1) This is a p…

[pfaffman (Jay Pfaffman)]

@Shubham_Ranjan

I wanted to close some old topics by running a query

You can do it from the rails console. There are some howto topics for doing mass changes to various settings.