Symfony Exception

InvalidValueException

HTTP 500 Internal Server Error

There is no component aliased by [e] in the given Query

Exception

Knp\Component\Pager\Exception\ InvalidValueException

  1.             }
  2.             $alias $aliases[$index];
  3.             if ($alias !== false) {
  4.                 if (!array_key_exists($alias$components)) {
  5.                     throw new InvalidValueException("There is no component aliased by [$alias] in the given Query");
  6.                 }
  7.                 $meta $components[$alias];
  8.                 if (!$meta['metadata']->hasField($field)) {
  9.                     throw new InvalidValueException("There is no such field [$field] in the given Query component, aliased by [$alias]");
  10.                 }
  1.     }
  2.     public function walkSelectStatement(AST\SelectStatement $AST)
  3.     {
  4.         foreach ($this->getWalkers() as $walker) {
  5.             $walker->walkSelectStatement($AST);
  6.             $this->queryComponents $walker->getQueryComponents();
  7.         }
  8.     }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> walkSelectStatement (line 388)
  1.                     $treeWalkerChain->walkDeleteStatement($AST);
  2.                     break;
  3.                 case $AST instanceof AST\SelectStatement:
  4.                 default:
  5.                     $treeWalkerChain->walkSelectStatement($AST);
  6.             }
  7.             $this->queryComponents $treeWalkerChain->getQueryComponents();
  8.         }
  1.     }
  2.     private function unbindUnusedQueryParams(Query $query): void
  3.     {
  4.         $parser            = new Parser($query);
  5.         $parameterMappings $parser->parse()->getParameterMappings();
  6.         /** @var Collection|Parameter[] $parameters */
  7.         $parameters $query->getParameters();
  8.         foreach ($parameters as $key => $parameter) {
  9.             $parameterName $parameter->getName();
  1.             $countQuery->setHint(Query::HINT_CUSTOM_OUTPUT_WALKERCountOutputWalker::class);
  2.             $countQuery->setResultSetMapping($rsm);
  3.         } else {
  4.             $this->appendTreeWalker($countQueryCountWalker::class);
  5.             $this->unbindUnusedQueryParams($countQuery);
  6.         }
  7.         $countQuery->setFirstResult(0)->setMaxResults(null);
  8.         return $countQuery;
  1.     #[ReturnTypeWillChange]
  2.     public function count()
  3.     {
  4.         if ($this->count === null) {
  5.             try {
  6.                 $this->count = (int) array_sum(array_map('current'$this->getCountQuery()->getScalarResult()));
  7.             } catch (NoResultException $e) {
  8.                 $this->count 0;
  9.             }
  10.         }
Paginator->count()
  1.         $paginator = new Paginator($event->target$fetchJoinCollection);
  2.         $paginator->setUseOutputWalkers($useOutputWalkers);
  3.         if (($count $event->target->getHint(self::HINT_COUNT)) !== false) {
  4.             $event->count = (int) $count;
  5.         } else {
  6.             $event->count count($paginator);
  7.         }
  8.         $event->items iterator_to_array($paginator);
  9.     }
  10.     public static function getSubscribedEvents(): array
  1.         $this->priority ??= $dispatcher->getListenerPriority($eventName$this->listener);
  2.         $e $this->stopwatch->start($this->name'event_listener');
  3.         try {
  4.             ($this->optimizedListener ?? $this->listener)($event$eventName$dispatcher);
  5.         } finally {
  6.             if ($e->isStarted()) {
  7.                 $e->stop();
  8.             }
  9.         }
  1.         foreach ($listeners as $listener) {
  2.             if ($stoppable && $event->isPropagationStopped()) {
  3.                 break;
  4.             }
  5.             $listener($event$eventName$this);
  6.         }
  7.     }
  8.     /**
  9.      * Sorts the internal list of listeners for the given event by priority.
  1.         } else {
  2.             $listeners $this->getListeners($eventName);
  3.         }
  4.         if ($listeners) {
  5.             $this->callListeners($listeners$eventName$event);
  6.         }
  7.         return $event;
  8.     }
  1.         try {
  2.             $this->beforeDispatch($eventName$event);
  3.             try {
  4.                 $e $this->stopwatch->start($eventName'section');
  5.                 try {
  6.                     $this->dispatcher->dispatch($event$eventName);
  7.                 } finally {
  8.                     if ($e->isStarted()) {
  9.                         $e->stop();
  10.                     }
  11.                 }
  1.         $this->eventDispatcher->dispatch($beforeEvent'knp_pager.before');
  2.         // items
  3.         $itemsEvent = new Event\ItemsEvent($offset$limit);
  4.         $itemsEvent->options = &$options;
  5.         $itemsEvent->target = &$target;
  6.         $this->eventDispatcher->dispatch($itemsEvent'knp_pager.items');
  7.         if (!$itemsEvent->isPropagationStopped()) {
  8.             throw new \RuntimeException('One of listeners must count and slice given target');
  9.         }
  10.         if ($page ceil($itemsEvent->count $limit)) {
  11.             $pageOutOfRangeOption $options[PaginatorInterface::PAGE_OUT_OF_RANGE] ?? $this->defaultOptions[PaginatorInterface::PAGE_OUT_OF_RANGE];
  1.     }
  2.     public function paginate(mixed $targetint $page 1, ?int $limit null, array $options = []): \Knp\Component\Pager\Pagination\PaginationInterface
  3.     {
  4.         if (isset($this->lazyObjectState)) {
  5.             return ($this->lazyObjectState->realInstance ??= ($this->lazyObjectState->initializer)())->paginate(...\func_get_args());
  6.         }
  7.         return throw new \BadMethodCallException('Cannot forward abstract method "Knp\Component\Pager\PaginatorInterface::paginate()".');
  8.     }
  9. }
PaginatorProxy9cc2a8f->paginate() in src/Controller/EventController.php (line 16974)
  1.                   $dql "SELECT j FROM App\Entity\Event j where j.status = 'publish' and j.address like  '%" $location "%' ORDER by j.id DESC";
  2.               } else {
  3.                   $dql "SELECT j FROM App\Entity\Event j where j.status = 'publish'  ORDER by j.id DESC";
  4.               }
  5.               $query $this->entityManager->createQuery($dql);
  6.               $pagination $this->paginator->paginate(
  7.                         $query$request->query->getInt('page'1), /*page number*/
  8.                                                 10 /*limit per page*/
  9.                 );
  10.                 if(!empty($pagination)){
  11.               foreach ($pagination as $k => $v) {
in vendor/symfony/http-kernel/HttpKernel.php -> eventsbylocationAction (line 181)
  1.         $this->dispatcher->dispatch($eventKernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller $event->getController();
  3.         $arguments $event->getArguments();
  4.         // call controller
  5.         $response $controller(...$arguments);
  6.         // view
  7.         if (!$response instanceof Response) {
  8.             $event = new ViewEvent($this$request$type$response$event);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  2.         $this->requestStack->push($request);
  3.         $response null;
  4.         try {
  5.             return $response $this->handleRaw($request$type);
  6.         } catch (\Throwable $e) {
  7.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  8.                 throw $e;
  9.             }
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices true;
  4.         try {
  5.             return $this->getHttpKernel()->handle($request$type$catch);
  6.         } finally {
  7.             --$this->requestStackSize;
  8.         }
  9.     }
  1.     ) {
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         if (Kernel::VERSION_ID >= 60400) {
  7.             $response->send(false);
  8.             if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 29)
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/usr/www/users/smartm/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  2. umask(0000);
  3. use App\Kernel;
  4. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  5. return function (array $context) {
  6.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  7. };

Stack Trace

InvalidValueException
Knp\Component\Pager\Exception\InvalidValueException:
There is no component aliased by [e] in the given Query

  at vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Sortable/Doctrine/ORM/Query/OrderByWalker.php:52
  at Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM\Query\OrderByWalker->walkSelectStatement()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/TreeWalkerChain.php:97)
  at Doctrine\ORM\Query\TreeWalkerChain->walkSelectStatement()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:388)
  at Doctrine\ORM\Query\Parser->parse()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:258)
  at Doctrine\ORM\Tools\Pagination\Paginator->unbindUnusedQueryParams()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:247)
  at Doctrine\ORM\Tools\Pagination\Paginator->getCountQuery()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:120)
  at Doctrine\ORM\Tools\Pagination\Paginator->count()
  at count()
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber.php:43)
  at Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items()
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:116)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:220)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:56)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:139)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php:92)
  at Knp\Component\Pager\Paginator->paginate()
     (var/cache/dev/Container0ZmLCMd/PaginatorProxy9cc2a8f.php:25)
  at Container0ZmLCMd\PaginatorProxy9cc2a8f->paginate()
     (src/Controller/EventController.php:16974)
  at App\Controller\EventController->eventsbylocationAction()
     (vendor/symfony/http-kernel/HttpKernel.php:181)
  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:197)
  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:29)
  at require_once('/usr/www/users/smartm/vendor/autoload_runtime.php')
     (public/index.php:5)