https://dev5.tile.expert/en-bg/tile/castelvetro/deck-concept-outfit-2-0/a/xdk4agsx7-d-blackang-grad-toratosx

Method
GET
HTTP Status
500
IP
47.128.115.26
Profiled on
Token
2dcdcf

Exceptions

PDOException Exception InvalidFieldNameException

HTTP 500 Internal Server Error

An exception occurred while executing 'SELECT u0_.`id` AS id_0, u0_.`unid` AS unid_1, u0_.`corporate_unid` AS corporate_unid_2, u0_.`token` AS token_3, u0_.`is_active` AS is_active_4, u0_.`proved` AS proved_5, u0_.`alias` AS alias_6, u0_.`foreign_alias` AS foreign_alias_7, u0_.`lotus_name` AS lotus_name_8, u0_.`password` AS password_9, u0_.`expired` AS expired_10, u0_.`expires_at` AS expires_at_11, u0_.`credentials_expired` AS credentials_expired_12, u0_.`credentials_expire_at` AS credentials_expire_at_13, u0_.`last_ip` AS last_ip_14, u0_.`source` AS source_15, u0_.`social_network` AS social_network_16, u0_.`social_network_id` AS social_network_id_17, u0_.`google_id` AS google_id_18, u0_.`fb_id` AS fb_id_19, u0_.`vk_id` AS vk_id_20, u0_.`ig_id` AS ig_id_21, u0_.`test` AS test_22, u0_.`token_fixed` AS token_fixed_23, u0_.`bid` AS bid_24, u0_.`email` AS email_25, u0_.`salt` AS salt_26, u0_.`review_request_sent` AS review_request_sent_27, u0_.`username` AS username_28, u0_.`roles` AS roles_29, u0_.`enabled` AS enabled_30, u0_.`confirmation_token` AS confirmation_token_31, u0_.`last_login` AS last_login_32, u0_.`password_requested_at` AS password_requested_at_33, u0_.`security_field` AS security_field_34, u0_.`created_at` AS created_at_35, u0_.`is_legal_entity` AS is_legal_entity_36, u0_.`companyName` AS companyName_37, u0_.`vatNumber` AS vatNumber_38, u0_.`lang` AS lang_39 FROM `user` u0_ WHERE u0_.`token` = ? LIMIT 1' with params ["c8e1b27a1971dafcac376b9030aad0a86b753ee3dc78734de8da397d6ceb6a82"]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u0_.foreign_alias' in 'field list'

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 826)
  1.      * @throws NonUniqueResultException
  2.      */
  3.     public function getOneOrNullResult($hydrationMode = null)
  4.     {
  5.         try {
  6.             $result = $this->execute(null, $hydrationMode);
  7.         } catch (NoResultException $e) {
  8.             return null;
  9.         }
  11.         if ($this->_hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
AbstractQuery->getOneOrNullResult() in src/WebBundle/Repository/UserRepository.php (line 58)
  1.             ->where('u.token = :token')
  2.             ->setParameter('token', $token)
  3.             ->setMaxResults(1)
  4.             ->getQuery();
  6.         return $q->getOneOrNullResult();
  7.     }
  9.     /**
  10.      * выбор менегеров для отчета по БМ
  11.      * @return array|null
UserRepository->getUserByToken() in src/WebBundle/Service/CommonDataService.php (line 70)
  2.         // проверяем токен от авторизированого пользователя или нет
  3.         if (!$user && empty($_SESSION['token'])) {
  4.             /** @var UserRepository $userRepo */
  5.             $userRepo = App::getRepository('WebBundle:User');
  6.             $usr = $userRepo->getUserByToken($token);
  7.             if ($usr) {
  8.                 $token = $userInfo->generateToken();
  9.                 $userInfo->setToken($token);
  10.                 $_SESSION['token'] = $token;
  11.             }
CommonDataService->top() in src/FlexApp/Service/ParametersGenerator.php (line 22)
  1.      */
  2.     public function generate(array $parameters): array
  3.     {
  4.         $parameters['initialState'] = array_merge($parameters['initialState'] ?? [], [
  5.             'common' => [
  6.                 'top' => $this->commonDataService->top(),
  7.                 'footer' => $this->commonDataService->footer(),
  8.                 'constants' => $this->commonDataService->constants(),
  9.                 'userData' => $this->commonDataService->userData(),
  10.                 'urls' => $this->commonDataService->urls(),
  11.                 'trans' => $this->commonDataService->trans(),
ParametersGenerator->generate() in src/WebBundle/Controller/ExtendedController.php (line 240)
  1.      */
  2.     public function renderReact(string $template, $params = []): Response
  3.     {
  4.         /** @var ParametersGenerator $parametersGenerator */
  5.         $parametersGenerator = App::getContainer()->get(ParametersGenerator::class);
  6.         $params = $parametersGenerator->generate($params);
  8.         $oLeftService = App::getContainer()->get('app.service.leftmenu');
  9.         $params['initialState']['liteMenu'] = $oLeftService->getDataMenuLite();
  11.         return $this->render($template, $params);
ExtendedController->renderReact() in src/WebBundle/Controller/SliderController.php (line 503)
  1.                     'keyword' => '',
  2.                 ],
  3.                 //для динамического ремаркетинга
  4.                 'ecommProdid' => $data['elementId'],
  5.                 'ecommTotalvalue' => $art ? LocaleHelper::getPrice($art) : 0,
  6.                 'initialState' => ['slider' => $output],
  7.             ]);
  8.         }
  9.     }
  11.     /**
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 'u0_.foreign_alias' in 'field list'

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 826)
  1.      * @throws NonUniqueResultException
  2.      */
  3.     public function getOneOrNullResult($hydrationMode = null)
  4.     {
  5.         try {
  6.             $result = $this->execute(null, $hydrationMode);
  7.         } catch (NoResultException $e) {
  8.             return null;
  9.         }
  11.         if ($this->_hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
AbstractQuery->getOneOrNullResult() in src/WebBundle/Repository/UserRepository.php (line 58)
  1.             ->where('u.token = :token')
  2.             ->setParameter('token', $token)
  3.             ->setMaxResults(1)
  4.             ->getQuery();
  6.         return $q->getOneOrNullResult();
  7.     }
  9.     /**
  10.      * выбор менегеров для отчета по БМ
  11.      * @return array|null
UserRepository->getUserByToken() in src/WebBundle/Service/CommonDataService.php (line 70)
  2.         // проверяем токен от авторизированого пользователя или нет
  3.         if (!$user && empty($_SESSION['token'])) {
  4.             /** @var UserRepository $userRepo */
  5.             $userRepo = App::getRepository('WebBundle:User');
  6.             $usr = $userRepo->getUserByToken($token);
  7.             if ($usr) {
  8.                 $token = $userInfo->generateToken();
  9.                 $userInfo->setToken($token);
  10.                 $_SESSION['token'] = $token;
  11.             }
CommonDataService->top() in src/FlexApp/Service/ParametersGenerator.php (line 22)
  1.      */
  2.     public function generate(array $parameters): array
  3.     {
  4.         $parameters['initialState'] = array_merge($parameters['initialState'] ?? [], [
  5.             'common' => [
  6.                 'top' => $this->commonDataService->top(),
  7.                 'footer' => $this->commonDataService->footer(),
  8.                 'constants' => $this->commonDataService->constants(),
  9.                 'userData' => $this->commonDataService->userData(),
  10.                 'urls' => $this->commonDataService->urls(),
  11.                 'trans' => $this->commonDataService->trans(),
ParametersGenerator->generate() in src/WebBundle/Controller/ExtendedController.php (line 240)
  1.      */
  2.     public function renderReact(string $template, $params = []): Response
  3.     {
  4.         /** @var ParametersGenerator $parametersGenerator */
  5.         $parametersGenerator = App::getContainer()->get(ParametersGenerator::class);
  6.         $params = $parametersGenerator->generate($params);
  8.         $oLeftService = App::getContainer()->get('app.service.leftmenu');
  9.         $params['initialState']['liteMenu'] = $oLeftService->getDataMenuLite();
  11.         return $this->render($template, $params);
ExtendedController->renderReact() in src/WebBundle/Controller/SliderController.php (line 503)
  1.                     'keyword' => '',
  2.                 ],
  3.                 //для динамического ремаркетинга
  4.                 'ecommProdid' => $data['elementId'],
  5.                 'ecommTotalvalue' => $art ? LocaleHelper::getPrice($art) : 0,
  6.                 'initialState' => ['slider' => $output],
  7.             ]);
  8.         }
  9.     }
  11.     /**
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 'u0_.foreign_alias' in 'field list'

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 826)
  1.      * @throws NonUniqueResultException
  2.      */
  3.     public function getOneOrNullResult($hydrationMode = null)
  4.     {
  5.         try {
  6.             $result = $this->execute(null, $hydrationMode);
  7.         } catch (NoResultException $e) {
  8.             return null;
  9.         }
  11.         if ($this->_hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
AbstractQuery->getOneOrNullResult() in src/WebBundle/Repository/UserRepository.php (line 58)
  1.             ->where('u.token = :token')
  2.             ->setParameter('token', $token)
  3.             ->setMaxResults(1)
  4.             ->getQuery();
  6.         return $q->getOneOrNullResult();
  7.     }
  9.     /**
  10.      * выбор менегеров для отчета по БМ
  11.      * @return array|null
UserRepository->getUserByToken() in src/WebBundle/Service/CommonDataService.php (line 70)
  2.         // проверяем токен от авторизированого пользователя или нет
  3.         if (!$user && empty($_SESSION['token'])) {
  4.             /** @var UserRepository $userRepo */
  5.             $userRepo = App::getRepository('WebBundle:User');
  6.             $usr = $userRepo->getUserByToken($token);
  7.             if ($usr) {
  8.                 $token = $userInfo->generateToken();
  9.                 $userInfo->setToken($token);
  10.                 $_SESSION['token'] = $token;
  11.             }
CommonDataService->top() in src/FlexApp/Service/ParametersGenerator.php (line 22)
  1.      */
  2.     public function generate(array $parameters): array
  3.     {
  4.         $parameters['initialState'] = array_merge($parameters['initialState'] ?? [], [
  5.             'common' => [
  6.                 'top' => $this->commonDataService->top(),
  7.                 'footer' => $this->commonDataService->footer(),
  8.                 'constants' => $this->commonDataService->constants(),
  9.                 'userData' => $this->commonDataService->userData(),
  10.                 'urls' => $this->commonDataService->urls(),
  11.                 'trans' => $this->commonDataService->trans(),
ParametersGenerator->generate() in src/WebBundle/Controller/ExtendedController.php (line 240)
  1.      */
  2.     public function renderReact(string $template, $params = []): Response
  3.     {
  4.         /** @var ParametersGenerator $parametersGenerator */
  5.         $parametersGenerator = App::getContainer()->get(ParametersGenerator::class);
  6.         $params = $parametersGenerator->generate($params);
  8.         $oLeftService = App::getContainer()->get('app.service.leftmenu');
  9.         $params['initialState']['liteMenu'] = $oLeftService->getDataMenuLite();
  11.         return $this->render($template, $params);
ExtendedController->renderReact() in src/WebBundle/Controller/SliderController.php (line 503)
  1.                     'keyword' => '',
  2.                 ],
  3.                 //для динамического ремаркетинга
  4.                 'ecommProdid' => $data['elementId'],
  5.                 'ecommTotalvalue' => $art ? LocaleHelper::getPrice($art) : 0,
  6.                 'initialState' => ['slider' => $output],
  7.             ]);
  8.         }
  9.     }
  11.     /**
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 18:35:36 php User Deprecated: Since symfony/http-foundation 5.3: "Symfony\Component\HttpFoundation\RequestStack::getMasterRequest()" is deprecated, use "getMainRequest()" instead. 
{
    "exception": {}
}
INFO 18:35:36 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "2dcdcf"
    },
    "request_uri": "https://dev5.tile.expert/_profiler/2dcdcf?panel=exception",
    "method": "GET"
}
INFO 18:35:36 php User Deprecated: Since symfony/http-foundation 5.3: "Symfony\Component\HttpFoundation\RequestStack::getMasterRequest()" is deprecated, use "getMainRequest()" instead. 
{
    "exception": {}
}
INFO 18:35:36 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 18:35:36 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 18:35:36 php User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.native" service is deprecated, use "session.storage.factory.native" instead. 
{
    "exception": {}
}
INFO 18:35:36 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 u0_.`id` AS id_0, u0_.`unid` AS unid_1, u0_.`corporate_unid` AS corporate_unid_2, u0_.`token` AS token_3, u0_.`is_active` AS is_active_4, u0_.`proved` AS proved_5, u0_.`alias` AS alias_6, u0_.`foreign_alias` AS foreign_alias_7, u0_.`lotus_name` AS lotus_name_8, u0_.`password` AS password_9, u0_.`expired` AS expired_10, u0_.`expires_at` AS expires_at_11, u0_.`credentials_expired` AS credentials_expired_12, u0_.`credentials_expire_at` AS credentials_expire_at_13, u0_.`last_ip` AS last_ip_14, u0_.`source` AS source_15, u0_.`social_network` AS social_network_16, u0_.`social_network_id` AS social_network_id_17, u0_.`google_id` AS google_id_18, u0_.`fb_id` AS fb_id_19, u0_.`vk_id` AS vk_id_20, u0_.`ig_id` AS ig_id_21, u0_.`test` AS test_22, u0_.`token_fixed` AS token_fixed_23, u0_.`bid` AS bid_24, u0_.`email` AS email_25, u0_.`salt` AS salt_26, u0_.`review_request_sent` AS review_request_sent_27, u0_.`username` AS username_28, u0_.`roles` AS roles_29, u0_.`enabled` AS enabled_30, u0_.`confirmation_token` AS confirmation_token_31, u0_.`last_login` AS last_login_32, u0_.`password_requested_at` AS password_requested_at_33, u0_.`security_field` AS security_field_34, u0_.`created_at` AS created_at_35, u0_.`is_legal_entity` AS is_legal_entity_36, u0_.`companyName` AS companyName_37, u0_.`vatNumber` AS vatNumber_38, u0_.`lang` AS lang_39 FROM `user` u0_ WHERE u0_.`token` = ? LIMIT 1' with params ["c8e1b27a1971dafcac376b9030aad0a86b753ee3dc78734de8da397d6ceb6a82"]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u0_.foreign_alias' in 'field list'

  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:826)
  at Doctrine\ORM\AbstractQuery->getOneOrNullResult()
     (src/WebBundle/Repository/UserRepository.php:58)
  at WebBundle\Repository\UserRepository->getUserByToken()
     (src/WebBundle/Service/CommonDataService.php:70)
  at WebBundle\Service\CommonDataService->top()
     (src/FlexApp/Service/ParametersGenerator.php:22)
  at FlexApp\Service\ParametersGenerator->generate()
     (src/WebBundle/Controller/ExtendedController.php:240)
  at WebBundle\Controller\ExtendedController->renderReact()
     (src/WebBundle/Controller/SliderController.php:503)
  at WebBundle\Controller\SliderController->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 'u0_.foreign_alias' in 'field list'

  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:826)
  at Doctrine\ORM\AbstractQuery->getOneOrNullResult()
     (src/WebBundle/Repository/UserRepository.php:58)
  at WebBundle\Repository\UserRepository->getUserByToken()
     (src/WebBundle/Service/CommonDataService.php:70)
  at WebBundle\Service\CommonDataService->top()
     (src/FlexApp/Service/ParametersGenerator.php:22)
  at FlexApp\Service\ParametersGenerator->generate()
     (src/WebBundle/Controller/ExtendedController.php:240)
  at WebBundle\Controller\ExtendedController->renderReact()
     (src/WebBundle/Controller/SliderController.php:503)
  at WebBundle\Controller\SliderController->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 'u0_.foreign_alias' in 'field list'

  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:826)
  at Doctrine\ORM\AbstractQuery->getOneOrNullResult()
     (src/WebBundle/Repository/UserRepository.php:58)
  at WebBundle\Repository\UserRepository->getUserByToken()
     (src/WebBundle/Service/CommonDataService.php:70)
  at WebBundle\Service\CommonDataService->top()
     (src/FlexApp/Service/ParametersGenerator.php:22)
  at FlexApp\Service\ParametersGenerator->generate()
     (src/WebBundle/Controller/ExtendedController.php:240)
  at WebBundle\Controller\ExtendedController->renderReact()
     (src/WebBundle/Controller/SliderController.php:503)
  at WebBundle\Controller\SliderController->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)