Error 500

Hello !

[Wed Sep 10 14:42:56 2014] [error] [client xx.xx.xx.xx] PHP Warning: Invalid argument supplied for foreach() in /(...)/administrator/components/com_awocoupon/views/history/tmpl/default.php on line 64, referer: (...)/administrator/index.php?option=com_awocoupon&view=coupons

URL : (...)/administrator/index.php?option=com_awocoupon&view=history&layout=coupon

Layout=coupon gives an error 500.

Clicking on HISTORY / COUPONS give URL : (...)/administrator/index.php?option=com_awocoupon&view=history, which gives an empty list, which is wrong (1 coupon was used before).

Thanks.

Please go to global configuration and turn on debug mode, then try to reload that page. What error do you see?

JDatabaseMySQL::query: 1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=SELECT c.id,c.coupon_code,c.num_of_uses_total,c.num_of_uses_customer,c.coupon_value_type,c.coupon_value, c.min_value,c.discount_type,c.function_type,c.startdate,c.expiration,c.published, uu.coupon_id,uu.coupon_entered_id,c2.coupon_code as coupon_entered_code, uu.id as use_id,uv.first_name,uv.last_name,uu.user_id,u.username, (uu.coupon_discount+uu.shipping_discount) AS discount,uu.productids,uu.timestamp,uu.user_email, ov.order_id AS order_id,FROM_UNIXTIME(ov.cdate) AS cdate,LPAD(ov.order_id,8,"0") AS order_number, u.username as _username, uv.first_name as _fname, uv.last_name as _lname,FROM_UNIXTIME(ov.cdate) AS _created_on FROM jos_awocoupon_history uu JOIN jos_awocoupon c ON c.id=uu.coupon_id LEFT JOIN jos_awocoupon c2 ON c2.id=uu.coupon_entered_id LEFT JOIN jos_awocoupon_tag t ON t.coupon_id=c.id LEFT JOIN jos_vm_user_info uv ON uv.user_id=uu.user_id AND uv.address_type="BT" LEFT JOIN jos_users u ON u.id=uu.user_id LEFT JOIN jos_awocoupon_vm1ids vm1 ON vm1.id=uu.order_id LEFT JOIN jos_vm_orders ov ON ov.order_number=vm1.value WHERE uu.estore="virtuemart1" GROUP BY uu.id ORDER BY c.coupon_code LIMIT 0, 20

Ok, try this solution:
https://awodev.com/forum/awocoupon/help-section/history-uses-not-working#comment-4035

Fixed. Thanks for your help.

Nicolas