new thing about 1064 error

[Guest]

HEllo i am having a problem

 

after i put a product , which contains attributes, to the cart , and i see it to catalog/shopping_cart.php

and i click on it to see some details (that action lead to catalog/product_info.php)

i get the followin problem.

i found that solution http://www.oscommerce.com/community/bugs,1605

but it doesn' t fix the problem

Could you please help me?

additional information : the server which host my site using MySql 4.0.23a

on my pC that i am using for testing the site i am using MySql 4.1.9max

In both cases i have the same problem

 

 

 

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}3{4}4 and ptf.products_extra_fields_value<>'' and (pef.langua

 

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=8{1}3{4}4 and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='4') ORDER BY products_extra_fields_order

 

[TEP STOP]

[♥Vger]

Edit, your error is nothing to do with the usualy 1064 error and actually relates to the coding being used.

 

Vger

[Guest]

Edit, your error is nothing to do with the usualy 1064 error and actually relates to the coding being used.

 

Vger

 

Thanks for your answer but how can i find the probvlem in the code?

[♥Vger]

You've added the Products Extra Fields contribution, and there are problems with the code. The code below should not have curly brackets around them.

 

to use near '{1}3{4}4

 

You need to go back over your install of the Products Extra Fields contribution.

 

Vger

[Guest]

You've added the Products Extra Fields contribution, and there are problems with the code. The code below should not have curly brackets around them.

 

to use near '{1}3{4}4

 

You need to go back over your install of the Products Extra Fields contribution.

 

Vger

 

thank you very much

It was the conyribution Products Extra Fields causing the problem

I found the solution Thanks