When I log into the system i get:
Unprocessed Error performing query: You have an error in your SQL syntax near ')' at line 1
SQL String on page /affiliates/index.php?control=sales
SELECT COUNT(DISTINCT(od.ID)) as cnt FROM orderDetails od LEFT JOIN orderItems oi ON (oi.itemOrderID=od.ID) WHERE (od.orderNewItems>='1' && od.orderApproved<=1 && od.orderHold='0' && od.orderActive=1 && oi.itemStatus=0 && affiliateID=);
Sorry there has been an Error with this page, plase call 0870 242 1808 if you would like to make an order or report this error.
Any thoughts?
Ta
|