Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

errors on adding new catalogs and products


nzturtle

Recommended Posts

hello i need some help ok so the install works fine !! :P

 

but when i goto view a catalog or Make a new 1 with a product i get this error

 

Let's See What We Have Here

 

 

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 = '21'

 

[TEP STOP]

 

 

does anyone know whats wrong

 

im pretty new to OS Commerce i brought a template from template monster for OS COmmerce

Link to comment
Share on other sites

You are running on MySQL v5, which requires different query structures that previous versons.

 

Change the query to be:

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c 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 = '21'

and it should work.

"Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a man does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses his intelligence." - A. Einstein

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...