Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

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

Link to comment
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.

Link to comment
Share on other sites


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

  • Create New...