Error 500 Internal Server Error

GET https://coffee.traductera.com/

Browse referrer URL
IP
172.22.22.2
Profiled on
Token
ba78fb

Exceptions

QueryException QueryException

HTTP 500 Internal Server Error

[Semantical Error] line 0, col -1 near 'SELECT cons AS': Error: Cannot select entity through identification variables without choosing at least one root entity alias.

Exceptions 2

Doctrine\ORM\Query\ QueryException

in vendor/doctrine/orm/src/Query/QueryException.php (line 28)
  1. return new self('[Syntax Error] ' . $message, 0, $previous);
  2. }
  4. public static function semanticalError(string $message, Throwable|null $previous = null): self
  5. {
  6. return new self('[Semantical Error] ' . $message, 0, $previous);
  7. }
  9. public static function invalidLockMode(): self
  10. {
  11. return new self('Invalid lock mode hint provided.');
in vendor/doctrine/orm/src/Query/Parser.php :: semanticalError (line 465)
  1. $tokenStr = substr($dql, $token->position, $length);
  3. // Building informative message
  4. $message = 'line 0, col ' . $tokenPos . " near '" . $tokenStr . "': Error: " . $message;
  6. throw QueryException::semanticalError($message, QueryException::dqlError($this->query->getDQL()));
  7. }
  9. /**
  10. * Peeks beyond the matched closing parenthesis and returns the first token after that one.
  11. *
in vendor/doctrine/orm/src/Query/Parser.php -> semanticalError (line 800)
  1. if (isset($this->queryComponents[$dqlAlias]) && ! isset($this->queryComponents[$dqlAlias]['parent'])) {
  2. return;
  3. }
  4. }
  6. $this->semanticalError('Cannot select entity through identification variables without choosing at least one root entity alias.');
  7. }
  9. /**
  10. * QueryLanguage ::= SelectStatement | UpdateStatement | DeleteStatement
  11. */
in vendor/doctrine/orm/src/Query/Parser.php -> processRootEntityAliasSelected (line 260)
  2. if ($this->deferredNewObjectExpressions) {
  3. $this->processDeferredNewObjectExpressions($AST);
  4. }
  6. $this->processRootEntityAliasSelected();
  8. // TODO: Is there a way to remove this? It may impact the mixed hydration resultset a lot!
  9. $this->fixIdentificationVariableOrder($AST);
  11. return $AST;
in vendor/doctrine/orm/src/Query/Parser.php -> getAST (line 330)
  1. /**
  2. * Parses a query string.
  3. */
  4. public function parse(): ParserResult
  5. {
  6. $AST = $this->getAST();
  8. $customWalkers = $this->query->getHint(Query::HINT_CUSTOM_TREE_WALKERS);
  9. if ($customWalkers !== false) {
  10. $this->customTreeWalkers = $customWalkers;
  11. }
in vendor/doctrine/orm/src/Query.php -> parse (line 248)
  1. }
  3. // Cache miss.
  4. $parser = new Parser($this);
  6. $this->parserResult = $parser->parse();
  8. $queryCache->save($cacheItem->set($this->parserResult)->expiresAfter($this->queryCacheTTL));
  10. return $this->parserResult;
  11. }
in vendor/doctrine/orm/src/Query.php -> parse (line 717)
  1. $this->state = self::STATE_DIRTY;
  2. }
  4. private function getSqlExecutor(): AbstractSqlExecutor
  5. {
  6. return $this->parse()->prepareSqlExecutor($this);
  7. }
  8. }
