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

  1. sanketbansal
    Posted 4 years 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.



  2. sanketbansal
    Posted 4 years 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

  • Yoast SEO
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic