VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Development & Testing => Topic started by: nzed on October 10, 2014, 11:39:34 AM

Title: VM 2.9.9e: DB error when saving coupon code on cart page
Post by: nzed on October 10, 2014, 11:39:34 AM
This is the error text:
Error: 1146 - Table 'mydb.vm3j2_virtuemart_coupons' doesn't 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 `vm3j2_virtuemart_coupons` WHERE `coupon_code` = "MyCode"

Seems like a hard coded table prefix instead of '#_' in \components\com_virtuemart\helpers\coupon.php in line 58.
Yes, it solved the problem, coupon finally worked.  ;)
Title: Re: VM 2.9.9e: DB error when saving coupon code on cart page
Post by: Milbo on October 11, 2014, 20:31:28 PM
Yepp, thank you someone already notified me. Sunday/monday comes the F version. I am quite sure that we found then almost all bugfixes of bugfixes
Title: Re: VM 2.9.9e: DB error when saving coupon code on cart page
Post by: nzed on October 11, 2014, 21:03:49 PM
Quote from: Milbo on October 11, 2014, 20:31:28 PM
Sunday/monday comes the F version. I am quite sure that we found then almost all bugfixes of bugfixes

Yes, surely. What is your roadmap to issue 'official' VM3? Is it bound to J3.5?
Title: Re: VM 2.9.9e: DB error when saving coupon code on cart page
Post by: Milbo on October 11, 2014, 23:44:46 PM
No, it is completly independent. Atm I aim mid of Oktober. It looks like the F version released internally seems very well.