1. First, create an event with (e.g.) Apple iCal and store it in Calendar "Test" "Test" is "sogopg3820180013687ac98{_quick,_acl}". For reference: My personal calendar is "sogopg3820180011785c1ee{_quick,_acl}". my normal login id for the web frontend is "pascal.gienger", my UIDField (uid) is "pg382018". BEGIN TRANSACTION INSERT INTO sogopg3820180013687ac98_quick (c_partstates, c_orgmail, c_uid, c_sequence, c_nextalarm, c_title, c_classification, c_location, c_name, c_component, c_iscycle, c_enddate, c_priority, c_status, c_isopaque, c_startdate, c_isallday) VALUES ('', '', 'D3E58EA5-F895-430D-9E67-5313FD0DE097', 2, 0, 'Test dans calendrier Test', 0, '', 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', 'vevent', 0, 1279785600, 0, 1, 1, 1279782000, 0) INSERT INTO sogopg3820180013687ac98 (c_creationdate, c_lastmodified, c_name, c_version, c_content) VALUES (1279631349, 1279631349, 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', 0, 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T130858Z UID:D3E58EA5-F895-430D-9E67-5313FD0DE097 DTEND;TZID=Europe/Berlin:20100722T100000 TRANSP:OPAQUE SUMMARY:Test dans calendrier Test DTSTART;TZID=Europe/Berlin:20100722T090000 DTSTAMP:20100720T130907Z SEQUENCE:2 END:VEVENT END:VCALENDAR ') COMMIT TRANSACTION 2. Open in Web Calendar, login with "pascal.gienger": (remark the use of "pg382018" which is "UIDField", correct!) SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = '22E0-4C459D80-1-4140F780' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180013687ac98_quick a, sogopg3820180013687ac98 b WHERE (a.c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/22E0-4C459D80-1-4140F780' SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = '22E0-4C459D80-1-4140F780' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180013687ac98_quick a, sogopg3820180013687ac98 b WHERE (a.c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/personal' SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/22E0-4C459D80-1-4140F780' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' 3. Drop Down Menu is on "Personal Calendar" (which is already an error) and now hitting Save: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = '22E0-4C459D80-1-4140F780' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180013687ac98_quick a, sogopg3820180013687ac98 b WHERE (a.c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_version, c_deleted FROM sogopg3820180013687ac98 WHERE (c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180013687ac98_quick SET c_partstates = '', c_orgmail = '', c_uid = 'D3E58EA5-F895-430D-9E67-5313FD0DE097', c_sequence = 2, c_nextalarm = 0, c_title = 'Test dans calendrier Test', c_classification = 0, c_location = '', c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_component = 'vevent', c_iscycle = 0, c_enddate = 1279785600, c_priority = 0, c_status = 1, c_isopaque = 1, c_startdate = 1279782000, c_isallday = 0 WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' UPDATE sogopg3820180013687ac98 SET c_lastmodified = 1279631637, c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_version = 1, c_content = 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T130858Z UID:D3E58EA5-F895-430D-9E67-5313FD0DE097 DTEND;TZID=Europe/Berlin:20100722T100000 TRANSP:OPAQUE SUMMARY:Test dans calendrier Test DTSTART;TZID=Europe/Berlin:20100722T090000 DTSTAMP:20100720T130907Z SEQUENCE:2 LAST-MODIFIED:20100720T131357Z END:VEVENT END:VCALENDAR' WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' COMMIT TRANSACTION COMMIT TRANSACTION SELECT c_version, c_deleted FROM sogopg3820180013687ac98 WHERE (c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180013687ac98_quick SET c_partstates = '', c_orgmail = '', c_uid = 'D3E58EA5-F895-430D-9E67-5313FD0DE097', c_sequence = 2, c_nextalarm = 0, c_title = 'Test dans calendrier Test', c_classification = 0, c_location = '', c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_component = 'vevent', c_iscycle = 0, c_enddate = 1279785600, c_priority = 0, c_status = 1, c_isopaque = 1, c_startdate = 1279782000, c_isallday = 0 WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' UPDATE sogopg3820180013687ac98 SET c_lastmodified = 1279631637, c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_version = 2, c_content = 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T130858Z UID:D3E58EA5-F895-430D-9E67-5313FD0DE097 DTEND;TZID=Europe/Berlin:20100722T100000 TRANSP:OPAQUE SUMMARY:Test dans calendrier Test DTSTART;TZID=Europe/Berlin:20100722T090000 DTSTAMP:20100720T130907Z SEQUENCE:2 LAST-MODIFIED:20100720T131357Z END:VEVENT END:VCALENDAR' WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' COMMIT TRANSACTION COMMIT TRANSACTION SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = 'personal' SELECT c_version, c_deleted FROM sogopg3820180011785c1ee WHERE (c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') BEGIN TRANSACTION BEGIN TRANSACTION INSERT INTO sogopg3820180011785c1ee_quick (c_partstates, c_orgmail, c_uid, c_sequence, c_nextalarm, c_title, c_classification, c_location, c_name, c_component, c_iscycle, c_enddate, c_priority, c_status, c_isopaque, c_startdate, c_isallday) VALUES ('', '', 'D3E58EA5-F895-430D-9E67-5313FD0DE097', 2, 0, 'Test dans calendrier Test', 0, '', 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', 'vevent', 0, 1279785600, 0, 1, 1, 1279782000, 0) INSERT INTO sogopg3820180011785c1ee (c_creationdate, c_lastmodified, c_name, c_version, c_content) VALUES (1279631637, 1279631637, 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', 0, 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T130858Z UID:D3E58EA5-F895-430D-9E67-5313FD0DE097 DTEND;TZID=Europe/Berlin:20100722T100000 TRANSP:OPAQUE SUMMARY:Test dans calendrier Test DTSTART;TZID=Europe/Berlin:20100722T090000 DTSTAMP:20100720T130907Z SEQUENCE:2 LAST-MODIFIED:20100720T131357Z END:VEVENT END:VCALENDAR') COMMIT TRANSACTION COMMIT TRANSACTION BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180013687ac98 SET c_deleted = 1, c_lastmodified = 1279631637 WHERE c_name='D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' DELETE FROM sogopg3820180013687ac98_quick WHERE c_name='D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' COMMIT TRANSACTION COMMIT TRANSACTION 4. Reopen the event: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = 'personal' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180011785c1ee_quick a, sogopg3820180011785c1ee b WHERE (a.c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/personal' SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = 'personal' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180011785c1ee_quick a, sogopg3820180011785c1ee b WHERE (a.c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/personal' SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/22E0-4C459D80-1-4140F780' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' 5. Save it again: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = 'personal' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180011785c1ee_quick a, sogopg3820180011785c1ee b WHERE (a.c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_version, c_deleted FROM sogopg3820180011785c1ee WHERE (c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180011785c1ee_quick SET c_partstates = '', c_orgmail = '', c_uid = 'D3E58EA5-F895-430D-9E67-5313FD0DE097', c_sequence = 2, c_nextalarm = 0, c_title = 'Test dans calendrier Test', c_classification = 0, c_location = '', c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_component = 'vevent', c_iscycle = 0, c_enddate = 1279785600, c_priority = 0, c_status = 1, c_isopaque = 1, c_startdate = 1279782000, c_isallday = 0 WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' UPDATE sogopg3820180011785c1ee SET c_lastmodified = 1279631977, c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_version = 1, c_content = 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T130858Z UID:D3E58EA5-F895-430D-9E67-5313FD0DE097 DTEND;TZID=Europe/Berlin:20100722T100000 TRANSP:OPAQUE SUMMARY:Test dans calendrier Test DTSTART;TZID=Europe/Berlin:20100722T090000 DTSTAMP:20100720T130907Z SEQUENCE:2 LAST-MODIFIED:20100720T131937Z END:VEVENT END:VCALENDAR' WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' COMMIT TRANSACTION COMMIT TRANSACTION SELECT c_version, c_deleted FROM sogopg3820180011785c1ee WHERE (c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180011785c1ee_quick SET c_partstates = '', c_orgmail = '', c_uid = 'D3E58EA5-F895-430D-9E67-5313FD0DE097', c_sequence = 2, c_nextalarm = 0, c_title = 'Test dans calendrier Test', c_classification = 0, c_location = '', c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_component = 'vevent', c_iscycle = 0, c_enddate = 1279785600, c_priority = 0, c_status = 1, c_isopaque = 1, c_startdate = 1279782000, c_isallday = 0 WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' UPDATE sogopg3820180011785c1ee SET c_lastmodified = 1279631977, c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_version = 2, c_content = 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T130858Z UID:D3E58EA5-F895-430D-9E67-5313FD0DE097 DTEND;TZID=Europe/Berlin:20100722T100000 TRANSP:OPAQUE SUMMARY:Test dans calendrier Test DTSTART;TZID=Europe/Berlin:20100722T090000 DTSTAMP:20100720T130907Z SEQUENCE:2 LAST-MODIFIED:20100720T131937Z END:VEVENT END:VCALENDAR' WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' COMMIT TRANSACTION COMMIT TRANSACTION SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = 'personal' SELECT c_version, c_deleted FROM sogopg3820180011785c1ee WHERE (c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics') BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180011785c1ee_quick SET c_partstates = '', c_orgmail = '', c_uid = 'D3E58EA5-F895-430D-9E67-5313FD0DE097', c_sequence = 2, c_nextalarm = 0, c_title = 'Test dans calendrier Test', c_classification = 0, c_location = '', c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_component = 'vevent', c_iscycle = 0, c_enddate = 1279785600, c_priority = 0, c_status = 1, c_isopaque = 1, c_startdate = 1279782000, c_isallday = 0 WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' UPDATE sogopg3820180011785c1ee SET c_lastmodified = 1279631977, c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics', c_version = 3, c_content = 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T130858Z UID:D3E58EA5-F895-430D-9E67-5313FD0DE097 DTEND;TZID=Europe/Berlin:20100722T100000 TRANSP:OPAQUE SUMMARY:Test dans calendrier Test DTSTART;TZID=Europe/Berlin:20100722T090000 DTSTAMP:20100720T130907Z SEQUENCE:2 LAST-MODIFIED:20100720T131937Z END:VEVENT END:VCALENDAR' WHERE c_name = 'D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' COMMIT TRANSACTION COMMIT TRANSACTION BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180011785c1ee SET c_deleted = 1, c_lastmodified = 1279631977 WHERE c_name='D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' DELETE FROM sogopg3820180011785c1ee_quick WHERE c_name='D3E58EA5-F895-430D-9E67-5313FD0DE097.ics' COMMIT TRANSACTION COMMIT TRANSACTION And the entry has gone. Now the SAME thing done with login as "pg382018" in the web interface. 2a: Open the event in web calendar (the drop down menu is showing "Test" as calendar which is correct for this event, compare with step 2 at the beginning!): SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = '22E0-4C459D80-1-4140F780' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180013687ac98_quick a, sogopg3820180013687ac98 b WHERE (a.c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/22E0-4C459D80-1-4140F780' SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = '22E0-4C459D80-1-4140F780' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180013687ac98_quick a, sogopg3820180013687ac98 b WHERE (a.c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/personal' SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/pg382018/Calendar/22E0-4C459D80-1-4140F780' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' 3a: Save the event. SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'pg382018' AND c_folder_type = 'Appointment' SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'pg382018' SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'pg382018' AND c_path3 = 'Calendar' AND c_path4 = '22E0-4C459D80-1-4140F780' SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogopg3820180013687ac98_quick a, sogopg3820180013687ac98 b WHERE (a.c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL) SELECT c_version, c_deleted FROM sogopg3820180013687ac98 WHERE (c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics') BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180013687ac98_quick SET c_partstates = '', c_orgmail = '', c_uid = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F', c_sequence = 2, c_nextalarm = 0, c_title = 'Test, la deuxième', c_classification = 0, c_location = '', c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics', c_component = 'vevent', c_iscycle = 0, c_enddate = 1279701000, c_priority = 0, c_status = 1, c_isopaque = 1, c_startdate = 1279695600, c_isallday = 0 WHERE c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics' UPDATE sogopg3820180013687ac98 SET c_lastmodified = 1279632579, c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics', c_version = 1, c_content = 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T132553Z UID:0E0B830B-4EAF-45BD-9E3D-E6F839AD150F DTEND;TZID=Europe/Berlin:20100721T103000 TRANSP:OPAQUE SUMMARY:Test, la deuxième DTSTART;TZID=Europe/Berlin:20100721T090000 DTSTAMP:20100720T132605Z SEQUENCE:2 LAST-MODIFIED:20100720T132939Z END:VEVENT END:VCALENDAR' WHERE c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics' COMMIT TRANSACTION COMMIT TRANSACTION SELECT c_version, c_deleted FROM sogopg3820180013687ac98 WHERE (c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics') BEGIN TRANSACTION BEGIN TRANSACTION UPDATE sogopg3820180013687ac98_quick SET c_partstates = '', c_orgmail = '', c_uid = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F', c_sequence = 2, c_nextalarm = 0, c_title = 'Test, la deuxième', c_classification = 0, c_location = '', c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics', c_component = 'vevent', c_iscycle = 0, c_enddate = 1279701000, c_priority = 0, c_status = 1, c_isopaque = 1, c_startdate = 1279695600, c_isallday = 0 WHERE c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics' UPDATE sogopg3820180013687ac98 SET c_lastmodified = 1279632579, c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics', c_version = 2, c_content = 'BEGIN:VCALENDAR VERSION:2.0 PRODID:-//Apple Inc.//iCal 4.0.3//EN CALSCALE:GREGORIAN BEGIN:VTIMEZONE TZID:Europe/Berlin BEGIN:DAYLIGHT TZOFFSETFROM:+0100 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU DTSTART:19810329T020000 TZNAME:GMT+02:00 TZOFFSETTO:+0200 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU DTSTART:19961027T030000 TZNAME:GMT+01:00 TZOFFSETTO:+0100 END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED:20100720T132553Z UID:0E0B830B-4EAF-45BD-9E3D-E6F839AD150F DTEND;TZID=Europe/Berlin:20100721T103000 TRANSP:OPAQUE SUMMARY:Test, la deuxième DTSTART;TZID=Europe/Berlin:20100721T090000 DTSTAMP:20100720T132605Z SEQUENCE:2 LAST-MODIFIED:20100720T132939Z END:VEVENT END:VCALENDAR' WHERE c_name = '0E0B830B-4EAF-45BD-9E3D-E6F839AD150F.ics' COMMIT TRANSACTION COMMIT TRANSACTION