PG::ReadOnlySqlTransaction: ERROR: cannot execute SELECT in a read-only transaction

[Shubham_Ranjan]

I wanted to close some old topics by running a query in data explorer and setting the closed field to true by running a query. It appears that I cannot modify the data even with admin rights. Is there any way I can accomplish this without having to individually close such topics one by one ?

It always throws an error : 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

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)]

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.