[SUBSCRIPTION_EXPIRY_DATE] error?

7 months 2 weeks ago #316648 by Thelowlandpiper
[SUBSCRIPTION_EXPIRY_DATE] error? was created by Thelowlandpiper
I have used the following in the subscription Thank-you Email body (subscription active):

"your subscription has been marked as expired since [SUBSCRIPTION_EXPIRY_DATE],"

the email output is "marked as expired since 31/12/2030"

The correct date of expiry was 04/12/2017

[I'm manually subscribing selected users to a special plan to cope with recurring payment issues]

Please Log in to join the conversation.

7 months 2 weeks ago #316657 by krileon
Replied by krileon on topic [SUBSCRIPTION_EXPIRY_DATE] error?
SUBSCRIPTION_EXPIRY_DATE directly pulls from the expiry_date column within the _cbsubs_subscriptions database table. This should then offset based off the timezone. Recommend verifying the expiry_date in the database.

[I'm manually subscribing selected users to a special plan to cope with recurring payment issues]

What recurring payment issues? Is this a bug in a payment gateway you're experiencing?


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

7 months 2 weeks ago #316671 by Thelowlandpiper
Replied by Thelowlandpiper on topic [SUBSCRIPTION_EXPIRY_DATE] error?
The problem has been caused by re-locating the website with a new database during the upgrade to joomla 3 some time ago; recurring payment subs created before the upgrade no longer send IPN's to the new database; I am trying to resolve the consequent problems; I realise that the cause of the issue I reported in this thread is that I am assigning affected users to a new plan and the activate email to inform them of the issue; this email reads the created date of the newly assigned plan - of course it does; I would need to be able to read the expired plan record; to get the expiry date of the old plan. I need to rethink the activate message; sorry for the trouble and thanks for the response.
Is there any way in which I could have avoided this whole problem when I first moved the site?

Please Log in to join the conversation.

7 months 2 weeks ago #316684 by krileon
Replied by krileon on topic [SUBSCRIPTION_EXPIRY_DATE] error?
Moving databases shouldn't cause issues with IPNs. What causes issues with IPNs is changing domain name since the IPN is just calling a URL on your site so if the domain name changes it won't be able to correctly reach your site. Only way a database move could cause problems is if when you moved your tables you renumbered the id columns causing the basket ids to no longer be correct. There's no real fixing this at this point if you already manually activated subscriptions as the original basket is now deactivated. My recommendation for those cases is just let the subscription expire and have your users resubscribe.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.505 seconds

Facebook Twitter LinkedIn