Bug Reports · Legacy archive

Scrasamax has over 9000 votes on his submission.

Started by EchoMirage Dec 8, 2011 5 posts Locked

  1. Scrasamax has over 9000 votes on his submission.

    #1
    I voted for Scras' sub, then changed my mind, deleted vote. The score messed up, so I deleted it again, and re-voted. Now the sub has a rating of 0 and many many many votes.
  2. Re: Scrasamax has over 9000 votes on his submission.

    #2
    Derp
  3. Re: Scrasamax has over 9000 votes on his submission.

    #3
    DOH!?
  4. Re: Scrasamax has over 9000 votes on his submission.

    #4
    Taking a look at the number provided (16777215) that looks suspiciously like a MySQL integer truncation error. I've encountered some of those recently, and they're a mild pain. Take a look at how it's being inserted; if you're wanting it as a string (not as a number) make sure to typecast it as such in PHP, otherwise MySQL does sneaky internal conversions and royally fscks it up.
  5. Re: Scrasamax has over 9000 votes on his submission.

    #5
    Yeah, I think so. I believe it is unsigned and the removal of the vote and the error maybe put it into the negative and it splurghed.

    Either way I will take a look at the sub and fix it up tomorrow night. Wish I could get to it today but it is bad timing.

Bug Reports · All categories · Guildhall