News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Coupon Expiration Date NOT Working.

Started by lydianp18, November 23, 2015, 03:04:09 AM

Previous topic - Next topic

lydianp18

VM 2.0.26d | J  2.5.18 (before you even ask - NO, we can't upgrade the site.  Too many core mods - and they weren't our idea...)

Coupons are still usable after their expiration dates... even if we "unpublish" them (click the checkbox and hit "unpublish" at the top).

Any idea as to why?

GJC Web Design

well.. could be a bug that has been fixed in the 100 or so versions since 2.0.26d

when u get hacked will you update then?   ;)
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

lydianp18

Thank you for being absolutely NO help.  It's not my choice not to upgrade - it's the clients.

jenkinhill

FFS nobody here would run such an old and insecure version to check, but since coupon expiry works with current versions somewhere down the line if it was a bug then it has been fixed.
Now you maybe see why we do not support core hacks.

You had this same problem a year ago so I guess it is not important. In any case z-analysts provided a workaround.    http://forum.virtuemart.net/index.php?topic=122378.msg435642#msg435642
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

lydianp18

That was a different client, we'd forgotten about it.  We ended up completely redoing their cart in a different system.  VM is never our first choice for a shopping cart system.

And let me stress, YET AGAIN, this was NOT our idea!  We're simply trying to find a solution for the client for an existing site they refuse to upgrade.

GJC Web Design

And I assume they are happy with their Windows 98, their php 4.0 and Android 2 on their phone.....

Tyres are bald and brakes shot but what the hell, will do for another year....

(must get that gas leak fixed one day)

You realise of course when they are hacked it will be u they blame?
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

trilogic.cz

here is the fix:
components/com_virtuemart/helpers/coupon.php
line 51
change
IFNULL( 0, IF( NOW() > `coupon_expiry_date`, 1, 0 )) AS ended
to
IFNULL( IF( NOW() > `coupon_expiry_date`, 1, 0 ), 0) AS ended

jenkinhill

@trilogic I have no idea what version your "fix" applies to, but this thread is 4 years old and the code you mention is considerably different in current versions.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum