HUGE wp_mailpoet_scheduled_task_subscribers table.

Hello there @razorfrog ,

Thank you for reaching out to us. Based on the information you provided, this error message occurs because the date format in the query you ran is incorrect.

You should double-check and make sure that the date format in your query matches the format in your database’s “created_at” field.

Additionally, please ensure that you are using the correct table name in your database.

I hope this helps.

Hi @geraltrivia. Yes, we’re using the correct table name. I’m looking at the created_at column and it appears to always be blank / NULL. Screenshot: https://rzfg.co/i/WGSD5O

Why would this be? Does this mean there’s no way to prune the table?

Hi there @razorfrog,

It looks like somehow the single-quotes around the dates got turned into curly quotes somehow when you copied them, and so the date is being interpreted wrong in the query.

I tried copying the SQL directly and got the same error message you reported.

However when I changed the quotes to the following (“straight quotes”), then it executed correctly:

DELETE FROM wp_mailpoet_scheduled_task_subscribers where created_at < '2019-01-01';

Please let me know how that goes, or if you have any questions!

Thanks. That query worked, but the larger issue mentioned above is that there aren’t any dates to begin with.

I’m looking at the?created_at?column and it appears to always be blank / NULL. Screenshot:?https://rzfg.co/i/WGSD5O

?0 rows affected. (Query took 10.2613 seconds.)