stevebrett Posted June 20, 2007 Share Posted June 20, 2007 I've just installed the extra fields contribution v2.0j and get the following error in product_info.php. Can anyone give me a hand tracking this down 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 'and ptf.products_extra_fields_value<>'' and (pef.languages_id='0 SELECT pef.products_extra_fields_name as name, ptf.products_extra_fields_value as value ,pef.products_extra_fields_status as status 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= and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='1') ORDER BY products_extra_fields_order Thanks Steve Link to comment Share on other sites More sharing options...
Guest Posted June 20, 2007 Share Posted June 20, 2007 Did you upload the SQL file that came with the contribution? Link to comment Share on other sites More sharing options...
stevebrett Posted June 20, 2007 Author Share Posted June 20, 2007 Did you upload the SQL file that came with the contribution? I did yes, and have confirmed that the two tables in the .sql have been made.... Other thoughts? Steve Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.