Knowledge Base Troubleshooting I'm getting the MySQL Error: 1104 - The...

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

Author Bill Brewer
Created 09-16-2019 02:33 pm
Last Modified 09-16-2019 02:33 pm
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;

Was this article helpful?

Yes
No

Still Have Questions?

Let Us Help You

My Account