Skip to Content Skip to Menu

GroupJive Event Time is wrong. frontend does not match backend fields due to time saving

9 years 6 months ago - 9 years 6 months ago #277038 by joebrickley
Hello,
Joomla 3.4.8 CB 2.0.12 Groupjive 3

I have realised that groupjive events do not show the correct time in the frintend events tab, during British Summertime ( BST ). They show an hour ahead of the time saved in the groupjive event start and end fields.

Am I missing a setting here somewhere or is this a bug ?
Thanks

Joe
Last edit: 9 years 6 months ago by joebrickley.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 49441
  • Thanks: 8467
  • Karma: 1465
9 years 6 months ago - 9 years 6 months ago #277065 by krileon
The datetime is stored in the database as UTC (no offset). You are selecting the datetime based off your local datetime. When it's displayed in the tab it is then offset based off the timezone your account has set otherwise uses Joomlas. In short you should always see it as local.

Please provide the timezone you've selected in Joomla global configuration and within your users profile edit. Please also provide the datetime you have stored in the _groupjive_events for your event that is off by 1 hour. This will allow me to attempt to duplicate your scenario exactly.

I believe "Europe/London" needs to be used if you want it to switch between BST as needed. Note this is typically entirely dependent on PHP doing the switch. Please also provide your PHP version and contact your host to ensure the timezone database is up to date.


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.
Last edit: 9 years 6 months ago by krileon.

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

9 years 6 months ago #277105 by joebrickley
Hi Krileon,
The global configuration server time is set to London,
user timezone is also set to london.
PHP 5.5.31
I've attached a screenshot showing back and front end for one of the affected dates. All events between Sun, 27 Mar & Sun, 30 Oct, appear affected. Also a strange thing is that with Mays event ( only this one) the calendar on the left of the event is showing as June!

I will check with host re timezone database.
Many thanks
Attachments:

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 49441
  • Thanks: 8467
  • Karma: 1465
9 years 6 months ago #277123 by krileon
Please have your host ensure their timezone database is up to date. Latest releases can be found below.

pecl.php.net/package/timezonedb

It should be up to date, but it's strange your dates are incorrect. Try adding a datetime field to your profile and seeing if it has the same issue.


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 or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum