Error 500 Internal Server Error

GET http://sae301.mmi24c04.mmi-troyes.fr/admin?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5CPromotionCrudController&page=1&sort%5Bpercentage%5D=DE…

IP
74.7.227.36
Profiled on
Token
62dd27
Forwarded to ErrorController (1c309a)

Exceptions

QueryException QueryException

HTTP 500 Internal Server Error

[Syntax Error] line 0, col 74: Error: Expected end of string, got 'DE'

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 832)
  1. break;
  2. }
  4. // Check for end of string
  5. if ($this->lexer->lookahead !== null) {
  6. $this->syntaxError('end of string');
  7. }
  9. return $statement;
  10. }
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/Tools/Pagination/Paginator.php -> parse (line 247)
  1. }
  3. private function unbindUnusedQueryParams(Query $query): void
  4. {
  5. $parser = new Parser($query);
  6. $parameterMappings = $parser->parse()->getParameterMappings();
  7. /** @var Collection|Parameter[] $parameters */
  8. $parameters = $query->getParameters();
  10. foreach ($parameters as $key => $parameter) {
  11. $parameterName = $parameter->getName();
in vendor/doctrine/orm/src/Tools/Pagination/Paginator.php -> unbindUnusedQueryParams (line 122)
  2. if ($this->useOutputWalker($subQuery)) {
  3. $subQuery->setHint(Query::HINT_CUSTOM_OUTPUT_WALKER, LimitSubqueryOutputWalker::class);
  4. } else {
  5. $this->appendTreeWalker($subQuery, LimitSubqueryWalker::class);
  6. $this->unbindUnusedQueryParams($subQuery);
  7. }
  9. $subQuery->setFirstResult($offset)->setMaxResults($length);
  11. $foundIdRows = $subQuery->getScalarResult();
in vendor/easycorp/easyadmin-bundle/src/Orm/EntityPaginator.php -> getIterator (line 68)
  1. $useOutputWalkers = null !== $havingPart;
  2. }
  3. }
  4. $paginator->setUseOutputWalkers($useOutputWalkers);
  6. $this->results = $paginator->getIterator();
  7. $this->numResults = $paginator->count();
  8. if ($this->rangeLastResultNumber > $this->numResults) {
  9. $this->rangeLastResultNumber = $this->numResults;
  10. }
in vendor/easycorp/easyadmin-bundle/src/Factory/PaginatorFactory.php -> paginate (line 26)
  1. {
  2. $adminContext = $this->adminContextProvider->getContext();
  3. $paginatorDto = $adminContext->getCrud()->getPaginator();
  4. $paginatorDto->setPageNumber((int) $adminContext->getRequest()->query->get('page', '1'));
  6. return $this->entityPaginator->paginate($paginatorDto, $queryBuilder);
  7. }
  8. }
in vendor/easycorp/easyadmin-bundle/src/Controller/AbstractCrudController.php -> create (line 138)
  1. }
  3. $fields = FieldCollection::new($this->configureFields(Crud::PAGE_INDEX));
  4. $filters = $this->container->get(FilterFactory::class)->create($context->getCrud()->getFiltersConfig(), $fields, $context->getEntity());
  5. $queryBuilder = $this->createIndexQueryBuilder($context->getSearch(), $context->getEntity(), $fields, $filters);
  6. $paginator = $this->container->get(PaginatorFactory::class)->create($queryBuilder);
  8. // this can happen after deleting some items and trying to return
  9. // to a 'index' page that no longer exists. Redirect to the last page instead
  10. if ($paginator->isOutOfRange()) {
  11. return $this->redirect($this->container->get(AdminUrlGenerator::class)
in vendor/symfony/http-kernel/HttpKernel.php -> index (line 183)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  5. // call controller
  6. $response = $controller(...$arguments);
  8. // view
  9. if (!$response instanceof Response) {
  10. $event = new ViewEvent($this, $request, $type, $response, $event);
  11. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $this->handleRaw($request, $type);
  7. } catch (\Throwable $e) {
  8. if ($e instanceof \Error && !$this->handleAllThrowables) {
  9. throw $e;
  10. }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 191)
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  5. try {
  6. return $this->getHttpKernel()->handle($request, $type, $catch);
  7. } finally {
  8. --$this->requestStackSize;
  9. }
  10. }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. if (Kernel::VERSION_ID >= 60400) {
  9. $response->send(false);
  11. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/var/www/SAE301/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 entity FROM App\Entity\Promotion entity ORDER BY entity.percentage DE…

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 832)
  1. break;
  2. }
  4. // Check for end of string
  5. if ($this->lexer->lookahead !== null) {
  6. $this->syntaxError('end of string');
  7. }
  9. return $statement;
  10. }
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/Tools/Pagination/Paginator.php -> parse (line 247)
  1. }
  3. private function unbindUnusedQueryParams(Query $query): void
  4. {
  5. $parser = new Parser($query);
  6. $parameterMappings = $parser->parse()->getParameterMappings();
  7. /** @var Collection|Parameter[] $parameters */
  8. $parameters = $query->getParameters();
  10. foreach ($parameters as $key => $parameter) {
  11. $parameterName = $parameter->getName();
in vendor/doctrine/orm/src/Tools/Pagination/Paginator.php -> unbindUnusedQueryParams (line 122)
  2. if ($this->useOutputWalker($subQuery)) {
  3. $subQuery->setHint(Query::HINT_CUSTOM_OUTPUT_WALKER, LimitSubqueryOutputWalker::class);
  4. } else {
  5. $this->appendTreeWalker($subQuery, LimitSubqueryWalker::class);
  6. $this->unbindUnusedQueryParams($subQuery);
  7. }
  9. $subQuery->setFirstResult($offset)->setMaxResults($length);
  11. $foundIdRows = $subQuery->getScalarResult();
in vendor/easycorp/easyadmin-bundle/src/Orm/EntityPaginator.php -> getIterator (line 68)
  1. $useOutputWalkers = null !== $havingPart;
  2. }
  3. }
  4. $paginator->setUseOutputWalkers($useOutputWalkers);
  6. $this->results = $paginator->getIterator();
  7. $this->numResults = $paginator->count();
  8. if ($this->rangeLastResultNumber > $this->numResults) {
  9. $this->rangeLastResultNumber = $this->numResults;
  10. }
