WordPress version: 3.4.1
WordPress SEO version: 1.2.7
Worpress Theme: Thesis 1.8.5
Problem: The plugin is generating a huge amount of invalid entries in the wp_postmeta table. Here is my SQL query:
select * from wp_postmeta where post_id not in (select ID from wp_posts)
Ideally, the above query should return no rows. But in my case, there are 270 rows returned when the total rows in wp_postmeta are 631. That’s almost 43% !! All of these are yoast plugin rows.
On a micro-scale, when I create a new post and monitor the database, I find that even though there is a single new entry in wp_posts, yoast plugin is generating meta data for 2 posts (for two different post_id). One of these post_id is valid and the other is invalid.
I did this: I tried disabling other plugins but the problem persists. I cannot disable my theme for a long time.
This is a massive data corruption issue with invalid and unnecessary entries being generated for wp_postmeta.
I love the plugin but with such data corruption, I need a quick fix or I would need to switch to Thesis’s default SEO options.
I would really appreciate urgent attention to this.
Thanks
http://wordpress.org/extend/plugins/wordpress-seo/