Assuming you've used the code fixes previously posted:
Find:
Code: Select all
if(isset($_REQUEST['couponCode']) && trim($_REQUEST['couponCode']) != '') {
$extraFields = 'DISTINCT(co.ordcouporderid), ';
$extraJoins = sprintf("INNER JOIN [|PREFIX|]order_coupons co ON (co.ordcouporderid=o.orderid AND co.ordcouponcode='%s')", $GLOBALS['ISC_CLASS_DB']->Quote($_REQUEST['couponCode']));
}
//MOD Search using SKU or product name
$extraJoins .= " LEFT JOIN [|PREFIX|]order_products sp ON (o.orderid=sp.orderorderid)";
//MOD END Search using SKU or product name
// Return an array containing details about orders.
$query = sprintf("
SELECT %s DISTINCT o.orderid, o.*, c.*, s.statusdesc AS ordstatustext, CONCAT(custconfirstname, ' ', custconlastname) AS custname,
Code: Select all
//MOD Search using SKU or product name
if(isset($_REQUEST['couponCode']) && trim($_REQUEST['couponCode']) != '') {
$extraFields = ' DISTINCT(co.ordcouporderid) ';
$extraJoins = sprintf("INNER JOIN [|PREFIX|]order_coupons co ON (co.ordcouporderid=o.orderid AND co.ordcouponcode='%s')", $GLOBALS['ISC_CLASS_DB']->Quote($_REQUEST['couponCode']));
}
else {
$extraFields = ' DISTINCT (o.orderid) ';
}
$extraJoins .= " LEFT JOIN [|PREFIX|]order_products sp ON (o.orderid=sp.orderorderid)";
//MOD END Search using SKU or product name
// Return an array containing details about orders.
$query = sprintf("
SELECT %s, o.*, c.*, s.statusdesc AS ordstatustext, CONCAT(custconfirstname, ' ', custconlastname) AS custname,
The above code moves the o.orderid field to an else conditional and allows the use of DISTINCT just once