Hi, i exactly have this same problem, can you please help?
500 - An error has occurred.
JDatabaseMySQL::query: 1271 - Illegal mix of collations for operation 'UNION' SQL=SELECT a.id,a.coupon_id,a.asset_id,b.product_name AS asset_name,a.asset_type,a.order_by FROM jos_awocoupon_asset1 a JOIN jos_vm_product b ON b.product_id=a.asset_id WHERE a.asset_type="product" AND a.coupon_id IN (1) UNION SELECT a.id,a.coupon_id,a.asset_id,b.category_name AS asset_name,a.asset_type,a.order_by FROM jos_awocoupon_asset1 a JOIN jos_vm_category b ON b.category_id=a.asset_id WHERE a.asset_type="category" AND a.coupon_id IN (1) UNION SELECT a.id,a.coupon_id,a.asset_id,b.mf_name AS asset_name,a.asset_type,a.order_by FROM jos_awocoupon_asset1 a JOIN jos_vm_manufacturer b ON b.manufacturer_id=a.asset_id WHERE a.asset_type="manufacturer" AND a.coupon_id IN (1) UNION SELECT a.id,a.coupon_id,a.asset_id,b.vendor_name AS asset_name,a.asset_type,a.order_by FROM jos_awocoupon_asset1 a JOIN jos_vm_vendor b ON b.vendor_id=a.asset_id WHERE a.asset_type="vendor" AND a.coupon_id IN (1) UNION SELECT a.id,a.coupon_id,a.asset_id,a.asset_id AS asset_name,a.asset_type,a.order_by FROM jos_awocoupon_asset1 a WHERE a.asset_type="shipping" AND a.coupon_id IN (1) UNION SELECT a.id,a.coupon_id,a.asset_id,b.coupon_code AS asset_name,a.asset_type,a.order_by FROM jos_awocoupon_asset1 a JOIN jos_awocoupon b ON b.id=a.asset_id WHERE a.asset_type="coupon" AND a.coupon_id IN (1)
Call stack
# Function Location
1 JAdministrator->dispatch() /home/fskspo/public_html/administrator/index.php:67
2 JComponentHelper->renderComponent() /home/fskspo/public_html/administrator/includes/application.php:136
3 require_once() /home/fskspo/public_html/libraries/joomla/application/component/helper.php:162
4 JController->execute() /home/fskspo/public_html/administrator/components/com_awocoupon/admin.awocoupon.php:30
5 AwoCouponController->editcoupon() /home/fskspo/public_html/libraries/joomla/application/component/controller.php:236
6 JController->display() /home/fskspo/public_html/administrator/components/com_awocoupon/controller.php:102
7 AwoCouponViewCoupon->display() /home/fskspo/public_html/libraries/joomla/application/component/controller.php:310
8 JView->get() /home/fskspo/public_html/administrator/components/com_awocoupon/views/coupon/view.html.php:82
9 AwoCouponModelCoupon->getEntry() /home/fskspo/public_html/libraries/joomla/application/component/view.php:364
10 awoLibrary::getAwoItem() /home/fskspo/public_html/administrator/components/com_awocoupon/models/coupon.php:103
11 JDatabaseMySQL->loadObjectList() /home/fskspo/public_html/administrator/components/com_awocoupon/helpers/awolibrary.php:147
12 JDatabaseMySQL->query() /home/fskspo/public_html/libraries/joomla/database/database/mysql.php:458
13 JError->raiseError() /home/fskspo/public_html/libraries/joomla/database/database/mysql.php:231
14 JError->raise() /home/fskspo/public_html/libraries/joomla/error/error.php:171
15 JException->__construct() /home/fskspo/public_html/libraries/joomla/error/error.php:136
