Hey, thanks for the report. I’ve added this to our GitHub tracker and will take a look at somepoint soon
I’m going to mark this as closed for now but if I can replicate this I’ll resolve it for the next update 🙂
I’m getting the same error every day. I don’t know if it is required for the error to appear, but so far no logs meet the delete age.
[12-Jul-2021 13:38:02 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 2 for query DELETE FROM wp75_mail_catcher_logs
WHERE id IN() made by do_action_ref_array('wp-mail-catcher_0'), WP_Hook->do_action, WP_Hook->apply_filters, WpMailCatcher\ExpiredLogManager::removeExpiredLogs, WpMailCatcher\Models\Logs::delete
@wardee can you please solve this issue? It should be an easy one.
It is really frustrating to see the notice generated by this error in my logs every day.
Unfortunately I’ve been very busy recently so haven’t had a chance to. I’ll hopefully get some time in the next week or so but no promises! As it’s an open source project you’re more than welcome to submit a fix 🙂
The problem is gone after last update and this is good, thank you for your work.
But older email logs are still not deleted (as it is described here https://wordpress.org/support/topic/auto-delete-logs-not-working/ by another user). So I suppose there always were zero emails to delete and that caused DB error. The question is why it was so.
