WordPress database error after updating to WC version 7.5.1

Hi @nick7766

Thanks for reaching out!

I am sorry to hear that you’ve received the error logs above after updating the WooCommerce plugin to version 7.5.1.

For us to investigate this further, can you please try to switch to the default Storefront theme and only WooCommerce plugin is enabled and see if this clears the error log above?

If so, then this kind of problem is usually caused by your theme or a third-party plugin present on your site. We can run a conflict test to verify this. I’d recommend cloning your site to a staging environment and performing the tests described on this guide without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.

If this was caused by a third-party plugin present on your site, it would be best to reach out to the developers for further assistance here.

If this did not resolve the issue, please share your System Status Report, that will help us further troubleshoot.

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 into your reply here.

If you could also provide the fatal error logs (if any) under WooCommerce > Status > Logs.

You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.

Let us know how it goes!

Good morning @xue28 !

Many thanks for your feedback. We test each update extensively on our test environment before we carry it out. There were no errors here. Only in the live environment did we have the two errors in our PHP ErrorLog after implementation. There is no error entry under WooCommerce > Status.

My question, before we go deeper into the analysis, is what this error message is actually trying to tell us. Can you help me here?

Hi Nico,

My question, before we go deeper into the analysis, is what this error message is actually trying to tell us. Can you help me here?

Sure, I’d be happy to explain!

The error message you received suggests that there is an issue with the wp_2_wc_order_stats table specifically. It indicates that there are two columns in this table with the same name, which is causing an error. These two columns are called date_paid and date_completed.

The error message also tells us that the issue happened when new columns were trying to be added to this table using a command called ALTER TABLE. There was an attempt to add two new columns to the table – one for date_paid and one for date_completed. The default value for these new columns was set to 0000-00-00 00:00:00.

While you are performing the conflict test as suggested by @xue28 , would you mind sharing the following:

• System Status Report: navigate to?WooCommerce?→?Status. Select?Get system report?and then?Copy for support.
• Fatal Error log: Share a copy of any fatal error log found under WooCommerce → Status → Logs.

Once you have these, please share them in your response here.

Cheers!

Hello @beautyofcode,

thank you very much for your explanation. We understood everything.

There are no entries under WooCommerce -> Status -> Logs. All clean. Only the errors described in our PHP ErrorLog.

I am attaching the status report here.

The “conflict test” on our staging site ran without any problems as described above. The statging site was a 1:1 copy of our live site. The problem only occurred when updating on our live page.

Hope that helps narrow down the problem.
many thanks in advance for your help

Nick.

--


WordPress Environment

WordPress address (URL): https://www.hello-world.net
Site address (URL): https://www.hello-world.net
WC Version: 7.5.1
REST API Version: ?</img> 7.5.1
WC Blocks Version: ?</img> 9.6.6
Action Scheduler Version: ?</img> 3.5.4
Log Directory Writable: ?</img>
WP Version: ?</img> 6.1.1 - Es ist eine neuere Version von WordPress verfügbar (6.2)
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: –
Language: de_DE
External object cache: –

Server Environment

Server Info: Apache
PHP Version: 7.4.33
PHP Post Max Size: 75 MB
PHP Time Limit: 240
PHP Max Input Vars: 5000
cURL Version: 7.61.1
OpenSSL/1.1.1k

SUHOSIN Installed: –
MySQL Version: 10.4.28-MariaDB
Max Upload Size: 50 MB
Default Timezone is UTC: ?</img>
fsockopen/cURL: ?</img>
SoapClient: ?</img>
DOMDocument: ?</img>
GZip: ?</img>
Multibyte String: ?</img>
Remote Post: ?</img>
Remote Get: ?</img>

Database

