Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Error on Search and Manufacturer Tool


Recommended Posts

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%') )




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'



Is the same error. I'm terrible handling MySQL. Hope someone can help. Thank you. Bye.

Link to comment
Share on other sites

  • 3 weeks later...
  • 3 weeks later...
  • 7 months later...
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


This topic is now archived and is closed to further replies.

  • Create New...