weixin_39600331
weixin_39600331
2020-12-28 20:18

comment count / pending / trash incorrect - _transient_as_comment_count

Please provide us with the information requested in this bug report. Without these details, we won't be able to fully evaluate this issue. Bug reports lacking detail, or for any other reason than to report a bug, may be closed without action.

Prerequisites (mark completed items with an [x]): - [ x] I have have carried out troubleshooting steps and I believe I have found a bug. - [ x] I have searched for similar bugs in both open and closed issues and cannot find a duplicate. - closed issue found

Describe the bug We are finding our Pending, spam and trash comment count in admin isnt updating and will often stick with some saying they are in trash but then there is nothing there. when i disable woocommerce the proper count returns.

I found me manually clearing the transient _transient_as_comment_count helped clear the issue straight away

Expected behavior correct counts show

Actual behavior Showing comments as in trash when i have emptied. same as still showing pending count when i have already approved

Steps to reproduce the bug (We need to be able to reproduce the bug in order to fix it.) Steps to reproduce the bug: 1. Go to Comments 2. View Comment Count 3. delete another comment and empty trash see comment count still showing

Screenshots

Isolating the problem (mark completed items with an [x]): - [x ] I have deactivated other plugins and confirmed this bug occurs when only WooCommerce plugin is active. - [x ] This bug happens with a default WordPress theme active, or Storefront. - [x ] I can reproduce this bug consistently using the steps above.

WordPress Environment We use the WooCommerce System Status Report to help us evaluate the issue. Without this report we won't be able to fully evaluate this issue.

