webstract

[webstract]

Unfortunately this answer will not work for me.

1. We’ve contacted VC and they can assure us it is not their issue
2. We’ve tried using [products] and [product] and this does not work
3. The issue is with [claue_addons_product] and they way the SQL query is programmed
4. We’ve had our IT person verify this by watching MySQL logs

If you are unwilling to fix this issue or help us further then please refund us our money and we will find another company to work with.

[webstract]

After working with our hosting company, the issue seems to be with the code. See here…

The issue looks to be related to the way the query is written.  Specifically, it’s dependence on the sub-query, and the way the wildcard (user input) is being passed, it’s not possible to index the table any further than it already is.

That message was from our hosting provider. When I did another test I waited 80 seconds and finally the query completed.

I don’t want to change to Visual Composer “products” – I want the one that we are currently using to work properly.

[webstract]

How many products your site have?
1671

Did you try with new created product?
Yes, nothing changes.

Are you usually use “product” short code?
Yes, using “[claue_addons_product]” which is packaged with your theme

Could you try cleanup your database and try again?
Yes, I have done that, it did not work

[webstract]

Ok, well what is going to be done to fix this? I’ve paid your product so it will work, and just because I have a lot of products are you unwilling to fix the issue? Please let me know

[webstract]

Nope. Because we actually ONLY deleted media DB entries via the following command:

DELETE FROM wp_posts WHERE post_type = "attachment";
DELETE FROM wp_postmeta WHERE meta_key = "_wp_attached_file";
DELETE FROM wp_postmeta WHERE meta_key = "_wp_attachment_metadata";

Maybe this product finder is searching through media as well and it is crashing this for websites with thousands and thousands of entries

[webstract]

I believe I found the issue. I believe it has to do with the fact that we have so many database entires. As a test, I removed all of our media from a test database. Now it’s working and loading products. However, will all the extra entries it gets bogged down and does not work properly. Can you look at the way this is programmed to see if there is something that can be done to fix this?

[webstract]

I have tried that, replacing jQuery. It did not fix the issue. I reached out to Visual Composer Page Builder support (I paid for their support) and they have informed me they do not see any issue from their end because the “Product” module is a custom module from Claue / JanStudio.

[webstract]

I installed a fresh copy of WordPress, I also re-installed Visual Builder that comes pre-packaged with your theme and it is still not working 🙁

[webstract]

This reply has been marked as private.

[webstract]

I’ve done that and it’s not working still. I left WooCommerce and Page Builder Active

[Author]

Posts