Problems with plugin All in One SEO

@forcesail What makes you feel the table wp_aioseo_posts is not cleaned do you see any message?

Could you please try to optimize all the tables again and check if it cleans to wp_aioseo_posts table?

1) select * FROM wp_aioseo_posts WHERE post_id not in (select id from wp_posts)
gives nothing
2) clear revisions by the plugin
3) select * FROM wp_aioseo_posts WHERE post_id not in (select id from wp_posts)
gives rows

Yes, this problem still exists with v.3.1.12, I’ve just tested

@forcesail Could you please try to repair wp_aioseo_posts from phpMyAdmin and then try to optimize the table from WP-Optimize and check if it works?

1) delete FROM wp_aioseo_posts WHERE post_id not in (select id from wp_posts)
2) select * FROM wp_aioseo_posts WHERE post_id not in (select id from wp_posts)
gives 0 rows
3) clear revisions by the plugin
4) select * FROM wp_aioseo_posts WHERE post_id not in (select id from wp_posts)
gives N rows

processed it again today

@forcesail It looks like wp_aioseo_posts table is corrupt, did you try to repair the table from phpMyAdmin?

It’s that I just wrote you above:
step 1 – repare,
step 2 – checking that after repare all is ok.
step 3 – activation clear revision function of your plugin
step 4 – checking content of the tables and finding errors.

Nothing happens with site in between!

I wonder, how are you making plugin if you can’t understand sql sentences from phpMyAdmin?

@forcesail I’ll check this with our development team for further tests and if its a bug then it will get fixed in next release.

Thank you.

Just to inform you that in v.3.2.2 going on the clearing revisions doesn’t clear their records in wp_aioseo_posts that makes by ALL-in-ONE SEO plugin.