Cart error, Action Scheduler Error

  • Resolved amuletts

    (@amuletts)


    1 year, 1 month ago

    Experiencing an error with shopping cart and checkout. Adding items to cart either doesn’t work, or does briefly then moments later it is empty. Checkout doesn’t work either (presumably because product vanishes halfway through checkout process, not 100% certain on that but seems likely).

    I think this problem is caused by the action scheduler. See error below. It has a table entry with ID 0

    How do I fix this please?

    [Tue Jan 30 09:02:24.918003 2024] [proxy_fcgi:error] [pid 711908:tid 140178597308160] [client?65.21.35.239:0] AH01071: Got error ‘PHP message: WordPress database error Duplicate entry ‘0’ for key ‘PRIMARY’ for query \nINSERT INTO hJV8Z_actionscheduler_actions (?hook?,?status?,?scheduled_date_gmt?,?scheduled_date_local?,?schedule?,?group_id?,?priority?,?args?)\nSELECT ‘action_scheduler/migration_hook’, ‘pending’, ‘2024-01-30 17:03:24’, ‘2024-01-30 17:03:24’, ‘O:30:\”ActionScheduler_SimpleSchedule\”:2:{s:22:\”\0\0scheduled_timestamp\”;i:1706634204;s:41:\”\0ActionScheduler_SimpleSchedule\0timestamp\”;i:1706634204;}’, 1, 10, ‘[]’ FROM DUAL\nWHERE ( SELECT NULL FROM DUAL ) IS NULL made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘wp_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Action_Scheduler\Migration\Controller->schedule_migration, Action_Scheduler\Migration\Scheduler->schedule_migration, as_schedule_single_action, ActionScheduler_ActionFactory->create, ActionScheduler_ActionFactory->store, ActionScheduler_HybridStore->save_act…; PHP message: Caught exception while enqueuing action “action_scheduler/migration_hook”: Error saving action: Error saving action: Duplicate entry ‘0’ for key ‘PRIMARY”, referer:?https://altocd.com/product/pacd96084/?add-to-cart=460

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

Viewing 5 replies - 1 through 5 (of 5 total)

  • Hi there @amuletts, thank you for reaching out.

    I understand you are experiencing an error with the shopping cart and checkout. Before we can proceed to troubleshoot the issue further, do you remember making any changes in your store before the issue started, such as updating or installing plugins?

    This way, we can have a better understanding of the issue.

    Thread Starter amuletts

    (@amuletts)

    Yes, updated woocommerce to 8.5.2

    Woocommerce is reporting a number of incompatible plugins, which we would deem essential:

    Advanced Coupons for WooCommerce Free
    Ivory Search
    WooCommerce PayPal Payments
    WooCommerce Weight Based Shipping

    The PayPal Payments one is actually recommended by woocommerce (and being able to process payments is clearly very important)! I tried deactivating paypal and switching to woo payments, but it said that wasn’t compatible either?! And that’s your plugin?

    • This reply was modified 1 year, 1 month ago by amuletts.

    Hi again @amuletts,

    I understand your concern about the plugin compatibility issues you’re experiencing.

    It’s strange that you’re experiencing issues with WooCommerce Payments since it’s recommended by WooCommerce. It might be worth ensuring that both WooCommerce and the PayPal Payments plugin are updated to their latest versions. If the problem persists, it might be an issue with a conflict with another plugin.

    I would recommend you to deactivate all plugins except WooCommerce and WooPayments, and then check if the issue persists. If it’s resolved, reactivate your plugins one by one to identify the one causing the conflict.

    You can find more details on performing a conflict test here: https://woo.com/document/how-to-test-for-conflicts/

    Thank you for your patience and understanding.

    Thread Starter amuletts

    (@amuletts)

    I tried deactivating all plugins except Woo and Paypal but the problem persisted.
    I restored from backup and am using woocoomerce version 8.4.0.
    I will be very careful before updating again.

    Even at this version, it *still* says those plugins (including PayPal Payments) are incompatible with woocommerce features (but they seem to be working).
    …wp-admin/plugins.php?plugin_status=incompatible_with_feature

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello amuletts,

    Thank you for your reply and for detailing the steps you have taken in response to the plugin compatibility messages you’re seeing.

    I want to assure you that the WooCommerce PayPal Payments and WooPayments plugins are kept up to date and should be compatible with the latest versions of WooCommerce.

    To help us understand the situation better, may I request a copy of your site’s System Status Report?
    Here’s how you can provide that:
    1. Navigate to WooCommerce > Status in your WordPress dashboard.
    2. Click on ‘Get system report.’
    3. Then click on ‘Copy for support.’

    After copying the report, paste it on https://gist.github.com to create a new Gist. Once you’ve done that, please share the Gist link with us.

    This report offers comprehensive details about your site’s server environment, which is essential in troubleshooting the issue you’re experiencing.

    Thank you for your cooperation, and I look forward to resolving this with you. ??

    Best regards.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Cart error, Action Scheduler Error’ is closed to new replies.

Tags