Support » Plugin: WooCommerce » Woocommerce MISSING/Hidden Order and data

  • hi there,

    I hope you are guys safe & fine ..

    Suddenly without no where while working on our staging copy we found that the orders are hidden and products and coupons .. everything is missing .. from the screemshot below you will find it showing as the order numbers is counted that they are there but the tables not showing . .this applies to everything as products and coupons

    Screenshot: http://prnt.sc/sr0e1b

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter magedmoh94

    (@magedmoh94)

    We have wordpress 5.4.1 and latest woocommerce

    Plugin Support 3 Sons Development – a11n

    (@3sonsdevelopment)

    Hi @magedmoh94,

    That’s definitely alarming! Does this happen with only WooCommerce and the Twenty Twenty theme active? If so, could you please send me a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, you can paste it here.

    Thanks!

    Thread Starter magedmoh94

    (@magedmoh94)

    Hi,

    Thank you for your reply .. deactivating all the plug-ins except woocommerce doesn’t solve the issue too.


    ### WordPress Environment ###

    WordPress address (URL): https://www.staging3.tktshub.com
    Site address (URL): https://www.staging3.tktshub.com
    WC Version: 4.1.1
    REST API Version: ✔ 1.0.7
    WC Blocks Version: ✔ 2.5.16
    Action Scheduler Version: ✔ 3.1.6
    WC Admin Version: ✔ 1.1.3
    Log Directory Writable: ✔
    WP Version: 5.4.1
    WP Multisite: –
    WP Memory Limit: 768 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    External object cache: –

    ### Server Environment ###

    Server Info: Apache
    PHP Version: 7.1.33 – We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
    PHP Post Max Size: 128 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 3000
    cURL Version: 7.59.0
    OpenSSL/1.0.2r

    SUHOSIN Installed: –
    MySQL Version: 5.6.40-84.0-log
    Max Upload Size: 128 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔

    ### Database ###

    WC Database Version: 3.8.1
    WC Database Prefix: wpvv_
    Total Database Size: 21.62MB
    Database Data Size: 12.76MB
    Database Index Size: 8.86MB
    wpvv_woocommerce_sessions: Data: 0.23MB + Index: 0.02MB + Engine InnoDB
    wpvv_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvv_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvv_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpvv_woocommerce_order_items: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wpvv_woocommerce_order_itemmeta: Data: 0.25MB + Index: 0.27MB + Engine InnoDB
    wpvv_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpvv_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvv_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvv_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvv_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvv_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvv_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvv_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvv_actionscheduler_actions: Data: 0.06MB + Index: 0.11MB + Engine InnoDB
    wpvv_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvv_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvv_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvv_ash2osh_faw_callback_log: Data: 0.20MB + Index: 0.00MB + Engine InnoDB
    wpvv_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvv_comments: Data: 0.45MB + Index: 0.48MB + Engine InnoDB
    wpvv_cubeportfolio: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvv_cubeportfolio_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvv_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvv_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvv_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvv_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvv_options: Data: 4.09MB + Index: 0.08MB + Engine InnoDB
    wpvv_pantheon_sessions: Data: 0.23MB + Index: 0.25MB + Engine InnoDB
    wpvv_postmeta: Data: 4.52MB + Index: 6.03MB + Engine InnoDB
    wpvv_posts: Data: 1.52MB + Index: 0.48MB + Engine InnoDB
    wpvv_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvv_snippets: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wpvv_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvv_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvv_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvv_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvv_usermeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wpvv_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpvv_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvv_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvv_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvv_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvv_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvv_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvv_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpvv_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpvv_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpvv_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wpvv_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvv_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpvv_yith_vendors_commissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvv_yith_vendors_commissions_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvv_yith_vendors_payments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvv_yith_vendors_payments_relationship: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpvv_yoast_seo_links: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
    wpvv_yoast_seo_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB

    ### Post Type Counts ###

    attachment: 185
    coupon: 1
    custom_css: 4
    custom-css-js: 2
    customize_changeset: 10
    event: 23
    event_order: 758
    event_ticket: 403
    mc4wp-form: 1
    nav_menu_item: 47
    page: 54
    post: 21
    product: 104
    revision: 40
    shop_coupon: 4
    shop_order: 555

    ### Security ###

    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔

    ### Active Plugins (5) ###

    WooCommerce Multi-Step Checkout Pro: by SilkyPress – 2.10 – Installed version not tested with active version of WooCommerce 4.1.1
    YITH WooCommerce Multi Vendor Allow Buy Only Their Own Products: by YITHEMES – 1.0.0 – Installed version not tested with active version of WooCommerce 4.1.1
    YITH WooCommerce Multi Vendor Premium: by YITH – 3.6.2
    YITH WooCommerce Sequential Order Number Premium: by YITH – 1.2.1

    Yoast SEO: by Team Yoast – 12.7.1 – Installed version not tested with active version of WooCommerce 4.1.1

    ### Settings ###

    API Enabled: –
    Force SSL: –
    Currency: EGP (EGP)
    Currency Position: right
    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: –

    ### WC Pages ###

    Shop base: #506 – /shop/
    Cart: #507 – /cart/
    Checkout: #508 – /checkout/
    My account: ❌ Page does not contain the shortcode.
    Terms and conditions: #3550 – /terms-and-conditions/

    ### Theme ###

    Name: Twenty Twenty
    Version: 1.1 (update to version 1.3 is available)
    Author URL: https://wordpress.org/
    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: –

    ### Action Scheduler ###

    Complete: 4
    Oldest: 2019-12-05 08:51:39 +0000
    Newest: 2019-12-26 12:16:13 +0000

    Pending: 122
    Oldest: 2020-01-03 14:39:03 +0000
    Newest: 2020-06-01 20:03:00 +0000

    `

    • This reply was modified 1 year, 7 months ago by magedmoh94.
    • This reply was modified 1 year, 7 months ago by magedmoh94.
    Plugin Support 3 Sons Development – a11n

    (@3sonsdevelopment)

    Thanks for sending that over. It looks like the database has not updated to match the new version. If you haven’t done that yet, go on and run the update so the database matches the WooCommerce version.

    There was a similar issue to this with WordPress 5.0.2, but that’s been fixed.

    https://github.com/woocommerce/woocommerce/issues/22271

    You could try one of the workaround snippets that’s in the thread on GitHub to see if it helps you out here too.

    
        function fix_request_query_args_for_woocommerce( $query_args ) {
            if ( isset( $query_args['post_status'] ) && empty( $query_args['post_status'] ) ) {
                    unset( $query_args['post_status'] );
            }
            return $query_args;
        }
        add_filter( 'request', 'fix_request_query_args_for_woocommerce', 1, 1 );
    

    That could be added to the theme’s functions.php file or with a plugin like Code Snippets.

    Let me know how it goes.

    Thread Starter magedmoh94

    (@magedmoh94)

    Hi Three Sons,

    Thank you for your reply.

    First of all the snippet did not solve the issue unfortunately, and for the database update it stucks never ends .. it has been like that for weeks .. and never end updating the database so we contacted siteground support about that stuck scheduled actions of not updating the database they told us to contact woocommerce support.

    N.B: this is a staging environment on a subdomain of siteground hosting

    So what do you think might preventing the database action from being updated ?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Woocommerce MISSING/Hidden Order and data’ is closed to new replies.