Latest News: (loading..)

pnoden

Members
  • Content count

    3
  • Joined

  • Last visited

About pnoden

Profile Information

  • Real Name
    Patrick
  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. 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. 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.