I'm getting the MySQL 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
Created
This error happens when the MySQL indexes are corrupt. To fix this go to Tools -> Database and run the following queries:
OPTIMIZE TABLE gfw_product_attribute_variants;
OPTIMIZE TABLE gfw_product_stock;
OPTIMIZE TABLE gfw_product_prices;
OPTIMIZE TABLE gfw_product_weight;