WC Database Version: 7.5.1
WC Database Prefix: wp_2_
Datenbank-Gesamtgr??e: 317.12MB
Datenbank-Datengr??e: 249.05MB
Datenbank-Indexgr??e: 68.07MB
wp_2_woocommerce_sessions: Daten: 0.06MB + Index: 0.00MB + Engine MyISAM
wp_2_woocommerce_api_keys: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_woocommerce_attribute_taxonomies: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_woocommerce_downloadable_product_permissions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_woocommerce_order_items: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_woocommerce_order_itemmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_woocommerce_tax_rates: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_woocommerce_tax_rate_locations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_woocommerce_shipping_zones: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_woocommerce_shipping_zone_locations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_woocommerce_shipping_zone_methods: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_woocommerce_payment_tokens: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_woocommerce_payment_tokenmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_woocommerce_log: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_actionscheduler_actions: Daten: 0.05MB + Index: 0.04MB + Engine MyISAM
wp_2_actionscheduler_claims: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_actionscheduler_groups: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_2_actionscheduler_logs: Daten: 0.04MB + Index: 0.03MB + Engine MyISAM
wp_2_adtribes_my_conversions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_alm: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_borlabs_cookie_consent_log: Daten: 21.55MB + Index: 5.55MB + Engine InnoDB
wp_2_borlabs_cookie_content_blocker: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_borlabs_cookie_cookies: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_borlabs_cookie_groups: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_borlabs_cookie_script_blocker: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_borlabs_cookie_statistics: Daten: 4.52MB + Index: 6.03MB + Engine InnoDB
wp_2_bwg_album: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_bwg_album_gallery: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_bwg_gallery: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_bwg_image: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_bwg_image_comment: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_bwg_image_rate: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_bwg_image_tag: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_bwg_option: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_bwg_shortcode: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_bwg_theme: Daten: 0.03MB + Index: 0.00MB + Engine MyISAM
wp_2_commentmeta: Daten: 0.39MB + Index: 0.15MB + Engine MyISAM
wp_2_comments: Daten: 0.79MB + Index: 0.11MB + Engine MyISAM
wp_2_duplicator_pro_entities: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_2_duplicator_pro_packages: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_ewwwio_images: Daten: 20.70MB + Index: 3.25MB + Engine MyISAM
wp_2_ewwwio_queue: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_e_events: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_e_notes: Daten: 0.02MB + Index: 0.17MB + Engine InnoDB
wp_2_e_notes_users_relations: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_e_submissions: Daten: 0.02MB + Index: 0.27MB + Engine InnoDB
wp_2_e_submissions_actions_log: Daten: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_2_e_submissions_values: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_links: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_lockdowns: Daten: 0.08MB + Index: 0.02MB + Engine MyISAM
wp_2_login_fails: Daten: 1.60MB + Index: 0.56MB + Engine MyISAM
wp_2_ms_snippets: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_ngg_album: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_ngg_gallery: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_ngg_pictures: Daten: 1.52MB + Index: 0.02MB + Engine InnoDB
wp_2_options: Daten: 35.16MB + Index: 0.15MB + Engine MyISAM
wp_2_postmeta: Daten: 91.41MB + Index: 35.12MB + Engine MyISAM
wp_2_posts: Daten: 48.06MB + Index: 8.21MB + Engine MyISAM
wp_2_reorder_post_rel: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_snippets: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_2_subscribe_reloaded_subscribers: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_ta_link_clicks: Daten: 0.09MB + Index: 0.13MB + Engine InnoDB
wp_2_ta_link_clicks_meta: Daten: 1.52MB + Index: 0.59MB + Engine InnoDB
wp_2_termmeta: Daten: 0.02MB + Index: 0.02MB + Engine MyISAM
wp_2_terms: Daten: 0.02MB + Index: 0.06MB + Engine MyISAM
wp_2_term_relationships: Daten: 0.04MB + Index: 0.07MB + Engine MyISAM
wp_2_term_taxonomy: Daten: 0.03MB + Index: 0.03MB + Engine MyISAM
wp_2_tm_taskmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_tm_tasks: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_unitegallery_categories: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_2_unitegallery_galleries: Daten: 1.00MB + Index: 0.00MB + Engine MyISAM
wp_2_unitegallery_items: Daten: 0.99MB + Index: 0.03MB + Engine MyISAM
wp_2_usermeta: Daten: 0.04MB + Index: 0.03MB + Engine MyISAM
wp_2_users: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_2_wc_admin_notes: Daten: 0.05MB + Index: 0.00MB + Engine MyISAM
wp_2_wc_admin_note_actions: Daten: 0.02MB + Index: 0.01MB + Engine MyISAM
wp_2_wc_category_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wc_comments_subscription: Daten: 0.03MB + Index: 0.03MB + Engine MyISAM
wp_2_wc_customer_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wc_download_log: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wc_feedback_forms: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_follow_users: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wc_order_coupon_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wc_order_product_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wc_order_stats: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wc_order_tax_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wc_phrases: Daten: 0.02MB + Index: 0.02MB + Engine MyISAM
wp_2_wc_product_attributes_lookup: Daten: 0.08MB + Index: 0.05MB + Engine InnoDB
wp_2_wc_product_download_directories: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_wc_product_meta_lookup: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_2_wc_rate_limits: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_wc_reserved_stock: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wc_tax_rate_classes: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_2_wc_users_rated: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wc_users_voted: Daten: 0.04MB + Index: 0.06MB + Engine MyISAM
wp_2_wc_webhooks: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wfblockediplog: Daten: 0.13MB + Index: 0.07MB + Engine MyISAM
wp_2_wfblocks7: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wfconfig: Daten: 0.39MB + Index: 0.01MB + Engine MyISAM
wp_2_wfcrawlers: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wffilechanges: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wffilemods: Daten: 1.56MB + Index: 0.23MB + Engine MyISAM
wp_2_wfhits: Daten: 0.64MB + Index: 0.10MB + Engine MyISAM
wp_2_wfhoover: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wfissues: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_2_wfknownfilelist: Daten: 0.81MB + Index: 0.10MB + Engine MyISAM
wp_2_wflivetraffichuman: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wflocs: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wflogins: Daten: 0.11MB + Index: 0.03MB + Engine MyISAM
wp_2_wfls_2fa_secrets: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_wfls_settings: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wfnotifications: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wfpendingissues: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wfreversecache: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wfsnipcache: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wfstatus: Daten: 0.08MB + Index: 0.04MB + Engine MyISAM
wp_2_wftrafficrates: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wpc_comments_subscription: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wpc_phrases: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_2_wpc_users_voted: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wpgb_cards: Daten: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_2_wpgb_facets: Daten: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_2_wpgb_grids: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_wpgb_index: Daten: 0.17MB + Index: 0.22MB + Engine InnoDB
wp_2_wplc_chat_msgs: Daten: 0.17MB + Index: 0.00MB + Engine InnoDB
wp_2_wplc_chat_ratings: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wplc_chat_sessions: Daten: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_2_wplc_chat_triggers: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wplc_custom_fields: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wplc_departments: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wplc_offline_messages: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wplc_roi_conversions: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wplc_roi_goals: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wpmailsmtp_debug_events: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wpmailsmtp_tasks_meta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_2_wprm_analytics: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_wprm_ratings: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_2_wpr_rucss_resources: Daten: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_2_wpr_rucss_used_css: Daten: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_2_wpstg_queue: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_2_wp_phpmyadmin_extension__errors_log: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_yoast_indexable: Daten: 11.16MB + Index: 5.11MB + Engine InnoDB
wp_2_yoast_indexable_hierarchy: Daten: 0.05MB + Index: 0.05MB + Engine InnoDB
wp_2_yoast_migrations: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_2_yoast_primary_term: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_2_yoast_prominent_words: Daten: 0.10MB + Index: 0.19MB + Engine MyISAM
wp_2_yoast_seo_links: Daten: 0.38MB + Index: 0.20MB + Engine InnoDB
wp_2_yoast_seo_meta: Daten: 0.02MB + Index: 0.02MB + Engine MyISAM

