[Tickets #401] NEW: invitations will not add to recipient's calendar. DB Error recieved

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

-Ticket 401
-Queue: Kronolith
-Created By: 


>From mpl at crito.net (Wed Jul 21 06:33:57 2004):
It appears that once the "add to calendar" option is chosen in the mime
viewer, the data from the .ics file gets inserted into the horde_events
table incorrectly, gets added again the right way but since the event_id
column is a primary key, the row will not get added since there already
exists the bad row that was initially added.

>From the horde log:
Jul 21 07:12:39 HORDE [debug] [kronolith] SQL event store by anon: 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 ('c2253a3b543fdd9130ac042513416a5f','ano
n','test from mpl','',0,'here in
load',2,'a:0:{}','','',1090408359,'2004-07-24 23:00:00','2004-07-25
00:00:00',0,0,'anon') " [on line 291 of
"/var/www/html/horde/kronolith/lib/Driver/sql.php"]
Jul 21 07:12:39 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, calendar_id)values
('c2253a3b543fdd9130ac042513416a5f','anon','test
 from mpl','',0,'here in load',2,'a:0:{}','','',1090408359,'2004-07-24
23:00:00','2004-07-25 00:00:00',0,0,'anon')  [nativecode=1062 ** Duplicate
entry 'c2253a3b543fdd9130ac042513416a5f' for key 1
] [on line 295 of "/var/www/html/horde/kronolith/lib/Driver/sql.php"]


>From the contents of the kronolith_events table:
mysql> select * from kronolith_events where
event_id='c2253a3b543fdd9130ac042513416a5f';
+----------------------------------+-------------+------------------+-------
------------+----------------+--------------+-------------------------------
----------------------------------------------+----------------+------------
------+---------------+----------------+-----------------+------------------
---+-----------------+--------------------+---------------------+-----------
----------+-------------+----------------+
| event_id                         | calendar_id | event_creator_id |
event_description | event_location | event_status | event_attendees         
                                                   | event_keywords |
event_exceptions | event_title   | event_category | event_recurtype |
event_recurinterval | event_recurdays | event_recurenddate | event_start    
    | event_end           | event_alarm | event_modified |
+----------------------------------+-------------+------------------+-------
------------+----------------+--------------+-------------------------------
----------------------------------------------+----------------+------------
------+---------------+----------------+-----------------+------------------
---+-----------------+--------------------+---------------------+-----------
----------+-------------+----------------+
| c2253a3b543fdd9130ac042513416a5f | mlanza      | mlanza           |       
           | here in load   |            2 |
a:1:{s:14:"anon at crito.net";a:2:{s:10:"attendance";i:1;s:8:"response";i:1;}}
|                |                  | test from mpl |                | 0    
          | NULL                | NULL            | NULL               |
2004-07-24 23:00:00 | 2004-07-25 00:00:00 |           0 |     1090408148 |
+----------------------------------+-------------+------------------+-------
------------+----------------+--------------+-------------------------------
----------------------------------------------+----------------+------------
------+---------------+----------------+-----------------+------------------
---+-----------------+--------------------+---------------------+-----------
----------+-------------+----------------+
1 row in set (0.00 sec)





http://bugs.horde.org/details.php?id=401

--