Error 500 Internal Server Error

GET https://medilum.keszul.hu/szolgaltatasok/vizsgalatok/laboratoriumi-vizsgalatok/Kedvezmenyes-laborvizsgalati-csomagjaink

IP
216.73.217.58
Profiled on
Token
97cea4
Forwarded to ErrorController (9e499a)

Exceptions

QueryException QueryException

HTTP 500 Internal Server Error

[Syntax Error] line 0, col 65: Error: Expected known function, got 'RAND'

Exceptions 2

Doctrine\ORM\Query\ QueryException

in vendor/doctrine/orm/src/Query/QueryException.php (line 23)
  1.         return new self($dql);
  2.     }
  4.     public static function syntaxError(string $message, Throwable|null $previous = null): self
  5.     {
  6.         return new self('[Syntax Error] ' . $message, 0, $previous);
  7.     }
  9.     public static function semanticalError(string $message, Throwable|null $previous = null): self
  10.     {
  11.         return new self('[Semantical Error] ' . $message, 0, $previous);
in vendor/doctrine/orm/src/Query/Parser.php :: syntaxError (line 432)
  2.         $message  = sprintf('line 0, col %d: Error: ', $tokenPos);
  3.         $message .= $expected !== '' ? sprintf('Expected %s, got ', $expected) : 'Unexpected ';
  4.         $message .= $this->lexer->lookahead === null ? 'end of string.' : sprintf("'%s'", $token->value);
  6.         throw QueryException::syntaxError($message, QueryException::dqlError($this->query->getDQL() ?? ''));
  7.     }
  9.     /**
  10.      * Generates a new semantical error.
  11.      *
in vendor/doctrine/orm/src/Query/Parser.php -> syntaxError (line 3359)
  2.             case isset(self::$datetimeFunctions[$funcName]):
  3.                 return $this->FunctionsReturningDatetime();
  5.             default:
  6.                 $this->syntaxError('known function', $token);
  7.         }
  8.     }
  10.     /**
  11.      * Helper function for FunctionDeclaration grammar rule.
in vendor/doctrine/orm/src/Query/Parser.php -> FunctionDeclaration (line 1471)
  1.         $expr = match (true) {
  2.             $this->isMathOperator($peek) || $this->isMathOperator($glimpse) => $this->SimpleArithmeticExpression(),
  3.             $glimpse !== null && $glimpse->type === TokenType::T_DOT => $this->SingleValuedPathExpression(),
  4.             $this->lexer->peek() && $this->isMathOperator($this->peekBeyondClosingParenthesis()) => $this->ScalarExpression(),
  5.             $this->lexer->lookahead->type === TokenType::T_CASE => $this->CaseExpression(),
  6.             $this->isFunction() => $this->FunctionDeclaration(),
  7.             default => $this->ResultVariable(),
  8.         };
  10.         $type = 'ASC';
  11.         $item = new AST\OrderByItem($expr);
in vendor/doctrine/orm/src/Query/Parser.php -> OrderByItem (line 1379)
  1.     {
  2.         $this->match(TokenType::T_ORDER);
  3.         $this->match(TokenType::T_BY);
  5.         $orderByItems   = [];
  6.         $orderByItems[] = $this->OrderByItem();
  8.         while ($this->lexer->isNextToken(TokenType::T_COMMA)) {
  9.             $this->match(TokenType::T_COMMA);
  11.             $orderByItems[] = $this->OrderByItem();
in vendor/doctrine/orm/src/Query/Parser.php -> OrderByClause (line 848)
  1.         $selectStatement = new AST\SelectStatement($this->SelectClause(), $this->FromClause());
  3.         $selectStatement->whereClause   = $this->lexer->isNextToken(TokenType::T_WHERE) ? $this->WhereClause() : null;
  4.         $selectStatement->groupByClause = $this->lexer->isNextToken(TokenType::T_GROUP) ? $this->GroupByClause() : null;
  5.         $selectStatement->havingClause  = $this->lexer->isNextToken(TokenType::T_HAVING) ? $this->HavingClause() : null;
  6.         $selectStatement->orderByClause = $this->lexer->isNextToken(TokenType::T_ORDER) ? $this->OrderByClause() : null;
  8.         return $selectStatement;
  9.     }
  11.     /**
in vendor/doctrine/orm/src/Query/Parser.php -> SelectStatement (line 814)
  2.         $this->lexer->moveNext();
  4.         switch ($this->lexer->lookahead->type ?? null) {
  5.             case TokenType::T_SELECT:
  6.                 $statement = $this->SelectStatement();
  7.                 break;
  9.             case TokenType::T_UPDATE:
  10.                 $statement = $this->UpdateStatement();
  11.                 break;
in vendor/doctrine/orm/src/Query/Parser.php -> QueryLanguage (line 238)
  1.      * Parses and builds AST for the given Query.
  2.      */
  3.     public function getAST(): AST\SelectStatement|AST\UpdateStatement|AST\DeleteStatement
  4.     {
  5.         // Parse & build AST
  6.         $AST = $this->QueryLanguage();
  8.         // Process any deferred validations of some nodes in the AST.
  9.         // This also allows post-processing of the AST for modification purposes.
  10.         $this->processDeferredIdentificationVariables();
in vendor/doctrine/orm/src/Query/Parser.php -> getAST (line 330)
  1.     /**
  2.      * Parses a query string.
  3.      */
  4.     public function parse(): ParserResult
  5.     {
  6.         $AST = $this->getAST();
  8.         $customWalkers = $this->query->getHint(Query::HINT_CUSTOM_TREE_WALKERS);
  9.         if ($customWalkers !== false) {
  10.             $this->customTreeWalkers = $customWalkers;
  11.         }
in vendor/doctrine/orm/src/Query.php -> parse (line 248)
  1.         }
  3.         // Cache miss.
  4.         $parser = new Parser($this);
  6.         $this->parserResult = $parser->parse();
  8.         $queryCache->save($cacheItem->set($this->parserResult)->expiresAfter($this->queryCacheTTL));
  10.         return $this->parserResult;
  11.     }
