Error 500 Internal Server Error

GET https://mercure-qualite-web-test.autobilan-systems.com/admin/planification-audits

Browse referrer URL
IP
86.228.222.67
Profiled on
Token
b92c59

Exceptions

PDOException Exception InvalidFieldNameException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.date_affectation_auditeur' in 'field list'

Exceptions 3

Doctrine\DBAL\Exception\ InvalidFieldNameException

Show exception properties 
Doctrine\DBAL\Exception\InvalidFieldNameException {#1514
  -query: Doctrine\DBAL\Query {#1511
    -sql: "SELECT t0.IDCentre AS IDCentre_1, t0.NumeroAgrementCentre AS NumeroAgrementCentre_2, t0.LoginCentre AS LoginCentre_3, t0.MotDePasseCrypte AS MotDePasseCrypte_4, t0.estVL AS estVL_5, t0.LogoCentre AS LogoCentre_6, t0.DateCreationInstallation AS DateCreationInstallation_7, t0.EnseigneCommerciale AS EnseigneCommerciale_8, t0.DateAgrementCentre AS DateAgrementCentre_9, t0.SurfaceTerrain AS SurfaceTerrain_10, t0.SurfaceZonesCouvertes AS SurfaceZonesCouvertes_11, t0.SurfaceZoneControle AS SurfaceZoneControle_12, t0.SurfaceBureaux AS SurfaceBureaux_13, t0.SurfaceSalleAttente AS SurfaceSalleAttente_14, t0.SurfaceParking AS SurfaceParking_15, t0.NombrePlacesParking AS NombrePlacesParking_16, t0.HauteurPorte AS HauteurPorte_17, t0.NombreLignesDeControle AS NombreLignesDeControle_18, t0.FKAdresseCNPA AS FKAdresseCNPA_19, t0.AdresseFacturationEstAdresseCentre AS AdresseFacturationEstAdresseCentre_20, t0.PL_NumeroAccreditationCentre AS PL_NumeroAccreditationCentre_21, t0.PL_DateAccreditationCentre AS PL_DateAccreditationCentre_22, t0.PL_SurfaceLocalArchives AS PL_SurfaceLocalArchives_23, t0.PL_NombrePlacesParkingEntree AS PL_NombrePlacesParkingEntree_24, t0.PL_NombrePlacesParkingSortie AS PL_NombrePlacesParkingSortie_25, t0.PL_ZoneDeControleLongueur AS PL_ZoneDeControleLongueur_26, t0.PL_ZoneDeControleLargeur AS PL_ZoneDeControleLargeur_27, t0.VL_HauteurPontEtOuFosse AS VL_HauteurPontEtOuFosse_28, t0.FK_VL_AdresseChauffage AS FK_VL_AdresseChauffage_29, t0.FKConciliateur AS FKConciliateur_30, t0.FKSociete AS FKSociete_31, t0.estActif AS estActif_32, t0.CommandeAutorisee AS CommandeAutorisee_33, t0.ID_CentreGroupe AS ID_CentreGroupe_34, t0.DateMiseEnServiceESIControl AS DateMiseEnServiceESIControl_35, t0.DateHeureMajMYSQL AS DateHeureMajMYSQL_36, t0.date_affectation_auditeur AS date_affectation_auditeur_37, t0.FKAdresseCentre AS FKAdresseCentre_38, t39.id AS id_40, t39.numero_compte_comptable AS numero_compte_comptable_41, t39.tarif_pv_reg AS tarif_pv_reg_42, t39.tarif_pv_vol AS tarif_pv_vol_43, t39.remise_expedition_paragon AS remise_expedition_paragon_44, t39.remise_produit AS remise_produit_45, t39.nom_facturation AS nom_facturation_46, t39.logo AS logo_47, t39.mercure_access AS mercure_access_48, t39.contrat AS contrat_49, t39.id_doc_contrant AS id_doc_contrant_50, t39.fichier_contrat AS fichier_contrat_51, t39.duree_contrat AS duree_contrat_52, t39.date_contrat AS date_contrat_53, t39.date_fin_contrat AS date_fin_contrat_54, t39.avenant AS avenant_55, t39.id_doc_avenant AS id_doc_avenant_56, t39.fichier_avenant AS fichier_avenant_57, t39.forfait_avenant AS forfait_avenant_58, t39.date_avenant AS date_avenant_59, t39.date_fin_avenant AS date_fin_avenant_60, t39.maintenance AS maintenance_61, t39.id_doc_maintenance AS id_doc_maintenance_62, t39.fichier_maintenance AS fichier_maintenance_63, t39.duree_maintenance AS duree_maintenance_64, t39.date_maintenance AS date_maintenance_65, t39.date_fin_maintenance AS date_fin_maintenance_66, t39.fichier_annexe AS fichier_annexe_67, t39.date_annexe AS date_annexe_68, t39.date_fin_annexe AS date_fin_annexe_69, t39.tarif_rel2ans_auto AS tarif_rel2ans_auto_70, t39.tarif_rel4ans AS tarif_rel4ans_71, t39.numero_compte_comptable_rel AS numero_compte_comptable_rel_72, t39.mode_reglement_compta AS mode_reglement_compta_73, t39.tarif_rel2ans_cent AS tarif_rel2ans_cent_74, t39.tarif_sms AS tarif_sms_75, t39.tarif_pay_ligne AS tarif_pay_ligne_76, t39.audit_compris AS audit_compris_77, t39.contrat_signe AS contrat_signe_78, t39.duree_contrat_signe AS duree_contrat_signe_79, t39.date_debut_contrat_signe AS date_debut_contrat_signe_80, t39.tvacentre AS tvacentre_81, t39.abs_group AS abs_group_82, t39.Centre AS Centre_83, t39.commercial_contrat_id AS commercial_contrat_id_84, t0.personnel_id AS personnel_id_85 FROM t_centre t0 LEFT JOIN bo_parametre_centre t39 ON t39.Centre = t0.IDCentre WHERE t0.personnel_id = ?"
    -params: array:1 [
      0 => 16
    ]
    -types: array:1 [
      0 => "integer"
    ]
  }
}
in vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php (line 63)
  1.             1557,
  2.             1569,
  3.             1586 => new UniqueConstraintViolationException($exception, $query),
  4.             1054,
  5.             1166,
  6.             1611 => new InvalidFieldNameException($exception, $query),
  7.             1052,
  8.             1060,
  9.             1110 => new NonUniqueFieldNameException($exception, $query),
  10.             1064,
  11.             1149,
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1456)
  1.     private function handleDriverException(
  2.         Driver\Exception $driverException,
  3.         ?Query $query,
  4.     ): DriverException {
  5.         $this->exceptionConverter ??= $this->driver->getExceptionConverter();
  6.         $exception                  = $this->exceptionConverter->convert($driverException, $query);
  8.         if ($exception instanceof ConnectionLost) {
  9.             $this->close();
  10.         }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1392)
  1.         Driver\Exception $e,
  2.         string $sql,
  3.         array $params = [],
  4.         array $types = [],
  5.     ): DriverException {
  6.         return $this->handleDriverException($e, new Query($sql, $params, $types));
  7.     }
  9.     /** @internal */
  10.     final public function convertException(Driver\Exception $e): DriverException
  11.     {
in vendor/doctrine/dbal/src/Connection.php -> convertExceptionDuringQuery (line 809)
  1.                 $result = $connection->query($sql);
  2.             }
  4.             return new Result($result, $this);
  5.         } catch (Driver\Exception $e) {
  6.             throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
  7.         }
  8.     }
  10.     /**
  11.      * Executes a caching query.
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> executeQuery (line 1848)
  1.         }
  3.         $sql              = $this->getSelectSQL($criteria, $assoc, null, $limit, $offset);
  4.         [$params, $types] = $this->expandToManyParameters($parameters);
  6.         return $this->conn->executeQuery($sql, $params, $types);
  7.     }
  9.     /**
  10.      * {@inheritDoc}
  11.      */
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> getOneToManyStatement (line 1793)
  1.         AssociationMapping $assoc,
  2.         object $sourceEntity,
  3.         PersistentCollection $collection,
  4.     ): mixed {
  5.         assert($assoc instanceof OneToManyAssociationMapping);
  6.         $stmt = $this->getOneToManyStatement($assoc, $sourceEntity);
  8.         return $this->loadCollectionFromStatement($assoc, $stmt, $collection);
  9.     }
  11.     /** Builds criteria and execute SQL statement to fetch the one to many entities from. */
