Indexing Problems

Hi Guys,

I am having great difficulty with your plugin as the index builder is taking a very long time to complete, this then results in my site crashing and no sales coming through. We are hosted with Kinsta and they supplied me with the following info.

______________________________________________________________________________________

There is a coding error inside the plugin Ajax Search for WooCommerce, found this in the logs:
?
?
2021/08/12 05:53:45 [error] 49877#49877: *322107 FastCGI sent in stderr: "PHP message: PHP Warning: strpos(): Empty needle in /www/livestainable_118/public/wp-content/plugins/ajax-search-for-woocommerce-premium/includes/Engines/WordPressNative/Search.php on line 453PHP message: PHP Warning: strpos(): Empty needle in /www/livestainable_118/public/wp-content/plugins/ajax-search-for-woocommerce-premium/includes/Engines/WordPressNative/Search.php on line 508PHP message: PHP Fatal error: Allowed memory size of 805306368 bytes exhausted (tried to allocate 20480 bytes) in /www/livestainable_118/public/wp-includes/wp-db.php on line 2022" while reading response header from upstream, client: 34.89.108.54, server: livestainable.co.za, request: "GET /?wc-ajax=dgwt_wcas_ajax_search&s HTTP/1.0", upstream: "fastcgi://unix:/var/run/php7.4-fpm-livestainable.sock:", host: "www.livestainable.co.za", referrer: "https://www.livestainable.co.za/?wc-ajax=dgwt_wcas_ajax_search&s"
This leads to the PHP Worker maxed out:
?
?[12-Aug-2021 05:52:37] WARNING: [pool livestainable] server reached max_children setting (4), consider raising it
You need to pay attention to PHP Worker as these are the ones who process the PHP request, stalling it will cause issues to your website.
We have an article about PHP Worker here:
?https://kinsta.com/blog/php-workers/

_________________________________________________________________________
Its pointed in the error logs as shown here:
?
? PHP Warning: strpos(): Empty needle in /www/livestainable_118/public/wp-content/plugins/ajax-search-for-woocommerce-premium/includes/Engines/WordPressNative/Search.php on line 508

________________________________________________________________________

There seems to be an issue with some kind of code from within the plugin causing the site to hit PHP worker limits. That results in the site crashing.

___________________________________________________________________________

You plugin did provide us with the following troubleshooting message from within the troubleshooter.:

Some NGINX configuration may block executing PHP files included directly in the plugins directory. There is no one solution. It depends on your NGINX configuration. We recommend contact your hosting provider and ask to allow to execute the following file: https://www.livestainable.co.za/wp-content/plugins/ajax-search-for-woocommerce-premium/includes/Engines/TNTSearchMySQL/Endpoints/search.php

Here are few samples NGINX config which helps other users:

Adding extra rules to /usr/local/nginx/conf/wpsecure_${vhostname}.conf
# Whitelist Exception for FiboSearch endpoint
location ~ ^/wp-content/plugins/ajax-search-for-woocommerce-premium/includes/Engines/TNTSearchMySQL/Endpoints/ {
  include /usr/local/nginx/conf/php.conf;
}

To which our host responded the following, :

The solution provided isn’t applicable with the setup we have – the path mentioned to be included doesn’t exist. Also – we don’t have any restrictions for file execution inside the plugin.

______________________________________________________________________

No I ask you to please help us, we have been having issues in terms of site performance with your plugin for a while now.

The page I need help with: [log in to see the link]