Jump to content


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name
  1. I have installed this module for a client and when testing using production mode, credit card go through but debit cards will not. Any ideas why this could be happening? Thanks
  2. pnoden

    Seperate Pricing Per Customer v3.5

    That worked great! There was just one small typo: p2c.product_id should be p2c.products_id. Thank you very much. I have been racking my brain to figure this out.
  3. pnoden

    Seperate Pricing Per Customer v3.5

    Hi Everyone, After installing SPPC ver 4.2.1a, I receive this error where the new products module should be on the categories page. 1052 - Column 'products_id' in from clause is ambiguous select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_price, pd.products_name from products p, products_description pd left join products_to_categories p2c using(products_id) left join categories c using(categories_id) where c.parent_id = '21' and p.products_status = '1' and pd.language_id = '1' and p.products_id = pd.products_id order by p.products_date_added desc limit 9 The featured products module will work in place of the new products module. I have searched the forum and cannot find an answer. The server that the site is on is using PHP Version 4.4.7 and MySQL 5. I have tested the site on another server that is using PHP Version 4.3.11 and MySQL 4 and everything works fine. Any help would be greatly appreciated.