Title: Ron Drake's Replies | WordPress.org --- # Ron Drake [ ](https://wordpress.org/support/users/nuflush/) * [Profile](https://wordpress.org/support/users/nuflush/) * [Topics Started](https://wordpress.org/support/users/nuflush/topics/) * [Replies Created](https://wordpress.org/support/users/nuflush/replies/) * [Reviews Written](https://wordpress.org/support/users/nuflush/reviews/) * [Topics Replied To](https://wordpress.org/support/users/nuflush/replied-to/) * [Engagements](https://wordpress.org/support/users/nuflush/engagements/) * [Favorites](https://wordpress.org/support/users/nuflush/favorites/) Search replies: ## Forum Replies Created Viewing 1 replies (of 1 total) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooCommerce] WooCommerce Database Query – Causing 502](https://wordpress.org/support/topic/woocommerce-database-query-causing-502/) * [Ron Drake](https://wordpress.org/support/users/nuflush/) * (@nuflush) * [3 years, 10 months ago](https://wordpress.org/support/topic/woocommerce-database-query-causing-502/#post-15839968) * ``` ### WordPress Environment ### WordPress address (URL): https://nuflush.com Site address (URL): https://nuflush.com WC Version: 6.7.0 REST API Version: ✔ 6.7.0 WC Blocks Version: ✔ 8.1.0 Action Scheduler Version: ✔ 3.4.0 Log Directory Writable: ✔ WP Version: 6.0.1 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.4.28 PHP Post Max Size: 516 MB PHP Time Limit: 60 PHP Max Input Vars: 1000 cURL Version: 7.81.0 OpenSSL/1.1.1n SUHOSIN Installed: – MySQL Version: 5.6.41-84.1 Max Upload Size: 512 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 6.7.0 WC Database Prefix: wp_ Total Database Size: 272.10MB Database Data Size: 247.26MB Database Index Size: 24.84MB wp_woocommerce_sessions: Data: 76.66MB + Index: 2.90MB + Engine MyISAM wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_order_items: Data: 0.55MB + Index: 0.23MB + Engine MyISAM wp_woocommerce_order_itemmeta: Data: 2.39MB + Index: 1.68MB + Engine MyISAM wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_actionscheduler_actions: Data: 0.66MB + Index: 0.31MB + Engine MyISAM wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_actionscheduler_logs: Data: 0.50MB + Index: 0.33MB + Engine MyISAM wp_amazon_accounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_amazon_btg: Data: 0.45MB + Index: 0.33MB + Engine InnoDB wp_amazon_categories: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_amazon_feeds: Data: 22.50MB + Index: 0.08MB + Engine InnoDB wp_amazon_feed_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_amazon_feed_tpl_data: Data: 0.16MB + Index: 0.08MB + Engine InnoDB wp_amazon_feed_tpl_values: Data: 1.52MB + Index: 0.25MB + Engine InnoDB wp_amazon_jobs: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_amazon_listings: Data: 1.48MB + Index: 0.19MB + Engine InnoDB wp_amazon_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_amazon_markets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_amazon_orders: Data: 8.25MB + Index: 0.19MB + Engine InnoDB wp_amazon_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_amazon_profiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_amazon_reports: Data: 40.52MB + Index: 0.00MB + Engine InnoDB wp_amazon_shipping: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_amazon_stock_log: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine MyISAM wp_comments: Data: 1.33MB + Index: 0.78MB + Engine MyISAM wp_ebay_accounts: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_ebay_auctions: Data: 6.44MB + Index: 0.33MB + Engine InnoDB wp_ebay_categories: Data: 1.52MB + Index: 3.30MB + Engine InnoDB wp_ebay_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ebay_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_ebay_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ebay_orders: Data: 9.13MB + Index: 0.03MB + Engine InnoDB wp_ebay_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ebay_profiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ebay_shipping: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_ebay_sites: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ebay_stocks_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ebay_store_categories: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_ebay_transactions: Data: 7.52MB + Index: 0.05MB + Engine InnoDB wp_fusion_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_fusion_form_entries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_fusion_form_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_fusion_form_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_mclean_refs: Data: 0.21MB + Index: 0.08MB + Engine MyISAM wp_mclean_scan: Data: 0.25MB + Index: 0.08MB + Engine MyISAM wp_options: Data: 20.82MB + Index: 0.24MB + Engine MyISAM wp_postmeta: Data: 36.27MB + Index: 10.10MB + Engine MyISAM wp_posts: Data: 5.69MB + Index: 1.40MB + Engine MyISAM wp_revslider_css: Data: 0.09MB + Index: 0.00MB + Engine MyISAM wp_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine MyISAM wp_revslider_slides: Data: 0.12MB + Index: 0.00MB + Engine MyISAM wp_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_termmeta: Data: 0.23MB + Index: 0.19MB + Engine MyISAM wp_terms: Data: 0.09MB + Index: 0.16MB + Engine MyISAM wp_term_relationships: Data: 0.17MB + Index: 0.37MB + Engine MyISAM wp_term_taxonomy: Data: 0.07MB + Index: 0.06MB + Engine MyISAM wp_usermeta: Data: 0.11MB + Index: 0.08MB + Engine MyISAM wp_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_admin_notes: Data: 0.04MB + Index: 0.00MB + Engine MyISAM wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.01MB + Engine MyISAM wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_customer_lookup: Data: 0.17MB + Index: 0.14MB + Engine MyISAM wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_product_lookup: Data: 0.25MB + Index: 0.27MB + Engine MyISAM wp_wc_order_stats: Data: 0.19MB + Index: 0.12MB + Engine MyISAM wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 0.09MB + Index: 0.10MB + Engine MyISAM wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ### Post Type Counts ### amn_mi-lite: 2 amn_om: 1 amn_wpforms-lite: 4 attachment: 4835 avada_portfolio: 10 nav_menu_item: 19 oembed_cache: 2 page: 16 post: 4 product: 1077 revision: 725 shop_coupon: 1 shop_order: 3810 shop_order_refund: 20 slide: 17 themefusion_elastic: 2 wmpc-trash: 2153 wpforms: 1 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (12) ### Database Cleaner and Optimizer (Built for 2022+): by Jordy Meow – 0.5.4 Avada Builder: by ThemeFusion – 3.3 Avada Core: by ThemeFusion – 5.3 Media Cleaner (Pro): by Jordy Meow – 6.4.0 Optimize Images Resizing: by OriginalEXE – 1.4.1 WooCommerce Blocks: by Automattic – 8.1.0 WooCommerce Payments: by Automattic – 4.4.0 WooCommerce PayPal Payments: by WooCommerce – 1.9.0 WooCommerce Shipping & Tax: by WooCommerce – 1.26.2 WooCommerce: by Automattic – 6.7.0 WP-Lister Pro for Amazon: by WP Lab – 2.2.3 WP-Lister Lite for eBay: by WP Lab – 3.2.11 ### Inactive Plugins (1) ### WooCommerce Admin: by WooCommerce – 3.3.2 ### Settings ### API Enabled: ✔ Force SSL: ✔ Currency: USD ($) Currency Position: left 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 WooCommerce.com: – Enforce Approved Product Download Directories: – ### WC Pages ### Shop base: #3813 - /nuflush-home/ Cart: #4098 - /cart-2/ Checkout: #4099 - /checkout/ My account: #4100 - /my-account-2/ Terms and conditions: ❌ Page not set ### Theme ### Name: Avada Version: 7.3 Author URL: https://themeforest.net/user/ThemeFusion Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ✔ ### Templates ### Overrides: Avada/woocommerce/cart/cart.php Avada/woocommerce/checkout/form-pay.php Avada/woocommerce/checkout/review-order.php Avada/woocommerce/checkout/thankyou.php Avada/woocommerce/loop/loop-start.php Avada/woocommerce/single-product/add-to-cart/variable.php version 3.5.5 is out of date. The core version is 6.1.0 Avada/woocommerce/single-product/short-description.php Avada/woocommerce/single-product/tabs/additional-information.php Avada/woocommerce/single-product/tabs/description.php Outdated Templates: ❌ Learn how to update ### Subscriptions ### WCS_DEBUG: ✔ No Subscriptions Mode: ✔ Live Subscriptions Live URL: https://nuflush.com Subscription Statuses: – WooCommerce Account Connected: ❌ No ### Store Setup ### Country / State: United States (US) — Colorado ### Payment Gateway Support ### PayPal: refunds ### WooCommerce PayPal Payments ### Onboarded: ✔ Shop country code: US WooCommerce currency supported: ✔ PayPal card processing available in country: ✔ Pay Later messaging available in country: ✔ Webhook status: – Vault enabled: ✔ Logging enabled: – Reference Transactions: – Used PayPal Checkout plugin: – ### Admin ### Enabled Features: activity-panels analytics coupons customer-effort-score-tracks experimental-products-task experimental-import-products-task experimental-fashion-sample-products experimental-product-tour homescreen marketing mobile-app-banner navigation onboarding onboarding-tasks remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices wc-pay-promotion wc-pay-welcome-page wc-pay-subscriptions-page Disabled Features: minified-js settings Daily Cron: ✔ Next scheduled: 2022-07-19 20:08:59 +00:00 Options: ✔ Notes: 92 Onboarding: completed ### WooCommerce Payments ### Version: 4.4.0 Connected to WPCOM: No Blog ID: - Account ID: - ### Action Scheduler ### Complete: 1,933 Oldest: 2022-07-13 15:24:38 +0000 Newest: 2022-07-19 18:51:46 +0000 Failed: 11 Oldest: 2022-05-25 19:19:15 +0000 Newest: 2022-06-04 19:19:16 +0000 Pending: 4 Oldest: 2022-07-19 19:51:46 +0000 Newest: 2022-07-20 16:40:45 +0000 ### Status report information ### Generated at: 2022-07-19 19:02:23 +00:00 ``` Viewing 1 replies (of 1 total)