- Posts: 73
- Thank you received: 2
Subscription Renewal Record End Date does not Match Previous Start Date
- Elliot Block
- Topic Author
- Offline
- Senior Member
-
Less
More
2 years 3 months ago #156004
by Elliot Block
Subscription Renewal Record End Date does not Match Previous Start Date was created by Elliot Block
Tuan,
I have a question about subscription records and what should happen when a renewal occurs.
In our case, we have a plan with:
Subscription Length: 1 year
Enable Renewal: Yes
When I renew my own membership (for next year) as a test, the start date (GUI) is 12/31/2023 16:00:00 and the subscription end date (GUI) is 12/31/2024 23:59:59.
The values for the subscription record in the database are:
from_date (database): 2024-01-01 00:00:00
to_date (database): 2025-01-01 07:59:59
Why is the membership record start date (GUI) not 1/1/2024 00:00:00 [or from_date (database) 2024-01-01 08:00:00]?
Incidentally, we are in the UTC-8 time zone (the Global Configuration for Joomla is set to "Los Angeles").
Is there something I forgot to setup? It would be nice for the records to be appropriately aligned with one another.
Thanks!
Elliot
I have a question about subscription records and what should happen when a renewal occurs.
In our case, we have a plan with:
Subscription Length: 1 year
Enable Renewal: Yes
When I renew my own membership (for next year) as a test, the start date (GUI) is 12/31/2023 16:00:00 and the subscription end date (GUI) is 12/31/2024 23:59:59.
The values for the subscription record in the database are:
from_date (database): 2024-01-01 00:00:00
to_date (database): 2025-01-01 07:59:59
Why is the membership record start date (GUI) not 1/1/2024 00:00:00 [or from_date (database) 2024-01-01 08:00:00]?
Incidentally, we are in the UTC-8 time zone (the Global Configuration for Joomla is set to "Los Angeles").
Is there something I forgot to setup? It would be nice for the records to be appropriately aligned with one another.
Thanks!
Elliot
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
2 years 3 months ago #156006
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Subscription Renewal Record End Date does not Match Previous Start Date
It is something with timezone handling here. Basically, the data stored in database is in UTC timezone, while the value displayed in GUI is using your site timezone
I guess the issue happens here is because the end date of the previous subscription record stored in database is 2023-12-31 23:59:59, so the start date of the renewal record is 2024-01-01 00:00:00
I will have to check and make sure 2023-12-31 23:59:59 is saved to the database with right value (2023-12-31 15:59:59) since your site timezone is GMT - 8 and it will address the concern
Will update you if I figured out something
Tuan
I guess the issue happens here is because the end date of the previous subscription record stored in database is 2023-12-31 23:59:59, so the start date of the renewal record is 2024-01-01 00:00:00
I will have to check and make sure 2023-12-31 23:59:59 is saved to the database with right value (2023-12-31 15:59:59) since your site timezone is GMT - 8 and it will address the concern
Will update you if I figured out something
Tuan
Please Log in or Create an account to join the conversation.
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.