Action Scheduler – Duplicate entry ‘0’ error

  • Resolved webkiwi

    (@webkiwi)


    4 years, 4 months ago

    Site has been live for 5 years, no issues ever, recent wordpress/woocommerce updates have frozen the shopping cart – error as per below:

    “Version 4.6.1 | By Automattic | View details
    This plugin failed to load properly and is paused during recovery mode.

    An error of type E_ERROR was caused in line 44 of the file /home/nzfireca/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php. Error message: Uncaught RuntimeException: Error saving action: Error saving action: Duplicate entry ‘0’ for key ‘PRIMARY’ in /home/nzfireca/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44 Stack trace: #0 /home/nzfireca/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(242): ActionScheduler_DBStoreMigrator->save_action(Object(ActionScheduler_Action), NULL) #1 /home/nzfireca/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_HybridStore->save_action(Object(ActionScheduler_Action)) #2 /home/nzfireca/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #3 /home/nzfireca/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler”

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter webkiwi

    (@webkiwi)

    A search of similar errors refer to checking the database is able to autoincrement – there havn’t been changes to the DB as far as I know, or perhaps host has upgraded SQL/php version without my knowledge, or perhaps SQL/php version needs to be updated?
    Either way, anyone able to recommend what tables to look at to troubleshoot this issue and get it resolved? THanks.

    Thread Starter webkiwi

    (@webkiwi)

    bumping this topic – anyone able to assist?

    Plugin Support Damianne P (a11n)

    (@drwpcom)

    Hi @webkiwi. Sorry that we missed your initial post.

    Have you been able to resolve this issue? If not, please try manually reinstalling/updating the WooCommerce plugin through FTP?

    Thread Starter webkiwi

    (@webkiwi)

    Unfortunately, though the FTP method was tried several times, if failed to work correctly, the client was unhappy, and the site has since moved to another developer. I can close this ticket.
    Thanks for the reply.
    Brendon

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Action Scheduler – Duplicate entry ‘0’ error’ is closed to new replies.