PG::ReadOnlySqlTransaction: エラー：読み取り専用トランザクション内で SELECT を実行できません

[Shubham_Ranjan]

古いトピックを閉じたいと思い、Data Explorer でクエリを実行して closed フィールドを true に設定しようとしたのですが、管理者権限があってもデータを変更できないようです。トピックを個別に一つずつ閉じることなく、この作業を完了する方法はありますか？

常に以下のエラーが表示されます：PG::ReadOnlySqlTransaction: ERROR: cannot execute SELECT in a read-only transaction

[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.