well, apart from solving problems to insert into the database (maybe with a trigger or better schema) can be a small fix in the script that displays the records (timeline.php), yes I know that is not a solution but at least fixes the output:

-$sql = "select * from events where event_tstamp >= $from order by event_tstamp desc";
+$sql = "select distinct * from events where event_tstamp >= $from order by event_tstamp desc";

Thanks, tried this today but it doesn't work, the multiple entries are still there

this one worked and dups are gone:

-$sql = "select * from events where event_tstamp >= $from order by event_tstamp desc";
+$sql = "select distinct event_date, event_description, event_notes, event_type, event_time from events where event_tstamp >= $from order by event_tstamp desc";

Thanks Jose, I've applied your fix, it works just fine. Not sure if we should try to fix the cause of the duplicates in tlcacher.php?

sure, and IMHO we should keep this ticket still as open

also there are some things that could be improved too:

- fix flyspray entries
every new task line is preceded by a 'modified' line like this:
19:23 New task 651 opened by sepen: [pekwm] new version 0.1.12 available
19:23 Task 651 modified by sepen
also we could try to use the $realname provided by flyspray instead of the $nickname

- markup for FS#$BUG_ID
20:50 b091..b2c0 committed by Juergen Daubert: zlib: fix for  FS#588 
in the line above,  FS#588  could be replaced by:
Task <a class='urllink' href='http://crux.nu/bugs/?do=details&amp;task_id=588' title='' rel='nofollow'>588</a>

- markup for [notify] lines:
we could point every notify line to his mailinglist URL

Hello Jose,

I implemented your suggestions for real names to be attached to flyspray
logs in our timelines (instead of nicknames) and rebuilt the whole timeline.db
to reflect this change. Enjoy ;)