Forum Replies Created

Viewing 15 replies - 1 through 15 (of 46 total)
  • Thread Starter own3mall

    (@own3mall)

    That certainly sounds better, but it doesn’t sound right for “fixed cart discounts”. For the overall eligibility check, the fixed cart discount should apply if there are ANY products in the cart that don’t have “exclude from coupons” set. Is that doable? I realize that these may be limitations with WooCommerce itself, but fixed cart discounts should still apply if there are any items in the cart that don’t have “exclude from coupons” enabled even if there are other products in the cart that do have it enabled. The only time it should not apply is if the cart is full of items that have “exclude from coupons” enabled

    Thread Starter own3mall

    (@own3mall)

    We’re using WooCommerce Version 5.1.0

    We’re unable to update to a newer version due to customizations we’ve made. It might be best to check for the presence of this interface before registering the blocks hook. Commenting it out fixes it for us, but there should be a check…

    Thread Starter own3mall

    (@own3mall)

    Live environment:

    ### WordPress Environment ###

    WordPress address (URL): url_removed
    Site address (URL): url_removed
    WC Version: 5.1.0
    REST API Version: ✔ 5.1.0
    WC Blocks Version: ✔ 4.4.3
    Action Scheduler Version: ✔ 3.1.6
    WC Admin Version: ❌ Inactive 2.0.2
    Log Directory Writable: ✔
    WP Version: ❌ 5.7.5 – There is a newer version of WordPress available (5.9)
    WP Multisite: –
    WP Memory Limit: 2 GB
    WP Debug Mode: –
    WP Cron: –
    Language: en_US
    External object cache: ✔

    ### Server Environment ###

    Server Info: nginx/1.18.0
    PHP Version: 7.4.3
    PHP Post Max Size: 500 MB
    PHP Time Limit: 240
    PHP Max Input Vars: 1000
    cURL Version: 7.68.0
    OpenSSL/1.1.1f

    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.3.32-MariaDB-0ubuntu0.20.04.1
    Max Upload Size: 500 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ❌ Your server does not have the SoapClient class enabled – some gateway plugins which use SOAP may not work as expected.
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔

    ### Database ###

    WC Database Version: 5.0.0
    WC Database Prefix: wpme_
    Total Database Size: 1004.75MB
    Database Data Size: 581.90MB
    Database Index Size: 422.85MB
    wpme_woocommerce_sessions: Data: 1.39MB + Index: 0.02MB + Engine InnoDB
    wpme_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpme_woocommerce_order_items: Data: 5.52MB + Index: 2.52MB + Engine InnoDB
    wpme_woocommerce_order_itemmeta: Data: 48.59MB + Index: 50.14MB + Engine InnoDB
    wpme_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpme_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blog_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blog_comments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    blog_gglcptch_allowlist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blog_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blog_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    blog_options: Data: 1.52MB + Index: 0.06MB + Engine InnoDB
    blog_popularpostsdata: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    blog_popularpostssummary: Data: 0.09MB + Index: 0.14MB + Engine InnoDB
    blog_postmeta: Data: 3.52MB + Index: 0.25MB + Engine InnoDB
    blog_posts: Data: 4.52MB + Index: 0.23MB + Engine InnoDB
    blog_ratings: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blog_rio_process_queue: Data: 0.08MB + Index: 0.08MB + Engine InnoDB
    blog_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blog_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    blog_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    blog_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blog_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blog_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    blog_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    blog_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    blog_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    blog_wprm_analytics: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    blog_wprm_ratings: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    eric_pos_tracking: Data: 0.22MB + Index: 0.14MB + Engine InnoDB
    wpme_actionscheduler_actions: Data: 1.52MB + Index: 0.78MB + Engine InnoDB
    wpme_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_actionscheduler_logs: Data: 1.52MB + Index: 0.52MB + Engine InnoDB
    wpme_aryo_activity_log: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
    wpme_automatewoo_abandoned_carts: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wpme_automatewoo_customers: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wpme_automatewoo_events: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpme_automatewoo_guests: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpme_automatewoo_guest_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_automatewoo_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpme_automatewoo_log_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpme_automatewoo_queue_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_automatewoo_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpme_commentmeta: Data: 0.19MB + Index: 0.59MB + Engine InnoDB
    wpme_comments: Data: 13.55MB + Index: 21.61MB + Engine InnoDB
    wpme_esp_answer: Data: 1.52MB + Index: 0.81MB + Engine InnoDB
    wpme_esp_attendee_meta: Data: 0.28MB + Index: 0.38MB + Engine InnoDB
    wpme_esp_checkin: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_esp_country: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wpme_esp_currency: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_esp_currency_payment_method: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_esp_datetime: Data: 0.11MB + Index: 0.11MB + Engine InnoDB
    wpme_esp_datetime_ticket: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wpme_esp_event_mailchimp_list_group: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_esp_event_message_template: Data: 1.52MB + Index: 3.03MB + Engine InnoDB
    wpme_esp_event_meta: Data: 0.09MB + Index: 0.05MB + Engine InnoDB
    wpme_esp_event_question_group: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
    wpme_esp_event_question_mailchimp_field: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_esp_event_venue: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wpme_esp_extra_join: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_esp_extra_meta: Data: 13.52MB + Index: 5.52MB + Engine InnoDB
    wpme_esp_line_item: Data: 6.52MB + Index: 9.06MB + Engine InnoDB
    wpme_esp_log: Data: 0.34MB + Index: 0.17MB + Engine InnoDB
    wpme_esp_message: Data: 88.63MB + Index: 8.72MB + Engine InnoDB
    wpme_esp_message_template: Data: 1.52MB + Index: 0.02MB + Engine InnoDB
    wpme_esp_message_template_group: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_esp_payment: Data: 0.50MB + Index: 0.17MB + Engine InnoDB
    wpme_esp_payment_method: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_esp_price: Data: 0.17MB + Index: 0.05MB + Engine InnoDB
    wpme_esp_price_type: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_esp_promotion: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
    wpme_esp_promotion_object: Data: 0.16MB + Index: 0.19MB + Engine InnoDB
    wpme_esp_question: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_esp_question_group: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_esp_question_group_question: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_esp_question_option: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_esp_registration: Data: 1.52MB + Index: 1.80MB + Engine InnoDB
    wpme_esp_registration_payment: Data: 0.23MB + Index: 0.33MB + Engine InnoDB
    wpme_esp_state: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_esp_status: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_esp_ticket: Data: 0.16MB + Index: 0.05MB + Engine InnoDB
    wpme_esp_ticket_price: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wpme_esp_ticket_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_esp_transaction: Data: 4.52MB + Index: 0.23MB + Engine InnoDB
    wpme_esp_venue_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpme_events_answer: Data: 8.52MB + Index: 11.03MB + Engine InnoDB
    wpme_events_attendee: Data: 35.58MB + Index: 3.03MB + Engine InnoDB
    wpme_events_attendee_checkin: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpme_events_attendee_meta: Data: 26.56MB + Index: 1.52MB + Engine InnoDB
    wpme_events_category_detail: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_events_category_rel: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
    wpme_events_detail: Data: 34.58MB + Index: 4.22MB + Engine InnoDB
    wpme_events_discount_codes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_events_discount_rel: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wpme_events_email: Data: 0.11MB + Index: 0.02MB + Engine InnoDB
    wpme_events_groupon_codes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    wpme_events_locale: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_events_locale_rel: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_events_mailchimp_attendee_rel: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_events_mailchimp_event_rel: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
    wpme_events_member_rel: Data: 0.34MB + Index: 0.00MB + Engine InnoDB
    wpme_events_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_events_multi_event_registration_id_group: Data: 1.52MB + Index: 3.03MB + Engine InnoDB
    wpme_events_personnel: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_events_personnel_rel: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_events_prices: Data: 2.52MB + Index: 0.28MB + Engine InnoDB
    wpme_events_qst_group: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_events_qst_group_rel: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_events_question: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpme_events_recurrence: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_events_start_end: Data: 1.52MB + Index: 0.27MB + Engine InnoDB
    wpme_events_ticket_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_events_venue: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_events_venue_rel: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_gf_addon_payment_callback: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    wpme_gf_addon_payment_transaction: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpme_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_gf_entry: Data: 1.52MB + Index: 0.17MB + Engine InnoDB
    wpme_gf_entry_meta: Data: 3.52MB + Index: 4.45MB + Engine InnoDB
    wpme_gf_entry_notes: Data: 1.52MB + Index: 0.20MB + Engine InnoDB
    wpme_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_gf_form_meta: Data: 0.19MB + Index: 0.00MB + Engine InnoDB
    wpme_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_gf_form_view: Data: 0.19MB + Index: 0.17MB + Engine InnoDB
    wpme_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_gglcptch_allowlist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_giftvouchers_activity: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_giftvouchers_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_giftvouchers_setting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_giftvouchers_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_grp_google_place: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_grp_google_review: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wpme_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_mclean_refs: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wpme_mclean_scan: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_options: Data: 12.06MB + Index: 0.47MB + Engine InnoDB
    wpme_pmxe_exports: Data: 0.42MB + Index: 0.00MB + Engine InnoDB
    wpme_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
    wpme_pmxe_posts: Data: 0.50MB + Index: 0.00MB + Engine InnoDB
    wpme_pmxe_templates: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
    wpme_postmeta: Data: 84.67MB + Index: 254.97MB + Engine InnoDB
    wpme_posts: Data: 76.55MB + Index: 11.06MB + Engine InnoDB
    wpme_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_termmeta: Data: 0.11MB + Index: 0.34MB + Engine InnoDB
    wpme_terms: Data: 0.13MB + Index: 0.16MB + Engine InnoDB
    wpme_term_relationships: Data: 1.52MB + Index: 0.44MB + Engine InnoDB
    wpme_term_taxonomy: Data: 0.13MB + Index: 0.20MB + Engine InnoDB
    wpme_tinvwl_analytics: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_tinvwl_items: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wpme_tinvwl_lists: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wpme_tip_jar_wp_arrangements: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_tip_jar_wp_download_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_tip_jar_wp_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_tip_jar_wp_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_tip_jar_wp_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_tip_jar_wp_transactions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_totalsoft_new_plugin: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_answers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_dbt: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_id: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_iminqu: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_iminqu_01: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_iminqu_02: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_iminqu_1: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_impoll: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_impoll_01: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_impoll_02: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_impoll_1: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_imwibu: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_imwibu_01: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_imwibu_02: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_imwibu_1: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_inform: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_quest_im: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_results: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_setting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_stpoll: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_stpoll_01: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_stpoll_02: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_stpoll_1: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_stwibu: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_stwibu_01: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_stwibu_02: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_totalsoft_poll_stwibu_1: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_usermeta: Data: 3.52MB + Index: 11.06MB + Engine InnoDB
    wpme_users: Data: 0.20MB + Index: 0.27MB + Engine InnoDB
    wpme_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpme_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpme_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wpme_wc_product_meta_lookup: Data: 1.52MB + Index: 1.28MB + Engine InnoDB
    wpme_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_webpages_data: Data: 57.58MB + Index: 2.52MB + Engine InnoDB
    wpme_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpme_wfconfig: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
    wpme_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_wffilemods: Data: 5.52MB + Index: 0.00MB + Engine InnoDB
    wpme_wfhits: Data: 1.52MB + Index: 0.30MB + Engine InnoDB
    wpme_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_wfissues: Data: 0.11MB + Index: 0.06MB + Engine InnoDB
    wpme_wfknownfilelist: Data: 3.52MB + Index: 0.00MB + Engine InnoDB
    wpme_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_wflogins: Data: 0.44MB + Index: 0.16MB + Engine InnoDB
    wpme_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wpme_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wpme_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wpme_wfstatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
    wpme_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wpme_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

    ### Post Type Counts ###

    attachment: 1788
    bws-admin_page: 2
    custom_css: 2
    customize_changeset: 14
    espresso_attendees: 2735
    espresso_events: 1176
    espresso_venues: 1
    gplp: 11985
    nav_menu_item: 74
    nectar_slider: 12
    news: 2
    oembed_cache: 1
    page: 77
    polylang_mo: 1
    popup: 2
    popup_theme: 6
    portfolio: 174
    post: 31
    product: 667
    product_variation: 3165
    revision: 3357
    shop_coupon: 123
    shop_order: 14289
    shop_order_refund: 242
    tablepress_table: 2
    ticket-meta-fieldset: 1
    tribe_events: 6
    tribe_organizer: 1
    tribe_tpp_orders: 467
    tribe_venue: 1
    tribe_wooticket: 9
    yith-wcbm-badge: 4

    ### Security ###

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

    ### Active Plugins (57) ###

    Gravity Perks: by Gravity Wiz – 2.1.9
    Gravity Forms: by Gravity Forms – 2.5.16
    Activity Log: by Activity Log Team – 2.8.2
    Classic Editor: by WordPress Contributors – 1.6.2
    Code Snippets: by Code Snippets Pro – 2.14.3
    Custom Checkout Fields for WooCommerce Pro: by Algoritmika Ltd – 1.5.1
    Disable WooCommerce Admin: by – 1.0
    Disable XML-RPC Pingback: by Samuel Aguilera – 1.2.2
    Disable Admin Notification of User Password Change: by –
    Duplicate Page: by mndpsingh287 – 4.4
    Event Espresso – Calendar (EE 4.3+): by Event Espresso – 3.2.13.p
    Event Espresso – Attendee Mover (EE4.9.13+): by Event Espresso – 1.0.5.p
    Event Espresso – Automated Upcoming Event Notification (EE 4.9.44+): by Event Espresso – 1.0.3.p
    Event Espresso – Events Table View Template (EE 4.4.9+): by Event Espresso – 1.3.9.p
    Event Espresso – MailChimp (EE4.4.5+): by Event Espresso – 2.4.5.p
    Event Espresso – MER – Multi Event Registration (EE 4.7.0+): by Event Espresso – 2.0.18.p
    Event Espresso – Promotions (EE 4.9.10+): by Event Espresso – 1.0.15.p
    Event Espresso – Wait Lists (EE4.9+): by Event Espresso – 1.0.2.p
    Event Espresso – Secure Submit Payment Method (EE 4.x+): by OwN-3m-All – 1.0.0
    Event Espresso: by Event Espresso – 4.10.8.p
    reCaptcha by BestWebSoft: by BestWebSoft – 1.66
    GP Live Preview: by Gravity Wiz – 1.4.3
    GP Multi-page Navigation: by Gravity Wiz – 1.0.7
    Gravity Forms ActiveCampaign Add-On: by Gravity Forms – 1.9
    Gravity Forms iContact Add-On: by Gravity Forms – 1.5
    Gravity Forms PayPal Standard Add-On: by Gravity Forms – 3.5
    GP Copy Cat: by Gravity Wiz – 1.4.24
    GP Terms of Service: by Gravity Wiz – 1.3.14
    Head and Footer Scripts Inserter: by Space X-Chimp – 4.52
    Heartland Secure Submit Addon for Gravity Forms: by SecureSubmit – 1.4.5
    Hide WooCommerce Categories On Shop Page: by Matix Web Designers – 1.1.0
    Index WP MySQL For Speed: by Oliver Jones
    Rick James – 1.4.2

    Salient WPBakery Page Builder: by Michael M – WPBakery.com | Modified by ThemeNectar – 5.5.2
    New Order Notification for Woocommerce: by Mr.Ebabi – 1.4.0
    Poll: by totalsoft – 1.6.2
    Product Open Pricing (Name Your Price) for WooCommerce: by WP Wham – 1.6.0
    Security Code / Captcha for WooCommerce Checkout: by Eric Arnol-Martin – 1.0
    TablePress: by Tobias Bäthge – 1.14
    Username Changer: by Widgit Team – 3.2.2
    VC Restaurant Menu: by DB-Dzine – 1.0.5
    W3 Total Cache: by BoldGrid – 2.2.1
    Delivery Date & Time for WooCommerce: by CodeRockz – 1.2.16
    Woo Donations: by Geek Web Solution – 1.5
    Extra Product Options (Product Addons) for WooCommerce: by ThemeHigh – 3.0.2
    Phone Validator for WooCommerce: by Precious Omonzejele (CodeXplorer 🤾🏽‍♂️🥞🦜🤡) – 1.3.0
    WPC Product Bundles for WooCommerce (Premium): by WPClever – 6.0.4
    WooCommerce Schedule Stock Manager: by Geek Code Lab – 1.7
    WooCommerce Bulk Stock Management: by WooCommerce – 2.2.24
    WooCommerce PDF Invoices: by Bas Elbers – 3.0.11
    WooCommerce Pre-Orders: by WooCommerce – 1.5.24
    WooCommerce SecureSubmit Gateway: by SecureSubmit – 1.12.2
    WooCommerce: by Automattic – 5.1.0 (update to version 6.1.1 is available)
    WP File Manager: by mndpsingh287 – 7.1.3
    Smush: by WPMU DEV – 3.9.5
    WPS Menu Exporter: by WPServeur
    NicolasKulka
    wpformation
    benoti – 1.3.3

    Smart Coupons for WooCommerce: by WebToffee – 1.3.6
    YITH WooCommerce Badge Management: by YITH – 2.1.0

    ### Inactive Plugins (33) ###

    Anti-Malware Security and Brute-Force Firewall: by Eli Scheetz – 4.20.94
    Custom Checkout Fields for WooCommerce: by Algoritmika Ltd – 1.5.1
    Event Espresso: by Event Espresso – 3.1.37.14.P
    Event Espresso – Calendar: by Event Espresso – 2.2.7.p
    Event Espresso – MailChimp Integration: by – 1.2
    Event Espresso – Members Addon: by Event Espresso – 1.9.8.p
    Event Espresso – Multi Event Registration: by Seth Shoultes – 1.0.5.p
    Event Espresso – Permissions: by Event Espresso – 1.5.5.p
    Event Espresso – Recurring Events: by Event Espresso – 1.1.8.p
    Event Espresso – Social Coupons: by Seth Shoultes – 1.5.4.p
    Event Espresso – Ticketing: by Event Espresso – 2.2.0.p
    Event Espresso – Voucher Import: by Event Espresso – 0.1
    Event Espresso API Plugin: by Event Espresso
    (Mike Nelson) – 2.1.4.P

    Event Espresso Volume Discounts: by Seth Shoultes – 0.5.1
    Event Tickets: by Modern Tribe
    Inc. – 4.12.3

    Event Tickets Plus: by Modern Tribe
    Inc. – 4.12.3

    Google Reviews Business: by RichPlugins <support@richplugins.com> – 1.4.1
    GP Preview Submission: by Gravity Wiz – 1.3.1
    Gravity Forms PayPal Payments Pro Add-On: by rocketgenius – 2.3
    Image Widget Plus: by Modern Tribe
    Inc. – 1.0.2

    Notification for WooCommerce: by Andy Ha (villatheme.com) – 1.2.3.7
    Popup Maker: by Popup Maker – 1.16.1
    PW WooCommerce Bulk Edit: by Pimwick
    LLC – 2.88

    Query Monitor: by John Blackbourn – 3.8.2
    Salient WPBakery Page Builder: by Michael M – WPBakery.com | Modified by ThemeNectar – 6.2.0
    ShortPixel Image Optimizer: by ShortPixel – 4.22.0
    Simple News: by Morten Andersen – 2.6
    The Events Calendar: by Modern Tribe
    Inc. – 5.1.5

    The Events Calendar: Filter Bar: by Modern Tribe
    Inc. – 4.10.1

    The Events Calendar PRO: by Modern Tribe
    Inc. – 5.1.4

    Wordfence Security: by Wordfence – 7.5.7
    WP-Optimize – Clean, Compress, Cache: by David Anderson
    Ruhani Rabin
    Team Updraft – 3.1.9

    WP Super Cache: by Automattic – 1.7.3

    ### Dropin Plugins (3) ###

    advanced-cache.php: advanced-cache.php
    db.php: db.php
    object-cache.php: object-cache.php

    ### Settings ###

    API Enabled: –
    Force SSL: –
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: event (event)
    external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    woosb (woosb)

    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: #351 – /shop/
    Cart: #565 – /cart/
    Checkout: #567 – /checkout/
    My account: #569 – /my-account/
    Terms and conditions: #135 – /policies/

    ### Theme ###

    Name: Salient Child Theme
    Version: 0.1
    Author URL: http:%20//mysite.com/
    Child Theme: ✔
    Parent Theme Name: Salient
    Parent Theme Version: 9.0.1
    Parent Theme Author URL: https://themeforest.net/user/themenectar
    WooCommerce Support: ✔

    ### Templates ###

    Overrides: salient/woocommerce/checkout/form-checkout.php version 2.3.0 is out of date. The core version is 3.5.0
    salient/woocommerce/checkout/review-order.php version 3.3.0 is out of date. The core version is 3.8.0
    salient/woocommerce/checkout/terms.php
    salient-child/woocommerce/checkout/thankyou.php version 3.2.0 is out of date. The core version is 3.7.0
    salient/woocommerce/content-product.php version 3.4.0 is out of date. The core version is 3.6.0
    salient/woocommerce/content-single-product.php version 3.4.0 is out of date. The core version is 3.6.0
    salient/woocommerce/loop/add-to-cart.php
    salient/woocommerce/loop/loop-start.php
    salient/woocommerce/myaccount/form-login.php version 3.4.0 is out of date. The core version is 4.1.0
    salient/woocommerce/single-product/product-image.php version 3.3.2 is out of date. The core version is 3.5.1
    salient/woocommerce/single-product/tabs/description.php
    salient/woocommerce/single-product/tabs/tabs.php version 2.4.0 is out of date. The core version is 3.8.0

    Outdated Templates: ❌

    Learn how to update

    ### Product Open Pricing Settings ###

    Product Open Pricing (Name Your Price): yes
    Frontend template: Set Desired Amount %open_price_input% %currency_symbol%
    Input field position: woocommerce_before_add_to_cart_button
    Position priority.: 9999
    Hide price: yes
    Disable quantity selector: yes
    Display on loop: no
    Frontend loop template: Set Desired Amount %open_price_input% %currency_symbol%
    Input field loop position: woocommerce_after_shop_loop_item
    Position priority.: 9
    Hide price: yes
    Input style: width:75px;text-align:center;
    Input pattern:
    Enable step ticker: yes
    Price step: 25
    Force number of decimals: no
    Number of decimals.: 2
    Add To Cart button text:
    Message on empty price: Price is required!
    Message on price too low: Price is too low!
    Message on price too high: Price is too high!
    Add “Open Pricing” column: no
    Fix mini cart: no

    ### Action Scheduler ###

    Complete: 3,287
    Oldest: 2021-12-26 11:42:48 -0700
    Newest: 2022-01-26 09:05:58 -0700

    Failed: 2
    Oldest: 2020-03-17 11:08:39 -0600
    Newest: 2020-03-17 11:08:39 -0600

    ### Status report information ###

    Generated at: 2022-01-26 09:35:45 -07:00

    In our test environment, I updated everything as much as I could and disabled plugins, and while that did lower the query count some, the CPU usage from php-fpm is still rather high. I’d really like to lower the CPU usage if possible.

    Thread Starter own3mall

    (@own3mall)

    Also, when loading the main page for Products available through WooCommerce via the Admin area, WooCommerce is responsible for another 753 queries:

    https://serv1.dragndropz.com/user_images/2022_01_25/4239_0BXKBV_woocommerce_admin_main_products_screen.png

    The time it took to run those queries didn’t take long (.21 seconds according to the monitor), but the sheer number of queries is concerning. Those 753 queries put immense load on my CPUs.

    So, what’s the reason for WooCommerce having to make so many calls to the database to load one page?

    • This reply was modified 4 years, 3 months ago by own3mall.
    Thread Starter own3mall

    (@own3mall)

    So for fun, in our test environment, I updated as many plugins as I could, and I updated the Salient themes. The results:

    NO CHANGE IN PERFORMANCE

    Are you telling me that it’s normal for WooCommerce to make 420 select MySQL queries just to load items in a product category? Here’s a screenshot:

    https://serv1.dragndropz.com/user_images/2022_01_25/4238_XU5i0p_woocommerce_420_select_statements_to_display_products_in_a_category.jpg

    Also, the page you linked for optimizing WooCommerce is not realistic. Shared hosting is plenty powerful for almost any website except for when the software in-use is inefficient, as is the case with WooCommerce. A CDN isn’t needed to offload your images. Most of the recommendations are not realistic and are trying to deflect attention from the real problem of WooCommerce not being efficient software.

    • This reply was modified 4 years, 3 months ago by own3mall.
    Thread Starter own3mall

    (@own3mall)

    https://github.com/own3mall/index-wp-mysql-for-speed

    I converted it to be PHP 7.0.x Compatible.

    However, this plugin did nothing to speed up the database or its expensive WooCommerce / Event Espresso database calls.

    I don’t believe creating keyed indexes increases speed? Nor converting tables to InnoDB? Did you actually see performance increases from these changes?

    Thread Starter own3mall

    (@own3mall)

    Sorry, I was wrong. I went through the code further, and it actually does break it down by item. It looks like we just need to add the donation product as an excluded item on each coupon we create rather than exclude it from coupons globally.

    Is that right?

    Thanks again!

    Thread Starter own3mall

    (@own3mall)

    Ok, well it looks like you can get custom checkout fields in the “order” group to sort if you sort the fields manually in code using a custom sort function.

    It would be nice if these sections would sort themselves automatically based on a priority attribute like they do in the billing and shipping sections.

    Thread Starter own3mall

    (@own3mall)

    It is a WooCommerce issue if that section doesn’t implement priority like the other WooCommerce sections do. It looks like you can position things near “order notes” doing things like:

    } elseif( $position == &quot;before_notes&quot; ) {
                $this->loader->add_action( 'woocommerce_before_order_notes', $plugin_public, 'coderockz_woo_delivery_add_custom_field' );
            } elseif( $position == &quot;after_notes&quot; ) {
                $this->loader->add_action( 'woocommerce_after_order_notes', $plugin_public, 'coderockz_woo_delivery_add_custom_field' );
            }

    However, the “order” group should also use a priority system to make it easier to order additional fields like in other groups like “billing”.

    It’s definitely a WooCommerce issue for not being consistent with its other sections. It has nothing to do with the plugin. If priority is not respected in the “order” group, is there another way to sort custom fields in this area without having to hook into the woocoomerce_after_order_notes or woocoomerce_before_order_notes hooks?

    • This reply was modified 5 years, 9 months ago by own3mall.
    Thread Starter own3mall

    (@own3mall)

    That’s really poor database design. Product variations are products. They should be linked in the database the same way products are so that their product category information is easily accessible.

    Thread Starter own3mall

    (@own3mall)

    Again, WordFence isn’t finding any modified files. So, reinstalling everything from “valid” source repos would do me no good.

    Thread Starter own3mall

    (@own3mall)

    I’d rather pinpoint the problem and fix it while giving you guys information on how they’re hacking this if possible.

    Thread Starter own3mall

    (@own3mall)

    The broken IN SQL is coming from these lines of code (in wp-includes/class-wp-term-query.php):

    $clauses = apply_filters( 'terms_clauses', compact( 'fields', 'join', 'where', 'distinct', 'orderby', 'order', 'limits' ), $taxonomies, $args );
    
    		$fields   = isset( $clauses['fields'] ) ? $clauses['fields'] : '';
    		$join     = isset( $clauses['join'] ) ? $clauses['join'] : '';
    		$where    = isset( $clauses['where'] ) ? $clauses['where'] : '';
    		$distinct = isset( $clauses['distinct'] ) ? $clauses['distinct'] : '';
    		$orderby  = isset( $clauses['orderby'] ) ? $clauses['orderby'] : '';
    		$order    = isset( $clauses['order'] ) ? $clauses['order'] : '';
    		$limits   = isset( $clauses['limits'] ) ? $clauses['limits'] : '';

    So, how does the $clauses variable get populated? Would that be pulling something from the database?

    Thread Starter own3mall

    (@own3mall)

    OK, more digging, and someone is able to create posts without being logged in, create categories without being logged in, and more. How is this possible? I also ran this command to find recently modified files since these issues occurred, and I’m not finding anything!

    
    find $1 -type f -exec stat --format '%Y :%y %n' "{}" \; | sort -nr | cut -d: -f2- | head
    

    They’re sending a POST request to the main index page to accomplish this. Using tcpdump to capture the packets, but how are their posts being hidden from the posts screen?

    • This reply was modified 6 years ago by own3mall.
    Thread Starter own3mall

    (@own3mall)

    I already have…

    grep -r "NOT IN" .

    in the httpdocs directory

    Doesn’t show me much other than the base core code!

Viewing 15 replies - 1 through 15 (of 46 total)