Post Type Counts

acf-field: 21
acf-field-group: 2
amn_smtp: 2
attachment: 3476
custom_css: 3
elementor_font: 4
elementor_library: 4
envira: 32
foogallery: 1
nav_menu_item: 31
ngg_gallery: 9
ngg_pictures: 50
oembed_cache: 44
page: 13
popup: 1
popup_theme: 6
post: 116
product: 58
r3d: 33
revision: 812
schema: 2
tablepress_table: 36
thirstylink: 135
wpcf7_contact_form: 2
wpdiscuz_form: 3
wprm_recipe: 6

Security

Secure connection (HTTPS): ?</img>
Hide errors from visitors: ?</img>

Active Plugins (35)

Query Monitor: von John Blackbourn – 3.12.1
Shortcodes Ultimate: von Vova Anokhin – 5.12.11
TablePress: von Tobias B?thge – 2.1
Advanced Custom Fields PRO: von WP Engine – 6.1.3
Borlabs Cookie - Cookie Opt-in: von Borlabs GmbH – 2.2.63
Classic Editor: von WordPress-Mitwirkende – 1.6.3
Code Snippets: von Code Snippets Pro – 3.3.0
Contact Form 7 Extension For Mailchimp: von Renzo Johnson – 0.5.64
Contact Form 7: von Takayuki Miyoshi – 5.7.4
Custom Post Type UI: von WebDevStudios – 1.13.5
Elementor Pro: von Elementor.com – 3.12.2
Elementor: von Elementor.com – 3.12.1
Envira Gallery - Defaults Erweiterung: von Envira Gallery Team – 1.5.0
Envira Gallery: von Envira Gallery Team – 1.9.5
Free Downloads WooCommerce Pro: von WP Enhanced – 3.5.3
GP Premium: von Tom Usborne – 2.2.2
Lightweight Social Icons: von Thomas Usborne – 1.1
Post Types Order: von Nsp Code – 1.9.9.2
Product Filter for WooCommerce: von XforWooCommerce – 8.3.0
Real3D Flipbook: von creativeinteractivemedia – 3.36
ThirstyAffiliates Pro - Basic: von Caseproof – 1.7.14
ThirstyAffiliates: von Caseproof – 3.10.15
Unite Gallery: von Valiano – 1.7.53
UpdraftPlus – Sichern/Wiederherstellen: von UpdraftPlus.Com
DavidAnderson – 2.23.3.26