in vendor/doctrine/orm/src/Query.php -> getSqlExecutor (line 257)
  1. return $this->parserResult;
  2. }
  4. protected function _doExecute(): Result|int
  5. {
  6. $executor = $this->getSqlExecutor();
  8. if ($this->queryCacheProfile) {
  9. $executor->setQueryCacheProfile($this->queryCacheProfile);
  10. } else {
  11. $executor->removeQueryCacheProfile();
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 930)
  1. $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2. $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3. };
  4. }
  6. $stmt = $this->_doExecute();
  8. if (is_numeric($stmt)) {
  9. $setCacheEntry($stmt);
  11. return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 886)
  1. ): mixed {
  2. if ($this->cacheable && $this->isCacheEnabled()) {
  3. return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4. }
  6. return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7. }
  9. /**
  10. * Execute query ignoring second level cache.
  11. *
in vendor/doctrine/orm/src/AbstractQuery.php -> execute (line 688)
  1. *
  2. * @phpstan-param string|AbstractQuery::HYDRATE_* $hydrationMode
  3. */
  4. public function getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed
  5. {
  6. return $this->execute(null, $hydrationMode);
  7. }
  9. /**
  10. * Gets the array of results for the query.
  11. *
AbstractQuery->getResult() in src/Repository/CoffeeRepository.php (line 191)
  2. /**
  3. * @return list<array{person: Person, balance: float}>
  4. */
  5. public function findPersonsWithNegativeBalance(): array
  6. {
  7. $rows = $this->getEntityManager()->createQueryBuilder()
  8. ->select('p AS person')
  9. ->addSelect('COALESCE(SUM(c.amount), 0) AS balance')
  10. ->from(Person::class, 'p')
  11. ->leftJoin(Coffee::class, 'c', 'WITH', 'c.consumer = p')
CoffeeRepository->findPersonsWithNegativeBalance() in src/Controller/HomeController.php (line 68)
  2. if ($user->isAdminUser()) {
  3. return $this->render('home/index.html.twig', [
  4. 'is_superadmin_home' => true,
  5. 'admin_stats' => $this->loadAdminDashboardStats(),
  6. 'admin_negative_balances' => $this->coffeeRepository->findPersonsWithNegativeBalance(),
  7. 'admin_unconfirmed_coffees' => $this->coffeeRepository->findUnconfirmedRecent(15),
  8. 'admin_cashbox_balance' => $this->moneyRepository->sumAmount(),
  9. 'admin_recent_money' => $this->moneyRepository->findRecent(5),
  10. ]);
  11. }
in vendor/symfony/http-kernel/HttpKernel.php -> index (line 183)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  5. // call controller
  6. $response = $controller(...$arguments);
  8. // view
  9. if (!$response instanceof Response) {
  10. $event = new ViewEvent($this, $request, $type, $response, $event);
  11. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $this->handleRaw($request, $type);
  7. } catch (\Throwable $e) {
  8. if ($e instanceof \Error && !$this->handleAllThrowables) {
  9. throw $e;
  10. }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 193)
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  5. try {
  6. return $this->getHttpKernel()->handle($request, $type, $catch);
  7. } finally {
  8. --$this->requestStackSize;
  9. }
  10. }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. if (Kernel::VERSION_ID >= 60400) {
  9. $response->send(false);
  11. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/var/www/coffee/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return static function (array $context) {
  8. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

Doctrine\ORM\Query\ QueryException

SELECT cons AS person, COALESCE(SUM(c.amount), 0) AS balance FROM App\Entity\Coffee c LEFT JOIN c.consumer cons WHERE c.consumer IS NOT NULL GROUP BY cons.id HAVING COALESCE(SUM(c.amount), 0) < 0 ORDER BY balance ASC, cons.name ASC, cons.id ASC

in vendor/doctrine/orm/src/Query/QueryException.php (line 18)
  2. class QueryException extends Exception implements ORMException
  3. {
  4. public static function dqlError(string $dql): self
  5. {
  6. return new self($dql);
  7. }
  9. public static function syntaxError(string $message, Throwable|null $previous = null): self
  10. {
  11. return new self('[Syntax Error] ' . $message, 0, $previous);
in vendor/doctrine/orm/src/Query/Parser.php :: dqlError (line 465)
  1. $tokenStr = substr($dql, $token->position, $length);
  3. // Building informative message
  4. $message = 'line 0, col ' . $tokenPos . " near '" . $tokenStr . "': Error: " . $message;
  6. throw QueryException::semanticalError($message, QueryException::dqlError($this->query->getDQL()));
  7. }
  9. /**
  10. * Peeks beyond the matched closing parenthesis and returns the first token after that one.
  11. *
in vendor/doctrine/orm/src/Query/Parser.php -> semanticalError (line 800)
  1. if (isset($this->queryComponents[$dqlAlias]) && ! isset($this->queryComponents[$dqlAlias]['parent'])) {
  2. return;
  3. }
  4. }
  6. $this->semanticalError('Cannot select entity through identification variables without choosing at least one root entity alias.');
  7. }
  9. /**
  10. * QueryLanguage ::= SelectStatement | UpdateStatement | DeleteStatement
  11. */
in vendor/doctrine/orm/src/Query/Parser.php -> processRootEntityAliasSelected (line 260)
  2. if ($this->deferredNewObjectExpressions) {
  3. $this->processDeferredNewObjectExpressions($AST);
  4. }
  6. $this->processRootEntityAliasSelected();
  8. // TODO: Is there a way to remove this? It may impact the mixed hydration resultset a lot!
  9. $this->fixIdentificationVariableOrder($AST);
  11. return $AST;
in vendor/doctrine/orm/src/Query/Parser.php -> getAST (line 330)
  1. /**
  2. * Parses a query string.
  3. */
  4. public function parse(): ParserResult
  5. {
  6. $AST = $this->getAST();
  8. $customWalkers = $this->query->getHint(Query::HINT_CUSTOM_TREE_WALKERS);
  9. if ($customWalkers !== false) {
  10. $this->customTreeWalkers = $customWalkers;
  11. }
in vendor/doctrine/orm/src/Query.php -> parse (line 248)
  1. }
  3. // Cache miss.
  4. $parser = new Parser($this);
  6. $this->parserResult = $parser->parse();
  8. $queryCache->save($cacheItem->set($this->parserResult)->expiresAfter($this->queryCacheTTL));
  10. return $this->parserResult;
  11. }
in vendor/doctrine/orm/src/Query.php -> parse (line 717)
  1. $this->state = self::STATE_DIRTY;
  2. }
  4. private function getSqlExecutor(): AbstractSqlExecutor
  5. {
  6. return $this->parse()->prepareSqlExecutor($this);
  7. }
  8. }
