SQLSTATE[HY000]: General error: 1364 Field ‘id’ doesn’t have a default value

  • Resolved millisec

    (@millisec)


    2 years, 4 months ago

    We recently migrated our website through servers.

    Before changing the nameservers, we checked for errors and compared the two websites by configuring the “hosts” file.

    However, when the DNS propagation was complete, we logged in on the new website and we encountered this error when clicking on Mailpoet in the wordpress dashboard:

    “An exception occurred while executing ‘INSERT INTO wp_mailpoet_scheduled_tasks (type, status, priority, scheduled_at, processed_at, meta, in_progress, reschedule_count, created_at, updated_at, deleted_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“subscribers_count_cache_recalculation”, “scheduled”, 10, “2022-11-10 20:12:51”, null, null, null, 0, “2022-11-10 20:12:49”, “2022-11-10 20:12:49″, null]:

    SQLSTATE[HY000]: General error: 1364 Field ‘id’ doesn’t have a default value ”

    Plugin version is 3.93.0
    Php is 7.3.33

    We are a paid customers and will be filing a ticket as one as well ASAP. However, can anyone help?

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

Viewing 1 replies (of 1 total)
  • Thread Starter millisec

    (@millisec)

    You can consider this resolved. We will file a new ticket as a paid customer if we notice this again. Thanks.

Viewing 1 replies (of 1 total)
  • The topic ‘SQLSTATE[HY000]: General error: 1364 Field ‘id’ doesn’t have a default value’ is closed to new replies.