6.0.0-beta1
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
8/15/25
H
istory
A
ttachments
C
omment
W
atch
Download
Comment on [#368] adding an invitation to calendar results in DB error / reusing event_ids as a primary key
*
Your Email Address
*
Spam protection
Enter the letters below:
. ..__..___ .. . |__|| |[__ || | | ||__\[___\__||/\|
Comment
> 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@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"] > >
Attachment
Watch this ticket
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers