[horde] Problem kronolith

[Ruud Baart]

Hi,

approximately 30,000 appointments are stored in the Horde database, 
roughly half of which do not have a time zone stored. That works fine in 
itself, but lately it has been causing problems in Thunderbird.

    horde6=# select count(*) from kronolith_events where event_timezone is null;
      count
    -------
      13677
    (1 row)

    horde6=# select count(*) from kronolith_events where event_timezone is not null;
      count
    -------
      17499
    (1 row)

If I have analyzed it correctly, this is because Thunderbird's calendar 
converts the null value to UTC in its cache (sqlite databases). That is 
not the correct value. So registering an event works fine, but when you 
reopen Thunderbird, the display is incorrect.

I would like to see Horde make a time zone mandatory when storing 
events. If the time zone is missing, it should take the time zone from 
the preferences, and if that is not possible, it should take the system 
time zone. I am not sure if my wish is already achievable through the 
configuration of Horde.

-- 

Cordialement,

*

R.J. Baart

*