Attendees sometimes have uncorrectly escaped characters
I've noticed that at least Lightening is sending DAViCal incorrectly escaped attendees. See the 3D (hex for =) in the below logs. I reckon we need to strip those out... This is DAViCal 1.1.7.
davical: LOG: PUT: Query: Error: QF in '/usr/share/davical/inc/caldav-PUT-functions.php' on line 1232
davical: LOG: PUT: Query: QF: SQL error "22P02" - ERROR: invalid input syntax for type boolean: "3DTRUE" LINE 2: ..x3asomeone@catalyst.net.nz', '3DREQ-PARTICIPANT', '3DTRUE', ... ^"
davical: LOG: PUT: Query: Error: QF in '/usr/share/davical/inc/caldav-PUT-functions.php' on line 1232
davical: LOG: PUT: Query: QF: INSERT INTO calendar_attendee ( dav_id, status, partstat, cn, attendee, role, rsvp, property ) VALUES( 787263, :status, :partstat, :cn, :attendee, :role, :rsvp, :property )
davical: LOG: PUT: Query: QF: ":attendee" => "mailto:someone@catalyst.net.nz"
davical: LOG: PUT: Query: QF: ":status" => ""
davical: LOG: PUT: Query: QF: ":partstat" => "3DACCEPTED"
davical: LOG: PUT: Query: QF: ":cn" => "3Dsomeone@catalyst.net.nz"
davical: LOG: PUT: Query: QF: ":role" => "3DREQ-PARTICIPANT"
davical: LOG: PUT: Query: QF: ":rsvp" => "3DTRUE"
davical: LOG: PUT: Query: QF: ":property" => "ATTENDEE;RSVP=3DTRUE;CN=3Dkathryn@catalyst.net.nz;PARTSTAT=3DACCEPTED;RO\r\n LE=3DREQ-PARTICIPANT:mailto:kathryn@catalyst.net.nz"
davical: LOG: PUT: Query: Error: QF in '/usr/share/davical/inc/caldav-PUT-functions.php' on line 1520
davical: LOG: PUT: Query: QF: SQL error "25P02" - ERROR: current transaction is aborted, commands ignored until end of transaction block"
davical: LOG: PUT: Query: Error: QF in '/usr/share/davical/inc/caldav-PUT-functions.php' on line 1520