Symfony Exception

UnexpectedValueException

HTTP 500 Internal Server Error

There is no component field [priced] in the given Query

Exception

UnexpectedValueException

  1.                 if (!$meta['metadata']->hasField($field)) {
  2.                     throw new \UnexpectedValueException("There is no such field [{$field}] in the given Query component, aliased by [$alias]");
  3.                 }
  4.             } else {
  5.                 if (!array_key_exists($field$components)) {
  6.                     throw new \UnexpectedValueException("There is no component field [{$field}] in the given Query");
  7.                 }
  8.             }
  9.             $direction $query->getHint(self::HINT_PAGINATOR_SORT_DIRECTION);
  10.             if ($alias !== false) {
  1.      * {@inheritdoc}
  2.      */
  3.     public function walkSelectStatement(AST\SelectStatement $AST)
  4.     {
  5.         foreach ($this->_walkers as $walker) {
  6.             $walker->walkSelectStatement($AST);
  7.             $this->_queryComponents $walker->getQueryComponents();
  8.         }
  9.     }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> walkSelectStatement (line 395)
  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 $parameters \Doctrine\Common\Collections\Collection|\Doctrine\ORM\Query\Parameter[] */
  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(null)->setMaxResults(null);
  8.         return $countQuery;
  1.      */
  2.     public function count()
  3.     {
  4.         if ($this->count === null) {
  5.             try {
  6.                 $this->count 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->called true;
  2.         $this->priority $dispatcher->getListenerPriority($eventName$this->listener);
  3.         $e $this->stopwatch->start($this->name'event_listener');
  4.         ($this->optimizedListener ?? $this->listener)($event$eventName$dispatcher);
  5.         if ($e->isStarted()) {
  6.             $e->stop();
  7.         }
  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.     protected function dispatch(string $eventNameEvent\Event $event): void
  2.     {
  3.         if (!\class_exists(LegacyEventDispatcherProxy::class)) {
  4.             $this->eventDispatcher->dispatch($eventName$event);
  5.         } else {
  6.             $this->eventDispatcher->dispatch($event$eventName);
  7.         }
  8.     }
  9. }
  1.         $this->dispatch('knp_pager.before'$beforeEvent);
  2.         // items
  3.         $itemsEvent = new Event\ItemsEvent($offset$limit);
  4.         $itemsEvent->options = &$options;
  5.         $itemsEvent->target = &$target;
  6.         $this->dispatch('knp_pager.items'$itemsEvent);
  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[self::PAGE_OUT_OF_RANGE] ?? $this->defaultOptions[self::PAGE_OUT_OF_RANGE];
Paginator->paginate(object(Query), 1, 30) in src/Service/Catalog.php (line 63)
  1.     public function run() {
  2.         $this->setFilter();
  3.         $this->setSort();
  4.         $q $this->query->orderBy('p.sort''ASC')->orderBy('p.id''DESC')->getQuery();
  5.         $this->products $this->paginator->paginate($q$this->request->query->getInt('page'1), $this->page_limit);
  6.         if(count($this->products) < 2) {
  7.             $this->sort null;
  8.         }
  9.     }
  1.             $category $categoryRepository->findOneBy(['url' => $url]);
  2.             if($category->getId() == 1) {
  3.                 return $this->redirectToRoute('catalog');
  4.             }
  5.         }
  6.         $catalog->setType('catalog'$category)->run();
  7.         $categories $categoryRepository->getAll();
  8.         return $this->render('catalog/index.html.twig', [
  9.             'products' => $catalog->getProducts(),
  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);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.     public function handle(Request $requestint $type HttpKernelInterface::MASTER_REQUESTbool $catch true)
  2.     {
  3.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         try {
  5.             return $this->handleRaw($request$type);
  6.         } catch (\Exception $e) {
  7.             if ($e instanceof RequestExceptionInterface) {
  8.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  9.             }
  10.             if (false === $catch) {
  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.     }
Kernel->handle(object(Request)) in public/index.php (line 22)
  1. if ($trustedHosts $_SERVER['TRUSTED_HOSTS'] ?? $_ENV['TRUSTED_HOSTS'] ?? false) {
  2.     Request::setTrustedHosts([$trustedHosts]);
  3. }
  4. $kernel = new Kernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  5. $request Request::createFromGlobals();
  6. $response $kernel->handle($request);
  7. $response->send();
  8. $kernel->terminate($request$response);

Logs

No log messages

Stack Trace

UnexpectedValueException

UnexpectedValueException:
There is no component field [priced] in the given Query

  at vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Sortable/Doctrine/ORM/Query/OrderByWalker.php:62
  at Knp\Component\Pager\Event\Subscriber\Sortable\Doctrine\ORM\Query\OrderByWalker->walkSelectStatement(object(SelectStatement))
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/TreeWalkerChain.php:113)
  at Doctrine\ORM\Query\TreeWalkerChain->walkSelectStatement(object(SelectStatement))
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:395)
  at Doctrine\ORM\Query\Parser->parse()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:275)
  at Doctrine\ORM\Tools\Pagination\Paginator->unbindUnusedQueryParams(object(Query))
     (vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:264)
  at Doctrine\ORM\Tools\Pagination\Paginator->getCountQuery()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:125)
  at Doctrine\ORM\Tools\Pagination\Paginator->count()
  at count(object(Paginator))
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber.php:46)
  at Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items(object(ItemsEvent), 'knp_pager.items', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:117)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object(ItemsEvent), 'knp_pager.items', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:230)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'knp_pager.items', object(ItemsEvent))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:59)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object(ItemsEvent), 'knp_pager.items')
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:151)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object(ItemsEvent), 'knp_pager.items')
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php:204)
  at Knp\Component\Pager\Paginator->dispatch('knp_pager.items', object(ItemsEvent))
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php:133)
  at Knp\Component\Pager\Paginator->paginate(object(Query), 1, 30)
     (src/Service/Catalog.php:63)
  at App\Service\Catalog->run()
     (src/Application/Controller/CatalogController.php:63)
  at Application\Controller\CatalogController->index(object(Catalog), null)
     (vendor/symfony/http-kernel/HttpKernel.php:157)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:79)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:196)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (public/index.php:22)