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

[Lukas Haase]

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...

>> 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?

Regards,
Luke