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

[mukka]

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 `products_description`.`products_name`, `categories_description`.`categories_name`, `manufacturers`.`manufacturers_name` FROM products, products_description, products_to_categories, categories, categories_description, languages, manufacturers, configuration WHERE products.products_id = products_description.products_id AND products_description.language_id = languages.languages_id AND products_description.products_id = products_to_categories.products_id AND products_to_categories.categories_id = categories.categories_id AND categories.categories_id = categories_description.categories_id AND categories_description.language_id = languages.languages_id AND products.manufacturers_id = manufacturers.manufacturers_id AND products.products_status = 1 AND configuration.configuration_key = 'DEFAULT_LANGUAGE' AND languages.code = configuration.configuration_value

 

[TEP STOP]

 

above is the error i get when trying to enter the shop, i have searched support and cant find a fix that works

have set my sql big selects =1 and also increased set sql max join size these have not helped at all

think there may be a problem with the code in index.php but not sure,

please help have been at this for a few days now and the shop has been down since before xmas,

all thoughts much appreciated

[mukka]

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 `products_description`.`products_name`, `categories_description`.`categories_name`, `manufacturers`.`manufacturers_name` FROM products, products_description, products_to_categories, categories, categories_description, languages, manufacturers, configuration WHERE products.products_id = products_description.products_id AND products_description.language_id = languages.languages_id AND products_description.products_id = products_to_categories.products_id AND products_to_categories.categories_id = categories.categories_id AND categories.categories_id = categories_description.categories_id AND categories_description.language_id = languages.languages_id AND products.manufacturers_id = manufacturers.manufacturers_id AND products.products_status = 1 AND configuration.configuration_key = 'DEFAULT_LANGUAGE' AND languages.code = configuration.configuration_value

 

[TEP STOP]

 

above is the error i get when trying to enter the shop, i have searched support and cant find a fix that works

have set my sql big selects =1 and also increased set sql max join size these have not helped at all

think there may be a problem with the code in index.php but not sure,

please help have been at this for a few days now and the shop has been down since before xmas,

all thoughts much appreciated

[mukka]

the admin seems to be working fine it only happens in the catalog