[Tickets #14021] Re: cannot modify/delete external caldav events

noreply at bugs.horde.org noreply at bugs.horde.org
Mon Jun 22 06:10:34 UTC 2015


BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: https://bugs.horde.org/ticket/14021
------------------------------------------------------------------------------
  Ticket           | 14021
  Aktualisiert Von | martin1 at k0k.net
  Zusammenfassung  | cannot modify/delete external caldav events
  Warteschlange    | Kronolith
  Version          | 4.2.8
  Typ              | Bug
  Status           | Feedback
  Priorität        | 1. Low
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


martin1 at k0k.net (2015-06-22 06:10) hat geschrieben:

I cannot see much in the horde debug logs either (does it log the  
calls to davical at all?)

This is where the davical event is created:

2015-06-21T09:49:09+02:00 DEBUG: HORDE5 [kronolith] SQL  (0,0014s)
	SELECT object_id, object_name FROM `rampage_objects` WHERE object_name
	  IN ('') AND type_id = 2 [pid 26317 on line 321 of  
"/usr/share/php/Horde/Db/Adapter/Mysqli.php"]
2015-06-21T09:49:09+02:00 DEBUG: HORDE5 [kronolith] SQL  (0,0013s)
	SELECT MAX(history_ts) FROM horde_histories WHERE history_action =
	  'add' AND object_uid =
	  'kronolith:http://localhost/davical/caldav.php/martin/calendar:55866c7
	  5-3a94-41ab-a70b-66cd00000000' [pid 26317 on line 321 of  
"/usr/share/php/Horde/Db/Adapter/Mysqli.php"]
2015-06-21T09:49:09+02:00 DEBUG: HORDE5 [kronolith] SQL  (0,0012s)
	SELECT MAX(history_ts) FROM horde_histories WHERE history_action =
	  'modify' AND object_uid =
	  'kronolith:http://localhost/davical/caldav.php/martin/calendar:55866c7
	  5-3a94-41ab-a70b-66cd00000000' [pid 26317 on line 321 of  
"/usr/share/php/Horde/Db/Adapter/Mysqli.php"]
2015-06-21T09:49:09+02:00 DEBUG: HORDE5 [kronolith] SQL  (0,0008s)
	SELECT x(event_coordinates) as lat, y(event_coordinates) as lon,
	  event_zoom as zoom FROM kronolith_events_mysqlgeo WHERE event_id =
	  '55866c75-3a94-41ab-a70b-66cd00000000.ics' [pid 26317 on line 321  
of "/usr/share/php/Horde/Db/Adapter/Mysqli.php"]
2015-06-21T09:49:09+02:00 DEBUG: HORDE5 [kronolith] SQL  (0,0009s)
	DELETE FROM horde_alarms WHERE alarm_id =
	  '55866c75-3a94-41ab-a70b-66cd00000000' [pid 26317 on line 321 of  
"/usr/share/php/Horde/Db/Adapter/Mysqli.php"]
2015-06-21T09:49:09+02:00 DEBUG: HORDE5 [kronolith] SQL  (0,0015s)
	SELECT alarm_id, alarm_uid, alarm_start, alarm_end, alarm_methods,
	  alarm_params, alarm_title, alarm_text, alarm_snooze, alarm_internal
	  FROM horde_alarms WHERE alarm_dismissed = 0 AND ((alarm_snooze IS NULL
	  AND alarm_start <= '2015-06-21 07:49:09') OR alarm_snooze <=
	  '2015-06-21 07:49:09') AND (alarm_end IS NULL OR alarm_end >=
	  '2015-06-21 07:49:09') AND (alarm_uid IS NULL OR alarm_uid = '' OR
	  alarm_uid = 'martin') ORDER BY alarm_start, alarm_end [pid 26317 on  
line 321 of "/usr/share/php/Horde/Db/Adapter/Mysqli.php"]

And here I open it again and try to delete it:

