Perlevenn Posted February 23, 2007 Share Posted February 23, 2007 Hi! I am haveing a problem with my categories page. For some reason, when i push on one of the categories, only a blank page comes up, with this message: 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] You can see for yourselves on www.perlevenn.com/catalog. Under "kategorier" in the left coloumb, press on "Ferskvannsperler". This should now show a page of the products i have entered...... However, I only get the error message. What could be wrong? Please help......? Iselin Link to comment Share on other sites More sharing options...
schrøder Posted February 23, 2007 Share Posted February 23, 2007 Hi!I am haveing a problem with my categories page. For some reason, when i push on one of the categories, only a blank page comes up, with this message: 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] You can see for yourselves on www.perlevenn.com/catalog. Under "kategorier" in the left coloumb, press on "Ferskvannsperler". This should now show a page of the products i have entered...... However, I only get the error message. What could be wrong? Please help......? Iselin In a sacred manner I live, in heaven I gaze, in a sacred manner I live my horses are many. Link to comment Share on other sites More sharing options...
schrøder Posted February 23, 2007 Share Posted February 23, 2007 Hi!I am haveing a problem with my categories page. For some reason, when i push on one of the categories, only a blank page comes up, with this message: 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] You can see for yourselves on www.perlevenn.com/catalog. Under "kategorier" in the left coloumb, press on "Ferskvannsperler". This should now show a page of the products i have entered...... However, I only get the error message. What could be wrong? Please help......? Iselin Ser ut som du har sletta siden har du backup?? In a sacred manner I live, in heaven I gaze, in a sacred manner I live my horses are many. Link to comment Share on other sites More sharing options...
satish Posted February 23, 2007 Share Posted February 23, 2007 Apply the latest patches of oscommerce. Satish Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
Perlevenn Posted February 23, 2007 Author Share Posted February 23, 2007 Apply the latest patches of oscommerce.Satish Sorry, I don't understand what you mean with "the latest patches"? Iselin Link to comment Share on other sites More sharing options...
satish Posted February 25, 2007 Share Posted February 25, 2007 Sorry, I don't understand what you mean with "the latest patches"? Iselin http://www.oscommerce.com/about/news,124 Satish Mantri Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.