Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error message when doing search


charmdiva

Recommended Posts

When entering keywords into the search box, I get this error on the action page:

 

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 = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%doll%' or p.products_model like '%doll%' or m.manufacturers_name like '%doll%') )

 

[TEP STOP]

 

I tried searching the forums for something similar, but got pages of unrelated posts.

 

Thanks

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...