[kronolith] timezone and data upload from older version

[Jan Schneider]

Zitat von LALOT Dominique <dom.lalot at gmail.com>:

> Hi,
>
> I just discovered that I have  a problem when uploading data from my
> production (kronolith 2.3.2) to my horde4 (kronolith 3.0.5)  test server. I
> just get a 2 hours shift from GMT when displaying events. For me, I believed
> it was OK until I looked at the hours when  getting duplicates.
>
> I looked both at the data coming from my sql dump and look at event_start in
> mysql (which is a string not a timestamp)
>
> sql dump from origin
> 'lalot','','Pharo',2,'a:0:{}','',NULL,'xxxx
> Pharo','Professionnel',0,NULL,NULL,NULL,'2011-07-12 10:00:00','2011-07-12
> 18:00:00',0,1311084572,0,NULL
>
> in mysql in horde4 side using phpmyadmin:
> event_start:
> 2011-07-12 10:00:00
>
>> From my prod server
> root at ent1:~# date
> mardi 19 juillet 2011, 17:04:58 (UTC+0200)
>
> on my test system:
> root at horde4:/var/www/horde/kronolith/config# date
> mardi 19 juillet 2011, 17:05:20 (UTC+0200)
>
> When the event is displayed in kronolith 3.0.5, the GMT shift is added, so
> my event starts at 12 instead of 10.
>
> I have no idea, as the date, timezone are the same. Just a little bit
> surprised that date are strings whithout timezone info in the database (so
> they should be GMT). The question is: why is my prod server display the same
> event whitout timezone..
> Don't understand what is wrong!
> One version is considering the same data as local the other one is storing
> as GMT (good option anyway). If I create a new event, the ascii string is
> stored as GMT.
> Is there an easy way to convert and what coudl be wrong?

http://www.horde.org/apps/kronolith/docs/UPGRADING#utc-timestamps

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/