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

[Andrew R. <an...@et...>]

Hey,

Apologies for the delay, I've been sick the past week.

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

Easiest to just add $c->dbg["ALL"] = 1; to your DAViCal config file.

Cheers,
Andrew

On Thu, 2023-06-15 at 08:06 +0200, Giuseppe Sacco via Davical-general wrote:
> 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
> 
> 
> _______________________________________________
> Davical-general mailing list
> Dav...@li...
> https://lists.sourceforge.net/lists/listinfo/davical-general

-- 
Andrew Ruthven, Wellington, New Zealand
an...@et... |
Catalyst Cloud: | This space intentionally left blank
https://catalystcloud.nz |