Skip to content

Slow order/subscription search #32826

New issue
New issue
Closed
Closed
Slow order/subscription search#32826

Description

@neillaferty

neillaferty
openedon Apr 28, 2022

Prerequisites

  • I have carried out troubleshooting steps and I believe I have found a bug.
  • I have searched for similar bugs in both open and closed issues and cannot find a duplicate.

Describe the bug

Order and subscription searches are taking minutes.

Expected behavior

Order and subscription searched should take seconds, not minutes.

Actual behavior

When doing search on orders or subscriptions, the results are so slow they are taking up to two minutes. The query it seems to get hung up on the most is:

Select distinct p1.post_id
from inlive.wi1065p_postmeta p1
where p1.meta_value like '%jane.doe@marketrebellion.com%'
and p1.meta_key in ('_orderkey', '_billing_address_index', '_shipping_address_indes', '_billing_email')

Steps to reproduce

In the wp-admin, WooCommerce > Orders (or Subscriptions) > Search Orders

WordPress Environment

`

WordPress Environment

WordPress address (URL): https://marketrebellion.com
Site address (URL): https://marketrebellion.com
WC Version: 6.4.1
REST API Version: ✔ 6.4.1
WC Blocks Version: ✔ 7.2.2
Action Scheduler Version: ✔ 3.4.0
WC Admin Version: ✔ 3.3.2
Log Directory Writable: ✔
WP Version: 5.9.3
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: –
Language: en_US
External object cache: –

Server Environment

Server Info: nginx/1.18.0
PHP Version: 7.4.16
PHP Post Max Size: 8 MB
PHP Time Limit: 180
PHP Max Input Vars: 1000
cURL Version: 7.68.0
OpenSSL/1.1.1f

SUHOSIN Installed: –
MySQL Version: 5.7.12
Max Upload Size: 2 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

Database

WC Database Version: 6.4.1
WC Database Prefix: wi1605p_
Total Database Size: 9753.18MB
Database Data Size: 6690.73MB
Database Index Size: 3062.45MB
wi1605p_woocommerce_sessions: Data: 7.03MB + Index: 1.02MB + Engine InnoDB
wi1605p_woocommerce_api_keys: Data: 0.03MB + Index: 0.03MB + Engine InnoDB
wi1605p_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_woocommerce_downloadable_product_permissions: Data: 3.52MB + Index: 4.97MB + Engine InnoDB
wi1605p_woocommerce_order_items: Data: 25.55MB + Index: 9.47MB + Engine InnoDB
wi1605p_woocommerce_order_itemmeta: Data: 271.69MB + Index: 164.22MB + Engine InnoDB
wi1605p_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wi1605p_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wi1605p_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wi1605p_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_woocommerce_payment_tokens: Data: 1.52MB + Index: 0.36MB + Engine InnoDB
wi1605p_woocommerce_payment_tokenmeta: Data: 10.16MB + Index: 7.50MB + Engine InnoDB
wi1605p_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
last_logins: Data: 57.58MB + Index: 0.00MB + Engine InnoDB
wi1605p_actionscheduler_actions: Data: 44.50MB + Index: 40.27MB + Engine InnoDB
wi1605p_actionscheduler_claims: Data: 0.27MB + Index: 0.14MB + Engine InnoDB
wi1605p_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_actionscheduler_logs: Data: 29.55MB + Index: 17.84MB + Engine InnoDB
wi1605p_afwc_campaigns: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wi1605p_afwc_commission_plans: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_afwc_hits: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wi1605p_afwc_payouts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wi1605p_afwc_payout_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_afwc_referrals: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wi1605p_aiowps_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_aiowps_failed_logins: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wi1605p_aiowps_global_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_aiowps_login_activity: Data: 1.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_aiowps_login_lockdown: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wi1605p_aiowps_permanent_block: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_automatewoo_abandoned_carts: Data: 1.02MB + Index: 0.08MB + Engine InnoDB
wi1605p_automatewoo_customers: Data: 10.48MB + Index: 20.61MB + Engine InnoDB
wi1605p_automatewoo_customer_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wi1605p_automatewoo_events: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wi1605p_automatewoo_guests: Data: 8.52MB + Index: 15.05MB + Engine InnoDB
wi1605p_automatewoo_guest_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wi1605p_automatewoo_logs: Data: 3.52MB + Index: 6.55MB + Engine InnoDB
wi1605p_automatewoo_log_meta: Data: 29.55MB + Index: 18.03MB + Engine InnoDB
wi1605p_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wi1605p_automatewoo_queue_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wi1605p_commentmeta: Data: 13.50MB + Index: 13.00MB + Engine InnoDB
wi1605p_comments: Data: 2242.92MB + Index: 823.77MB + Engine InnoDB
wi1605p_defender_lockout: Data: 0.34MB + Index: 0.00MB + Engine InnoDB
wi1605p_defender_lockout_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_facetwp_index: Data: 30.56MB + Index: 32.64MB + Engine InnoDB
wi1605p_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_forum_ads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_forum_forums: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_forum_polls: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_forum_polls_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_forum_polls_votes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_forum_posts: Data: 20.52MB + Index: 16.41MB + Engine InnoDB
wi1605p_forum_reactions: Data: 1.48MB + Index: 0.00MB + Engine InnoDB
wi1605p_forum_reports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_forum_topics: Data: 1.52MB + Index: 0.80MB + Engine InnoDB
wi1605p_gf_addon_feed: Data: 1.50MB + Index: 0.02MB + Engine InnoDB
wi1605p_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_gf_entry: Data: 24.55MB + Index: 6.03MB + Engine InnoDB
wi1605p_gf_entry_meta: Data: 58.58MB + Index: 73.80MB + Engine InnoDB
wi1605p_gf_entry_notes: Data: 3.52MB + Index: 1.97MB + Engine InnoDB
wi1605p_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_gf_form_meta: Data: 2.33MB + Index: 0.00MB + Engine InnoDB
wi1605p_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wi1605p_gf_form_view: Data: 1.52MB + Index: 2.00MB + Engine InnoDB
wi1605p_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wi1605p_ia_savedcarts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wi1605p_learndash_pro_quiz_category: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_learndash_pro_quiz_form: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_learndash_pro_quiz_lock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_learndash_pro_quiz_master: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_learndash_pro_quiz_prerequisite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_learndash_pro_quiz_question: Data: 0.33MB + Index: 0.03MB + Engine InnoDB
wi1605p_learndash_pro_quiz_statistic: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
wi1605p_learndash_pro_quiz_statistic_ref: Data: 0.30MB + Index: 0.23MB + Engine InnoDB
wi1605p_learndash_pro_quiz_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_learndash_pro_quiz_toplist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_learndash_user_activity: Data: 5.52MB + Index: 17.92MB + Engine InnoDB
wi1605p_learndash_user_activity_meta: Data: 8.52MB + Index: 8.03MB + Engine InnoDB
wi1605p_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_mailchimp_carts: Data: 0.20MB + Index: 0.00MB + Engine InnoDB
wi1605p_mepr_events: Data: 1.52MB + Index: 1.00MB + Engine InnoDB
wi1605p_mepr_jobs: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
wi1605p_mepr_members: Data: 0.13MB + Index: 0.23MB + Engine InnoDB
wi1605p_mepr_subscriptions: Data: 1.52MB + Index: 0.30MB + Engine InnoDB
wi1605p_mepr_tax_rates: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
wi1605p_mepr_tax_rate_locations: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wi1605p_mepr_transactions: Data: 1.52MB + Index: 0.75MB + Engine InnoDB
wi1605p_mo_campaign_log: Data: 534.63MB + Index: 0.00MB + Engine InnoDB
wi1605p_mo_campaign_logmeta: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wi1605p_mo_conversions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_mo_email_campaignmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_mo_email_campaigns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_mo_optin_advance_stat: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wi1605p_mo_optin_campaignmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_mo_optin_campaigns: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wi1605p_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_nextend2_section_storage: Data: 1.02MB + Index: 0.13MB + Engine InnoDB
wi1605p_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_nextend2_smartslider3_sliders: Data: 0.17MB + Index: 0.03MB + Engine InnoDB
wi1605p_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_nextend2_smartslider3_slides: Data: 0.27MB + Index: 0.13MB + Engine InnoDB
wi1605p_object_sync_sf_field_map: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wi1605p_object_sync_sf_object_map: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wi1605p_options: Data: 167.25MB + Index: 3.25MB + Engine InnoDB
wi1605p_postmeta: Data: 1689.98MB + Index: 1239.95MB + Engine InnoDB
wi1605p_posts: Data: 491.77MB + Index: 101.30MB + Engine InnoDB
wi1605p_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_redirection_404: Data: 9.03MB + Index: 7.06MB + Engine InnoDB
wi1605p_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wi1605p_redirection_items: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wi1605p_redirection_logs: Data: 2.02MB + Index: 1.19MB + Engine InnoDB
wi1605p_revslider_css: Data: 0.14MB + Index: 0.00MB + Engine InnoDB
wi1605p_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_revslider_slides: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wi1605p_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_rg_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_rg_form_meta: Data: 1.22MB + Index: 0.00MB + Engine InnoDB
wi1605p_rg_form_view: Data: 0.31MB + Index: 0.25MB + Engine InnoDB
wi1605p_rg_incomplete_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_rg_lead: Data: 4.52MB + Index: 0.61MB + Engine InnoDB
wi1605p_rg_lead_detail: Data: 5.52MB + Index: 11.89MB + Engine InnoDB
wi1605p_rg_lead_detail_long: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_rg_lead_meta: Data: 3.52MB + Index: 7.55MB + Engine InnoDB
wi1605p_rg_lead_notes: Data: 0.22MB + Index: 0.11MB + Engine InnoDB
wi1605p_rg_zapier: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_signups: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
wi1605p_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wi1605p_sr_woo_order_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wi1605p_talentlms: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wi1605p_talentlms_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_talentlms_courses: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wi1605p_talentlms_products: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_talentlms_products_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_termmeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
wi1605p_terms: Data: 0.31MB + Index: 0.28MB + Engine InnoDB
wi1605p_term_relationships: Data: 54.14MB + Index: 20.50MB + Engine InnoDB
wi1605p_term_taxonomy: Data: 1.52MB + Index: 0.42MB + Engine InnoDB
wi1605p_usermeta: Data: 245.42MB + Index: 125.59MB + Engine InnoDB
wi1605p_users: Data: 7.17MB + Index: 6.33MB + Engine InnoDB
wi1605p_vimeography_gallery: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_vimeography_gallery_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_wcs_payment_retries: Data: 2.45MB + Index: 0.23MB + Engine InnoDB
wi1605p_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_wc_admin_note_actions: Data: 0.03MB + Index: 0.02MB + Engine InnoDB
wi1605p_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_wc_customer_lookup: Data: 8.50MB + Index: 6.75MB + Engine InnoDB
wi1605p_wc_download_log: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
wi1605p_wc_order_bundle_lookup: Data: 0.30MB + Index: 0.53MB + Engine InnoDB
wi1605p_wc_order_coupon_lookup: Data: 0.30MB + Index: 0.38MB + Engine InnoDB
wi1605p_wc_order_product_lookup: Data: 29.52MB + Index: 26.64MB + Engine InnoDB
wi1605p_wc_order_stats: Data: 23.42MB + Index: 19.50MB + Engine InnoDB
wi1605p_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wi1605p_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_wc_product_meta_lookup: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wi1605p_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_wc_zapier_history: Data: 3.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_wll_login_attempts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_woochimp_scheduled_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_woocommerce_bundled_itemmeta: Data: 0.09MB + Index: 0.13MB + Engine InnoDB
wi1605p_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wi1605p_woocommerce_exported_csv_items: Data: 280.02MB + Index: 43.17MB + Engine InnoDB
wi1605p_woo_sr_cart_items: Data: 0.14MB + Index: 0.13MB + Engine InnoDB
wi1605p_woo_sr_orders: Data: 0.23MB + Index: 0.19MB + Engine InnoDB
wi1605p_woo_sr_order_items: Data: 0.14MB + Index: 0.08MB + Engine InnoDB
wi1605p_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_wpml_mails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wi1605p_wpmudev_chat_log: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wi1605p_wpmudev_chat_message: Data: 8.52MB + Index: 9.53MB + Engine InnoDB
wi1605p_wpmudev_chat_users: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wi1605p_yoast_indexable: Data: 127.67MB + Index: 90.33MB + Engine InnoDB
wi1605p_yoast_indexable_hierarchy: Data: 19.44MB + Index: 22.25MB + Engine InnoDB
wi1605p_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wi1605p_yoast_primary_term: Data: 1.52MB + Index: 3.03MB + Engine InnoDB
wi1605p_yoast_seo_links: Data: 11.52MB + Index: 5.89MB + Engine InnoDB
wi1605p_yoast_seo_meta: Data: 13.20MB + Index: 0.00MB + Engine InnoDB

Post Type Counts

aam_policy: 1
acf-field: 50
acf-field-group: 11
advanced_ads: 58
amn_smtp: 1
attachment: 13646
aw_workflow: 19
bnfw_notification: 6
bp-email: 16
careers: 8
cfp_posts: 1003
crypto-cue: 7
custom_css: 1
customize_changeset: 14
education-center: 114
eta_type: 253
forum: 1
inc_popup: 1
inner-circle-thurs: 2
inner-circle-tuesday: 1
inner-circle-wed: 2
invest_video_post: 1
investitute_lpo_type: 1851
investitute_lpp_type: 2507
investitute_uoa_type: 58659
jetpack_migration: 2
mc4wp-form: 2
memberpressproduct: 15
memberpressrule: 6
mepr-subscriptions: 249
mp-reminder: 2
mrc: 85
ms_communication: 7
ms_event: 872
ms_invoice: 312
ms_membership: 3
ms_relationship: 295
mt_pp: 40
nav_menu_item: 478
oembed_cache: 48
oraclehour: 153
ota_type: 289
page: 482
phoenix_portfolio: 672
popup: 2
popup_theme: 6
post: 10674
product: 356
product_variation: 68
rapidfire-charts: 4
reply: 3
revision: 34488
scs: 174
sfwd-courses: 20
sfwd-lessons: 129
sfwd-question: 194
sfwd-quiz: 21
sfwd-topic: 50
shop_coupon: 96
shop_order: 281632
shop_order_refund: 13227
shop_subscription: 22827
slide_in: 1
sma_pro_type: 7723
sma_type: 1748
spt: 1
staff: 47
tbo: 1043
templatera: 2
testimonials: 66
time_bandit: 1421
topic: 2
user_request: 7
vc_grid_item: 6
wc_membership_plan: 55
wc_user_membership: 71534
wd_ip_lockout: 3080
wd_iplockout_log: 2367
wdca_custom_ad: 3
wdscan_result: 1
wll_records: 51785
wp_log: 2

Security

Secure connection (HTTPS): ✔
Hide errors from visitors: ✔

Active Plugins (89)

Advanced Custom Fields: Extended: by ACF Extended – 0.8.8.7
Advanced Access Manager: by Vasyl Martyniuk vasyl@vasyltech.com – 6.8.1
Advanced Ads – Slider: by Thomas Maier – 1.4.4
Advanced Ads: by Thomas Maier
Advanced Ads GmbH – 1.33.2

Advanced Custom Fields PRO: by Delicious Brains – 5.12.2
Advanced Custom Fields: Table Field: by Johann Heyne – 1.3.14
Affiliate For WooCommerce: by StoreApps – 4.3.0
Akismet Anti-Spam: by Automattic – 4.2.3
Asgaros Forum: by Thomas Belser – 2.0.0
AutomateWoo: by WooCommerce – 5.5.13
Awin - Advertiser Tracking: by awinglobal – 1.0.9
Better Notifications for WP: by Made with Fuel – 1.8.11
Chatroll Live Chat: by Chatroll – 2.4.0
Classic Widgets: by WordPress Contributors – 0.3
Custom Post Type Rewrite: by thingsym – 1.1.0
Custom Post Type UI: by WebDevStudios – 1.11.2
Custom Post Type Widgets: by thingsym – 1.4.2
Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.4
FacetWP: by FacetWP
LLC – 4.0

Funnychord Coaching Manager: by Funnychord / Neil Laferty – 1.4.2
Funnychord: by Funnychord / Neil Laferty – 1.8.15
Funnychord HubSpot E-Commerce Sync: by Funnychord / Neil Laferty – 1.0.3
Funnychord Smart Money Advantage: by Funnychord / Neil Laferty – 1.1.6
Funnychord Unusual Options Activity: by Funnychord / Neil Laferty – 2.5.11
Feed Socket: by ParadiVision Inc. / Jerome Paradis – 1.7.1
Chat by Flyzoo - Group Chat & Live Support: by Flyzoo – 2.3.3
Gravity Forms Image Choices: by JetSloth – 1.3.51
Gravity Forms No CAPTCHA reCAPTCHA: by John Parks - Folkhack Studios – 1.0.7
Gravity Forms: by Gravity Forms – 2.6.1
Gravity Forms Advanced Post Creation Add-On: by Gravity Forms – 1.2
Gravity Forms HubSpot Add-On: by Gravity Forms – 1.7
Gravity Forms Mailchimp Add-On: by Gravity Forms – 5.0
Gravity Forms Polls Add-On: by Gravity Forms – 3.9
Gravity Forms Quiz Add-On: by Gravity Forms – 3.9
Gravity Forms Signature Add-On: by Gravity Forms – 4.2
Gravity Forms Survey Add-On: by Gravity Forms – 3.7
Gravity Forms Zapier Add-On: by Gravity Forms – 4.2
Gravity Forms Utility: by gravity+ – 2.7.0.dev1
Health Check & Troubleshooting: by The WordPress.org community – 1.4.5
WPBakery Page Builder: by Michael M - WPBakery.com – 6.8.0
HubSpot All-In-One Marketing - Forms, Popups, Live Chat: by HubSpot – 8.10.25
LearnDash LMS - WooCommerce Integration: by LearnDash – 1.9.4.1
LearnDash LMS - Zapier Integration: by LearnDash – 2.3.0
Limit Login Attempts Reloaded: by Limit Login Attempts Reloaded – 2.24.1
Loco Translate: by Tim Whitlock – 2.6.1
MailOptin - Pro: by MailOptin Team – 2.2.46.1
Market Rebellion Crypto: by Market Rebellion – 1.0.0
Market Rebellion Rebel Chat: by Market Rebellion – 1.0.6
Nav Menu Roles + WooCommerce Memberships Bridge: by Kathy Darling – 1.0.0
Nav Menu Roles: by Kathy Darling – 2.1.0
Smart Slider 3 Pro: by Nextend – 3.5.1.5
Perfmatters: by forgemedia – 1.9.0
Redirection: by John Godley – 5.2.3
Responsive Lightbox & Gallery: by dFactory – 2.3.5
SendGrid: by SendGrid – 1.11.8
LearnDash LMS: by LearnDash – 4.1.0
Sucuri Security - Auditing, Malware Scanner and Hardening: by Sucuri Inc. – 1.8.30
TalentLMS | Customized for Market Rebellion: by Epignosis LLC – 6.6.9.3
Templatera: by WPBakery – 2.0.5
Total Theme Core: by WPExplorer – 1.3.2
Unbounce Landing Pages: by Unbounce – 1.0.47
User Switching: by John Blackbourn & contributors – 1.5.8
Username Changer: by Widgit Team – 3.2.2
Vimeography: by Dave Kiss – 2.3.0
WooChimp: by RightPress – 2.2.7
WooCommerce Conditional Shipping and Payments: by WooCommerce – 1.13.0
WooCommerce Customer/Order/Coupon Export: by SkyVerge – 5.3.3
WooCommerce Authorize.Net Gateway: by SkyVerge – 3.7.0
WooCommerce Stripe Gateway: by WooCommerce – 6.3.0
WooCommerce Google Analytics Integration: by WooCommerce – 1.5.8
WooCommerce HubSpot Sync: by Gate 39 Media – 1.2.0
MailChimp for WooCommerce Memberships: by SkyVerge – 1.4.0
WooCommerce Memberships: by SkyVerge – 1.23.0
WooCommerce Order Proposal | Customized for Market Rebellion: by Voleatech GmbH – 1.6.7
WooCommerce Product Bundles: by WooCommerce – 6.15.2
WooCommerce Redirect Thank You: by Shop Plugins – 2.0.5
WooCommerce Shipment Tracking: by WooCommerce – 1.7.0
WooCommerce Smart Coupons: by StoreApps – 5.2.0
WooCommerce Subscriptions CSV Importer and Exporter: by Prospress Inc – 2.0-beta
WooCommerce Subscriptions: by WooCommerce – 4.1.0
WooCommerce Zapier: by OM4 Software – 2.3.0
WooCommerce: by Automattic – 6.4.1
Yoast SEO: by Team Yoast – 18.6
WP Crontrol: by John Blackbourn & crontributors – 1.12.1
Smush: by WPMU DEV – 3.9.8
WP Super Cache: by Automattic – 1.7.7
WP User Avatar Pro: by flippercode – 4.1.0
Zoom WordPress Plugin: by eLearning evolve – 4.23.4
Zapier for WordPress: by Zapier – 1.0.4

Inactive Plugins (0)

Dropin Plugins (1)

advanced-cache.php: advanced-cache.php

Must Use Plugins (2)

Health Check Troubleshooting Mode: by – 1.7.2
LearnDash LMS Multisite: by LearnDash – 1.0.0

Settings

API Enabled: ✔
Force SSL: ✔
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: bundle (bundle)
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: ✔

WC Pages

Shop base: #4804 - /shop/
Cart: #145558 - /shop/cart/
Checkout: #4808 - /shop/checkout/
My account: #3690 - /account/
Terms and conditions: #101 - /terms-of-use/

Theme

Name: Total Child
Version: 2.0.1
Author URL: http://totalwptheme.com
Child Theme: ✔
Parent Theme Name: Total
Parent Theme Version: 5.3.1
Parent Theme Author URL: https://www.wpexplorer.com/
WooCommerce Support: ✔

Templates

Archive Template: Your theme has a woocommerce.php file
you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.

Overrides: Total/woocommerce/archive-product.php
total-child-theme/woocommerce/cart/cart-empty.php
total-child-theme/woocommerce/cart/cart-item-data.php
total-child-theme/woocommerce/cart/cart-shipping.php
total-child-theme/woocommerce/cart/cart-totals.php
total-child-theme/woocommerce/cart/cart.php
total-child-theme/woocommerce/cart/cross-sells.php
total-child-theme/woocommerce/cart/mini-cart.php
total-child-theme/woocommerce/cart/proceed-to-checkout-button.php
total-child-theme/woocommerce/cart/shipping-calculator.php
total-child-theme/woocommerce/checkout/form-checkout.php
total-child-theme/woocommerce/checkout/form-pay.php
total-child-theme/woocommerce/checkout/payment-method.php
total-child-theme/woocommerce/checkout/payment.php
total-child-theme/woocommerce/checkout/review-order.php
total-child-theme/woocommerce/checkout/terms.php
total-child-theme/woocommerce/content-product.php
total-child-theme/woocommerce/emails/customer-completed-order.php
total-child-theme/woocommerce/emails/customer-invoice.php
total-child-theme/woocommerce/emails/customer-new-account.php
total-child-theme/woocommerce/emails/customer-processing-order.php
total-child-theme/woocommerce/emails/email-header.php
total-child-theme/woocommerce/emails/email-order-details.php
total-child-theme/woocommerce/emails/email-order-items.php
total-child-theme/woocommerce/emails/email-styles.php
total-child-theme/woocommerce/loop/loop-start.php
Total/woocommerce/loop/pagination.php
total-child-theme/woocommerce/myaccount/dashboard.php
total-child-theme/woocommerce/myaccount/form-edit-account.php
total-child-theme/woocommerce/myaccount/navigation.php
total-child-theme/woocommerce/myaccount/orders.php
total-child-theme/woocommerce/myaccount/view-order.php
total-child-theme/woocommerce/order/order-again.php
total-child-theme/woocommerce/order/order-details.php
Total/woocommerce/single-product/meta.php
Total/woocommerce/single-product/rating.php
total-child-theme/woocommerce/single-product/title.php
total-child-theme/woocommerce/single-product.php

Memberships

Restriction mode:: Redirect to page
Public content:: Pages: 1 itemUnusual Activity: 1 item
Excluded from discounts:: –
Membership plans:: 54
Crypto Cue:: Members: 51Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: No
2022 RebelCon:: Members: 45Access method: Product(s) purchaseAccess length: Unlimited Subscription: No
Rapid Fire Charts:: Members: 146Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: No❌ The plan contains a rule to restrict all RapidFire Charts to non-members
TNT Options Pro Rebel Pit - TEST:: Members: 16Access method: Manual assignment onlyAccess length: Unlimited Subscription: No
TNT Options Pro Rebel Pit:: Members: 447Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: No❌ The plan contains a rule to restrict all TNT Options Updates to non-members❌ The plan contains a rule to restrict all TNT Options Pro to non-members
Trading the Condor:: Members: 173Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: No
AJ's Inner Circle - Thursday Class:: Members: 60Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: No❌ The plan contains a rule to restrict all AJ's Inner Circle - Thursdays to non-members
AJ's Inner Circle - Wednesday Class:: Members: 59Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: No❌ The plan contains a rule to restrict all AJ's Inner Circle - Wednesdays to non-members
AJ's Inner Circle - Tuesday Class:: Members: 65Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: No❌ The plan contains a rule to restrict all AJ's Inner Circle - Tuesdays to non-members
Mastering Technical Analysis:: Members: 12Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: No
Education: Advanced Q&A Live:: Members: 3Access method: Manual assignment onlyAccess length: Specific length (1 years)Subscription: No
Smart Spreads:: Members: 816Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: No❌ The plan contains a rule to restrict all Smart Spreads to non-members
Candlesticks:: Members: 220Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: No
2021 Trading Conference:: Members: 224Access method: Product(s) purchaseAccess length: Fixed dates (369 days)Subscription: No
Stock Market Mechanics:: Members: 11Access method: Manual assignment onlyAccess length: Specific length (1 years)Subscription: No
UOA Masterclass:: Members: 455Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: OptionalInstallment plan: No
Covered Call Masterclass:: Members: 112Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: No
Oracle Hour:: Members: 1591Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: No❌ The plan contains a rule to restrict all Oracle Hour to non-members
2020 Virtual Conference Attendee:: Members: 637Access method: Product(s) purchaseAccess length: Specific length (60 days)Subscription: No
Equity Oracle:: Members: 1048Access method: Product(s) purchaseAccess length: Unlimited Subscription: OptionalInstallment plan: No❌ The plan contains a rule to restrict all Equity Oracle Updates to non-members
Options Oracle:: Members: 1214Access method: Product(s) purchaseAccess length: Unlimited Subscription: OptionalInstallment plan: No❌ The plan contains a rule to restrict all Options Oracle Updates to non-members
Market Rebellion Crypto:: Members: 7940Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: YesInstallment plan: No❌ The plan contains a rule to restrict all Crypto to non-members
UOA Pro:: Members: 2561Access method: Product(s) purchaseAccess length: Unlimited Subscription: OptionalInstallment plan: No❌ The plan contains a rule to restrict all UOA Pro Updates to non-members❌ The plan contains a rule to restrict all UOA Essential Updates to non-members
Pete’s Covered Calls:: Members: 449Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: No❌ The plan contains a rule to restrict all Cash Flow Portfolio to non-members
UOA Essential:: Members: 6371Access method: Product(s) purchaseAccess length: Unlimited Subscription: OptionalInstallment plan: No❌ The plan contains a rule to restrict all UOA Essential Updates to non-members
Triple Digit Options Profits:: Members: 5Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: No
Unusual Activity – One Year Membership:: Members: 258Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: No
Unusual Activity – One Month Membership:: Members: 30Access method: Product(s) purchaseAccess length: Specific length (1 months)Subscription: No
Phoenix Portfolio:: Members: 220Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: No❌ The plan contains a rule to restrict all Phoenix Posts to non-members
Course: The Phoenix Portfolio:: Members: 507Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: OptionalInstallment plan: No
TNT Options Annual Membership:: Members: 1183Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: No❌ The plan contains a rule to restrict all TNT Options Updates to non-members
TNT Options Free Preview:: Members: 483Access method: Product(s) purchaseAccess length: Specific length (1 months)Subscription: No❌ The plan contains a rule to restrict all TNT Options Updates to non-members
TNT Options Membership:: Members: 8692Access method: Product(s) purchaseAccess length: Unlimited Subscription: No❌ The plan contains a rule to restrict all TNT Options Updates to non-members
Course: Drawing Trend Lines:: Members: 2004Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: No
Course: Theory & Strategy of Unusual Option Activity:: Members: 3510Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: OptionalInstallment plan: No
Course: Drawing Flat Lines:: Members: 3086Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: OptionalInstallment plan: No
Time Bandit Options:: Members: 986Access method: Product(s) purchaseAccess length: Unlimited Subscription: OptionalInstallment plan: No❌ The plan contains a rule to restrict all Time Bandit to non-members
TNT Options – UOA:: Members: 2106Access method: Product(s) purchaseAccess length: Unlimited Subscription: OptionalInstallment plan: No❌ The plan contains a rule to restrict all TNT Options Updates to non-members
TNT Options Platinum:: Members: 3Access method: Product(s) purchaseAccess length: Specific length (2 years)Subscription: No❌ The plan contains a rule to restrict all TNT Options Updates to non-members
Profitable Iron Condors:: Members: 10Access method: Product(s) purchaseAccess length: Unlimited Subscription: No
Credit Spreads Made Easy:: Members: 53Access method: Product(s) purchaseAccess length: Unlimited Subscription: No
Options Decoded:: Members: 36Access method: Product(s) purchaseAccess length: Unlimited Subscription: No
Crypto Basics:: Members: 121Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: No
Time Bandit Options Pro:: Members: 706Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: No❌ The plan contains a rule to restrict all Time Bandit Pro to non-members❌ The plan contains a rule to restrict all Time Bandit to non-members
TNT Options Pro | Stockrulebook.com:: Members: 5Access method: Product(s) purchaseAccess length: Unlimited Subscription: No❌ The plan contains a rule to restrict all TNT Options Pro to non-members
TNT Options | Stockrulebook.com:: Members: 114Access method: Product(s) purchaseAccess length: Unlimited Subscription: No❌ The plan contains a rule to restrict all TNT Options Updates to non-members
Education Center:: Members: 3833Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: OptionalInstallment plan: No❌ The plan contains a rule to restrict all Education to non-members
Call and Put Options:: Members: 145Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: No
Site Moderator:: Members: 49Access method: Manual assignment onlyAccess length: Unlimited Subscription: No
Unusual Activity:: Members: 2942Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: No
TNT Options:: Members: 3914Access method: Product(s) purchaseAccess length: Unlimited Subscription: YesInstallment plan: No❌ The plan contains a rule to restrict all TNT Options Updates to non-members
Crash-Proof Portfolio:: Members: 2559Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: OptionalInstallment plan: No
Beginner's Options Course:: Members: 7930Access method: Product(s) purchaseAccess length: Specific length (1 years)Subscription: OptionalInstallment plan: No
TNT Options Pro:: Members: 1317Access method: Product(s) purchaseAccess length: Unlimited Subscription: OptionalInstallment plan: No❌ The plan contains a rule to restrict all TNT Options Pro to non-members❌ The plan contains a rule to restrict all TNT Options Updates to non-members

Subscriptions

WCS_DEBUG: ✔ No
Subscriptions Mode: ✔ Live
Subscriptions Live URL: https://marketrebellion.com
Subscriptions Template Theme Overrides: total-child-theme/woocommerce/emails/email-order-details.php
Subscription Statuses: wc-active: 6861
wc-expired: 12
wc-pending-cancel: 564
wc-on-hold: 429
wc-cancelled: 14961

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: ✔ Yes
Cache Update Failures: ✔ 0 failure

Store Setup

Country / State: United States (US) — Florida

Subscriptions by Payment Gateway

other: wc-cancelled: 102
Authorize.Net Credit Card: wc-active: 3283
wc-cancelled: 10008
wc-expired: 2
wc-on-hold: 179
wc-pending-cancel: 297

Stripe: wc-active: 725
wc-cancelled: 1345
wc-on-hold: 41
wc-pending-cancel: 58

Payment Gateway Support

Authorize.Net Credit Card: products
card_types
payment_form
inline
lightbox
tokenization
token_editor
charge
charge-virtual
authorization
capture_charge
customer_decline_messages
refunds
voids
customer_id
add_payment_method
apple_pay
subscriptions
subscription_suspension
subscription_cancellation
subscription_reactivation
subscription_amount_changes
subscription_date_changes
multiple_subscriptions
subscription_payment_method_change_customer
subscription_payment_method_change_admin

Stripe: products
refunds
tokenization
add_payment_method
subscriptions
subscription_cancellation
subscription_suspension
subscription_reactivation
subscription_amount_changes
subscription_date_changes
subscription_payment_method_change
subscription_payment_method_change_customer
subscription_payment_method_change_admin
multiple_subscriptions

Product Bundles

Database Version: 6.15.2
Loopback Test: ✔
Template Overrides: –

Authorize.Net Credit Card

Environment: Production
Tokenization Enabled: ✔
Debug Mode: Off
Webhooks Enabled: ✔

WooCommerce Customer/Order/Coupon Export

Automated exports: 3
Custom formats: 7
Next export: Scheduled on April 28
2022 3:57 pm

Action Scheduler

Canceled: 31
Oldest: 2022-03-28 17:27:28 -0400
Newest: 2023-03-10 13:16:37 -0500

Complete: 99,664
Oldest: 2022-04-11 13:17:49 -0400
Newest: 2022-04-28 15:30:16 -0400

Failed: 385
Oldest: 2020-04-18 17:42:37 -0400
Newest: 2022-04-28 11:01:21 -0400

Pending: 25,369
Oldest: 2022-04-28 15:31:05 -0400
Newest: 2099-03-31 17:13:56 -0500

WooCommerce Zapier

Database Version: ✔ 14
Detailed Logging Enabled: No
Legacy Mode Disabled: ✔ Yes
SSL: ✔ Yes
REST API Authentication Key(s): ✔ 19
Task History Record Count: ✔ 10214
Webhook #82: WooCommerce Zapier

Status report information

Generated at: 2022-04-28 15:31:15 -04:00
`

Isolating the problem

  • I have deactivated other plugins and confirmed this bug occurs when only WooCommerce plugin is active.
  • This bug happens with a default WordPress theme active, or Storefront.
  • I can reproduce this bug consistently using the steps above.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Assignees

No one assigned

    Labels

    plugin: woocommerceIssues related to the WooCommerce Core plugin.status: can't reproduceIssues that can't be reproduced.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions