Custom fields filters not working anymore (1604)

  • Posts: 6
  • Thank you received: 0
9 years 8 months ago #193943

-- HikaShop version -- : 2.4.0
-- Joomla version -- : 3.4.0
-- PHP version -- : 5.4.17
-- Error-message(debug-mod must be tuned on) -- : Erreur: 1064
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 'OR b.certification_en LIKE 'EN A,%' OR b.certification_en LIKE '%,EN A' OR b.cer' at line 1 SQL=SELECT DISTINCT b.* , case when b.price_currency_id IS NULL then 0 when b.price_currency_id = '1' and b.product_tax_id = '11' then b.price_value+b.price_value*0.2 when b.price_currency_id = '1' and b.product_tax_id = '35' then b.price_value+b.price_value*0 when b.price_currency_id = '1' and b.product_tax_id = '36' then b.price_value+b.price_value*0.055 when b.price_currency_id = '1' and b.product_tax_id NOT IN ('11','35','36') then b.price_value end as product_price_normalized FROM ls19i_hikashop_product_category AS a LEFT JOIN (SELECT * FROM ls19i_hikashop_product AS product3 LEFT JOIN ls19i_hikashop_price AS price3 ON product3.product_id=price3.price_product_id WHERE (price3.price_access = 'all' OR price3.price_access LIKE '%,1,%' OR ISNULL(price3.price_access)) AND product3.product_type='main' GROUP BY product3.product_id ORDER BY price3.price_min_quantity ASC) AS b ON a.product_id=b.product_id INNER JOIN ls19i_hikashop_category AS Marque2 ON Marque2.category_id=b.product_manufacturer_id AND b.product_manufacturer_id IN (28) WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (15) AND b.product_quantity!=0 AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') AND (b.certification_en = 'EN A' OR OR b.certification_en LIKE 'EN A,%' OR b.certification_en LIKE '%,EN A' OR b.certification_en LIKE '%,EN A,%') ORDER BY product_price_normalized*1 DESC LIMIT 0, 20

Hi!

I have three filters on this page ( www.parapente-normandie.com/shop/categorie/voiles ), and the first one ("certification") is not working anymore, I get a 1604 error when I use it.
It used to work, and I guess it's not working after an update. What's wrong?
Thank you

Last edit: 9 years 8 months ago by flyingplanet.

Please Log in or Create an account to join the conversation.

  • Posts: 82867
  • Thank you received: 13373
  • MODERATOR
9 years 8 months ago #193956

Hi,

I don't see why it would do that.
Please provide a FTP access and a backend access to the website along with a link to this thread via our contact form so that we can look at that issue:
www.hikashop.com/support/contact-us.html

Please Log in or Create an account to join the conversation.

Time to create page: 0.135 seconds
Powered by Kunena Forum