# Hot **URL:** https://meta.discourse.org/hot.md?page=1641 [Latest](https://meta.discourse.org/latest.md) · [Categories](https://meta.discourse.org/categories.md) · [Tags](https://meta.discourse.org/tags.md) **Page:** 1642 --- ## [Missing PluginOutlet for some preference tabs](https://meta.discourse.org/t/missing-pluginoutlet-for-some-preference-tabs/274892)
**Author:** [@pangbo](https://meta.discourse.org/u/pangbo)\ **Replies:** 1\ **Last updated:** [August 12, 2023, 12:50pm UTC](https://meta.discourse.org/t/missing-pluginoutlet-for-some-preference-tabs/274892 "2023-08-12T12:50:38Z")
I’m about to add a new setting to the Tracking tab of preferences, but I don’t see any PluginOutlets present in tracking.hbs. I checked other tabs and some tabs like interface, emails have PluginOutlets like user-prefere… --- ## [Broken width responsive mobile](https://meta.discourse.org/t/broken-width-responsive-mobile/274895)
**Author:** [@thaidb](https://meta.discourse.org/u/thaidb)\ **Replies:** 8\ **Last updated:** [August 14, 2023, 4:11pm UTC](https://meta.discourse.org/t/broken-width-responsive-mobile/274895 "2023-08-14T16:11:00Z")
My Discourse is broken width mobile UI, i disable all theme component and plugin but not effect. How can i test and fix ít? Have way comback all setting in Dashboard? Thank you, --- ## [How to deploy secondary / stand-by Discourse?](https://meta.discourse.org/t/how-to-deploy-secondary-stand-by-discourse/274896)
**Author:** [@lejeczek](https://meta.discourse.org/u/lejeczek)\ **Replies:** 2\ **Last updated:** [August 12, 2023, 12:44pm UTC](https://meta.discourse.org/t/how-to-deploy-secondary-stand-by-discourse/274896 "2023-08-12T12:44:59Z")
Hi guys. How does one deploy secondary/stand-by Discourse? I thought that would be rather a common topic but I failed to find anything on that. Such a stand-by Discourse would be - obviously, in my mind, thus trying t… --- ## [Trouble using embedding in dark mode](https://meta.discourse.org/t/trouble-using-embedding-in-dark-mode/274901)
**Author:** [@satonotdead](https://meta.discourse.org/u/satonotdead)\ **Replies:** 3\ **Last updated:** [August 12, 2023, 3:43pm UTC](https://meta.discourse.org/t/trouble-using-embedding-in-dark-mode/274901 "2023-08-12T15:43:01Z")
We are currently forced to use cove.chat on Ghost because the embed Discourse comments can’t be used on dark themes without destroying the entire UI on the comments section. This simple update should be enough for us fo… --- ## [How can I disable the docs item in the 'more' section?](https://meta.discourse.org/t/how-can-i-disable-the-docs-item-in-the-more-section/274904)
**Author:** [@AquaL1te](https://meta.discourse.org/u/AquaL1te)\ **Replies:** 2\ **Last updated:** [August 12, 2023, 4:41pm UTC](https://meta.discourse.org/t/how-can-i-disable-the-docs-item-in-the-more-section/274904 "2023-08-12T16:41:12Z")
How can I disable the menu item in the sidebar (in the ‘more’ section)? I can only disable it in the drop menu where the links to the categories and latest topics are included. --- ## [Are the posts translated automatically?](https://meta.discourse.org/t/are-the-posts-translated-automatically/274905)
**Author:** [@andrei.stoian](https://meta.discourse.org/u/andrei.stoian)\ **Replies:** 1\ **Last updated:** [August 3, 2023, 11:22am UTC](https://meta.discourse.org/t/are-the-posts-translated-automatically/274905 "2023-08-03T11:22:12Z")
Hello, Does the translator automatically translates all posts when added to the forum as in initial step? Or it translates only the posts triggered for translation by a user? Thank you. --- ## [Improving PM notifications (unread/read)](https://meta.discourse.org/t/improving-pm-notifications-unread-read/274906)
**Author:** [@satonotdead](https://meta.discourse.org/u/satonotdead)\ **Replies:** 0\ **Last updated:** [August 12, 2023, 3:40pm UTC](https://meta.discourse.org/t/improving-pm-notifications-unread-read/274906 "2023-08-12T15:40:19Z")
We currently have the same icon for readed and not readed personal messages on our notifications: I think that could be drastically improved showing opened and closed icons, and probably grouping the messages that co… --- ## [1.5X cheers on specific TL's or groups](https://meta.discourse.org/t/1-5x-cheers-on-specific-tls-or-groups/274913)
**Author:** [@satonotdead](https://meta.discourse.org/u/satonotdead)\ **Replies:** 2\ **Last updated:** [August 13, 2023, 4:04pm UTC](https://meta.discourse.org/t/1-5x-cheers-on-specific-tls-or-groups/274913 "2023-08-13T16:04:13Z")
I wonder if you find that (probably) simple feature will add value to Gamification integrations :slight\_smile: The point is just push users to improve their overall engagement to reach more cheers that should enable mor… --- ## [Discourse\_user\_auto\_activation not installing](https://meta.discourse.org/t/discourse-user-auto-activation-not-installing/274914)
**Author:** [@geekyouth](https://meta.discourse.org/u/geekyouth)\ **Replies:** 2\ **Last updated:** [October 4, 2023, 12:43am UTC](https://meta.discourse.org/t/discourse-user-auto-activation-not-installing/274914 "2023-10-04T00:43:34Z")
Plugin name is ‘’, but plugin directory is named ‘discourse\_user\_auto\_activation’ Building Building cleaning up cleaning up cleaning up Cannot read properties of undefined (reading ‘cleanup’) Stack Trace and Error Re… --- ## [Option to Require new Tags to be Reviewed](https://meta.discourse.org/t/option-to-require-new-tags-to-be-reviewed/274924)
**Author:** [@TheDarkWizard](https://meta.discourse.org/u/TheDarkWizard)\ **Replies:** 0\ **Last updated:** [August 13, 2023, 1:30am UTC](https://meta.discourse.org/t/option-to-require-new-tags-to-be-reviewed/274924 "2023-08-13T01:30:24Z")
Hey all, I’d like to suggest the option to require new tags (not previously approved or used before) to go into the flag queue for review by a staff member. This would allow not just writing sites but just about any sit… --- ## [Disable or remove likes from a post](https://meta.discourse.org/t/disable-or-remove-likes-from-a-post/274936)
**Author:** [@FroggyC](https://meta.discourse.org/u/FroggyC)\ **Replies:** 6\ **Last updated:** [August 13, 2023, 7:43pm UTC](https://meta.discourse.org/t/disable-or-remove-likes-from-a-post/274936 "2023-08-13T19:43:01Z")
I’m having an issue where users use likes as a low-stakes way to engage with a toxic post, that has been intervened on by moderators. I wouldn’t like to delete the post, because I’d like the discussion to remain organica… --- ## [Installation Error](https://meta.discourse.org/t/installation-error/274937)
**Author:** [@Wleksion](https://meta.discourse.org/u/Wleksion)\ **Replies:** 1\ **Last updated:** [August 13, 2023, 9:43am UTC](https://meta.discourse.org/t/installation-error/274937 "2023-08-13T09:43:02Z")
install: cannot remove '/swapfile': Operation not permitted fallocate: fallocate failed: Text file busy mkswap: error: /swapfile is mounted; will not make swapspace swapon: /swapfile: swapon failed: Device or resource bu… --- ## [Unable to Setup Google Analytics 4 with Discourse](https://meta.discourse.org/t/unable-to-setup-google-analytics-4-with-discourse/274942)
**Author:** [@Anuj\_Kapoor](https://meta.discourse.org/u/Anuj_Kapoor)\ **Replies:** 2\ **Last updated:** [September 29, 2023, 1:10pm UTC](https://meta.discourse.org/t/unable-to-setup-google-analytics-4-with-discourse/274942 "2023-09-29T13:10:20Z")
I have been trying to setup Google Analytics 4 with my website https://www.proptalks.in but not able to see any data in the GA dashboard. Here are my Discourse settings: The GA dashboard says " No data received from… --- ## [ArgumentError: directory for pid=/.../unicorn.pid not writable](https://meta.discourse.org/t/argumenterror-directory-for-pid-unicorn-pid-not-writable/274948)
**Author:** [@jeanas](https://meta.discourse.org/u/jeanas)\ **Replies:** 42\ **Last updated:** [September 9, 2023, 2:23pm UTC](https://meta.discourse.org/t/argumenterror-directory-for-pid-unicorn-pid-not-writable/274948 "2023-09-09T14:23:35Z")
I’m trying to set up Discourse on a server. I’ve already done it a few times, as I’m testing a script to fix various aspects of the mbox archives from 18 years of mailing list activity before importing them into Discours… --- ## [Quote button on hover is missing](https://meta.discourse.org/t/quote-button-on-hover-is-missing/274955)
**Author:** [@hiddenseal](https://meta.discourse.org/u/hiddenseal)\ **Replies:** 29\ **Last updated:** [September 28, 2023, 5:53pm UTC](https://meta.discourse.org/t/quote-button-on-hover-is-missing/274955 "2023-09-28T17:53:27Z")
After update to 3.2.0.beta1-dev (0187ad0d37), I stopped seeing “Quote” button when I select text I want to quote. The hotkey “q” still works. Occasionally I find the “Quote” button visible in some topics, but after th… --- ## [Flair Giveaways](https://meta.discourse.org/t/flair-giveaways/274966)
**Author:** [@SalladShooter](https://meta.discourse.org/u/SalladShooter)\ **Replies:** 6\ **Last updated:** [August 15, 2023, 12:03pm UTC](https://meta.discourse.org/t/flair-giveaways/274966 "2023-08-15T12:03:56Z")
I think Discourse should add an easy way to give flairs to people instead of adding people to groups. An example I won a flair giveaway and had to be added to a group to get it, but it would be nice if like TL3+ could gi… --- ## [Report on # of emails sent doesn't show data older than 3 months](https://meta.discourse.org/t/report-on-of-emails-sent-doesnt-show-data-older-than-3-months/274972)
**Author:** [@hiddenseal](https://meta.discourse.org/u/hiddenseal)\ **Replies:** 2\ **Last updated:** [August 13, 2023, 10:38pm UTC](https://meta.discourse.org/t/report-on-of-emails-sent-doesnt-show-data-older-than-3-months/274972 "2023-08-13T22:38:04Z")
Is it supposed to be that “emails” report doesn’t show the data older than 3 months? Even if you ask for: /admin/reports/emails?end\_date=2023-08-13&start\_date=2021-01-01.json It gives you data only starting from May 15… --- ## [Chat usage reports endpoint](https://meta.discourse.org/t/chat-usage-reports-endpoint/274973)
**Author:** [@hiddenseal](https://meta.discourse.org/u/hiddenseal)\ **Replies:** 1\ **Last updated:** [August 14, 2023, 6:45am UTC](https://meta.discourse.org/t/chat-usage-reports-endpoint/274973 "2023-08-14T06:45:51Z")
Is there an endpoint for reports related to chat activity? I’m interested in the number of messages sent in total, the number of messages per channel, and maybe even the number of reactions in total/each channel. I don’… --- ## [Ignore user date range seems buggy in Safari or Firefox on touchscreen desktop](https://meta.discourse.org/t/ignore-user-date-range-seems-buggy-in-safari-or-firefox-on-touchscreen-desktop/274993)
**Author:** [@Lilly](https://meta.discourse.org/u/Lilly)\ **Replies:** 2\ **Last updated:** [August 15, 2023, 12:45pm UTC](https://meta.discourse.org/t/ignore-user-date-range-seems-buggy-in-safari-or-firefox-on-touchscreen-desktop/274993 "2023-08-15T12:45:39Z")
the ignore user modal date range selector seems to be not behaving as expected in Safari or Firefox in iOS ipad desktop view. it’s fine in mobile views and Chrome. cannot select longer date ranges or forever options. vi… --- ## [Banner stats](https://meta.discourse.org/t/banner-stats/274998)
**Author:** [@Mittineague](https://meta.discourse.org/u/Mittineague)\ **Replies:** 0\ **Last updated:** [May 1, 2016, 2:55am UTC](https://meta.discourse.org/t/banner-stats/274998 "2016-05-01T02:55:33Z")
Most of mine are “OK, but could be better” For example, this one works, but I don’t like the duplicate sub-query much Banner Stats WITH all\_users AS ( SELECT COUNT(users.id) AS user\_count FROM users WHERE users.… --- ## [Likes by 'team'](https://meta.discourse.org/t/likes-by-team/274999)
**Author:** [@fefrei](https://meta.discourse.org/u/fefrei)\ **Replies:** 0\ **Last updated:** [May 1, 2016, 6:48pm UTC](https://meta.discourse.org/t/likes-by-team/274999 "2016-05-01T18:48:22Z")
Likes from the team This query assumes there is a group called team, and gives you the likes other users have received, split into likes from the team and likes from others: SELECT pl.user\_id, SUM(pl.team\_likes… --- ## [Recently Read Topics by User](https://meta.discourse.org/t/recently-read-topics-by-user/275000)
**Author:** [@mcwumbly](https://meta.discourse.org/u/mcwumbly)\ **Replies:** 0\ **Last updated:** [May 4, 2016, 5:25am UTC](https://meta.discourse.org/t/recently-read-topics-by-user/275000 "2016-05-04T05:25:02Z")
Recently Read Topics by User Show the topics with that have been opened by a given user in the past N days, sorted by the amount of time the user has spent in that topic. (requested on feverbee) -- \[params\] -- integer :… --- ## [Member Uploads](https://meta.discourse.org/t/member-uploads/275001)
**Author:** [@Mittineague](https://meta.discourse.org/u/Mittineague)\ **Replies:** 0\ **Last updated:** [June 20, 2016, 6:14pm UTC](https://meta.discourse.org/t/member-uploads/275001 "2016-06-20T18:14:23Z")
Member Uploads I put together this query to help find members that post a lot of uploads that potentially might lead to a problem. Ordered by total upload weight per member WITH heavy\_uploads AS ( SELECT ( SUM(u… --- ## [List of all Members of a Group with Custom Field](https://meta.discourse.org/t/list-of-all-members-of-a-group-with-custom-field/275003)
**Author:** [@fefrei](https://meta.discourse.org/u/fefrei)\ **Replies:** 0\ **Last updated:** [September 15, 2016, 4:11pm UTC](https://meta.discourse.org/t/list-of-all-members-of-a-group-with-custom-field/275003 "2016-09-15T16:11:41Z")
List of all Members of a Group with Custom Field We use this query to get a list of the name and matriculation number of all team members: SELECT users.name, user\_custom\_fields.value as matriculation FROM users JOIN gro… --- ## [A query for users with a custom title?](https://meta.discourse.org/t/a-query-for-users-with-a-custom-title/275004)
**Author:** [@jomaxro](https://meta.discourse.org/u/jomaxro)\ **Replies:** 4\ **Last updated:** [October 15, 2016, 6:07pm UTC](https://meta.discourse.org/t/a-query-for-users-with-a-custom-title/275004 "2016-10-15T18:07:24Z")
Anyone able to provide the query for all users with a custom title (not a badge granted title)? --- ## [Top quality users in last six months](https://meta.discourse.org/t/top-quality-users-in-last-six-months/275006)
**Author:** [@ChrisBeach](https://meta.discourse.org/u/ChrisBeach)\ **Replies:** 3\ **Last updated:** [January 30, 2019, 1:43pm UTC](https://meta.discourse.org/t/top-quality-users-in-last-six-months/275006 "2019-01-30T13:43:02Z")
Top quality users in last six months Top 20 users by average post score. Post scores are calculated based on reply count, likes, incoming links, bookmarks, average time (reading?) and read count. SELECT sum(p.scor… --- ## [Who has been sending the most messages in the last week?](https://meta.discourse.org/t/who-has-been-sending-the-most-messages-in-the-last-week/275007)
**Author:** [@fefrei](https://meta.discourse.org/u/fefrei)\ **Replies:** 0\ **Last updated:** [June 5, 2017, 3:04pm UTC](https://meta.discourse.org/t/who-has-been-sending-the-most-messages-in-the-last-week/275007 "2017-06-05T15:04:05Z")
Who has been sending the most messages in the last week? SELECT user\_id, count(\*) AS message\_count FROM topics WHERE archetype = 'private\_message' AND subtype = 'user\_to\_user' AND age(created\_at) \< interval '7 days' GROU… --- ## [Users ordered by creation date](https://meta.discourse.org/t/users-ordered-by-creation-date/275009)
**Author:** [@jomaxro](https://meta.discourse.org/u/jomaxro)\ **Replies:** 0\ **Last updated:** [June 22, 2017, 12:37am UTC](https://meta.discourse.org/t/users-ordered-by-creation-date/275009 "2017-06-22T00:37:26Z")
Users ordered by creation date SELECT users.username, users.created\_at FROM users WHERE users.created\_at \< '2017-05-10'::timestamp ORDER BY users.created\_at --- ## [Posts per category (with deleted and without deleted)](https://meta.discourse.org/t/posts-per-category-with-deleted-and-without-deleted/275010)
**Author:** [@david](https://meta.discourse.org/u/david)\ **Replies:** 1\ **Last updated:** [July 17, 2017, 7:03pm UTC](https://meta.discourse.org/t/posts-per-category-with-deleted-and-without-deleted/275010 "2017-07-17T19:03:35Z")
Posts per category (with deleted and without deleted) I think that by default deleted topics/posts will be included in data-explorer statistics. Doing some quick experimentation on a category where we delete a lot of st… --- ## [Recreate the Discourse user’s directory](https://meta.discourse.org/t/recreate-the-discourse-user-s-directory/275011)
**Author:** [@jomaxro](https://meta.discourse.org/u/jomaxro)\ **Replies:** 3\ **Last updated:** [March 13, 2020, 11:30pm UTC](https://meta.discourse.org/t/recreate-the-discourse-user-s-directory/275011 "2020-03-13T23:30:49Z")
Recreate the Discourse user’s directory OK, here is the query to recreate the user’s directory. -- \[params\] -- null int :period SELECT users.username AS "Username", directory\_items.likes\_received AS "Likes Received", d… [Previous page](https://meta.discourse.org/hot.md?page=1640) [Next page](https://meta.discourse.org/hot.md?page=1642)