Thread: cron jobs trouble and ads not purge!!

cron jobs trouble and ads not purge!!

hi, please I need to solve the problem of cron job, I can not purge any ads and I get emails EVERY MINUTE, paste the email to see my code:

"Your cron job has run successfully.
No expired ads were found.

Output of the SQL select call for expired ads:
SELECT class2012_posts.ID FROM class2012_posts
LEFT JOIN class2012_postmeta ON class2012_posts.ID = class2012_postmeta.post_id
WHERE class2012_postmeta.meta_key = 'cp_sys_expire_date'
AND timediff(STR_TO_DATE(class2012_postmeta.meta_value , '%m/%d/%Y %H:%i:%s'), now()) <= 0
AND class2012_posts.post_status = 'publish' AND class2012_posts.post_type = 'ad_listing'


I've read all threads on this forum and edit the theme-cron.php but still not working. I have version 3.1.4 and all settings are correct on the dashboard (prune = YES Cron time = daily), i try make a new clean installation in another domain and the problem continues.
Please I need to solve this problema NOWWWW
thank you very much