timestamp weirdness

Message Bookmarked
Bookmark Removed
http://www.ilxor.com/ILX/ThreadSelectedControllerServlet?boardid=41&threadid=40095

in this thread, the first message's timestamp is: -- fandango (fandango), Tuesday, June 26, 2001 10:57 PM (5 years ago)

this is very unlikely because the album in question didn't come out until 2005. i feel like i've been seeing more of this in other threads but this is the first one that really jumped out at me.

lfam, Wednesday, 25 April 2007 00:14 (nineteen years ago)

There are a couple of things like this, because of the migrator. Try Glasgow More claims it was started by Ailsa, not RJG. Keith explained it somwhere, I'll try and find where he did it.

stet, Wednesday, 25 April 2007 00:38 (nineteen years ago)

Part the migrator, but really because of the state of the database as it was. It used to just read out messages from the DB in the order they were stored - but this meant that lots of threads were screwed up (for whatever reason; not sure - probably not coping with deletions and so on, in the past. Relying on the order in which the database puts messages is a bad thing to do - some databases, including MySQL use blank space again for new data, if data is deleted).

So, I made the migration order messages by timestamp, which should sort everything out - except, for a short period a year or two ago, when something went wrong and everyone posted like it was 2001. Don't know why this was either, but it means that some threads wound up with their earliest date as this. I counted them at the time, but it was only a handful.

Keith, Wednesday, 25 April 2007 07:25 (nineteen years ago)

yeah, that 2nd post is realy the first - i remember starting this thread.

toby, Wednesday, 25 April 2007 21:21 (nineteen years ago)


This thread has been locked by an administrator

You must be logged in to post. Please either login here, or if you are not registered, you may register here.