Skip to Content Skip to Menu

🕒 Save Time and Effort with CB Editor Assistant: Effortlessly create and refine content in Joomla 3, 4, & 5.
🎁 Limited Offer: Enjoy a 5-day FREE trial and save up to 30% afterward!

[SOLVED] Renewing subscription in back-end doesn't update last_renewed_date

  • petekuhn
  • petekuhn
  • OFFLINE
  • Posts: 239
  • Thanks: 34
  • Karma: 0
7 years 10 months ago - 7 years 10 months ago #292157 by petekuhn
Joomla 3.6.5 Stable
PHP 5.6.30
MySQL 5.6.28-76
CB 2.1.2
CBSubs 4.1.0

This used to work. If I renew a member's subscription in the back-end, it doesn't update the last_renewed_date in the #__cbsubs_subscriptions table, although it does set status and expiry_date correctly.

This is a problem for us, as we key off last_renewed_date to do some processing on recently renewed subscriptions, which could be done in either the front-end or the back-end. If there's a better way to do this, please advise.

TIA.
Last edit: 7 years 10 months ago by krileon. Reason: Added [SOLVED] tag to subject

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48709
  • Thanks: 8319
  • Karma: 1447
7 years 10 months ago #292179 by krileon
Worked perfectly fine in my tests. See the below.

Before:


After:


Was the plan already expired or was it a renewal of an already active subscription?


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.
Attachments:
The following user(s) said Thank You: petekuhn

Please Log in or Create an account to join the conversation.

  • petekuhn
  • petekuhn
  • OFFLINE
  • Posts: 239
  • Thanks: 34
  • Karma: 0
7 years 10 months ago #292195 by petekuhn
Looking closer at it, I think this is an edge case. I hadn't noticed in my testing that the user already had an active subscription of a different type. When I renewed the second subscription, it didn't set the date_last_renewed.

I tested with a "clean" user, and it all worked.

Thanks.
The following user(s) said Thank You: krileon

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum