1064 - You have an error in your SQL syntax near '

[Guest]

I have installed the shop bij Price Contribution v1.0 Revised files

when I klick on the Top>>Catalog>>shop_by_price I get an error

 

 

CODE

1064 - You have an error in your SQL syntax near '' at line 1

 

select count(p.products_id) as total from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '4' left join specials s on p.products_id = s.products_id where p.products_status = '1' and

 

[TEP STOP]

 

 

 

 

Any help is welcome

[Guest]

your sql is broken, there needs to be more stuff after the last 'and'

[Guest]

This is most likely caused by the splitPageResults class not being compatible - I assume you are running MS2 and the contribution was written for an earlier version - there is an example here

 

HTH

 

Matti