Jump to content
Sign in to follow this  
Silvian

Problema modul cautare dupa atribute

Recommended Posts

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

Share this post


Link to post
Share on other sites
Sign in to follow this  

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More