Error Connecting to database
-
Hi
i am not sure who to ask, as the hosting people say there is nothing wrong but every time i add or edit an item with woocommerce it will come up with error connection lost or cant connect to database
-
Hi @dazsmodels let’s start with a SSR. If you could please go into your site and go to WooCommerce > Status > Get System Report and the paste that here using a Code block that would be great.
This will allow us to see any conflicting issues.
Thank you
<br>### WordPress Environment ###<br><br>WordPress address (URL): https://www.dazsmodels.co.uk<br>Site address (URL): https://www.dazsmodels.co.uk<br>WC Version: 9.8.5<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ✔ 3.9.2<br>Log Directory Writable: ✔<br>WP Version: 6.8.1<br>WP Multisite: –<br>WP Memory Limit: 4 GB<br>WP Debug Mode: –<br>WP Cron: –<br>Language: en_GB<br>External object cache: ✔<br><br>### Server Environment ###<br><br>Server Info: LiteSpeed<br>PHP Version: 8.3.20<br>PHP Post Max Size: 512 MB<br>PHP Time Limit: 360<br>PHP Max Input Vars: 1000<br>cURL Version: 8.13.0<br>OpenSSL/1.1.1w<br><br>SUHOSIN Installed: –<br>MySQL Version: 10.11.11-MariaDB-cll-lve<br>Max Upload Size: 512 MB<br>Default Timezone is UTC: ✔<br>fsockopen/cURL: ✔<br>SoapClient: ✔<br>DOMDocument: ✔<br>GZip: ✔<br>Multibyte String: ✔<br>Remote Post: ✔<br>Remote Get: ✔<br><br>### Database ###<br><br>WC Database Version: 9.8.5<br>WC Database Prefix: nOQFkPH_<br>Total Database Size: 3722.07MB<br>Database Data Size: 2799.35MB<br>Database Index Size: 922.72MB<br>nOQFkPH_woocommerce_sessions: Data: 45.08MB + Index: 2.02MB + Engine InnoDB<br>nOQFkPH_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_woocommerce_order_items: Data: 2.52MB + Index: 0.91MB + Engine InnoDB<br>nOQFkPH_woocommerce_order_itemmeta: Data: 14.56MB + Index: 33.67MB + Engine InnoDB<br>nOQFkPH_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_woocommerce_shipping_zone_locations: Data: 0.11MB + Index: 0.23MB + Engine InnoDB<br>nOQFkPH_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>fin_costs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>fin_inventory: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>fin_purchase_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>fin_taxpaid: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>fin_transfers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>fin_vendors: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ic_woo_full_details_mv: Data: 3.52MB + Index: 0.19MB + Engine InnoDB<br>ic_woo_full_details_v: Data: 0.00MB + Index: 0.00MB + Engine<br>ic_woo_lookup_t: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ic_woo_orders_mv: Data: 5.52MB + Index: 0.33MB + Engine InnoDB<br>ic_woo_orders_v: Data: 0.00MB + Index: 0.00MB + Engine<br>ic_woo_order_details_v: Data: 0.00MB + Index: 0.00MB + Engine<br>ic_woo_order_items_v: Data: 0.00MB + Index: 0.00MB + Engine<br>ic_woo_prefix_v: Data: 0.00MB + Index: 0.00MB + Engine<br>ic_woo_product_attributes_v: Data: 0.00MB + Index: 0.00MB + Engine<br>ic_woo_product_multi_attrib_v: Data: 0.00MB + Index: 0.00MB + Engine<br>ic_woo_product_uniq_attrib_v: Data: 0.00MB + Index: 0.00MB + Engine<br>ic_woo_prod_details_v: Data: 0.00MB + Index: 0.00MB + Engine<br>nOQFkPH_actionscheduler_actions: Data: 24.55MB + Index: 17.86MB + Engine InnoDB<br>nOQFkPH_actionscheduler_claims: Data: 0.36MB + Index: 0.20MB + Engine InnoDB<br>nOQFkPH_actionscheduler_groups: Data: 0.08MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_actionscheduler_logs: Data: 19.55MB + Index: 9.03MB + Engine InnoDB<br>nOQFkPH_atum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_atum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_atum_product_data: Data: 0.45MB + Index: 0.28MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_cart: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_interface: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_locations_tree: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_posts: Data: 4.52MB + Index: 0.28MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_posts_columns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_posts_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_brb_business: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_brb_review: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_bv_activities_store: Data: 181.73MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_cartflows_ca_cart_abandonment: Data: 1.52MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_cartflows_ca_email_history: Data: 0.20MB + Index: 0.19MB + Engine InnoDB<br>nOQFkPH_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_cleantalk_ac_log: Data: 1.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_cleantalk_connection_reports: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_cleantalk_sessions: Data: 7.05MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_cleantalk_sfw: Data: 1.52MB + Index: 1.52MB + Engine InnoDB<br>nOQFkPH_cleantalk_sfw_logs: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_cleantalk_sfw_personal: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_cleantalk_spamscan_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_cleantalk_ua_bl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_cleantalk_wc_spam_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_commentmeta: Data: 0.06MB + Index: 0.17MB + Engine InnoDB<br>nOQFkPH_comments: Data: 8.52MB + Index: 12.61MB + Engine InnoDB<br>nOQFkPH_commercekit_ajs_product_index: Data: 11.52MB + Index: 0.38MB + Engine InnoDB<br>nOQFkPH_commercekit_searches: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_commercekit_sg_post_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_commercekit_swatches_cache_count: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_commercekit_waitlist: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_commercekit_wishlist: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_commercekit_wishlist_items: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_dgwt_wcas_stats: Data: 0.17MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_dologin_failure: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_dologin_pswdless: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_dologin_sms: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_ebay_accounts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_auctions: Data: 117.58MB + Index: 2.19MB + Engine InnoDB<br>nOQFkPH_ebay_categories: Data: 2.52MB + Index: 0.69MB + Engine InnoDB<br>nOQFkPH_ebay_documents: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_ebay_jobs: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_log: Data: 154.11MB + Index: 3.33MB + Engine InnoDB<br>nOQFkPH_ebay_manufacturers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_messages: Data: 9.52MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_orders: Data: 134.56MB + Index: 0.34MB + Engine InnoDB<br>nOQFkPH_ebay_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_profiles: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_responsible_persons: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_shipping: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_sites: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_stocks_log: Data: 1.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_store_categories: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_ebay_transactions: Data: 109.52MB + Index: 0.50MB + Engine InnoDB<br>nOQFkPH_eib2bpro_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_eib2bpro_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_eib2bpro_note: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_eib2bpro_requests: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_eib2bpro_todo: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB<br>nOQFkPH_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_e_submissions: Data: 0.30MB + Index: 0.50MB + Engine InnoDB<br>nOQFkPH_e_submissions_actions_log: Data: 0.08MB + Index: 0.11MB + Engine InnoDB<br>nOQFkPH_e_submissions_values: Data: 1.52MB + Index: 0.16MB + Engine InnoDB<br>nOQFkPH_ff_scheduled_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_draft_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_entry_details: Data: 0.20MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_forms: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_form_analytics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_order_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_submissions: Data: 0.30MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_submission_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_subscriptions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fsmpt_email_logs: Data: 4.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fswcwallet: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fswcwallet_transaction: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fswcwallet_withdrawal_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_gla_budget_recommendations: Data: 0.19MB + Index: 0.11MB + Engine InnoDB<br>nOQFkPH_gla_merchant_issues: Data: 2.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_gla_shipping_rates: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_icegram_tracking: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_jetpack_waf_blocklog: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_litespeed_avatar: Data: 0.36MB + Index: 0.23MB + Engine InnoDB<br>nOQFkPH_litespeed_img_optming: Data: 4.52MB + Index: 6.55MB + Engine InnoDB<br>nOQFkPH_litespeed_url: Data: 0.27MB + Index: 0.34MB + Engine InnoDB<br>nOQFkPH_litespeed_url_file: Data: 0.25MB + Index: 0.63MB + Engine InnoDB<br>nOQFkPH_mailster_action_bounces: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_mailster_action_clicks: Data: 0.05MB + Index: 0.08MB + Engine InnoDB<br>nOQFkPH_mailster_action_errors: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_mailster_action_opens: Data: 0.23MB + Index: 0.34MB + Engine InnoDB<br>nOQFkPH_mailster_action_sent: Data: 0.44MB + Index: 0.63MB + Engine InnoDB<br>nOQFkPH_mailster_action_unsubs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_mailster_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_mailster_forms_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_mailster_forms_tags: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_mailster_form_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_mailster_form_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_mailster_links: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_mailster_lists_subscribers: Data: 0.34MB + Index: 0.38MB + Engine InnoDB<br>nOQFkPH_mailster_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_mailster_queue: Data: 0.11MB + Index: 0.22MB + Engine InnoDB<br>nOQFkPH_mailster_subscribers: Data: 1.52MB + Index: 0.66MB + Engine InnoDB<br>nOQFkPH_mailster_subscriber_fields: Data: 0.41MB + Index: 0.61MB + Engine InnoDB<br>nOQFkPH_mailster_subscriber_meta: Data: 2.52MB + Index: 3.06MB + Engine InnoDB<br>nOQFkPH_mailster_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_mailster_tags_subscribers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_mailster_workflows: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_mollie_pending_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_area_codes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_backend_sendings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_bound_phones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_call_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_campaign_gift_track: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_chat_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_client_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_client_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_order_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_phone_numbers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_phone_number_group_assignment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_scheduler: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_sms_inbox: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_states: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_text_sms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_time_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_trivia_answers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_trivia_questions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_user_phone_numbers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_viral_coupon_codes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_viral_friends: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_widget_style: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_woo_autoresponders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_options: Data: 79.16MB + Index: 11.36MB + Engine InnoDB<br>nOQFkPH_postmeta: Data: 537.98MB + Index: 520.95MB + Engine InnoDB<br>nOQFkPH_posts: Data: 812.56MB + Index: 17.06MB + Engine InnoDB<br>nOQFkPH_prfi_object: Data: 15.55MB + Index: 0.41MB + Engine InnoDB<br>nOQFkPH_qss: Data: 5.52MB + Index: 3.03MB + Engine InnoDB<br>nOQFkPH_qss_jsonld: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_qss_redirects: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>nOQFkPH_qss_redirects_log: Data: 30.05MB + Index: 5.05MB + Engine InnoDB<br>nOQFkPH_search_filter_cache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_search_filter_term_results: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_seopress_content_analysis: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_seopress_seo_issues: Data: 1.52MB + Index: 0.16MB + Engine InnoDB<br>nOQFkPH_seopress_significant_keywords: Data: 5.52MB + Index: 5.03MB + Engine InnoDB<br>nOQFkPH_shortpixel_folders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_shortpixel_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_shortpixel_postmeta: Data: 228.89MB + Index: 105.66MB + Engine InnoDB<br>nOQFkPH_shortpixel_queue: Data: 2.52MB + Index: 6.05MB + Engine InnoDB<br>nOQFkPH_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_spbc_auth_logs: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_spbc_backuped_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_backups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_bfp_blocked: Data: 0.20MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_cure_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_firewall_data_v4: Data: 1.52MB + Index: 1.52MB + Engine InnoDB<br>nOQFkPH_spbc_firewall_data_v6: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_spbc_firewall_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_firewall__personal_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_firewall__personal_ips_v4: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_spbc_firewall__personal_ips_v6: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_spbc_important_files: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_spbc_important_file_snapshots: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_monitoring_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_spbc_scan_frontend: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_scan_links_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_spbc_scan_results: Data: 14.19MB + Index: 4.11MB + Engine InnoDB<br>nOQFkPH_spbc_scan_results_log: Data: 3.52MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_scan_signatures: Data: 0.36MB + Index: 0.08MB + Engine InnoDB<br>nOQFkPH_spbc_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_surface_completed_dirs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_traffic_control_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_termmeta: Data: 3.52MB + Index: 9.55MB + Engine InnoDB<br>nOQFkPH_terms: Data: 1.52MB + Index: 0.78MB + Engine InnoDB<br>nOQFkPH_term_relationships: Data: 5.52MB + Index: 3.52MB + Engine InnoDB<br>nOQFkPH_term_taxonomy: Data: 1.52MB + Index: 1.92MB + Engine InnoDB<br>nOQFkPH_trp_gettext_en_gb: Data: 0.38MB + Index: 0.34MB + Engine InnoDB<br>nOQFkPH_usermeta: Data: 7.55MB + Index: 13.55MB + Engine InnoDB<br>nOQFkPH_users: Data: 0.50MB + Index: 0.58MB + Engine InnoDB<br>nOQFkPH_w3tc_alwayscached_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wamc_campaign: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wamc_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wamc_user_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wc_admin_notes: Data: 0.13MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wc_customer_lookup: Data: 0.50MB + Index: 0.25MB + Engine InnoDB<br>nOQFkPH_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_wc_orders: Data: 2.52MB + Index: 2.22MB + Engine InnoDB<br>nOQFkPH_wc_orders_meta: Data: 25.59MB + Index: 31.17MB + Engine InnoDB<br>nOQFkPH_wc_order_addresses: Data: 3.52MB + Index: 2.09MB + Engine InnoDB<br>nOQFkPH_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_wc_order_operational_data: Data: 1.52MB + Index: 0.53MB + Engine InnoDB<br>nOQFkPH_wc_order_product_lookup: Data: 1.52MB + Index: 0.81MB + Engine InnoDB<br>nOQFkPH_wc_order_stats: Data: 1.52MB + Index: 0.61MB + Engine InnoDB<br>nOQFkPH_wc_order_tax_lookup: Data: 0.08MB + Index: 0.09MB + Engine InnoDB<br>nOQFkPH_wc_product_attributes_lookup: Data: 3.52MB + Index: 2.52MB + Engine InnoDB<br>nOQFkPH_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wc_product_meta_lookup: Data: 1.52MB + Index: 1.22MB + Engine InnoDB<br>nOQFkPH_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wfknownfilelist: Data: 11.52MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_woocommerce_exported_csv_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_woocommerce_gc_activity: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_woocommerce_gc_cards: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_woocommerce_gc_cardsmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_woof_front_builder: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_woof_query_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_woof_sd: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_woof_sd_presets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_woof_stat_buffer: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_woof_stat_tmp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wooznd_giftcard_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wooznd_refund_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wooznd_wallet_accounts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wooznd_wallet_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wpforms_entries: Data: 0.39MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wpforms_entry_fields: Data: 0.20MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_wpforms_entry_meta: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wpf_filters: Data: 0.03MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wpf_meta_values: Data: 0.02MB + Index: 0.44MB + Engine InnoDB<br>nOQFkPH_wpf_meta_values_bk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wpf_statistics: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wpf_statistics_det: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wpf_statistics_sum: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wpf_statistics_val: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wpgb_cards: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_wpgb_facets: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_wpgb_grids: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_wpgb_index: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_wpgb_styles: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_wps_hit: Data: 0.06MB + Index: 0.14MB + Engine InnoDB<br>nOQFkPH_wps_index: Data: 50.58MB + Index: 52.64MB + Engine InnoDB<br>nOQFkPH_wps_key: Data: 1.52MB + Index: 0.47MB + Engine InnoDB<br>nOQFkPH_wps_object_term: Data: 5.52MB + Index: 12.09MB + Engine InnoDB<br>nOQFkPH_wps_object_type: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>nOQFkPH_wps_query: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wps_uri: Data: 0.14MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_wps_user_agent: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_yith_wcan_cache: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_yith_wcas_data_index_lookup: Data: 10.52MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_yith_wcas_index_relationship: Data: 28.56MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_yith_wcas_index_taxonomy: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_yith_wcas_index_token: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_yith_wcas_query_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>xcategory: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xconnection: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xgroup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xgroup_category_map: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xjob: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>xjob_raw_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>xlogin: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xmembership_plan: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xmembership_plan_detail: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xobject: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xobject_category_map: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xobject_share: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xobject_type: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xplan_subscription: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xprivilege: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xrole: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xrole_privilege_map: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xsummary: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xuser: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>xuser_group_map: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xuser_info: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br><br>### Post Type Counts ###<br><br>_op_register: 1<br>attachment: 36659<br>br_filters_group: 1<br>br_product_filter: 1<br>brb_collection: 1<br>calendar: 1<br>cartflows_flow: 1<br>cartflows_step: 2<br>ckit_size_guide: 2<br>class: 11<br>custom_css: 8<br>eib2bpro_groups: 1<br>elementor_library: 9<br>elementor_snippet: 1<br>es_template: 29<br>et_pb_layout: 1<br>firebox: 2<br>ig_campaign: 1<br>ig_message: 4<br>inspire_invoice: 2<br>itsec-dash-card: 6<br>itsec-dashboard: 1<br>jet-smart-filters: 1<br>jetpack_migration: 2<br>jp_img_sitemap: 12<br>jp_img_sitemap_index: 1<br>jp_sitemap: 1<br>jp_sitemap_master: 1<br>jp_vid_sitemap: 1<br>laybuy_quote: 4<br>mailpoet_page: 1<br>mc4wp-form: 1<br>mec_calendars: 12<br>mec-events: 20<br>nav_menu_item: 225<br>newsletter: 4<br>oembed_cache: 1<br>page: 34<br>popup: 1<br>pos_outlet: 1<br>pos_receipt: 1<br>pos_register: 1<br>pos-station: 2<br>post: 6<br>product: 5312<br>pwf_woofilter: 1<br>rainmaker_form: 1<br>revision: 22<br>seopress_404: 3327<br>seopress_bot: 1<br>seopress_schemas: 1<br>shop_coupon: 626<br>shop_order: 8329<br>shop_order_refund: 164<br>static_block: 2<br>stocktend_object: 6658<br>stocktend_tryst: 2<br>viwcpf_filter_block: 3<br>viwcpf_filter_menu: 1<br>wafs: 1<br>warranty_request: 1<br>wc_afrsm: 7<br>wc_afrsm_zone: 7<br>wcb: 405<br>wcct_countdown: 1<br>wcdp_payment: 8<br>wcpf_item: 12<br>wcpf_project: 2<br>wfacp_checkout: 1<br>whatsapp-accounts: 1<br>wp_block: 2<br>wp_global_styles: 3<br>wp_navigation: 1<br>wp_popup: 1<br>wp-rest-api-log: 12218<br>wpcode: 2<br>wpforms: 6<br>wppopups: 2<br>wpwautoposterlogs: 11207<br>wznd_giftcard: 1<br>yith_wcan_preset: 3<br>yith_wcpmr_rule: 1<br>yith-pos-receipt: 1<br>yith-pos-register: 1<br>yith-pos-store: 1<br>yith-wcgpf-feed: 1<br><br>### Security ###<br><br>Secure connection (HTTPS): ✔<br>Hide errors from visitors: ✔<br><br>### Active Plugins (38) ###<br><br>Core Processor: by ASaDOfSX – 1.9<br>Advanced Flat Rate Shipping For WooCommerce Market: by theDotstore – 4.7.8<br>AllAccessible: by AllAccessible Team – 1.3.7<br>Auto Image Attributes From Filename With Bulk Updater: by Arun Basil Lal – 4.4<br>Auto Image Attributes Pro: by Arun Basil Lal – 4.5<br>Classic Editor: by WordPress Contributors – 1.6.7<br>Classic Widgets: by WordPress Contributors – 0.3<br>Anti-Spam by CleanTalk: by CleanTalk - Anti-Spam Protection – 6.55<br>Code Snippets: by Code Snippets Pro – 3.6.8<br>CommerceGurus CommerceKit: by CommerceGurus – 2.4.2<br>Elementor Pro: by Elementor.com – 3.28.4<br>Elementor: by Elementor.com – 3.28.4<br>Facebook for WooCommerce: by Facebook – 3.4.8<br>FluentSMTP: by FluentSMTP & WPManageNinja Team – 2.2.90<br>Fluent Forms: by Contact Form - WPManageNinja LLC – 6.0.3<br>Fluent Forms Pro Add On Pack: by Fluent Forms – 6.0.3<br>Google for WooCommerce: by WooCommerce – 2.9.13<br>Index WP MySQL For Speed: by Oliver Jones<br>Rick James – 1.5.3<br><br>Kirki Customizer Framework: by Themeum – 5.1.0<br>Mollie Payments for WooCommerce: by Mollie – 8.0.1<br>Query Monitor: by John Blackbourn – 3.17.2<br>Regenerate Thumbnails Advanced: by ShortPixel – 2.5.0<br>ShortPixel Image Optimizer: by ShortPixel - Convert WebP/AVIF & Optimize Images – 6.2.0<br>Squirrly SEO - Advanced Pack: by Squirrly – 2.4.01<br>Squirrly SEO (Newton): by Squirrly – 12.4.11<br>W3 Total Cache: by BoldGrid – 2.8.8<br>Aelia Foundation Classes for WooCommerce: by Aelia – 2.6.4.250217<br>WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.3.1<br>WooCommerce Order Test - WP Fix It: by WP Fix It – 3.4<br>WP Sheet Editor - WooCommerce Products (Premium): by WP Sheet Editor – 1.8.17<br>WooCommerce.com Update Manager: by Automattic – 1.0.3<br>WooCommerce Print Invoices/Packing Lists: by SkyVerge – 3.14.0<br>HUSKY - Products Filter Professional for WooCommerce: by realmag777 – 3.3.6.6<br>WooCommerce Shipment Tracking: by WooCommerce – 2.5.8<br>Aelia Tax Display by Country for WooCommerce: by Aelia – 1.20.7.231115<br>WooCommerce: by Automattic – 9.8.5<br>WP-Lister Pro for eBay: by WP Lab – 3.8.1<br>WP Sheet Editor - Facebook for WooCommerce: by WP Sheet Editor – 1.0.1<br><br>### Inactive Plugins (27) ###<br><br>10Web Booster: by 10Web - Website speed optimization team – 2.31.8<br>10Web Image Optimizer: by 10Web - Image Optimizer team – 6.0.67<br>Cache Enabler: by KeyCDN – 1.8.15<br>CartFlows: by Brainstorm Force – 2.1.11<br>DoLogin Security: by WPDO – 3.8<br>Enable Media Replace: by ShortPixel – 4.1.6<br>FastPixel Website Accelerator: by ShortPixel – 1.0.48<br>FooSales - Point of Sale (POS) for WooCommerce: by FooSales – 1.39.5<br>FunnelKit Funnel Builder: by FunnelKit – 3.10.2<br>Jetpack: by Automattic – 14.6<br>LiteSpeed Cache: by LiteSpeed Technologies – 7.1<br>Oliver POS - A WooCommerce Point of Sale (POS): by Oliver POS – 2.4.2.6<br>Resize Image After Upload: by ShortPixel – 1.8.6<br>reSmush.it Image Optimizer: by reSmush.it – 1.0.4<br>Security by CleanTalk: by CleanTalk Security – 2.155<br>ShortPixel Adaptive Images: by ShortPixel – 3.10.3<br>Social Auto Poster: by WPWeb – 5.4.8<br>Speed Optimizer: by SiteGround – 7.7.2<br>Trustpilot-reviews: by Trustpilot – 2.5.927<br>Vitepos - Point of sale (POS) for WooCommerce: by appsbd – 3.1.14<br>wePOS - Point Of Sale (POS) for WooCommerce: by weDevs – 1.3.0<br>WooCommerce Direct Checkout: by QuadLayers – 3.4.8<br>WooCommerce MSRP Pricing: by Ademti Software Ltd. – 4.2.1<br>Woocommerce OpenPos: by anhvnit@gmail.com – 7.1.4<br>WooCommerce POS: by kilbot – 1.7.8<br>Woo Store Vacation: by MyPreview – 1.9.5<br>WP Fastest Cache: by Emre Vona – 1.3.7<br><br>### Dropin Plugins () ###<br><br>advanced-cache.php: advanced-cache.php<br>db.php: Query Monitor Database Class (Drop-in)<br>maintenance.php: maintenance.php<br>object-cache.php: object-cache.php<br><br>### Must Use Plugins (2) ###<br><br>Elementor Safe Mode: by Elementor.com – 1.0.0<br>Index WP MySQL For Speed Upgrade Filter for mu-plugins.: by – 1.5.3<br><br>### Settings ###<br><br>Legacy API Enabled: –<br>Force SSL: ✔<br>Currency: GBP (£)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>grouped (grouped)<br>instock (instock)<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)<br><br>Connected to WooCommerce.com: ✔<br>Enforce Approved Product Download Directories: –<br>HPOS feature enabled: ✔<br>Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore<br>HPOS data sync enabled: ✔<br><br>### Logging ###<br><br>Enabled: ✔<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 674 MB<br><br>### WC Pages ###<br><br>Shop base: #115 - /shop/<br>Basket: #5 - /shopping-cart/ - Contains the woocommerce_cart shortcode<br>Checkout: #6 - /checkout/ - Contains the woocommerce_checkout shortcode<br>My account: #122 - /my-account/ - Contains the [woocommerce_my_account] shortcode<br>Terms and conditions: #9029 - /returns/<br><br>### Theme ###<br><br>Name: Shoptimizer<br>Version: 2.8.11<br>Author URL: https://www.commercegurus.com/<br>Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build<br>personally we recommend using a child theme. See: How to create a child theme<br><br>Theme type: Classic theme<br>WooCommerce Support: ✔<br><br>### Templates ###<br><br>Overrides: –<br><br>### Admin ###<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<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>onboarding<br>onboarding-tasks<br>pattern-toolkit-full-composability<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>printful<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<br>launch-your-store<br>add-to-cart-with-options-stepper-layout<br><br>Disabled Features: product-data-views<br>experimental-blocks<br>coming-soon-newsletter-template<br>minified-js<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br>use-wp-horizon<br>blockified-add-to-cart<br><br>Daily Cron: ✔ Next scheduled: 2025-05-15 00:13:33 +01:00<br>Options: ✔<br>Notes: 181<br>Onboarding: completed<br><br>### Action Scheduler ###<br><br>Complete: 23,604<br>Oldest: 2025-04-13 11:44:11 +0100<br>Newest: 2025-05-14 11:43:19 +0100<br><br>Failed: 35,472<br>Oldest: 2022-10-30 15:57:35 +0000<br>Newest: 2025-05-14 11:30:10 +0100<br><br>Pending: 13<br>Oldest: 2025-05-14 11:44:04 +0100<br>Newest: 2025-05-19 19:49:10 +0100<br><br><br>### Status report information ###<br><br>Generated at: 2025-05-14 11:43:30 +01:00<br>Thank you for that @dazsmodels
So the main issue here is the DB is bloated (3.7GB), especially postmeta, options, and Action Scheduler. Over 35k failed actions are clogging things up. Combine that with object caching (likely Redis), and it’s a recipe for connection issues. Recommend clearing failed actions and testing with object cache disabled. It needs a bath immediately!
You also have too many caching plugins (W3TC active, LiteSpeed, WP Fastest Cache, Cache Enabler all installed). That’s asking for conflicts. Stick to one and fully remove the rest …including drop-ins like advanced-cache.php. I know they’re inactive, but I just want you to know you can’t run two caching apps at the same time, they will cancel each other out. You can run object-cache and cache, but not two cache apps at the same time.
Stef
i am happy to try howdo a debloat the database and clearing failed actions
Hey @dazsmodels thanks for getting back to me. Do you have WP-CLI access (or can your host run commands)? That’s the safest way to clean this without risking a crash. Using a plugin might crash the site. You can try, but CLI would be the safest.
If not, you can try using Advanced DB Cleaner, but we’ll need to go slow and only clean small sections at a time. I wouldn’t recommend WP-Optimize for this, it’s too aggressive on sites this large.
As with anything ALWAYS make a backup before performing any high maintenance procedures. Thanks.
For CLI Commands the first one needs to be:
wp action-scheduler delete --status=failedSecond:
wp action-scheduler delete --status=completeAfter running those two you can do more, but I want to start with baby steps first.
Lastly, let’s optimize the DB after those two:
wp db optimizeTo finish you’re going to clear server cache:
wp cache flushLet us know how it goes
Hello Darren Ellis,
Thank you for contacting WooCommerce support.
I understand you’re encountering an “Error Connecting to Database” error whenever you try to add or edit a product in WooCommerce.
I appreciate Stef for stepping in and offering assistance, it’s always great to see community members helping each other.
In addition to cleaning up the database, it’s important to identify what may have caused this issue in the first place. To help with that, could you please share a screenshot of your Scheduled Actions page? You can use Snipboard.io to upload the image and share the link here. This might provide us with some helpful clues.
Looking forward to your response. 🙂
<br>### WordPress Environment ###<br><br>WordPress address (URL): https://www.dazsmodels.co.uk<br>Site address (URL): https://www.dazsmodels.co.uk<br>WC Version: 9.8.5<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ✔ 3.9.2<br>Log Directory Writable: ✔<br>WP Version: 6.8.1<br>WP Multisite: –<br>WP Memory Limit: 4 GB<br>WP Debug Mode: –<br>WP Cron: –<br>Language: en_GB<br>External object cache: ✔<br><br>### Server Environment ###<br><br>Server Info: LiteSpeed<br>PHP Version: 8.3.20<br>PHP Post Max Size: 512 MB<br>PHP Time Limit: 360<br>PHP Max Input Vars: 1000<br>cURL Version: 8.13.0<br>OpenSSL/1.1.1w<br><br>SUHOSIN Installed: –<br>MySQL Version: 10.11.11-MariaDB-cll-lve<br>Max Upload Size: 512 MB<br>Default Timezone is UTC: ✔<br>fsockopen/cURL: ✔<br>SoapClient: ✔<br>DOMDocument: ✔<br>GZip: ✔<br>Multibyte String: ✔<br>Remote Post: ✔<br>Remote Get: ✔<br><br>### Database ###<br><br>WC Database Version: 9.8.5<br>WC Database Prefix: nOQFkPH_<br>Total Database Size: 3319.31MB<br>Database Data Size: 2449.48MB<br>Database Index Size: 869.83MB<br>nOQFkPH_woocommerce_sessions: Data: 34.56MB + Index: 1.52MB + Engine InnoDB<br>nOQFkPH_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_woocommerce_order_items: Data: 2.52MB + Index: 0.91MB + Engine InnoDB<br>nOQFkPH_woocommerce_order_itemmeta: Data: 14.56MB + Index: 29.64MB + Engine InnoDB<br>nOQFkPH_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_woocommerce_shipping_zone_locations: Data: 0.11MB + Index: 0.23MB + Engine InnoDB<br>nOQFkPH_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>fin_inventory: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>fin_transfers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>fin_vendors: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>ic_woo_full_details_v: Data: 0.00MB + Index: 0.00MB + Engine<br>ic_woo_lookup_t: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>ic_woo_orders_mv: Data: 5.52MB + Index: 0.33MB + Engine InnoDB<br>ic_woo_orders_v: Data: 0.00MB + Index: 0.00MB + Engine<br>ic_woo_order_details_v: Data: 0.00MB + Index: 0.00MB + Engine<br>ic_woo_order_items_v: Data: 0.00MB + Index: 0.00MB + Engine<br>ic_woo_prefix_v: Data: 0.00MB + Index: 0.00MB + Engine<br>ic_woo_product_attributes_v: Data: 0.00MB + Index: 0.00MB + Engine<br>ic_woo_product_multi_attrib_v: Data: 0.00MB + Index: 0.00MB + Engine<br>ic_woo_product_uniq_attrib_v: Data: 0.00MB + Index: 0.00MB + Engine<br>ic_woo_prod_details_v: Data: 0.00MB + Index: 0.00MB + Engine<br>nOQFkPH_actionscheduler_actions: Data: 24.55MB + Index: 17.11MB + Engine InnoDB<br>nOQFkPH_actionscheduler_claims: Data: 0.36MB + Index: 0.20MB + Engine InnoDB<br>nOQFkPH_actionscheduler_groups: Data: 0.08MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_actionscheduler_logs: Data: 19.55MB + Index: 9.03MB + Engine InnoDB<br>nOQFkPH_atum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_atum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_atum_product_data: Data: 0.45MB + Index: 0.28MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_cart: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_interface: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_locations_tree: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_posts: Data: 4.52MB + Index: 0.28MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_posts_columns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_posts_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_barcode_scanner_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_cartflows_ca_cart_abandonment: Data: 1.52MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_cartflows_ca_email_history: Data: 0.20MB + Index: 0.19MB + Engine InnoDB<br>nOQFkPH_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_cleantalk_ac_log: Data: 0.48MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_cleantalk_connection_reports: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_cleantalk_sessions: Data: 4.55MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_cleantalk_sfw: Data: 1.52MB + Index: 0.50MB + Engine InnoDB<br>nOQFkPH_cleantalk_sfw_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_cleantalk_sfw_personal: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_cleantalk_spamscan_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_cleantalk_ua_bl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_cleantalk_wc_spam_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_commentmeta: Data: 0.08MB + Index: 0.19MB + Engine InnoDB<br>nOQFkPH_comments: Data: 8.52MB + Index: 12.61MB + Engine InnoDB<br>nOQFkPH_commercekit_ajs_product_index: Data: 12.52MB + Index: 0.28MB + Engine InnoDB<br>nOQFkPH_commercekit_searches: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_commercekit_sg_post_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_commercekit_swatches_cache_count: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_commercekit_waitlist: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_commercekit_wishlist: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_commercekit_wishlist_items: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_accounts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_auctions: Data: 118.58MB + Index: 2.22MB + Engine InnoDB<br>nOQFkPH_ebay_categories: Data: 2.52MB + Index: 0.69MB + Engine InnoDB<br>nOQFkPH_ebay_documents: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_ebay_jobs: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_log: Data: 154.63MB + Index: 3.50MB + Engine InnoDB<br>nOQFkPH_ebay_manufacturers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_messages: Data: 9.52MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_orders: Data: 135.56MB + Index: 0.34MB + Engine InnoDB<br>nOQFkPH_ebay_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_profiles: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_responsible_persons: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_shipping: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_sites: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_stocks_log: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_ebay_store_categories: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_ebay_transactions: Data: 110.52MB + Index: 0.50MB + Engine InnoDB<br>nOQFkPH_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB<br>nOQFkPH_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_e_submissions: Data: 0.30MB + Index: 0.50MB + Engine InnoDB<br>nOQFkPH_e_submissions_actions_log: Data: 0.08MB + Index: 0.11MB + Engine InnoDB<br>nOQFkPH_e_submissions_values: Data: 1.52MB + Index: 0.16MB + Engine InnoDB<br>nOQFkPH_ff_scheduled_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_draft_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_entry_details: Data: 0.20MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_forms: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_form_analytics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_order_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_submissions: Data: 0.30MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_submission_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_subscriptions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fluentform_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_fsmpt_email_logs: Data: 2.52MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_gla_budget_recommendations: Data: 0.19MB + Index: 0.11MB + Engine InnoDB<br>nOQFkPH_gla_merchant_issues: Data: 2.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_gla_shipping_rates: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_icegram_tracking: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_jetpack_waf_blocklog: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_litespeed_img_optming: Data: 5.52MB + Index: 7.55MB + Engine InnoDB<br>nOQFkPH_mailster_action_bounces: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_mailster_action_clicks: Data: 0.05MB + Index: 0.08MB + Engine InnoDB<br>nOQFkPH_mailster_action_errors: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_mailster_action_opens: Data: 0.23MB + Index: 0.34MB + Engine InnoDB<br>nOQFkPH_mailster_action_sent: Data: 0.44MB + Index: 0.63MB + Engine InnoDB<br>nOQFkPH_mailster_action_unsubs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_mailster_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_mailster_forms_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_mailster_forms_tags: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_mailster_form_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_mailster_form_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_mailster_links: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_mailster_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_mailster_queue: Data: 0.11MB + Index: 0.22MB + Engine InnoDB<br>nOQFkPH_mailster_subscribers: Data: 1.52MB + Index: 0.66MB + Engine InnoDB<br>nOQFkPH_mailster_subscriber_fields: Data: 0.41MB + Index: 0.61MB + Engine InnoDB<br>nOQFkPH_mailster_subscriber_meta: Data: 2.52MB + Index: 3.06MB + Engine InnoDB<br>nOQFkPH_mailster_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_mailster_tags_subscribers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_mailster_workflows: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_mollie_pending_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_client_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_order_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_phone_numbers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_scheduler: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_states: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_text_sms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_nm_widget_style: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_options: Data: 58.25MB + Index: 6.97MB + Engine InnoDB<br>nOQFkPH_postmeta: Data: 545.98MB + Index: 528.95MB + Engine InnoDB<br>nOQFkPH_posts: Data: 811.56MB + Index: 17.06MB + Engine InnoDB<br>nOQFkPH_qss: Data: 6.52MB + Index: 0.69MB + Engine InnoDB<br>nOQFkPH_qss_jsonld: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_qss_redirects: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>nOQFkPH_qss_redirects_log: Data: 36.56MB + Index: 2.55MB + Engine InnoDB<br>nOQFkPH_search_filter_cache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_search_filter_term_results: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_seopress_content_analysis: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_seopress_seo_issues: Data: 1.52MB + Index: 0.16MB + Engine InnoDB<br>nOQFkPH_seopress_significant_keywords: Data: 5.52MB + Index: 5.03MB + Engine InnoDB<br>nOQFkPH_shortpixel_folders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_shortpixel_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_shortpixel_postmeta: Data: 152.72MB + Index: 67.70MB + Engine InnoDB<br>nOQFkPH_shortpixel_queue: Data: 3.52MB + Index: 6.05MB + Engine InnoDB<br>nOQFkPH_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_spbc_auth_logs: Data: 0.09MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_spbc_backuped_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_backups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_bfp_blocked: Data: 0.20MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_cure_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_firewall_data_v4: Data: 1.52MB + Index: 1.52MB + Engine InnoDB<br>nOQFkPH_spbc_firewall_data_v6: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_spbc_firewall_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_firewall__personal_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_firewall__personal_ips_v4: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_spbc_firewall__personal_ips_v6: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_spbc_important_files: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_spbc_important_file_snapshots: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_monitoring_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_spbc_scan_frontend: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_scan_links_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_spbc_scan_results: Data: 9.52MB + Index: 2.52MB + Engine InnoDB<br>nOQFkPH_spbc_scan_results_log: Data: 3.52MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_scan_signatures: Data: 0.36MB + Index: 0.08MB + Engine InnoDB<br>nOQFkPH_spbc_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_surface_completed_dirs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_spbc_traffic_control_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_termmeta: Data: 3.52MB + Index: 7.55MB + Engine InnoDB<br>nOQFkPH_terms: Data: 1.52MB + Index: 0.81MB + Engine InnoDB<br>nOQFkPH_term_relationships: Data: 5.52MB + Index: 3.52MB + Engine InnoDB<br>nOQFkPH_term_taxonomy: Data: 1.52MB + Index: 1.94MB + Engine InnoDB<br>nOQFkPH_trp_gettext_en_gb: Data: 0.38MB + Index: 0.34MB + Engine InnoDB<br>nOQFkPH_usermeta: Data: 7.55MB + Index: 13.55MB + Engine InnoDB<br>nOQFkPH_users: Data: 0.50MB + Index: 0.47MB + Engine InnoDB<br>nOQFkPH_w3tc_alwayscached_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wamc_campaign: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wamc_user_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wc_admin_notes: Data: 0.13MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wc_customer_lookup: Data: 0.52MB + Index: 0.27MB + Engine InnoDB<br>nOQFkPH_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_wc_orders: Data: 2.52MB + Index: 2.25MB + Engine InnoDB<br>nOQFkPH_wc_orders_meta: Data: 24.59MB + Index: 28.14MB + Engine InnoDB<br>nOQFkPH_wc_order_addresses: Data: 3.52MB + Index: 3.09MB + Engine InnoDB<br>nOQFkPH_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_wc_order_operational_data: Data: 1.52MB + Index: 0.53MB + Engine InnoDB<br>nOQFkPH_wc_order_product_lookup: Data: 1.52MB + Index: 0.84MB + Engine InnoDB<br>nOQFkPH_wc_order_stats: Data: 1.52MB + Index: 0.61MB + Engine InnoDB<br>nOQFkPH_wc_order_tax_lookup: Data: 0.09MB + Index: 0.09MB + Engine InnoDB<br>nOQFkPH_wc_product_attributes_lookup: Data: 3.52MB + Index: 2.52MB + Engine InnoDB<br>nOQFkPH_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wc_product_meta_lookup: Data: 1.52MB + Index: 1.23MB + Engine InnoDB<br>nOQFkPH_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_woocommerce_exported_csv_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_woocommerce_gc_activity: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_woocommerce_gc_cards: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_woocommerce_gc_cardsmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_woof_front_builder: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_woof_query_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_woof_sd: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_woof_sd_presets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_woof_stat_buffer: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_woof_stat_tmp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wpforms_entries: Data: 0.39MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wpforms_entry_fields: Data: 0.20MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_wpforms_entry_meta: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wpf_filters: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wpf_meta_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_wpf_statistics: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wpf_statistics_sum: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wpgb_cards: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_wpgb_facets: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_wpgb_grids: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_wpgb_index: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>nOQFkPH_wpgb_styles: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>nOQFkPH_wps_hit: Data: 0.06MB + Index: 0.14MB + Engine InnoDB<br>nOQFkPH_wps_index: Data: 50.58MB + Index: 52.64MB + Engine InnoDB<br>nOQFkPH_wps_key: Data: 1.52MB + Index: 0.47MB + Engine InnoDB<br>nOQFkPH_wps_object_term: Data: 5.52MB + Index: 12.09MB + Engine InnoDB<br>nOQFkPH_wps_object_type: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>nOQFkPH_wps_query: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_wps_uri: Data: 0.14MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_wps_user_agent: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>nOQFkPH_yith_wcan_cache: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>nOQFkPH_yith_wcas_index_token: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>nOQFkPH_yith_wcas_query_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>xcategory: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xconnection: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xgroup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xjob: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>xlogin: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xmembership_plan: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xobject: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xobject_share: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xobject_type: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xplan_subscription: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xprivilege: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xrole: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xsummary: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>xuser: Data: 0.00MB + Index: 0.01MB + Engine MyISAM<br>xuser_info: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br><br>### Post Type Counts ###<br><br>_op_register: 1<br>attachment: 36659<br>br_filters_group: 1<br>br_product_filter: 1<br>brb_collection: 1<br>calendar: 1<br>cartflows_flow: 1<br>cartflows_step: 2<br>ckit_size_guide: 2<br>class: 11<br>custom_css: 8<br>eib2bpro_groups: 1<br>elementor_library: 9<br>elementor_snippet: 1<br>es_template: 29<br>et_pb_layout: 1<br>firebox: 2<br>ig_campaign: 1<br>ig_message: 4<br>inspire_invoice: 2<br>itsec-dash-card: 6<br>itsec-dashboard: 1<br>jet-smart-filters: 1<br>jetpack_migration: 2<br>jp_img_sitemap: 12<br>jp_img_sitemap_index: 1<br>jp_sitemap: 1<br>jp_sitemap_master: 1<br>jp_vid_sitemap: 1<br>laybuy_quote: 4<br>mailpoet_page: 1<br>mc4wp-form: 1<br>mec_calendars: 12<br>mec-events: 20<br>nav_menu_item: 225<br>newsletter: 4<br>oembed_cache: 1<br>page: 34<br>popup: 1<br>pos_outlet: 1<br>pos_receipt: 1<br>pos_register: 1<br>pos-station: 2<br>post: 4<br>product: 5312<br>pwf_woofilter: 1<br>rainmaker_form: 1<br>seopress_404: 3327<br>seopress_bot: 1<br>seopress_schemas: 1<br>shop_coupon: 626<br>shop_order: 8329<br>shop_order_refund: 164<br>static_block: 2<br>stocktend_object: 6658<br>stocktend_tryst: 2<br>viwcpf_filter_block: 3<br>viwcpf_filter_menu: 1<br>wafs: 1<br>warranty_request: 1<br>wc_afrsm: 7<br>wc_afrsm_zone: 7<br>wcb: 405<br>wcct_countdown: 1<br>wcdp_payment: 8<br>wcpf_item: 12<br>wcpf_project: 2<br>wfacp_checkout: 1<br>whatsapp-accounts: 1<br>wp_block: 2<br>wp_global_styles: 3<br>wp_navigation: 1<br>wp_popup: 1<br>wp-rest-api-log: 12218<br>wpcode: 2<br>wpforms: 6<br>wppopups: 2<br>wpwautoposterlogs: 11207<br>wznd_giftcard: 1<br>yith_wcan_preset: 3<br>yith_wcpmr_rule: 1<br>yith-pos-receipt: 1<br>yith-pos-register: 1<br>yith-pos-store: 1<br>yith-wcgpf-feed: 1<br><br>### Security ###<br><br>Secure connection (HTTPS): ✔<br>Hide errors from visitors: ✔<br><br>### Active Plugins (39) ###<br><br>Core Processor: by ASaDOfSX – 1.9<br>Advanced Database Cleaner PRO: by Younes JFR. – 3.2.11<br>Advanced Flat Rate Shipping For WooCommerce Market: by theDotstore – 4.7.8<br>AllAccessible: by AllAccessible Team – 1.3.7<br>Auto Image Attributes From Filename With Bulk Updater: by Arun Basil Lal – 4.4<br>Auto Image Attributes Pro: by Arun Basil Lal – 4.5<br>Classic Editor: by WordPress Contributors – 1.6.7<br>Classic Widgets: by WordPress Contributors – 0.3<br>Anti-Spam by CleanTalk: by CleanTalk - Anti-Spam Protection – 6.55<br>Code Snippets: by Code Snippets Pro – 3.6.8<br>CommerceGurus CommerceKit: by CommerceGurus – 2.4.2<br>Elementor Pro: by Elementor.com – 3.28.4<br>Elementor: by Elementor.com – 3.28.4<br>Facebook for WooCommerce: by Facebook – 3.4.8<br>FluentSMTP: by FluentSMTP & WPManageNinja Team – 2.2.90<br>Fluent Forms: by Contact Form - WPManageNinja LLC – 6.0.3<br>Fluent Forms Pro Add On Pack: by Fluent Forms – 6.0.3<br>Google for WooCommerce: by WooCommerce – 2.9.13<br>Index WP MySQL For Speed: by Oliver Jones<br>Rick James – 1.5.3<br><br>Kirki Customizer Framework: by Themeum – 5.1.0<br>Mollie Payments for WooCommerce: by Mollie – 8.0.1<br>Query Monitor: by John Blackbourn – 3.17.2<br>Regenerate Thumbnails Advanced: by ShortPixel – 2.5.0<br>ShortPixel Image Optimizer: by ShortPixel - Convert WebP/AVIF & Optimize Images – 6.2.0<br>Squirrly SEO - Advanced Pack: by Squirrly – 2.4.01<br>Squirrly SEO (Newton): by Squirrly – 12.4.11<br>W3 Total Cache: by BoldGrid – 2.8.8<br>Aelia Foundation Classes for WooCommerce: by Aelia – 2.6.4.250217<br>WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.3.1<br>WooCommerce Order Test - WP Fix It: by WP Fix It – 3.4<br>WP Sheet Editor - WooCommerce Products (Premium): by WP Sheet Editor – 1.8.17<br>WooCommerce.com Update Manager: by Automattic – 1.0.3<br>WooCommerce Print Invoices/Packing Lists: by SkyVerge – 3.14.0<br>HUSKY - Products Filter Professional for WooCommerce: by realmag777 – 3.3.6.6<br>WooCommerce Shipment Tracking: by WooCommerce – 2.5.8<br>Aelia Tax Display by Country for WooCommerce: by Aelia – 1.20.7.231115<br>WooCommerce: by Automattic – 9.8.5<br>WP-Lister Pro for eBay: by WP Lab – 3.8.1<br>WP Sheet Editor - Facebook for WooCommerce: by WP Sheet Editor – 1.0.1<br><br>### Inactive Plugins (10) ###<br><br>CartFlows: by Brainstorm Force – 2.1.11<br>FunnelKit Funnel Builder: by FunnelKit – 3.10.2<br>Jetpack: by Automattic – 14.6<br>Security by CleanTalk: by CleanTalk Security – 2.155<br>Social Auto Poster: by WPWeb – 5.4.8<br>Trustpilot-reviews: by Trustpilot – 2.5.927<br>WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.3.1<br>WooCommerce Direct Checkout: by QuadLayers – 3.4.8<br>WooCommerce MSRP Pricing: by Ademti Software Ltd. – 4.2.1<br>Woo Store Vacation: by MyPreview – 1.9.5<br><br>### Dropin Plugins () ###<br><br>advanced-cache.php: advanced-cache.php<br>db.php: db.php<br>maintenance.php: maintenance.php<br>object-cache.php: object-cache.php<br><br>### Must Use Plugins (2) ###<br><br>Elementor Safe Mode: by Elementor.com – 1.0.0<br>Index WP MySQL For Speed Upgrade Filter for mu-plugins.: by – 1.5.3<br><br>### Settings ###<br><br>Legacy API Enabled: –<br>Force SSL: ✔<br>Currency: GBP (£)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: simple (simple)<br>Taxonomies: Product Visibility: featured (featured)<br>grouped (grouped)<br>instock (instock)<br>outofstock (outofstock)<br><br>Connected to WooCommerce.com: ✔<br>Enforce Approved Product Download Directories: –<br>HPOS feature enabled: ✔<br>Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore<br>HPOS data sync enabled: ✔<br><br>### Logging ###<br><br>Enabled: ✔<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 677 MB<br><br>### WC Pages ###<br><br>Shop base: #115 - /shop/<br>Basket: #5 - /shopping-cart/ - Contains the woocommerce_cart shortcode<br>Checkout: #6 - /checkout/ - Contains the woocommerce_checkout shortcode<br>My account: #122 - /my-account/ - Contains the [woocommerce_my_account] shortcode<br>Terms and conditions: #9029 - /returns/<br><br>### Theme ###<br><br>Name: Shoptimizer<br>Version: 2.8.11<br>Author URL: https://www.commercegurus.com/<br>Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build<br>personally we recommend using a child theme. See: How to create a child theme<br><br>Theme type: Classic theme<br>WooCommerce Support: ✔<br><br>### Templates ###<br><br>Overrides: –<br><br>### Admin ###<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<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>onboarding<br>onboarding-tasks<br>pattern-toolkit-full-composability<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>printful<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<br>launch-your-store<br>add-to-cart-with-options-stepper-layout<br><br>Disabled Features: product-data-views<br>experimental-blocks<br>coming-soon-newsletter-template<br>minified-js<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br>use-wp-horizon<br>blockified-add-to-cart<br><br>Daily Cron: ✔ Next scheduled: 2025-05-15 00:13:33 +01:00<br>Options: ✔<br>Notes: 181<br>Onboarding: completed<br><br>### Action Scheduler ###<br><br>Complete: 24,771<br>Oldest: 2025-04-13 16:05:15 +0100<br>Newest: 2025-05-14 16:02:49 +0100<br><br>Failed: 35,473<br>Oldest: 2022-10-30 15:57:35 +0000<br>Newest: 2025-05-14 15:10:30 +0100<br><br>Pending: 14<br>Oldest: 2025-05-14 16:02:52 +0100<br>Newest: 2025-05-19 19:49:10 +0100<br><br><br>### Status report information ###<br><br>Generated at: 2025-05-14 16:02:54 +01:00<br>i have done most and please see what you think
are we on track
Hi @dazsmodels I think @doublezed2 is asking for a screenshot of your actions panel. That’ll be this URL /wp-admin/admin.php?page=wc-status&tab=action-scheduler
I appreciate @doublezed2 stepping in here, but have you run thru anything I gave you? The reason I ask is because it’s clear by your SSR what’s going on here. So have you run thru any of those steps I gave you above?
hi
im out the office so can’t do the scheduled actions properly. So will do later.
as my host won’t really help I used advanced cleaner and thought I got rid of a lot .
the only think I couldn’t sort is the transients as it just does and comes up again
can you see the problem , can you let me know so i can pass it on to hosting
Hey @dazsmodels understood. Just be careful with that app. Some plugins rely on transients. Have you done anything with it so far?
i am not sure how detailed you wanted
He just wants to see what he’s not seeing in your SSR report. But like I said I saw your issue myself. This is a simple 10 second CLI run and done. But @doublezed2 I guess didn’t see your SSR. Not sure.
Stef
So another cli on top of what you have sent me
No @dazsmodels sorry @doublezed2 just wants to confirm what you and I already discussed. Not sure why.
i have tried to run it and says command not found
The topic ‘Error Connecting to database’ is closed to new replies.
