[Plugin: Delete Duplicate Posts] the plugin breaks my menu…

latest news:
also tried with personal links for the nav menu and i don’t know why but this plugins treats the default navigation links as posts and it deletes the links from the menu!…maybe is the li id=”menu-item-NUMBER”…that it treats as post IDs ? How can avoid it?
i’m using WordPress 3.0.1 with Mystique Theme from digitalnature, latest version… 2.4.2

thank you

I’ve no tested yet but try to replace current WHERE with something like

WHERE (
(
post_status = ‘published’ AND post_type = ‘post’
)
OR (
post_status = ‘publish’ AND post_type = ‘post’

sorry the labels

WHERE (
            (
            <code>post_status</code> = 'published' AND <code>post_type</code> = 'post'
            )
            OR (
            <code>post_status</code> = 'publish' AND <code>post_type</code> = 'post'

ok, you need the quotes, i dont know how to escape them here.

Thanks, this helped! The same query appears three times in plugin code, so fix should be applied 3 times.

WHERE (
(
post_status = ‘published’
)
OR (
post_status = ‘publish’
)
) AND post_type = ‘post’

Hi there,

@nutesla
Thank you for asking this question. This has been driving me nuts also.

@olegdudkin
Thank you for taking the time to answer. This has saved me a ton of time.

I am using the “Delete Duplicate Posts” plugin and had three places in the query to update. I updated with this version of the updates above:

WHERE (
(
post_status = ‘published’
)
OR (
post_status = ‘publish’
)
) AND post_type = ‘post’
)

Thanks again!

Yes I want to say thanks also. Without this I would have had to go for the premium plugin.

I would like to add a tip for everyone.
If you add the plugin “WP Missed Schedule”,I think the cron will execute frequently instead of once a day.

Hiya everyone

Sorry about that. I have just released v. 2.2.2 with above updated code. I hope it fixes the problem, I have not had much time to test it.