What the !@^&@!!!

Wednesday Jul 6th 2005

Holy shit has the past couple of days been hell in blogland. This is going to be a geekoid post, I give you fair warning. I’m also going to swear a lot. A whole lot.

Okay, here’s the situation: This programmer asshole decided to release an “updated” version of DBD::mysql, version 3.0000. Why four zeros? I have no idea. This thing is used in cPanel, something a lot of web host providers use, including the one I use. In short, due to the God darned release, it broke almost EVERY SINGLE BLOG that uses MT and MySQL across the internet. Good job, retard! As of RIGHT NOW, there are SHITLOADS of MT blogs that STILL DON’T WORK.

Very fucking annoying. Many MT bloggers are now familiar with the phrase “Premature end of script” error, HUGE “core” files being dumped to the cgi-bin directory, “Error 500″ server nastygrams up the ying-yang and a busted blog.

So why is my blog working? Good question. Here’s a good answer.

MovableType gives the choice of using a few different databases on install. One of them is Berkeley. It’s not MySQL. It’s just a directory Perl thing-a-ma-doo whatever. “Okay, I’ll just convert over to that - shouldn’t be a problem.”

Or so I thought.

Turns out my MySQL database had a few “holes” in it where the entry and ID count were off.. (such as entry 434, 435, 437, 438 where it skipped a number due to a deleted entry or whatever) so when I exported the entries and then reimported to the Berkeley database, my phpBB comment system didn’t match up to the entry ID’s. ARRHGHGHGHGHHHH…

So I had to manually open the MySQL database and fix it LINE BY LINE by “filling the hole” with a dummy entry whereever a skipped number was present.

Finally, I got everything back together where the ID’s matched the comment system. I also had to manually import all the template crap from the MySQL db using phpMyAdmin and cut/paste into this MT installation.

This whole experience fucking sucked. I can’t believe that someone would release an “update” that would simply break MT blogs all over the place.

To those who are (still) waiting for a fix, the thread is here. If and when a patch is released, I seriously doubt I will go back to MySQL for a while. I worked really, really hard to get my MT setup the way I wanted it.. and I’m not about to let it go. I was considering migrating to WordPress or pMachine, but.. with my integrated phpBB comment system - that would be a pain in the ass to the ump-teenth degree. No thanks. I got my setup working now.. that’s all that counts.

Oh, one more thing. You will see that I did post something on that thread where I said my comments go “out of sync”. This was before I fixed my little “hole” thing mentioned above. Once I got that straightened out I was able to reimport all my entries to the Berkeley db without a problem.

Posted in blog   Short URL

You can follow any responses to this entry through the RSS 2.0 feed.

Both comments and pings are currently closed.

« Internet speak in a southern drawlLate to bed, late to rise »