[kronolith] adding an invitation to calendar results in DB error / reusing event_ids as a primary key

[Bernhard Erdmann]

Hi,

running current CVS checkout of Kronolith, I get a DB error when I try 
to add an invitation to my calendar.

"Beim Importieren des Termins ist ein Fehler aufgetreten: DB Error: 
already exists."

I use shared calendars. Person 1 (gl) registers an event and sends an 
invitation to person 2 (be). Person 2 looks it up using IMP, clicks on 
the attachment and on "add to my calendar".

Kronolith tries to store the event for person 2 in kronolith_events 
using the same event_id already used for the event. DB error because 
event_id is the table's primary key.


Jul 10 12:34:04 HORDE [debug] [kronolith] SQL event store by gl: query = 
"INSERT INTO kronolith_events (event_id, event_creator_id, event_title, 
event_description, event_category, event_location, event_status, 
event_attendees, event_keywords, event_exceptions, event_modified, 
event_start, event_end, event_alarm, event_recurtype, calendar_id)values 
('8dbcf601aaec8e781f2792005994bdb1','gl','FEG','','','Pforzheim','3','a:1:{s:14:\"be at berdmann.de\";a:2:{s:10:\"attendance\";s:1:\"2\";s:8:\"response\";i:1;}}','','',1089455644,'2004-07-11 
10:00:00','2004-07-11 12:00:00',0,'0','gl') " [on line 291 of 
"/opt/apache/htdocs/horde/kronolith/lib/Driver/sql.php"]

Jul 10 12:37:01 HORDE [debug] [kronolith] SQL event store by be: query = 
"INSERT INTO kronolith_events (event_id, event_creator_id, event_title, 
event_description, event_category, event_location, event_status, 
event_attendees, event_keywords, event_exceptions, event_modified, 
event_start, event_end, event_alarm, event_recurtype, 
event_recurinterval, event_recurenddate, event_recurdays, 
calendar_id)values 
('8dbcf601aaec8e781f2792005994bdb1','be','FEG','',0,'Pforzheim',2,'a:0:{}','','',1089455821,'2004-07-11 
10:00:00','2004-07-11 12:00:00',0,2,'1','99991231',1,'be') " [on line 
291 of "/opt/apache/htdocs/horde/kronolith/lib/Driver/sql.php"]

Jul 10 12:37:01 HORDE [error] [kronolith] DB Error: already exists: 
INSERT INTO kronolith_events (event_id, event_creator_id, event_title, 
event_description, event_category, event_location, event_status, 
event_attendees, event_keywords, event_exceptions, event_modified, 
event_start, event_end, event_alarm, event_recurtype, 
event_recurinterval, event_recurenddate, event_recurdays, 
calendar_id)values 
('8dbcf601aaec8e781f2792005994bdb1','be','FEG','',0,'Pforzheim',2,'a:0:{}','','',1089455821,'2004-07-11 
10:00:00','2004-07-11 12:00:00',0,2,'1','99991231',1,'be') 
[nativecode=1062 ** Duplicate entry '8dbcf601aaec8e781f2792005994bdb1' 
for key 1] [on line 295 of 
"/opt/apache/htdocs/horde/kronolith/lib/Driver/sql.php"]