Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help. templete not working.


Guest

Recommended Posts

Posted

HELP!

I am getting this error when I look at the products on my cart.

What is problem, I just downloaded a templete when it happened.

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '22'

 

[TEP STOP]

Posted

This is because your host is using MySql 5 and the template hasn't had the necessary updates. Read through the updates and compare them to your files.

 

You might want to download the latest osC update and WinMerge to make the job easier.

 

There is a file within the latest package that details the updates. The updates until update-20051113 are shown at this link:

 

http://www.oscommerce.com/ext/update-20051113.html

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...