in vendor/doctrine/orm/src/Query.php -> parse (line 717)
  1.         $this->state = self::STATE_DIRTY;
  2.     }
  4.     private function getSqlExecutor(): AbstractSqlExecutor
  5.     {
  6.         return $this->parse()->prepareSqlExecutor($this);
  7.     }
  8. }
in vendor/doctrine/orm/src/Query.php -> getSqlExecutor (line 257)
  1.         return $this->parserResult;
  2.     }
  4.     protected function _doExecute(): Result|int
  5.     {
  6.         $executor = $this->getSqlExecutor();
  8.         if ($this->queryCacheProfile) {
  9.             $executor->setQueryCacheProfile($this->queryCacheProfile);
  10.         } else {
  11.             $executor->removeQueryCacheProfile();
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 930)
  1.             $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2.                 $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3.             };
  4.         }
  6.         $stmt = $this->_doExecute();
  8.         if (is_numeric($stmt)) {
  9.             $setCacheEntry($stmt);
  11.             return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 886)
  1.     ): mixed {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4.         }
  6.         return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7.     }
  9.     /**
  10.      * Execute query ignoring second level cache.
  11.      *
in vendor/doctrine/orm/src/AbstractQuery.php -> execute (line 688)
  1.      *
  2.      * @phpstan-param string|AbstractQuery::HYDRATE_* $hydrationMode
  3.      */
  4.     public function getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed
  5.     {
  6.         return $this->execute(null, $hydrationMode);
  7.     }
  9.     /**
  10.      * Gets the array of results for the query.
  11.      *
AbstractQuery->getResult() in src/Repository/ReviewRepository.php (line 27)
  1.         $qb->select('r.id')
  2.             ->where('r.active = 1')
  3.             ->orderBy('RAND()')
  4.             ->setMaxResults(10);
  6.         $ids = array_column($qb->getQuery()->getResult(), 'id');
  8.         return $this->createQueryBuilder('r')
  9.             ->where('r.id IN (:ids)')
  10.             ->setParameter('ids', $ids)
  11.             ->getQuery()
ReviewRepository->getRandomReview() in src/Service/Pages/ProductService.php (line 120)
  1.             }
  2.         }
  4.         $reviewList = $this->currentProduct->getReview();
  5.         if ($reviewList === null || $reviewList->isEmpty()){
  6.             $reviewList = $this->reviewRepo->getRandomReview();
  7.         }
  8.         foreach ($reviewList as $review) {
  9.             $this->reviewSchema[] = [
  10.                 "@context" => "https://schema.org",
  11.                 "@type" => "Review",
ProductService->getData(object(EvcMenu), array('page1' => 'vizsgalatok', 'page2' => 'laboratoriumi-vizsgalatok', 'page3' => 'Kedvezmenyes-laborvizsgalati-csomagjaink')) in src/Controller/PageController.php (line 154)
  1.             $serviceName = "articleService";
  2.             $currentPage = $this->menuService->getMenuByAlias("404");
  3.             $templateDir = 'article';
  4.         }
  6.         $data = $this->$serviceName->getData($currentPage,$pages);
  8.         $render = $this->render($templateDir."/index.html.twig", $data);
  10.         if($this->notFound) {
  11.             $render->setStatusCode(Response::HTTP_NOT_FOUND);
PageController->pageGenerate('szolgaltatasok', array('page1' => 'vizsgalatok', 'page2' => 'laboratoriumi-vizsgalatok', 'page3' => 'Kedvezmenyes-laborvizsgalati-csomagjaink')) in src/Controller/PageController.php (line 105)
  1.         $pages = [
  2.             'page1' => $page,
  3.             'page2' => $page2,
  4.             'page3' => $page3
  5.         ];
  6.         return $this->pageGenerate($id,$pages);
  7.     }
  9.     #[Route('/{id}/{page}/{page2}/{page3}/{page4}', name: 'app_subpage4', requirements: ['paths' => '.+'])]
  10.     public function subpage4(string $id,string $page, string $page2, string $page3, string $page4): Response
  11.     {
in vendor/symfony/http-kernel/HttpKernel.php -> subpage3 (line 183)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         $response = null;
  5.         try {
  6.             return $response = $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 182)
  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.     }
in vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php -> handle (line 86)
  1.         if (!IpUtils::checkIp('127.0.0.1', $trustedProxies)) {
  2.             Request::setTrustedProxies(array_merge($trustedProxies, ['127.0.0.1']), Request::getTrustedHeaderSet());
  3.         }
  5.         try {
  6.             return $kernel->handle($request, $type, $catch);
  7.         } finally {
  8.             // restore global state
  9.             Request::setTrustedProxies($trustedProxies, $trustedHeaderSet);
  10.         }
  11.     }
in vendor/symfony/http-kernel/HttpCache/HttpCache.php :: handle (line 461)
  1.     protected function forward(Request $request, bool $catch = false, ?Response $entry = null): Response
  2.     {
  3.         $this->surrogate?->addSurrogateCapability($request);
  5.         // always a "master" request (as the real master request can be in cache)
  6.         $response = SubRequestHandler::handle($this->kernel, $request, HttpKernelInterface::MAIN_REQUEST, $catch);
  8.         /*
  9.          * Support stale-if-error given on Responses or as a config option.
  10.          * RFC 7234 summarizes in Section 4.2.4 (but also mentions with the individual
  11.          * Cache-Control directives) that
in vendor/symfony/framework-bundle/HttpCache/HttpCache.php -> forward (line 68)
  1.     protected function forward(Request $request, bool $catch = false, ?Response $entry = null): Response
  2.     {
  3.         $this->getKernel()->boot();
  4.         $this->getKernel()->getContainer()->set('cache', $this);
  6.         return parent::forward($request, $catch, $entry);
  7.     }
  9.     /**
  10.      * Returns an array of options to customize the Cache configuration.
  11.      */
