PG::ReadOnlySqlTransaction: ERRORE: impossibile eseguire SELECT in una transizione di sola lettura

[Shubham_Ranjan]

Volevo chiudere alcuni vecchi argomenti eseguendo una query in Data Explorer e impostando il campo closed su true tramite una query. Sembra che non possa modificare i dati, nemmeno con i privilegi di amministratore. Esiste un modo per farlo senza dover chiudere manualmente gli argomenti uno per uno?

Viene sempre restituito un errore: PG::ReadOnlySqlTransaction: ERRORE: impossibile eseguire SELECT in una transizione di sola lettura

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