2015-06-21T09:49:13+02:00 DEBUG: HORDE5 [kronolith] SQL  (0,0008s)
	SELECT object_id, object_name FROM `rampage_objects` WHERE object_name
	  IN ('55866c75-3a94-41ab-a70b-66cd00000000') AND type_id = 2 [pid  
26317 on line 321 of "/usr/share/php/Horde/Db/Adapter/Mysqli.php"]
2015-06-21T09:49:13+02:00 DEBUG: HORDE5 [kronolith] SQL  (0,0003s)
	SELECT x(event_coordinates) as lat, y(event_coordinates) as lon,
	  event_zoom as zoom FROM kronolith_events_mysqlgeo WHERE event_id =
	  'ical0' [pid 26317 on line 321 of  
"/usr/share/php/Horde/Db/Adapter/Mysqli.php"]
2015-06-21T09:49:13+02:00 DEBUG: HORDE5 [kronolith] SQL  (0,0017s)
	SELECT alarm_id, alarm_uid, alarm_start, alarm_end, alarm_methods,
	  alarm_params, alarm_title, alarm_text, alarm_snooze, alarm_internal
	  FROM horde_alarms WHERE alarm_dismissed = 0 AND ((alarm_snooze IS NULL
	  AND alarm_start <= '2015-06-21 07:49:13') OR alarm_snooze <=
	  '2015-06-21 07:49:13') AND (alarm_end IS NULL OR alarm_end >=
	  '2015-06-21 07:49:13') AND (alarm_uid IS NULL OR alarm_uid = '' OR
	  alarm_uid = 'martin') ORDER BY alarm_start, alarm_end [pid 26317 on  
line 321 of "/usr/share/php/Horde/Db/Adapter/Mysqli.php"]
2015-06-21T09:49:13+02:00 DEBUG: HORDE5 [kronolith] Max memory usage:  
1835008 bytes [pid 26317 on line 609 of  
"/usr/share/php/Horde/Registry.php"]
2015-06-21T07:49:13+00:00 DEBUG: HORDE5 Load config file (conf.php;  
app: horde) [pid 26317 on line 109 of  
"/usr/share/php/Horde/Registry/Loadconfig.php"]
2015-06-21T07:49:13+00:00 DEBUG: HORDE5 [kronolith] Load config file  
(conf.php; app: kronolith) [pid 26317 on line 109 of  
"/usr/share/php/Horde/Registry/Loadconfig.php"]
2015-06-21T07:49:13+00:00 DEBUG: HORDE5 [kronolith]  
Horde_HashTable_Memory: Deleted keys  
(hht_hht_horde|nhBAMPnKLeBYAi2RBUIwfKh|martin||horde) [pid 26317 on  
line 129 of "/usr/share/php/Horde/HashTable/Base.php"]
2015-06-21T07:49:13+00:00 DEBUG: HORDE5 [kronolith]  
Horde_HashTable_Memory: Non-existent keys  
(horde|nhBAMPnKLeBYAi2RBUIwfKh|martin||horde) [pid 26317 on line 240  
of "/usr/share/php/Horde/HashTable/Base.php"]
2015-06-21T09:49:13+02:00 DEBUG: HORDE5 [kronolith]  
Horde_HashTable_Memory: Deleted keys  
(hht_hht_kronolith.tagger.type_ids) [pid 26317 on line 129 of  
"/usr/share/php/Horde/HashTable/Base.php"]
2015-06-21T09:49:13+02:00 DEBUG: HORDE5 [kronolith]  
Horde_HashTable_Memory: Deleted keys  
(hht_hht_kronolith.tagger.type_ids_t) [pid 26317 on line 129 of  
"/usr/share/php/Horde/HashTable/Base.php"]
2015-06-21T09:49:13+02:00 DEBUG: HORDE5 [kronolith]  
Horde_HashTable_Memory: Non-existent keys  
(kronolith.tagger.type_ids,kronolith.tagger.type_ids_t) [pid 26317 on  
line 240 of "/usr/share/php/Horde/HashTable/Base.php"]
2015-06-21T09:49:13+02:00 DEBUG: HORDE5 [kronolith] SQL  (0,0003s)
	SELECT user_id, user_name FROM `rampage_users` WHERE user_name IN
	  ('martin') [pid 26317 on line 321 of  
"/usr/share/php/Horde/Db/Adapter/Mysqli.php"]
2015-06-21T09:49:13+02:00 DEBUG: HORDE5 [kronolith] SQL  (0,0003s)
	SELECT t.tag_id AS tag_id, tag_name, count FROM `rampage_tagged`
	  tagged INNER JOIN `rampage_tags` t ON tagged.tag_id = t.tag_id INNER
	  JOIN `rampage_user_tag_stats` uts ON t.tag_id = uts.tag_id AND
	  uts.user_id = 2 GROUP BY t.tag_id, tag_name, count ORDER BY count DESC
	  LIMIT 10 [pid 26317 on line 321 of  
"/usr/share/php/Horde/Db/Adapter/Mysqli.php"]
2015-06-21T09:49:13+02:00 DEBUG: HORDE5 [kronolith] SQL  (0,0004s)
	SELECT alarm_id, alarm_uid, alarm_start, alarm_end, alarm_methods,
	  alarm_params, alarm_title, alarm_text, alarm_snooze, alarm_internal
	  FROM horde_alarms WHERE alarm_dismissed = 0 AND ((alarm_snooze IS NULL
	  AND alarm_start <= '2015-06-21 07:49:13') OR alarm_snooze <=
	  '2015-06-21 07:49:13') AND (alarm_end IS NULL OR alarm_end >=
	  '2015-06-21 07:49:13') AND (alarm_uid IS NULL OR alarm_uid = '' OR
	  alarm_uid = 'martin') ORDER BY alarm_start, alarm_end [pid 26317 on  
line 321 of "/usr/share/php/Horde/Db/Adapter/Mysqli.php"]
2015-06-21T09:49:13+02:00 DEBUG: HORDE5 [kronolith] Max memory usage:  
1572864 bytes [pid 26317 on line 609 of  
"/usr/share/php/Horde/Registry.php"]
2015-06-21T07:49:17+00:00 DEBUG: HORDE5 Load config file (conf.php;  
app: horde) [pid 26317 on line 109 of  
"/usr/share/php/Horde/Registry/Loadconfig.php"]
2015-06-21T07:49:17+00:00 DEBUG: HORDE5 [kronolith] Load config file  
(conf.php; app: kronolith) [pid 26317 on line 109 of  
"/usr/share/php/Horde/Registry/Loadconfig.php"]
2015-06-21T07:49:17+00:00 DEBUG: HORDE5 [kronolith]  
Horde_HashTable_Memory: Deleted keys  
(hht_hht_horde|nhBAMPnKLeBYAi2RBUIwfKh|martin||horde) [pid 26317 on  
line 129 of "/usr/share/php/Horde/HashTable/Base.php"]
2015-06-21T07:49:17+00:00 DEBUG: HORDE5 [kronolith]  
Horde_HashTable_Memory: Non-existent keys  
(horde|nhBAMPnKLeBYAi2RBUIwfKh|martin||horde) [pid 26317 on line 240  
of "/usr/share/php/Horde/HashTable/Base.php"]
2015-06-21T09:49:17+02:00 DEBUG: HORDE5 [kronolith] SQL  (0,0017s)
	SELECT alarm_id, alarm_uid, alarm_start, alarm_end, alarm_methods,
	  alarm_params, alarm_title, alarm_text, alarm_snooze, alarm_internal
	  FROM horde_alarms WHERE alarm_dismissed = 0 AND ((alarm_snooze IS NULL
	  AND alarm_start <= '2015-06-21 07:49:17') OR alarm_snooze <=
	  '2015-06-21 07:49:17') AND (alarm_end IS NULL OR alarm_end >=
	  '2015-06-21 07:49:17') AND (alarm_uid IS NULL OR alarm_uid = '' OR
	  alarm_uid = 'martin') ORDER BY alarm_start, alarm_end [pid 26317 on  
line 321 of "/usr/share/php/Horde/Db/Adapter/Mysqli.php"]

Davical sees:

[Sun Jun 21 09:49:09.127830 2015] [:error] [pid 26313] [client  
127.0.0.1:45166] davical: LOG: :PUT  
/davical/caldav.php/martin/calendar/55866c75-3a94-41ab-a70b-66cd00000000.ics

(...)

[Sun Jun 21 09:49:13.613334 2015] [:error] [pid 26527] [client  
127.0.0.1:45169] davical: LOG: :GET  
/davical/caldav.php/martin/calendar/55866c75-3a94-41ab-a70b-66cd00000000.ics

(...)

[Sun Jun 21 09:49:17.623577 2015] [:error] [pid 26554] [client  
127.0.0.1:45172] davical: LOG: :GET  
/davical/caldav.php/martin/calendar/ical0






More information about the bugs mailing list