Symfony Exception

NonUniqueResultException

HTTP 500 Internal Server Error

More than one result was found for query although one row or none was expected.

Exception

Doctrine\ORM\ NonUniqueResultException

  1.         if ( ! is_array($result)) {
  2.             return $result;
  3.         }
  4.         if (count($result) > 1) {
  5.             throw new NonUniqueResultException;
  6.         }
  7.         return array_shift($result);
  8.     }
AbstractQuery->getOneOrNullResult() in src/Controller/Front/ActionCollectiveArticleController.php (line 167)
  1.             if(preg_match('/\-([0-9]+)$/'$acSlug$matches)) {
  2.                 $mappingAc $em
  3.                     ->createQueryBuilder()->select('o')
  4.                     ->from(MappingAc::class, 'o')
  5.                     ->where('o.originalUrl LIKE :idarticle')
  6.                     ->setParameter('idarticle''%'.$matches[1])->getQuery()->getOneOrNullResult();
  7.             }
  8.         }
  9.         if($mappingAc) {
  10.             $nodeTransalation $mappingAc->getNode()->getNodeTranslation('fr');
in vendor/symfony/http-kernel/HttpKernel.php -> redirectSubAc (line 158)
  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 25)
  1.     Request::setTrustedHosts([$trustedHosts]);
  2. }
  3. $kernel = new Kernel($_SERVER['APP_ENV'], (bool) $_SERVER['REMOTE_ADDR'] == '82.65.193.90');
  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

NonUniqueResultException

Doctrine\ORM\NonUniqueResultException:
More than one result was found for query although one row or none was expected.

  at vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:811
  at Doctrine\ORM\AbstractQuery->getOneOrNullResult()
     (src/Controller/Front/ActionCollectiveArticleController.php:167)
  at App\Controller\Front\ActionCollectiveArticleController->redirectSubAc()
     (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:25)