Symfony Exception

NoResultException

HTTP 500 Internal Server Error

No result was found for query although at least one row was expected.

Exception

Doctrine\ORM\ NoResultException

  1.     public function getSingleResult($hydrationMode null)
  2.     {
  3.         $result $this->execute(null$hydrationMode);
  4.         if ($this->_hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
  5.             throw new NoResultException;
  6.         }
  7.         if ( ! is_array($result)) {
  8.             return $result;
  9.         }
AbstractQuery->getSingleResult() in src/Repository/Common/PageRepository.php (line 59)
  1.             ->andWhere('trans.url = :url')
  2.             ->setParameter(':lang'$language)
  3.             ->setParameter(':url'$url)
  4.             ->setMaxResults(1)
  5.             ->getQuery()
  6.             ->getSingleResult()
  7.             ;
  8.     }
  9. }
PageRepository->showOneByUrl() in src/Controller/ZController.php (line 33)
  1.             $request->setLocale('en');
  2.             $url mb_substr($request->get('url'),3);
  3.             //dump($url);die();
  4.         }
  5.         $page $pageRepository->showOneByUrl($request->getLocale(),$url);
  6.         return $this->render('page/app/index.html.twig', [
  7.             'sliders' => $blockRepository->showAllSlider($request->getLocale(), $page),
  8.             'page' => $page
  9.         ]);
  10.     }
  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 $request$type HttpKernelInterface::MASTER_REQUEST$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() in public/index.php (line 24)
  1.     Request::setTrustedHosts([$trustedHosts]);
  2. }
  3. $kernel = new Kernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  4. $request Request::createFromGlobals();
  5. $response $kernel->handle($request);
  6. $response->send();
  7. $kernel->terminate($request$response);

Logs

No log messages

Stack Trace

NoResultException

Doctrine\ORM\NoResultException:
No result was found for query although at least one row was expected.

  at vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:837
  at Doctrine\ORM\AbstractQuery->getSingleResult()
     (src/Repository/Common/PageRepository.php:59)
  at App\Repository\Common\PageRepository->showOneByUrl()
     (src/Controller/ZController.php:33)
  at App\Controller\ZController->page()
     (vendor/symfony/http-kernel/HttpKernel.php:158)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:80)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:201)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:24)