WooCommerce: von Automattic – 7.5.1
Yoast SEO Premium: von Team Yoast – 20.5
Yoast SEO: von Team Yoast – 20.5
WP Grid Builder - Elementor: von Lo?c Blascos – 1.2.3
WP Grid Builder: von Lo?c Blascos – 1.7.5
WP Mail SMTP: von WPForms – 3.7.0
WP Rezept Maker: von Bootstrapped Ventures – 8.7.5
WP Rocket: von WP Media – 3.11.5
WP STAGING PRO - Backup Duplicator & Migration: von WP-STAGING – 4.7.2
wpDiscuz: von gVectors Team – 7.5.4
Yoast SEO: WooCommerce: von Team Yoast – 15.6

Inactive Plugins (1)

EWWW Image Optimizer: von Exactly WWW – 6.9.3

Dropin Plugins (2)

advanced-cache.php: advanced-cache.php
db.php: Query Monitor Database Class (Drop-in)

Must Use Plugins (1)

WP STAGING Optimizer: von René Hermenau – 1.5.1

Settings

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: –
Order datastore: WC_Order_Data_Store_CPT

WC Pages

Shop-Basis: #3312 - /jakobswegreisen-shop/
Warenkorb: #3314 - /warenkorb/
Kasse: #3316 - /kasse/
Mein Konto: #3318 - /mein-konto/
Allgemeine Gesch?ftsbedingungen: ?</img> Seite nicht festgelegt

Theme

