MySQL Crazy Errors!

Heh, check out this error. I upgraded MySQL to version 5 on a server at work then some things (note not everything) decided to stop working when connecting through Perl. After some googling I discovered sweet fa. I decided to check the DBD/mysql.pm files manually and discovered that there were actually two of them! When I installed the new driver it had installed it to a different location than the old one, so it didn’t overwrite it. Some Perl scripts were loading the old one and giving the error below.

table tree connect failed -- install_driver(mysql) failed: DBD::mysql object version 4.004 does not match bootstrap parameter 3.0002 at /usr/local/lib/perl5/5.8.7/i686-linux/DynaLoader.pm line 253.

I removed the old DBD folder and all was well again. No pressure at all considering a large commerce site was down during all of this!