We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Der Fehler SQLSTATE[42803]: Grouping error: 7 ERROR: column "cr.id" must appear in the GROUP BY clause or be used in an aggregate function tritt auf.
Der Hintergrundjob sollte ohne Fehler ausgeführt werden.
Führen Sie den Hintergrundjob OCA\DAV\BackgroundJob\EventReminderJob aus. Der oben genannte Fehler tritt auf.
- OS:unraid - How docker service was installed: community apps
x86-64
unraid installation
{ "reqId": "mEnVXo3hvLmIG0TCOXns", "level": 3, "time": "2024-10-01T11:45:01+00:00", "remoteAddr": "", "user": "--", "app": "core", "method": "", "url": "--", "message": "Error while running background job OCA\\DAV\\BackgroundJob\\EventReminderJob (id: 9, arguments: null)", "userAgent": "--", "version": "30.0.0.14", "exception": { "Exception": "Doctrine\\DBAL\\Exception\\DriverException", "Message": "An exception occurred while executing a query: SQLSTATE[42803]: Grouping error: 7 ERROR: column \"cr.id\" must appear in the GROUP BY clause or be used in an aggregate function\nLINE 1: SELECT \"cr\".*, \"co\".\"calendardata\", \"c\".\"displayname\", \"c\".\"...\n ^", "Code": 7, "Trace": [ { "file": "/app/www/public/3rdparty/doctrine/dbal/src/Connection.php", "line": 1943, "function": "convert", "class": "Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter", "type": "->" }, { "file": "/app/www/public/3rdparty/doctrine/dbal/src/Connection.php", "line": 1885, "function": "handleDriverException", "class": "Doctrine\\DBAL\\Connection", "type": "->" }, { "file": "/app/www/public/3rdparty/doctrine/dbal/src/Connection.php", "line": 1106, "function": "convertExceptionDuringQuery", "class": "Doctrine\\DBAL\\Connection", "type": "->" }, { "file": "/app/www/public/lib/private/DB/Connection.php", "line": 415, "function": "executeQuery", "class": "Doctrine\\DBAL\\Connection", "type": "->" }, { "file": "/app/www/public/lib/private/DB/ConnectionAdapter.php", "line": 50, "function": "executeQuery", "class": "OC\\DB\\Connection", "type": "->" }, { "file": "/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php", "line": 272, "function": "executeQuery", "class": "OC\\DB\\ConnectionAdapter", "type": "->" }, { "file": "/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php", "line": 249, "function": "executeQuery", "class": "OC\\DB\\QueryBuilder\\QueryBuilder", "type": "->" }, { "file": "/config/www/nextcloud/apps/dav/lib/CalDAV/Reminder/Backend.php", "line": 53, "function": "execute", "class": "OC\\DB\\QueryBuilder\\QueryBuilder", "type": "->" }, { "file": "/config/www/nextcloud/apps/dav/lib/CalDAV/Reminder/ReminderService.php", "line": 104, "function": "getRemindersToProcess", "class": "OCA\\DAV\\CalDAV\\Reminder\\Backend", "type": "->" }, { "file": "/config/www/nextcloud/apps/dav/lib/BackgroundJob/EventReminderJob.php", "line": 50, "function": "processReminders", "class": "OCA\\DAV\\CalDAV\\Reminder\\ReminderService", "type": "->" }, { "file": "/app/www/public/lib/public/BackgroundJob/Job.php", "line": 61, "function": "run", "class": "OCA\\DAV\\BackgroundJob\\EventReminderJob", "type": "->" }, { "file": "/app/www/public/lib/public/BackgroundJob/TimedJob.php", "line": 83, "function": "start", "class": "OCP\\BackgroundJob\\Job", "type": "->" }, { "file": "/app/www/public/lib/public/BackgroundJob/TimedJob.php", "line": 73, "function": "start", "class": "OCP\\BackgroundJob\\TimedJob", "type": "->" }, { "file": "/app/www/public/cron.php", "line": 162, "function": "execute", "class": "OCP\\BackgroundJob\\TimedJob", "type": "->" } ], "File": "/app/www/public/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php", "Line": 87, "Previous": { "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception", "Message": "SQLSTATE[42803]: Grouping error: 7 ERROR: column \"cr.id\" must appear in the GROUP BY clause or be used in an aggregate function\nLINE 1: SELECT \"cr\".*, \"co\".\"calendardata\", \"c\".\"displayname\", \"c\".\"...\n ^", "Code": 7, "Trace": [ { "file": "/app/www/public/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php", "line": 132, "function": "new", "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception", "type": "::" }, { "file": "/app/www/public/3rdparty/doctrine/dbal/src/Connection.php", "line": 1099, "function": "execute", "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement", "type": "->" }, { "file": "/app/www/public/lib/private/DB/Connection.php", "line": 415, "function": "executeQuery", "class": "Doctrine\\DBAL\\Connection", "type": "->" }, { "file": "/app/www/public/lib/private/DB/ConnectionAdapter.php", "line": 50, "function": "executeQuery", "class": "OC\\DB\\Connection", "type": "->" }, { "file": "/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php", "line": 272, "function": "executeQuery", "class": "OC\\DB\\ConnectionAdapter", "type": "->" }, { "file": "/app/www/public/lib/private/DB/QueryBuilder/QueryBuilder.php", "line": 249, "function": "executeQuery", "class": "OC\\DB\\QueryBuilder\\QueryBuilder", "type": "->" }, { "file": "/config/www/nextcloud/apps/dav/lib/CalDAV/Reminder/Backend.php", "line": 53, "function": "execute", "class": "OC\\DB\\QueryBuilder\\QueryBuilder", "type": "->" }, { "file": "/config/www/nextcloud/apps/dav/lib/CalDAV/Reminder/ReminderService.php", "line": 104, "function": "getRemindersToProcess", "class": "OCA\\DAV\\CalDAV\\Reminder\\Backend", "type": "->" }, { "file": "/config/www/nextcloud/apps/dav/lib/BackgroundJob/EventReminderJob.php", "line": 50, "function":"processReminders", "class": "OCA\\DAV\\CalDAV\\Reminder\\ReminderService", "type": "->" }, { "file": "/app/www/public/lib/public/BackgroundJob/Job.php", "line": 61, "function": "run", "class": "OCA\\DAV\\BackgroundJob\\EventReminderJob", "type": "->" }, { "file": "/app/www/public/lib/public/BackgroundJob/TimedJob.php", "line": 83, "function": "start", "class": "OCP\\BackgroundJob\\Job", "type": "->" }, { "file": "/app/www/public/lib/public/BackgroundJob/TimedJob.php", "line": 73, "function": "start", "class": "OCP\\BackgroundJob\\TimedJob", "type": "->" }, { "file": "/app/www/public/cron.php", "line": 162, "function": "execute", "class": "OCP\\BackgroundJob\\TimedJob", "type": "->" } ], "File": "/app/www/public/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php", "Line": 28 } }, "message": "Error while running background job OCA\\DAV\\BackgroundJob\\EventReminderJob (id: 9, arguments: null)", "exception": {}, "CustomMessage": "Error while running background job OCA\\DAV\\BackgroundJob\\EventReminderJob (id: 9, arguments: null)" }
The text was updated successfully, but these errors were encountered:
Thanks for opening your first issue here! Be sure to follow the relevant issue templates, or risk having this issue marked as invalid.
Sorry, something went wrong.
Same here with fresh nextcloud-aio installation
I would seek guidance from nextcloud
is solved with Nextcloud Hub 9 (30.0.1)
No branches or pull requests
Is there an existing issue for this?
Current Behavior
Der Fehler SQLSTATE[42803]: Grouping error: 7 ERROR: column "cr.id" must appear in the GROUP BY clause or be used in an aggregate function tritt auf.
Expected Behavior
Der Hintergrundjob sollte ohne Fehler ausgeführt werden.
Steps To Reproduce
Führen Sie den Hintergrundjob OCA\DAV\BackgroundJob\EventReminderJob aus.
Der oben genannte Fehler tritt auf.
Environment
CPU architecture
x86-64
Docker creation
Container logs
The text was updated successfully, but these errors were encountered: