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/PageBundle/Controller/DefaultController.php (line 25)
  1.     {
  2.         $em $this->getDoctrine()->getManager();
  3.         $dql "SELECT p FROM PageBundle:Page p LEFT JOIN p.translations pt WHERE pt.locale = '" $request->getLocale() . "' AND pt.slug LIKE '" $slug "' AND p.deletedAt IS NULL ORDER BY p.sort";
  4.         $query $em->createQuery($dql);
  5.         /** @var Page $page */
  6.         $page $query->getSingleResult();
  7.         return $this->render('app/pages/page.html.twig', [
  8.             'page' => $page
  9.         ]);
  10.     }
DefaultController->indexAction(object(Request), 'les-applications') in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 151)
  1.         $this->dispatcher->dispatch(KernelEvents::CONTROLLER_ARGUMENTS$event);
  2.         $controller $event->getController();
  3.         $arguments $event->getArguments();
  4.         // call controller
  5.         $response = \call_user_func_array($controller$arguments);
  6.         // view
  7.         if (!$response instanceof Response) {
  8.             $event = new GetResponseForControllerResultEvent($this$request$type$response);
  9.             $this->dispatcher->dispatch(KernelEvents::VIEW$event);
HttpKernel->handleRaw(object(Request), 1) in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 68)
  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) {
HttpKernel->handle(object(Request), 1, true) in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php (line 200)
  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 web/app.php (line 22)
  1. $request Request::createFromGlobals();
  2. Request::setTrustedProxies(
  3.     ['192.0.0.1''10.0.0.0/8'],
  4.     Request::HEADER_X_FORWARDED_ALL
  5. );
  6. $response $kernel->handle($request);
  7. $response->send();
  8. $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:800
  at Doctrine\ORM\AbstractQuery->getSingleResult()
     (src/PageBundle/Controller/DefaultController.php:25)
  at PageBundle\Controller\DefaultController->indexAction(object(Request), 'les-applications')
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/app.php:22)