Henry

tried to deactive the plugin and reactive it, but no luck.

Please help. thanks

This will be much faster.

SELECT?n.comment_approved,?COUNT(?*?)?AS?total?FROM?wp_comments?AS?n?LEFT?JOIN?wp_posts?AS?m?ON?n.comment_post_ID?=?m.ID?WHERE?(?n.comment_type?NOT?IN?(?‘cr_qna’?)?AND?(m.post_type?=?‘product’?)?)?GROUP?BY?n.comment_approved;

Here is the screen shot

https://imgtr.ee/image/2023-10-24-07-14-37.IIUEXW

I got more details for the slow query. As shown in the following SQL query, too many post types are included when getting comments? Is there a way to exclude post type, e.g. shop_coupon, when query for comments?

SELECT wp_comments.comment_ID FROM wp_comments JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID LEFT JOIN wp_posts AS wp_posts_to_exclude_reviews ON comment_post_ID = wp_posts_to_exclude_reviews.ID WHERE ( ( comment_approved = ‘0’ OR comment_approved = ‘1’ ) ) AND wp_posts.post_type IN (‘post’,’page’,‘attachment’,’revision’,’nav_menu_item’,’custom_css’,’customize_changeset’,’oembed_cache’,’user_request’,’wp_block’,’wp_template’,’wp_template_part’,’wp_global_styles’,’wp_navigation’,’product_variation’,’shop_order’,’shop_order_refund’,’shop_coupon’,’shop_order_placehold’) AND comment_type != ‘order_note’ AND comment_type != ‘webhook_delivery’ AND wp_posts_to_exclude_reviews.post_type NOT IN (‘product’) ORDER BY wp_comments.comment_date_gmt DESC LIMIT 0,58

Thank you for your reply, yes, you are correct. It works correcly on production wesbite, and the problem only happens to testing website, so maybe some plugin on testing website are causing the issue.

Yes, we tracked this using Query Monitor. This leads to a 403 error at the end.

Hi there， any update on this issue. Thanks.

Great, problem sovled.

we got the same issue. We are using the latest version of DE post plugin and woocommerce.

Please take a look at this issue.

And for the duplicated label, where could I deleted it? I can not find the refund feature on the backend of WordPress, and I can not see any label, created by this plugin, on DE post webiste.

Henry

I got the same question.

So far on the backend, I only see Warenpost National, nothing related to Warenpost International.

Could you please let us know if it is possible now or is there any plan to support this soon?

Thank you

that is really quick response, thank you.
I reinstalled and got the same error, line number changed to 334.

Fatal error: Uncaught Error: Call to undefined method Redux_Helpers::strtolower() in wp-content/plugins/redux-framework/redux-core/class-redux-core.php:334 Stack trace: #0 [internal function]: Redux_Core->register_classes(‘ReduxAppsero\\Cl…’) #1 [internal function]: spl_autoload_call(‘ReduxAppsero\\Cl…’) #2 wp-content/plugins/redux-framework/redux-core/class-redux-core.php(185): class_exists(‘ReduxAppsero\\Cl…’) #3 wp-content/plugins/redux-framework/redux-core/class-redux-core.php(170): Redux_Core->init() #4 wp-content/plugins/redux-framework/redux-core/framework.php(28): Redux_Core::instance() #5 wp-content/plugins/redux-framework/class-redux-framework-plugin.php(149): require_once(‘/homepages/9/d8…’) #6 /homepages/9/d810412643/htdocs/clickandbuild in wp-content/plugins/redux-framework/redux-core/class-redux-core.php on line 334