Name: GeneratePress
Version: 3.2.4 (Update auf Version 3.3.0 ist verfügbar)
Author URL: https://tomusborne.com
Child Theme: ?</img> – Wenn du WooCommerce mit einem Theme
das du nicht selbst entwickelt hast
an eigene Bedürfnisse anpasst
dann empfehlen wir die Verwendung eines Child-Themes. Siehe Wie du ein Child-Theme erstellst (engl.)

WooCommerce Support: ?</img>

Templates

Overrides: –

Admin

Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
multichannel-marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page

Disabled Features: minified-js
new-product-management-experience
product-variation-management
settings

Daily Cron: ?</img> Next scheduled: 2023-04-12 16:08:11 +02:00
Options: ?</img>
Notes: 116
Onboarding: completed

Action Scheduler

Abgeschlossen: 181
Oldest: 2023-03-12 13:26:26 +0100
Newest: 2023-04-12 09:32:06 +0200

Fehlgeschlagen: 3
Oldest: 2023-03-01 19:55:04 +0100
Newest: 2023-04-11 18:57:04 +0200

Ausstehend: 2
Oldest: 2023-04-13 09:32:06 +0200
Newest: 2023-04-17 14:25:06 +0200

Status report information

Generated at: 2023-04-12 12:56:45 +02:00
`

Hello @nick7766,

The “conflict test” on our staging site ran without any problems as described above.

I understand that after completing the conflict test, the site was functioning as expected in the staging environment.

To identify the culprit now, you can enable the plugins one by one until the error starts showing up again.

Let us know if you have any other questions.

Hello Saif, I don’t know if we understand each other correctly. The error occurred during the update process on the live site. It did not occur after use. The error also did not occur when testing the update on our test page.

Therefore, it is not entirely clear to me what it should do if I deactivate the plugins.

Hi,

That issue is certainly odd, sorry about that.

I think you were asked to check again after disabling all other plugins except WooCommerce to see if there was a plugin affecting the wc_order_stats table.

May I ask, can you access the database and run this SQL command:

desc wp_wc_order_stats of course, in your case, it is desc wp_2_wc_order_stats, is the command result showing a discrepancy in the table?

Another thing to do since there is a staging site, (I have read it does not have the issue), is to update the version of WordPress, you can follow these recommendations to do it.

Once it is updated, can you head to WooCommerce > status > tools > Verify base database tables and do a click on verify database.

Let us know if that makes a difference.

@ihereira
Good morning Igor!

Many thanks for helping. We just ran the SQL command on our live site. You can see the result here.

Link: 2023-04-13_07h29_32.png

Will now follow your second advice and verify the database tables under WooCommerce > status > tools.

best regards from Germany
Nick

@ihereira Ok, we ran the database test under WooCommerce > status > tools on our test site as well as on our live site. The result was “Database successfully verified”.

Creo que todo está bien. ?Tú también lo crees? ??

HI @nick7766

I’m glad that the database run successfully on both your live and test site.

Can you please confirm if you’re still seeing the error logs above on your original post here after the database update

Xue, I’m not quite sure what error logs you’re talking about. The update process to the current WC version 7.5.1 generated two errors in our PHP ErrorLog. These errors are still here. Sure, as long as I haven’t deleted them.

Is that what you wanted to know?

Hi Nico ,

I believe that @xue28 would like to see if the errors are still being generated after doing as suggested above.

Since you have confirmed doing the above, can you deactivate and then reactivate WooCommerce to see if this generates the same errors in the error log with a more recent date?

Cheers!

Hello everyone!
We just ran all the tests. The database seems to be consistent. There are no other problems.

I think we can close the ticket.

We would like to express our thanks once again for the qualified help.

Best regards from Germany
Nick

Hi Nico,

That is great to hear – we are happy to help ??

Since this has been resolved, feel free to create a new topic should you need any further help.

Also, if you have a few minutes, we’d love it if you could leave us a review:?

https://www.ads-software.com/support/plugin/woocommerce/reviews/

Cheers!