in vendor/symfony/http-kernel/HttpCache/HttpCache.php -> forward (line 438)
  2.         // avoid that the backend sends no content
  3.         $subRequest->headers->remove('If-Modified-Since');
  4.         $subRequest->headers->remove('If-None-Match');
  6.         $response = $this->forward($subRequest, $catch);
  8.         if ($response->isCacheable()) {
  9.             $this->store($request, $response);
  10.         }
in vendor/symfony/http-kernel/HttpCache/HttpCache.php -> fetch (line 336)
  1.         }
  3.         if (null === $entry) {
  4.             $this->record($request, 'miss');
  6.             return $this->fetch($request, $catch);
  7.         }
  9.         if (!$this->isFreshEnough($request, $entry)) {
  10.             $this->record($request, 'stale');
in vendor/symfony/http-kernel/HttpCache/HttpCache.php -> lookup (line 214)
  1.                 reload the cache by fetching a fresh response and caching it (if possible).
  2.             */
  3.             $this->record($request, 'reload');
  4.             $response = $this->fetch($request, $catch);
  5.         } else {
  6.             $response = $this->lookup($request, $catch);
  7.         }
  9.         $this->restoreResponseBody($request, $response);
  11.         if (HttpKernelInterface::MAIN_REQUEST === $type) {
in vendor/symfony/http-kernel/Kernel.php -> handle (line 173)
  1.     {
  2.         if (!$this->booted) {
  3.             $container = $this->container ?? $this->preBoot();
  5.             if ($container->has('http_cache')) {
  6.                 return $container->get('http_cache')->handle($request, $type, $catch);
  7.             }
  8.         }
  10.         $this->boot();
  11.         ++$this->requestStackSize;
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.     ) {
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  8.         if (Kernel::VERSION_ID >= 60400) {
  9.             $response->send(false);
  11.             if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/keszulhu/data/www/medilum.keszul.hu/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

Doctrine\ORM\Query\ QueryException

SELECT r.id FROM App\Entity\Review r WHERE r.active = 1 ORDER BY RAND() ASC

in vendor/doctrine/orm/src/Query/QueryException.php (line 18)
  2. class QueryException extends Exception implements ORMException
  3. {
  4.     public static function dqlError(string $dql): self
  5.     {
  6.         return new self($dql);
  7.     }
  9.     public static function syntaxError(string $message, Throwable|null $previous = null): self
  10.     {
  11.         return new self('[Syntax Error] ' . $message, 0, $previous);
in vendor/doctrine/orm/src/Query/Parser.php :: dqlError (line 432)
  2.         $message  = sprintf('line 0, col %d: Error: ', $tokenPos);
  3.         $message .= $expected !== '' ? sprintf('Expected %s, got ', $expected) : 'Unexpected ';
  4.         $message .= $this->lexer->lookahead === null ? 'end of string.' : sprintf("'%s'", $token->value);
  6.         throw QueryException::syntaxError($message, QueryException::dqlError($this->query->getDQL() ?? ''));
  7.     }
  9.     /**
  10.      * Generates a new semantical error.
  11.      *
in vendor/doctrine/orm/src/Query/Parser.php -> syntaxError (line 3359)
  2.             case isset(self::$datetimeFunctions[$funcName]):
  3.                 return $this->FunctionsReturningDatetime();
  5.             default:
  6.                 $this->syntaxError('known function', $token);
  7.         }
  8.     }
  10.     /**
  11.      * Helper function for FunctionDeclaration grammar rule.
in vendor/doctrine/orm/src/Query/Parser.php -> FunctionDeclaration (line 1471)
  1.         $expr = match (true) {
  2.             $this->isMathOperator($peek) || $this->isMathOperator($glimpse) => $this->SimpleArithmeticExpression(),
  3.             $glimpse !== null && $glimpse->type === TokenType::T_DOT => $this->SingleValuedPathExpression(),
  4.             $this->lexer->peek() && $this->isMathOperator($this->peekBeyondClosingParenthesis()) => $this->ScalarExpression(),
  5.             $this->lexer->lookahead->type === TokenType::T_CASE => $this->CaseExpression(),
  6.             $this->isFunction() => $this->FunctionDeclaration(),
  7.             default => $this->ResultVariable(),
  8.         };
  10.         $type = 'ASC';
  11.         $item = new AST\OrderByItem($expr);
in vendor/doctrine/orm/src/Query/Parser.php -> OrderByItem (line 1379)
  1.     {
  2.         $this->match(TokenType::T_ORDER);
  3.         $this->match(TokenType::T_BY);
  5.         $orderByItems   = [];
  6.         $orderByItems[] = $this->OrderByItem();
  8.         while ($this->lexer->isNextToken(TokenType::T_COMMA)) {
  9.             $this->match(TokenType::T_COMMA);
  11.             $orderByItems[] = $this->OrderByItem();
in vendor/doctrine/orm/src/Query/Parser.php -> OrderByClause (line 848)
  1.         $selectStatement = new AST\SelectStatement($this->SelectClause(), $this->FromClause());
  3.         $selectStatement->whereClause   = $this->lexer->isNextToken(TokenType::T_WHERE) ? $this->WhereClause() : null;
  4.         $selectStatement->groupByClause = $this->lexer->isNextToken(TokenType::T_GROUP) ? $this->GroupByClause() : null;
  5.         $selectStatement->havingClause  = $this->lexer->isNextToken(TokenType::T_HAVING) ? $this->HavingClause() : null;
  6.         $selectStatement->orderByClause = $this->lexer->isNextToken(TokenType::T_ORDER) ? $this->OrderByClause() : null;
  8.         return $selectStatement;
  9.     }
  11.     /**
in vendor/doctrine/orm/src/Query/Parser.php -> SelectStatement (line 814)
  2.         $this->lexer->moveNext();
  4.         switch ($this->lexer->lookahead->type ?? null) {
  5.             case TokenType::T_SELECT:
  6.                 $statement = $this->SelectStatement();
  7.                 break;
  9.             case TokenType::T_UPDATE:
  10.                 $statement = $this->UpdateStatement();
  11.                 break;
in vendor/doctrine/orm/src/Query/Parser.php -> QueryLanguage (line 238)
  1.      * Parses and builds AST for the given Query.
  2.      */
  3.     public function getAST(): AST\SelectStatement|AST\UpdateStatement|AST\DeleteStatement
  4.     {
  5.         // Parse & build AST
  6.         $AST = $this->QueryLanguage();
  8.         // Process any deferred validations of some nodes in the AST.
  9.         // This also allows post-processing of the AST for modification purposes.
  10.         $this->processDeferredIdentificationVariables();
in vendor/doctrine/orm/src/Query/Parser.php -> getAST (line 330)
  1.     /**
  2.      * Parses a query string.
  3.      */
  4.     public function parse(): ParserResult
  5.     {
  6.         $AST = $this->getAST();
  8.         $customWalkers = $this->query->getHint(Query::HINT_CUSTOM_TREE_WALKERS);
  9.         if ($customWalkers !== false) {
  10.             $this->customTreeWalkers = $customWalkers;
  11.         }
in vendor/doctrine/orm/src/Query.php -> parse (line 248)
  1.         }
  3.         // Cache miss.
  4.         $parser = new Parser($this);
  6.         $this->parserResult = $parser->parse();
  8.         $queryCache->save($cacheItem->set($this->parserResult)->expiresAfter($this->queryCacheTTL));
  10.         return $this->parserResult;
  11.     }
in vendor/doctrine/orm/src/Query.php -> parse (line 717)
  1.         $this->state = self::STATE_DIRTY;
  2.     }
  4.     private function getSqlExecutor(): AbstractSqlExecutor
  5.     {
  6.         return $this->parse()->prepareSqlExecutor($this);
  7.     }
  8. }
in vendor/doctrine/orm/src/Query.php -> getSqlExecutor (line 257)
  1.         return $this->parserResult;
  2.     }
  4.     protected function _doExecute(): Result|int
  5.     {
  6.         $executor = $this->getSqlExecutor();
  8.         if ($this->queryCacheProfile) {
  9.             $executor->setQueryCacheProfile($this->queryCacheProfile);
  10.         } else {
  11.             $executor->removeQueryCacheProfile();
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 930)
  1.             $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2.                 $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3.             };
  4.         }
  6.         $stmt = $this->_doExecute();
  8.         if (is_numeric($stmt)) {
  9.             $setCacheEntry($stmt);
  11.             return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 886)
  1.     ): mixed {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4.         }
  6.         return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7.     }
  9.     /**
  10.      * Execute query ignoring second level cache.
  11.      *
in vendor/doctrine/orm/src/AbstractQuery.php -> execute (line 688)
  1.      *
  2.      * @phpstan-param string|AbstractQuery::HYDRATE_* $hydrationMode
  3.      */
  4.     public function getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed
  5.     {
  6.         return $this->execute(null, $hydrationMode);
  7.     }
  9.     /**
  10.      * Gets the array of results for the query.
  11.      *
AbstractQuery->getResult() in src/Repository/ReviewRepository.php (line 27)
  1.         $qb->select('r.id')
  2.             ->where('r.active = 1')
  3.             ->orderBy('RAND()')
  4.             ->setMaxResults(10);
  6.         $ids = array_column($qb->getQuery()->getResult(), 'id');
  8.         return $this->createQueryBuilder('r')
  9.             ->where('r.id IN (:ids)')
  10.             ->setParameter('ids', $ids)
  11.             ->getQuery()
ReviewRepository->getRandomReview() in src/Service/Pages/ProductService.php (line 120)
  1.             }
  2.         }
  4.         $reviewList = $this->currentProduct->getReview();
  5.         if ($reviewList === null || $reviewList->isEmpty()){
  6.             $reviewList = $this->reviewRepo->getRandomReview();
  7.         }
  8.         foreach ($reviewList as $review) {
  9.             $this->reviewSchema[] = [
  10.                 "@context" => "https://schema.org",
  11.                 "@type" => "Review",
ProductService->getData(object(EvcMenu), array('page1' => 'vizsgalatok', 'page2' => 'laboratoriumi-vizsgalatok', 'page3' => 'Kedvezmenyes-laborvizsgalati-csomagjaink')) in src/Controller/PageController.php (line 154)
  1.             $serviceName = "articleService";
  2.             $currentPage = $this->menuService->getMenuByAlias("404");
  3.             $templateDir = 'article';
  4.         }
  6.         $data = $this->$serviceName->getData($currentPage,$pages);
  8.         $render = $this->render($templateDir."/index.html.twig", $data);
  10.         if($this->notFound) {
  11.             $render->setStatusCode(Response::HTTP_NOT_FOUND);
PageController->pageGenerate('szolgaltatasok', array('page1' => 'vizsgalatok', 'page2' => 'laboratoriumi-vizsgalatok', 'page3' => 'Kedvezmenyes-laborvizsgalati-csomagjaink')) in src/Controller/PageController.php (line 105)
  1.         $pages = [
  2.             'page1' => $page,
  3.             'page2' => $page2,
  4.             'page3' => $page3
  5.         ];
  6.         return $this->pageGenerate($id,$pages);
  7.     }
  9.     #[Route('/{id}/{page}/{page2}/{page3}/{page4}', name: 'app_subpage4', requirements: ['paths' => '.+'])]
  10.     public function subpage4(string $id,string $page, string $page2, string $page3, string $page4): Response
  11.     {
in vendor/symfony/http-kernel/HttpKernel.php -> subpage3 (line 183)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         $response = null;
  5.         try {
  6.             return $response = $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 182)
  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.     }
in vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php -> handle (line 86)
  1.         if (!IpUtils::checkIp('127.0.0.1', $trustedProxies)) {
  2.             Request::setTrustedProxies(array_merge($trustedProxies, ['127.0.0.1']), Request::getTrustedHeaderSet());
  3.         }
  5.         try {
  6.             return $kernel->handle($request, $type, $catch);
  7.         } finally {
  8.             // restore global state
  9.             Request::setTrustedProxies($trustedProxies, $trustedHeaderSet);
  10.         }
  11.     }
in vendor/symfony/http-kernel/HttpCache/HttpCache.php :: handle (line 461)
  1.     protected function forward(Request $request, bool $catch = false, ?Response $entry = null): Response
  2.     {
  3.         $this->surrogate?->addSurrogateCapability($request);
  5.         // always a "master" request (as the real master request can be in cache)
  6.         $response = SubRequestHandler::handle($this->kernel, $request, HttpKernelInterface::MAIN_REQUEST, $catch);
  8.         /*
  9.          * Support stale-if-error given on Responses or as a config option.
  10.          * RFC 7234 summarizes in Section 4.2.4 (but also mentions with the individual
  11.          * Cache-Control directives) that
in vendor/symfony/framework-bundle/HttpCache/HttpCache.php -> forward (line 68)
  1.     protected function forward(Request $request, bool $catch = false, ?Response $entry = null): Response
  2.     {
  3.         $this->getKernel()->boot();
  4.         $this->getKernel()->getContainer()->set('cache', $this);
  6.         return parent::forward($request, $catch, $entry);
  7.     }
  9.     /**
  10.      * Returns an array of options to customize the Cache configuration.
  11.      */
