WordPress database error: [Duplicate entry ‘0’ for key ‘PRIMARY’]

  • bcraig24

    (@bcraig24)


    5 years, 3 months ago

    I have had my webhost recover my whole website and I am going through the process of reinstalling all my plugins one by one to find a bad plugin.
    But with just the one plugin – WooCommerce – I am getting this database error.

    I have read else where that it can be a plugin conflict but like I’ve said I only have the one plugin at this point.

    WordPress database error: [Duplicate entry ‘0’ for key ‘PRIMARY’]
    INSERT INTO wp_actionscheduler_actions (hook, status, scheduled_date_gmt, scheduled_date_local, schedule, group_id, args) VALUES (‘woocommerce_run_update_callback’, ‘pending’, ‘2021-02-25 01:38:51’, ‘2021-02-25 14:38:51’, ‘O:30:\”ActionScheduler_SimpleSchedule\”:2:{s:22:\”\0*\0scheduled_timestamp\”;i:1614217131;s:41:\”\0ActionScheduler_SimpleSchedule\0timestamp\”;i:1614217131;}’, ‘7’, ‘{\”update_callback\”:\”wc_update_500_fix_product_review_count\”}’)

    Fatal error: Uncaught RuntimeException: Error saving action: Duplicate entry ‘0’ for key ‘PRIMARY’ in /home/filthydo/public_html/benandwen.co.nz/blog/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:75 Stack trace: #0 /home/filthydo/public_html/benandwen.co.nz/blog/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(177): ActionScheduler_DBStore->save_action(Object(ActionScheduler_Action)) #1 /home/filthydo/public_html/benandwen.co.nz/blog/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_ActionFactory.php(84): ActionScheduler_ActionFactory->store(Object(ActionScheduler_Action)) #2 /home/filthydo/public_html/benandwen.co.nz/blog/wp-content/plugins/woocommerce/packages/action-scheduler/functions.php(36): ActionScheduler_ActionFactory->single(‘woocommerce_run…’, Array, 1614217131, ‘woocommerce-db-…’) #3 /home/filthydo/public_html/benandwen.co.nz/blog/wp-content/plugins/woocommerce/include in /home/filthydo/public_html/benandwen.co.nz/blog/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 75

Viewing 1 replies (of 1 total)
  • heverson

    (@heverson)

    5 years ago

    In your database, change ID to Auto Increment in the wp_actionscheduler_actions table.

Viewing 1 replies (of 1 total)

The topic ‘WordPress database error: [Duplicate entry ‘0’ for key ‘PRIMARY’]’ is closed to new replies.