error on coupon

[giangot]

Hi all

when I try to enter a discount coupon I get the following error message.

1305 FUNCTION Sqlxxxx_1.IFNULL does not exist SQL=SELECT IFNULL( NOW() >= `coupon_start_date` OR `coupon_start_date`="0000-00-00 00:00:00" , 1 ) AS started , `coupon_start_date` , IFNULL (`coupon_expiry_date`!="0000-00-00 00:00:00" and NOW() > `coupon_expiry_date`,0) AS `ended` , `coupon_expiry_date` , `coupon_value_valid` , `coupon_used` FROM `fdx3t_virtuemart_coupons` WHERE `coupon_code` = "panta"

I address you as the same site transferred to my hard drive or NAS on my home network works perfectly, I hope you can help me.

Giampiero

Joomla version 3.3.6
VM version 3.0.6

[jhautier]

Hi,

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

Thanks :-)

Jerome

[jhautier]

Hi,

This is a solution:

http://forum.virtuemart.net/index.php?topic=129750.msg446726#msg446726

Jerome