database error Unknown column ‘wp_wc_order_stats.total_sales’
-
Hi there.
Checking on debug.log today we found the following error:
[07-Dec-2023 08:30:31 UTC] WordPress database error Unknown column 'wp_wc_order_stats.total_sales' in 'field list' for query SELECT SUM( CASE WHEN wp_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) as orders_count, SUM(wp_wc_order_stats.num_items_sold) as num_items_sold, ( SUM(wp_wc_order_stats.total_sales) + COALESCE( SUM(discount_amount), 0 ) - SUM(wp_wc_order_stats.tax_total) - SUM(wp_wc_order_stats.shipping_total) + ABS( SUM( CASE WHEN wp_wc_order_stats.net_total < 0 THEN wp_wc_order_stats.net_total ELSE 0 END ) ) ) as gross_sales, SUM(wp_wc_order_stats.total_sales) AS total_sales, COALESCE( SUM(discount_amount), 0 ) AS coupons, COALESCE( coupons_count, 0 ) as coupons_count, ABS( SUM( CASE WHEN wp_wc_order_stats.net_total < 0 THEN wp_wc_order_stats.net_total ELSE 0 END ) ) AS refunds, SUM(wp_wc_order_stats.tax_total) AS taxes, SUM(wp_wc_order_stats.shipping_total) AS shipping, SUM(wp_wc_order_stats.net_total) AS net_revenue, SUM( wp_wc_order_stats.num_items_sold ) / SUM( CASE WHEN wp_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_items_per_order, SUM( wp_wc_order_stats.net_total ) / SUM( CASE WHEN wp_wc_order_stats.parent_id = 0 THEN 1 ELSE 0 END ) AS avg_order_value, COUNT( DISTINCT( wp_wc_order_stats.customer_id ) ) as total_customers FROM wp_wc_order_stats LEFT JOIN ( SELECT order_id, SUM(discount_amount) AS discount_amount, COUNT(DISTINCT coupon_id) AS coupons_count FROM wp_wc_order_coupon_lookup GROUP BY order_id ) order_coupon_lookup ON order_coupon_lookup.order_id = wp_wc_order_stats.order_id WHERE 1=1 AND ( wp_wc_order_stats.status NOT IN ( 'wc-auto-draft','wc-trash','wc-pending','wc-failed','wc-cancelled','wc-checkout-draft' ) ) AND wp_wc_order_stats.date_paid<= '2023-12-07 23:59:59' AND wp_wc_order_stats.date_paid>= '2023-12-01 00:00:00' made by wp_dashboard, do_meta_boxes, WC_Admin_Dashboard->status_widget, WC_Admin_Dashboard->get_wc_admin_performance_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\PerformanceIndicators\Controller->get_stats_data, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\Controller->get_items, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\Query->get_data, WC_Data_Store->__call, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore->get_data, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC\_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_queryThe column wp_wc_order_stats.total_sales is indeed missing.
We have developed the restyling of a website that we found with WooCommerce 3.x and we now have WooCommerce 7.7.1.
I tried to replicate the error but I apparently I couldn’t navigate to the page that generates the error. My local db is also missing that column (in fact it’s just a backup of the online db from yesterday).
I found the relative code in the file
public/wp-content/plugins/woocommerce/src/Admin/API/Reports/Orders/Stats/DataStore.phpand I thought that this file was called when visiting the page
https://www.qualenergia.loc/wp-admin/admin.php?page=wc-reports
but I still don’t get any errors in my local debug.log
- Why is this column missing? Was it an upgrade from a previous version of WC that did not go right?
- Is this column necessary? What’s the best way to go about it?
- Why can’t I get the error locally? I do get the numbers in the dashboard. Are they calculated in a different method?
Thanks for your help.
Best regards,
.S.
Viewing 13 replies - 1 through 13 (of 13 total)
-
Hi @paulsally
Thanks for reaching out!
The missing
wp_wc_order_stats.total_salescolumn issue you’re encountering usually happens when there’s a failed or incomplete update of the WooCommerce plugin. It appears that during the upgrade from WooCommerce 3.x to 7.7.1, not all database changes were applied correctly.I’d like to understand your site properly. Please share with us the System Status Report which you can find via
WooCommerce > Status > Get system report > Copy for support.You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.
Once we have more information, we’ll be able to assist you further.
Dear @xue28,
Thanks very much for your reply and your offer to understand the matter further.
In a previous update I can see, looking into an old backup, that the table wp_wc_order_stats did contain the total_sales column. But, in order to go online with the restyling of the website, we had to take again a fresh db from the website that was online at the time and execute all the updates and changes that our new code required. Maybe something has gone wrong there. Can you see from the system report if there are other parts that did not update correctly? Is there a proper way to trigger the WooCommerce DB update again? Would this be the proper way to do it?
I’m more than happy to attach the System Status Report you mentioned. Here it is, let me know if there is anymore info I can provide or if anything is missing from the report.
Thank you!
Best regards,
.S.` WordPress Environment WordPress address (URL): https://www.qualenergia.it<br>Site address (URL): https://www.qualenergia.it<br>WC Version: 7.7.1<br>REST API Version: ? 7.7.1<br>WC Blocks Version: ? 10.0.5<br>Action Scheduler Version: ? 3.6.1<br>Log Directory Writable: ?<br>WP Version: ? 6.3.1 - è disponibile una versione più recente di WordPress (6.4.2)<br>WP Multisite: –<br>WP Memory Limit: 1 GB<br>WP Debug Mode: ?<br>WP Cron: ?<br>Language: it_IT<br>External object cache: ? Server Environment Server Info: nginx/1.25.2<br>PHP Version: 7.4.33<br>PHP Post Max Size: 20 MB<br>PHP Time Limit: 600<br>PHP Max Input Vars: 1000<br>cURL Version: 7.74.0<br>OpenSSL/1.1.1n SUHOSIN Installed: –<br>MySQL Version: 8.0.27<br>Max Upload Size: 20 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ? Il tuo server non ha la classe SoapClient attiva - alcuni plugin gateway che usano SOAP potrebbero non funzionare correttamente.<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database WC Database Version: 7.7.1<br>WC Database Prefix: wp_<br>Dimensione totale database: 2327.33MB<br>Dimensione dati database: 1863.63MB<br>Dimensione indice database: 463.70MB<br>wp_woocommerce_sessions: Dati: 2.33MB + indice: 0.04MB + motore MyISAM<br>wp_woocommerce_api_keys: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_woocommerce_attribute_taxonomies: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_woocommerce_downloadable_product_permissions: Dati: 0.00MB + indice: 0.01MB + motore MyISAM<br>wp_woocommerce_order_items: Dati: 1.88MB + indice: 0.87MB + motore MyISAM<br>wp_woocommerce_order_itemmeta: Dati: 10.45MB + indice: 6.81MB + motore MyISAM<br>wp_woocommerce_tax_rates: Dati: 0.00MB + indice: 0.01MB + motore MyISAM<br>wp_woocommerce_tax_rate_locations: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_woocommerce_shipping_zones: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_woocommerce_shipping_zone_locations: Dati: 0.02MB + indice: 0.05MB + motore InnoDB<br>wp_woocommerce_shipping_zone_methods: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_woocommerce_payment_tokens: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_woocommerce_payment_tokenmeta: Dati: 0.02MB + indice: 0.03MB + motore InnoDB<br>wp_woocommerce_log: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>fbo_blacklist: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>fbo_preventivi: Dati: 0.22MB + indice: 0.23MB + motore MyISAM<br>wp_actionscheduler_actions: Dati: 3.14MB + indice: 1.69MB + motore InnoDB<br>wp_actionscheduler_claims: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_actionscheduler_groups: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_actionscheduler_logs: Dati: 2.36MB + indice: 1.53MB + motore InnoDB<br>wp_aioseo_cache: Dati: 10.02MB + indice: 0.03MB + motore InnoDB<br>wp_aioseo_notifications: Dati: 0.09MB + indice: 0.06MB + motore InnoDB<br>wp_aioseo_posts: Dati: 59.59MB + indice: 4.52MB + motore InnoDB<br>wp_aiowps_audit_log: Dati: 1.52MB + indice: 0.06MB + motore InnoDB<br>wp_aiowps_debug_log: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_aiowps_events: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_aiowps_failed_logins: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_aiowps_global_meta: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_aiowps_login_activity: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_aiowps_login_lockdown: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_aiowps_message_store: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_aiowps_permanent_block: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_bdl_log: Dati: 3.04MB + indice: 0.57MB + motore MyISAM<br>wp_betterlinkmeta: Dati: 0.02MB + indice: 0.03MB + motore InnoDB<br>wp_betterlinks: Dati: 0.02MB + indice: 0.06MB + motore InnoDB<br>wp_betterlinks_clicks: Dati: 0.02MB + indice: 0.06MB + motore InnoDB<br>wp_betterlinks_password: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_betterlinks_terms: Dati: 0.02MB + indice: 0.05MB + motore InnoDB<br>wp_betterlinks_terms_relationships: Dati: 0.02MB + indice: 0.03MB + motore InnoDB<br>wp_bws_fancytree: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_bws_fancytree_users: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_cbxwpbookmark: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_cbxwpbookmarkcat: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_cms2cms_connector_options: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_commentmeta: Dati: 0.62MB + indice: 0.70MB + motore MyISAM<br>wp_comments: Dati: 11.48MB + indice: 4.70MB + motore MyISAM<br>wp_duplicator_packages: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_followup_coupon_logs: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_followup_coupons: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_followup_customer_carts: Dati: 4.10MB + indice: 0.44MB + motore MyISAM<br>wp_followup_customer_notes: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_followup_customer_orders: Dati: 0.21MB + indice: 0.13MB + motore MyISAM<br>wp_followup_customers: Dati: 0.19MB + indice: 0.41MB + motore MyISAM<br>wp_followup_email_coupons: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_followup_email_excludes: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_followup_email_logs: Dati: 0.89MB + indice: 0.24MB + motore MyISAM<br>wp_followup_email_order_coupons: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_followup_email_orders: Dati: 5.02MB + indice: 0.83MB + motore MyISAM<br>wp_followup_email_tracking: Dati: 0.43MB + indice: 0.33MB + motore MyISAM<br>wp_followup_followup_history: Dati: 3.58MB + indice: 0.10MB + motore MyISAM<br>wp_followup_order_categories: Dati: 0.13MB + indice: 0.23MB + motore MyISAM<br>wp_followup_order_items: Dati: 0.25MB + indice: 0.44MB + motore MyISAM<br>wp_followup_subscriber_lists: Dati: 0.00MB + indice: 0.01MB + motore MyISAM<br>wp_followup_subscribers: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_followup_subscribers_to_lists: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_icl_content_status: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_icl_core_status: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_icl_flags: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_icl_languages: Dati: 0.00MB + indice: 0.01MB + motore MyISAM<br>wp_icl_languages_translations: Dati: 0.10MB + indice: 0.11MB + motore MyISAM<br>wp_icl_locale_map: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_icl_message_status: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_icl_node: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_icl_reminders: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_icl_string_positions: Dati: 0.19MB + indice: 0.04MB + motore MyISAM<br>wp_icl_string_status: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_icl_string_translations: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_icl_strings: Dati: 0.14MB + indice: 0.08MB + motore MyISAM<br>wp_icl_translate: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_icl_translate_job: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_icl_translation_batches: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_icl_translation_status: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_icl_translations: Dati: 0.01MB + indice: 0.03MB + motore MyISAM<br>wp_itbbc_history: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_itbbc_history_items: Dati: 0.02MB + indice: 0.03MB + motore InnoDB<br>wp_itsec_bans: Dati: 0.02MB + indice: 0.03MB + motore InnoDB<br>wp_itsec_dashboard_events: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_itsec_distributed_storage: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_itsec_fingerprints: Dati: 0.02MB + indice: 0.03MB + motore InnoDB<br>wp_itsec_geolocation_cache: Dati: 0.02MB + indice: 0.03MB + motore InnoDB<br>wp_itsec_lockouts: Dati: 0.02MB + indice: 0.08MB + motore InnoDB<br>wp_itsec_logs: Dati: 0.02MB + indice: 0.11MB + motore InnoDB<br>wp_itsec_mutexes: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_itsec_opaque_tokens: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_itsec_temp: Dati: 0.02MB + indice: 0.06MB + motore InnoDB<br>wp_itsec_user_groups: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_links: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_options: Dati: 20.43MB + indice: 1.15MB + motore MyISAM<br>wp_pdfprnt_templates: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_pmb_external_resources: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_pmb_project_sections: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_pmxe_exports: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_pmxe_google_cats: Dati: 0.39MB + indice: 0.00MB + motore InnoDB<br>wp_pmxe_posts: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_pmxe_templates: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_pmxi_files: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_pmxi_history: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_pmxi_images: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_pmxi_imports: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_pmxi_posts: Dati: 0.02MB + indice: 0.03MB + motore InnoDB<br>wp_pmxi_templates: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_postmeta: Dati: 275.89MB + indice: 97.82MB + motore MyISAM<br>wp_posts: Dati: 1024.91MB + indice: 22.66MB + motore MyISAM<br>wp_redirection_404: Dati: 18.05MB + indice: 22.13MB + motore InnoDB<br>wp_redirection_groups: Dati: 0.02MB + indice: 0.03MB + motore InnoDB<br>wp_redirection_items: Dati: 7.52MB + indice: 7.50MB + motore InnoDB<br>wp_redirection_logs: Dati: 18.02MB + indice: 10.08MB + motore InnoDB<br>wp_say_what_strings: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_smush_dir_images: Dati: 0.02MB + indice: 0.05MB + motore InnoDB<br>wp_term_relationships: Dati: 4.25MB + indice: 8.44MB + motore MyISAM<br>wp_term_taxonomy: Dati: 0.13MB + indice: 0.19MB + motore MyISAM<br>wp_termmeta: Dati: 0.06MB + indice: 0.03MB + motore MyISAM<br>wp_terms: Dati: 0.14MB + indice: 0.25MB + motore MyISAM<br>wp_usermeta: Dati: 10.03MB + indice: 5.97MB + motore MyISAM<br>wp_users: Dati: 0.50MB + indice: 0.57MB + motore MyISAM<br>wp_w3tc_cdn_pathmap: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_w3tc_cdn_queue: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_wc_admin_note_actions: Dati: 0.05MB + indice: 0.02MB + motore InnoDB<br>wp_wc_admin_notes: Dati: 0.06MB + indice: 0.00MB + motore InnoDB<br>wp_wc_category_lookup: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_wc_customer_lookup: Dati: 0.20MB + indice: 0.14MB + motore InnoDB<br>wp_wc_download_log: Dati: 0.02MB + indice: 0.03MB + motore InnoDB<br>wp_wc_order_addresses: Dati: 0.02MB + indice: 0.06MB + motore InnoDB<br>wp_wc_order_coupon_lookup: Dati: 0.02MB + indice: 0.03MB + motore InnoDB<br>wp_wc_order_operational_data: Dati: 0.02MB + indice: 0.03MB + motore InnoDB<br>wp_wc_order_product_lookup: Dati: 0.08MB + indice: 0.06MB + motore InnoDB<br>wp_wc_order_stats: Dati: 0.06MB + indice: 0.05MB + motore InnoDB<br>wp_wc_order_tax_lookup: Dati: 0.05MB + indice: 0.03MB + motore InnoDB<br>wp_wc_orders: Dati: 0.02MB + indice: 0.11MB + motore InnoDB<br>wp_wc_orders_meta: Dati: 0.02MB + indice: 0.03MB + motore InnoDB<br>wp_wc_product_attributes_lookup: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_wc_product_download_directories: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_wc_product_meta_lookup: Dati: 0.02MB + indice: 0.09MB + motore InnoDB<br>wp_wc_rate_limits: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_wc_reserved_stock: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_wc_tax_rate_classes: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_wc_webhooks: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_wcpdf_credit_note_number: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_wcpdf_invoice_number: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_wcpdf_packing_slip_number: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_wcpdf_proforma_number: Dati: 0.06MB + indice: 0.00MB + motore InnoDB<br>wp_wcs_payment_retries: Dati: 0.02MB + indice: 0.02MB + motore InnoDB<br>wp_wpbrads: Dati: 0.29MB + indice: 0.08MB + motore MyISAM<br>wp_wpbrcountries: Dati: 0.02MB + indice: 0.05MB + motore InnoDB<br>wp_wpbrsizes: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpbrstats: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpbrzones: Dati: 0.00MB + indice: 0.01MB + motore MyISAM<br>wp_wpbrzonesads: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpie_template: Dati: 0.02MB + indice: 0.00MB + motore MyISAM<br>wp_wpmailsmtp_debug_events: Dati: 85.61MB + indice: 0.00MB + motore InnoDB<br>wp_wpmailsmtp_tasks_meta: Dati: 0.02MB + indice: 0.00MB + motore InnoDB<br>wp_wpmlautoresponderemails: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpmlautoresponders: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpmlautorespondersforms: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpmlautoresponderslists: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpmlbounces: Dati: 1.51MB + indice: 0.66MB + motore MyISAM<br>wp_wpmlclicks: Dati: 62.12MB + indice: 83.28MB + motore MyISAM<br>wp_wpmlcontents: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpmlcountries: Dati: 0.01MB + indice: 0.02MB + motore MyISAM<br>wp_wpmlemails: Dati: 183.09MB + indice: 157.32MB + motore MyISAM<br>wp_wpmlfields: Dati: 0.01MB + indice: 0.01MB + motore MyISAM<br>wp_wpmlfieldsforms: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpmlfieldslists: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpmlforms: Dati: 0.00MB + indice: 0.01MB + motore MyISAM<br>wp_wpmlgroups: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpmlhistoriesattachments: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpmlhistorieslists: Dati: 0.07MB + indice: 0.09MB + motore MyISAM<br>wp_wpmlhistory: Dati: 6.01MB + indice: 0.09MB + motore MyISAM<br>wp_wpmllatestposts: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpmllatestpostssubscriptions: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpmllinks: Dati: 6.84MB + indice: 0.88MB + motore MyISAM<br>wp_wpmlmailinglists: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpmloptions: Dati: 0.01MB + indice: 0.01MB + motore MyISAM<br>wp_wpmlorders: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpmlposts: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpmlqueue: Dati: 0.02MB + indice: 0.06MB + motore InnoDB<br>wp_wpmlsubscribermetas: Dati: 0.38MB + indice: 0.17MB + motore MyISAM<br>wp_wpmlsubscribers: Dati: 3.99MB + indice: 2.20MB + motore MyISAM<br>wp_wpmlsubscriberslists: Dati: 0.95MB + indice: 1.25MB + motore MyISAM<br>wp_wpmlsubscribersoptions: Dati: 0.37MB + indice: 0.57MB + motore MyISAM<br>wp_wpmltemplates: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wpmlthemes: Dati: 0.19MB + indice: 0.00MB + motore MyISAM<br>wp_wpmlunsubscribes: Dati: 0.18MB + indice: 0.25MB + motore MyISAM<br>wp_wpr_rocket_cache: Dati: 7.52MB + indice: 12.66MB + motore InnoDB<br>wp_wpr_rucss_used_css: Dati: 0.02MB + indice: 0.09MB + motore InnoDB<br>wp_wt_iew_action_history: Dati: 0.00MB + indice: 0.00MB + motore MyISAM<br>wp_wt_iew_mapping_template: Dati: 0.00MB + indice: 0.00MB + motore MyISAM Post Type Counts acf: 17<br>acf-field: 85<br>acf-field-group: 18<br>attachment: 69754<br>blog: 9<br>custom_css: 1<br>event: 7<br>follow_up_email: 4<br>gallery: 7<br>itsec-dash-card: 5<br>itsec-dashboard: 1<br>nav_menu_item: 33<br>newsletter: 674<br>oembed_cache: 10<br>page: 52<br>post: 44251<br>product: 13<br>recipe: 5<br>review: 12<br>revision: 120272<br>shop_coupon: 2872<br>shop_order: 9856<br>shop_order_refund: 188<br>shop_subscription: 3025<br>team: 4<br>wc_membership_plan: 14<br>wc_user_membership: 4425<br>wpcf7_contact_form: 5 Security Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (63) Advanced Custom Fields: Repeater Field: by Elliot Condon – 2.1.0<br>Advanced Custom Fields: by WP Engine – 6.2.0<br>All in One SEO: by All in One SEO Team – 4.4.5.1<br>BE Media from Production: by CultivateWP – 1.7.0<br>iThemes Security: by iThemes – 8.1.8<br>CBX Bookmark & Favorite: by Codeboxr Team – 1.7.13<br>Contact Form 7 - Dynamic Text Extension: by SevenSpark<br>AuRise Creative – 4.0.3 Contact Form 7: by Takayuki Miyoshi – 5.8<br>Default featured image: by Jan Willem Oostendorp – 1.7.3<br>Delete All Comments Easily: by J P S – 1.3<br>Display Posts: by Bill Erickson – 3.0.2<br>GTM4WP: by Thomas Geiger – 1.18.1<br>iubenda | All-in-one Compliance for GDPR / CCPA Cookie Consent + more: by iubenda – 3.7.4<br>Lightbox with PhotoSwipe: by Arno Welzel – 5.0.43<br>LinkedIn Perfect Share: by Mirco Babini – 1.0.0<br>List category posts: by Fernando Briano – 0.88.1<br>Loco Translate: by Tim Whitlock – 2.6.6<br>Loggedin - Limit Active Logins: by Joel James – 1.3.1<br>Custom Login Page Customizer: by Hardeep Asrani – 2.2.3<br>reCAPTCHA: by Ash Matadeen – 1.6<br>Newsletters - WooCommerce Subscribers: by Tribulant Software – 1.0<br>Page scroll to id: by malihu – 1.7.8<br>PDF Embedder: by WP PDF Embedder Team – 4.6.4<br>PHP Code Widget: by Otto – 2.4<br>PopLogin: by Tradesouthwest – 1.0.0<br>Re-add text underline and justify: by Brice Capobianco – 0.4<br>Read Meter - Reading Time & Progress Bar for WordPress.: by Brainstorm Force – 1.0.6<br>Read More Without Refresh: by Eightweb Interactive – 3.3.1<br>Redirection: by John Godley – 3.4<br>Redux Developer Mode Disabler: by Team Redux – 1.0.1<br>Remove Category URL: by Valerio Souza<br>Сreativemotion – 1.1.6 Single Post Template: by Nathan Rice – 1.4.4<br>SSL Insecure Content Fixer: by WebAware – 2.7.2<br>Stop Spammers: by Trumani – 2023.4.1<br>Template for Custom Post Types: by Rahul Gandhi – 1.0.4<br>Revive Old Posts Pro Add-on: by revive.social – 3.0.9<br>Revive Old Posts: by revive.social – 9.0.19<br>User Switching: by John Blackbourn e collaboratori – 1.7.0<br>W3 Total Cache: by BoldGrid – 2.4.1<br>Widget CSS Classes: by Jory Hogeveen – 1.5.4.1<br>Widget Logic: by WPChef – 5.10.4<br>Minicart for WooCommerce: by Ahmad Shyk – 2.0.5<br>Woocommerce Custom Code: by Whitedrop – 1.0.0<br>Follow-Up Emails: by WooCommerce – 4.9.51<br>WooCommerce Italian Add-on Plus: by laboratorio d'Avanguardia – 0.8.7<br>WooCommerce Memberships: by SkyVerge – 1.9.5 (aggiornamento alla versione 1.25.2 disponibile)<br>PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.6.2<br>PDF Invoices & Packing Slips for WooCommerce - Professional: by WP Overnight – 2.14.5<br>WooCommerce Sequential Order Numbers Pro: by SkyVerge – 1.20.3<br>WooCommerce Shortcodes: by WooThemes<br>Claudio Sanches – 1.0.0 WooCommerce Subscriptions: by WooCommerce – 5.4.0 (aggiornamento alla versione 5.7.0 disponibile)<br>WooCommerce: by Automattic – 7.7.1 (aggiornamento alla versione 8.3.1 disponibile)<br>Banner Rotator: by Tribulant – 3.4.8<br>WP-CFM: by Forum One – 1.7.5<br>WP Crontrol: by John Blackbourn & crontributors – 1.16.1<br>WP Mail SMTP: by WP Mail SMTP – 3.9.0<br>Newsletter: by Tribulant – 4.9.5<br>WP Meteor: by Aleksandr Guidrevitch – 3.3.1<br>WP Simple Related Posts: by digitalcube – 1.6.0<br>Smush: by WPMU DEV – 3.14.2<br>WPMU DEV Dashboard: by WPMU DEV – 4.7.5<br>WP Overnight Sidekick: by WP Overnight – 2.5.1<br>XML Sitemap & Google News: by RavanH – 5.3.6 Inactive Plugins (23) All In One WP Security: by All In One WP Security & Firewall Team – 5.2.4<br>Asset CleanUp: Page Speed Booster: by Gabe Livan – 1.3.9.3<br>AutomateWoo: by WooCommerce – 6.0.8<br>Autoptimize: by Frank Goossens (futtta) – 3.1.8.1<br>BetterLinks: by WPDeveloper – 1.6.3<br>Cloudflare: by Cloudflare<br>Inc. – 4.12.2 CMP - Coming Soon & Maintenance Plugin: by NiteoThemes – 4.1.10<br>Debug Bar: by wordpressdotorg – 1.1.4<br>Disable Gutenberg: by Jeff Starr – 3.1<br>Lazy Load - Optimize Images: by WP Rocket – 2.3.6<br>Lazy Load for Videos: by Kevin Weber – 2.18.1<br>Newsletters - Google Analytics: by Tribulant Software – 1.5<br>PDF & Print by BestWebSoft: by BestWebSoft – 2.3.2<br>PDF & Print Pro by BestWebSoft: by BestWebSoft – 2.3.3<br>Query Monitor: by John Blackbourn – 3.13.1<br>Regione Provincia Comune: by Pasquale Bucci – 2.0<br>TaxoPress: by TaxoPress – 3.10.0<br>WooCommerce Checkout Manager: by QuadLayers – 7.1.4<br>WordPress Importer: by wordpressdotorg – 0.8.1<br>WP-Sweep: by Lester 'GaMerZ' Chan – 1.1.8<br>WP Post to PDF Enhanced: by Lewis Rosenthal – 1.1.1<br>WP Rollback: by GiveWP.com – 1.7.3<br>XML Sitemap Generator for Google: by Auctollo – 4.1.13 Dropin Plugins (3) advanced-cache.php: advanced-cache.php<br>db.php: db.php<br>object-cache.php: object-cache.php Settings API Enabled: ?<br>Force SSL: –<br>Currency: EUR (€)<br>Currency Position: right_space<br>Thousand Separator: .<br>Decimal Separator: ,<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>subscription (subscription)<br>variable (variable)<br>variable subscription (variable-subscription) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5) Connected to WooCommerce.com: ?<br>Enforce Approved Product Download Directories: –<br>HPOS feature screen enabled: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – WC Pages Shop base: #4 - /pro/acquista-online/<br>Carrello: #5 - /pro/carrello/<br>Pagamento: #6 - /pro/checkout/<br>Il mio account: #7 - /pro/mio-account/<br>Termini e condizioni: #83815 - /termini-e-condizioni/ Theme Name: QualEnergia PRO<br>Version: 1.0.0<br>Author URL: https://www.whitedrop.it<br>Child Theme: ?<br>Parent Theme Name: NewsStand - Magazine/Blog/Shop WordPress Theme<br>Parent Theme Version: 1.0.18<br>Parent Theme Author URL: https://themeforest.net/user/AVAThemes<br>WooCommerce Support: ? Templates Overrides: newsstand-child/woocommerce/archive-product.php<br>newsstand-child/woocommerce/content-product.php<br>newsstand-child/woocommerce/content-single-product.php<br>newsstand-child/woocommerce/emails/admin-cancelled-order.php<br>newsstand-child/woocommerce/emails/admin-failed-order.php<br>newsstand-child/woocommerce/emails/admin-new-order.php<br>newsstand-child/woocommerce/emails/customer-completed-order.php<br>newsstand-child/woocommerce/emails/customer-invoice.php<br>newsstand-child/woocommerce/emails/customer-new-account.php<br>newsstand-child/woocommerce/emails/customer-note.php<br>newsstand-child/woocommerce/emails/customer-processing-order.php<br>newsstand-child/woocommerce/emails/customer-refunded-order.php<br>newsstand-child/woocommerce/emails/customer-reset-password.php<br>newsstand-child/woocommerce/emails/email-addresses.php<br>newsstand-child/woocommerce/emails/email-customer-details.php<br>newsstand-child/woocommerce/emails/email-footer.php<br>newsstand-child/woocommerce/emails/email-header.php<br>newsstand-child/woocommerce/emails/email-order-details.php<br>newsstand-child/woocommerce/emails/email-styles.php<br>newsstand-child/woocommerce/emails/plain/admin-cancelled-order.php<br>newsstand-child/woocommerce/emails/plain/admin-failed-order.php<br>newsstand-child/woocommerce/emails/plain/admin-new-order.php<br>newsstand-child/woocommerce/emails/plain/customer-completed-order.php<br>newsstand-child/woocommerce/emails/plain/customer-invoice.php<br>newsstand-child/woocommerce/emails/plain/customer-new-account.php<br>newsstand-child/woocommerce/emails/plain/customer-note.php<br>newsstand-child/woocommerce/emails/plain/customer-processing-order.php<br>newsstand-child/woocommerce/emails/plain/customer-refunded-order.php<br>newsstand-child/woocommerce/emails/plain/customer-reset-password.php<br>newsstand-child/woocommerce/emails/plain/email-addresses.php<br>newsstand-child/woocommerce/emails/plain/email-customer-details.php<br>newsstand-child/woocommerce/emails/plain/email-order-details.php<br>newsstand-child/woocommerce/loop/pagination.php<br>newsstand-child/woocommerce/single-product.php Abbonamenti WCS_DEBUG: ? No<br>Subscriptions Mode: ? Live<br>Subscriptions Live URL: https://www.qualenergia.it<br>Subscriptions-core Library Version: 6.2.0<br>Subscriptions Template Theme Overrides: newsstand-child/woocommerce/emails/email-order-details.php<br>newsstand-child/woocommerce/emails/plain/email-order-details.php Subscription Statuses: trash: 14<br>auto-draft: 1<br>wc-active: 1158<br>wc-expired: 23<br>wc-pending-cancel: 27<br>wc-pending: 149<br>wc-on-hold: 1306<br>wc-cancelled: 347 WooCommerce Account Connected: ? Yes<br>Active Product Key: ? Yes<br>Custom Retry Rules: ? No<br>Custom Retry Rule Class: ? No<br>Custom Raw Retry Rule: ? No<br>Custom Retry Rule: ? No<br>Retries Migration Status: ? Completed<br>Report Cache Enabled: ? No<br>Cache Update Failures: ? 3 non riuscito Impostazione del negozio Country / State: Italia — Roma Abbonamenti per gateway di pagamento PayPal Standard: wc-cancelled: 305<br>wc-active: 528<br>wc-on-hold: 507<br>wc-pending-cancel: 25<br>wc-expired: 22<br>wc-pending: 149<br>trash: 12 Bonifico bancario: wc-on-hold: 92<br>wc-active: 180<br>wc-cancelled: 3<br>wc-pending-cancel: 1<br>trash: 1 Supporto gateway di pagamento PayPal Standard: subscriptions<br>gateway_scheduled_payments<br>subscription_payment_method_change_customer<br>subscription_cancellation<br>subscription_suspension<br>subscription_reactivation<br>products<br>refunds PayPal Reference Transactions Enabled: ? No<br>Bonifico bancario: products Admin Enabled Features: activity-panels<br>analytics<br>coupons<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page Disabled Features: product-block-editor<br>minified-js<br>new-product-management-experience<br>product-variation-management<br>settings Daily Cron: ? Next scheduled: 2023-12-09 07:39:53 +01:00<br>Options: ?<br>Notes: 91<br>Onboarding: completed Action Scheduler Canceled: 38<br>Oldest: 2023-11-18 10:23:34 +0100<br>Newest: 2024-10-25 00:00:00 +0200 Complete: 1.788<br>Oldest: 2023-11-08 02:31:54 +0100<br>Newest: 2023-12-08 16:56:38 +0100 Failed: 45<br>Oldest: 2020-02-16 12:51:20 +0100<br>Newest: 2023-12-08 18:47:55 +0100 Pending: 3.421<br>Oldest: 2023-12-08 20:17:59 +0100<br>Newest: 2024-12-31 00:00:00 +0100 Status report information Generated at: 2023-12-08 19:29:13 +01:00<br>`Not sure if it’s more convenient to look at it via a Gist in GitHub?
https://gist.github.com/sarapolselli/b9e5d81e489e80670a2a6c3e17a1aa48
I hope you can give us a hint on how to proceed.
Thanks again.
.S.Hi @paulsally,
Thanks again for getting back to us and for sharing the system status report – this is very helpful.
However, this report shows the status of your WooCommerce installations and doesn’t provide detailed information about your database.
To trigger the WooCommerce database update again, you can follow these steps:
1. Go to your WordPress Dashboard.
2. Navigate to WooCommerce > Status.
3. Click on the “Tools” tab.
4. Scroll down to the “Database Update” section.
5. Click on the “Update Database” button.
Before doing this, I recommend backing up your entire WordPress site to ensure you don’t lose any data if something goes wrong.
I hope this helps. Thanks again for reaching out.
Dear @ckadenge,
Thanks very much for your reply.
I followed the instructions in my local machine before attempting it live. We have scheduled to perform it live tonight (in about a couple of hours) and so I wanted to test it beforehand.
I receive a status message something that translates roughly to “The update has been scheduled to be run in the background” but if I go to the Scheduled Actions tab I can’t see it (maybe it’s lost in the long queue I have locally where cron is disabled but I don’t know what keywords I may use to find it).
And the column wp_wc_order_stats.total_sales doesn’t get added. Will it be added in the future?
Is it safe to run the database update on a live server?
Thanks!
.S.My guess is that, being the WC Database marked with the same version as the WC plugin code (as can be seen in the Status Report), clicking on Update the Database doesn’t trigger any action.
Any cues? Should we just add that column to remove the error in the log? But how to populate it with data?
Thanks!
Hi paulsally
Thank you for your reply.
I will not recommend manually adding the missing column to the Database.
This method might skip some steps that are taken by the automated process in the back end.The latest version of the WooCommerce plugin is 8.4.0 and your site uses 7.7.1. Therefore I will recommend updating the WooCommerce plugin to the latest version. This will also trigger a Database update.
Please take all necessary precautions before making the update, such as creating a full site backup and checking the compatibility of other plugins dependent on WooCommerce.
Here is our detailed guideline about updating the WooCommerce plugin
https://woo.com/document/how-to-update-woocommerce/Let us know how it goes ??
ThanksThanks a lot @doublezed2.
One more question. We updated the plugin to version 8.4.0 and now the WooCommerce Status page shows that the plugin is at 8.4.0 while the db is at 7.7.1 as expected.
I triggered the Update Database via WooCommerce => Tools and I received the status message:
(the update routine has been planned to be run in the background)
Should we be able to find it amongst the ones showed in the Planned Actions tab?
Can we know when it will be run exactly so that we can test that everything is working as expected? Is it safe for it to run at its convenience?
Thanks!
.S.Hi.
I forgot to say that the update mentioned in my previous post was carried out in my local machine. We’re waiting to see the result locally before taking it on production server.
In my local machine the WooCommerce status page still shows database version at 7.7.1 despite the plugin was update to 8.4.0.
I tried to run the cron by calling its url:
https://www.qualenergia.loc/wp-cron.php?doing_wp_cronI attach the status report:
` WordPress Environment WordPress address (URL): https://www.qualenergia.loc Site address (URL): https://www.qualenergia.loc WC Version: 8.4.0 REST API Version: ? 8.4.0 WC Blocks Version: ? 11.6.2 Action Scheduler Version: ? 3.7.0 Log Directory Writable: ? WP Version: ? 6.3.1 - è disponibile una versione più recente di WordPress (6.4.2) WP Multisite: – WP Memory Limit: 1 GB WP Debug Mode: ? WP Cron: – Language: it_IT External object cache: ? Server Environment Server Info: nginx/1.25.2 PHP Version: 7.4.33 PHP Post Max Size: 20 MB PHP Time Limit: 300 PHP Max Input Vars: 1000 cURL Version: 7.74.0 OpenSSL/1.1.1n SUHOSIN Installed: – MySQL Version: 8.0.27 Max Upload Size: 20 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? Il tuo server non ha la classe SoapClient attiva - alcuni plugin gateway che usano SOAP potrebbero non funzionare correttamente. DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? Database WC Database Version: 7.7.1 WC Database Prefix: wp_ Dimensione totale database: 2275.50MB Dimensione dati database: 1827.87MB Dimensione indice database: 447.63MB wp_woocommerce_sessions: Dati: 1.06MB + indice: 0.03MB + motore MyISAM wp_woocommerce_api_keys: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_woocommerce_attribute_taxonomies: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_woocommerce_downloadable_product_permissions: Dati: 0.00MB + indice: 0.01MB + motore MyISAM wp_woocommerce_order_items: Dati: 1.87MB + indice: 0.86MB + motore MyISAM wp_woocommerce_order_itemmeta: Dati: 10.42MB + indice: 6.66MB + motore MyISAM wp_woocommerce_tax_rates: Dati: 0.00MB + indice: 0.01MB + motore MyISAM wp_woocommerce_tax_rate_locations: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_woocommerce_shipping_zones: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_woocommerce_shipping_zone_locations: Dati: 0.02MB + indice: 0.05MB + motore InnoDB wp_woocommerce_shipping_zone_methods: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_woocommerce_payment_tokens: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_woocommerce_payment_tokenmeta: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wp_woocommerce_log: Dati: 0.02MB + indice: 0.02MB + motore InnoDB fbo_blacklist: Dati: 0.02MB + indice: 0.00MB + motore InnoDB fbo_preventivi: Dati: 0.22MB + indice: 0.23MB + motore MyISAM wp_actionscheduler_actions: Dati: 2.52MB + indice: 1.91MB + motore InnoDB wp_actionscheduler_claims: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_actionscheduler_groups: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_actionscheduler_logs: Dati: 1.52MB + indice: 0.67MB + motore InnoDB wp_aioseo_cache: Dati: 9.52MB + indice: 0.03MB + motore InnoDB wp_aioseo_notifications: Dati: 0.09MB + indice: 0.06MB + motore InnoDB wp_aioseo_posts: Dati: 52.61MB + indice: 4.52MB + motore InnoDB wp_aiowps_audit_log: Dati: 1.52MB + indice: 0.06MB + motore InnoDB wp_aiowps_debug_log: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_aiowps_events: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_aiowps_failed_logins: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_aiowps_global_meta: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_aiowps_login_activity: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_aiowps_login_lockdown: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_aiowps_message_store: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_aiowps_permanent_block: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_bdl_log: Dati: 3.04MB + indice: 0.57MB + motore MyISAM wp_betterlinkmeta: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wp_betterlinks: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wp_betterlinks_clicks: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wp_betterlinks_password: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_betterlinks_terms: Dati: 0.02MB + indice: 0.05MB + motore InnoDB wp_betterlinks_terms_relationships: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wp_bws_fancytree: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_bws_fancytree_users: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_cbxwpbookmark: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_cbxwpbookmarkcat: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_cms2cms_connector_options: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_commentmeta: Dati: 0.62MB + indice: 0.70MB + motore MyISAM wp_comments: Dati: 11.26MB + indice: 4.18MB + motore MyISAM wp_duplicator_packages: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_followup_coupon_logs: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_followup_coupons: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_followup_customer_carts: Dati: 4.09MB + indice: 0.38MB + motore MyISAM wp_followup_customer_notes: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_followup_customer_orders: Dati: 0.21MB + indice: 0.12MB + motore MyISAM wp_followup_customers: Dati: 0.19MB + indice: 0.32MB + motore MyISAM wp_followup_email_coupons: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_followup_email_excludes: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_followup_email_logs: Dati: 0.88MB + indice: 0.24MB + motore MyISAM wp_followup_email_order_coupons: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_followup_email_orders: Dati: 5.01MB + indice: 0.73MB + motore MyISAM wp_followup_email_tracking: Dati: 0.43MB + indice: 0.27MB + motore MyISAM wp_followup_followup_history: Dati: 3.58MB + indice: 0.10MB + motore MyISAM wp_followup_order_categories: Dati: 0.13MB + indice: 0.23MB + motore MyISAM wp_followup_order_items: Dati: 0.25MB + indice: 0.43MB + motore MyISAM wp_followup_subscriber_lists: Dati: 0.00MB + indice: 0.01MB + motore MyISAM wp_followup_subscribers: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_followup_subscribers_to_lists: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_icl_content_status: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_icl_core_status: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_icl_flags: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_icl_languages: Dati: 0.00MB + indice: 0.01MB + motore MyISAM wp_icl_languages_translations: Dati: 0.10MB + indice: 0.11MB + motore MyISAM wp_icl_locale_map: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_icl_message_status: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_icl_node: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_icl_reminders: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_icl_string_positions: Dati: 0.19MB + indice: 0.04MB + motore MyISAM wp_icl_string_status: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_icl_string_translations: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_icl_strings: Dati: 0.14MB + indice: 0.08MB + motore MyISAM wp_icl_translate: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_icl_translate_job: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_icl_translation_batches: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_icl_translation_status: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_icl_translations: Dati: 0.01MB + indice: 0.03MB + motore MyISAM wp_itbbc_history: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_itbbc_history_items: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wp_itsec_bans: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wp_itsec_dashboard_events: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_itsec_distributed_storage: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_itsec_fingerprints: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wp_itsec_geolocation_cache: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wp_itsec_lockouts: Dati: 0.02MB + indice: 0.08MB + motore InnoDB wp_itsec_logs: Dati: 0.02MB + indice: 0.11MB + motore InnoDB wp_itsec_mutexes: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_itsec_opaque_tokens: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_itsec_temp: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wp_itsec_user_groups: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_links: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_options: Dati: 10.77MB + indice: 0.94MB + motore MyISAM wp_pdfprnt_templates: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_pmb_external_resources: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_pmb_project_sections: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_pmxe_exports: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_pmxe_google_cats: Dati: 0.39MB + indice: 0.00MB + motore InnoDB wp_pmxe_posts: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_pmxe_templates: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_pmxi_files: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_pmxi_history: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_pmxi_images: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_pmxi_imports: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_pmxi_posts: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wp_pmxi_templates: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_postmeta: Dati: 274.83MB + indice: 90.04MB + motore MyISAM wp_posts: Dati: 1022.53MB + indice: 20.90MB + motore MyISAM wp_redirection_404: Dati: 17.52MB + indice: 19.16MB + motore InnoDB wp_redirection_groups: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wp_redirection_items: Dati: 7.52MB + indice: 6.45MB + motore InnoDB wp_redirection_logs: Dati: 13.52MB + indice: 8.58MB + motore InnoDB wp_say_what_strings: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_smush_dir_images: Dati: 0.02MB + indice: 0.05MB + motore InnoDB wp_term_relationships: Dati: 3.65MB + indice: 7.12MB + motore MyISAM wp_term_taxonomy: Dati: 0.13MB + indice: 0.18MB + motore MyISAM wp_termmeta: Dati: 0.06MB + indice: 0.03MB + motore MyISAM wp_terms: Dati: 0.14MB + indice: 0.22MB + motore MyISAM wp_usermeta: Dati: 9.78MB + indice: 5.33MB + motore MyISAM wp_users: Dati: 0.46MB + indice: 0.34MB + motore MyISAM wp_w3tc_cdn_pathmap: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_w3tc_cdn_queue: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_wc_admin_note_actions: Dati: 0.05MB + indice: 0.02MB + motore InnoDB wp_wc_admin_notes: Dati: 0.08MB + indice: 0.00MB + motore InnoDB wp_wc_category_lookup: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_wc_customer_lookup: Dati: 0.20MB + indice: 0.14MB + motore InnoDB wp_wc_download_log: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wp_wc_order_addresses: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wp_wc_order_coupon_lookup: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wp_wc_order_operational_data: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wp_wc_order_product_lookup: Dati: 0.09MB + indice: 0.06MB + motore InnoDB wp_wc_order_stats: Dati: 0.06MB + indice: 0.05MB + motore InnoDB wp_wc_order_tax_lookup: Dati: 0.06MB + indice: 0.03MB + motore InnoDB wp_wc_orders: Dati: 0.02MB + indice: 0.11MB + motore InnoDB wp_wc_orders_meta: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wp_wc_product_attributes_lookup: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_wc_product_download_directories: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_wc_product_meta_lookup: Dati: 0.02MB + indice: 0.09MB + motore InnoDB wp_wc_rate_limits: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_wc_reserved_stock: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_wc_tax_rate_classes: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_wc_webhooks: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_wcpdf_credit_note_number: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_wcpdf_invoice_number: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_wcpdf_packing_slip_number: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_wcpdf_proforma_number: Dati: 0.06MB + indice: 0.00MB + motore InnoDB wp_wcs_payment_retries: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wp_wpbrads: Dati: 0.28MB + indice: 0.07MB + motore MyISAM wp_wpbrcountries: Dati: 0.02MB + indice: 0.05MB + motore InnoDB wp_wpbrsizes: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpbrstats: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpbrzones: Dati: 0.00MB + indice: 0.01MB + motore MyISAM wp_wpbrzonesads: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpie_template: Dati: 0.02MB + indice: 0.00MB + motore MyISAM wp_wpmailsmtp_debug_events: Dati: 79.61MB + indice: 0.00MB + motore InnoDB wp_wpmailsmtp_tasks_meta: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wp_wpmlautoresponderemails: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpmlautoresponders: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpmlautorespondersforms: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpmlautoresponderslists: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpmlbounces: Dati: 1.51MB + indice: 0.73MB + motore MyISAM wp_wpmlclicks: Dati: 62.05MB + indice: 85.92MB + motore MyISAM wp_wpmlcontents: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpmlcountries: Dati: 0.01MB + indice: 0.02MB + motore MyISAM wp_wpmlemails: Dati: 182.91MB + indice: 157.25MB + motore MyISAM wp_wpmlfields: Dati: 0.01MB + indice: 0.01MB + motore MyISAM wp_wpmlfieldsforms: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpmlfieldslists: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpmlforms: Dati: 0.00MB + indice: 0.01MB + motore MyISAM wp_wpmlgroups: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpmlhistoriesattachments: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpmlhistorieslists: Dati: 0.07MB + indice: 0.11MB + motore MyISAM wp_wpmlhistory: Dati: 6.00MB + indice: 0.10MB + motore MyISAM wp_wpmllatestposts: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpmllatestpostssubscriptions: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpmllinks: Dati: 6.84MB + indice: 0.88MB + motore MyISAM wp_wpmlmailinglists: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpmloptions: Dati: 0.01MB + indice: 0.01MB + motore MyISAM wp_wpmlorders: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpmlposts: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpmlqueue: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wp_wpmlsubscribermetas: Dati: 0.38MB + indice: 0.17MB + motore MyISAM wp_wpmlsubscribers: Dati: 3.99MB + indice: 2.49MB + motore MyISAM wp_wpmlsubscriberslists: Dati: 0.94MB + indice: 1.34MB + motore MyISAM wp_wpmlsubscribersoptions: Dati: 0.37MB + indice: 0.60MB + motore MyISAM wp_wpmltemplates: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wpmlthemes: Dati: 0.19MB + indice: 0.00MB + motore MyISAM wp_wpmlunsubscribes: Dati: 0.18MB + indice: 0.27MB + motore MyISAM wp_wpr_rocket_cache: Dati: 7.52MB + indice: 12.66MB + motore InnoDB wp_wpr_rucss_used_css: Dati: 0.02MB + indice: 0.09MB + motore InnoDB wp_wt_iew_action_history: Dati: 0.00MB + indice: 0.00MB + motore MyISAM wp_wt_iew_mapping_template: Dati: 0.00MB + indice: 0.00MB + motore MyISAM Post Type Counts acf: 17 acf-field: 85 acf-field-group: 18 attachment: 69695 blog: 9 custom_css: 1 event: 7 follow_up_email: 4 gallery: 7 itsec-dash-card: 5 itsec-dashboard: 1 nav_menu_item: 33 newsletter: 673 oembed_cache: 10 page: 52 post: 44042 product: 13 recipe: 5 review: 12 revision: 119870 shop_coupon: 2872 shop_order: 9844 shop_order_refund: 188 shop_subscription: 3015 team: 4 wc_membership_plan: 14 wc_user_membership: 4412 wpcf7_contact_form: 5 Security Secure connection (HTTPS): ? Hide errors from visitors: ?I messaggi di errore non saranno mostrati ai visitatori. Active Plugins (64) Advanced Custom Fields: Repeater Field: by Elliot Condon – 2.1.0 Advanced Custom Fields: by WP Engine – 6.2.0 All in One SEO: by All in One SEO Team – 4.4.5.1 BE Media from Production: by CultivateWP – 1.7.0 iThemes Security: by iThemes – 8.1.8 CBX Bookmark & Favorite: by Codeboxr Team – 1.7.13 Contact Form 7 - Dynamic Text Extension: by SevenSpark AuRise Creative – 4.0.3 Contact Form 7: by Takayuki Miyoshi – 5.8 Default featured image: by Jan Willem Oostendorp – 1.7.3 Delete All Comments Easily: by J P S – 1.3 Display Posts: by Bill Erickson – 3.0.2 GTM4WP: by Thomas Geiger – 1.18.1 iubenda | All-in-one Compliance for GDPR / CCPA Cookie Consent + more: by iubenda – 3.7.4 Lightbox with PhotoSwipe: by Arno Welzel – 5.0.43 LinkedIn Perfect Share: by Mirco Babini – 1.0.0 List category posts: by Fernando Briano – 0.88.1 Loco Translate: by Tim Whitlock – 2.6.6 Loggedin - Limit Active Logins: by Joel James – 1.3.1 Custom Login Page Customizer: by Hardeep Asrani – 2.2.3 reCAPTCHA: by Ash Matadeen – 1.6 Newsletters - WooCommerce Subscribers: by Tribulant Software – 1.0 Page scroll to id: by malihu – 1.7.8 PDF Embedder: by WP PDF Embedder Team – 4.6.4 PDF e Stampa Pro di BestWebSoft: by MigliorWebSoft – 2.3.3 PHP Code Widget: by Otto – 2.4 PopLogin: by Tradesouthwest – 1.0.0 Re-add text underline and justify: by Brice Capobianco – 0.4 Read Meter - Reading Time & Progress Bar for WordPress.: by Brainstorm Force – 1.0.6 Read More Without Refresh: by Eightweb Interactive – 3.3.1 Redirection: by John Godley – 3.4 Redux Developer Mode Disabler: by Team Redux – 1.0.1 Remove Category URL: by Valerio Souza Сreativemotion – 1.1.6 Single Post Template: by Nathan Rice – 1.4.4 SSL Insecure Content Fixer: by WebAware – 2.7.2 Stop Spammers: by Trumani – 2023.4.1 Template for Custom Post Types: by Rahul Gandhi – 1.0.4 Revive Old Posts Pro Add-on: by revive.social – 3.0.9 Revive Old Posts: by revive.social – 9.0.19 User Switching: by John Blackbourn e collaboratori – 1.7.0 W3 Total Cache: by BoldGrid – 2.4.1 Widget CSS Classes: by Jory Hogeveen – 1.5.4.1 Widget Logic: by WPChef – 5.10.4 Minicart for WooCommerce: by Ahmad Shyk – 2.0.5 Woocommerce Custom Code: by Whitedrop – 1.0.0 Follow-Up Emails: by WooCommerce – 4.9.51 WooCommerce Italian Add-on Plus: by laboratorio d'Avanguardia – 0.8.7 WooCommerce Memberships: by SkyVerge – 1.9.5 (aggiornamento alla versione 1.25.2 disponibile) PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.6.2 PDF Invoices & Packing Slips for WooCommerce - Professional: by WP Overnight – 2.14.5 WooCommerce Sequential Order Numbers Pro: by SkyVerge – 1.20.3 WooCommerce Shortcodes: by WooThemes Claudio Sanches – 1.0.0 WooCommerce Subscriptions: by WooCommerce – 5.4.0 (aggiornamento alla versione 5.7.0 disponibile) WooCommerce: by Automattic – 8.4.0 Banner Rotator: by Tribulant – 3.4.8 WP-CFM: by Forum One – 1.7.5 WP Crontrol: by John Blackbourn e collaboratori – 1.16.1 WP Mail SMTP: by WP Mail SMTP – 3.9.0 Newsletter: by Tribulant – 4.9.5 WP Meteor: by Aleksandr Guidrevitch – 3.3.1 WP Simple Related Posts: by digitalcube – 1.6.0 Smush: by WPMU DEV – 3.14.2 WPMU DEV Dashboard: by WPMU DEV – 4.7.5 WP Overnight Sidekick: by WP Overnight – 2.5.1 XML Sitemap & Google News: by RavanH – 5.3.6 Inactive Plugins (22) All In One WP Security: by All In One WP Security & Firewall Team – 5.2.4 Asset CleanUp: Page Speed Booster: by Gabe Livan – 1.3.9.3 AutomateWoo: by WooCommerce – 6.0.8 (aggiornamento alla versione 6.0.10 disponibile) Autoptimize: by Frank Goossens (futtta) – 3.1.8.1 BetterLinks: by WPDeveloper – 1.6.3 Cloudflare: by Cloudflare Inc. – 4.12.2 CMP - Coming Soon & Maintenance Plugin: by NiteoThemes – 4.1.10 Debug Bar: by wordpressdotorg – 1.1.4 Disable Gutenberg: by Jeff Starr – 3.1 Lazy Load - Optimize Images: by WP Rocket – 2.3.6 Lazy Load for Videos: by Kevin Weber – 2.18.1 Newsletters - Google Analytics: by Tribulant Software – 1.5 PDF & Print by BestWebSoft: by BestWebSoft – 2.3.2 Query Monitor: by John Blackbourn – 3.13.1 Regione Provincia Comune: by Pasquale Bucci – 2.0 TaxoPress: by TaxoPress – 3.10.0 WooCommerce Checkout Manager: by QuadLayers – 7.1.4 WordPress Importer: by wordpressdotorg – 0.8.1 WP-Sweep: by Lester 'GaMerZ' Chan – 1.1.8 WP Post to PDF Enhanced: by Lewis Rosenthal – 1.1.1 WP Rollback: by GiveWP.com – 1.7.3 XML Sitemap Generator for Google: by Auctollo – 4.1.13 Dropin Plugins (3) advanced-cache.php: advanced-cache.php db.php: db.php object-cache.php: object-cache.php 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) subscription (subscription) variable (variable) variable subscription (variable-subscription) 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 Woo.com: ? Enforce Approved Product Download Directories: – HPOS feature screen enabled: – HPOS feature enabled: – Order datastore: WC_Order_Data_Store_CPT HPOS data sync enabled: – WC Pages Shop base: #4 - /pro/acquista-online/ Carrello: #5 - /pro/carrello/ Pagamento: #6 - /pro/checkout/ Il mio account: #7 - /pro/mio-account/ Termini e condizioni: #83815 - /termini-e-condizioni/ Theme Name: QualEnergia PRO Version: 1.0.0 Author URL: https://www.whitedrop.it Child Theme: ? Parent Theme Name: NewsStand - Magazine/Blog/Shop WordPress Theme Parent Theme Version: 1.0.18 Parent Theme Author URL: https://themeforest.net/user/AVAThemes WooCommerce Support: ? Templates Overrides: newsstand-child/woocommerce/archive-product.php newsstand-child/woocommerce/content-product.php newsstand-child/woocommerce/content-single-product.php newsstand-child/woocommerce/emails/admin-cancelled-order.php newsstand-child/woocommerce/emails/admin-failed-order.php newsstand-child/woocommerce/emails/admin-new-order.php newsstand-child/woocommerce/emails/customer-completed-order.php newsstand-child/woocommerce/emails/customer-invoice.php newsstand-child/woocommerce/emails/customer-new-account.php newsstand-child/woocommerce/emails/customer-note.php newsstand-child/woocommerce/emails/customer-processing-order.php newsstand-child/woocommerce/emails/customer-refunded-order.php newsstand-child/woocommerce/emails/customer-reset-password.php newsstand-child/woocommerce/emails/email-addresses.php newsstand-child/woocommerce/emails/email-customer-details.php newsstand-child/woocommerce/emails/email-footer.php newsstand-child/woocommerce/emails/email-header.php newsstand-child/woocommerce/emails/email-order-details.php newsstand-child/woocommerce/emails/email-styles.php newsstand-child/woocommerce/emails/plain/admin-cancelled-order.php newsstand-child/woocommerce/emails/plain/admin-failed-order.php newsstand-child/woocommerce/emails/plain/admin-new-order.php newsstand-child/woocommerce/emails/plain/customer-completed-order.php newsstand-child/woocommerce/emails/plain/customer-invoice.php newsstand-child/woocommerce/emails/plain/customer-new-account.php newsstand-child/woocommerce/emails/plain/customer-note.php newsstand-child/woocommerce/emails/plain/customer-processing-order.php newsstand-child/woocommerce/emails/plain/customer-refunded-order.php newsstand-child/woocommerce/emails/plain/customer-reset-password.php newsstand-child/woocommerce/emails/plain/email-addresses.php newsstand-child/woocommerce/emails/plain/email-customer-details.php newsstand-child/woocommerce/emails/plain/email-order-details.php newsstand-child/woocommerce/loop/pagination.php newsstand-child/woocommerce/single-product.php Abbonamenti WCS_DEBUG: ? No Subscriptions Mode: ? Staging Subscriptions Live URL: https://www.qualenergia.it Subscriptions-core Library Version: 6.2.0 Subscriptions Template Theme Overrides: newsstand-child/woocommerce/emails/email-order-details.php newsstand-child/woocommerce/emails/plain/email-order-details.php Subscription Statuses: trash: 13 wc-active: 1154 wc-expired: 23 wc-pending-cancel: 27 wc-pending: 148 wc-on-hold: 1303 wc-cancelled: 347 WooCommerce Account Connected: ? Yes Active Product Key: ? Yes Custom Retry Rules: ? No Custom Retry Rule Class: ? No Custom Raw Retry Rule: ? No Custom Retry Rule: ? No Retries Migration Status: ? Completed Report Cache Enabled: ? No Cache Update Failures: ? 3 non riuscito Impostazione del negozio Country / State: Italia — Roma Abbonamenti per gateway di pagamento PayPal Standard: wc-cancelled: 305 wc-active: 526 wc-on-hold: 505 wc-pending-cancel: 25 wc-expired: 22 wc-pending: 148 trash: 11 Bonifico bancario: wc-on-hold: 92 wc-active: 178 wc-cancelled: 3 wc-pending-cancel: 1 trash: 1 Supporto gateway di pagamento PayPal Standard: subscriptions gateway_scheduled_payments subscription_payment_method_change_customer subscription_cancellation subscription_suspension subscription_reactivation products refunds PayPal Reference Transactions Enabled: ? No Bonifico bancario: products Admin Enabled Features: activity-panels analytics product-block-editor coupons core-profiler 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 product-variation-management product-virtual-downloadable 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: customize-store minified-js new-product-management-experience product-external-affiliate settings async-product-editor-category-field Daily Cron: ? Next scheduled: 2023-12-15 07:39:53 +01:00 Options: ? Notes: 92 Onboarding: completed Action Scheduler Operazione annullata: 37 Oldest: 2023-11-18 10:23:34 +0100 Newest: 2024-10-25 00:00:00 +0200 Completato: 1.863 Oldest: 2023-11-05 04:31:51 +0100 Newest: 2023-12-14 22:44:08 +0100 Operazione non riuscita: 42 Oldest: 2020-02-16 12:51:20 +0100 Newest: 2023-12-05 15:18:30 +0100 In attesa: 3.412 Oldest: 2023-12-07 16:36:08 +0100 Newest: 2024-12-31 00:00:00 +0100 Status report information Generated at: 2023-12-14 23:42:38 +01:00 `What should trigger the database update?
Thanks!
One more question: why does the button “Update Database” after updating the plugin doesn’t show up? Was it silenced in any way?
Hi @paulsally
I understand that the database update is still being processed at the background.
In attesa: 3.412Checking your SSR, I can see that there are a lot of pending tasks on your site. Please run them manually by going to WooCommerce > Status > Scheduled Actions > Pending.
The database update task is surely stuck in these pile of pending tasks. You can also look for that specific task to manually run as well.
Let us know how it goes!
Thanks @xue28,
I could finally find the hook corresponding to the database update “woocommerce_update_db_to_current_version” and ran it manually. After that the database version was the same as the plugin version.
In our production site there are 3438 pending Scheduled Actions. Does this imply some kind of problem? Should we be warned?
Thanks.
.S.Hi @paulsally
I could finally find the hook corresponding to the database update “woocommerce_update_db_to_current_version” and ran it manually. After that the database version was the same as the plugin version.
We’re glad that worked! ??
In our production site there are 3438 pending Scheduled Actions. Does this imply some kind of problem? Should we be warned?
Regarding your question, a high number of pending Scheduled Actions doesn’t necessarily indicate a problem. Scheduled Actions are tasks that your site plans to run in the future, including things like sending emails, processing payments, and more. Having a large number of them could simply mean there’s a lot of activity on your site.
However, if these actions remain pending for an unusually long time, it could indicate an issue with your site’s cron system or a conflict with another plugin. If you’re noticing any performance issues or if actions are not completing as they should, I would recommend checking your server’s error logs for any clues or reaching out to your hosting provider.
Hope this helps!
Viewing 13 replies - 1 through 13 (of 13 total)
- The topic ‘database error Unknown column ‘wp_wc_order_stats.total_sales’’ is closed to new replies.
