WordPress.org

Ready to get started?Download WordPress

Forums

WordPress SEO by Yoast
[resolved] Huge amount of invalid entries in wp_postmeta (2 posts)

  1. sanketbansal
    Member
    Posted 1 year ago #

    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/

  2. sanketbansal
    Member
    Posted 1 year ago #

    Never mind, I figured out that this was an incompatibility issue with an existing plugin - "Revision Control".

    Instead of actively controlling revisions and preventing them from being generated, I am now using a database optimizer to delete revisions periodically. Yoast SEO plugin is now working as expected.

    My apologies for any inconvenience/confusion.

    Thank you.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic