Coupon Issue

[gsstephens]

Even when using the default coupon that comes loaded I still get this error: Coupon Error: Data could not be fetched.  along with the error i have this output:

TABLE 'WWWCOAST_COASTAL2.NWGCU_VIRTUEMART_GENERATEDCOUPON' DOESN'T EXIST SQL=SELECT IF( NOW() >= `COUPON_START_DATE` , 1, 0 ) AS STARTED , `COUPON_START_DATE` , IFNULL( 0, IF( NOW() > `COUPON_EXPIRY_DATE`, 1, 0 )) AS ENDED , `COUPON_VALUE_VALID` FROM `NWGCU_VIRTUEMART_COUPONS` WHERE `COUPON_CODE` = '' UNION SELECT IF( NOW() >= FROM_UNIXTIME(VALID_FROM,'%Y-%M-%D %H:%I:%S') , 1, 0 ) AS STARTED, FROM_UNIXTIME(VALID_FROM,'%Y-%M-%D %H:%I:%S') AS COUPON_START_DATE, IFNULL( 0, IF( NOW() > FROM_UNIXTIME(VALID_TILL,'%Y-%M-%D %H:%I:%S'), 1, 0 )), MINAMOUNT AS COUPON_VALUE_VALID FROM NWGCU_VIRTUEMART_GENERATEDCOUPON WHERE NAME='' AND PUBLISHED=1 AND REMAIN_USE>0

I'm running:

PHP Built On   Linux vps.bigmonster.biz 2.6.32-504.12.2.el6.x86_64 #1 SMP Wed Mar 11 22:03:14 UTC 2015 x86_64
Database Version   5.5.42-MariaDB
Database Collation   utf8_general_ci
PHP Version   5.4.39
Web Server   Apache
WebServer to PHP Interface   apache2handler
Joomla! Version   Joomla! 3.3.6 Stable [ Ember ] 01-October-2014 02:00 GMT
Joomla! Platform Version   Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent   Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_3) AppleWebKit/600.5.17 (KHTML, like Gecko) Version/8.0.5 Safari/600.5.17

VirtueMart 3.0.4


I'm running:

PHP Built On   Linux vps.bigmonster.biz 2.6.32-504.12.2.el6.x86_64 #1 SMP Wed Mar 11 22:03:14 UTC 2015 x86_64
Database Version   5.5.42-MariaDB
Database Collation   utf8_general_ci
PHP Version   5.4.39
Web Server   Apache
WebServer to PHP Interface   apache2handler
Joomla! Version   Joomla! 3.3.6 Stable [ Ember ] 01-October-2014 02:00 GMT
Joomla! Platform Version   Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent   Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_3) AppleWebKit/600.5.17 (KHTML, like Gecko) Version/8.0.5 Safari/600.5.17

VirtueMart 3.0.4

[jhautier]

Hi,

Did you find the solution because I have the same problem... ?

Thanks a lot,

Regards,

Jérôme

[jhautier]

Hi,

I found a solution:
http://forum.virtuemart.net/index.php?topic=129750.msg446726#msg446726

Jerome