Products Extra Fields mod bug? Wierd

[Guest]

I installed product extra fields mod. I thought everything was fine until one day I added an option (not a mod) in a product. Now when this product is selected from the shopping cart box I get this error (but not if it is selected from Cart Contents!)

 

1064 - You have an error in your SQL syntax near '{1}1 and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.la' at line 6

 

SELECT 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=38{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]

 

But if you select it from say the Cart Contents or in any other way, there is no error. You can continue buying the product with no problem just as long as one aviods the shopping cart box in the top right hand corner.

 

Remove the attributes option in that product and problem is solved again.

 

i.e Products Extra Fields doesn't like me to use attributes.

 

Indeed if you find products_extra_fields.php (which is not an edited php but an added one(you do find this line

 

$products_extra_fields_query = tep_db_query("SELECT * FROM " . TABLE_PRODUCTS_EXTRA_FIELDS . " ORDER BY products_extra_fields_order");

while ($extra_fields = tep_db_fetch_array($products_extra_fields_query)) {

?>

 

Any ideas?

 

 

Wierd

 

I have another mod installed, Product Short Descriptions which so far works fine. In fact I thought PEF was add short desriptions (but to remove it would be hard now) and for those who want an extra description in the Products listings rather than an extra word or two in the product main page, then Short Description is the one. It is also multilingual which is not mention in the intructions.

 

 

Charlie

[Guest]

It is actually an old-ish bugs and it has been fixed in the latest install proceudre under chapter six.

 

 

Charlie

[Guest]

It is actually an old-ish bugs and it has been fixed in the latest install proceudre under chapter six.

Charlie

<{POST_SNAPBACK}>

 

 

The only problem it didn't work. Any clues? I still get this error and the fix isn't making any difference.

 

Thanks for any help I get.

 

Charlie