coupon issue and now upgrade issue


  • Default avatar
    christopher9    
     3 years ago
    0

    Hey

    I added a coupon and set it to exclude my chosen categories, but when adding to the cart these products still get discounted.

    So i decided to upgrade the component and renew my subscription

    now i still have the problem above and also now in the admin i have

    Warning: Invalid argument supplied for foreach() in /home/NAME/public_html/administrator/components/com_awocoupon/helpers/awolibrary.php on line 149

    Warning: Invalid argument supplied for foreach() in /home/NAME/public_html/administrator/components/com_awocoupon/views/coupon/tmpl/default.php on line 311


  • Default avatar
    christopher9    
     3 years ago
    0

    ignore that coupons work great now but still this in the admin

    Warning: Invalid argument supplied for foreach() in /home/NAME/public_html/administrator/components/com_awocoupon/helpers/awolibrary.php on line 149

    Warning: Invalid argument supplied for foreach() in /home/NAME/public_html/administrator/components/com_awocoupon/views/coupon/tmpl/default.php on line 311

  • Your avatar
    seyi    
     3 years ago
    0

    Hello,

    I believe there is a problem with the database.

    Can you go to global configuration and turn debug mode on? Then refresh AwoCoupon page? You should see a database error, what is it?
  • Default avatar
    yofie1    
     2 years ago
    0

    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

  • Your avatar
    seyi    
     2 years ago
    0

    Hello,

    Can you please try this solution:
    https://awodev.com/forum/awocoupon/help-section/error-showing-coupon-created-buy-one-get-one-half-price#comment-3883