PG::ReadOnlySqlTransaction: خطأ: لا يمكن تنفيذ SELECT في معاملة للقراءة فقط

[Shubham_Ranjan]

أردت إغلاق بعض المواضيع القديمة بتشغيل استعلام في مستكشف البيانات وتعيين حقل الإغلاق إلى 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.