Attachment 17168 Details for Bug 52028 – лог

лог

error01.txt (text/plain), 10.14 KB, created by NecroJoke on 2024-11-12 19:22:55 MSK

(hide)

Description:

Filename:

MIME Type:

Creator: NecroJoke

Created: 2024-11-12 19:22:55 MSK

Size: 10.14 KB

patch

obsolete

> DriverException 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 LINE 1: SELECT "cr".*, "co"."calendardata", "c"."displayname", "c"."... ^
>
>    /var/www/webapps/nextcloud/3rdparty/doctrine/dbal/src/Connection.phpÐÐ¸Ð½Ð¸Ñ 1943
>
>    Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert(
>      [
>        "Doctrine\\DBAL\\Driver\\PDO\\Exception"
>      ],
>      [
>        "Doctrine\\DBAL\\Query"
>      ]
>    )
>
>    /var/www/webapps/nextcloud/3rdparty/doctrine/dbal/src/Connection.phpÐÐ¸Ð½Ð¸Ñ 1885
>
>    Doctrine\DBAL\Connection->handleDriverException(
>      [
>        "Doctrine\\DBAL\\Driver\\PDO\\Exception"
>      ],
>      [
>        "Doctrine\\DBAL\\Query"
>      ]
>    )
>
>    /var/www/webapps/nextcloud/3rdparty/doctrine/dbal/src/Connection.phpÐÐ¸Ð½Ð¸Ñ 1106
>
>    Doctrine\DBAL\Connection->convertExceptionDuringQuery(
>      [
>        "Doctrine\\DBAL\\Driver\\PDO\\Exception"
>      ],
>      "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\" <= ? GROUP BY \"cr\".\"event_hash\", \"cr\".\"notification_date\", \"cr\".\"type\"",
>      [
>        1731421812
>      ],
>      [
>        2
>      ]
>    )
>
>    /var/www/webapps/nextcloud/lib/private/DB/Connection.phpÐÐ¸Ð½Ð¸Ñ 415
>
>    Doctrine\DBAL\Connection->executeQuery(
>      "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\" <= ? GROUP BY \"cr\".\"event_hash\", \"cr\".\"notification_date\", \"cr\".\"type\"",
>      [
>        1731421812
>      ],
>      [
>        2
>      ],
>      null
>    )
>
>    /var/www/webapps/nextcloud/lib/private/DB/ConnectionAdapter.phpÐÐ¸Ð½Ð¸Ñ 50
>
>    OC\DB\Connection->executeQuery(
>      "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\" <= :dcValue1 GROUP BY \"cr\".\"event_hash\", \"cr\".\"notification_date\", \"cr\".\"type\"",
>      [
>        1731421812
>      ],
>      [
>        2
>      ]
>    )
>
>    /var/www/webapps/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.phpÐÐ¸Ð½Ð¸Ñ 272
>
>    OC\DB\ConnectionAdapter->executeQuery(
>      "SELECT `cr`.*, `co`.`calendardata`, `c`.`displayname`, `c`.`principaluri`, `cr`.`notification_date`, `cr`.`event_hash`, `cr`.`type` FROM `*PREFIX*calendar_reminders` `cr` INNER JOIN `*PREFIX*calendarobjects` `co` ON `cr`.`object_id` = `co`.`id` INNER JOIN `*PREFIX*calendars` `c` ON `cr`.`calendar_id` = `c`.`id` WHERE `cr`.`notification_date` <= :dcValue1 GROUP BY `cr`.`event_hash`, `cr`.`notification_date`, `cr`.`type`",
>      [
>        1731421812
>      ],
>      [
>        2
>      ]
>    )
>
>    /var/www/webapps/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.phpÐÐ¸Ð½Ð¸Ñ 249
>
>    OC\DB\QueryBuilder\QueryBuilder->executeQuery(
>      [
>        "OC\\DB\\ConnectionAdapter"
>      ]
>    )
>
>    /var/www/webapps/nextcloud/apps/dav/lib/CalDAV/Reminder/Backend.phpÐÐ¸Ð½Ð¸Ñ 53
>
>    OC\DB\QueryBuilder\QueryBuilder->execute()
>
>    /var/www/webapps/nextcloud/apps/dav/lib/CalDAV/Reminder/ReminderService.phpÐÐ¸Ð½Ð¸Ñ 104
>
>    OCA\DAV\CalDAV\Reminder\Backend->getRemindersToProcess()
>
>    /var/www/webapps/nextcloud/apps/dav/lib/BackgroundJob/EventReminderJob.phpÐÐ¸Ð½Ð¸Ñ 50
>
>    OCA\DAV\CalDAV\Reminder\ReminderService->processReminders()
>
>    /var/www/webapps/nextcloud/lib/public/BackgroundJob/Job.phpÐÐ¸Ð½Ð¸Ñ 61
>
>    OCA\DAV\BackgroundJob\EventReminderJob->run(
>      null
>    )
>
>    /var/www/webapps/nextcloud/lib/public/BackgroundJob/TimedJob.phpÐÐ¸Ð½Ð¸Ñ 83
>
>    OCP\BackgroundJob\Job->start(
>      [
>        "OC\\BackgroundJob\\JobList"
>      ]
>    )
>
>    /var/www/webapps/nextcloud/lib/public/BackgroundJob/TimedJob.phpÐÐ¸Ð½Ð¸Ñ 73
>
>    OCP\BackgroundJob\TimedJob->start(
>      [
>        "OC\\BackgroundJob\\JobList"
>      ]
>    )
>
>    /var/www/webapps/nextcloud/cron.phpÐÐ¸Ð½Ð¸Ñ 162
>
>    OCP\BackgroundJob\TimedJob->execute(
>      [
>        "OC\\BackgroundJob\\JobList"
>      ]
>    )
>
>ÐÑÐ·Ð²Ð°Ð½Ð¾ Exception SQLSTATE[42803]: Grouping error: 7 ERROR: column "cr.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "cr".*, "co"."calendardata", "c"."displayname", "c"."... ^
>ÐÐ¾ÑÐ»Ðµ Ð¾Ð±Ð½Ð¾Ð²Ð»ÐµÐ½Ð¸Ñ Nextcloud Ð´Ð¾ Ð²ÐµÑÑÐ¸Ð¸ 30.0.0.14 Ð¸Ð· ÑÐµÐ¿Ð¾Ð·Ð¸ÑÐ¾ÑÐ¸Ñ p10 Ð¿ÑÐ¸ ÑÐ°Ð±Ð¾ÑÐµ Ð²Ð¾Ð·Ð½Ð¸ÐºÐ°ÐµÑ ÑÐ»ÐµÐ´ÑÑÑÐ°Ñ Ð¾ÑÐ¸Ð±ÐºÐ° (ÑÐ¸Ñ1)
>---
> DriverException 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 LINE 1: SELECT "cr".*, "co"."calendardata", "c"."displayname", "c"."... ^
>
>    /var/www/webapps/nextcloud/3rdparty/doctrine/dbal/src/Connection.phpÐÐ¸Ð½Ð¸Ñ 1943
>
>    Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert(
>      [
>        "Doctrine\\DBAL\\Driver\\PDO\\Exception"
>      ],
>      [
>        "Doctrine\\DBAL\\Query"
>      ]
>    )
>
>    /var/www/webapps/nextcloud/3rdparty/doctrine/dbal/src/Connection.phpÐÐ¸Ð½Ð¸Ñ 1885
>
>    Doctrine\DBAL\Connection->handleDriverException(
>      [
>        "Doctrine\\DBAL\\Driver\\PDO\\Exception"
>      ],
>      [
>        "Doctrine\\DBAL\\Query"
>      ]
>    )
>
>    /var/www/webapps/nextcloud/3rdparty/doctrine/dbal/src/Connection.phpÐÐ¸Ð½Ð¸Ñ 1106
>
>    Doctrine\DBAL\Connection->convertExceptionDuringQuery(
>      [
>        "Doctrine\\DBAL\\Driver\\PDO\\Exception"
>      ],
>      "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\" <= ? GROUP BY \"cr\".\"event_hash\", \"cr\".\"notification_date\", \"cr\".\"type\"",
>      [
>        1731421812
>      ],
>      [
>        2
>      ]
>    )
>
>    /var/www/webapps/nextcloud/lib/private/DB/Connection.phpÐÐ¸Ð½Ð¸Ñ 415
>
>    Doctrine\DBAL\Connection->executeQuery(
>      "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\" <= ? GROUP BY \"cr\".\"event_hash\", \"cr\".\"notification_date\", \"cr\".\"type\"",
>      [
>        1731421812
>      ],
>      [
>        2
>      ],
>      null
>    )
>
>    /var/www/webapps/nextcloud/lib/private/DB/ConnectionAdapter.phpÐÐ¸Ð½Ð¸Ñ 50
>
>    OC\DB\Connection->executeQuery(
>      "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\" <= :dcValue1 GROUP BY \"cr\".\"event_hash\", \"cr\".\"notification_date\", \"cr\".\"type\"",
>      [
>        1731421812
>      ],
>      [
>        2
>      ]
>    )
>
>    /var/www/webapps/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.phpÐÐ¸Ð½Ð¸Ñ 272
>
>    OC\DB\ConnectionAdapter->executeQuery(
>      "SELECT `cr`.*, `co`.`calendardata`, `c`.`displayname`, `c`.`principaluri`, `cr`.`notification_date`, `cr`.`event_hash`, `cr`.`type` FROM `*PREFIX*calendar_reminders` `cr` INNER JOIN `*PREFIX*calendarobjects` `co` ON `cr`.`object_id` = `co`.`id` INNER JOIN `*PREFIX*calendars` `c` ON `cr`.`calendar_id` = `c`.`id` WHERE `cr`.`notification_date` <= :dcValue1 GROUP BY `cr`.`event_hash`, `cr`.`notification_date`, `cr`.`type`",
>      [
>        1731421812
>      ],
>      [
>        2
>      ]
>    )
>
>    /var/www/webapps/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.phpÐÐ¸Ð½Ð¸Ñ 249
>
>    OC\DB\QueryBuilder\QueryBuilder->executeQuery(
>      [
>        "OC\\DB\\ConnectionAdapter"
>      ]
>    )
>
>    /var/www/webapps/nextcloud/apps/dav/lib/CalDAV/Reminder/Backend.phpÐÐ¸Ð½Ð¸Ñ 53
>
>    OC\DB\QueryBuilder\QueryBuilder->execute()
>
>    /var/www/webapps/nextcloud/apps/dav/lib/CalDAV/Reminder/ReminderService.phpÐÐ¸Ð½Ð¸Ñ 104
>
>    OCA\DAV\CalDAV\Reminder\Backend->getRemindersToProcess()
>
>    /var/www/webapps/nextcloud/apps/dav/lib/BackgroundJob/EventReminderJob.phpÐÐ¸Ð½Ð¸Ñ 50
>
>    OCA\DAV\CalDAV\Reminder\ReminderService->processReminders()
>
>    /var/www/webapps/nextcloud/lib/public/BackgroundJob/Job.phpÐÐ¸Ð½Ð¸Ñ 61
>
>    OCA\DAV\BackgroundJob\EventReminderJob->run(
>      null
>    )
>
>    /var/www/webapps/nextcloud/lib/public/BackgroundJob/TimedJob.phpÐÐ¸Ð½Ð¸Ñ 83
>
>    OCP\BackgroundJob\Job->start(
>      [
>        "OC\\BackgroundJob\\JobList"
>      ]
>    )
>
>    /var/www/webapps/nextcloud/lib/public/BackgroundJob/TimedJob.phpÐÐ¸Ð½Ð¸Ñ 73
>
>    OCP\BackgroundJob\TimedJob->start(
>      [
>        "OC\\BackgroundJob\\JobList"
>      ]
>    )
>
>    /var/www/webapps/nextcloud/cron.phpÐÐ¸Ð½Ð¸Ñ 162
>
>    OCP\BackgroundJob\TimedJob->execute(
>      [
>        "OC\\BackgroundJob\\JobList"
>      ]
>    )
>
>ÐÑÐ·Ð²Ð°Ð½Ð¾ Exception SQLSTATE[42803]: Grouping error: 7 ERROR: column "cr.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT "cr".*, "co"."calendardata", "c"."displayname", "c"."... ^

Actions: View

Attachments on bug 52028: 17168