Errors, errors, yay errors!

Two in one day. (Gotta make up for yesterday, right?)

You may have been noticing some error messages popping up on the pages around these parts. Remember when I mentioned that I was in the process of switching over "from Access to SQL Server," and then when I messed up and uploaded a test file to the site without backing up the original – necessitating a quick shift to the new database? (You do? Wow! You're such a nerd!)

Well I lied. (Sorry!) It was unintentional, but I did. I actually migrated from Access to MySQL. I've been working with SQL Server a lot at work and got some wires crossed in my brain. Unfortunately, there appears to be a known issue between Coldfusion 5 and MySQL, where the connection to the database is dropped pretty frequently. Our web host refusing to upgrade to the latest version of CF isn't exactly making me all smiles either. If you do get errors, just refresh the page until they go away.

In the meantime, I really am working on migrating us to SQL Server. If only it were that easy. I've also got to install a web based DBMS since I'm an Apple-nerd these days and SQL Server doesn't have any (free-ish) DBMS software for OS X. But once I get past all of that, we should be good to go!

Until then, please refresh when you see errors and forgive me! :(