https://dev5.tile.expert/en-dk/tile/sant-agostino/logico/f/pei

Method
GET
HTTP Status
500
IP
23.21.179.27
Profiled on
Token
7c8e5f

Exceptions

PDOException Exception InvalidFieldNameException

HTTP 500 Internal Server Error

An exception occurred while executing 'SELECT COUNT(c0_.`id`) AS sclr_0 FROM `comment_refact` c0_ LEFT JOIN `user` u1_ ON c0_.user_id = u1_.id WHERE c0_.`locale` = ? AND c0_.`category` = ? AND c0_.`commentable_unid` = ? AND (u1_.`foreign_alias` IS NULL OR u1_.`foreign_alias` <> ?)' with params ["en", 1, "", ""]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u1_.foreign_alias' in 'where clause'

Exceptions 3

Doctrine\DBAL\Exception\ InvalidFieldNameException

in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php (line 79)
  1.                 return new UniqueConstraintViolationException($message, $exception);
  3.             case '1054':
  4.             case '1166':
  5.             case '1611':
  6.                 return new InvalidFieldNameException($message, $exception);
  8.             case '1052':
  9.             case '1060':
  10.             case '1110':
  11.                 return new NonUniqueFieldNameException($message, $exception);
in vendor/sentry/sentry-symfony/src/Tracing/Doctrine/DBAL/TracingDriverForV2.php -> convertException (line 107)
  1.      * {@inheritdoc}
  2.      */
  3.     public function convertException($message, DriverException $exception): DBALDriverException
  4.     {
  5.         if ($this->decoratedDriver instanceof ExceptionConverterDriver) {
  6.             return $this->decoratedDriver->convertException($message, $exception);
  7.         }
  9.         return new DBALDriverException($message, $exception);
  10.     }
  11. }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php -> convertException (line 182)
  1.         if ($driverEx instanceof DriverException) {
  2.             return $driverEx;
  3.         }
  5.         if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DeprecatedDriverException) {
  6.             return $driver->convertException($msg, $driverEx);
  7.         }
  9.         return new Exception($msg, 0, $driverEx);
  10.     }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php :: wrapException (line 159)
  1.             $msg .= ' with params ' . self::formatParameters($params);
  2.         }
  4.         $msg .= ":\n\n" . $driverEx->getMessage();
  6.         return self::wrapException($driver, $driverEx, $msg);
  7.     }
  9.     /**
  10.      * @deprecated
  11.      *
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php :: driverExceptionDuringQuery (line 2226)
  1.         $this->throw(
  2.             Exception::driverExceptionDuringQuery(
  3.                 $this->_driver,
  4.                 $e,
  5.                 $sql,
  6.                 $this->resolveParams($params, $types)
  7.             )
  8.         );
  9.     }
  11.     /**
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php -> handleExceptionDuringQuery (line 1313)
  1.             } else {
  2.                 $stmt = $connection->query($sql);
  3.             }
  4.         } catch (Throwable $e) {
  5.             $this->handleExceptionDuringQuery(
  6.                 $e,
  7.                 $sql,
  8.                 $params,
  9.                 $types
  10.             );
  11.         }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php -> executeQuery (line 47)
  1.      *
  2.      * @return ResultStatement
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types)
  5.     {
  6.         return $conn->executeQuery($this->_sqlStatements, $params, $types, $this->queryCacheProfile);
  7.     }
  8. }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php -> execute (line 330)
  1.             $sqlParams,
  2.             $types,
  3.             $this->_em->getConnection()->getParams()
  4.         );
  6.         return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
  7.     }
  9.     /**
  10.      * @param array<string,mixed> $sqlParams
  11.      * @param array<string,Type>  $types
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> _doExecute (line 1074)
  2.                 $cache->save($cacheKey, $result, $queryCacheProfile->getLifetime());
  3.             };
  4.         }
  6.         $stmt = $this->_doExecute();
  8.         if (is_numeric($stmt)) {
  9.             $setCacheEntry($stmt);
  11.             return $stmt;
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> executeIgnoreQueryCache (line 1027)
  1.     {
  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/lib/Doctrine/ORM/AbstractQuery.php -> execute (line 863)
  1.      * @throws NonUniqueResultException If the query result is not unique.
  2.      * @throws NoResultException        If the query returned no result and hydration mode is not HYDRATE_SINGLE_SCALAR.
  3.      */
  4.     public function getSingleResult($hydrationMode = null)
  5.     {
  6.         $result = $this->execute(null, $hydrationMode);
  8.         if ($this->_hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
  9.             throw new NoResultException();
  10.         }
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> getSingleResult (line 892)
  1.      * @throws NoResultException        If the query returned no result.
  2.      * @throws NonUniqueResultException If the query result is not unique.
  3.      */
  4.     public function getSingleScalarResult()
  5.     {
  6.         return $this->getSingleResult(self::HYDRATE_SINGLE_SCALAR);
  7.     }
  9.     /**
  10.      * Sets a query hint. If the hint name is not recognized, it is silently ignored.
  11.      *
AbstractQuery->getSingleScalarResult() in src/FlexApp/Repository/CommentRepository.php (line 101)
  1.         }
  3.         $r = $query->getQuery();
  5.         try {
  6.             return $r->getSingleScalarResult();
  7.         } catch (NoResultException|NonUniqueResultException $e) {
  8.             return 0;
  9.         }
  10.     }
CommentRepository->getCommentCountData() in src/WebBundle/Service/CollectionService.php (line 80)
  1.     public function getCommentsCountData(string $unid): array
  2.     {
  3.         $commentRepo = App::em()->getRepository(CommentEntity::class);
  5.         return [
  6.             'questions' => $commentRepo->getCommentCountData($unid, App::getCurLocale(), false),
  7.             'answers' => $commentRepo->getCommentCountData($unid, App::getCurLocale())
  8.         ];
  9.     }
  11.     /**
CollectionService->getCommentsCountData() in src/WebBundle/Controller/TileController.php (line 457)
  1.             'itemsNoImg' => [],
  2.             'itemsNoImgCount' => 0,//(int)$itemsNoImgCount,
  3.             'itemsIds' => $itemsIds,
  4.             'alsoViewed' => null,
  5.             'alsoViewedUrl' => App::generateUrl('app_article_info', ['collectionId' => $collection['id']]),
  6.             'commentsCounts' => $this->collectionService->getCommentsCountData($collection['unid'] ?? ''),
  7.             'commentsBlockUrl' => App::generateUrl(
  8.                 'app_comment_block',
  9.                 [
  10.                     'entity' => $collection['id'],
  11.                     'type' => CommentableEntityTypes::COLLECTION,
in vendor/symfony/http-kernel/HttpKernel.php -> indexAction (line 163)
  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);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 75)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Exception $e) {
  8.             if ($e instanceof RequestExceptionInterface) {
  9.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  10.             }
  11.             if (false === $catch) {
in vendor/symfony/http-kernel/Kernel.php -> handle (line 202)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
Kernel->handle() in public/index.php (line 34)
  1. }
  3. Request::enableHttpMethodParameterOverride();
  4. $request = Request::createFromGlobals();
  5. define('BASE_URL', $request->getScheme() . '://tile.expert/');
  6. $response = $kernel->handle($request);
  7. $response->send();
  8. $kernel->terminate($request, $response);
require('/var/www/dev5.tile.expert/public/index.php') in web/index.php (line 3)
  1. <?php
  3. require '../public/index.php';

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u1_.foreign_alias' in 'where clause'

in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php (line 18)
  1.  */
  2. final class Exception extends PDOException
  3. {
  4.     public static function new(\PDOException $exception): self
  5.     {
  6.         return new self($exception);
  7.     }
  8. }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php :: new (line 119)
  1.     public function execute($params = null)
  2.     {
  3.         try {
  4.             return parent::execute($params);
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  8.     }
  10.     /**
  11.      * {@inheritdoc}
in vendor/sentry/sentry-symfony/src/Tracing/Doctrine/DBAL/AbstractTracingStatement.php -> execute (line 77)
  1.         if (null !== $span) {
  2.             $span = $span->startChild($spanContext);
  3.         }
  5.         try {
  6.             return $callback(...$args);
  7.         } finally {
  8.             if (null !== $span) {
  9.                 $span->finish();
  10.             }
  11.         }
in vendor/sentry/sentry-symfony/src/Tracing/Doctrine/DBAL/TracingStatementForV2.php -> traceFunction (line 124)
  1.         $spanContext = new SpanContext();
  2.         $spanContext->setOp(self::SPAN_OP_STMT_EXECUTE);
  3.         $spanContext->setDescription($this->sqlQuery);
  4.         $spanContext->setData($this->spanData);
  6.         return $this->traceFunction($spanContext, [$this->decoratedStatement, 'execute'], $params);
  7.     }
  8. }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php -> execute (line 1304)
  1.                 [$sql, $params, $types] = SQLParserUtils::expandListParameters($sql, $params, $types);
  3.                 $stmt = $connection->prepare($sql);
  4.                 if ($types) {
  5.                     $this->_bindTypedValues($stmt, $params, $types);
  6.                     $stmt->execute();
  7.                 } else {
  8.                     $stmt->execute($params);
  9.                 }
  10.             } else {
  11.                 $stmt = $connection->query($sql);
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php -> executeQuery (line 47)
  1.      *
  2.      * @return ResultStatement
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types)
  5.     {
  6.         return $conn->executeQuery($this->_sqlStatements, $params, $types, $this->queryCacheProfile);
  7.     }
  8. }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php -> execute (line 330)
  1.             $sqlParams,
  2.             $types,
  3.             $this->_em->getConnection()->getParams()
  4.         );
  6.         return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
  7.     }
  9.     /**
  10.      * @param array<string,mixed> $sqlParams
  11.      * @param array<string,Type>  $types
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> _doExecute (line 1074)
  2.                 $cache->save($cacheKey, $result, $queryCacheProfile->getLifetime());
  3.             };
  4.         }
  6.         $stmt = $this->_doExecute();
  8.         if (is_numeric($stmt)) {
  9.             $setCacheEntry($stmt);
  11.             return $stmt;
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> executeIgnoreQueryCache (line 1027)
  1.     {
  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/lib/Doctrine/ORM/AbstractQuery.php -> execute (line 863)
  1.      * @throws NonUniqueResultException If the query result is not unique.
  2.      * @throws NoResultException        If the query returned no result and hydration mode is not HYDRATE_SINGLE_SCALAR.
  3.      */
  4.     public function getSingleResult($hydrationMode = null)
  5.     {
  6.         $result = $this->execute(null, $hydrationMode);
  8.         if ($this->_hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
  9.             throw new NoResultException();
  10.         }
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> getSingleResult (line 892)
  1.      * @throws NoResultException        If the query returned no result.
  2.      * @throws NonUniqueResultException If the query result is not unique.
  3.      */
  4.     public function getSingleScalarResult()
  5.     {
  6.         return $this->getSingleResult(self::HYDRATE_SINGLE_SCALAR);
  7.     }
  9.     /**
  10.      * Sets a query hint. If the hint name is not recognized, it is silently ignored.
  11.      *
AbstractQuery->getSingleScalarResult() in src/FlexApp/Repository/CommentRepository.php (line 101)
  1.         }
  3.         $r = $query->getQuery();
  5.         try {
  6.             return $r->getSingleScalarResult();
  7.         } catch (NoResultException|NonUniqueResultException $e) {
  8.             return 0;
  9.         }
  10.     }
CommentRepository->getCommentCountData() in src/WebBundle/Service/CollectionService.php (line 80)
  1.     public function getCommentsCountData(string $unid): array
  2.     {
  3.         $commentRepo = App::em()->getRepository(CommentEntity::class);
  5.         return [
  6.             'questions' => $commentRepo->getCommentCountData($unid, App::getCurLocale(), false),
  7.             'answers' => $commentRepo->getCommentCountData($unid, App::getCurLocale())
  8.         ];
  9.     }
  11.     /**
CollectionService->getCommentsCountData() in src/WebBundle/Controller/TileController.php (line 457)
  1.             'itemsNoImg' => [],
  2.             'itemsNoImgCount' => 0,//(int)$itemsNoImgCount,
  3.             'itemsIds' => $itemsIds,
  4.             'alsoViewed' => null,
  5.             'alsoViewedUrl' => App::generateUrl('app_article_info', ['collectionId' => $collection['id']]),
  6.             'commentsCounts' => $this->collectionService->getCommentsCountData($collection['unid'] ?? ''),
  7.             'commentsBlockUrl' => App::generateUrl(
  8.                 'app_comment_block',
  9.                 [
  10.                     'entity' => $collection['id'],
  11.                     'type' => CommentableEntityTypes::COLLECTION,
in vendor/symfony/http-kernel/HttpKernel.php -> indexAction (line 163)
  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);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 75)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Exception $e) {
  8.             if ($e instanceof RequestExceptionInterface) {
  9.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  10.             }
  11.             if (false === $catch) {
in vendor/symfony/http-kernel/Kernel.php -> handle (line 202)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
Kernel->handle() in public/index.php (line 34)
  1. }
  3. Request::enableHttpMethodParameterOverride();
  4. $request = Request::createFromGlobals();
  5. define('BASE_URL', $request->getScheme() . '://tile.expert/');
  6. $response = $kernel->handle($request);
  7. $response->send();
  8. $kernel->terminate($request, $response);
require('/var/www/dev5.tile.expert/public/index.php') in web/index.php (line 3)
  1. <?php
  3. require '../public/index.php';

PDOException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u1_.foreign_alias' in 'where clause'

in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php (line 117)
  1.      */
  2.     #[ReturnTypeWillChange]
  3.     public function execute($params = null)
  4.     {
  5.         try {
  6.             return parent::execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  10.     }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php -> execute (line 117)
  1.      */
  2.     #[ReturnTypeWillChange]
  3.     public function execute($params = null)
  4.     {
  5.         try {
  6.             return parent::execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  10.     }
in vendor/sentry/sentry-symfony/src/Tracing/Doctrine/DBAL/AbstractTracingStatement.php -> execute (line 77)
  1.         if (null !== $span) {
  2.             $span = $span->startChild($spanContext);
  3.         }
  5.         try {
  6.             return $callback(...$args);
  7.         } finally {
  8.             if (null !== $span) {
  9.                 $span->finish();
  10.             }
  11.         }
in vendor/sentry/sentry-symfony/src/Tracing/Doctrine/DBAL/TracingStatementForV2.php -> traceFunction (line 124)
  1.         $spanContext = new SpanContext();
  2.         $spanContext->setOp(self::SPAN_OP_STMT_EXECUTE);
  3.         $spanContext->setDescription($this->sqlQuery);
  4.         $spanContext->setData($this->spanData);
  6.         return $this->traceFunction($spanContext, [$this->decoratedStatement, 'execute'], $params);
  7.     }
  8. }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php -> execute (line 1304)
  1.                 [$sql, $params, $types] = SQLParserUtils::expandListParameters($sql, $params, $types);
  3.                 $stmt = $connection->prepare($sql);
  4.                 if ($types) {
  5.                     $this->_bindTypedValues($stmt, $params, $types);
  6.                     $stmt->execute();
  7.                 } else {
  8.                     $stmt->execute($params);
  9.                 }
  10.             } else {
  11.                 $stmt = $connection->query($sql);
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php -> executeQuery (line 47)
  1.      *
  2.      * @return ResultStatement
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types)
  5.     {
  6.         return $conn->executeQuery($this->_sqlStatements, $params, $types, $this->queryCacheProfile);
  7.     }
  8. }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php -> execute (line 330)
  1.             $sqlParams,
  2.             $types,
  3.             $this->_em->getConnection()->getParams()
  4.         );
  6.         return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
  7.     }
  9.     /**
  10.      * @param array<string,mixed> $sqlParams
  11.      * @param array<string,Type>  $types
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> _doExecute (line 1074)
  2.                 $cache->save($cacheKey, $result, $queryCacheProfile->getLifetime());
  3.             };
  4.         }
  6.         $stmt = $this->_doExecute();
  8.         if (is_numeric($stmt)) {
  9.             $setCacheEntry($stmt);
  11.             return $stmt;
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> executeIgnoreQueryCache (line 1027)
  1.     {
  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/lib/Doctrine/ORM/AbstractQuery.php -> execute (line 863)
  1.      * @throws NonUniqueResultException If the query result is not unique.
  2.      * @throws NoResultException        If the query returned no result and hydration mode is not HYDRATE_SINGLE_SCALAR.
  3.      */
  4.     public function getSingleResult($hydrationMode = null)
  5.     {
  6.         $result = $this->execute(null, $hydrationMode);
  8.         if ($this->_hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
  9.             throw new NoResultException();
  10.         }
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> getSingleResult (line 892)
  1.      * @throws NoResultException        If the query returned no result.
  2.      * @throws NonUniqueResultException If the query result is not unique.
  3.      */
  4.     public function getSingleScalarResult()
  5.     {
  6.         return $this->getSingleResult(self::HYDRATE_SINGLE_SCALAR);
  7.     }
  9.     /**
  10.      * Sets a query hint. If the hint name is not recognized, it is silently ignored.
  11.      *
AbstractQuery->getSingleScalarResult() in src/FlexApp/Repository/CommentRepository.php (line 101)
  1.         }
  3.         $r = $query->getQuery();
  5.         try {
  6.             return $r->getSingleScalarResult();
  7.         } catch (NoResultException|NonUniqueResultException $e) {
  8.             return 0;
  9.         }
  10.     }
CommentRepository->getCommentCountData() in src/WebBundle/Service/CollectionService.php (line 80)
  1.     public function getCommentsCountData(string $unid): array
  2.     {
  3.         $commentRepo = App::em()->getRepository(CommentEntity::class);
  5.         return [
  6.             'questions' => $commentRepo->getCommentCountData($unid, App::getCurLocale(), false),
  7.             'answers' => $commentRepo->getCommentCountData($unid, App::getCurLocale())
  8.         ];
  9.     }
  11.     /**
CollectionService->getCommentsCountData() in src/WebBundle/Controller/TileController.php (line 457)
  1.             'itemsNoImg' => [],
  2.             'itemsNoImgCount' => 0,//(int)$itemsNoImgCount,
  3.             'itemsIds' => $itemsIds,
  4.             'alsoViewed' => null,
  5.             'alsoViewedUrl' => App::generateUrl('app_article_info', ['collectionId' => $collection['id']]),
  6.             'commentsCounts' => $this->collectionService->getCommentsCountData($collection['unid'] ?? ''),
  7.             'commentsBlockUrl' => App::generateUrl(
  8.                 'app_comment_block',
  9.                 [
  10.                     'entity' => $collection['id'],
  11.                     'type' => CommentableEntityTypes::COLLECTION,
in vendor/symfony/http-kernel/HttpKernel.php -> indexAction (line 163)
  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);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 75)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Exception $e) {
  8.             if ($e instanceof RequestExceptionInterface) {
  9.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  10.             }
  11.             if (false === $catch) {
in vendor/symfony/http-kernel/Kernel.php -> handle (line 202)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
Kernel->handle() in public/index.php (line 34)
  1. }
  3. Request::enableHttpMethodParameterOverride();
  4. $request = Request::createFromGlobals();
  5. define('BASE_URL', $request->getScheme() . '://tile.expert/');
  6. $response = $kernel->handle($request);
  7. $response->send();
  8. $kernel->terminate($request, $response);
require('/var/www/dev5.tile.expert/public/index.php') in web/index.php (line 3)
  1. <?php
  3. require '../public/index.php';

Logs

Level Channel Message
INFO 22:34:06 php User Deprecated: Since symfony/http-foundation 5.3: "Symfony\Component\HttpFoundation\RequestStack::getMasterRequest()" is deprecated, use "getMainRequest()" instead. 
{
    "exception": {}
}
INFO 22:34:06 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "7c8e5f"
    },
    "request_uri": "https://dev5.tile.expert/_profiler/7c8e5f?panel=exception",
    "method": "GET"
}
INFO 22:34:06 php User Deprecated: Since symfony/http-foundation 5.3: "Symfony\Component\HttpFoundation\RequestStack::getMasterRequest()" is deprecated, use "getMainRequest()" instead. 
{
    "exception": {}
}
INFO 22:34:06 php User Deprecated: Since symfony/framework-bundle 5.2: Accessing the "security.csrf.token_manager" service directly from the container is deprecated, use dependency injection instead. 
{
    "exception": {}
}
INFO 22:34:06 php User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.factory.service" service is deprecated, use "session.storage.factory.native", "session.storage.factory.php_bridge" or "session.storage.factory.mock_file" instead. 
{
    "exception": {}
}
INFO 22:34:06 php User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.native" service is deprecated, use "session.storage.factory.native" instead. 
{
    "exception": {}
}
INFO 22:34:06 php User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.metadata_bag" service is deprecated, create your own "session.storage.factory" instead. 
{
    "exception": {}
}

Stack Traces 3

[3/3] InvalidFieldNameException 
Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing 'SELECT COUNT(c0_.`id`) AS sclr_0 FROM `comment_refact` c0_ LEFT JOIN `user` u1_ ON c0_.user_id = u1_.id WHERE c0_.`locale` = ? AND c0_.`category` = ? AND c0_.`commentable_unid` = ? AND (u1_.`foreign_alias` IS NULL OR u1_.`foreign_alias` <> ?)' with params ["en", 1, "", ""]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u1_.foreign_alias' in 'where clause'

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79
  at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
     (vendor/sentry/sentry-symfony/src/Tracing/Doctrine/DBAL/TracingDriverForV2.php:107)
  at Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverForV2->convertException()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182)
  at Doctrine\DBAL\DBALException::wrapException()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159)
  at Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2226)
  at Doctrine\DBAL\Connection->handleExceptionDuringQuery()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1313)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:47)
  at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:330)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1074)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1027)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:863)
  at Doctrine\ORM\AbstractQuery->getSingleResult()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:892)
  at Doctrine\ORM\AbstractQuery->getSingleScalarResult()
     (src/FlexApp/Repository/CommentRepository.php:101)
  at FlexApp\Repository\CommentRepository->getCommentCountData()
     (src/WebBundle/Service/CollectionService.php:80)
  at WebBundle\Service\CollectionService->getCommentsCountData()
     (src/WebBundle/Controller/TileController.php:457)
  at WebBundle\Controller\TileController->indexAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:34)
  at require('/var/www/dev5.tile.expert/public/index.php')
     (web/index.php:3)
[2/3] Exception 
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u1_.foreign_alias' in 'where clause'

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119)
  at Doctrine\DBAL\Driver\PDOStatement->execute()
     (vendor/sentry/sentry-symfony/src/Tracing/Doctrine/DBAL/AbstractTracingStatement.php:77)
  at Sentry\SentryBundle\Tracing\Doctrine\DBAL\AbstractTracingStatement->traceFunction()
     (vendor/sentry/sentry-symfony/src/Tracing/Doctrine/DBAL/TracingStatementForV2.php:124)
  at Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV2->execute()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1304)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:47)
  at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:330)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1074)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1027)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:863)
  at Doctrine\ORM\AbstractQuery->getSingleResult()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:892)
  at Doctrine\ORM\AbstractQuery->getSingleScalarResult()
     (src/FlexApp/Repository/CommentRepository.php:101)
  at FlexApp\Repository\CommentRepository->getCommentCountData()
     (src/WebBundle/Service/CollectionService.php:80)
  at WebBundle\Service\CollectionService->getCommentsCountData()
     (src/WebBundle/Controller/TileController.php:457)
  at WebBundle\Controller\TileController->indexAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:34)
  at require('/var/www/dev5.tile.expert/public/index.php')
     (web/index.php:3)
[1/3] PDOException 
PDOException:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u1_.foreign_alias' in 'where clause'

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
  at PDOStatement->execute()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)
  at Doctrine\DBAL\Driver\PDOStatement->execute()
     (vendor/sentry/sentry-symfony/src/Tracing/Doctrine/DBAL/AbstractTracingStatement.php:77)
  at Sentry\SentryBundle\Tracing\Doctrine\DBAL\AbstractTracingStatement->traceFunction()
     (vendor/sentry/sentry-symfony/src/Tracing/Doctrine/DBAL/TracingStatementForV2.php:124)
  at Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV2->execute()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1304)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:47)
  at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:330)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1074)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1027)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:863)
  at Doctrine\ORM\AbstractQuery->getSingleResult()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:892)
  at Doctrine\ORM\AbstractQuery->getSingleScalarResult()
     (src/FlexApp/Repository/CommentRepository.php:101)
  at FlexApp\Repository\CommentRepository->getCommentCountData()
     (src/WebBundle/Service/CollectionService.php:80)
  at WebBundle\Service\CollectionService->getCommentsCountData()
     (src/WebBundle/Controller/TileController.php:457)
  at WebBundle\Controller\TileController->indexAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:34)
  at require('/var/www/dev5.tile.expert/public/index.php')
     (web/index.php:3)