https://dev5.tile.expert/en-mt/tile/versace/eterno/a/0263243-ins-dec-chevr-ice

Forwarded to
ErrorController (f1c62b)
Method
GET
HTTP Status
500
IP
47.128.40.24
Profiled on
Token
b3c95d

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 ["540cd2994a06977e324a44c5f4134605b0b8822643867f9e03b77f69a1954f50"]:

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 01:05:15 php User Deprecated: Since symfony/http-foundation 5.3: "Symfony\Component\HttpFoundation\RequestStack::getMasterRequest()" is deprecated, use "getMainRequest()" instead. 
{
    "exception": {}
}
INFO 01:05:15 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "b3c95d"
    },
    "request_uri": "https://dev5.tile.expert/_profiler/b3c95d",
    "method": "GET"
}
INFO 01:05:15 php User Deprecated: Since symfony/http-foundation 5.3: "Symfony\Component\HttpFoundation\RequestStack::getMasterRequest()" is deprecated, use "getMainRequest()" instead. 
{
    "exception": {}
}
INFO 01:05:15 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 01:05:15 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 01:05:15 php User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.native" service is deprecated, use "session.storage.factory.native" instead. 
{
    "exception": {}
}
INFO 01:05:15 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 ["540cd2994a06977e324a44c5f4134605b0b8822643867f9e03b77f69a1954f50"]:

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)