[Tickets #368] NEW: adding an invitation to calendar results in DB
error / reusing event_ids as a primary key
bugs at bugs.horde.org
bugs at bugs.horde.org
Sat Jul 10 04:59:27 PDT 2004
DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.
-Ticket 368
-Queue: Kronolith
-Created By:
>From be at berdmann.de (Sat Jul 10 04:59:27 2004):
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"]
http://bugs.horde.org/details.php?id=368
--
More information about the bugs
mailing list