weird mysql-wordpress flake-out
For the last week or two, I had some sort of strange thing going on between mysql and wordpress.
Basically, everything would work fine, except for the “save” button on the post page. Whenever I’d hit “save”, it’d save as normal, but then it’d throw an error saying something to the effect of “can’t have more than one header, multiple headers detected” in wp-admin/post.php.
So I did some troubleshooting. First I took a mysqldump of the whole db, and imported it into a test install on a local server, and took a tarball of the wordpress install and copied that over. Updated the db entry for the site url manually, logged in. Got the same result, so it’s not a host issue.
Next I tried with a clean install of wordpress using the old db. Same result. Not an issue with my customizations (hacks) to wordpress code/themes.
okey dokey … so what else? Next I tried the old wp install with a clean db. And no error … so it’s definitely something wrong with the db.
As of right now, I still don’t know what the ultimate cause of it was. But whatever it was, pointing wordpress at an entirely new set of tables, dumping the posts, comments, categories, post2cat, links, and linkcategories tables, changing the table names to the new namespace, and loading them back into the db seems to have fixed the problem.
Just … one of those strange things, I guess. I think it might have something to do with dreamhost moving the default table charsets to utf-8, and wordpress not being aware of the fact… or something? I dunno. But whatever it was, I fixed it, so I’m happy :p.