• Resolved nicowob123

    (@nicowob123)


    Hi ,

    my planned actions are constantly ignored and i get this error

    thrown in /homepages/9/XXXXXXXX/htdocs/clickandbuilds/SiteName/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php on line 1128
    [12-Mar-2025 23:14:29 UTC] PHP Fatal error: Uncaught RuntimeException: Impossible de publier des mesures pour l’ID de demande 0. in /homepages/9/XXXXXXXX/htdocs/clickandbuilds/SiteName/wp-content/plugins/woocommerce/packages/action-scheduler/classes/data-stores/ActionScheduler_DBStore.php:1128


    seemingly resulting in an impossibility of interacting with my database : crash when i make a new post uploading photos return errors( impossible to in insert attachment in db) It looks like an action corrupted it… it looks like woo is involved as i always get i’m on it since’ve been on it for a week and have been trying to repair it in multiple ways , nothing is working.. help !

    ### WordPress Environment ###
    
    WordPress address (URL): [Redacted]
    Site address (URL): [Redacted]
    WC Version: 9.7.1
    Legacy REST API Package Version: L’extension Legacy REST API n’est pas installée sur ce site.
    Action Scheduler Version: ✔ 3.9.0
    Log Directory Writable: ✔
    WP Version: 6.7.2
    WP Multisite: –
    WP Memory Limit: 1 Go
    WP Debug Mode: ✔
    WP Cron: ✔
    Language: fr_FR
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 8.2.27
    PHP Post Max Size: 128 Mo
    PHP Time Limit: 120
    PHP Max Input Vars: 1000
    cURL Version: 7.74.0
    OpenSSL/1.1.1w
    
    SUHOSIN Installed: –
    MySQL Version: 10.5.22-MariaDB-1:10.5.22+maria~deb11-log
    Max Upload Size: 128 Mo
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    [REDACTED]
    
    ### Post Type Counts ###
    
    acf-field: 6
    acf-field-group: 1
    attachment: 195
    bc_x1379_op_type: 2
    custom_css: 2
    et_body_layout: 5
    et_footer_layout: 1
    et_header_layout: 1
    et_pb_layout: 20
    et_template: 7
    et_theme_builder: 1
    forminator_forms: 3
    nav_menu_item: 39
    page: 18
    post: 1
    product: 44
    product_variation: 23
    shop_order: 3
    universal_clocks: 1
    wp_global_styles: 2
    wpuf_forms: 1
    wpuf_input: 5
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (20) ###
    
    Advanced Custom Fields: par WP Engine – 6.3.12
    All-in-One WP Migration: par ServMask – 7.90
    BC Woo Custom Thank You Pages: par WooCommerce & WordPress Tutorials – 1.4.22
    Divi Dashboard Welcome: par Divi Life — by Tim Strifler – 1.2
    Forminator: par WPMU DEV – 1.40.0
    Site Kit de Google: par Google – 1.148.0
    LoginPress: par LoginPress – 4.0.0
    MouseWheel Smooth Scroll: par KubiQ – 6.7.2
    Popups for Divi: par divimode.com – 3.0.7
    Themify - WooCommerce Product Filter: par Themify – 1.5.4
    Extra product options For WooCommerce | Custom Product Addons and Fields: par ThemeHigh – 3.3.1
    WooCommerce Display Order Count: par SkyVerge – 1.1.0
    WooCommerce Stripe Gateway: par Stripe – 9.2.0
    WooCommerce: par Automattic – 9.7.1
    Wordfence Security: par Wordfence – 8.0.3
    WordPress Importer: par wordpressdotorg – 0.8.3
    Yoast SEO: par L’équipe Yoast – 24.6
    WP-Optimize - Nettoyer, compresser, mettre en cache.: par TeamUpdraft
    DavidAnderson – 4.1.1
    
    Widgets pour les avis Google: par Trustindex.io  – 12.6.1
    WPS Hide Login: par WPServeur
    NicolasKulka
    wpformation – 1.9.17.1
    
    
    ### Inactive Plugins (0) ###
    
    
    ### Dropin Plugins () ###
    
    advanced-cache.php: advanced-cache.php
    
    ### Must Use Plugins (1) ###
    
    1&1 Product Subdomain: par 1&1 – 1.1.0
    
    ### Settings ###
    
    Legacy API Enabled: –
    Force SSL: –
    Currency: EUR (€)
    Currency Position: right_space
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    Connected to WooCommerce.com: –
    Enforce Approved Product Download Directories: ✔
    HPOS feature enabled: –
    Order datastore: WC_Order_Data_Store_CPT
    HPOS data sync enabled: –
    
    ### Logging ###
    
    Enabled: ✔
    Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
    Retention period: 30 jours
    Level threshold: –
    Log directory size: 124 Ko
    
    ### WC Pages ###
    
    Base de la boutique: ❌ L’ID de page est définie
    mais la page n’existe pas
    
    Panier: ❌ La page ne contient pas le code court [woocommerce_cart] ou le bloc woocommerce/cart.
    Commander: ❌ La page ne contient pas le code court [woocommerce_checkout] ou le bloc woocommerce/checkout.
    Mon compte: #966 - /mon-compte -  Contient le code court [woocommerce_my_account]
    Conditions générales de vente et d’utilisation: ❌ Page non définie
    
    ### Theme ###
    
    Name: Headshot Child Theme
    Version: 1.1
    Author URL: https://agence-headshot.com
    Child Theme: ✔
    Parent Theme Name: Divi
    Parent Theme Version: 4.27.4
    Parent Theme Author URL: http://www.elegantthemes.com
    Theme type: Thème classique
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: –
    
    ### Admin ###
    
    Enabled Features: activity-panels
    analytics
    product-block-editor
    coupons
    core-profiler
    customize-store
    customer-effort-score-tracks
    import-products-task
    experimental-fashion-sample-products
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    mobile-app-banner
    onboarding
    onboarding-tasks
    pattern-toolkit-full-composability
    product-custom-fields
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    printful
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    woo-mobile-welcome
    wc-pay-promotion
    wc-pay-welcome-page
    launch-your-store
    add-to-cart-with-options-stepper-layout
    
    Disabled Features: product-data-views
    experimental-blocks
    coming-soon-newsletter-template
    minified-js
    product-pre-publish-modal
    settings
    async-product-editor-category-field
    product-editor-template-system
    blueprint
    reactify-classic-payments-settings
    use-wp-horizon
    blockified-add-to-cart
    
    Daily Cron: ✔ Next scheduled: 2025-03-13 13:37:46 +02:00
    Options: ✔
    Notes: 133
    Onboarding: skipped
    
    ### Action Scheduler ###
    
    Terminé: 1
    Oldest: 2025-03-12 22:22:27 +0000
    Newest: 2025-03-12 22:22:27 +0000
    
    En attente: 8
    Oldest: 2025-03-12 22:22:27 +0000
    Newest: 2025-03-12 22:22:27 +0000
    
    
    ### Status report information ###
    
    Generated at: 2025-03-13 01:04:58 +02:00

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Zee

    (@doublezed2)

    Hello nicowob123,

    Thank you for contacting WooCommerce support.

    I understand that scheduled actions are being ignored, and you’re seeing a fatal error related to ActionScheduler_DBStore.php, which seems to be affecting database interactions, including uploading photos and creating posts.

    Could you tell me when did this issue start? Also, let me know what solutions you’ve already tried so we don’t repeat them.

    I recommend installing the WP Crontrol plugin to check for any errors or warnings.
    Please also share a screenshot of the Scheduled Actions page.

    Are you able to upload images after you deactivate WooCommerce?
    This information will help narrow down the troubleshooting process.

    Looking forward to your response. 🙂

    Thread Starter nicowob123

    (@nicowob123)

    Hi Zubair,
    thanks for your help and quick response.

    It started 5 days ago when i tried to create a product : newly added products images would’nt upload 80% of the time and 20% of the time would upload in the library but would be impossible to use as featured images and event impossible to simply vizualize after library’s page refresh.

    i tried repairing with maint/repair.php, tried repairing actionscheduler tables in phpmyadmin, tried to clean manually tables with 0 id and activate auto increment ( i broke my db while doing so on options table, had to restore backup) . I tried several plugins (WP optimize, Advanced db celaner)

    Are you able to upload images after you deactivate WooCommerce?
    same ratio : not 8/10 times

    • This reply was modified 1 year ago by nicowob123.
    Zee

    (@doublezed2)

    Hello nicowob123,

    Thank you for your reply.

    I understand that newly added product images fail to upload most of the time, and when they do, they become unusable as featured images or fail to display after a library refresh.

    You have also tried database repairs and optimization plugins, but the issue persists even when WooCommerce is deactivated.

    This seems related to the server configuration rather than WooCommerce. I recommend deactivating all plugins, including WooCommerce, and switching to a default theme like Twenty Twenty-Four. If the issue continues, contact your web host to check for server limitations affecting the database.

    Let me know how it goes, and I’ll be happy to assist further.

    Best regards.

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

The topic ‘ActionScheduler tables issues’ is closed to new replies.