Here is the Debug error message(s):
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 joomla2_awocoupon_asset1 a JOIN joomla2_virtuemart_products b ON b.virtuemart_product_id=a.asset_id JOIN joomla2_virtuemart_products_en_gb c USING (virtuemart_product_id) WHERE a.asset_type="product" AND a.coupon_id IN (107) UNION SELECT a.coupon_id,a.asset_id,c.category_name AS asset_name FROM joomla2_awocoupon_asset1 a JOIN joomla2_virtuemart_categories b ON b.virtuemart_category_id=a.asset_id JOIN joomla2_virtuemart_categories_en_gb c USING (virtuemart_category_id) WHERE a.asset_type="category" AND a.coupon_id IN (107) UNION SELECT a.coupon_id,a.asset_id,c.mf_name AS asset_name FROM joomla2_awocoupon_asset1 a JOIN joomla2_virtuemart_manufacturers b ON b.virtuemart_manufacturer_id=a.asset_id JOIN joomla2_virtuemart_manufacturers_en_gb c USING (virtuemart_manufacturer_id) WHERE a.asset_type="manufacturer" AND a.coupon_id IN (107) UNION SELECT a.coupon_id,a.asset_id,c.vendor_store_name AS asset_name FROM joomla2_awocoupon_asset1 a JOIN joomla2_virtuemart_vendors b ON b.virtuemart_vendor_id=a.asset_id JOIN joomla2_virtuemart_vendors_en_gb c USING (virtuemart_vendor_id) WHERE a.asset_type="vendor" AND a.coupon_id IN (107) UNION SELECT a.coupon_id,a.asset_id,c.shipment_name AS asset_name FROM joomla2_awocoupon_asset1 a JOIN joomla2_virtuemart_shipmentmethods b ON b.virtuemart_shipmentmethod_id=a.asset_id JOIN joomla2_virtuemart_shipmentmethods_en_gb c USING (virtuemart_shipmentmethod_id) WHERE a.asset_type="shipping" AND a.coupon_id IN (107) UNION SELECT a.coupon_id,a.asset_id,b.coupon_code AS asset_name FROM joomla2_awocoupon_asset1 a JOIN joomla2_awocoupon b ON b.id=a.asset_id WHERE a.asset_type="coupon" AND a.coupon_id IN (107)
Call stack
# Function Location
1 JAdministrator->dispatch() /home/XXXX/public_html/portal/administrator/index.php:46
2 JComponentHelper::renderComponent() /home/XXXX/public_html/portal/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() /home/XXXX/public_html/portal/libraries/joomla/application/component/helper.php:351
4 require_once() /home/XXXX/public_html/portal/libraries/joomla/application/component/helper.php:383
5 JController->execute() /home/XXXX/public_html/portal/administrator/components/com_awocoupon/awocoupon.php:45
6 AwoCouponController->editcoupon() /home/XXXX/public_html/portal/libraries/joomla/application/component/controller.php:761
7 JController->display() /home/XXXX/public_html/portal/administrator/components/com_awocoupon/controller.php:225
8 AwoCouponViewCoupon->display() /home/XXXX/public_html/portal/libraries/joomla/application/component/controller.php:722
9 JView->get() /home/XXXX/public_html/portal/administrator/components/com_awocoupon/views/coupon/view.html.php:86
10 AwoCouponModelCoupon->getEntry() /home/XXXX/public_html/portal/libraries/joomla/application/component/view.php:386
11 call_user_func() /home/XXXX/public_html/portal/administrator/components/com_awocoupon/models/coupon.php:91
12 AwocouponVirtuemartHelper::getAwoItem()
13 JDatabase->loadObjectList() /home/XXXX/public_html/portal/administrator/components/com_awocoupon/helpers/estore/virtuemart/helper.php:101
14 JDatabaseMySQLi->execute() /home/XXXX/public_html/portal/libraries/joomla/database/database.php:1100
15 JError::raiseError() /home/XXXX/public_html/portal/libraries/joomla/database/database/mysqli.php:396
16 JError::raise() /home/XXXX/public_html/portal/libraries/joomla/error/error.php:251
