Hallo,
in my shop I'm using:
joomla 3.6.2
virtuemart 3.0.16
About 36000 products are in my shop.
In virtuemart-backend, whenever trying to search for a product I receive an error 1104:
"The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `#__virtuemart_products` as p INNER JOIN `#__virtuemart_products_en_gb` as l using (`virtuemart_product_id`) LEFT JOIN `#__virtuemart_product_categories` as pc ON p.`virtuem ..."
Does anybody have a suggestion, how to fix this?
Thanks in advance.
I think, it's a SQL limited by your hosting plan.
Thank you, I will check this with my provider.