Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Plase help!!! Error 1064


Pitxi

Recommended Posts

In a new installation of Oscommerce 2.2 MS2, when i perform a basic search, this error appear:

 

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

 

 

This error don?t appear in the local installation (using EasyPHP)

 

Please help !!!

 

Thanks

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...