Guest Posted March 26, 2007 Posted March 26, 2007 I am getting this error on every product page. 1054 - Unknown column 'approved' in 'where clause' select count(*) as count from reviews where approved = 1 and products_id = '28' [TEP STOP] Please can you assist?
Guest Posted March 27, 2007 Posted March 27, 2007 I am getting this error on every product page. 1054 - Unknown column 'approved' in 'where clause' select count(*) as count from reviews where approved = 1 and products_id = '28' [TEP STOP] Please can you assist? I am also getting this 1054 - unknown column error all throughout my site: Visit My Website 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 = '106' [TEP STOP] HELP!!!! what can I do???
boonchai Posted March 27, 2007 Posted March 27, 2007 To all friends who have an Error : 1054 - Unknown column 'p.products_id' in 'on clause' , Please see the advice under osCommerce Community Support Forums> osCommerce Support>Installation and Configuration, Forum Topics : 1054 - Unknown column 'p.products_id' in 'on clause' by boonchai Today 11:41am at jack replied on Mar.23.2007 07:58pm at the link said : Take a look at this. Good Luck, Boonchai
Recommended Posts
Archived
This topic is now archived and is closed to further replies.