in vendor/doctrine/orm/src/Query.php -> getSqlExecutor (line 257)
  1. return $this->parserResult;
  2. }
  4. protected function _doExecute(): Result|int
  5. {
  6. $executor = $this->getSqlExecutor();
  8. if ($this->queryCacheProfile) {
  9. $executor->setQueryCacheProfile($this->queryCacheProfile);
  10. } else {
  11. $executor->removeQueryCacheProfile();
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 930)
  1. $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2. $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3. };
  4. }
  6. $stmt = $this->_doExecute();
  8. if (is_numeric($stmt)) {
  9. $setCacheEntry($stmt);
  11. return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 886)
  1. ): mixed {
  2. if ($this->cacheable && $this->isCacheEnabled()) {
  3. return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4. }
  6. return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7. }
  9. /**
  10. * Execute query ignoring second level cache.
  11. *
in vendor/doctrine/orm/src/AbstractQuery.php -> execute (line 688)
  1. *
  2. * @phpstan-param string|AbstractQuery::HYDRATE_* $hydrationMode
  3. */
  4. public function getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed
  5. {
  6. return $this->execute(null, $hydrationMode);
  7. }
  9. /**
  10. * Gets the array of results for the query.
  11. *
AbstractQuery->getResult() in src/Repository/CoffeeRepository.php (line 191)
  2. /**
  3. * @return list<array{person: Person, balance: float}>
  4. */
  5. public function findPersonsWithNegativeBalance(): array
  6. {
  7. $rows = $this->getEntityManager()->createQueryBuilder()
  8. ->select('p AS person')
  9. ->addSelect('COALESCE(SUM(c.amount), 0) AS balance')
  10. ->from(Person::class, 'p')
  11. ->leftJoin(Coffee::class, 'c', 'WITH', 'c.consumer = p')
CoffeeRepository->findPersonsWithNegativeBalance() in src/Controller/HomeController.php (line 68)
  2. if ($user->isAdminUser()) {
  3. return $this->render('home/index.html.twig', [
  4. 'is_superadmin_home' => true,
  5. 'admin_stats' => $this->loadAdminDashboardStats(),
  6. 'admin_negative_balances' => $this->coffeeRepository->findPersonsWithNegativeBalance(),
  7. 'admin_unconfirmed_coffees' => $this->coffeeRepository->findUnconfirmedRecent(15),
  8. 'admin_cashbox_balance' => $this->moneyRepository->sumAmount(),
  9. 'admin_recent_money' => $this->moneyRepository->findRecent(5),
  10. ]);
  11. }
in vendor/symfony/http-kernel/HttpKernel.php -> index (line 183)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  5. // call controller
  6. $response = $controller(...$arguments);
  8. // view
  9. if (!$response instanceof Response) {
  10. $event = new ViewEvent($this, $request, $type, $response, $event);
  11. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $this->handleRaw($request, $type);
  7. } catch (\Throwable $e) {
  8. if ($e instanceof \Error && !$this->handleAllThrowables) {
  9. throw $e;
  10. }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 193)
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  5. try {
  6. return $this->getHttpKernel()->handle($request, $type, $catch);
  7. } finally {
  8. --$this->requestStackSize;
  9. }
  10. }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. if (Kernel::VERSION_ID >= 60400) {
  9. $response->send(false);
  11. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/var/www/coffee/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return static function (array $context) {
  8. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

Logs

Level Message
info 22:17:01 Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "ba78fb"
    },
    "request_uri": "https://coffee.traductera.com/_profiler/ba78fb?panel=exception&type=request",
    "method": "GET"
}
debug 22:17:01 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
debug 22:17:01 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
debug 22:17:01 Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest"
}
debug 22:17:01 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
debug 22:17:01 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
debug 22:17:01 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
debug 22:17:01 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
debug 22:17:01 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
debug 22:17:01 Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
debug 22:17:01 Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
debug 22:17:01 Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
debug 22:17:01 Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
info 22:17:01 User Deprecated: Support for MySQL < 8 is deprecated and will be removed in DBAL 5 (AbstractMySQLDriver.php:75 called by AbstractDriverMiddleware.php:32, https://github.com/doctrine/dbal/pull/6343, package doctrine/dbal) 
{
    "exception": {}
}
debug 22:17:01 Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\IsSignatureValidAttributeListener::onKernelControllerArguments"
}
debug 22:17:01 Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
}
debug 22:17:01 Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
debug 22:17:01 Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
debug 22:17:01 Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}

