Jump to content

Frederik

Members
  • Content count

    3
  • Joined

  • Last visited

Profile Information

  • Real Name
    Frederik Boenders
  1. Frederik

    1064 Error on Catalogside

    It seems that the (temporary) ID ptf.products_id=376{8}48{7}23 causes the problem. If is would just be ptf.products_id=376, it would work fine. Does anybody know where this "{8}48{7}23 " addition is created, what the use is, and how to get rid of it? Tnx. Frederik 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 '{8}48{7}23 and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or ' at line 5 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=376{8}48{7}23 and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='4') ORDER BY products_extra_fields_order
  2. I have installed this contribution, and everything seemed to be working fine, at least on the Admin side. The problem is that the e-mail to the customer contains a link to the article that produces this error: 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 '{8}48{7}23 and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or ' at line 5 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=376{8}48{7}23 and ptf.products_extra_fields_value<>'' and (pef.languages_id='0' or pef.languages_id='4') ORDER BY products_extra_fields_order I've checked this topic and other sources (Google, other osCommerce fora), but to no avail. Extra info: Site language is Dutch. Any help will be greatly appreciated. Rgds, Frederik
  3. Frederik

    News Blog V1.0

    I've got the same problem. Installed the contri to the letter today, but Tools->News only displays an empty page with the word News and an empty drop-down box under "Go back to: categories/products" (also empty). Any help is welcome!! Tnx, Frederik
×