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

[Daniel Eckl]

Hi Bernhard!

You didn't update the mysql tables through some horde changes.

Look at the sql generation scripts and compare the data type of the
event_id field with that in your database.

Greets,
Daniel

Zitat von Bernhard Erdmann <be at berdmann.de>:

> 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"]
> --
> Kronolith mailing list - Join the hunt: http://horde.org/bounties/#kronolith
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org