https://jkc-formations.com/prospects/new/63496198d81be?p=prospects%2Fnew%2F63496198d81be

Exceptions

An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jkcformations.referents' doesn't exist

  • Exceptions 3
  • Logs
  • Stack Traces 3

Doctrine\DBAL\Exception\ TableNotFoundException

  1.             case 1050:
  2.                 return new TableExistsException($exception$query);
  3.             case 1051:
  4.             case 1146:
  5.                 return new TableNotFoundException($exception$query);
  6.             case 1216:
  7.             case 1217:
  8.             case 1451:
  9.             case 1452:
  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);
  7.         if ($exception instanceof ConnectionLost) {
  8.             $this->close();
  9.         }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1761)
  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.     }
  8.     /** @internal */
  9.     final public function convertException(Driver\Exception $e): DriverException
  10.     {
in vendor/doctrine/dbal/src/Connection.php -> convertExceptionDuringQuery (line 1034)
  1.                 $result $connection->query($sql);
  2.             }
  3.             return new Result($result$this);
  4.         } catch (Driver\Exception $e) {
  5.             throw $this->convertExceptionDuringQuery($e$sql$params$types);
  6.         } finally {
  7.             if ($logger !== null) {
  8.                 $logger->stopQuery();
  9.             }
  10.         }
  1.     {
  2.         $this->switchPersisterContext(null$limit);
  3.         $sql              $this->getSelectSQL($criteria$assoc$lockMode$limitnull$orderBy);
  4.         [$params$types] = $this->expandParameters($criteria);
  5.         $stmt             $this->conn->executeQuery($sql$params$types);
  6.         if ($entity !== null) {
  7.             $hints[Query::HINT_REFRESH]        = true;
  8.             $hints[Query::HINT_REFRESH_ENTITY] = $entity;
  9.         }
  1.      */
  2.     public function findOneBy(array $criteria, ?array $orderBy null)
  3.     {
  4.         $persister $this->_em->getUnitOfWork()->getEntityPersister($this->_entityName);
  5.         return $persister->load($criterianullnull, [], null1$orderBy);
  6.     }
  7.     /**
  8.      * Counts entities by a set of criteria.
  9.      *
EntityRepository->findOneBy() in src/Controller/ProspectsController.php (line 35)
  1.      * @Route("/new/{code}", name="app_prospects_new", methods={"GET", "POST"})
  2.      */
  3.     public function new(Request $requestProspectsRepository $prospectsRepository,$codeReferentsRepository $referentsRepo): Response
  4.     {
  5.      
  6.         $referent $referentsRepo->findOneBy(array('Code'=>$code));
  7.         if(empty($referent))
  8.         {
  9.             dd("Erreur de code contacter l'administrateur");
  10.         }
  11.         $prospect = new Prospects();
  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.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  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 28)
  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);

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jkcformations.referents' doesn't exist

  1.         } else {
  2.             $code     $exception->getCode();
  3.             $sqlState null;
  4.         }
  5.         return new self($exception->getMessage(), $sqlState$code$exception);
  6.     }
  7. }
  1.         }
  2.         try {
  3.             $this->stmt->execute($params);
  4.         } catch (PDOException $exception) {
  5.             throw Exception::new($exception);
  6.         }
  7.         return new Result($this->stmt);
  8.     }
  1.     /**
  2.      * {@inheritdoc}
  3.      */
  4.     public function execute($params null): Result
  5.     {
  6.         return $this->wrappedStatement->execute($params);
  7.     }
  8. }
  1.             'sql'    => $this->sql,
  2.             'params' => $params ?? $this->params,
  3.             'types'  => $this->types,
  4.         ]);
  5.         return parent::execute($params);
  6.     }
  7. }
  1.     /**
  2.      * {@inheritdoc}
  3.      */
  4.     public function execute($params null): Result
  5.     {
  6.         return $this->wrappedStatement->execute($params);
  7.     }
  8. }
  1.         $this->debugDataHolder->addQuery($this->connectionName$query = clone $this->query);
  2.         $query->start();
  3.         try {
  4.             $result parent::execute($params);
  5.         } finally {
  6.             $query->stop();
  7.         }
  8.         return $result;
  1.                 $stmt $connection->prepare($sql);
  2.                 $this->bindParameters($stmt$params$types);
  3.                 $result $stmt->execute();
  4.             } else {
  5.                 $result $connection->query($sql);
  6.             }
  7.             return new Result($result$this);
  1.     {
  2.         $this->switchPersisterContext(null$limit);
  3.         $sql              $this->getSelectSQL($criteria$assoc$lockMode$limitnull$orderBy);
  4.         [$params$types] = $this->expandParameters($criteria);
  5.         $stmt             $this->conn->executeQuery($sql$params$types);
  6.         if ($entity !== null) {
  7.             $hints[Query::HINT_REFRESH]        = true;
  8.             $hints[Query::HINT_REFRESH_ENTITY] = $entity;
  9.         }
  1.      */
  2.     public function findOneBy(array $criteria, ?array $orderBy null)
  3.     {
  4.         $persister $this->_em->getUnitOfWork()->getEntityPersister($this->_entityName);
  5.         return $persister->load($criterianullnull, [], null1$orderBy);
  6.     }
  7.     /**
  8.      * Counts entities by a set of criteria.
  9.      *
EntityRepository->findOneBy() in src/Controller/ProspectsController.php (line 35)
  1.      * @Route("/new/{code}", name="app_prospects_new", methods={"GET", "POST"})
  2.      */
  3.     public function new(Request $requestProspectsRepository $prospectsRepository,$codeReferentsRepository $referentsRepo): Response
  4.     {
  5.      
  6.         $referent $referentsRepo->findOneBy(array('Code'=>$code));
  7.         if(empty($referent))
  8.         {
  9.             dd("Erreur de code contacter l'administrateur");
  10.         }
  11.         $prospect = new Prospects();
  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.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  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 28)
  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);