` ### WordPress Environment ### WordPress address (URL): https://xxxx Site address (URL): https://xxxx WC Version: 4.3.0 REST API Version: ✔ 1.0.10 WC Blocks Version: ✔ 2.7.1 Action Scheduler Version: ✔ 3.1.6 WC Admin Version: ✔ 1.3.0 Log Directory Writable: ✔ WP Version: 5.4.2 WP Multisite: – WP Memory Limit: 2 GB WP Debug Mode: ✔ WP Cron: ✔ Language: en_US External object cache: – ### Server Environment ### Server Info: LiteSpeed PHP Version: 7.3.19 PHP Post Max Size: 800 MB PHP Time Limit: 1800 PHP Max Input Vars: 10000 cURL Version: 7.70.0 OpenSSL/1.1.1g SUHOSIN Installed: – MySQL Version: 5.5.5-10.3.23-MariaDB-log Max Upload Size: 512 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 4.3.0 WC Database Prefix: mystic_ Total Database Size: 2518.49MB Database Data Size: 1536.81MB Database Index Size: 981.68MB mystic_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB mystic_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_woocommerce_downloadable_product_permissions: Data: 4.52MB + Index: 8.06MB + Engine InnoDB mystic_woocommerce_order_items: Data: 15.52MB + Index: 5.52MB + Engine InnoDB mystic_woocommerce_order_itemmeta: Data: 193.72MB + Index: 118.25MB + Engine InnoDB mystic_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB mystic_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB mystic_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB mystic_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_woocommerce_payment_tokens: Data: 1.52MB + Index: 0.19MB + Engine InnoDB mystic_woocommerce_payment_tokenmeta: Data: 2.52MB + Index: 3.03MB + Engine InnoDB mystic_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_actionscheduler_actions: Data: 2.24MB + Index: 0.66MB + Engine MyISAM mystic_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM mystic_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM mystic_actionscheduler_logs: Data: 1.55MB + Index: 0.75MB + Engine MyISAM mystic_addonlibrary_addons: Data: 0.08MB + Index: 0.00MB + Engine InnoDB mystic_addonlibrary_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_aelia_dismissed_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_affiliate_wp_affiliatemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB mystic_affiliate_wp_creatives: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_affiliate_wp_referrals: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_alpha_mystic: Data: 0.19MB + Index: 0.01MB + Engine MyISAM mystic_as3cf_items: Data: 2.38MB + Index: 3.08MB + Engine MyISAM mystic_auditlog: Data: 17.55MB + Index: 5.03MB + Engine InnoDB mystic_automatewoo_abandoned_carts: Data: 0.13MB + Index: 0.08MB + Engine InnoDB mystic_automatewoo_customers: Data: 2.52MB + Index: 3.66MB + Engine InnoDB mystic_automatewoo_customer_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB mystic_automatewoo_events: Data: 0.02MB + Index: 0.05MB + Engine InnoDB mystic_automatewoo_guests: Data: 2.52MB + Index: 3.84MB + Engine InnoDB mystic_automatewoo_guest_meta: Data: 0.09MB + Index: 0.11MB + Engine InnoDB mystic_automatewoo_logs: Data: 4.52MB + Index: 6.55MB + Engine InnoDB mystic_automatewoo_log_meta: Data: 18.55MB + Index: 14.03MB + Engine InnoDB mystic_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB mystic_automatewoo_queue_meta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB mystic_automatewoo_referrals: Data: 0.02MB + Index: 0.08MB + Engine InnoDB mystic_automatewoo_referral_advocate_keys: Data: 0.08MB + Index: 0.05MB + Engine InnoDB mystic_automatewoo_referral_invites: Data: 0.02MB + Index: 0.05MB + Engine InnoDB mystic_automatewoo_unsubscribes: Data: 0.02MB + Index: 0.08MB + Engine InnoDB mystic_blc_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_blc_instances: Data: 4.52MB + Index: 1.16MB + Engine InnoDB mystic_blc_links: Data: 18.52MB + Index: 3.30MB + Engine InnoDB mystic_blc_synch: Data: 22.55MB + Index: 11.52MB + Engine InnoDB mystic_commentmeta: Data: 19.55MB + Index: 13.03MB + Engine InnoDB mystic_comments: Data: 232.75MB + Index: 84.25MB + Engine InnoDB mystic_dologin_failure: Data: 0.02MB + Index: 0.01MB + Engine MyISAM mystic_dologin_pswdless: Data: 0.00MB + Index: 0.00MB + Engine MyISAM mystic_dologin_sms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM mystic_et_social_stats: Data: 0.13MB + Index: 0.00MB + Engine InnoDB mystic_eventscalendar_main: Data: 0.11MB + Index: 0.00MB + Engine InnoDB mystic_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_groups_capability: Data: 0.02MB + Index: 0.03MB + Engine InnoDB mystic_groups_group: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_groups_group_capability: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_groups_user_capability: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_groups_user_group: Data: 0.34MB + Index: 0.22MB + Engine InnoDB mystic_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB mystic_litespeed_avatar: Data: 0.02MB + Index: 0.03MB + Engine MyISAM mystic_litespeed_cssjs: Data: 0.33MB + Index: 0.02MB + Engine MyISAM mystic_litespeed_img_optm: Data: 9.08MB + Index: 4.73MB + Engine MyISAM mystic_litespeed_img_optming: Data: 0.33MB + Index: 0.07MB + Engine MyISAM mystic_litespeed_optimizer: Data: 0.00MB + Index: 0.00MB + Engine MyISAM mystic_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_mailchimp_jobs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM mystic_mc4wp_log: Data: 0.16MB + Index: 0.00MB + Engine InnoDB mystic_mw_subscr_customers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB mystic_mw_subscr_products: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_mystic: Data: 2.52MB + Index: 0.00MB + Engine InnoDB mystic_mywebtonetperfstatsresults: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_mywebtonetqtest: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_options: Data: 9.47MB + Index: 0.34MB + Engine InnoDB mystic_pimwick_affiliate: Data: 0.00MB + Index: 0.01MB + Engine MyISAM mystic_pimwick_gift_card: Data: 0.08MB + Index: 0.05MB + Engine InnoDB mystic_pimwick_gift_card_activity: Data: 0.25MB + Index: 0.05MB + Engine InnoDB mystic_pmxe_exports: Data: 0.33MB + Index: 0.00MB + Engine InnoDB mystic_pmxe_google_cats: Data: 0.38MB + Index: 0.00MB + Engine InnoDB mystic_pmxe_posts: Data: 0.13MB + Index: 0.00MB + Engine InnoDB mystic_pmxe_templates: Data: 0.05MB + Index: 0.00MB + Engine InnoDB mystic_postmeta: Data: 587.98MB + Index: 582.47MB + Engine InnoDB mystic_posts: Data: 81.59MB + Index: 24.13MB + Engine InnoDB mystic_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_redirection_404: Data: 0.06MB + Index: 0.06MB + Engine InnoDB mystic_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB mystic_redirection_items: Data: 1.52MB + Index: 0.58MB + Engine InnoDB mystic_redirection_logs: Data: 0.02MB + Index: 0.08MB + Engine InnoDB mystic_rg_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_rg_form_meta: Data: 0.13MB + Index: 0.00MB + Engine InnoDB mystic_rg_form_view: Data: 2.52MB + Index: 0.45MB + Engine InnoDB mystic_rg_incomplete_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_rg_lead: Data: 1.52MB + Index: 0.14MB + Engine InnoDB mystic_rg_lead_detail: Data: 2.52MB + Index: 2.70MB + Engine InnoDB mystic_rg_lead_detail_long: Data: 2.52MB + Index: 0.00MB + Engine InnoDB mystic_rg_lead_meta: Data: 0.14MB + Index: 0.14MB + Engine InnoDB mystic_rg_lead_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB mystic_sabre_table: Data: 0.02MB + Index: 0.05MB + Engine InnoDB mystic_sgpb_analytics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_sticky: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB mystic_terms: Data: 1.52MB + Index: 0.81MB + Engine InnoDB mystic_term_relationships: Data: 4.52MB + Index: 2.52MB + Engine InnoDB mystic_term_taxonomy: Data: 1.52MB + Index: 1.98MB + Engine InnoDB mystic_tweet_urls: Data: 0.02MB + Index: 0.05MB + Engine InnoDB mystic_usermeta: Data: 165.61MB + Index: 38.11MB + Engine InnoDB mystic_users: Data: 2.52MB + Index: 1.14MB + Engine InnoDB mystic_usin_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_usin_user_data: Data: 1.52MB + Index: 0.30MB + Engine InnoDB mystic_wc_admin_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM mystic_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM mystic_wc_avatars_cache: Data: 1.52MB + Index: 0.55MB + Engine InnoDB mystic_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM mystic_wc_comments_subscription: Data: 0.02MB + Index: 0.06MB + Engine InnoDB mystic_wc_customer_lookup: Data: 1.57MB + Index: 1.09MB + Engine MyISAM mystic_wc_download_log: Data: 12.52MB + Index: 8.03MB + Engine InnoDB mystic_wc_feedback_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM mystic_wc_flagged: Data: 0.02MB + Index: 0.05MB + Engine InnoDB mystic_wc_follow_users: Data: 0.02MB + Index: 0.13MB + Engine InnoDB mystic_wc_order_coupon_lookup: Data: 0.11MB + Index: 0.19MB + Engine MyISAM mystic_wc_order_product_lookup: Data: 11.52MB + Index: 8.18MB + Engine MyISAM mystic_wc_order_stats: Data: 7.71MB + Index: 4.66MB + Engine MyISAM mystic_wc_order_tax_lookup: Data: 2.26MB + Index: 2.39MB + Engine MyISAM mystic_wc_phrases: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB mystic_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM mystic_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_wc_users_rated: Data: 0.00MB + Index: 0.01MB + Engine MyISAM mystic_wc_users_voted: Data: 2.52MB + Index: 3.22MB + Engine InnoDB mystic_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_wfBlockedIPLog: Data: 0.13MB + Index: 0.00MB + Engine InnoDB mystic_wfBlocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB mystic_wfConfig: Data: 0.36MB + Index: 0.00MB + Engine InnoDB mystic_wfCrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_wfFileChanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_wfFileMods: Data: 3.52MB + Index: 0.00MB + Engine InnoDB mystic_wfHits: Data: 1.52MB + Index: 0.23MB + Engine InnoDB mystic_wfHoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_wfIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB mystic_wfKnownFileList: Data: 1.52MB + Index: 0.00MB + Engine InnoDB mystic_wfLiveTrafficHuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_wfLocs: Data: 0.06MB + Index: 0.00MB + Engine InnoDB mystic_wfLogins: Data: 1.52MB + Index: 0.16MB + Engine InnoDB mystic_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB mystic_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_wfNotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_wfPendingIssues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB mystic_wfReverseCache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_wfSNIPCache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB mystic_wfStatus: Data: 0.16MB + Index: 0.09MB + Engine InnoDB mystic_wfTrafficRates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_woocommerce_bundled_itemmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB mystic_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB mystic_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_wpml_mails: Data: 1.52MB + Index: 0.00MB + Engine InnoDB mystic_wpmm_subscribers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_wp_rp_tags: Data: 0.17MB + Index: 0.16MB + Engine InnoDB mystic_yarpp_keyword_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_yarpp_related_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB mystic_yoast_indexable: Data: 17.43MB + Index: 1.91MB + Engine MyISAM mystic_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine MyISAM mystic_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM mystic_yoast_primary_term: Data: 0.08MB + Index: 0.08MB + Engine MyISAM mystic_yoast_seo_links: Data: 3.52MB + Index: 1.52MB + Engine InnoDB mystic_yoast_seo_meta: Data: 14.52MB + Index: 0.00MB + Engine InnoDB _mig_wpmdb_alter_statements: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### acf: 2 acf-field: 42 acf-field-group: 14 alert: 2 astra-advanced-hook: 3 attachment: 8354 aw_workflow: 10 bwl_kb: 38 calendar: 1 custom_css: 2 customize_changeset: 26 dtwpb_product_tpl: 3 horoscope: 10548 horoscopes: 1 jp_img_sitemap: 4 jp_img_sitemap_index: 1 jp_sitemap: 2 jp_sitemap_index: 1 jp_sitemap_master: 1 mm_auto_fields: 7703 nav_menu_item: 32 njt-widget-builder: 1 oembed_cache: 2 oracle: 18 oracle2-posts: 261 page: 125 post: 3608 product: 42 product_variation: 2 revision: 2065 shop_coupon: 85 shop_order: 114751 shop_order_refund: 577 shop_subscription: 3932 single_tarot: 48 tarot: 78 templatera: 12 tinymcetemplates: 2 usin_note: 550 vc_grid_item: 3 vc4_templates: 3 vcv_templates: 9 wc_membership_plan: 10 wc_user_membership: 8547 wcccf: 3 wccpf: 4 wpdiscuz_form: 1 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (64) ### Query Monitor: by John Blackbourn – 3.6.0 MM Current: by Mystic – 1.0.36 MM Alpha Mystic: by Mystic – 1.1.4 MM Media Player: by StarGroup – 1.0.16 MM Moon Calendar: by Mystic – 1.0.31 Oracle 2: by Mystic – 1.8.1 MM Robo Mystic: by Mystic – 1.6.01 Ultimate Addons for WPBakery Page Builder: by Brainstorm Force – 3.19.4 AddToAny Share Buttons: by AddToAny – 1.7.41 Advanced Custom Fields PRO: by Elliot Condon – 5.8.12 Akismet Anti-Spam: by Automattic – 4.1.6 Always Remember Me: by Ozh – 1.0 Astra Pro: by Brainstorm Force – 2.5.1 Astra Widgets: by Brainstorm Force – 1.2.4 AutomateWoo: by WooCommerce – 4.9.7 Templify KB - Knowledge Base Addon: by Md Mahbub Alam Khan – 1.0.8 Black Studio TinyMCE Widget: by Black Studio – 2.6.9 BWL Knowledge Base Manager: by Md Mahbub Alam Khan – 1.3.2 Classic Editor: by WordPress Contributors – 1.5 Custom Fonts: by Brainstorm Force – 1.2.2 Disable Emails: by WebAware – 1.6.3 Epic News Elements: by Jegtheme – 2.2.7 Google XML Sitemaps: by Arne Brachhold – 4.1.0 Health Check & Troubleshooting: by The WordPress.org community – 1.4.4 WPBakery Page Builder: by Michael M - WPBakery.com – 6.2.0 Max Mega Menu - Pro Addon: by megamenu.com – 2.1 Max Mega Menu: by megamenu.com – 2.8 WPBakery Custom Elements Addon: by Ravindra Singh Meyda – 1.0.0 Mystic Oracle: by Bronson Quick – 1.0 Mystic's Tarot Cards: by Bronson Quick – 1.0 NS Widget Recent Comments: by Miodrag Rasic – 1.2 Plugin Single Tarot: by Mystic – 1.0 Redirection: by John Godley – 4.8 Substitute Display Names: by MemberFix – 1.2.0 Category Order and Taxonomy Terms Order: by Nsp-Code – 1.5.7.2 Templatera: by WPBakery – 1.1.12 Transients Manager: by Pippin Williamson – 1.8 Ultimate Widget Builder Pro with Visual Composer: by NinjaTeam – 1.4 Update Comments Count: by Pau Iglesias Blogestudio – 1.0 VC Animated Gradient Background: by Boom-Apps – 1.1 Aelia Foundation Classes for WooCommerce: by Aelia – 2.0.21.200629 Aelia Currency Switcher for WooCommerce: by Aelia – 4.8.11.200524 – Installed version not tested with active version of WooCommerce 4.3.0 WooCommerce Conversion Tracking: by weDevs – 2.0.8 – Installed version not tested with active version of WooCommerce 4.3.0 WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.0.3 WooCommerce Stripe Gateway: by WooCommerce – 4.5.0 – Installed version not tested with active version of WooCommerce 4.3.0 WooCommerce Google Analytics Pro: by SkyVerge – 1.8.14 – Installed version not tested with active version of WooCommerce 4.3.0 WooCommerce Memberships: by SkyVerge – 1.17.5 – Installed version not tested with active version of WooCommerce 4.3.0 WooCommerce My Account Widget: by PEP – 0.6.6 – Installed version not tested with active version of WooCommerce 4.3.0 WooCommerce Product Bundles: by SomewhereWarm – 6.2.5 (update to version 6.3.2 is available) – Installed version not tested with active version of WooCommerce 4.3.0 WooCommerce: by Automattic – 4.3.0 Yoast SEO Premium: by Team Yoast – 14.3 Asset CleanUp: Page Speed Booster: by Gabriel Livan – 1.3.6.5 WP Crontrol: by John Blackbourn & crontributors – 1.8.5 WP File Manager: by mndpsingh287 – 6.5 WP Mail Logging: by MailPoet – 1.9.6 WP Maintenance Mode: by Designmodo – 2.2.4 WP Notifications Manager: by Chad Anderson – 1.1 WP-PageNavi: by Lester 'GaMerZ' Chan – 2.93.3 WP Rocket: by WP Media – 3.6.1 WP-Sweep: by Lester 'GaMerZ' Chan – 1.1.3 wpDiscuz - Embeds: by gVectors Team – 1.0.0 wpDiscuz - Media Uploader: by gVectors Team – 7.0.3 wpDiscuz - Report and Flagging: by gVectors Team – 7.0.0 wpDiscuz: by gVectors Team – 7.0.3 ### Inactive Plugins (23) ### Advanced Access Manager: by Vasyl Martyniuk – 6.6.0 Advanced Random Posts Widget: by Idenovasi – 2.2.0 BackupBuddy: by iThemes – 8.5.7.0 Broken Link Checker: by WPMU DEV – 1.11.13 Delete Expired Transients: by WebAware – 2.0.7 DoLogin Security: by WPDO – 2.8 – Installed version not tested with active version of WooCommerce 4.3.0 GS Posts Widget PRO: by GS Plugins – 2.0.3 Import / Export Customizer Settings: by Brainstorm Force – 1.0.3 jQuery Colorbox: by Arne Franken – 4.6.2 LiteSpeed Cache: by LiteSpeed Technologies – 3.2.4 Monarch Plugin: by Elegant Themes – 1.4.12 Plugins Garbage Collector (Database Cleanup): by Vladimir Garagulya – 0.11.1 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.3 Responsive Lightbox & Gallery: by dFactory – 2.2.3.1 Ultimate Layouts - Responsive Grid – Addon For WPBakery Page Builder: by BeeTeam368 – 3.0.0 Users Insights: by Pexeto – 3.9.0 WooCommerce Page Builder: by DawnThemes – 3.3.8.6 – Installed version not tested with active version of WooCommerce 4.3.0 WooCommerce Product Archive Customiser: by jameskoster – 1.0.5 – Installed version not tested with active version of WooCommerce 4.3.0 Woo Products Require Account: by AndrewRMinion Design – 1.0.2 – Installed version not tested with active version of WooCommerce 4.3.0 Wordfence Security: by Wordfence – 7.4.9 WordPress Importer: by wordpressdotorg – 0.7 WP Offload Media: by Delicious Brains – 2.3.2 WP Session Manager: by Eric Mann – 3.0.4 ### Dropin Plugins (3) ### advanced-cache.php: advanced-cache.php db.php: Query Monitor Database Class maintenance.php: maintenance.php ### Must Use Plugins (1) ### Health Check Troubleshooting Mode: by – 1.7.1 ### Settings ### API Enabled: ✔ Force SSL: ✔ Currency: AUD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: simple (simple) bundle (bundle) grouped (grouped) variable (variable) external (external) Taxonomies: Product Visibility: exclude-from-search (exclude-from-search) exclude-from-catalog (exclude-from-catalog) featured (featured) outofstock (outofstock) rated-4 (rated-4) rated-5 (rated-5) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) Connected to WooCommerce.com: ✔ ### WC Pages ### Shop base: #127684 - /shop/ Cart: #43256 - /cart/ Checkout: #43257 - /checkout/ My account: #43258 - /my-account/ Terms and conditions: ❌ Page not set ### Theme ### Name: Mystic Astra Version: 2.4.31 Child Theme: ✔ Parent Theme Name: Astra Parent Theme Version: 2.4.5 Parent Theme Author URL: https://wpastra.com/about/ WooCommerce Support: ✔ ### Templates ### Overrides: mystic-m/woocommerce/myaccount/navigation.php ### Memberships ### ### Product Bundles ### Database Version: 6.2.5 Template Overrides: – ### Action Scheduler ### Canceled: 24 Oldest: 2020-06-18 00:11:32 +1000 Newest: 2024-04-12 03:11:57 +1000 Complete: 3,316 Oldest: 2020-06-17 04:24:15 +1000 Newest: 2020-07-18 04:06:29 +1000 Failed: 0 Oldest: 2019-11-20 21:23:23 +1100 Newest: 2020-02-13 01:46:19 +1100 Pending: 4,796 Oldest: 2020-07-18 04:19:06 +1000 Newest: 2099-06-21 18:01:13 +1100 `

