Jump to content

Archived

This topic is now archived and is closed to further replies.

tunetti

Max_Join_Size error

Recommended Posts

I am getting the following error when adding product attributes. Have entered many with no issues.

 

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

Share this post


Link to post
Share on other sites

It's telling you that your database tables have grown to the point that they're too big for the server to handle. You will need to talk to your hosting tech support to find out how to increase the setting(s) for allowing larger table operations. If you're on a free or super-cheap host, they may not let you use larger tables, in which case you'll have to move to a better server. Good luck!

 

Add: There's a slim chance that something is corrupted in your database, and fixing that might fix this problem. Go into your hosting control panel's database section (and if necessary, into phpMyAdmin) and run a CHECK on all the database tables, to see if anything is marked "damaged". If it is, try a REPAIR on those table(s). It's worth a try. If you can't figure out how to do this stuff, talk to your tech support.

Share this post


Link to post
Share on other sites

×