Post counters actually off by one
-
Continuing the discussion from The Official "Likes" Thread:
Somehow the beer discussion broke the post counter.
Scroll up until the progress bar shows 2728. Now scroll down slowly. The progress bar jumps to 2730, although that post is not visible (not even partially). The post number seems to be off by one for all subsequent posts.
Edit - Submitted to meta: https://meta.discourse.org/t/duplicate-post-ids-within-a-topic/17333 [mod - PJH]
-
Nah, there's just a post that was anti-deleted. Yeah, that's the ticket.
-
-
There is, actually, two post 2728's on that thread...
WTF? How is that even possible?
One for meta?
Isn't mentioning @codinghorror or @sam sufficient?
-
Isn't mentioning @codinghorror or @sam sufficient?
Not any more. At a minimum they've abandoned Meta:Bugs in favour of meta.discourse.org.
-
-
INB4 (select max(postid)+1 from topic) returning the duplicate value.
-
It appears to be something pretending to be a multi-column primary key (topic id + post id). Without any constraints on it...
(the posts themselves do have separate unique id's behind the scenes apparently.)
-
Another stellar piece of design brought to you by a coding horror.
-
This one at least probably* had the good intent of
create unique index on table (topicid, postnumber, postid)
where it should really have been
postid int not null primary key autoincrement(1, 1)
create unique index on table (topicid, postnumber)
It's an easy mistake for people new to database work and is completely OK in software designed by experienced... Huh.
-
-
I CALLED IT!
Looking at that sql, I think the update to correct dupe post ids is just going to shove the dupe in the other direction, but without seeing the actual db I'm not going to commit to that.
-
Is it really so hard just to use a single unique id for every post and just work with that? Fuck sake, every other forum software does and it's never been any problem for them before, not even pulling subsets of a topic at a time.
-
But then it wouldn't be "innovative."
-
Is 'doesn't fucking work properly' a new definition of 'innovative' that I somehow managed to miss before?
-
It apparently is to some people.
-
Most early access games on steam are innovative, so yes...?
-
Unless they're called Godus.
-
Filed Under: Oops we forgot to enforce the unique key constraint.
-
I don't see that as a bug, I see that as a fundamental design flaw from the off.
-
"We can't 'fucking work properly,' because that's been done before; it's so Web1.0."
-
Most early access games on steam are innovative, so yes...?
Edge of Space is a complete rip-off of Terraria, and a shitty one to-boot. Starbound is a billion times better.
-
Is 'doesn't fucking work properly' a new definition of 'innovative'
Filed under: I nominate Blakey for the 'Missing the joke' badge
-
-
@blakeyrat actually hasn't said:
Is 'doesn't fucking work properly' a new definition of 'innovative'
Filed under: I nominate Blakey for the 'Missing the joke' badge
FTFY
-
Oh great, now I have no idea if people are misquoting me because they're stupid, because they're assholes, or because this software is made by stupid assholes.
-
I tried to reply to you and quote @Arantor, but discourse happened.
-
Another example of Blakeyrat's Law.
And no, I don't think I missed the joke. Jeff and co generally believe that they're being all innovative with this Piece of Software, except failing to realise that every problem they're encountering has already been encountered and solved by multiple communities long before Discourse was a thing.
-
Filed under:We all missed the joke, Jeff got us good.
-
No, that's the worst part about it. Discourse is genuine in everything it does.
-
The best jokes are genuine.
-
Oh great, now I have no idea if people are misquoting me because they're stupid, because they're @blakeyrats, or because this software is made by stupid @blakeyrats.
-
I don't think Jeff was pranking us with this Piece of Software.
-
I believe it's a social experiment.
-
It is... to improve civilised discourse, presumably by forcibly taking away the things you're used to because they're broken?
-
To see if changing how you make people respond to one another using only immediate items above and below the post can result in a change in behavior to responding to the overall thread.
-
Interesting theory, I like it. Fits with Jeff's attitude too.
-
The best jokes are genuine.
Items don't have to be immediate.
using only immediate items above and below the post
Nor even from the same post!
You can quote yourself now....
Items don't have to be immediate.
using only immediate items above and below the post
Nor even from the same post!
You can quote yourself now....
Or quote yourself from the future!
Or quote yourself from the future!
It's the fewchur
-
It's the fewchur, and Dicsourse didn't get better.
-
I don't like fushcias.
-
@@darkmatter said:
Items don't have to be immediate.
using only immediate items above and below the post
Nor even from the same post!
You can quote yourself now....
Items don't have to be immediate.
using only immediate items above and below the post
Nor even from the same post!
You can quote yourself now....
Or quote yourself from the future!
Or quote yourself from the future!
@@darkmatter said:
It's the fewchur
This is going to be a 'thing' now.
Oh. shit. That looks like xss waiting to happen. MACIE LETTER SOUP! @Maciejasjmj
-
This is going to be a 'thing' now.
Probably not, it was already a 'thing' almost a month ago, but it's so pointless because no one is going to go back and read your old posts and then be like "AH HA! I see what you did thar", they are just going to think you're stupid when you quote it the first time and stupider when you post the thing you had quoted.