Uninstalling Babble Part 2: Groups

Uninstalling Babble results in many, many, maybe hundreds of tiny user groups, mostly with two people in it, some even with 1 or 0.
And they show up as recommended topics.
Reinstalling babble makes them disappear.

However, I had a good reason to uninstall it so reinstalling is not a workaround for me. (and besides this would be a strange way to go about something like this imo).

3 Likes

4 posts were split to a new topic: Uninstalling Babble Part 1: Removing chats you no longer need.

Groups are the concern at least for me. Uninstalling babble makes /g unusable.

1 Like

Mark we’ll follow up on groups.

1 Like

FYI I was referring to this OP: Weird looking non-existent topics in recommended topics due to babble plugin - support - Discourse Meta

I had made an assumption this was the same user :). Hard to tell across instances sometimes.

1 Like

Mark, on rails console, does this return anything?:

Group.where('visibility_level = ?', 999)

4 Likes

Yes, that seems to capture the groups. The dates of .first and .last corresponded to the period babble was enabled. Destroying them cleaned up /g.

Group.where('visibility_level = ?', 999).count
=> 121

Group.where('visibility_level = ?', 999).find_each do |group|
  group.destroy
end

Group.where('visibility_level = ?', 999).count
=> 0

I did this on a test site. Let me know if there are any concerns before doing it on the production site. Thank you.

2 Likes

Hi Robert! I just removed babble from my app.yml and am seeing lots of extra groups. I do see results when I run this - see below. Looks like there 6 babble groups. I’d like to remove them all. Can you confirm that this rails command will do the job without affecting other groups? I’m a bit weak on rails skills. :pray:

Results
root@community:/var/discourse# ./launcher enter app

root@community-app:/var/www/discourse# rails c

[1] pry(main)> **Group**.where(**'**visibility_level = ?**'**, **999**)

