[kronolith] Kronolith with iCal r/w or task support or ... or ...

[Jan Schneider]

Zitat von Lukas Haase <lukashaase at gmx.at>:

> Hi,
>
> Thanks for reply
>
> Jan Schneider wrote:
>> Zitat von Lukas Haase <lukashaase at gmx.at>:
>>> My wish would be to
>>> * Use a calender and task list with Lightning
>>> * Use this calender and tasks with kronolith
>>> * Both with write support
>>> * In one calender (on Thunderbird/Lighting side)
>> [...]
>> All of this is possible, beside having events and tasks in one calendar.
>
> Ok, that is a pity although it is just esthetically.
>
> However, are there reasons why not combine them with the same API?
> In fact iCalender allows to have TODOs and events in one file...

That's because they are (still) completely separate application in Horde.

>>> So far it works good to share the calender with Thunderbird. But  
>>> the tasks do not work. I have to create a separate calender just  
>>> for the tasks (access to nag)! And even if I do that there seem to  
>>> be huge bugs with write access on nag (tasks created with horde  
>>> are not displayed in Lighting and the next task created with  
>>> lighting just overwrites the last task created with nag). So this  
>>> is a no-go.
>> [...]
>> Well, this is definitely a bug, and the solution is not to look for  
>> a different solution, but to report this bug and steps to reproduce  
>> it on the bug tracker.
>
> Once more I am just fed up with Debian! AAARGH. Very old and the so  
> called "stable" distribution is never stable in fact.
>
> In fact the buggy Debian "stable" version has this bug enabled:
>
> http://bugs.horde.org/ticket/6947
>
> My problem I described above was the following: I began the tests  
> with an empty TODO list, created TODOs, everything worked.
>
> But then, as the TODO list filled up, I got the bug from above in  
> the log causing Thunderbird to not receive the updates I did from  
> Horde.
>
> However, adding a new Task in Thunderbird caused the cached items to  
> be uploaded to horde where everything was overwritten.
>
> I did "aptitude purge nag2" which was a really good idea and  
> downloaded the latest stable from the horde homepage.
>
> I hope there is no problem with Debians horde/imp4 + new stable nag.
>
> I also found that I get lots of stuff like that:
>
> Dec 22 19:32:51 HORDE [error] [kronolith] DB Error: syntax error:  
> SELECT event_id, event_uid, calendar_id, event_description,  
> event_locatio
> n, event_private, event_status, event_attendees, event_keywords,  
> event_title, event_category, event_recurcount, event_recurtype,  
> event_recu
> renddate, event_recurinterval, event_recurdays, event_start,  
> event_end, event_alarm, event_modified, event_exceptions,  
> event_creator_id FRO
> M kronolith_events WHERE event_uid = ? AND calendar_id IN (?)  
> [nativecode=1064 ** You have an error in your SQL syntax; check the  
> manual th
> at corresponds to your MySQL server version for the right syntax to  
> use near '? AND calendar_id IN (?)' at line 1] [pid 12580 on line  
> 432 o
> f "/usr/share/horde3/kronolith/lib/Driver/sql.php"]
>
>
> I did not find anything with google but I am sure that Debian  
> "stable" also contains a buggy version of Kronolith. So I also  
> purged kronolith2 and downloaded the latest stable.
>
> Now the logs are quiet.
>
>
> However apart from this I found problems with UTF8: When I create  
> entried for example with Japanese characters in Thunderbird the  
> items are just called ????? in Kronolith.
>
> The other way round, when I create an appointment with UTF8 named in  
> Kronolith they get somehow weird escaped. The wonderful Japanese  
> christmas becomes: &#12463;&#12522;&#12473;&#12510;&#12473;
>
> Maybe it is enough to just add utf8_encode/decode?

Did you configure the a compatible charset, e.g. UTF-8 for the  
database backend?

Jan.

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