in vendor/doctrine/orm/src/UnitOfWork.php -> loadOneToManyCollection (line 2709)
  1.         $assoc     = $collection->getMapping();
  2.         $persister = $this->getEntityPersister($assoc->targetEntity);
  4.         switch ($assoc->type()) {
  5.             case ClassMetadata::ONE_TO_MANY:
  6.                 $persister->loadOneToManyCollection($assoc, $collection->getOwner(), $collection);
  7.                 break;
  9.             case ClassMetadata::MANY_TO_MANY:
  10.                 $persister->loadManyToManyCollection($assoc, $collection->getOwner(), $collection);
  11.                 break;
in vendor/doctrine/orm/src/PersistentCollection.php -> loadCollection (line 636)
  1.         if ($this->isDirty) {
  2.             $newlyAddedDirtyObjects = $this->unwrap()->toArray();
  3.         }
  5.         $this->unwrap()->clear();
  6.         $this->getUnitOfWork()->loadCollection($this);
  7.         $this->takeSnapshot();
  9.         if ($newlyAddedDirtyObjects) {
  10.             $this->restoreNewObjectsInDirtyCollection($newlyAddedDirtyObjects);
  11.         }
in vendor/doctrine/orm/src/PersistentCollection.php -> doInitialize (line 186)
  1.     {
  2.         if ($this->initialized || ! $this->association) {
  3.             return;
  4.         }
  6.         $this->doInitialize();
  8.         $this->initialized = true;
  9.     }
  11.     /**
in vendor/doctrine/collections/src/AbstractLazyCollection.php -> initialize (line 313)
  1.      * @phpstan-return Traversable<TKey,T>
  2.      */
  3.     #[ReturnTypeWillChange]
  4.     public function getIterator()
  5.     {
  6.         $this->initialize();
  8.         return $this->collection->getIterator();
  9.     }
  11.     /**
AbstractLazyCollection->getIterator() in src/Controller/AuditAgendaController.php (line 328)
  1.         // --- 3. Analyse des centres ---
  2.         $typesAutorises = [5, 6, 7, 8, 9];
  3.         $centres = $auditeur->getCentres();
  4.         $planningPropose = [];
  6.         foreach ($centres as $centre) {
  7.             if (!$centre->getEstactif()) continue;
  9.             $centreId = $centre->getIdcentre();
  10.             $statutGlobalCentre = 'success';
AuditAgendaController->calculerPlanningPourAuditeur() in src/Controller/AuditAgendaController.php (line 229)
  1. //        $user = $personnelAbsRepo->find(29);
  2.         $user = $this->getUser();
  3.         if (!$user) throw $this->createAccessDeniedException('Vous devez Ãªtre connecté.');
  5.         // On appelle notre moteur de calcul magique
  6.         $data = $this->calculerPlanningPourAuditeur(
  7.             $user, $tacheRepo, $auditRepo, $auditTypeRepo, $userRepo, $planifSuperviseurRepo,$habilitationRepository
  8.         );
  10.         return $this->render('interne/planification.html.twig', $data);
  11.     }
in vendor/symfony/http-kernel/HttpKernel.php -> planifAudit (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('/home/ks185124202150/public_html/mercurequaliteweb_test/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. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.date_affectation_auditeur' in 'field list'

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 24)
  1.         } else {
  2.             $code     = $exception->getCode();
  3.             $sqlState = null;
  4.         }
  6.         return new self($exception->getMessage(), $sqlState, $code, $exception);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 57)
  1.     public function execute(): Result
  2.     {
  3.         try {
  4.             $this->stmt->execute();
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  9.         return new Result($this->stmt);
  10.     }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 24)
  1.         $this->wrappedStatement->bindValue($param, $value, $type);
  2.     }
  4.     public function execute(): Result
  5.     {
  6.         return $this->wrappedStatement->execute();
  7.     }
  8. }
in vendor/doctrine/dbal/src/Logging/Statement.php -> execute (line 46)
  1.             'sql'    => $this->sql,
  2.             'params' => $this->params,
  3.             'types'  => $this->types,
  4.         ]);
  6.         return parent::execute();
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 24)
  1.         $this->wrappedStatement->bindValue($param, $value, $type);
  2.     }
  4.     public function execute(): Result
  5.     {
  6.         return $this->wrappedStatement->execute();
  7.     }
  8. }
in vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php -> execute (line 58)
  2.         $this->stopwatch?->start('doctrine', 'doctrine');
  3.         $query->start();
  5.         try {
  6.             return parent::execute();
  7.         } finally {
  8.             $query->stop();
  9.             $this->stopwatch?->stop('doctrine');
  10.         }
  11.     }
in vendor/doctrine/dbal/src/Connection.php -> execute (line 802)
  2.                 $stmt = $connection->prepare($sql);
  4.                 $this->bindParameters($stmt, $params, $types);
  6.                 $result = $stmt->execute();
  7.             } else {
  8.                 $result = $connection->query($sql);
  9.             }
  11.             return new Result($result, $this);
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> executeQuery (line 1848)
  1.         }
  3.         $sql              = $this->getSelectSQL($criteria, $assoc, null, $limit, $offset);
  4.         [$params, $types] = $this->expandToManyParameters($parameters);
  6.         return $this->conn->executeQuery($sql, $params, $types);
  7.     }
  9.     /**
  10.      * {@inheritDoc}
  11.      */
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> getOneToManyStatement (line 1793)
  1.         AssociationMapping $assoc,
  2.         object $sourceEntity,
  3.         PersistentCollection $collection,
  4.     ): mixed {
  5.         assert($assoc instanceof OneToManyAssociationMapping);
  6.         $stmt = $this->getOneToManyStatement($assoc, $sourceEntity);
  8.         return $this->loadCollectionFromStatement($assoc, $stmt, $collection);
  9.     }
  11.     /** Builds criteria and execute SQL statement to fetch the one to many entities from. */
