• Resolved khushbu91

    (@khushbu91)


    I have recently moved to Racknerd from Hostgator, migration was done by Racknerd guys, there were a few hiccups but it was finally done, I installed PHP Error Log plugin & am seeing these errors, am clueless as have 0 knowledge about coding/database editing

    WordPress database error Commands out of sync; you can’t run this command now for query UPDATE wp_options SET option_value = ‘1733588114’ WHERE option_name = ‘_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient, update_option

    WordPress database error Commands out of sync; you can’t run this command now for query SELECT autoload FROM wp_options WHERE option_name = ‘_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl’ LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient, update_option

    WordPress database error Commands out of sync; you can’t run this command now for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.hook=’wc_schedule_pending_batch_processes’ AND a.status IN (‘in-progress’, ‘pending’)?LIMIT 0, 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->Automattic\WooCommerce\Internal\BatchProcessing\{closure}, Automattic\WooCommerce\Internal\BatchProcessing\BatchProcessingController->remove_or_retry_failed_processors, call_user_func, as_has_scheduled_action, ActionScheduler_Store->query_action, ActionScheduler_DBStore->query_actions

    WordPress database error Commands out of sync; you can’t run this command now for query UPDATE wp_options SET option_value = ‘1730997906’ WHERE option_name = ‘_transient_timeout_2__2951165530’ made by Imagely\NGG\Util\Router->cache_lookups, Imagely\NGG\Util\Transient::update, Imagely\NGG\Util\Transient->set, set_transient, update_option

    WordPress database error Commands out of sync; you can’t run this command now for query UPDATE wp_options SET option_value = ‘1733588106’ WHERE option_name = ‘_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl’ made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient, update_option

    These keep coming and am clueless how to resolve these & how is it impacting my website.
    Thank you in advance for your help!

    System Status Report

    ### WordPress Environment ###
    
    WordPress address (URL): [Redacted]
    Site address (URL): [Redacted]
    WC Version: 9.3.3
    Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.
    Action Scheduler Version: ? 3.8.1
    Log Directory Writable: ?
    WP Version: 6.6.2
    WP Multisite: –
    WP Memory Limit: 1 GB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: LiteSpeed
    PHP Version: 7.4.33
    PHP Post Max Size: 1 GB
    PHP Time Limit: 6000
    PHP Max Input Vars: 10000
    cURL Version: 7.61.1
    OpenSSL/1.1.1k
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.11.9-MariaDB-cll-lve
    Max Upload Size: 1 GB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    [REDACTED]
    
    ### Post Type Counts ###
    
    attachment: 5337
    custom_css: 4
    custom_order_status: 5
    custom-css-js: 4
    customize_changeset: 1
    display_type: 7
    elementor_library: 3
    footer: 6
    megamenu: 3
    nav_menu_item: 75
    ngg_gallery: 3
    ngg_pictures: 137
    nomos_mapper: 6
    oembed_cache: 4
    page: 20
    post: 1
    product: 2261
    product_variation: 2335
    revision: 2
    shop_coupon: 1
    shop_order: 1447
    wcpa_pt_forms: 16
    wp_global_styles: 2
    wp_navigation: 1
    ziss: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (22) ###
    
    Error Log Monitor: by Janis Elsts – 1.7.10
    Advanced Database Cleaner: by Younes JFR. – 3.1.5
    Advanced Woo Search: by ILLID – 3.19
    Astra Pro: by Brainstorm Force – 4.8.3
    Blackhole for Bad Bots: by Jeff Starr – 3.7.3
    Click to Chat: by HoliThemes – 4.12
    Simple Custom CSS and JS: by SilkyPress.com – 3.48
    Custom Order Status for WooCommerce: by Tyche Softwares – 2.5.0
    Elementor Pro: by Elementor.com – 3.25.2
    Elementor: by Elementor.com – 3.25.4
    Enable Media Replace: by ShortPixel – 4.1.5
    LiteSpeed Cache: by LiteSpeed Technologies – 6.5.2
    WooCommerce PDF Invoices, Packing Slips, Delivery Notes and Shipping Labels: by WebToffee – 4.7.1
    Side Cart WooCommerce: by XootiX – 2.5.5
    Converter for Media: by matt plugins - Optimize images by convert WebP & AVIF – 6.1.2
    Advanced Shipment Tracking for WooCommerce: by zorem – 3.7.0
    WooCommerce Custom Product Addons Free: by Acowebs – 3.0.12
    Advanced Order Export For WooCommerce: by AlgolPlus – 3.5.5
    Ultimate Order Combination: by Fahad Mahmood – 1.8.8
    WooCommerce: by Automattic – 9.3.3
    WP Cerber Security, Anti-spam & Malware Scan: by Cerber Tech Inc. – 9.0
    NextGEN Gallery: by Imagely – 3.59.6
    
    ### Inactive Plugins (0) ###
    
    
    ### Dropin Plugins () ###
    
    advanced-cache.php: advanced-cache.php
    
    ### Settings ###
    
    Legacy API Enabled: –
    Force SSL: –
    Currency: INR (?)
    Currency Position: left
    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 days
    Level threshold: –
    Log directory size: 1,000 KB
    
    ### WC Pages ###
    
    Shop base: #5169 - /
    Cart: #5170 - /cart-2/ -  Contains the [woocommerce_cart] shortcode
    Checkout: #5171 - /checkout-2/ -  Contains the [woocommerce_checkout] shortcode
    My account: #5167 - /my-account-2/
    Terms and conditions: ? Page not set
    
    ### Theme ###
    
    Name: Astra
    Version: 4.8.3
    Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme
    Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
    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
    navigation
    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
    
    Disabled Features: experimental-blocks
    minified-js
    product-pre-publish-modal
    settings
    async-product-editor-category-field
    product-editor-template-system
    blueprint
    reactify-classic-payments-settings
    
    Daily Cron: ? Next scheduled: 2024-11-08 15:21:43 +05:30
    Options: ?
    Notes: 212
    Onboarding: completed
    
    ### Action Scheduler ###
    
    Complete: 2,382
    Oldest: 2024-10-07 16:57:37 +0000
    Newest: 2024-11-07 14:59:31 +0000
    
    Pending: 4
    Oldest: 2024-11-07 16:48:44 +0000
    Newest: 2024-11-08 10:42:56 +0000
    
    
    ### Status report information ###
    
    Generated at: 2024-11-07 22:04:53 +05:30
    • This topic was modified 3 weeks, 1 day ago by khushbu91.

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

Viewing 1 replies (of 1 total)
  • Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello khushbu91,

    Thank you for contacting WooCommerce support.

    I understand you’re seeing database errors after migrating to Racknerd from Hostgator, specifically regarding the “Commands out of sync” error in your PHP Error Log.

    Could you check WooCommerce > Status > Scheduled Actions to see if there are any Pending or Failed actions? Please share a screenshot if possible.

    Also, go to WooCommerce > Status > Tools and clear WooCommerce transients.

    Lastly, share a screenshot of Order Data Storage settings.
    I want to verify the settings.

    Looking forward to your response. ??

    Best regards.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.