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
Hi,
Did you find the solution because I have the same problem... ?
Thanks a lot,
Regards,
Jérôme
Hi,
I found a solution:
http://forum.virtuemart.net/index.php?topic=129750.msg446726#msg446726
Jerome