This is just a quick post of a little problem I've been running into lately. I'm not sure if it's a bug or some kind of intended MySQL thing, but it's annoying as heck. Also, I'm using MySQL version 5.0.32. I'm not sure if this applies to older versions of MySQL or not, but it seems to be something new with the 5.0 variants.
If you haven't noticed, the site had gone though it's fourth major revision, since I originally launched back in 2005. It's been a slow and painful process but instead of using some off-the-shelf solution for the site, I decided to write something completely new from the ground up. Why would I ever do this, you ask? Well, sit back and prepare yourself for a little story.
When I first launched, it was a very simple ColdFusion site. It didn't have a blog and it really didn't have any content management methods in place. Everything was hand coded and manually updated. It was time consuming, but it fit better with what I was trying to do. I could spotlight some of my clients, show some examples of my work and to provide some sample code to give back to the community. About 6 months after I launched, I soon realized that the site was taking more time to maintain than I had available. I had to come up with some sort of solution to let me focus on the content and not the code.