Hi Benno, I just realized this email didn't reach the Debian BTS and may
not have reached you. It's probably best to keep both the bug (and thus
davical-devel) in Cc.
Florian
----- Forwarded message from Andrew Ruthven <and...@etc.gen.nz> -----
From: Andrew Ruthven <and...@etc.gen.nz>
To: davical-de...@lists.sourceforge.net
Date: Sat, 19 Feb 2022 16:59:37 +1300
Subject: Re: [DAViCal-devel] Bug#1004285: Bug#1004285: davical: problems after
upgrade to php 8,
calendar clients reports "500"
Hi Benno,
Those SQL errors are most likely the problem. Do they only appear with
PHP 8? What version of PostgreSQL are you using?
Cheers,
Andrew
On Fri, 2022-02-18 at 21:39 +0100, Benno Overeinder wrote:
> [Fri Feb 18 21:14:58.430957 2022] [php:notice] [pid 49689] [client
> 192.168.1.1:64517] davical: BUG: :DAViCal Fatal Error: [0A000]
> SQLSTATE[0A000]: Feature not supported: 7 ERROR: set-returning
> functions are not allowed in CASE\nLINE 4: ... expanded.g_id FROM
> (SELECT CASE WHEN $2 > 0 THEN expand_mem...\n
> ^\nHINT: You might be able to
> move
> the set-returning function into a LATERAL FROM item.\nQUERY: \n
> SELECT
> group_id FROM group_member WHERE member_id = $1\n UNION\n
> SELECT
> expanded.g_id FROM (SELECT CASE WHEN $2 > 0 THEN expand_memberships(
> group_id, $2 - 1) END AS g_id\n FROM
> group_member WHERE member_id = $1) AS expanded\n
> WHERE expanded.g_id IS NOT NULL;\n\nCONTEXT: SQL function
> "expand_memberships" during startup\nSQL statement "SELECT
> bit_or(subquery.privileges) FROM\n (\n
> SELECT
> privileges FROM grants WHERE by_principal=in_grantor AND
> by_collection
> IS NULL\n AND
> (to_principal=in_accessor OR to_principal IN (SELECT
> expand_memberships(in_accessor,in_depth)))\n UNION\n
> SELECT 32::BIT(24) AS privileges FROM
> expand_memberships(in_accessor,in_depth) WHERE expand_memberships =
> in_grantor\n ) AS subquery"\nPL/pgSQL function
> pprivs(bigint,bigint,integer) line 14 at SQL statement at
> /usr/share/awl/inc/AwlDatabase.php:94
--
Andrew Ruthven, Wellington, New Zealand
and...@etc.gen.nz |
Catalyst Cloud: | This space intentionally left blank
https://catalystcloud.nz |
_______________________________________________
DAViCal-devel mailing list
davical-de...@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/davical-devel
----- End forwarded message -----