该提问来源于开源项目:woocommerce/action-scheduler

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

9条回答

  • weixin_39805732 weixin_39805732 4月前

    Hi ,

    Thank you for submitting the issue. However, I can’t reproduce the issue you reported using the steps you provided. Everything is working as expected on my end.

    But since _transient_as_comment_count as part of Action Schedule I'm moving this issue to the correct repository.

    Please provide us with more details about the issue which may help us to evaluate it further. Maybe extra steps to reproduce it.

    Thanks!

    点赞 评论 复制链接分享
  • weixin_39586353 weixin_39586353 4月前

    Hi ,

    So I also cannot reproduce this. Can you please provide any additional information such as how many total counts are showing and how many actual counts?

    Thanks!

    点赞 评论 复制链接分享
  • weixin_39600331 weixin_39600331 4月前

    Heres an example i just emptied comment trash and it still shows as https://www.dropbox.com/s/745rqif5a03zilw/2020-10-23_13-58-02.png?dl=0

    Shows 1 is in there but there isnt

    点赞 评论 复制链接分享
  • weixin_39586353 weixin_39586353 4月前

    Is it a specific comment type you're deleting?

    点赞 评论 复制链接分享
  • weixin_39600331 weixin_39600331 4月前

    Standard post comments

    点赞 评论 复制链接分享
  • weixin_39586353 weixin_39586353 4月前

    Do you have some type of cache on your site either as a plugin or installed on your host?

    点赞 评论 复制链接分享
  • weixin_39600331 weixin_39600331 4月前

    Dedicated server, no server side cache no memcached etc

    Its odd that if i delete that transient it refreshes. The only thing we would have woo/actionsheduler related would be we utilize standard woocommerce reviews (which are just comments for products?)

    But these count anomalies are just standard

    点赞 评论 复制链接分享
  • weixin_39586353 weixin_39586353 4月前

    Ok so you mentioned after deleting the transient it corrects itself. How long after will the problem arise again?

    点赞 评论 复制链接分享
  • weixin_39600331 weixin_39600331 4月前

    seems to be immediate - i have a site in staging i can show f you have somewhere for me to email details?

    点赞 评论 复制链接分享

相关推荐