| Summary | Move Event from one calendar to another (CalDAV) |
| Queue | Kronolith |
| Queue Version | Git master |
| Type | Bug |
| State | Resolved |
| Priority | 2. Medium |
| Owners | jan (at) horde (dot) org |
| Requester | heidrich (at) ukw-freiburg (dot) de |
| Created | 04/09/2014 (4122 days ago) |
| Due | |
| Updated | 06/04/2014 (4066 days ago) |
| Assigned | 05/27/2014 (4074 days ago) |
| Resolved | 06/04/2014 (4066 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | Horde_Dav 1.0.7 |
| Patch | No |
State ⇒ Resolved
Milestone ⇒ Horde_Dav 1.0.7
commit 626fa5477651b782a90d6c7981ec094791ed2c59
Author: Jan Schneider <jan@horde.org>
Date: Wed Jun 4 14:59:54 2014 +0200
Don't create unique index on id_external.
Moving objects is done per PUT-DELETE-sequence by some clients,
which requires
duplicate external object UIDs. Use a simple index instead and
disallow the
same external UID twice in a collection instead.
Bug: 13102.../Horde/Dav/2_horde_dav_remove_unique_index.php | 43
++++++++++++++++++++
framework/Dav/package.xml | 10 +++--
2 files changed, 49 insertions(+), 4 deletions(-)
http://github.com/horde/horde/commit/626fa5477651b782a90d6c7981ec094791ed2c59
movement is successful. If I try to move the event back to the
original calendar, the following is logged by Horde:
2014-06-02T15:21:06+02:00 ERR: HORDE-5.2beta [kronolith] SQL QUERY
FAILED: SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key
value violates unique constraint
"index_horde_dav_objects_on_id_external"
INSERT INTO horde_dav_objects (id_internal, id_external,
id_collection) VALUES ('JzF5K79h6_z3tZUTwzRshA1',
'20140602151930.ZPnk4YJchy0XulMqfT_E8g1@_______________.ics
', 'C6CSbyqpQfeoypw5YGb7ag2') [pid 3717 on line 204 of
"/var/www/horde-5.2beta/pear/php/Horde/Db/Adapter/Pdo/Base.php"]
CalDAV-Client is Thunderbird/Lightning
State ⇒ Feedback
requests, and the debug log from Horde.
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Move Event from one calendar to another (CalDAV)
Queue ⇒ Kronolith
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
(also subscribed via CalDAV) the CalDAV Server throws an
"CalDAVMoveEntityQueueableOperation" error. And in the log file you
can see that the SQL query has failed:
SQL QUERY FAILED: SQLSTATE[23000]: Integrity constraint violation:
1062 Duplicate entry '9F52A8BA-5C65-424F-B30D-45078B626251.ics' for
key 'index_horde_dav_objects_on_id_external'
INSERT INTO horde_dav_objects (id_internal, id_external, id_collection)
VALUES ('BMIcN77OOsEvB-IzFlaWRA1',
'9F52A8BA-5C65-424F-B30D-45078B626251.ics', 'tme-LL9Shfy_MHL6Mf4Y3w9')