Ошибка при выборе множественного значения фильтра

[Divan 0]

Добавил спецификацию сделал ее как чекбоксы.

Привязал к товарам.

После этого, когда в фильтрах выбираешь несколько значений выдает ошибку. Если выбираешь одно значение, то все отлично.

Ошибка такая:

04/02/2013 21:02:08 | 1066 - Not unique table/alias: 'ps1' | select distinct p.products_id,

p.products_fsk18,

p.products_shippingtime,

p.products_model,

pd.products_name,

p.products_ean,

p.products_price,

p.products_tax_class_id,

m.manufacturers_name,

p.products_quantity,

p.products_image,

p.products_weight,

pd.products_short_description,

pd.products_description,

p.products_id,

p.manufacturers_id,

p.products_price,

p.products_vpe,

p.products_vpe_status,

p.products_vpe_value,

p.products_discount_allowed,

p.products_tax_class_id,

IF(s.status, s.specials_new_products_price, NULL)

as specials_new_products_price,

IF(s.status, s.specials_new_products_price, p.products_price)

as final_price

from

products p

left join specials s

on p.products_id = s.products_id

left join manufacturers m

on p.manufacturers_id = m.manufacturers_id

join products_description pd

on p.products_id = pd.products_id

join products_to_categories p2c

on p.products_id = p2c.products_id

INNER JOIN products_specifications ps1 ON p.products_id = ps1.products_id INNER JOIN products_specifications ps1 ON p.products_id = ps1.products_id

where

p.products_status = '1'

and pd.language_id = '1'

AND ps1.specification <=> 44

AND ps1.specifications_id = '1'

AND ps1.language_id = '1'

AND ps1.specification <=> 50

AND ps1.specifications_id = '1'

AND ps1.language_id = '1'

ORDER BY pd.products_name | /products_filter.php?f1%5B2%5D=44&f1%5B5%5D=50

04/02/2013 21:02:49 | 1066 - Not unique table/alias: 'ps1' | select distinct p.products_id,

p.products_fsk18,

p.products_shippingtime,

p.products_model,

pd.products_name,

p.products_ean,

p.products_price,

p.products_tax_class_id,

m.manufacturers_name,

p.products_quantity,

p.products_image,

p.products_weight,

pd.products_short_description,

pd.products_description,

p.products_id,

p.manufacturers_id,

p.products_price,

p.products_vpe,

p.products_vpe_status,

p.products_vpe_value,

p.products_discount_allowed,

p.products_tax_class_id,

IF(s.status, s.specials_new_products_price, NULL)

as specials_new_products_price,

IF(s.status, s.specials_new_products_price, p.products_price)

as final_price

from

products p

left join specials s

on p.products_id = s.products_id

left join manufacturers m

on p.manufacturers_id = m.manufacturers_id

join products_description pd

on p.products_id = pd.products_id

join products_to_categories p2c

on p.products_id = p2c.products_id

INNER JOIN products_specifications ps1 ON p.products_id = ps1.products_id INNER JOIN products_specifications ps1 ON p.products_id = ps1.products_id

where

p.products_status = '1'

and pd.language_id = '1'

AND ps1.specification <=> 42

AND ps1.specifications_id = '1'

AND ps1.language_id = '1'

AND ps1.specification <=> 44

AND ps1.specifications_id = '1'

AND ps1.language_id = '1'

ORDER BY pd.products_name | /products_filter.php?f1%5B1%5D=42&f1%5B2%5D=44

[support 447]

А какая версия MySQL у Вас на сервере?

[Divan 0]

А какая версия MySQL у Вас на сервере?

Версия сервера: 5.1.63-0+squeeze1-log

[support 447]

Видимо, неправильно фильтры настроили.

Вы посмотрите таблицу вот здесь - http://vamshop.ru/manual/ch06s07.html

Там таблица совместимости класса фильтра и типа фильтра.

Нужно Вам в настройках фильтров поменять либо тип фильтры, либо класс фильтра.