After the last update of NextCloud it stopped working.
The server was unable to complete your request.
I review the pod logs. I found this error related to a “group by clause” in the psotgres section
A known issue ( NAS-131308. Will be fixed in the final release as I understand it. Refresh the browser window, or manually access the port in the form hostname or IP address :port , to correct button function and access the app UI.
Hi Okedokey, thanks for the reply. I reviewed the issue, but I did not find the connection with my case. I have not upgraded to Electric Eel yet.
I checked the postgreSQL log again and I have new error messages.
Now there are a lot of this type of errors.
They look to be related to an issue with the database (inner joins failing).
2024-10-13 08:01:20.426559-04:002024-10-13 12:01:20.426 UTC [1] LOG: database system is ready to accept connections
2024-10-13 08:15:02.309467-04:002024-10-13 12:15:02.309 UTC [1691] ERROR: column “cr.id” must appear in the GROUP BY clause or be used in an aggregate function at character 8
2024-10-13 08:15:02.309520-04:002024-10-13 12:15:02.309 UTC [1691] STATEMENT: SELECT “cr”., “co”.“calendardata”, “c”.“displayname”, “c”.“principaluri”, “cr”.“notification_date”, “cr”.“event_hash”, “cr”.“type” FROM “oc_calendar_reminders” “cr” INNER JOIN “oc_calendarobjects” “co” ON “cr”.“object_id” = “co”.“id” INNER JOIN “oc_calendars” “c” ON “cr”.“calendar_id” = “c”.“id” WHERE “cr”.“notification_date” <= $1 GROUP BY “cr”.“event_hash”, “cr”.“notification_date”, “cr”.“type”
2024-10-13 08:30:02.239616-04:002024-10-13 12:30:02.239 UTC [4162] ERROR: column “cr.id” must appear in the GROUP BY clause or be used in an aggregate function at character 8
2024-10-13 08:30:02.239668-04:002024-10-13 12:30:02.239 UTC [4162] STATEMENT: SELECT “cr”., “co”.“calendardata”, “c”.“displayname”, “c”.“principaluri”, “cr”.“notification_date”, “cr”.“event_hash”, “cr”.“type” FROM “oc_calendar_reminders” “cr” INNER JOIN “oc_calendarobjects” “co” ON “cr”.“object_id” = “co”.“id” INNER JOIN “oc_calendars” “c” ON “cr”.“calendar_id” = “c”.“id” WHERE “cr”.“notification_date” <= $1 GROUP BY “cr”.“event_hash”, “cr”.“notification_date”, “cr”.“type”
Sorry to send you down the wrong path. I am not any type of expert here.