in vendor/easycorp/easyadmin-bundle/src/Factory/PaginatorFactory.php -> paginate (line 26)
  1. {
  2. $adminContext = $this->adminContextProvider->getContext();
  3. $paginatorDto = $adminContext->getCrud()->getPaginator();
  4. $paginatorDto->setPageNumber((int) $adminContext->getRequest()->query->get('page', '1'));
  6. return $this->entityPaginator->paginate($paginatorDto, $queryBuilder);
  7. }
  8. }
in vendor/easycorp/easyadmin-bundle/src/Controller/AbstractCrudController.php -> create (line 138)
  1. }
  3. $fields = FieldCollection::new($this->configureFields(Crud::PAGE_INDEX));
  4. $filters = $this->container->get(FilterFactory::class)->create($context->getCrud()->getFiltersConfig(), $fields, $context->getEntity());
  5. $queryBuilder = $this->createIndexQueryBuilder($context->getSearch(), $context->getEntity(), $fields, $filters);
  6. $paginator = $this->container->get(PaginatorFactory::class)->create($queryBuilder);
  8. // this can happen after deleting some items and trying to return
  9. // to a 'index' page that no longer exists. Redirect to the last page instead
  10. if ($paginator->isOutOfRange()) {
  11. return $this->redirect($this->container->get(AdminUrlGenerator::class)
in vendor/symfony/http-kernel/HttpKernel.php -> index (line 183)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  5. // call controller
  6. $response = $controller(...$arguments);
  8. // view
  9. if (!$response instanceof Response) {
  10. $event = new ViewEvent($this, $request, $type, $response, $event);
  11. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $this->handleRaw($request, $type);
  7. } catch (\Throwable $e) {
  8. if ($e instanceof \Error && !$this->handleAllThrowables) {
  9. throw $e;
  10. }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 191)
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  5. try {
  6. return $this->getHttpKernel()->handle($request, $type, $catch);
  7. } finally {
  8. --$this->requestStackSize;
  9. }
  10. }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. if (Kernel::VERSION_ID >= 60400) {
  9. $response->send(false);
  11. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/var/www/SAE301/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 06:32:17 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "62dd27"
    },
    "request_uri": "https://sae301.mmi24c04.mmi-troyes.fr/_profiler/62dd27?panel=exception&type=request",
    "method": "GET"
}

Stack Traces 2

[2/2] QueryException 
Doctrine\ORM\Query\QueryException:
[Syntax Error] line 0, col 74: Error: Expected end of string, got 'DE'

  at vendor/doctrine/orm/src/Query/QueryException.php:23
  at Doctrine\ORM\Query\QueryException::syntaxError()
     (vendor/doctrine/orm/src/Query/Parser.php:432)
  at Doctrine\ORM\Query\Parser->syntaxError()
     (vendor/doctrine/orm/src/Query/Parser.php:832)
  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/Tools/Pagination/Paginator.php:247)
  at Doctrine\ORM\Tools\Pagination\Paginator->unbindUnusedQueryParams()
     (vendor/doctrine/orm/src/Tools/Pagination/Paginator.php:122)
  at Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
     (vendor/easycorp/easyadmin-bundle/src/Orm/EntityPaginator.php:68)
  at EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate()
     (vendor/easycorp/easyadmin-bundle/src/Factory/PaginatorFactory.php:26)
  at EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create()
     (vendor/easycorp/easyadmin-bundle/src/Controller/AbstractCrudController.php:138)
  at EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index()
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:191)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:32)
  at require_once('/var/www/SAE301/vendor/autoload_runtime.php')
     (public/index.php:5)
[1/2] QueryException 
Doctrine\ORM\Query\QueryException:
SELECT entity FROM App\Entity\Promotion entity ORDER BY entity.percentage DE…

  at vendor/doctrine/orm/src/Query/QueryException.php:18
  at Doctrine\ORM\Query\QueryException::dqlError()
     (vendor/doctrine/orm/src/Query/Parser.php:432)
  at Doctrine\ORM\Query\Parser->syntaxError()
     (vendor/doctrine/orm/src/Query/Parser.php:832)
  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/Tools/Pagination/Paginator.php:247)
  at Doctrine\ORM\Tools\Pagination\Paginator->unbindUnusedQueryParams()
     (vendor/doctrine/orm/src/Tools/Pagination/Paginator.php:122)
  at Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
     (vendor/easycorp/easyadmin-bundle/src/Orm/EntityPaginator.php:68)
  at EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate()
     (vendor/easycorp/easyadmin-bundle/src/Factory/PaginatorFactory.php:26)
  at EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create()
     (vendor/easycorp/easyadmin-bundle/src/Controller/AbstractCrudController.php:138)
  at EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index()
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:191)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:32)
  at require_once('/var/www/SAE301/vendor/autoload_runtime.php')
     (public/index.php:5)