Stack Traces 2

[2/2] QueryException 
Doctrine\ORM\Query\QueryException:
[Semantical Error] line 0, col -1 near 'SELECT cons AS': Error: Cannot select entity through identification variables without choosing at least one root entity alias.

  at vendor/doctrine/orm/src/Query/QueryException.php:28
  at Doctrine\ORM\Query\QueryException::semanticalError()
     (vendor/doctrine/orm/src/Query/Parser.php:465)
  at Doctrine\ORM\Query\Parser->semanticalError()
     (vendor/doctrine/orm/src/Query/Parser.php:800)
  at Doctrine\ORM\Query\Parser->processRootEntityAliasSelected()
     (vendor/doctrine/orm/src/Query/Parser.php:260)
  at Doctrine\ORM\Query\Parser->getAST()
     (vendor/doctrine/orm/src/Query/Parser.php:330)
  at Doctrine\ORM\Query\Parser->parse()
     (vendor/doctrine/orm/src/Query.php:248)
  at Doctrine\ORM\Query->parse()
     (vendor/doctrine/orm/src/Query.php:717)
  at Doctrine\ORM\Query->getSqlExecutor()
     (vendor/doctrine/orm/src/Query.php:257)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/src/AbstractQuery.php:688)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/Repository/CoffeeRepository.php:191)
  at App\Repository\CoffeeRepository->findPersonsWithNegativeBalance()
     (src/Controller/HomeController.php:68)
  at App\Controller\HomeController->index()
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:193)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:32)
  at require_once('/var/www/coffee/vendor/autoload_runtime.php')
     (public/index.php:5)
[1/2] QueryException 
Doctrine\ORM\Query\QueryException:
SELECT cons AS person, COALESCE(SUM(c.amount), 0) AS balance FROM App\Entity\Coffee c LEFT JOIN c.consumer cons WHERE c.consumer IS NOT NULL GROUP BY cons.id HAVING COALESCE(SUM(c.amount), 0) < 0 ORDER BY balance ASC, cons.name ASC, cons.id ASC

  at vendor/doctrine/orm/src/Query/QueryException.php:18
  at Doctrine\ORM\Query\QueryException::dqlError()
     (vendor/doctrine/orm/src/Query/Parser.php:465)
  at Doctrine\ORM\Query\Parser->semanticalError()
     (vendor/doctrine/orm/src/Query/Parser.php:800)
  at Doctrine\ORM\Query\Parser->processRootEntityAliasSelected()
     (vendor/doctrine/orm/src/Query/Parser.php:260)
  at Doctrine\ORM\Query\Parser->getAST()
     (vendor/doctrine/orm/src/Query/Parser.php:330)
  at Doctrine\ORM\Query\Parser->parse()
     (vendor/doctrine/orm/src/Query.php:248)
  at Doctrine\ORM\Query->parse()
     (vendor/doctrine/orm/src/Query.php:717)
  at Doctrine\ORM\Query->getSqlExecutor()
     (vendor/doctrine/orm/src/Query.php:257)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/src/AbstractQuery.php:688)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/Repository/CoffeeRepository.php:191)
  at App\Repository\CoffeeRepository->findPersonsWithNegativeBalance()
     (src/Controller/HomeController.php:68)
  at App\Controller\HomeController->index()
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:193)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:32)
  at require_once('/var/www/coffee/vendor/autoload_runtime.php')
     (public/index.php:5)