Error Messages Following New Clean Install


  • Your avatar
    seyi    
     6 years ago
    0

    Please assist with why I get these 2 error messages when I select the "coupon" menu item


    "Warning: Invalid argument supplied for foreach() in /home/darksele/public_html/administrator/components/com_awocoupon/models/coupons.php
    on line 57"

    "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/darksele/public_html/libraries/joomla/database/database/mysql.php on line 344"

    Installation check states all was successful


    Thanks
  • Your avatar
    seyi    
     6 years ago
    0

    Hello,

    Please run these statements on your mysql database:
    ALTER TABLE `jos_awocoupon` MODIFY `expiration` DATETIME;
    ALTER TABLE `jos_awocoupon` ADD COLUMN `startdate` DATETIME AFTER function_type2_mode;


    That should fix the problem.
  • Default avatar
    neal34    
     6 years ago
    0

    Sure did fix it :)

    Thanks for such speedy support.
  • Default avatar
    ricardo    
     5 years ago
    0

    ive tried the same fix. but still didnt work.

    mysql retrieve a message that startdate is a duplicated column
  • Default avatar
    ricardo    
     5 years ago
    0

    alright, i´ve done.

    but still getting the same error!!

    Warning: Invalid argument supplied for foreach() in /home/designu/www/administrator/components/com_awocoupon/models/coupons.php on line 57

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/designu/www/libraries/joomla/database/database/mysql.php on line 344

    Warning: Invalid argument supplied for foreach() in /home/designu/www/administrator/components/com_awocoupon/views/coupons/tmpl/default.php on line 57
  • Your avatar
    seyi    
     5 years ago
    0

    Sent you a private message. Please respond to that.
  • Default avatar
    jstiles    
     5 years ago
    0

    I had the exact same issue after an upgrade to Pro.

    The same fix worked for me.

    The tech support here is OUTSTANDING! I will use and recommend AWO without hesitation.