divijc

Hi, I have over 500,000 contacts that need to be deleted. Any other way to do this without having to delete entire plugin data as doing it in batches of 600 will be excessively time consuming?

Hi, please let me know if any other info is needed regarding this case.

Hi,

Please refer to the follow URL to check the issue. I have added the term “gtag” in include keywords settings in your plugin.

1. On cached page, gtag scripts are not lazyloaded as can be seen here – [ in the link field ]

2. On uncached page, gtag scripts are lazyloaded as can be seen here – [ link in the link field ]/?no-cache

Please check.

• This reply was modified 3 years, 1 month ago by Jan Dembowski.

Disabling author sitemap resolved the issue. On websites with more than 200,000 registered users, the following sql query is very slow:

# Query_time: 61.713477  Lock_time: 0.000199 Rows_sent: 0  Rows_examined: 7029744
use ypdbase;
SET timestamp=1604989790;
SELECT wp_users.* FROM wp_users LEFT JOIN wp_usermeta ON (wp_users.ID = wp_usermeta.user_id AND wp_usermeta.meta_key = '_yoast_wpseo_profile_updated' )  LEFT JOIN wp_usermeta AS mt1 ON ( wp_users.ID = mt1.user_id ) WHERE 1=1 AND ( 
  ( 
    ( 
      wp_usermeta.user_id IS NULL
    ) 
    AND 
    ( mt1.meta_key = 'wp_user_level' AND mt1.meta_value != '0' )
  )
) ORDER BY user_login ASC;

• This reply was modified 4 years ago by divijc.

Hi Stef, I am able to do what the article says but my question was that putting 15000 pincodes slows down the checkout page excessively. How to solve the slowing down issue?

Thanks for your help, have given a 5 star rating for your prompt assistance with the issue.

Hi, I am using Flatsome theme. However, I reverted to the default 2017 theme to test and the same issue is there. Once a product is added to cart, the body stops loading. Only the header loads. I have also shared the login details for my test install via the contact form of your website so that you can test the issue.

Hi, thanks for your reply. I have contacted you via the contact page of your website. I have shared the plugin files so that you can check the issue.

Hi,

The issue seems to be as follows:

Once the order is marked as completed manually or via bulk import, “An automatic review reminder has been scheduled…” note is added in the row under review reminder column. However, after some time (almost 12 hrs), this note is replaced by “No reminders sent”.

1. Almost 600 orders are marked as completed per day on our store, do you have any limit to the number of emails which can be sent which might be causing this issue? If not, then it seems to be an issue with the plugin. Let me know any further details required.

Yes, it did. Have already reviewed your plugin with 5 stars.

Thanks ??

Hi Chetna,

Has the 2nd issue (regarding database size) been resolved? If yes, please provide info regarding this.

UPDATE: Resolved the issue, mb_string was not enabled on my server.

Thanks!

You can probably include this feature in themes where the cart is loaded via Ajax. Most of the themes in the market today load carts via Ajax.