I decided to start overhauling this blog by fixing the Ultimate Tag Warrior problem caused by a bad version. I could probably use a newer version and have it clean up the mess but I don’t plan on tagging my posts anymore.
I would backup the DB first, but the bug caused tons of extra records to get loaded into the WordPress tables making backups virtually impossible.
It looks like this is going to talk longer than it should. GoDaddy (my hosting provider) is running extremely slowly and I’m getting a fair amount of timeout errors.
My wp_postmeta table had over 300,000 records. Almost all of them are bad UTW records.
To clean up the records, I used this SQL command:
DELETE FROM `wp_postmeta` WHERE meta_key like ‘%utw%’
If you decide to try something similar, make sure you know how your database works. Not all of them use the same syntax.
Here are the results:
Deleted rows: 301693 (Query took 20.7045 sec)
Afterward, there is only 1 record. And everything is loading much more quickly (although GoDaddy admin page loads are still pretty slow).
That takes care of the first phase of cleaning up this blog. I’m going to be cleaning up a few other blogs at the same time. After I take care of this problem with the other blogs, I’ll be upgrading to WordPress 2.1.2.
If you would like to make a comment, please fill out the form below.
