database error when going back back to a product with attributes

[Guest]

Hi

 

Could somebody point me to an existing thread about the problem occuring when clicking on a product from the shopping cart page or box on a product with attributes AND extra fields (in separate table) regarding the message:

 

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 '{1}1 and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.la' at line 5

SELECT pef.products_extra_fields_status as status, pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value FROM products_extra_fields pef LEFT JOIN products_to_products_extra_fields ptf ON ptf.products_extra_fields_id=pef.products_extra_fields_id WHERE ptf.products_id=37{1}1 and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='1') ORDER BY products_extra_fields_order

[TEP STOP]

 

a product with extra fields and no attribute doesn't cause a problem, it does if an attribute is added

 

I know I saw that somewhere, couldn't find it again

 

Thanks