I was able to get the coupon reports functioning again by changing sql query near line 594 in the uc_coupon module to:
$query = db_query("SELECT co.cid, co.oid, co.value, co.code, o.order_total, o.created FROM uc_coupons_orders AS co LEFT JOIN uc_orders AS o ON (co.oid = o.order_id) WHERE o.order_status >= 0 AND o.created > %d AND o.created < %d ORDER BY co.cid, o.created ASC",$start, $end);I have also attached the modified uc_coupon module package.
Everyone - please let me know if this gets functioning for you as well as it appears to be working fine for me with ubercart v0.8
cheers - Aaron
| Attachment | Size |
|---|---|
| uc_coupon_module.zip | 13.47 KB |