Support » Plugin: WooCommerce » Woo Commerce 4.0 Not Able To Add Product to Cart

  • Resolved redhat

    (@redhat)


    Hello Team,

    After Updating the plugin to the latest Version not able to add product to cart

    while cross checking have find this in error log

    #0 /home/0000--000/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(598): ActionScheduler_DBStore->claim_actions(0, 25, NULL, Array, '')

    #1 /home/00---00/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_HybridStore.php(206): ActionScheduler_DBStore->stake_claim(25, NULL, Array, '')

    #2 /home/00--000/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(154): ActionScheduler_HybridStore->stake_claim(25)

    #3 /home/000--000/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(133): ActionScheduler_QueueRunner->do_batch(25, 'WP Cron')

    #4 /home/000---000/public_html/wp- in /home/bloodtbg/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 674

    [16-Mar-2020 08:46:27 UTC] WordPress database error Table '00000-----0000000_actionscheduler_claims' doesn't exist for query SHOW FULL COLUMNS FROMhp3j_actionscheduler_claimsmade by do_action_ref_array('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_HybridStore->stake_claim, ActionScheduler_DBStore->stake_claim, ActionScheduler_DBStore->generate_claim_id, W3TC\DbCache_WpdbNew->insert, W3TC\DbCache_WpdbInjection_QueryCaching->insert, W3TC\_CallUnderlying->insert, W3TC\DbCache_WpdbNew->insert, W3TC\DbCache_WpdbInjection->insert, W3TC\DbCache_WpdbNew->default_insert, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query

    For Now i have rolled back to the previous version of woocommerce

Viewing 9 replies - 1 through 9 (of 9 total)
  • @redhat I think there must be any plugin which will not compatible with the WooCommerce 4.0. So please try to deactivate all plugins except woocommerce and check your issue by activating other plugins one by one. I am sure you will be able to find the conflicting plugin. And also switch to the default theme like a storefront.

    hey @mohitmishra

    done this all steps but unfortunately not able to find anything.

    well i updated the plugin on other domain as well and its working fine that domain also contains same plugin.

    Ok do one thing check your console.

    I too have the exact same error.
    I can no longer add photos to the products in my catalog and this is causing me a lot of damage.

    How should I go about solving?
    I deactivated all the plugins but nothing to do, I deactivated the theme but nothing.

    This is the error log, I put the xxxxx instead of the name of the database and the site.

    2020-03-15T18:08:03+00:00 CRITICAL Uncaught RuntimeException: Impossibile richiedere azioni. Errore del database. in /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:674
    Stack trace:
    #0 /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(598): ActionScheduler_DBStore->claim_actions(0, 25, NULL, Array, ”)
    #1 /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(154): ActionScheduler_DBStore->stake_claim(25)
    #2 /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(133): ActionScheduler_QueueRunner->do_batch(25, ‘WP Cron’)
    #3 /home/xxxxx/public_html/xxxxx/wp-includes/class-wp-hook.php(288): ActionScheduler_QueueRunner->run(‘WP Cron’)
    #4 /home/xxxxx/public in /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php alla riga 674

    2020-03-15T18:09:34+00:00 CRITICAL Uncaught RuntimeException: Impossibile richiedere azioni. Errore del database. in /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:674
    Stack trace:
    #0 /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(598): ActionScheduler_DBStore->claim_actions(0, 25, NULL, Array, ”)
    #1 /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(154): ActionScheduler_DBStore->stake_claim(25)
    #2 /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(133): ActionScheduler_QueueRunner->do_batch(25, ‘WP Cron’)
    #3 /home/xxxxx/public_html/xxxxx/wp-includes/class-wp-hook.php(288): ActionScheduler_QueueRunner->run(‘WP Cron’)
    #4 /home/xxxxx/public in /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php alla riga 674

    2020-03-15T18:10:56+00:00 CRITICAL Uncaught RuntimeException: Impossibile richiedere azioni. Errore del database. in /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:674
    Stack trace:
    #0 /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(598): ActionScheduler_DBStore->claim_actions(0, 25, NULL, Array, ”)
    #1 /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(154): ActionScheduler_DBStore->stake_claim(25)
    #2 /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(133): ActionScheduler_QueueRunner->do_batch(25, ‘WP Cron’)
    #3 /home/xxxxx/public_html/xxxxx/wp-includes/class-wp-hook.php(288): ActionScheduler_QueueRunner->run(‘WP Cron’)
    #4 /home/xxxxx/public in /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php alla riga 674

    2020-03-15T18:12:01+00:00 CRITICAL Uncaught RuntimeException: Impossibile richiedere azioni. Errore del database. in /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:674
    Stack trace:
    #0 /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php(598): ActionScheduler_DBStore->claim_actions(0, 25, NULL, Array, ”)
    #1 /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(154): ActionScheduler_DBStore->stake_claim(25)
    #2 /home/xxxxx/public_html/xxxxx/wp-content/plugins/woocommerce/packages/action-scheduler/classes/ActionScheduler_QueueRunner.php(133): ActionScheduler_QueueRunner->do_batch(25, ‘WP Cron’)
    #3 /home/XXXX/public_html/XXXX/wp-includes/class-wp-hook.php(288): ActionScheduler_QueueRunner->run(‘WP Cron’)
    #4 /home/XXXX/public in XXXXXXX/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php alla riga 674

    Errore sul database di WordPress: [Table ‘xxxxx_wp894.wp8r_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wp8r_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

    Errore sul database di WordPress: [Table ‘xxxxx_wp894.wp8r_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wp8r_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

    Errore sul database di WordPress: [Table ‘xxxxx_wp894.wp8r_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wp8r_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’in-progress’ ORDER BY scheduled_date_gmt DESC LIMIT 1

    Errore sul database di WordPress: [Table ‘xxxxx_wp894.wp8r_actionscheduler_actions’ doesn’t exist]
    SELECT a.action_id FROM wp8r_actionscheduler_actions a WHERE a.hook=’action_scheduler/migration_hook’ AND a.status=’pending’ ORDER BY scheduled_date_gmt ASC LIMIT 1

    Errore sul database di WordPress: [Table ‘xxxxx_wp894.wp8r_actionscheduler_groups’ doesn’t exist]
    SELECT group_id FROM wp8r_actionscheduler_groups WHERE slug=’action-scheduler-migration’

    Errore sul database di WordPress: [Table ‘xxxxx_wp894.wp8r_actionscheduler_groups’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp8r_actionscheduler_groups

    Errore sul database di WordPress: [Table ‘xxxxx_wp894.wp8r_actionscheduler_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp8r_actionscheduler_actions

    Hello @andreaguerra80 Have tried it by deactivating all the plugins except the WooCommece and switch to the default theme like StoreFront.

    Hello @mohitmishra
    I think while upgrading the woocommerce plugin, ActionScheduler or some related tables which automatically get created got stuck or didn’t get created in database might be the reason for this error, tried again to update the woocommerce plugin but result same so rolled back to the previous version any solution for this or else will not be able to use the latest version of woocommerce here onwards.

    Hi @andreaguerra80

    Thanks for the source checking it out.

    Plugin Support yukikatayama

    (@yukikatayama)

    Automattic Happiness Engineer

    Hi all, please try updating to 4.0.1 which was just released today to resolved the missing scheduled action issues.

    Thanks!

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Woo Commerce 4.0 Not Able To Add Product to Cart’ is closed to new replies.