No REVISIONS found to delete…

Hey Kent,

Your settings are pretty much standard so it doesn’t look like you are doing something wrong!

No idea why it doesn’t delete the revisions.

Can you run the following query on your database:

SELECT post_parent,post_title, COUNT(*) cnt
FROM $wpdb->posts
WHERE post_type = ‘revision’
GROUP BY post_parent
HAVING COUNT(*) > 0
ORDER BY UCASE(post_title)

Replace $wpdb->posts with the real name of your posts table.

Please let me know the result of that query.

Thanks,
Rolf

Hi Rolf,

Thank you for your quick reply. After running your query, I’ve got about ~8000 records. All records contain post_parent and count value (some are 1, and others are more than 1). About the post_title, about 30 first results are blank, the remains are the post title.

Hey Kent,

Thanks for testing!

Just to make sure it’s not a ‘plugin clash’:
Please can you disable all plugins except for my optimizer and try to run the optimizer again?

Let me know if that deletes the revisions.

peace,
Rolf

Oh, it’s deleting revisions now

Here are my plugins:

Bulk Move
Google XML Sitemaps
HTML Javascript Adder
Members
Wordpress Popular Posts

I will test with each plugin disabled to see which one is the cause of this problem ??

So it is a ‘plugin clash’… ??

Yes, please find out which plugin causes this problem.
Then I can install it myself and see what the exact problem is.

Thanks,
Rolf

Hi Rolf,

After testing with each plugin enabled, and now all plugins are enabled, your plugin is working properly.

So, I’m not sure where the problem comes from. I will let you know if I find out something.

Thank you and have a nice weekend,
Kent

Hey Kent,

Good to hear it’s working now! No idea what caused the problem in the first place.

Thanks for your feedback and have a great weekend too!

Rolf