Searched before posting: I like ‘Auto Bumping the topics’ to keep topics getting renewed. But I wished that when visitor visited topics, they weren’t shown tens of ‘Automatically Bumped’ msgs. Is there a way to delete them occasionally, manually or automatically (or both)? I’m asking this because I’ve found that at my level, whatever my wish happens to be, the same is mostly already been taken care of.

There is no built-in feature for such a bulk action. You could use a rails script to delete existing auto bump messages, something like: SSH in your server cd /var/discourse ./launcher enter app rails c Post.where("action_code = 'autobumped'").destroy_all :warning: Always do a backup first of course, just in case.

Hi @Bathinda! You can manually click on the delete icon, like any other post:

[image] Coin-coin le Canapin: nually click on the delete icon, like any other Thanks, but that’s not practical way of deleting hundreds of bumping msgs on different topics. I even couldn’t select all ‘bump’ msgs on even one single topic.

That’s good enough. Thank you. Is there some command with which we could first list/see all those msgs before giving the ‘destroy (delete)’ command?

The best way would be to do it from the Discourse interface with Data Explorer: [image] Discourse Data Explorer Plugin discourse2 Summary Discourse Data Explorer allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting. open_book Install Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately. information_source If you’re looking for examples or support for any custom queries, you can find lots of topics in our #data-reporting category under the #sql-query tag. If there’s not one to suit your par… Use the following query: SELECT * from posts WHERE action_code = 'autobumped' [auto bump data explorer query result]

Though the query suggested does show the topics that contain ‘auto-bumped’ msgs in all topics. But it proved of not much help. [image] It just returns hundreds of topics which contain thousands of ‘Auto-Bumped’ msgs, but doesn’t tell how many such msgs exist in how many topics. So, I think, ultimately I’ll have to wield the axe in the ‘dark rooms’ of rails console only (which is a bit intimidating). I’m a bit worrisome because it’ll affect thousands of topics/posts in one go. If only there were some select all button inside topics which would select all the bumping msgs together and we could delete those msgs with one click inside any topic. And if anyone wanted to delete all such msgs in All Topics with just one command only then he’d have to enter ‘rails’. I’m not complaining. I’m just expressing myself.

[image] Coin-coin le Canapin: Post.where(“action_code = ‘autobumped’”).destroy_all Would the 5th line of the rails command told by you would ask or prompt anything before deleting all those posts? Or would it just do what it has been told to do, without any warning etc, or chance of retrieval? If possible, can we delete ‘bumping msgs’ from anyone topic first, instead of deleting from whole website? Also, can you pls suggest/tell any rails command to view some samples of the posts which we’re going to delete? Thanks.

Something like this in the data-explorer may help give an overview: SELECT p.topic_id, COUNT(p.id) AS count FROM posts p WHERE action_code = 'autobumped' GROUP BY p.topic_id ORDER BY count DESC However, I’ll chuck in a word of warning about using the rails console to make changes like these on a live site if you’re inexperienced with it. You may want to spin up a test site and have a practice before diving in. :+1:

Yeah it did solve problem as much as offered by the designers/developers. But I still would like to say that there should be some ‘Admin’ commandj, in the admin settings or in the topic being viewed, to select all 'duplicate (Auto-Bumped) msgs’ in any one topic or all topics and then remove them, whenever admin wished.

Perhaps you could hide those messages with CSS instead? Unfortunately, I don’t think the post-small-action widget currently includes the action type as a CSS class, so you can’t target bump messages specifically. Maybe a theme component could help?

Can we delete all 'Automatically Bumped' msgs in one go?

Product Support

Bathinda (Bathinda Helper) January 9, 2023, 12:13pm 7

Ah!! That’s the query, which would make me happy. Thanks again.

Topic		Replies	Views
Delete deleted-posts permanently in bulk? Product Support	58	7503	December 9, 2021
Batch Delete topics in a category? Feature bulk-actions	47	9300	November 18, 2016
Delete Unreplied Topics plugin Plugin	27	2418	March 15, 2025
Bulk deletion of topics Product Support	8	1010	March 8, 2023
With Discourse AI summary allow option to create a summary, close topic and do not bump the date Feature ai , ai-summarize , reset-bump-date	23	1275	December 2, 2023

Can we delete all 'Automatically Bumped' msgs in one go?

Related topics