We have a use case where we need to close all existing topics and unlist them. I have closed all topics using the rails console by executing Topic.where(closed: false).find_each do |topic| topic.update_status("closed", true, Discourse.system_user) end But, when I try to do the same to unlist topics by executing topic.update_status("unlisted", true, Discourse.system_user) I get this error: ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR: column "unlisted" of relation "topics" does not exist LINE 1: UPDATE "topics" SET "unlisted" = 't' WHERE "topics"."id" = 1 From which I understand that there is no unlisted column for the topic object. How can I unlist a topic using console?

I believe you are looking for “visible”. But don’t let me stop you from learning about the database before you start running queries against it. Please save a backup just in case you need it later.

I don’t have much idea :grin: and shouldn’t say anything, but what came to me was maybe try "listed" column and set to false? at least something to try until someone else sees :grin: (or I find something while peeking around) Edit: I think I can see things like closed, visible, enabled, archived, disabled and autoclosed in /apps/models/topic_status_update.rb but again, I have no idea :slight_smile:

I tried the listed column. That one also does not exist. I am trying to get a peek into the table using phppgadmin now

[imagem] shahidh: I am trying to get a peek into the table a great idea :smiley:

Unlist a topic using rails console

Product Support

shahidh (Shahidh K Muhammed) 23 Janeiro , 2017 06:39 6

visible it is.

topic.update_status("visible", false, Discourse.system_user)

Thanks guys

Tópico		Respostas	Vistas
Unlisting a topic in the ruby console Development unlisting	1	523	21 Janeiro , 2019
Unlisted option on creation of a new topic Feature unlisting	5	3941	30 Março , 2016
Unlisted only means not listed in topics list Announcements unlisting	0	1505	22 Agosto , 2017
Unlisted topics become listed via references Bug unlisting	9	1834	22 Agosto , 2017
Error: PG::UndefinedColumn. Custom field not creating column Product Support	4	1661	11 Agosto , 2021

Unlist a topic using rails console

Related topics