in vendor/symfony/http-kernel/HttpCache/HttpCache.php -> forward (line 438)
  2.         // avoid that the backend sends no content
  3.         $subRequest->headers->remove('If-Modified-Since');
  4.         $subRequest->headers->remove('If-None-Match');
  6.         $response = $this->forward($subRequest, $catch);
  8.         if ($response->isCacheable()) {
  9.             $this->store($request, $response);
  10.         }
in vendor/symfony/http-kernel/HttpCache/HttpCache.php -> fetch (line 336)
  1.         }
  3.         if (null === $entry) {
  4.             $this->record($request, 'miss');
  6.             return $this->fetch($request, $catch);
  7.         }
  9.         if (!$this->isFreshEnough($request, $entry)) {
  10.             $this->record($request, 'stale');
in vendor/symfony/http-kernel/HttpCache/HttpCache.php -> lookup (line 214)
  1.                 reload the cache by fetching a fresh response and caching it (if possible).
  2.             */
  3.             $this->record($request, 'reload');
  4.             $response = $this->fetch($request, $catch);
  5.         } else {
  6.             $response = $this->lookup($request, $catch);
  7.         }
  9.         $this->restoreResponseBody($request, $response);
  11.         if (HttpKernelInterface::MAIN_REQUEST === $type) {
in vendor/symfony/http-kernel/Kernel.php -> handle (line 173)
  1.     {
  2.         if (!$this->booted) {
  3.             $container = $this->container ?? $this->preBoot();
  5.             if ($container->has('http_cache')) {
  6.                 return $container->get('http_cache')->handle($request, $type, $catch);
  7.             }
  8.         }
  10.         $this->boot();
  11.         ++$this->requestStackSize;
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.     ) {
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  8.         if (Kernel::VERSION_ID >= 60400) {
  9.             $response->send(false);
  11.             if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/keszulhu/data/www/medilum.keszul.hu/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

Logs

Level Channel Message
INFO 15:23:57 deprecation User Deprecated: Support for MariaDB < 10.4 is deprecated and will be removed in DBAL 4. Consider upgrading to a more recent version of MariaDB. (AbstractMySQLDriver.php:66 called by AbstractDriverMiddleware.php:68, https://github.com/doctrine/dbal/pull/6110, package doctrine/dbal) 
{
    "exception": {}
}
INFO 15:23:57 doctrine Connecting with parameters {params} 
{
    "params": {
        "use_savepoints": true,
        "driver": "pdo_mysql",
        "idle_connection_ttl": 600,
        "host": "127.0.0.1",
        "port": 3399,
        "user": "symfony_medilum",
        "password": "<redacted>",
        "driverOptions": [],
        "defaultTableOptions": [],
        "dbname": "symfony_medilum",
        "serverVersion": "10.3.31-MariaDB",
        "charset": "utf8mb4"
    }
}
DEBUG 15:23:57 doctrine Executing query: SELECT t0.szavak_id AS szavak_id_1, t0.szavak_hu AS szavak_hu_2, t0.szavak_code AS szavak_code_3, t0.szavak_date AS szavak_date_4 FROM evc_szavak t0 
{
    "sql": "SELECT t0.szavak_id AS szavak_id_1, t0.szavak_hu AS szavak_hu_2, t0.szavak_code AS szavak_code_3, t0.szavak_date AS szavak_date_4 FROM evc_szavak t0"
}
DEBUG 15:23:57 doctrine Executing query: SELECT t0.acci_id AS acci_id_1, t0.acci_title AS acci_title_2, t0.acci_leir AS acci_leir_3, t0.acci_accid AS acci_accid_4, t0.acci_aktiv AS acci_aktiv_5, t0.acci_sorrend AS acci_sorrend_6 FROM evc_accordion_items t0 
{
    "sql": "SELECT t0.acci_id AS acci_id_1, t0.acci_title AS acci_title_2, t0.acci_leir AS acci_leir_3, t0.acci_accid AS acci_accid_4, t0.acci_aktiv AS acci_aktiv_5, t0.acci_sorrend AS acci_sorrend_6 FROM evc_accordion_items t0"
}
DEBUG 15:23:57 doctrine Executing query: SELECT t0.galeria_kepek_id AS galeria_kepek_id_1, t0.galeria_kepek_kepnev AS galeria_kepek_kepnev_2, t0.galeria_kepek_galeria_id AS galeria_kepek_galeria_id_3, t0.galeria_kepek_sorrend AS galeria_kepek_sorrend_4, t0.galeria_kepek_felirat_hu AS galeria_kepek_felirat_hu_5, t0.galeria_kepek_alt_hu AS galeria_kepek_alt_hu_6, t0.galeria_kepek_kepnev_cropped AS galeria_kepek_kepnev_cropped_7, t0.fo_kep_cropped AS fo_kep_cropped_8, t0.al_kep_cropped AS al_kep_cropped_9 FROM evc_galeria_kepek t0 
{
    "sql": "SELECT t0.galeria_kepek_id AS galeria_kepek_id_1, t0.galeria_kepek_kepnev AS galeria_kepek_kepnev_2, t0.galeria_kepek_galeria_id AS galeria_kepek_galeria_id_3, t0.galeria_kepek_sorrend AS galeria_kepek_sorrend_4, t0.galeria_kepek_felirat_hu AS galeria_kepek_felirat_hu_5, t0.galeria_kepek_alt_hu AS galeria_kepek_alt_hu_6, t0.galeria_kepek_kepnev_cropped AS galeria_kepek_kepnev_cropped_7, t0.fo_kep_cropped AS fo_kep_cropped_8, t0.al_kep_cropped AS al_kep_cropped_9 FROM evc_galeria_kepek t0"
}
DEBUG 15:23:57 doctrine Executing statement: SELECT t0.id AS id_1, t0.siteadmin_pass AS siteadmin_pass_2, t0.sitename AS sitename_3, t0.sitename_seo_hu AS sitename_seo_hu_4, t0.siteemail AS siteemail_5, t0.meta_desc_hu AS meta_desc_hu_6, t0.site_aktiv AS site_aktiv_7, t0.site_aktiv_uzenet AS site_aktiv_uzenet_8, t0.masolas_vedelem AS masolas_vedelem_9, t0.ev_logo_url AS ev_logo_url_10, t0.scroll_appointment AS scroll_appointment_11, t0.ev_logo_title AS ev_logo_title_12, t0.ev_img_title AS ev_img_title_13, t0.ev_img_alt AS ev_img_alt_14, t0.body AS body_15, t0.inactive_link AS inactive_link_16, t0.robots AS robots_17, t0.siteurl AS siteurl_18, t0.linkedin AS linkedin_19, t0.twitter AS twitter_20, t0.facebook AS facebook_21 FROM evc_config t0 WHERE t0.id = ? LIMIT 1 (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.siteadmin_pass AS siteadmin_pass_2, t0.sitename AS sitename_3, t0.sitename_seo_hu AS sitename_seo_hu_4, t0.siteemail AS siteemail_5, t0.meta_desc_hu AS meta_desc_hu_6, t0.site_aktiv AS site_aktiv_7, t0.site_aktiv_uzenet AS site_aktiv_uzenet_8, t0.masolas_vedelem AS masolas_vedelem_9, t0.ev_logo_url AS ev_logo_url_10, t0.scroll_appointment AS scroll_appointment_11, t0.ev_logo_title AS ev_logo_title_12, t0.ev_img_title AS ev_img_title_13, t0.ev_img_alt AS ev_img_alt_14, t0.body AS body_15, t0.inactive_link AS inactive_link_16, t0.robots AS robots_17, t0.siteurl AS siteurl_18, t0.linkedin AS linkedin_19, t0.twitter AS twitter_20, t0.facebook AS facebook_21 FROM evc_config t0 WHERE t0.id = ? LIMIT 1",
    "params": {
        "1": 1
    },
    "types": {
        "1": 1
    }
}
DEBUG 15:23:57 doctrine Executing statement: SELECT t0.id AS id_1, t0.shop_tel AS shop_tel_2, t0.shop_utca_hsz AS shop_utca_hsz_3, t0.shop_varos AS shop_varos_4, t0.shop_irsz AS shop_irsz_5 FROM evc_shop_config t0 WHERE t0.id = ? LIMIT 1 (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.id AS id_1, t0.shop_tel AS shop_tel_2, t0.shop_utca_hsz AS shop_utca_hsz_3, t0.shop_varos AS shop_varos_4, t0.shop_irsz AS shop_irsz_5 FROM evc_shop_config t0 WHERE t0.id = ? LIMIT 1",
    "params": {
        "1": 1
    },
    "types": {
        "1": 1
    }
}
DEBUG 15:23:57 doctrine Executing statement: SELECT t0.menu_id AS menu_id_1, t0.menu_title_hu AS menu_title_hu_2, t0.menu_seo_title_hu AS menu_seo_title_hu_3, t0.label AS label_4, t0.menu_alias_hu AS menu_alias_hu_5, t0.menu_cikk_id AS menu_cikk_id_6, t0.menu_tipus AS menu_tipus_7, t0.menu_fajlnev AS menu_fajlnev_8, t0.menu_szulo_id AS menu_szulo_id_9, t0.menu_szint AS menu_szint_10, t0.menu_sorrend AS menu_sorrend_11, t0.menu_aktiv AS menu_aktiv_12, t0.menu_date AS menu_date_13, t0.menu_pozicio AS menu_pozicio_14, t0.meta_desc_hu AS meta_desc_hu_15, t0.menu_url_hu AS menu_url_hu_16, t0.menu_fajl_hu AS menu_fajl_hu_17, t0.menu_mod AS menu_mod_18 FROM evc_menu t0 WHERE t0.menu_aktiv = ? ORDER BY t0.menu_sorrend ASC (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.menu_id AS menu_id_1, t0.menu_title_hu AS menu_title_hu_2, t0.menu_seo_title_hu AS menu_seo_title_hu_3, t0.label AS label_4, t0.menu_alias_hu AS menu_alias_hu_5, t0.menu_cikk_id AS menu_cikk_id_6, t0.menu_tipus AS menu_tipus_7, t0.menu_fajlnev AS menu_fajlnev_8, t0.menu_szulo_id AS menu_szulo_id_9, t0.menu_szint AS menu_szint_10, t0.menu_sorrend AS menu_sorrend_11, t0.menu_aktiv AS menu_aktiv_12, t0.menu_date AS menu_date_13, t0.menu_pozicio AS menu_pozicio_14, t0.meta_desc_hu AS meta_desc_hu_15, t0.menu_url_hu AS menu_url_hu_16, t0.menu_fajl_hu AS menu_fajl_hu_17, t0.menu_mod AS menu_mod_18 FROM evc_menu t0 WHERE t0.menu_aktiv = ? ORDER BY t0.menu_sorrend ASC",
    "params": {
        "1": 1
    },
    "types": {
        "1": 5
    }
}
DEBUG 15:23:57 doctrine Executing statement: SELECT t0.modulok_id AS modulok_id_1, t0.modulok_nev AS modulok_nev_2, t0.modulok_szoveg_hu AS modulok_szoveg_hu_3, t0.modulok_date AS modulok_date_4, t0.modulok_pozicio AS modulok_pozicio_5, t0.modulok_aktiv AS modulok_aktiv_6 FROM evc_modulok t0 WHERE t0.modulok_aktiv = ? (parameters: {params}, types: {types}) 
{
    "sql": "SELECT t0.modulok_id AS modulok_id_1, t0.modulok_nev AS modulok_nev_2, t0.modulok_szoveg_hu AS modulok_szoveg_hu_3, t0.modulok_date AS modulok_date_4, t0.modulok_pozicio AS modulok_pozicio_5, t0.modulok_aktiv AS modulok_aktiv_6 FROM evc_modulok t0 WHERE t0.modulok_aktiv = ?",
    "params": {
        "1": 1
    },
    "types": {
        "1": 5
    }
}
INFO 15:23:57 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "97cea4"
    },
    "request_uri": "https://medilum.keszul.hu/_profiler/97cea4",
    "method": "GET"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Nelmio\SecurityBundle\EventListener\ContentSecurityPolicyListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Nelmio\\SecurityBundle\\EventListener\\ContentSecurityPolicyListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\AssetMapper\\AssetMapperDevServerSubscriber::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "App\EventListener\GlobalListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "App\\EventListener\\GlobalListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 15:23:57 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 15:23:57 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
DEBUG 15:23:57 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Nelmio\SecurityBundle\EventListener\ContentSecurityPolicyListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Nelmio\\SecurityBundle\\EventListener\\ContentSecurityPolicyListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\AssetMapper\\AssetMapperDevServerSubscriber::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "App\EventListener\GlobalListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "App\\EventListener\\GlobalListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 15:23:57 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 15:23:57 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
DEBUG 15:23:57 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
DEBUG 15:23:57 event Notified event "kernel.response" to listener "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\AssetMapper\\AssetMapperDevServerSubscriber::onKernelResponse"
}
DEBUG 15:23:57 event Notified event "kernel.response" to listener "Nelmio\SecurityBundle\EventListener\ContentTypeListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Nelmio\\SecurityBundle\\EventListener\\ContentTypeListener::onKernelResponse"
}
DEBUG 15:23:57 event Notified event "kernel.response" to listener "Nelmio\SecurityBundle\EventListener\ReferrerPolicyListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Nelmio\\SecurityBundle\\EventListener\\ReferrerPolicyListener::onKernelResponse"
}
DEBUG 15:23:57 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ResponseListener::onKernelResponse"
}
DEBUG 15:23:57 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelResponse"
}
DEBUG 15:23:57 event Notified event "kernel.response" to listener "Nelmio\SecurityBundle\EventListener\ClickjackingListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Nelmio\\SecurityBundle\\EventListener\\ClickjackingListener::onKernelResponse"
}
DEBUG 15:23:57 event Notified event "kernel.response" to listener "Nelmio\SecurityBundle\EventListener\ContentSecurityPolicyListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Nelmio\\SecurityBundle\\EventListener\\ContentSecurityPolicyListener::onKernelResponse"
}
DEBUG 15:23:57 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelResponse"
}
DEBUG 15:23:57 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ProfilerListener::onKernelResponse"
}
DEBUG 15:23:57 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::removeCspHeader"
}
DEBUG 15:23:57 event Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Bundle\\WebProfilerBundle\\EventListener\\WebDebugToolbarListener::onKernelResponse"
}
DEBUG 15:23:57 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DisallowRobotsIndexingListener::onResponse"
}
DEBUG 15:23:57 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelResponse"
}
DEBUG 15:23:57 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelFinishRequest"
}
DEBUG 15:23:57 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelFinishRequest"
}
DEBUG 15:23:57 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelFinishRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Nelmio\SecurityBundle\EventListener\ContentSecurityPolicyListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Nelmio\\SecurityBundle\\EventListener\\ContentSecurityPolicyListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\AssetMapper\\AssetMapperDevServerSubscriber::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.request" to listener "App\EventListener\GlobalListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "App\\EventListener\\GlobalListener::onKernelRequest"
}
DEBUG 15:23:57 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 15:23:57 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 15:23:57 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
DEBUG 15:23:57 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}

