24 hour subscription and timezone issue

My client is using J2.5.14, CB 1.9, CBS 3.0.

We are based in Sydney Australia but use a hosting server in mid US. The Joomla Global Config | Server | Timezone is set to Sydney.

They are testing a 24 hour subscription, and find that a if such a subscriber logs in immediately after registration they see an expiry date/time of ten hours after the expected 24 hours. In the attached example the user registered at 13.35 on 2 Sep Sydney time and the Expiry Date/Time on the Memberships/Subscriptions tab shows 23.35 on 3 Sep. This incorrect time appears to indicate time in Sydney when the UTC reaches 13.35.


The backend record of the basket payment shows an incorrect time (10 hours later than Sydney time!).



The Status/Settings tab correctly shows the correct Online Member Since value.



The problem seems to be that the Expiry Time on the Subscriptions tab does not appropriately reflect the Sydney timezone offset. Changing the user time zone from Default to Sydney did not change anything.

The site was migrated from J1.5, and it from J1.0 if this is relevant. I note that in System Info | PHP are the following two entries:



Can provide login credentials for test site if required. Probably some setting at my or host end... :blush:

This is a known issue. The offset throws off the expiration calculation. They shouldn't be actually expired though as from what I can gather it's purely cosmetic. We've a bug ticket in place to fix for next release. Only workaround that I am aware of is to not use an offset and work off UTC time. CBSubs stores all its dates in UTC then applies offset on display. So subscription duration is always UTC based. You can check the UTC datetime of a subscription within CBSubs > Subscriptions then click the # under the ID column.