• Default avatar
    nicolas4    
     9 years ago
    0

    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.
  • Your avatar
    seyi    
     9 years ago
    0

    Please go to global configuration and turn on debug mode, then try to reload that page. What error do you see?
  • Default avatar
    nicolas4    
     9 years ago
    0

    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
  • Your avatar
    seyi    
     9 years ago
    0

    Ok, try this solution:
    https://awodev.com/forum/awocoupon/help-section/history-uses-not-working#comment-4035
  • Default avatar
    nicolas4    
     9 years ago
    0

    Fixed. Thanks for your help.

    Nicolas