tunetti Posted May 27, 2013 Share Posted May 27, 2013 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 More sharing options...
MrPhil Posted May 27, 2013 Share Posted May 27, 2013 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.