in vendor/doctrine/orm/src/UnitOfWork.php -> loadOneToManyCollection (line 2709)
  1.         $assoc     = $collection->getMapping();
  2.         $persister = $this->getEntityPersister($assoc->targetEntity);
  4.         switch ($assoc->type()) {
  5.             case ClassMetadata::ONE_TO_MANY:
  6.                 $persister->loadOneToManyCollection($assoc, $collection->getOwner(), $collection);
  7.                 break;
  9.             case ClassMetadata::MANY_TO_MANY:
  10.                 $persister->loadManyToManyCollection($assoc, $collection->getOwner(), $collection);
  11.                 break;
in vendor/doctrine/orm/src/PersistentCollection.php -> loadCollection (line 636)
  1.         if ($this->isDirty) {
  2.             $newlyAddedDirtyObjects = $this->unwrap()->toArray();
  3.         }
  5.         $this->unwrap()->clear();
  6.         $this->getUnitOfWork()->loadCollection($this);
  7.         $this->takeSnapshot();
  9.         if ($newlyAddedDirtyObjects) {
  10.             $this->restoreNewObjectsInDirtyCollection($newlyAddedDirtyObjects);
  11.         }
in vendor/doctrine/orm/src/PersistentCollection.php -> doInitialize (line 186)
  1.     {
  2.         if ($this->initialized || ! $this->association) {
  3.             return;
  4.         }
  6.         $this->doInitialize();
  8.         $this->initialized = true;
  9.     }
  11.     /**
in vendor/doctrine/collections/src/AbstractLazyCollection.php -> initialize (line 313)
  1.      * @phpstan-return Traversable<TKey,T>
  2.      */
  3.     #[ReturnTypeWillChange]
  4.     public function getIterator()
  5.     {
  6.         $this->initialize();
  8.         return $this->collection->getIterator();
  9.     }
  11.     /**
AbstractLazyCollection->getIterator() in src/Controller/AuditAgendaController.php (line 328)
  1.         // --- 3. Analyse des centres ---
  2.         $typesAutorises = [5, 6, 7, 8, 9];
  3.         $centres = $auditeur->getCentres();
  4.         $planningPropose = [];
  6.         foreach ($centres as $centre) {
  7.             if (!$centre->getEstactif()) continue;
  9.             $centreId = $centre->getIdcentre();
  10.             $statutGlobalCentre = 'success';
AuditAgendaController->calculerPlanningPourAuditeur() in src/Controller/AuditAgendaController.php (line 229)
  1. //        $user = $personnelAbsRepo->find(29);
  2.         $user = $this->getUser();
  3.         if (!$user) throw $this->createAccessDeniedException('Vous devez Ãªtre connecté.');
  5.         // On appelle notre moteur de calcul magique
  6.         $data = $this->calculerPlanningPourAuditeur(
  7.             $user, $tacheRepo, $auditRepo, $auditTypeRepo, $userRepo, $planifSuperviseurRepo,$habilitationRepository
  8.         );
  10.         return $this->render('interne/planification.html.twig', $data);
  11.     }
in vendor/symfony/http-kernel/HttpKernel.php -> planifAudit (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('/home/ks185124202150/public_html/mercurequaliteweb_test/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. };

PDOException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.date_affectation_auditeur' in 'field list'

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 55)
  1.     }
  3.     public function execute(): Result
  4.     {
  5.         try {
  6.             $this->stmt->execute();
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 55)
  1.     }
  3.     public function execute(): Result
  4.     {
  5.         try {
  6.             $this->stmt->execute();
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 24)
  1.         $this->wrappedStatement->bindValue($param, $value, $type);
  2.     }
  4.     public function execute(): Result
  5.     {
  6.         return $this->wrappedStatement->execute();
  7.     }
  8. }
in vendor/doctrine/dbal/src/Logging/Statement.php -> execute (line 46)
  1.             'sql'    => $this->sql,
  2.             'params' => $this->params,
  3.             'types'  => $this->types,
  4.         ]);
  6.         return parent::execute();
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 24)
  1.         $this->wrappedStatement->bindValue($param, $value, $type);
  2.     }
  4.     public function execute(): Result
  5.     {
  6.         return $this->wrappedStatement->execute();
  7.     }
  8. }
in vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php -> execute (line 58)
  2.         $this->stopwatch?->start('doctrine', 'doctrine');
  3.         $query->start();
  5.         try {
  6.             return parent::execute();
  7.         } finally {
  8.             $query->stop();
  9.             $this->stopwatch?->stop('doctrine');
  10.         }
  11.     }
in vendor/doctrine/dbal/src/Connection.php -> execute (line 802)
  2.                 $stmt = $connection->prepare($sql);
  4.                 $this->bindParameters($stmt, $params, $types);
  6.                 $result = $stmt->execute();
  7.             } else {
  8.                 $result = $connection->query($sql);
  9.             }
  11.             return new Result($result, $this);
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> executeQuery (line 1848)
  1.         }
  3.         $sql              = $this->getSelectSQL($criteria, $assoc, null, $limit, $offset);
  4.         [$params, $types] = $this->expandToManyParameters($parameters);
  6.         return $this->conn->executeQuery($sql, $params, $types);
  7.     }
  9.     /**
  10.      * {@inheritDoc}
  11.      */
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> getOneToManyStatement (line 1793)
  1.         AssociationMapping $assoc,
  2.         object $sourceEntity,
  3.         PersistentCollection $collection,
  4.     ): mixed {
  5.         assert($assoc instanceof OneToManyAssociationMapping);
  6.         $stmt = $this->getOneToManyStatement($assoc, $sourceEntity);
  8.         return $this->loadCollectionFromStatement($assoc, $stmt, $collection);
  9.     }
  11.     /** Builds criteria and execute SQL statement to fetch the one to many entities from. */
