Error 500 Internal Server Error

GET https://www.test.fluxxo.fr/client/import/lieu

Browse referrer URL
IP
2.13.146.10
Profiled on
Token
f7cab2

Exceptions

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

in vendor/doctrine/orm/src/AbstractQuery.php (line 752)
  1. if (! is_array($result)) {
  2. return $result;
  3. }
  5. if (count($result) > 1) {
  6. throw new NonUniqueResultException();
  7. }
  9. return array_shift($result);
  10. }
AbstractQuery->getOneOrNullResult() in src/Service/ImportLieuService.php (line 200)
  1. $lieu = $lieuQuery
  2. ->setParameter('reference', $datas['Reference'])
  3. ->setParameter('interventionSite', $interventionSite)
  4. ->setParameter('etage', $etage)
  5. ->setParameter('numero', $datas['Numero'])
  6. ->getOneOrNullResult();
  8. if ($lieu === null) {
  9. $lieu = new Lieu();
  10. $lieu->setReference($datas['Reference']);
  11. $lieu->setType(LieuType::LOGEMENT);
ImportLieuService->import() in src/Controller/Client/ImportController.php (line 57)
  1. {
  2. $form = $this->createForm($formType);
  3. $form->handleRequest($request);
  5. if ($form->isSubmitted() && $form->isValid()) {
  6. $importService->import($form->get('file')->getData());
  7. $request->setRequestFormat(TurboBundle::STREAM_FORMAT);
  8. $response = $this->renderBlock(
  9. 'client/import/_import.stream.html.twig',
  10. 'rapport',
  11. [
ImportController->manageForm() in src/Controller/Client/ImportController.php (line 42)
  1. }
  3. #[Route('lieu', name: 'lieu')]
  4. public function lieu(Request $request, ImportLieuService $importLieuService): Response
  5. {
  6. return $this->manageForm(ImportSiteType::class, 'client/import/lieu.html.twig', $request, $importLieuService);
  7. }
  9. #[Route('referent', name: 'referent')]
  10. public function referent(Request $request, ImportReferentService $importReferentService): Response
  11. {
in vendor/symfony/http-kernel/HttpKernel.php -> lieu (line 183)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  5. // call controller
  6. $response = $controller(...$arguments);
  8. // view
  9. if (!$response instanceof Response) {
  10. $event = new ViewEvent($this, $request, $type, $response, $event);
  11. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $this->handleRaw($request, $type);
  7. } catch (\Throwable $e) {
  8. if ($e instanceof \Error && !$this->handleAllThrowables) {
  9. throw $e;
  10. }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 182)
  1. $this->boot();
  2. ++$this->requestStackSize;
  3. $this->resetServices = true;
  5. try {
  6. return $this->getHttpKernel()->handle($request, $type, $catch);
  7. } finally {
  8. --$this->requestStackSize;
  9. }
  10. }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. if (Kernel::VERSION_ID >= 60400) {
  9. $response->send(false);
  11. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/var/www/fluxxo.fr/fluxxo/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

Logs

Level Channel Message
INFO 14:44:08 deprecation User Deprecated: Since symfony/ux-toggle-password 2.29.0: The package is deprecated and will be removed in 3.0. Follow the migration steps in https://github.com/symfony/ux/tree/2.x/src/TogglePassword to keep using TogglePassword in your Symfony application. 
{
    "exception": {}
}
INFO 14:44:08 deprecation User Deprecated: The Liip\ImagineBundle\Templating\FilterTrait trait is deprecated since version 2.7 and will be removed in 3.0; use Twig instead. 
{
    "exception": {}
}
INFO 14:44:08 deprecation User Deprecated: The Liip\ImagineBundle\Templating\FilterExtension class is deprecated since version 2.7 and will be removed in 3.0; configure "liip_imagine.twig.mode" to "lazy" instead. 
{
    "exception": {}
}
INFO 14:44:08 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "f7cab2"
    },
    "request_uri": "https://www.test.fluxxo.fr/_profiler/f7cab2",
    "method": "GET"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "Symfony\UX\Turbo\Request\RequestListener::__invoke". 
{
    "event": "kernel.request",
    "listener": "Symfony\\UX\\Turbo\\Request\\RequestListener::__invoke"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Nelmio\\CorsBundle\\EventListener\\CorsListener::onKernelRequest"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\AssetMapper\\AssetMapperDevServerSubscriber::onKernelRequest"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "ApiPlatform\Symfony\EventListener\AddFormatListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "ApiPlatform\\Symfony\\EventListener\\AddFormatListener::onKernelRequest"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "ApiPlatform\Symfony\EventListener\ReadListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "ApiPlatform\\Symfony\\EventListener\\ReadListener::onKernelRequest"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "ApiPlatform\Symfony\EventListener\DeserializeListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "ApiPlatform\\Symfony\\EventListener\\DeserializeListener::onKernelRequest"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Knp\\Bundle\\PaginatorBundle\\Subscriber\\SlidingPaginationSubscriber::onKernelRequest"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "App\ApiResource\Listener\CorsPreflightRequestSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "App\\ApiResource\\Listener\\CorsPreflightRequestSubscriber::onKernelRequest"
}
DEBUG 14:44:08 event Notified event "kernel.request" to listener "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\UX\\LiveComponent\\EventListener\\LiveComponentSubscriber::onKernelRequest"
}
DEBUG 14:44:08 event Notified event "kernel.controller" to listener "Symfony\UX\LiveComponent\EventListener\LiveComponentSubscriber::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\UX\\LiveComponent\\EventListener\\LiveComponentSubscriber::onKernelController"
}
DEBUG 14:44:08 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 14:44:08 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 14:44:08 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
}
DEBUG 14:44:08 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
DEBUG 14:44:08 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
DEBUG 14:44:08 event Notified event "kernel.controller_arguments" to listener "ContainerQRuow7R\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "ContainerQRuow7R\\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
}
DEBUG 14:44:08 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}

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/src/AbstractQuery.php:752
  at Doctrine\ORM\AbstractQuery->getOneOrNullResult()
     (src/Service/ImportLieuService.php:200)
  at App\Service\ImportLieuService->import()
     (src/Controller/Client/ImportController.php:57)
  at App\Controller\Client\ImportController->manageForm()
     (src/Controller/Client/ImportController.php:42)
  at App\Controller\Client\ImportController->lieu()
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  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:182)
  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('/var/www/fluxxo.fr/fluxxo/vendor/autoload_runtime.php')
     (public/index.php:5)