Error 500 Internal Server Error

GET http://street-fighter-6.anagraph.org/en/news/index?%2Aparameters%5B%2Aparameters%5D%5B%2Aparameters%5D%5B%2Aparameters%5D%5B%2Aparameters%5D%5B%2Aparameters%5D%…

IP
192.168.208.2
Profiled on
Token
3f249e

Exceptions

InvalidArgumentException

HTTP 500 Internal Server Error

Offset must be a positive integer or zero, -20 given.

Exception

Doctrine\DBAL\Exception\ InvalidArgumentException

in vendor/doctrine/dbal/src/Platforms/AbstractPlatform.php (line 2086)
  1. * Adds an driver-specific LIMIT clause to the query.
  2. */
  3. final public function modifyLimitQuery(string $query, ?int $limit, int $offset = 0): string
  4. {
  5. if ($offset < 0) {
  6. throw new InvalidArgumentException(sprintf(
  7. 'Offset must be a positive integer or zero, %d given.',
  8. $offset,
  9. ));
  10. }
in vendor/doctrine/orm/src/Tools/Pagination/LimitSubqueryOutputWalker.php -> modifyLimitQuery (line 245)
  1. * @throws RuntimeException
  2. */
  3. public function walkSelectStatementWithoutRowNumber(SelectStatement $AST, bool $addMissingItemsFromOrderByToSelect = true): string
  4. {
  5. // Apply the limit and offset.
  6. return $this->platform->modifyLimitQuery(
  7. $this->createSqlWithoutRowNumber($AST, $addMissingItemsFromOrderByToSelect),
  8. $this->maxResults,
  9. $this->firstResult,
  10. );
  11. }
in vendor/doctrine/orm/src/Tools/Pagination/LimitSubqueryOutputWalker.php -> walkSelectStatementWithoutRowNumber (line 311)
  2. // This will populate $orderByPathExpressions via
  3. // LimitSubqueryOutputWalker::walkPathExpression, which will be called
  4. // as the select statement is walked. We'll end up with an array of all
  5. // path expressions referenced in the query.
  6. $walker->walkSelectStatementWithoutRowNumber($AST, false);
  7. $orderByPathExpressions = $walker->getOrderByPathExpressions();
  9. // Get a map of referenced identifiers to field names.
  10. $selects = [];
  11. foreach ($orderByPathExpressions as $pathExpression) {
in vendor/doctrine/orm/src/Tools/Pagination/LimitSubqueryOutputWalker.php -> addMissingItemsFromOrderByToSelect (line 259)
  1. // We don't want to call this recursively!
  2. if ($AST->orderByClause instanceof OrderByClause && $addMissingItemsFromOrderByToSelect) {
  3. // In the case of ordering a query by columns from joined tables, we
  4. // must add those columns to the select clause of the query BEFORE
  5. // the SQL is generated.
  6. $this->addMissingItemsFromOrderByToSelect($AST);
  7. }
  9. // Remove order by clause from the inner query
  10. // It will be re-appended in the outer select generated by this method
  11. $orderByClause = $AST->orderByClause;
in vendor/doctrine/orm/src/Tools/Pagination/LimitSubqueryOutputWalker.php -> createSqlWithoutRowNumber (line 173)
  1. }
  3. if ($this->platformSupportsRowNumber()) {
  4. $sql = $this->createSqlWithRowNumber($AST);
  5. } else {
  6. $sql = $this->createSqlWithoutRowNumber($AST);
  7. }
  9. return new SingleSelectSqlFinalizer($sql);
  10. }