=> [#<Group:0x00007f29809e21f8

id: **160**,

name: **"**2d57bade09539c7d6b56c168fa3c5b95**"**,

created_at: **Fri**, **20** **Sep** **2019** **15**:**00**:**38.392626000** **UTC** **+00**:**00**,

updated_at: **Fri**, **20** **Sep** **2019** **15**:**00**:**38.392626000** **UTC** **+00**:**00**,

automatic: **false**,

user_count: **2**,

automatic_membership_email_domains: **nil**,

primary_group: **false**,

title: **nil**,

grant_trust_level: **nil**,

incoming_email: **nil**,

has_messages: **false**,

flair_bg_color: **nil**,

flair_color: **nil**,

bio_raw: **nil**,

bio_cooked: **nil**,

allow_membership_requests: **false**,

full_name: **nil**,

default_notification_level: **3**,

visibility_level: **999**,

public_exit: **false**,

public_admission: **false**,

membership_request_template: **nil**,

messageable_level: **0**,

mentionable_level: **0**,

members_visibility_level: **0**,

publish_read_state: **false**,

flair_icon: **nil**,

flair_upload_id: **nil**,

smtp_server: **nil**,

smtp_port: **nil**,

smtp_ssl: **nil**,

imap_server: **nil**,

imap_port: **nil**,

imap_ssl: **nil**,

imap_mailbox_name: **""**,

imap_uid_validity: **0**,

imap_last_uid: **0**,

email_username: **nil**,

email_password: **nil**,

imap_last_error: **nil**,

imap_old_emails: **nil**,

imap_new_emails: **nil**,

allow_unknown_sender_topic_replies: **false**>,

#<Group:0x00007f297bb3d9f8

id: **159**,

name: **"**b21a074605d5e3d45f89e526000d6971**"**,

created_at: **Fri**, **20** **Sep** **2019** **14**:**48**:**56.533384000** **UTC** **+00**:**00**,

updated_at: **Fri**, **20** **Sep** **2019** **14**:**48**:**56.533384000** **UTC** **+00**:**00**,

automatic: **false**,

user_count: **1**,

automatic_membership_email_domains: **nil**,

primary_group: **false**,

title: **nil**,

grant_trust_level: **nil**,

incoming_email: **nil**,

has_messages: **false**,

flair_bg_color: **nil**,

flair_color: **nil**,

bio_raw: **nil**,

bio_cooked: **nil**,

allow_membership_requests: **false**,

full_name: **nil**,

default_notification_level: **3**,

visibility_level: **999**,

public_exit: **false**,

public_admission: **false**,

membership_request_template: **nil**,

messageable_level: **0**,

mentionable_level: **0**,

members_visibility_level: **0**,

publish_read_state: **false**,

flair_icon: **nil**,

flair_upload_id: **nil**,

smtp_server: **nil**,

smtp_port: **nil**,

smtp_ssl: **nil**,

imap_server: **nil**,

imap_port: **nil**,

imap_ssl: **nil**,

imap_mailbox_name: **""**,

imap_uid_validity: **0**,

imap_last_uid: **0**,

email_username: **nil**,

email_password: **nil**,

imap_last_error: **nil**,

imap_old_emails: **nil**,

imap_new_emails: **nil**,

allow_unknown_sender_topic_replies: **false**>,

#<Group:0x00007f297bb3d6d8

id: **157**,

name: **"**59a743bc6d393f6b2c6feed49590e83f**"**,

created_at: **Fri**, **20** **Sep** **2019** **14**:**47**:**34.563830000** **UTC** **+00**:**00**,

updated_at: **Fri**, **20** **Sep** **2019** **14**:**47**:**34.563830000** **UTC** **+00**:**00**,

automatic: **false**,

user_count: **1**,

automatic_membership_email_domains: **nil**,

primary_group: **false**,

title: **nil**,

grant_trust_level: **nil**,

incoming_email: **nil**,

has_messages: **false**,

flair_bg_color: **nil**,

flair_color: **nil**,

bio_raw: **nil**,

bio_cooked: **nil**,

allow_membership_requests: **false**,

full_name: **nil**,

default_notification_level: **3**,

visibility_level: **999**,

public_exit: **false**,

public_admission: **false**,

membership_request_template: **nil**,

messageable_level: **0**,

mentionable_level: **0**,

members_visibility_level: **0**,

publish_read_state: **false**,

flair_icon: **nil**,

flair_upload_id: **nil**,

smtp_server: **nil**,

smtp_port: **nil**,

smtp_ssl: **nil**,

imap_server: **nil**,

imap_port: **nil**,

imap_ssl: **nil**,

imap_mailbox_name: **""**,

imap_uid_validity: **0**,

imap_last_uid: **0**,

email_username: **nil**,

email_password: **nil**,

imap_last_error: **nil**,

imap_old_emails: **nil**,

imap_new_emails: **nil**,

allow_unknown_sender_topic_replies: **false**>,

#<Group:0x00007f297bb3d458

id: **158**,

name: **"**9e42332af074d50fb6218a9f4004ec1b**"**,

created_at: **Fri**, **20** **Sep** **2019** **14**:**47**:**52.854622000** **UTC** **+00**:**00**,

updated_at: **Fri**, **20** **Sep** **2019** **14**:**47**:**52.854622000** **UTC** **+00**:**00**,

automatic: **false**,

user_count: **1**,

automatic_membership_email_domains: **nil**,

primary_group: **false**,

title: **nil**,

grant_trust_level: **nil**,

incoming_email: **nil**,

has_messages: **false**,

flair_bg_color: **nil**,

flair_color: **nil**,

bio_raw: **nil**,

bio_cooked: **nil**,

allow_membership_requests: **false**,

full_name: **nil**,

default_notification_level: **3**,

visibility_level: **999**,

public_exit: **false**,

public_admission: **false**,

membership_request_template: **nil**,

messageable_level: **0**,

mentionable_level: **0**,

members_visibility_level: **0**,

publish_read_state: **false**,

flair_icon: **nil**,

flair_upload_id: **nil**,

smtp_server: **nil**,

smtp_port: **nil**,

smtp_ssl: **nil**,

imap_server: **nil**,

imap_port: **nil**,

imap_ssl: **nil**,

imap_mailbox_name: **""**,

imap_uid_validity: **0**,

imap_last_uid: **0**,

email_username: **nil**,

email_password: **nil**,

imap_last_error: **nil**,

imap_old_emails: **nil**,

imap_new_emails: **nil**,

allow_unknown_sender_topic_replies: **false**>,

#<Group:0x00007f297bb3d390

id: **162**,

name: **"**c5c0888042e700c0e884aaa42ca319d6**"**,

created_at: **Fri**, **20** **Sep** **2019** **15**:**05**:**17.680129000** **UTC** **+00**:**00**,

updated_at: **Fri**, **20** **Sep** **2019** **15**:**05**:**17.680129000** **UTC** **+00**:**00**,

automatic: **false**,

user_count: **0**,

automatic_membership_email_domains: **nil**,

primary_group: **false**,

title: **nil**,

grant_trust_level: **nil**,

incoming_email: **nil**,

has_messages: **false**,

flair_bg_color: **nil**,

flair_color: **nil**,

bio_raw: **nil**,

bio_cooked: **nil**,

allow_membership_requests: **false**,

full_name: **nil**,

default_notification_level: **3**,

visibility_level: **999**,

public_exit: **false**,

public_admission: **false**,

membership_request_template: **nil**,

messageable_level: **0**,

mentionable_level: **0**,

members_visibility_level: **0**,

publish_read_state: **false**,

flair_icon: **nil**,

flair_upload_id: **nil**,

smtp_server: **nil**,

smtp_port: **nil**,

smtp_ssl: **nil**,

imap_server: **nil**,

imap_port: **nil**,

imap_ssl: **nil**,

imap_mailbox_name: **""**,

imap_uid_validity: **0**,

imap_last_uid: **0**,

email_username: **nil**,

email_password: **nil**,

imap_last_error: **nil**,

imap_old_emails: **nil**,

imap_new_emails: **nil**,

allow_unknown_sender_topic_replies: **false**>,

#<Group:0x00007f297bb3d2c8

id: **161**,

name: **"**4c0f405c3af5db905fe24d9a621709be**"**,

created_at: **Fri**, **20** **Sep** **2019** **15**:**01**:**58.626582000** **UTC** **+00**:**00**,

updated_at: **Fri**, **20** **Sep** **2019** **15**:**01**:**58.626582000** **UTC** **+00**:**00**,

automatic: **false**,

user_count: **1**,

automatic_membership_email_domains: **nil**,

primary_group: **false**,

title: **nil**,

grant_trust_level: **nil**,

incoming_email: **nil**,

has_messages: **false**,

flair_bg_color: **nil**,

flair_color: **nil**,

bio_raw: **nil**,

bio_cooked: **nil**,

allow_membership_requests: **false**,

full_name: **nil**,

default_notification_level: **3**,

visibility_level: **999**,

public_exit: **false**,

public_admission: **false**,

membership_request_template: **nil**,

messageable_level: **0**,

mentionable_level: **0**,

members_visibility_level: **0**,

publish_read_state: **false**,

flair_icon: **nil**,

flair_upload_id: **nil**,

smtp_server: **nil**,

smtp_port: **nil**,

smtp_ssl: **nil**,

imap_server: **nil**,

imap_port: **nil**,

imap_ssl: **nil**,

imap_mailbox_name: **""**,

imap_uid_validity: **0**,

imap_last_uid: **0**,

email_username: **nil**,

email_password: **nil**,

imap_last_error: **nil**,

imap_old_emails: **nil**,

imap_new_emails: **nil**,

allow_unknown_sender_topic_replies: **false**>,

#<Group:0x00007f297bb3d110

id: **163**,

name: **"**6303a6ab66fe8587b69f7ca205d17794**"**,

created_at: **Fri**, **20** **Sep** **2019** **15**:**07**:**34.038308000** **UTC** **+00**:**00**,

updated_at: **Fri**, **20** **Sep** **2019** **15**:**07**:**34.038308000** **UTC** **+00**:**00**,

automatic: **false**,

user_count: **1**,

automatic_membership_email_domains: **nil**,

primary_group: **false**,

title: **nil**,

grant_trust_level: **nil**,

incoming_email: **nil**,

has_messages: **false**,

flair_bg_color: **nil**,

flair_color: **nil**,

bio_raw: **nil**,

bio_cooked: **nil**,

allow_membership_requests: **false**,

full_name: **nil**,

default_notification_level: **3**,

visibility_level: **999**,

public_exit: **false**,

public_admission: **false**,

membership_request_template: **nil**,

messageable_level: **0**,

mentionable_level: **0**,

members_visibility_level: **0**,

publish_read_state: **false**,

flair_icon: **nil**,

flair_upload_id: **nil**,

smtp_server: **nil**,

smtp_port: **nil**,

smtp_ssl: **nil**,

imap_server: **nil**,

imap_port: **nil**,

imap_ssl: **nil**,

imap_mailbox_name: **""**,

imap_uid_validity: **0**,

imap_last_uid: **0**,

email_username: **nil**,

email_password: **nil**,

imap_last_error: **nil**,

imap_old_emails: **nil**,

imap_new_emails: **nil**,

allow_unknown_sender_topic_replies: **false**>]