Desperate Help Needed

[Guest]

Hi all

 

I get the following error

 

1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

 

It happens when I use the search function and on the new product module (that I've found so far anyway)

This store is live and I could do with a quick fix - I am not a PHP or database expert so please be gentle with your answers.

 

Any help appreciated.

 

Thanks Rob

[Jan Zonjee]

I get the following error

 

1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

Check this post for a resolution.