Guest rickyoun Posted November 20, 2006 Share Posted November 20, 2006 Hi all, it seems i have a problem with my product options. More particularly in displaying them within cube cart. Is there a quick way of increasing the amount of entries in the options table that can ve viewed, i have included the eror message i am getting below: MySQL Error Occured 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 QUERY = SELECT DISTINCT productId, name FROM CubeCart_options_bot RIGHT JOIN CubeCart_inventory ON product = productId ORDER BY name ASC Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.