COMMUNITY FORUM

[SOLVED] Time zone issues

Ronny Van Der Borght
Offline
Senior Member

9 years 3 months ago #136542 by Ronny Van Der Borght

Replied by Ronny Van Der Borght on topic Time zone issues

There are certainly no overrides in the core component folder. I never do that, it is not upgrade safe.
I have turned on debugging now. Do you notice anything strange on: salario.be/dev/sociale-kalender ?

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

Lefteris
Offline
Moderator

9 years 3 months ago #136576 by Lefteris

Replied by Lefteris on topic Time zone issues

Execute the following queries with a tool like phpMyAdmin:

SELECT *
  FROM r2mgx_k2_items 
  WHERE YEAR(created)=2015 
  AND MONTH(created)=1 
  AND DAY(created)=14

SELECT *
  FROM r2mgx_k2_items 
  WHERE YEAR(created)=2015 
  AND MONTH(created)=1 
  AND DAY(created)=15

They will return the items for 14th and 15th of January. Look into the results the "created" field and verify that they match to what is printed in front-end.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

Ronny Van Der Borght
Offline
Senior Member

9 years 3 months ago #136587 by Ronny Van Der Borght

Replied by Ronny Van Der Borght on topic Time zone issues

Alright. I now see what is happening.

The value show in K2 Items for Date created is not the same as what is saved to the database. It is altered by the Joomla setting 'Server Time zone'.
So to see the real creation date that is saved to the database you need to check with PhpMyAdmin.
My problem was caused by a wrong time settings on the webserver, it seems it is using UTC time (although the control panel shows GMT+1) and my Joomla Time setting was also GMT+1. That created the difference, I now changed my Joomla setting to UTC and the problem is gone.

Thanks al you guys for your valuable tips !

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

Krikor Boghossian
Offline
Platinum Member

9 years 3 months ago #136602 by Krikor Boghossian

Replied by Krikor Boghossian on topic Time zone issues

You 're welcome Ronny,

I am sure a lot of users will benefit from this thread :)

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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