Florence ANDROLUS

Hello @celeste-9,I’m delighted to hear that version 1.0.3 resolved the issue! It’s excellent news that the task has disappeared from WP Crontrol and, most importantly, that your error logs are finally clean.The “Ghost Cron” was indeed stubborn, but it’s precisely for these kinds of complex cases that I developed this deep cleanup tool.Thank you so much for your patience and detailed feedback, which helped me refine the fix. If you found the plugin helpful, please leave a review; it greatly benefits the project!Best of luck with your site.

Hi @celeste-9 ,

Thank you for your detailed feedback. Your analysis was spot on: the previous version of the plugin was indeed too restrictive with the 90-day limit and was missing "orphan" tasks like yours dating back to 2017.

I have just released version 1.0.2 of Fand Transient and Action Cleaner specifically to address this type of legacy blockage. Here is what I’ve improved for your specific case:

Legacy Detection: The plugin no longer relies on the "last attempt" date (which is often empty for old bugs) but now uses the initial scheduled date. This finally allows it to track down and list your 2017 tasks.

Invalid Date Cleanup: The plugin now forces the removal of rows with corrupted dates (like 0000-00-00) that often prevent WordPress from updating the cron array.

Native Transient Purge: I have expanded the cleanup to include all expired transients, which should help unblock write operations in your wp_options table.

What I recommend doing:

Update the plugin to version 1.0.2.

Go to the plugin settings page. You should now see your 2017 tasks appearing in the lists.

Click the "Run Cleanup Now" button.

This should force a purge of the actions related to woocommerce_send_queued_transactional_email and clear out the orphan logs bloating your database. If the could_not_set error persists after this, @lovingbro's suggestion about renaming the cron option would be the next step, but my plugin will have already handled the surgical deep cleaning.

Let me know how it goes!