Stack Traces 2

[2/2] QueryException 
Doctrine\ORM\Query\QueryException:
[Syntax Error] line 0, col 65: Error: Expected known function, got 'RAND'

  at vendor/doctrine/orm/src/Query/QueryException.php:23
  at Doctrine\ORM\Query\QueryException::syntaxError('line 0, col 65: Error: Expected known function, got \'RAND\'', object(QueryException))
     (vendor/doctrine/orm/src/Query/Parser.php:432)
  at Doctrine\ORM\Query\Parser->syntaxError('known function', object(Token))
     (vendor/doctrine/orm/src/Query/Parser.php:3359)
  at Doctrine\ORM\Query\Parser->FunctionDeclaration()
     (vendor/doctrine/orm/src/Query/Parser.php:1471)
  at Doctrine\ORM\Query\Parser->OrderByItem()
     (vendor/doctrine/orm/src/Query/Parser.php:1379)
  at Doctrine\ORM\Query\Parser->OrderByClause()
     (vendor/doctrine/orm/src/Query/Parser.php:848)
  at Doctrine\ORM\Query\Parser->SelectStatement()
     (vendor/doctrine/orm/src/Query/Parser.php:814)
  at Doctrine\ORM\Query\Parser->QueryLanguage()
     (vendor/doctrine/orm/src/Query/Parser.php:238)
  at Doctrine\ORM\Query\Parser->getAST()
     (vendor/doctrine/orm/src/Query/Parser.php:330)
  at Doctrine\ORM\Query\Parser->parse()
     (vendor/doctrine/orm/src/Query.php:248)
  at Doctrine\ORM\Query->parse()
     (vendor/doctrine/orm/src/Query.php:717)
  at Doctrine\ORM\Query->getSqlExecutor()
     (vendor/doctrine/orm/src/Query.php:257)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 1)
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute(null, 1)
     (vendor/doctrine/orm/src/AbstractQuery.php:688)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/Repository/ReviewRepository.php:27)
  at App\Repository\ReviewRepository->getRandomReview()
     (src/Service/Pages/ProductService.php:120)
  at App\Service\Pages\ProductService->getData(object(EvcMenu), array('page1' => 'vizsgalatok', 'page2' => 'laboratoriumi-vizsgalatok', 'page3' => 'Kedvezmenyes-laborvizsgalati-csomagjaink'))
     (src/Controller/PageController.php:154)
  at App\Controller\PageController->pageGenerate('szolgaltatasok', array('page1' => 'vizsgalatok', 'page2' => 'laboratoriumi-vizsgalatok', 'page3' => 'Kedvezmenyes-laborvizsgalati-csomagjaink'))
     (src/Controller/PageController.php:105)
  at App\Controller\PageController->subpage3('szolgaltatasok', 'vizsgalatok', 'laboratoriumi-vizsgalatok', 'Kedvezmenyes-laborvizsgalati-csomagjaink')
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:182)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php:86)
  at Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(object(Kernel), object(Request), 1, true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:461)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(object(Request), true, null)
     (vendor/symfony/framework-bundle/HttpCache/HttpCache.php:68)
  at Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward(object(Request), true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:438)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(object(Request), true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:336)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(object(Request), true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:214)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:173)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/keszulhu/data/www/medilum.keszul.hu/vendor/autoload_runtime.php')
     (public/index.php:5)
