Guest Posted March 21, 2006 Posted March 21, 2006 Hi, hope someone can help me with thisproblem. When a user clicks on a category within my cart, or tries to search for something the following error is displayed: 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 = '25' [TEP STOP] Any ideas?, is it an osc problem or my hosting Thanks Kevin
mtechama Posted March 21, 2006 Posted March 21, 2006 Hi, hope someone can help me with thisproblem. When a user clicks on a category within my cart, or tries to search for something the following error is displayed: 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 = '25' [TEP STOP] Any ideas?, is it an osc problem or my hosting Thanks Kevin Ok what is your Web Address? Wade Morris Amarillo, Texas Before you do any changes on your site you need to do BACKUP! BACKUP!
Guest Posted March 21, 2006 Posted March 21, 2006 Ok what is your Web Address? Hi Web address is https://web17.secure-secure.co.uk/books-and...u.net/shopping/ if you select one of the categories on the left you will see what I mean. Thanks
Guest Posted March 21, 2006 Posted March 21, 2006 its probably the mysql 5x issue with the older osc code. You could get the latest upgrade http://www.oscommerce.com/solutions/downloads and modify the sql queries. It should fix the problem.
Guest Posted March 21, 2006 Posted March 21, 2006 its probably the mysql 5x issue with the older osc code. You could get the latest upgrade http://www.oscommerce.com/solutions/downloads and modify the sql queries. It should fix the problem. Thanks for your advice, but......... How do I modify the queries and which queries do I modify?
Guest Posted March 21, 2006 Posted March 21, 2006 you mean you just d/l the latest update and it doesn't say anything in the instructions?
Guest Posted March 21, 2006 Posted March 21, 2006 Thanks for your advice, but.........How do I modify the queries and which queries do I modify? No not d/l yet, just pre-empting any problems!!!!!
Guest Posted March 22, 2006 Posted March 22, 2006 well they're a bunch of changes, it's not a simple one. But it states what files to change and how to locate the code in each file.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.