Migration “MailPoet\Migrations\Migration_20230605_174836” failed.

Hi there @lindytech,

Thanks for reaching out!

The error means that in some of the rows in your wp_mailpoet_subscribers table, the confirmed_at column is set to 0 instead of NULL.

Here is the SQL query to bulk update it:

UPDATE wp_mailpoet_subscribers SET confirmed_at = NULL WHERE confirmed_at = 0

Please create a backup of your database before running it.

Let us know how it goes!

Hi there @lindytech,

We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

So I ended up updating the datebase manually which was a huge pain BUT worked. Today had the same issue as above on another site. Ran the quarry and it fixed that error but now I’m getting…

Migration “MailPoet\Migrations\Db\Migration_20230605_174836” failed. Details: An exception occurred while executing ‘ALTER TABLE wp_mailpoet_subscribers
ADD COLUMN last_sending_at TIMESTAMP NULL DEFAULT NULL,
ADD INDEX last_sending_at (last_sending_at)’:

SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘created_at’ at row 417

Tried the same quarry and replaced “confirmed_at” with “created_at” and it did not work.

Any quick fix for this error?

• This reply was modified 1 year, 6 months ago by lindytech.