Категории

Ошибка при внесении доп.полей в параметров.

Внес дополнительные поля в Параметры. Теперь некоторые запросы работают, а некоторые выдают ошибку

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 distinct p.products_id, p.products_price, p.products_model, p.products_quantity, p.products_shippingtime, p.products_fsk18, p.products_image, p.products_weight, p.products_tax_class_id, pd.products_name, pd.products_short_description, pd.products_description FROM os_products AS p LEFT JOIN os_products_description AS pd ON (p.products_id = pd.products_id) LEFT OUTER JOIN os_products_attributes AS pa ON (p.products_id = pa.products_id) LEFT OUTER JOIN os_products_options_values AS pov ON (pa.options_values_id = pov.products_options_values_id) LEFT OUTER JOIN os_specials AS s ON (p.products_id = s.products_id) AND s.status = '1' LEFT OUTER JOIN os_products_to_products_extra_fields AS pe ON (p.products_id = pe.products_id) left join os_param pm on p.products_id = pm.product_id left join

В чем может быть проблема?

попробуйте выполнить запросы

ALTER TABLE `os_param` ADD INDEX ( `value_id` ) ;
ALTER TABLE `os_param` ADD INDEX ( `name_id` ) ;
ALTER TABLE `os_param_value` ADD INDEX ( `name_id` )

SET SQL_MAX_JOIN_SIZE = 4294967295999999

Источник