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

[Giuseppe S. <giu...@sg...>]

Hello Andrew,
collections are present.

Il giorno gio, 15/06/2023 alle 14.36 +1200, Andrew Ruthven ha scritto:
[...]
> It looks like DAViCal is failing to find the collection. Can you please try
> running:
> 
> SELECT collection.*
> FROM usr LEFT JOIN collection USING (user_no)
> WHERE usr.username = 'giuseppe';
[...]

davical=> SELECT collection.user_no, collection.collection_id
FROM usr LEFT JOIN collection USING (user_no)
WHERE usr.username = 'giuseppe';
 user_no | collection_id 
---------+---------------
    1001 |          4523
    1001 |          1003
    1001 |          1002
(3 rows)

Maybe the problem of the original query is that this user is not member of a
group. In fact, the group_member table is empty, so any JOIN with this table
gives no records.

Bye,
Giuseppe