mauriciofollari Posted March 13, 2007 Share Posted March 13, 2007 Hello everyone. First of all, thank you for giving us the posibility of getting fast solutions to our problems with osCommerce. My question is about two errors using osCommerce. When I use the search tool (the query is "life") I get this error: 1054 - Unknown column 'p.products_id' in 'on clause' select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '3' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%life%' or p.products_model like '%life%' or m.manufacturers_name like '%life%') ) [TEP STOP] It seems that there's one column missing somewhere. Another similar error appears when I try to visit any manufacturer section from the homepage of osCommerce. The error is: 1054 - Unknown column 'm.products_id' in 'on clause' select count(p.products_id) as total from products p, products_description pd, manufacturers m left join specials s on m.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '3' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '1' [TEP STOP] Is the same error. I'm terrible handling MySQL. Hope someone can help. Thank you. Bye. Link to comment Share on other sites More sharing options...
Guest Posted March 14, 2007 Share Posted March 14, 2007 it is unlikely that there are missing columns. Get the latest osc http://www.oscommerce.com/solutions/downloads and follow the manual instructions to upgrade the sql queries for mysql5x Link to comment Share on other sites More sharing options...
mauriciofollari Posted April 3, 2007 Author Share Posted April 3, 2007 it is unlikely that there are missing columns. Get the latest oschttp://www.oscommerce.com/solutions/downloads and follow the manual instructions to upgrade the sql queries for mysql5x I'll do that. Thank you. Link to comment Share on other sites More sharing options...
bonzabuy Posted April 23, 2007 Share Posted April 23, 2007 I am getting the error [TEP STOP] when I try to do a search too - but no other error. Any suggestions anyone? can be seen www.bonzabuy.com Link to comment Share on other sites More sharing options...
bonzabuy Posted December 19, 2007 Share Posted December 19, 2007 I am getting the error [TEP STOP] when I try to do a search too - but no other error. Any suggestions anyone? can be seen www.bonzabuy.com For those looking for an answer to this - upgrade to the latest OS store - I know it seems daunting but it is easier in the long run! 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.