Timestamp

Last weekend the BBS system was updated to Fedora Core 6 by COMMAN. Many thanks! Well, it's been two years since the first installation in 2004. It's really hard at that time: two harddisks were damaged and sources were lost. With some luck there were backup data on nowhereman's machine, which actually was borrowed from my advisor. I can still remember the rainy day that parrot and I rushed for a new SCSI harddisk, experiencing feelings of anxiety and helplessness. Later we got further financial support from Trend Micro with the help of Jackie, and COMMAN gave hands to get things ready for a new machine.

We had even no display card then, so we just "borrowed" one from lfan's machine. It's the first 64-bit machine I had ever used. Getting the operating system OK, we printed sizeof(long) and sizeof(void *) to see "8" and grinned. After this, better worked hard to port SMTH code and got it running successfully. Only a few months later another storm came and the story became ridiculous. I've no interest in politics but I really hate those full of ambition. So better and I chose to quit at the April Fool. Stupid, huh?

Last night a few reports showed that the system failed to deal with the timestamp of comments of blogs. As COMMAN figured out, the blogs were stored in an old version of MySQL and the timestamp format was YYYYMMDDHHMMSS while newer MySQL uses YYYY-MM-DD HH:MM:SS. A minor fix works, and it's said to add "+0" in the column name in SQL statements would also be OK to retain the old timestamp format.