Migration “MailPoet\Migrations\Migration_20230605_174836” failed.

  • IN the backend of WP I’m seeing this:

    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 419

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Bruna a11n

    (@bruberries)

    Hi @lindytech,

    Unfortunately, this is a database issue and you’ll need to access your database, go to the wp_mailpoet_subscribers table and update the mentioned column to NULL instead of 0.

    In this specific case, you can use the SQL query:

    UPDATE wp_mailpoet_subscribers SET created_at = NULL WHERE created_at = 0

    Let us know if it works!

    Thread Starter lindytech

    (@lindytech)

    Thank you! Yes, that seems to have worked! Pro plugin updated as well. ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Migration “MailPoet\Migrations\Migration_20230605_174836” failed.’ is closed to new replies.