Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Search error: error in your SQL syntax near...


lekkaut

Recommended Posts

Hello,

 

I installad OsCommerce on my server and everything is working allright besides the search-option.

 

When I try to search for something I get this error:

 

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



[TEP STOP]

 

What could be the cause of this error? I hope somebody with more experience then me, can help me out here. I'm clueless.

 

thanks

greetings, Richard

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...