in vendor/doctrine/orm/src/UnitOfWork.php -> loadOneToManyCollection (line 2709)
  1.         $assoc     = $collection->getMapping();
  2.         $persister = $this->getEntityPersister($assoc->targetEntity);
  4.         switch ($assoc->type()) {
  5.             case ClassMetadata::ONE_TO_MANY:
  6.                 $persister->loadOneToManyCollection($assoc, $collection->getOwner(), $collection);
  7.                 break;
  9.             case ClassMetadata::MANY_TO_MANY:
  10.                 $persister->loadManyToManyCollection($assoc, $collection->getOwner(), $collection);
  11.                 break;
in vendor/doctrine/orm/src/PersistentCollection.php -> loadCollection (line 636)
  1.         if ($this->isDirty) {
  2.             $newlyAddedDirtyObjects = $this->unwrap()->toArray();
  3.         }
  5.         $this->unwrap()->clear();
  6.         $this->getUnitOfWork()->loadCollection($this);
  7.         $this->takeSnapshot();
  9.         if ($newlyAddedDirtyObjects) {
  10.             $this->restoreNewObjectsInDirtyCollection($newlyAddedDirtyObjects);
  11.         }
in vendor/doctrine/orm/src/PersistentCollection.php -> doInitialize (line 186)
  1.     {
  2.         if ($this->initialized || ! $this->association) {
  3.             return;
  4.         }
  6.         $this->doInitialize();
  8.         $this->initialized = true;
  9.     }
  11.     /**
in vendor/doctrine/collections/src/AbstractLazyCollection.php -> initialize (line 313)
  1.      * @phpstan-return Traversable<TKey,T>
  2.      */
  3.     #[ReturnTypeWillChange]
  4.     public function getIterator()
  5.     {
  6.         $this->initialize();
  8.         return $this->collection->getIterator();
  9.     }
  11.     /**
AbstractLazyCollection->getIterator() in src/Controller/AuditAgendaController.php (line 328)
  1.         // --- 3. Analyse des centres ---
  2.         $typesAutorises = [5, 6, 7, 8, 9];
  3.         $centres = $auditeur->getCentres();
  4.         $planningPropose = [];
  6.         foreach ($centres as $centre) {
  7.             if (!$centre->getEstactif()) continue;
  9.             $centreId = $centre->getIdcentre();
  10.             $statutGlobalCentre = 'success';
AuditAgendaController->calculerPlanningPourAuditeur() in src/Controller/AuditAgendaController.php (line 229)
  1. //        $user = $personnelAbsRepo->find(29);
  2.         $user = $this->getUser();
  3.         if (!$user) throw $this->createAccessDeniedException('Vous devez Ãªtre connecté.');
  5.         // On appelle notre moteur de calcul magique
  6.         $data = $this->calculerPlanningPourAuditeur(
  7.             $user, $tacheRepo, $auditRepo, $auditTypeRepo, $userRepo, $planifSuperviseurRepo,$habilitationRepository
  8.         );
  10.         return $this->render('interne/planification.html.twig', $data);
  11.     }
in vendor/symfony/http-kernel/HttpKernel.php -> planifAudit (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('/home/ks185124202150/public_html/mercurequaliteweb_test/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 12:14:44 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "b92c59"
    },
    "request_uri": "https://mercure-qualite-web-test.autobilan-systems.com/_profiler/b92c59",
    "method": "GET"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\UX\Turbo\Request\RequestListener::__invoke". 
{
    "event": "kernel.request",
    "listener": "Symfony\\UX\\Turbo\\Request\\RequestListener::__invoke"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 12:14:44 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 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 12:14:44 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 12:14:44 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
INFO 12:14:44 deprecation User Deprecated: Support for MySQL < 8 is deprecated and will be removed in DBAL 5 (AbstractMySQLDriver.php:75 called by AbstractDriverMiddleware.php:32, https://github.com/doctrine/dbal/pull/6343, package doctrine/dbal) 
{
    "exception": {}
}
DEBUG 12:14:44 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 12:14:44 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 12:14:44 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 12:14:44 event Notified event "kernel.controller_arguments" to listener "ContainerS9NxSAT\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "ContainerS9NxSAT\\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
}
DEBUG 12:14:44 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"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\UX\Turbo\Request\RequestListener::__invoke". 
{
    "event": "kernel.request",
    "listener": "Symfony\\UX\\Turbo\\Request\\RequestListener::__invoke"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 12:14:44 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 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 12:14:44 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 12:14:44 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 12:14:44 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 12:14:44 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 12:14:44 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 12:14:44 event Notified event "kernel.controller_arguments" to listener "ContainerS9NxSAT\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "ContainerS9NxSAT\\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
}
DEBUG 12:14:44 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"
}
DEBUG 12:14:44 event Notified event "kernel.response" to listener "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\Security\\Csrf\\SameOriginCsrfTokenManager::onKernelResponse"
}
DEBUG 12:14:44 event Notified event "kernel.response" to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\Security\\Http\\Firewall\\ContextListener::onKernelResponse"
}
DEBUG 12:14:44 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ResponseListener::onKernelResponse"
}
DEBUG 12:14:44 event Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\WebLink\\EventListener\\AddLinkHeaderListener::onKernelResponse"
}
DEBUG 12:14:44 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelResponse"
}
DEBUG 12:14:44 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelResponse"
}
DEBUG 12:14:44 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ProfilerListener::onKernelResponse"
}
DEBUG 12:14:44 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::removeCspHeader"
}
DEBUG 12:14:44 event Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Bundle\\WebProfilerBundle\\EventListener\\WebDebugToolbarListener::onKernelResponse"
}
DEBUG 12:14:44 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DisallowRobotsIndexingListener::onResponse"
}
DEBUG 12:14:44 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse". 
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelResponse"
}
DEBUG 12:14:44 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelFinishRequest"
}
DEBUG 12:14:44 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelFinishRequest"
}
DEBUG 12:14:44 event Notified event "kernel.finish_request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelFinishRequest"
}
DEBUG 12:14:44 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest". 
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelFinishRequest"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\UX\Turbo\Request\RequestListener::__invoke". 
{
    "event": "kernel.request",
    "listener": "Symfony\\UX\\Turbo\\Request\\RequestListener::__invoke"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 12:14:44 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 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 12:14:44 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 12:14:44 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 12:14:44 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 12:14:44 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 12:14:44 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 12:14:44 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 12:14:44 event Notified event "kernel.controller_arguments" to listener "ContainerS9NxSAT\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "ContainerS9NxSAT\\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
}
DEBUG 12:14:44 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 Traces 3

[3/3] InvalidFieldNameException 
Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.date_affectation_auditeur' in 'field list'

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:63
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1456)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1392)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Connection.php:809)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:1848)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement()
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:1793)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection()
     (vendor/doctrine/orm/src/UnitOfWork.php:2709)
  at Doctrine\ORM\UnitOfWork->loadCollection()
     (vendor/doctrine/orm/src/PersistentCollection.php:636)
  at Doctrine\ORM\PersistentCollection->doInitialize()
     (vendor/doctrine/orm/src/PersistentCollection.php:186)
  at Doctrine\ORM\PersistentCollection->initialize()
     (vendor/doctrine/collections/src/AbstractLazyCollection.php:313)
  at Doctrine\Common\Collections\AbstractLazyCollection->getIterator()
     (src/Controller/AuditAgendaController.php:328)
  at App\Controller\AuditAgendaController->calculerPlanningPourAuditeur()
     (src/Controller/AuditAgendaController.php:229)
  at App\Controller\AuditAgendaController->planifAudit()
     (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('/home/ks185124202150/public_html/mercurequaliteweb_test/vendor/autoload_runtime.php')
     (public/index.php:5)
[2/3] Exception 
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.date_affectation_auditeur' in 'field list'

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:57)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/doctrine/dbal/src/Logging/Statement.php:46)
  at Doctrine\DBAL\Logging\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php:58)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:802)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:1848)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement()
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:1793)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection()
     (vendor/doctrine/orm/src/UnitOfWork.php:2709)
  at Doctrine\ORM\UnitOfWork->loadCollection()
     (vendor/doctrine/orm/src/PersistentCollection.php:636)
  at Doctrine\ORM\PersistentCollection->doInitialize()
     (vendor/doctrine/orm/src/PersistentCollection.php:186)
  at Doctrine\ORM\PersistentCollection->initialize()
     (vendor/doctrine/collections/src/AbstractLazyCollection.php:313)
  at Doctrine\Common\Collections\AbstractLazyCollection->getIterator()
     (src/Controller/AuditAgendaController.php:328)
  at App\Controller\AuditAgendaController->calculerPlanningPourAuditeur()
     (src/Controller/AuditAgendaController.php:229)
  at App\Controller\AuditAgendaController->planifAudit()
     (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('/home/ks185124202150/public_html/mercurequaliteweb_test/vendor/autoload_runtime.php')
     (public/index.php:5)
[1/3] PDOException 
PDOException:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.date_affectation_auditeur' in 'field list'

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:55
  at PDOStatement->execute()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:55)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/doctrine/dbal/src/Logging/Statement.php:46)
  at Doctrine\DBAL\Logging\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php:58)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:802)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:1848)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement()
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:1793)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection()
     (vendor/doctrine/orm/src/UnitOfWork.php:2709)
  at Doctrine\ORM\UnitOfWork->loadCollection()
     (vendor/doctrine/orm/src/PersistentCollection.php:636)
  at Doctrine\ORM\PersistentCollection->doInitialize()
     (vendor/doctrine/orm/src/PersistentCollection.php:186)
  at Doctrine\ORM\PersistentCollection->initialize()
     (vendor/doctrine/collections/src/AbstractLazyCollection.php:313)
  at Doctrine\Common\Collections\AbstractLazyCollection->getIterator()
     (src/Controller/AuditAgendaController.php:328)
  at App\Controller\AuditAgendaController->calculerPlanningPourAuditeur()
     (src/Controller/AuditAgendaController.php:229)
  at App\Controller\AuditAgendaController->planifAudit()
     (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('/home/ks185124202150/public_html/mercurequaliteweb_test/vendor/autoload_runtime.php')
     (public/index.php:5)