Sam, that’s awful!
Start with the wp_posts table. Is everything still there? Did the post_type column change to something other than ‘post’? If so, fix that.
WP’s taxonomy storage schema is kind of complicated (see http://codex.wordpress.org/WordPress_Taxonomy and http://codex.wordpress.org/Database_Description). Fixing a problem like this will take a few steps.
First, look in wp_terms and note the term_ids of all the formats you were working on.
Then, go to the wp_term_taxonomy table and edit the taxonomy column for all the term_ids in your list.
Thread Starter
Sam
(@thinkink)
Well yes, I fixed it by going to PHP MyAdmin.
The post_type column in mysql was showing ‘-1’?
So I googled sql commands and finally managed a find/replace on the database:
update wp_posts set post_type = replace(post_type,'-1','post');
which changed -1 back to post.
Got everything back. Was scary for a bit, but worked out in the end.
Anyway I had wanted to convert posts tagged ‘Video’ to become post-format ‘video’) – but after this error, I never figured out how to use the plugin anyway.
Very sorry about that. I’ll try to prevent that from happening in the next version.
The Term Management Tools plugin might be better for changing taxonomies without messing with the post types.
Thread Starter
Sam
(@thinkink)
No worries, alls well that ends well. And it was just my personal blog, not a clients!
Thanks for the link.
cheers,
I’ve just completely rewritten the plugin. Among other huge bug fixes, the new version prevents this from happening. Thanks for reporting it!
