SQL syntax error
I get this:
[25-Jan-2023 15:22:39 UTC] davical: BUG: :DAViCal Fatal Error: [42601] SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "not"
LINE 1: ...ta.caldav_type = 'VTODO' AND calendar_item.status not-LIKE '...
^ at /usr/share/awl/inc/AwlDatabase.php:94
[25-Jan-2023 15:22:39 UTC] ================= Stack Trace ===================
[25-Jan-2023 15:22:39 UTC] davical: LOG: :Response status 500 for REPORT /caldav.php/tobias/pythoncaldav-test/
[25-Jan-2023 15:22:39 UTC] davical: LOG: :***************** Response Header ****************
[25-Jan-2023 15:22:39 UTC] davical: LOG: headers:-->X-Powered-By: PHP/8.2.1
[25-Jan-2023 15:22:39 UTC] davical: LOG: headers:-->Server: 1.1
[25-Jan-2023 15:22:39 UTC] davical: LOG: headers:-->DAV: 1, 2, 3, access-control, calendar-access, calendar-schedule
[25-Jan-2023 15:22:39 UTC] davical: LOG: headers:-->DAV: extended-mkcol, bind, addressbook, calendar-auto-schedule, calendar-proxy
[25-Jan-2023 15:22:39 UTC] davical: LOG: headers:-->X-DAViCal-Version: DAViCal/1.1.11; DB/1.3.3
[25-Jan-2023 15:22:39 UTC] davical: LOG: headers:-->Content-type: text/plain; charset="utf-8"
[25-Jan-2023 15:22:39 UTC] davical: LOG: :******************** Response ********************
[25-Jan-2023 15:22:39 UTC] davical: LOG: response:-->DAViCal Fatal Error
... when doing a simple REPORT:
REPORT https://davical.bekkenstenveien53c.oslo.no/caldav.php/tobias/pythoncaldav-test/
Depth: 1
Content-Type: application/xml; charset="utf-8"
<?xml version='1.0' encoding='utf-8'?>
<C:calendar-query xmlns:D="DAV:" xmlns:C="urn:ietf:params:xml:ns:caldav">
<D:prop>
<C:calendar-data/>
</D:prop>
<C:filter>
<C:comp-filter name="VCALENDAR">
<C:comp-filter name="VTODO">
<C:prop-filter name="COMPLETED">
<C:is-not-defined/>
</C:prop-filter>
<C:prop-filter name="STATUS">
<C:is-not-defined/>
</C:prop-filter>
</C:comp-filter>
</C:comp-filter>
</C:filter>
</C:calendar-query>
<====
500 Internal Server ErrorDate: Wed, 25 Jan 2023 15:35:04 GMT
Content-Type: text/plain; charset="utf-8"
Content-Length: 19
Connection: close
X-Powered-By: PHP/8.2.1
Server: 1.1
DAV: 1, 2, 3, access-control, calendar-access, calendar-schedule, extended-mkcol, bind, addressbook, calendar-auto-schedule, calendar-proxy
X-DAViCal-Version: DAViCal/1.1.11; DB/1.3.3
DAViCal Fatal Error
I've tested 1.1.10 and 1.1.11, but not the master branch yet.
Edited by Tobias Brox