Re: [Davical-general] SQL error after upgrade: ":collection_id" => "-1"

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hello Andrew,
thank you for your reply.

Il giorno dom, 18/06/2023 alle 14.16 +1200, Andrew Ruthven ha scritto:
> If the collection belongs to your user, not being a member of a group
> shouldn't be a problem.
> 
> Can you please turn on
> debugging? https://wiki.davical.org/index.php?title=Debugging

I think this is what you requested, using evolution as a client:

ALL: I18N:Set locale to =it_IT.UTF-8=
ALL: I18N:Bound domain =davical= to location =/usr/share/davical/locale= using character set =UTF-8=
ALL: caldav:Version (1.1.12) == 1001.12
LOG: always: Query: DBGQ: SELECT schema_major, schema_minor, schema_patch FROM awl_db_revision ORDER BY schema_id DESC LIMIT 1;
LOG: always: Query: DBGQ: Took: 0,000621 to find 1 rows.
LOG: always: Query: DBGQ: SET TIMEZONE TO ?
LOG: always: Query: DBGQ:  "0" => "UTC"
LOG: always: Query: DBGQ: Took: 0,000275 to find 0 rows.
LOG: :***************** Request Header ****************
LOG: :REPORT /caldav.php/giuseppe/calendar/
LOG: headers:-->Depth: 1
LOG: headers:-->Authorization: Delicious tasty password eaten by debugging monster!
LOG: headers:-->Accept-Language: it-it, it;q=0.9
LOG: headers:-->Accept-Encoding: gzip, deflate, br
LOG: headers:-->Content-Length: 278
LOG: headers:-->Content-Type: application/xml; charset="utf-8"
LOG: headers:-->Pragma: no-cache
LOG: headers:-->Cache-Control: no-cache
LOG: headers:-->User-Agent: Evolution/3.46.4
LOG: headers:-->Host: cal.domani.tld
LOG: :******************** Request ********************
LOG: request:--><calendar-query xmlns="urn:ietf:params:xml:ns:caldav" xmlns:D="DAV:"><D:prop><D:getetag/></D:prop><filter><comp-filter name="VCALENDAR"><comp-filter name="VEVENT"><time-range start="20230514T074916Z" end="20230723T074916Z"/></comp-filter></comp-filter></filter></calendar-query>
ALL: Cache:memcache_servers isn't set, using NoCache dummy interface
LOG: Principal: Query: DBGQ: SELECT *, 0::BIT(24) AS privileges FROM dav_principal WHERE lower(username)=lower(text(:param))
LOG: Principal: Query: DBGQ:  ":param" => "giuseppe"
LOG: Principal: Query: DBGQ: Took: 0,001792 to find 1 rows.
LOG: BasicAuth: Query: DBGQ: SELECT role_name FROM role_member m join roles r ON r.role_no = m.role_no WHERE user_no = :user_no
LOG: BasicAuth: Query: DBGQ:  ":user_no" => "1001"
LOG: BasicAuth: Query: DBGQ: Took: 0,000435 to find 0 rows.
ALL: Principal:No useful path split possible
LOG: Principal: Query: DBGQ: SELECT *, pprivs(:session_principal::int8,principal_id,:scan_depth::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text(:param))
LOG: Principal: Query: DBGQ:  ":session_principal" => "1001"
LOG: Principal: Query: DBGQ:  ":scan_depth" => "2"
LOG: Principal: Query: DBGQ:  ":param" => "giuseppe"
LOG: Principal: Query: DBGQ: Took: 0,001548 to find 1 rows.
LOG: caldav: Query: DBGQ: SELECT * FROM collection WHERE dav_name = :exact_name OR dav_name = :truncated_name OR dav_name = :trailing_slash_name ORDER BY LENGTH(dav_name) DESC LIMIT 1
LOG: caldav: Query: DBGQ:  ":exact_name" => ""
LOG: caldav: Query: DBGQ:  ":truncated_name" => ""
LOG: caldav: Query: DBGQ:  ":trailing_slash_name" => "/"
LOG: caldav: Query: DBGQ: Took: 0,000459 to find 0 rows.
ALL: caldav: Collection '' is 0, type
ALL: Principal:No useful path split possible
LOG: Principal: Query: DBGQ: SELECT *, pprivs(:session_principal::int8,principal_id,:scan_depth::int) AS privileges FROM dav_principal WHERE lower(username)=lower(text(:param))
LOG: Principal: Query: DBGQ:  ":session_principal" => "1001"
LOG: Principal: Query: DBGQ:  ":scan_depth" => "2"
LOG: Principal: Query: DBGQ:  ":param" => "giuseppe"
LOG: Principal: Query: DBGQ: Took: 0,000383 to find 1 rows.
LOG: DAVPrincipal: Query: DBGQ: SELECT usr.username FROM group_member JOIN principal ON (principal_id=group_id) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = :member_id UNION SELECT usr.username FROM group_member LEFT JOIN grants ON (to_principal=group_id)
LOG: DAVPrincipal: Query: DBGQ:  JOIN principal ON (principal_id=by_principal) JOIN usr USING(user_no) WHERE usr.active=true AND member_id = :member_id and by_principal != member_id ORDER BY 1
LOG: DAVPrincipal: Query: DBGQ:  ":member_id" => "1001"
LOG: DAVPrincipal: Query: DBGQ: Took: 0,001114 to find 0 rows.
ALL: principal: User: giuseppe (1001) URL: /caldav.php/giuseppe/, By Email: 0
ALL: caldav:Full read permissions for user accessing /
ALL: caldav: Parsed incoming XML request body.
ALL: REPORT:method handler
ng:  fopen(/var/log/davical/REPORT.debug): Failed to open stream: File o directory non esistente in /usr/share/davical/inc/caldav-REPORT.php on line 19
ALL: DAVResource::FetchCollection: Looking for collection for "/".
LOG: DAVResource: Query: DBGQ: SELECT collection.*, path_privs(:session_principal::int8, collection.dav_name,:scan_depth::int), p.principal_id, p.type_id AS principal_type_id, p.displayname AS principal_displayname, p.default_privileges AS principal_default_privileges, t
LOG: DAVResource: Query: DBGQ: imezones.vtimezone FROM collection LEFT JOIN principal p USING (user_no) LEFT JOIN timezones ON (collection.timezone=timezones.tzid) WHERE collection.dav_name = :raw_path ORDER BY LENGTH(collection.dav_name) DESC LIMIT 1
LOG: DAVResource: Query: DBGQ:  ":raw_path" => "/"
LOG: DAVResource: Query: DBGQ:  ":session_principal" => "1001"
LOG: DAVResource: Query: DBGQ:  ":scan_depth" => "2"
LOG: DAVResource: Query: DBGQ: Took: 0,000811 to find 0 rows.
ALL: Cache::FetchCollection: Setting cache ns "collection-/" key "dav_resource1001". Type: root
ALL: DAVResource::FetchCollection: Found collection named "/" of type "root".
ALL: DAVResource::FromPath: Path "/" is <DAV::collection/> a collection.
ALL: DAVResource::FetchPrivileges: Read permissions for user accessing /
ALL: DAVResource:Testing any privileges of "Array" (1000000001) against allowed "110001" => "1" (1)
ALL: DAVResource::FetchCollection: Looking for collection for "/".
LOG: DAVResource: Query: DBGQ: SELECT collection.*, path_privs(:session_principal::int8, collection.dav_name,:scan_depth::int), p.principal_id, p.type_id AS principal_type_id, p.displayname AS principal_displayname, p.default_privileges AS principal_default_privileges, t
LOG: DAVResource: Query: DBGQ: imezones.vtimezone FROM collection LEFT JOIN principal p USING (user_no) LEFT JOIN timezones ON (collection.timezone=timezones.tzid) WHERE collection.dav_name = :raw_path ORDER BY LENGTH(collection.dav_name) DESC LIMIT 1
LOG: DAVResource: Query: DBGQ:  ":raw_path" => "/"
LOG: DAVResource: Query: DBGQ:  ":session_principal" => "1001"
LOG: DAVResource: Query: DBGQ:  ":scan_depth" => "2"
LOG: DAVResource: Query: DBGQ: Took: 0,000767 to find 0 rows.
ALL: Cache::FetchCollection: Setting cache ns "collection-/" key "dav_resource1001". Type: root
ALL: DAVResource::FetchCollection: Found collection named "/" of type "root".
ALL: DAVResource::FromPath: Path "/" is <DAV::collection/> a collection.
ALL: I18N:Translated =The calendar-query report must be run against a calendar or a scheduling collection= into =The calendar-query report must be run against a calendar or a scheduling collection=
LOG: :Response status 403 for REPORT /caldav.php/giuseppe/calendar/
LOG: :***************** Response Header ****************
LOG: headers:-->Server: 1.1
LOG: headers:-->DAV: 1, 2, 3, access-control, calendar-access, calendar-schedule
LOG: headers:-->DAV: extended-mkcol, bind, addressbook, calendar-auto-schedule, calendar-proxy
LOG: headers:-->X-DAViCal-Version: DAViCal/1.1.12; DB/1.3.5
LOG: headers:-->Content-type: text/plain; charset="utf-8"
LOG: :******************** Response ********************
LOG: response:-->The calendar-query report must be run against a calendar or a scheduling collection

Thank you very much,
Giuseppe