Product Options, MySQL Error Occured, 1104:

[cb2004]

One of my customers gets this error when trying to enter product options:

Product Options

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 cartcube_CubeCart_options_bot RIGHT JOIN cartcube_CubeCart_inventory ON product = productId ORDER BY name ASC

Any ideas?

[cb2004]

Could this be a server problem?

[cb2004]

My host has said I need to set big limits in the code?

[cb2004]

Around line 278 on /admin/products/options.php

Find this:

get slave products

$slaveProducts = $db->select("SELECT DISTINCT productId, name FROM ".$glob['dbprefix']."CubeCart_options_bot RIGHT JOIN ".$glob['dbprefix']."CubeCart_inventory ON product = productId ORDER BY name ASC");

Add this line before $slaveProducts:

$bigselects = $db->misc("SET sql_big_selects=1");

So it looks like this:

get slave products

$bigselects = $db->misc("SET sql_big_selects=1");

$slaveProducts = $db->select("SELECT DISTINCT productId, name FROM ".$glob['dbprefix']."CubeCart_options_bot RIGHT JOIN ".$glob['dbprefix']."CubeCart_inventory ON product = productId ORDER BY name ASC");

Should this be added to the release?

[lns]

I have the following as well when I go to product options....

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

I have tried the fix suggested to no avail, cleared cache and even rebooted. Any help would be appreciated