Error Messages Following New Clean Install

neal34
13 years ago
0 +0 / -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
seyi
13 years ago
0 +0 / -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.
Regards
neal34
13 years ago
0 +0 / -0

Sure did fix it :)

Thanks for such speedy support.
ricardo
13 years ago
0 +0 / -0

ive tried the same fix. but still didnt work.

mysql retrieve a message that startdate is a duplicated column
ricardo
13 years ago
0 +0 / -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
seyi
13 years ago
0 +0 / -0

Sent you a private message. Please respond to that.
Regards
jstiles
13 years ago
0 +0 / -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.