PDOException

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jkcformations.referents' doesn't exist

  1.                     ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  4.         try {
  5.             $this->stmt->execute($params);
  6.         } catch (PDOException $exception) {
  7.             throw Exception::new($exception);
  8.         }
  9.         return new Result($this->stmt);
  1.                     ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  4.         try {
  5.             $this->stmt->execute($params);
  6.         } catch (PDOException $exception) {
  7.             throw Exception::new($exception);
  8.         }
  9.         return new Result($this->stmt);
  1.     /**
  2.      * {@inheritdoc}
  3.      */
  4.     public function execute($params null): Result
  5.     {
  6.         return $this->wrappedStatement->execute($params);
  7.     }
  8. }
  1.             'sql'    => $this->sql,
  2.             'params' => $params ?? $this->params,
  3.             'types'  => $this->types,
  4.         ]);
  5.         return parent::execute($params);
  6.     }
  7. }
  1.     /**
  2.      * {@inheritdoc}
  3.      */
  4.     public function execute($params null): Result
  5.     {
  6.         return $this->wrappedStatement->execute($params);
  7.     }
  8. }
  1.         $this->debugDataHolder->addQuery($this->connectionName$query = clone $this->query);
  2.         $query->start();
  3.         try {
  4.             $result parent::execute($params);
  5.         } finally {
  6.             $query->stop();
  7.         }
  8.         return $result;
  1.                 $stmt $connection->prepare($sql);
  2.                 $this->bindParameters($stmt$params$types);
  3.                 $result $stmt->execute();
  4.             } else {
  5.                 $result $connection->query($sql);
  6.             }
  7.             return new Result($result$this);
  1.     {
  2.         $this->switchPersisterContext(null$limit);
  3.         $sql              $this->getSelectSQL($criteria$assoc$lockMode$limitnull$orderBy);
  4.         [$params$types] = $this->expandParameters($criteria);
  5.         $stmt             $this->conn->executeQuery($sql$params$types);
  6.         if ($entity !== null) {
  7.             $hints[Query::HINT_REFRESH]        = true;
  8.             $hints[Query::HINT_REFRESH_ENTITY] = $entity;
  9.         }
  1.      */
  2.     public function findOneBy(array $criteria, ?array $orderBy null)
  3.     {
  4.         $persister $this->_em->getUnitOfWork()->getEntityPersister($this->_entityName);
  5.         return $persister->load($criterianullnull, [], null1$orderBy);
  6.     }
  7.     /**
  8.      * Counts entities by a set of criteria.
  9.      *
EntityRepository->findOneBy() in src/Controller/ProspectsController.php (line 35)
  1.      * @Route("/new/{code}", name="app_prospects_new", methods={"GET", "POST"})
  2.      */
  3.     public function new(Request $requestProspectsRepository $prospectsRepository,$codeReferentsRepository $referentsRepo): Response
  4.     {
  5.      
  6.         $referent $referentsRepo->findOneBy(array('Code'=>$code));
  7.         if(empty($referent))
  8.         {
  9.             dd("Erreur de code contacter l'administrateur");
  10.         }
  11.         $prospect = new Prospects();
  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.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  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 28)
  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);