[OGo-Bugs][Bug 1876] Sunbird Alerts cannot be dismissed

[bugs@opengroupware.org]

Please do not reply directly to this email. All additional
comments should be made in the comments box of this bug
report.

http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=1876


awilliam@whitemice.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         AssignedTo|helge.hess@opengroupware.org|awilliam@whitemice.org
             Status|NEW                         |ASSIGNED




------- Additional Comments From awilliam@whitemice.org  2008-06-30 04:33 -------
Possibly relates to SQL error in saving the reminder.

Jun 30 02:31:26 ogo-zidestore-1.5 [3154]: <<0x0x8860b8c[SxAppointment]>>D patch
old=>new 13=>0
Jun 30 02:31:26 ogo-zidestore-1.5 [3154]: <0x0x8667614[PostgreSQL72Channel]:
connection=<0x0x845b114[PGConnection]:  connection=0x0x8667e98>>: message:
WARNING:  nonstandard use of \' in a string literal
LINE 1: ... null, associated_contacts = null, evo_reminder = '\'DISPLAY...
                                                             ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...').


------- Additional Comments From awilliam@whitemice.org  2008-07-02 23:44 -------
There is no SQL error, the issue regarding quoting is merely a warning. 
Probably this should be fixed in the PostgreSQL adapter.

I think the issue is this -
BEGIN:VALARM
TRIGGER;VALUE=DURATION:-P1W
X-MOZ-LASTACK:20080702T211432Z
DESCRIPTION:Mozilla Alarm: hfhfdhd
ACTION:DISPLAY
END:VALARM

A dismiss in Mozilla sets a X-MOZ-LASTACK attribute.  This is *not* encoded into
the evoReminder,  then ZideStore dutifully returns -

BEGIN:VALARM
ACTION:DISPLAY
DESCRIPTION:Mozilla Alarm: hfhfdhd
TRIGGER;VALUE=DURATION;RELATED=START:-P1W
END:VALARM


------- You are receiving this mail because: -------
You are on the CC list for the bug, or are watching someone who is.