Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Search not working


rjfernandez

Recommended Posts

Everytime I try to search I get the following:

 

1064 - You have an error in your SQL syntax near 'distinct p.products_id) as total from products p left join manufacturers m usin' at line 1

 

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 '%guaro%' or p.products_model like '%guaro%' or m.manufacturers_name like '%guaro%') )

 

[TEP STOP]

 

Could somebody shed a light on what is happening?

I'm using OSCommerce 2.2 MS2

Any help would be very much appreciated.

Thanks,

 

Rodrigo Fernandez

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...