in vendor/doctrine/orm/src/Query/Parser.php -> getFinalizer (line 363)
  2. $outputWalkerClass = $this->customOutputWalker ?: SqlOutputWalker::class;
  3. $outputWalker = new $outputWalkerClass($this->query, $this->parserResult, $this->queryComponents);
  5. if ($outputWalker instanceof OutputWalker) {
  6. $finalizer = $outputWalker->getFinalizer($AST);
  7. $this->parserResult->setSqlFinalizer($finalizer);
  8. } else {
  9. Deprecation::trigger(
  10. 'doctrine/orm',
  11. 'https://github.com/doctrine/orm/pull/11188/',
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 935)
  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 891)
  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 725)
  1. *
  2. * @return mixed[]
  3. */
  4. public function getScalarResult(): array
  5. {
  6. return $this->execute(null, self::HYDRATE_SCALAR);
  7. }
  9. /**
  10. * Get exactly one result or null.
  11. *
in vendor/doctrine/orm/src/Tools/Pagination/Paginator.php -> getScalarResult (line 127)
  1. $this->unbindUnusedQueryParams($subQuery);
  2. }
  4. $subQuery->setFirstResult($offset)->setMaxResults($length);
  6. $foundIdRows = $subQuery->getScalarResult();
  8. // don't do this for an empty id array
  9. if ($foundIdRows === []) {
  10. return new ArrayIterator([]);
  11. }
Paginator->getIterator() in src/Mapper/news/PostsPageMapper.php (line 21)
  1. private ObjectMapperInterface $objectMapper
  2. ) {}
  4. public function mapPaginatorToPostsPage(Paginator $paginator, InputBag $queryParameters): ItemsPage
  5. {
  6. $postDTOs = array_map(fn($postETT) => $this->objectMapper->map($postETT, postDTO::class), iterator_to_array($paginator->getIterator()));
  7. $pagesCount = ceil($paginator->count() / self::POSTS_PER_PAGE);
  8. $currentPage = $queryParameters->get('page') ?? 1;
  10. $queryParameters = $this->createQueryParametersArrayWithoutPage($queryParameters);
PostsPageMapper->mapPaginatorToPostsPage(object(Paginator), object(InputBag)) in src/Controller/news/NewsController.php (line 52)
  2. $filter = new Filter($language, $newerDate, $tag);
  4. $paginator = $this->queryBus->query(new GetPosts($page -1, $filter));
  6. $postsPage = $this->pageMapper->mapPaginatorToPostsPage($paginator, $request->query);
  8. return $this->render('skeletons/news/index.html.twig', ['posts_page' => $postsPage]);
  9. }
  11. #[Route(path: '/preview', name: 'app_news_preview', methods: [Request::METHOD_GET])]
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 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/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('/app/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 21:25:46 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "3f249e"
    },
    "request_uri": "http://street-fighter-6.anagraph.org/_profiler/3f249e",
    "method": "GET"
}
DEBUG 21:25:46 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 21:25:46 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 21:25:46 event Notified event "kernel.request" to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Nelmio\\CorsBundle\\EventListener\\CorsListener::onKernelRequest"
}
DEBUG 21:25:46 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 21:25:46 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 21:25:46 event Notified event "kernel.request" to listener "App\Listener\LocaleSubscriber::checkLocale". 
{
    "event": "kernel.request",
    "listener": "App\\Listener\\LocaleSubscriber::checkLocale"
}
DEBUG 21:25:46 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 21:25:46 event Notified event "kernel.request" to listener "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\AssetMapper\\AssetMapperDevServerSubscriber::onKernelRequest"
}
DEBUG 21:25:46 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 21:25:46 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 21:25:46 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 21:25:46 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 21:25:46 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 21:25:46 event Notified event "kernel.request" to listener "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\UX\\LiveComponent\\EventListener\\LiveComponentSubscriber::onKernelRequest"
}
DEBUG 21:25:46 event Notified event "kernel.controller" to listener "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\UX\\LiveComponent\\EventListener\\LiveComponentSubscriber::onKernelController"
}
DEBUG 21:25:46 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 21:25:46 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 21:25:46 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
}
DEBUG 21:25:46 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
DEBUG 21:25:46 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 21:25:46 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\Controller\\ArgumentResolver\\RequestPayloadValueResolver::onKernelControllerArguments"
}
DEBUG 21:25:46 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 Trace

InvalidArgumentException 
Doctrine\DBAL\Exception\InvalidArgumentException:
Offset must be a positive integer or zero, -20 given.

  at vendor/doctrine/dbal/src/Platforms/AbstractPlatform.php:2086
  at Doctrine\DBAL\Platforms\AbstractPlatform->modifyLimitQuery('SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_3 FROM (SELECT p0_.id AS id_0, p0_.link AS link_1, p0_.title AS title_2, p0_.published_at AS published_at_3, p0_.heading AS heading_4, p0_.language AS language_5, p0_.banner_link AS banner_link_6, p0_.tags AS tags_7 FROM post p0_) dctrn_result_inner ORDER BY published_at_3 DESC) dctrn_result', 20, -20)
     (vendor/doctrine/orm/src/Tools/Pagination/LimitSubqueryOutputWalker.php:245)
  at Doctrine\ORM\Tools\Pagination\LimitSubqueryOutputWalker->walkSelectStatementWithoutRowNumber(object(SelectStatement), false)
     (vendor/doctrine/orm/src/Tools/Pagination/LimitSubqueryOutputWalker.php:311)
  at Doctrine\ORM\Tools\Pagination\LimitSubqueryOutputWalker->addMissingItemsFromOrderByToSelect(object(SelectStatement))
     (vendor/doctrine/orm/src/Tools/Pagination/LimitSubqueryOutputWalker.php:259)
  at Doctrine\ORM\Tools\Pagination\LimitSubqueryOutputWalker->createSqlWithoutRowNumber(object(SelectStatement))
     (vendor/doctrine/orm/src/Tools/Pagination/LimitSubqueryOutputWalker.php:173)
  at Doctrine\ORM\Tools\Pagination\LimitSubqueryOutputWalker->getFinalizer(object(SelectStatement))
     (vendor/doctrine/orm/src/Query/Parser.php:363)
  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:935)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 3)
     (vendor/doctrine/orm/src/AbstractQuery.php:891)
  at Doctrine\ORM\AbstractQuery->execute(null, 3)
     (vendor/doctrine/orm/src/AbstractQuery.php:725)
  at Doctrine\ORM\AbstractQuery->getScalarResult()
     (vendor/doctrine/orm/src/Tools/Pagination/Paginator.php:127)
  at Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
     (src/Mapper/news/PostsPageMapper.php:21)
  at App\Mapper\news\PostsPageMapper->mapPaginatorToPostsPage(object(Paginator), object(InputBag))
     (src/Controller/news/NewsController.php:52)
  at App\Controller\news\NewsController->index(object(Request), 0, null, null, null)
     (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))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/app/vendor/autoload_runtime.php')
     (public/index.php:5)