Problema modul cautare dupa atribute

[Silvian]

Salutare, sunt nou pe forum si am si eu o problema.
Am instalat prestashop 1.3.1 local, totul ok pana cand am incercat sa instalez un modul de cautare pe atribute (blocksearchbyattribute).
tin sa precizez ca imi trebuie acest modul pentru un site de vanzari anvelope, deci atributele trebuie sa fie Latime, inaltime diametru etc.
Ok, modulul este instalat, am introdus atribute la produse, dar imi apare o eroare.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10,10' at line 61

SELECT DISTINCT * FROM (

SELECT p.`id_product` , ppac.`id_attribute` , ppac.`id_product_attribute` , ppa.`quantity` , i.`id_image` , pl.`description_short` , pl.`link_rewrite` , pl.`name`

FROM

`ps_product` AS p,

`ps_product_attribute` AS ppa,

`ps_product_attribute_combination` AS ppac,

`ps_product_lang` AS pl,

`ps_product_attribute_image` AS pai,

`ps_image` AS i

WHERE



ppac.`id_attribute` = 29

AND pai.`id_product_attribute` = ppac.`id_product_attribute`

AND ppa.`id_product_attribute` = ppac.`id_product_attribute`

AND p.`id_product` = ppa.`id_product`

AND ppa.`quantity` > 0

AND i.`id_product` = p.`id_product`

AND i.`id_image` = pai.`id_image`

AND p.`id_product` = pl.`id_product`

AND p.`active` =1

AND pl.`id_lang` =1 UNION

SELECT p.`id_product` , ppac.`id_attribute` , ppac.`id_product_attribute` , ppa.`quantity` , i.`id_image` , pl.`description_short` , pl.`link_rewrite` , pl.`name`

FROM

`ps_product` AS p,

`ps_product_attribute` AS ppa,

`ps_product_attribute_combination` AS ppac,

`ps_product_lang` AS pl,

`ps_product_attribute_image` AS pai,

`ps_image` AS i

WHERE



ppac.`id_attribute` = 28

AND pai.`id_product_attribute` = ppac.`id_product_attribute`

AND ppa.`id_product_attribute` = ppac.`id_product_attribute`

AND p.`id_product` = ppa.`id_product`

AND ppa.`quantity` > 0

AND i.`id_product` = p.`id_product`

AND i.`id_image` = pai.`id_image`

AND p.`id_product` = pl.`id_product`

AND p.`active` =1

AND pl.`id_lang` =1 UNION

SELECT p.`id_product` , ppac.`id_attribute` , ppac.`id_product_attribute` , ppa.`quantity` , i.`id_image` , pl.`description_short` , pl.`link_rewrite` , pl.`name`

FROM

`ps_product` AS p,

`ps_product_attribute` AS ppa,

`ps_product_attribute_combination` AS ppac,

`ps_product_lang` AS pl,

`ps_product_attribute_image` AS pai,

`ps_image` AS i

WHERE



ppac.`id_attribute` = 27

AND pai.`id_product_attribute` = ppac.`id_product_attribute`

AND ppa.`id_product_attribute` = ppac.`id_product_attribute`

AND p.`id_product` = ppa.`id_product`

AND ppa.`quantity` > 0

AND i.`id_product` = p.`id_product`

AND i.`id_image` = pai.`id_image`

AND p.`id_product` = pl.`id_product`

AND p.`active` =1

AND pl.`id_lang` =1) AS tmp GROUP BY tmp.`id_product_attribute` HAVING COUNT(*) = 3 ORDER BY tmp.`name` LIMIT -10,10

Ma puteti ajuta si pe mine, sa rezolv si eu aceasta problema va rog?
P.S. Am incercat sa instalez toate modulele finale pentru prestashop 1.3.1

[gremlinash2in1]

Salut, încearcă LIMIT = 0,10 (la sfîrșit)

[radu adrian]

imi poti da mai multe detalii despre modul pt ca si eu caut ceva asemanator

[Abh]

Detalii? Il poti lua de aici: http://www.prestashop.com/forums/viewthread/54611/third_party_modules/module_prestashop_1_dot_3_dot_1_compliant_search_by_attribute_module_working_fine_now__advanced_search__filter_by_attributes__filter_search_product