Blowin Posted October 17, 2007 Share Posted October 17, 2007 Hi, I'm trying to add some product attributes to a client's site and I got through about 30 of them and then got the following error message and can't add any more: 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 select pov.products_options_values_id, pov.products_options_values_name, pov2po.products_options_id, pov2po.products_options_values_sort_order from products_options_values pov left join products_options_values_to_products_options pov2po on pov.products_options_values_id = pov2po.products_options_values_id where pov.language_id = '1' order by pov.products_options_values_id [TEP STOP] I'm a graphics person and not a coder and have no idea how to fix this. What do I need to do to clear this error message and add more product attributes? Thanks... Link to comment Share on other sites More sharing options...
Blowin Posted October 24, 2007 Author Share Posted October 24, 2007 I'm still having trouble with this...can anyone please help me fix this error message so I can add more attributes? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.