irishcavan Posted November 11, 2005 Share Posted November 11, 2005 I have read everything I could find on Product Extra Fields in regards to fixing the quotation marks problem. However, I haven't been able to fix my problem. Here is the code error: 1054 - Unknown column 'pef.languages_id' in 'where clause' 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=2340 and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='1') ORDER BY products_extra_fields_order [TEP STOP] I used the fix for the pef.products_extra_fields_name error listed in the Contribution Annoucements area: http://www.oscommerce.com/forums/index.php?sho...ct+Extra+Fields, but it is not working in this instance. Can someone help me with this? Thanks, Irish Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.