PHP Error: foreach() statement

When I setup the coupon's exclude list it worked perfectly. Also it does exclude items upon checkout, but when I go back in to modify the coupon I am receiving this error:

Warning: Invalid argument supplied for foreach() in /home4/king6/public_html/administrator/components/com_awocoupon/views/coupon/tmpl/default.php on line 415Warning: Invalid argument supplied for foreach() in /home4/king6/public_html/administrator/components/com_awocoupon/views/coupon/tmpl/default.php on line 336

Here is an image of the problem:

http://imgur.com/PBg9HQC

Joomla! 2.5.11VirtueMart Version: 2.0.20bPHP 5.3.24

Thanks.

seyi

4 years ago

0+0 / -0

Hello,

That is a strange error.

Can you go to global options and turn on debug mode and then refresh the screen? I wonder if there is a database error.

Regards

joyce3

4 years ago

0+0 / -0

500 - An error has occurred.JDatabaseMySQLi::query: 1271 - Illegal mix of collations for operation 'UNION' SQL=SELECT a.coupon_id,a.asset_id,c.product_name AS asset_name FROM hhv4z_awocoupon_asset1 a JOIN hhv4z_virtuemart_products b ON b.virtuemart_product_id=a.asset_id JOIN hhv4z_virtuemart_products_en_gb c USING (virtuemart_product_id) WHERE a.asset_type="product" AND a.coupon_id IN (1) UNION SELECT a.coupon_id,a.asset_id,c.category_name AS asset_name FROM hhv4z_awocoupon_asset1 a JOIN hhv4z_virtuemart_categories b ON b.virtuemart_category_id=a.asset_id JOIN hhv4z_virtuemart_categories_en_gb c USING (virtuemart_category_id) WHERE a.asset_type="category" AND a.coupon_id IN (1) UNION SELECT a.coupon_id,a.asset_id,c.mf_name AS asset_name FROM hhv4z_awocoupon_asset1 a JOIN hhv4z_virtuemart_manufacturers b ON b.virtuemart_manufacturer_id=a.asset_id JOIN hhv4z_virtuemart_manufacturers_en_gb c USING (virtuemart_manufacturer_id) WHERE a.asset_type="manufacturer" AND a.coupon_id IN (1) UNION SELECT a.coupon_id,a.asset_id,c.vendor_store_name AS asset_name FROM hhv4z_awocoupon_asset1 a JOIN hhv4z_virtuemart_vendors b ON b.virtuemart_vendor_id=a.asset_id JOIN hhv4z_virtuemart_vendors_en_gb c USING (virtuemart_vendor_id) WHERE a.asset_type="vendor" AND a.coupon_id IN (1) UNION SELECT a.coupon_id,a.asset_id,c.shipment_name AS asset_name FROM hhv4z_awocoupon_asset1 a JOIN hhv4z_virtuemart_shipmentmethods b ON b.virtuemart_shipmentmethod_id=a.asset_id JOIN hhv4z_virtuemart_shipmentmethods_en_gb c USING (virtuemart_shipmentmethod_id) WHERE a.asset_type="shipping" AND a.coupon_id IN (1) UNION SELECT a.coupon_id,a.asset_id,b.coupon_code AS asset_name FROM hhv4z_awocoupon_asset1 a JOIN hhv4z_awocoupon b ON b.id=a.asset_id WHERE a.asset_type="coupon" AND a.coupon_id IN (1)