Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Extra Fields Bug Fix


Guest

Recommended Posts

I was wondering if someone could help me. In the process of trying to get Easy Populate setup correctly, I am running into this error message with Extra Fields 2.0i. I've tried the fix of updating to this line:

 

list($products_id_clean) = split('{', $product_info['products_id']);

 

But I still keep getting the following:

 

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')

 

It just looks be as if the variable is not being passed properly into the SQL statement. Has anyone else wrestled with this? I know some PHP & SQL, but not enough to troubleshoot this properly. Thanks for your time!

Mark

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...