Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing ' SELECT o.skautisId, SUM(ci.price) as sum

Sentry Issue: H-SKAUTING-CZ-1S6
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'o.skautisId' in 'field list'
  File "/home/vu008930/releases/20240425-1606-5c7c376/app/model/Stat/ReadModel/QueryHandlers/EventStatisticsQueryHandler.php", line 45, in Model\Event\ReadModel\QueryHandlers\EventStatisticsQueryHandler::__invoke
    $stmt = $this->db->executeQuery($sql, $params, $types);
  File "/home/vu008930/releases/20240425-1606-5c7c376/app/model/Common/Services/MessengerQueryBus.php", line 22, in Model\Common\Services\MessengerQueryBus::handle
    $stamp = $this->queryBus->dispatch($query)->last(HandledStamp::class);
  File "/home/vu008930/releases/20240425-1606-5c7c376/app/model/Stat/StatisticsService.php", line 32, in Model\StatisticsService::getEventStatistics
    $eventStats = $this->queryBus->handle(new EventStatisticsQuery(array_keys($events), $year));
  File "/home/vu008930/releases/20240425-1606-5c7c376/app/AccountancyModule/StatisticsModule/presenter/DefaultPresenter.php", line 27, in App\AccountancyModule\StatisticsModule\DefaultPresenter::renderDefault
    $data     = $this->statService->getEventStatistics($unitTree, $year);
  File "/index.php", line 10
    $container->getService('application')->run();
...
(12 additional frame(s) were not displayed)

Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'o.skautisId' in 'field list'
  File "/home/vu008930/releases/20240425-1606-5c7c376/app/model/Stat/ReadModel/QueryHandlers/EventStatisticsQueryHandler.php", line 45, in Model\Event\ReadModel\QueryHandlers\EventStatisticsQueryHandler::__invoke
    $stmt = $this->db->executeQuery($sql, $params, $types);
  File "/home/vu008930/releases/20240425-1606-5c7c376/app/model/Common/Services/MessengerQueryBus.php", line 22, in Model\Common\Services\MessengerQueryBus::handle
    $stamp = $this->queryBus->dispatch($query)->last(HandledStamp::class);
  File "/home/vu008930/releases/20240425-1606-5c7c376/app/model/Stat/StatisticsService.php", line 32, in Model\StatisticsService::getEventStatistics
    $eventStats = $this->queryBus->handle(new EventStatisticsQuery(array_keys($events), $year));
  File "/home/vu008930/releases/20240425-1606-5c7c376/app/AccountancyModule/StatisticsModule/presenter/DefaultPresenter.php", line 27, in App\AccountancyModule\StatisticsModule\DefaultPresenter::renderDefault
    $data     = $this->statService->getEventStatistics($unitTree, $year);
  File "/index.php", line 10
    $container->getService('application')->run();
...
(12 additional frame(s) were not displayed)

Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing '            SELECT o.skautisId, SUM(ci.price) as sum
            FROM `ac_chits` c
            LEFT JOIN `ac_chit_to_item` cti ON c.id = cti.chit_id
            LEFT JOIN `ac_chits_item` ci ON cti.item_id = ci.id
            JOIN ac_event_cashbooks o ON c.eventId = o.cashbookId
            WHERE o.id IN (?, ?, ?, ?, ?, ?) AND category_operation_type = ? AND YEAR(date) = ?
            GROUP BY eventId' with params [18717, 19028, 18149, 19076, 19094, 19088, "out", 2024]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'o.skautisId' in 'field list'
  File "/home/vu008930/releases/20240425-1606-5c7c376/app/model/Stat/ReadModel/QueryHandlers/EventStatisticsQueryHandler.php", line 45, in Model\Event\ReadModel\QueryHandlers\EventStatisticsQueryHandler::__invoke
    $stmt = $this->db->executeQuery($sql, $params, $types);
  File "/home/vu008930/releases/20240425-1606-5c7c376/app/model/Common/Services/MessengerQueryBus.php", line 22, in Model\Common\Services\MessengerQueryBus::handle
    $stamp = $this->queryBus->dispatch($query)->last(HandledStamp::class);
  File "/home/vu008930/releases/20240425-1606-5c7c376/app/model/Stat/StatisticsService.php", line 32, in Model\StatisticsService::getEventStatistics
    $eventStats = $this->queryBus->handle(new EventStatisticsQuery(array_keys($events), $year));
  File "/home/vu008930/releases/20240425-1606-5c7c376/app/AccountancyModule/StatisticsModule/presenter/DefaultPresenter.php", line 27, in App\AccountancyModule\StatisticsModule\DefaultPresenter::renderDefault
    $data     = $this->statService->getEventStatistics($unitTree, $year);
  File "/index.php", line 10
    $container->getService('application')->run();
...
(14 additional frame(s) were not displayed)

An exception occurred while executing '            SELECT o.skautisId, SUM(ci.price) as sum
            FROM `ac_chits` c
            LEFT JOIN `ac_chit_to_item` cti ON c.id = cti.chit_id
            LEFT JOIN `ac_chits_item` ci ON cti.item_id = ci.id
            JOIN ac_event_cashbooks o ON c.eventId = o.cashbookId
            WHERE o.id IN (?, ?, ?, ?, ?, ?) AND category_operation_type = ? AND YEAR(date) = ?
            GROUP BY eventId' with params [18717, 19028, 18149, 19076, 19094, 19088, "out", 2024]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'o.skautisId' in 'field list'
skaut / Skautske-hospodareni

Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing ' SELECT o.skautisId, SUM(ci.price) as sum #2739
