Dear PaperDemon members. Sometime yesterday the Art Comments/Reviews system broke. It is back up and running now. Although it sucks that it broke, it is cause for celebration. And here's why...
arkillian reported to me yesterday that she had received a few empty art comments in her inbox. I looked in the database and saw there were roughly 10 other of these ghost messages and they were all recent. I had no idea what the problem was but thought I'd take a look at it in the evening. Unfortunately, I ended up not having a chance to do it that evening but figured it could wait.
Then arkillian pinged me on IM today notifying me that none of the art comments were going through! I then had a pretty good idea what had caused the problem. I logged into my database to confirm my suspicions. The Art Comments table had reached it's id limit. I had set it to INT(6) and the maximum number of entries it can take had been reached at number 65535. I simply changed the limit to a higher INT and all is peachy.
Can you believe it? This is cause for celebration! We've reached 65,535 art comments. Hooray! See, it's not all bad!
Only one bad thing about this though. All comments made during this broken period have been lost. If you get a chance, please go back and rewrite your comments for any artwork you have posted to in the last couple days. If you have any ghost comments in your inbox, please delete them.
| Permalink |
Comments (1) |
Post a comment