Problem after installation

[mimosa7]

Hi guys,

 

I bought a osc template from template monster for my store and i isnatlled it and everything went great except one thing.

 

If i click on any categorie link, this is what i get as an error :

 

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

 

Otherwise, the primary link like "Contact US" "Home" "Shopping Cart" . etc.. are working perfectly. Can u please help me on that, ill really appreciate.

 

Thanks :thumbsup:

[mimosa7]

OK i Fixed this problem by replacing in the index page the second instance of //we show then all by :

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_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 = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

 

AND IT IS WORKING NOW.

 

But the search fonction still give me the same error. Can u help please ? i heard that i have to inatall the lastest version of OsCommerce, but since i am a real newbie, how can i update to the latest version and keep my template as it is. Sorry if this is a stupid question but i really dont know the procedure to do it the right way.

 

Thanks <_<