File nshop/dbresult.php, line 14], message Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4 ( select round(max(pc.commission/pc.price)*100) from product_variants pv join price_cache pc on(pv.id=pc.variant_id and pc.broker_id=0) where pv.product_id in (select cp.product_id from category_products cp where cp.category_id=)).
Trace:
File nshop/dbconnection.php, line 23, class/function dbresult->dbresult, arg0 resource(8) of type (mysql link) , arg1 string(280) " select round(max(pc.commission/pc.price)*100) from product_variants pv .
File nshop/category_listing.php, line 79, class/function dbconnection->query, arg0 string(280) " select round(max(pc.commission/pc.price)*100) from product_variants pv .
File nshop/nshop.php, line 64, class/function category_listing->out_body.
File index.php, line 32, class/function nshop->out_body.