I have a problem with Awocoupon. When I try to see the codes that has been send, I get this error message:
1054 Unknown column 'user_email' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS c.id AS voucher_customer_id, c.codes, uv.first_name,uv.last_name, c.user_id, c.user_id AS _user_id, u.username, uv.email as user_email, ov.virtuemart_order_id AS order_id,ov.created_on AS cdate,CONCAT(ov.virtuemart_order_id," (",ov.order_number,")") AS order_number, u.username as _username, uv.first_name as _fname, uv.last_name as _lname,ov.created_on AS _created_on, GROUP_CONCAT(cc.code ORDER BY cc.code SEPARATOR ", ") as coupon_codes FROM #__awocoupon_voucher_customer c LEFT JOIN #__awocoupon_voucher_customer_code cc ON cc.voucher_customer_id=c.id LEFT JOIN #__users u ON u.id=c.user_id LEFT JOIN #__virtuemart_orders ov ON ov.virtuemart_order_id=c.order_id LEFT JOIN #__virtuemart_order_userinfos uv ON uv.virtuemart_order_id=c.order_id AND uv.address_type="BT" WHERE c.estore="virtuemart" AND LOWER(user_email) LIKE '%hallo%' GROUP BY c.id ORDER BY c.order_id desc LIMIT 0, 20
How can I solve this?
Thanks in advance,
Kris