Star Trek Social Club
r/startrek: The Next Generation
Star Trek news and discussion. No slash fic...
Maybe a little slash fic.
New to Star Trek and wondering where to start?
Rules
1 Be constructive
All posts/comments must be thoughtful and balanced.
2 Be welcoming
It is important that everyone from newbies to OG Trekkers feel welcome, no matter their gender, sexual orientation, religion or race.
3 Be truthful
All posts/comments must be factually accurate and verifiable. We are not a place for gossip, rumors, or manipulative or misleading content.
4 Be nice
If a polite way cannot be found to phrase what it is you want to say, don't say anything at all. Insulting or disparaging remarks about any human being are expressly not allowed.
5 Spoilers
Utilize the spoiler system for any and all spoilers relating to the most recently-aired episode. There is no formal spoiler protection for episodes/films after they have been available for approximately one week.
6 Keep on-topic
All busmittions must be directly about the Star Trek franchise (the shows, movies, books, etc.). Off-topic discussions are welcome at c/Quarks.
7 Meta
Questions and concerns about moderator actions should be brought forward via DM.
Upcoming Episodes
| Date | Episode | Title |
|---|---|---|
| 11-28 | LD 5x07 | "Fully Dilated" |
| 12-05 | LD 5x08 | "Upper Decks" |
| 12-12 | LD 5x09 | "Fissure Quest" |
| 12-19 | LD 5x10 | "The New Next Generation" |
| 01-24 | Film | "Section 31" |
In Production
Strange New Worlds (TBA)
Section 31 (2025-01-24)
Starfleet Academy (TBA)
In Development
Untitled comedy series
Wondering where to stream a series? Check here.
view the rest of the comments
Just a quick update for everyone, yes OP is right and a bunch of bots signed up. We've purged them from our user count and enabled CAPTCHA. Email verification is coming soon as a secondary deterrent.
For the record nobody told us that it's not safe out here. We were aware that self-hosting was wondrous, with treasures to satiate desires both subtle and gross; but has NO IDEA that it wasn't for the timid. ๐
Ooh โฆ how did you purge them from your user numbers? Many other admins might not know how to do that โฆ maybe worth sharing?
We deleted them from the
local_userdatabase table outright based on some sketchy shared attributes, and then manually updated the user count insite_aggregatesto the correct figure so our stats wouldn't look so sketchy.Pretty simple for anyone comfortable in SQL who knows where to look (a helpful user DM'd and gave us a hand here), but not something anybody should try willy nilly if they don't know what they are doing. Editing production data on the fly is not to be done casually.
There are pricy probably admins who might appreciate this, as dangerous as it is.
Care if I post it into the lemmy community or even made the support community?
Sure, go for it.
Include a mention that even running queries against the database won't necessarily be easy if you don't know what you're doing. where it is located and (separately) how best to access it will depend on how it was installed.