Woocommerce MISSING/Hidden Order and data

magedmoh94
(@magedmoh94)

1 year, 7 months ago

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)

1 year, 7 months ago

We have wordpress 5.4.1 and latest woocommerce

Plugin Support 3 Sons Development – a11n
(@3sonsdevelopment)

1 year, 7 months ago

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)

1 year, 7 months ago
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)

1 year, 7 months ago
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)

1 year, 7 months ago

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.

WordPress.org

Woocommerce MISSING/Hidden Order and data

Views