[1/2] QueryException 
Doctrine\ORM\Query\QueryException:
SELECT r.id FROM App\Entity\Review r WHERE r.active = 1 ORDER BY RAND() ASC

  at vendor/doctrine/orm/src/Query/QueryException.php:18
  at Doctrine\ORM\Query\QueryException::dqlError('SELECT r.id FROM App\\Entity\\Review r WHERE r.active = 1 ORDER BY RAND() ASC')
     (vendor/doctrine/orm/src/Query/Parser.php:432)
  at Doctrine\ORM\Query\Parser->syntaxError('known function', object(Token))
     (vendor/doctrine/orm/src/Query/Parser.php:3359)
  at Doctrine\ORM\Query\Parser->FunctionDeclaration()
     (vendor/doctrine/orm/src/Query/Parser.php:1471)
  at Doctrine\ORM\Query\Parser->OrderByItem()
     (vendor/doctrine/orm/src/Query/Parser.php:1379)
  at Doctrine\ORM\Query\Parser->OrderByClause()
     (vendor/doctrine/orm/src/Query/Parser.php:848)
  at Doctrine\ORM\Query\Parser->SelectStatement()
     (vendor/doctrine/orm/src/Query/Parser.php:814)
  at Doctrine\ORM\Query\Parser->QueryLanguage()
     (vendor/doctrine/orm/src/Query/Parser.php:238)
  at Doctrine\ORM\Query\Parser->getAST()
     (vendor/doctrine/orm/src/Query/Parser.php:330)
  at Doctrine\ORM\Query\Parser->parse()
     (vendor/doctrine/orm/src/Query.php:248)
  at Doctrine\ORM\Query->parse()
     (vendor/doctrine/orm/src/Query.php:717)
  at Doctrine\ORM\Query->getSqlExecutor()
     (vendor/doctrine/orm/src/Query.php:257)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 1)
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute(null, 1)
     (vendor/doctrine/orm/src/AbstractQuery.php:688)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/Repository/ReviewRepository.php:27)
  at App\Repository\ReviewRepository->getRandomReview()
     (src/Service/Pages/ProductService.php:120)
  at App\Service\Pages\ProductService->getData(object(EvcMenu), array('page1' => 'vizsgalatok', 'page2' => 'laboratoriumi-vizsgalatok', 'page3' => 'Kedvezmenyes-laborvizsgalati-csomagjaink'))
     (src/Controller/PageController.php:154)
  at App\Controller\PageController->pageGenerate('szolgaltatasok', array('page1' => 'vizsgalatok', 'page2' => 'laboratoriumi-vizsgalatok', 'page3' => 'Kedvezmenyes-laborvizsgalati-csomagjaink'))
     (src/Controller/PageController.php:105)
  at App\Controller\PageController->subpage3('szolgaltatasok', 'vizsgalatok', 'laboratoriumi-vizsgalatok', 'Kedvezmenyes-laborvizsgalati-csomagjaink')
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:182)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php:86)
  at Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(object(Kernel), object(Request), 1, true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:461)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(object(Request), true, null)
     (vendor/symfony/framework-bundle/HttpCache/HttpCache.php:68)
  at Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward(object(Request), true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:438)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(object(Request), true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:336)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(object(Request), true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:214)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:173)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/var/www/keszulhu/data/www/medilum.keszul.hu/vendor/autoload_runtime.php')
     (public/index.php:5)