head84

For anyone interested, i solved by temporarely disabling the option “Optimize back end product searches” in the WooCommerce Product Search extension. By disabling this you should manage to create the pricing rules. Once created, you can re-enable the option. It will work fine. Thanks Alex.

Hi, eventually I created an offline mirror site and found out the plugin that causes the issue. It is an official WooCommerce extension called “WooCommerce Product Search”. When I disable it, the search in your plugin works fine. Do you think you will be able to fix this compatibility issue in a short time?

https://woocommerce.com/it/products/woocommerce-product-search/

I cannot do this. I will try other pricing rules plugins. Thank you anyways.

• This reply was modified 2 months ago by head84.

Hi, the 500 error persists even setting the “Show first X results in autocomplete” to 1. The product I want to select has no variation, but there is another product with similar name that has 5 or 6 variation. Anyways, the 500 problem occurs regardless of the keyword I search for. Thank you

Hi, to answer your questions:

1) The product search in the “Product filter” gives results after a long time (about 2 minutes) but they are not related to the keyword I type. Seems like it gives the same results regardless of the search term. See screenshot here: https://ibb.co/tLNTbG8

2) I tried it a few times now and it takes about 125 seconds, then I get the error.

3) Please see configuration screenshot here: https://ibb.co/rZTX8kV

I look forward for your support. Thanks.

Update: Since the SKU filter seems to work fine in the “Product filter” module, I also tried adding my product in the “Product filter” module and selecting the “Use product from filter” option in the “Free product” module, but the rule seems not to work properly. No item is added to the cart.

I look forward for your help. Thanks.

Hi, I confirm I have the problem just with the product search included in the “Free product” mode. No error with the categories or other filters. I configured the wp_debug_log but nothing seems to be recorded when the error occurs. I think the cause could be the huge product database I have. Maybe the search times out? Could you please suggest some way to troubleshoot? Thanks.

I checked cPanel for the error log but there are no recent errors logged. Yours is actually the last plugin I installed. Could you please suggest other ways to troubleshoot? Is there any other method to add the products to the rule? Thanks

• This reply was modified 2 months ago by head84.

I cannot see any fatal-errors log in the WooCommerce>Status>Logs section. What can I do? Thanks.

Hi Alex, thanks for your help.

I was able to check the JS error generated after the product search attempt:

POST https://www.***.***/wp-admin/admin-ajax.php 500 (Internal Server Error)

send @ load-scripts.php?c=1&load%5Bchunk_0%5D=jquery-core,jquery-migrate,jquery-ui-core,jquery-ui-mouse,jquery-ui-sortable,wp-hooks&ver=6.6.2:2
ajax @ load-scripts.php?c=1&load%5Bchunk_0%5D=jquery-core,jquery-migrate,jquery-ui-core,jquery-ui-mouse,jquery-ui-sortable,wp-hooks&ver=6.6.2:2
(anonymous) @ load-scripts.php?c=1&load%5Bchunk_0%5D=jquery-core,jquery-migrate,jquery-ui-core,jquery-ui-mouse,jquery-ui-sortable,wp-hooks&ver=6.6.2:5
e. @ load-scripts.php?c=1&load%5Bchunk_0%5D=jquery-core,jquery-migrate,jquery-ui-core,jquery-ui-mouse,jquery-ui-sortable,wp-hooks&ver=6.6.2:5
transport @ select2.full.min.js?ver=4.0.3:2
e @ select2.full.min.js?ver=4.0.3:2
setTimeout
n.query @ select2.full.min.js?ver=4.0.3:2
e.query @ select2.full.min.js?ver=4.0.3:2
(anonymous) @ select2.full.min.js?ver=4.0.3:2
(anonymous) @ select2.full.min.js?ver=4.0.3:2
e.invoke @ select2.full.min.js?ver=4.0.3:2
e.trigger @ select2.full.min.js?ver=4.0.3:2
d.trigger @ select2.full.min.js?ver=4.0.3:2
(anonymous) @ select2.full.min.js?ver=4.0.3:2
e.invoke @ select2.full.min.js?ver=4.0.3:2
e.trigger @ select2.full.min.js?ver=4.0.3:2
e.handleSearch @ select2.full.min.js?ver=4.0.3:2
(anonymous) @ select2.full.min.js?ver=4.0.3:2
(anonymous) @ select2.full.min.js?ver=4.0.3:2
dispatch @ load-scripts.php?c=1&load%5Bchunk_0%5D=jquery-core,jquery-migrate,jquery-ui-core,jquery-ui-mouse,jquery-ui-sortable,wp-hooks&ver=6.6.2:2
v.handle @ load-scripts.php?c=1&load%5Bchunk_0%5D=jquery-core,jquery-migrate,jquery-ui-core,jquery-ui-mouse,jquery-ui-sortable,wp-hooks&ver=6.6.2:2

How can I solve? Thanks for your help.

Hi @khungate, I reached out to my hosting provider. Migrating the website to another server solved the issue. Thank you!

Hi @khungate, as I stated above the WP CRON is enabled. I also tried deactivating it, but in both cases the problem is still there.

In fact, I’m still unable to resolve. Please tell me which log files you need. Thank you.

Hello @khungate, the WP CRON is active. I just tried disabling the WP CRON using the “define(‘DISABLE_WP_CRON’, true);” command in the wpconfig file, and the problem is still there. Could you please provide a solution? Thanks

• This reply was modified 2 years, 5 months ago by head84.

Hi Gabriel, thank you for getting back to me.

After doing some more testing I realized this is the function causing my issues:

$fields = $checkout->get_checkout_fields();

The problem is not limited to the taxes tables; I’m facing different kind of issues in the admin side. Could you please give me some advice?

Hi there,

The problem is still there. I’m using the latest version (1.8.5). Dilas solution is working for me, but a stable solution will be much appreciated.

Thank you