So I'm working on some PHP stuff, and wanted to do a query something like "SELECT id FROM table WHERE id NOT IN (SELECT id FROM another_table)". Apparently this does not work in MySQL 4.0. So, I did the apt-get to install the latest and greatest. Viola! My Query worked. Ack! The journal's don't.

This made me sad, as I like upgrades that just work. It was pretty obvious that the journal's were not connecting to mysql, so I grabbed the updated JDBC driver and stuck that in. That worked... except there was some jibberish on the pages, which is of course not good. The date's were all funktified... apparently the mysql team decied that YYYYMMDDHHMMSS was not the best way to store a date (which I tend to agree completely with). However, it was rather inconvenient to change it, as all of the journal code manually parsed this out (bad design decision). So, I spent an hour updating the JDBC driver and fixing the journal code to use a function *gasp* to parse out the date, which is now in a convienent YYYY-MM-DD HH:MM:SS format. I wonder how many other people they've created unnecessary work for by making this change.