Dear Florian,
On 18/10/2022 13:01, Florian Schlichting wrote:
On Mon, Oct 10, 2022 at 12:46:57PM +0200, Benno Overeinder wrote:
Unfortunately the problem persists after updating to davical 1.1.11-1. I see
the same messages in the Apache2 error.log as previously reported.
looking at your error log from February, I think the crucial part is
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...
This sounds like https://gitlab.com/davical-project/davical/-/issues/171
The important bit is to make sure that update-davical-database is run
from the new package, and that it has replaced the expand_memberships
function to not contain a CASE statement any more.
Thanks for your email. I updated to php8.1 again and ran the
update-davical-database script, and then restarted apache2. At first I
saw the same errors, but after rebooting the server, DAViCal worked
perfectly as before. Maybe some sticky state in one of the components
(postgresql?).
Thanks again for your support and maintaining the davical package.
Cheers,
-- Benno
