https://jkc-formations.com/prospects/new/63496198d81be?amp%253Bp%3Dprospects%252Fnew%252F63496198d81be%26amp%253Bp%253Dprospects%25252Fnew%25252F63496198d81be%3D%26p%3Dprospects%252Fnew%252F63496198d81be=&p=prospects%2Fnew%2F63496198d81be

Method
GET
HTTP Status
500
IP
20.171.206.112
Profiled on
Token
5c707a

ErrorController

Request

GET Parameters

Key Value
amp%3Bp=prospects%2Fnew%2F63496198d81be&amp%3Bp%3Dprospects%252Fnew%252F63496198d81be=&p=prospects%2Fnew%2F63496198d81be 
""
p 
"prospects/new/63496198d81be"

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller 
"error_controller"
_stopwatch_token 
"a98eb9"
exception 
Doctrine\DBAL\Exception\TableNotFoundException {#668
  -query: Doctrine\DBAL\Query {#692 …}
  #message: "An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'jkcformations.referents' doesn't exist"
  #code: 1146
  #file: "/var/www/vhosts/jkc-formations.com/httpdocs/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
  #line: 49
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#680 …}
  trace: {
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:49 {
      Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
      › case 1146:
      ›     return new TableNotFoundException($exception, $query);
      › 
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/doctrine/dbal/src/Connection.php:1818 {
      Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
      › $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
      › $exception                  = $this->exceptionConverter->convert($driverException, $query);
      › 
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/doctrine/dbal/src/Connection.php:1761 {
      Doctrine\DBAL\Connection->convertExceptionDuringQuery(Exception $e, string $sql, array $params = [], array $types = []): DriverException …
      › ): DriverException {
      ›     return $this->handleDriverException($e, new Query($sql, $params, $types));
      › }
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/doctrine/dbal/src/Connection.php:1034 {
      Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], $types = [], QueryCacheProfile $qcp = null): Result …
      › } catch (Driver\Exception $e) {
      ›     throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
      › } finally {
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:750 {
      Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(array $criteria, $entity = null, $assoc = null, array $hints = [], $lockMode = null, $limit = null, array $orderBy = null) …
      › [$params, $types] = $this->expandParameters($criteria);
      › $stmt             = $this->conn->executeQuery($sql, $params, $types);
      › 
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:241 {
      Doctrine\ORM\EntityRepository->findOneBy(array $criteria, array $orderBy = null) …
      › 
      ›     return $persister->load($criteria, null, null, [], null, 1, $orderBy);
      › }
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/src/Controller/ProspectsController.php:35 {
      App\Controller\ProspectsController->new(Request $request, ProspectsRepository $prospectsRepository, $code, ReferentsRepository $referentsRepo): Response …
      › 
      › $referent = $referentsRepo->findOneBy(array('Code'=>$code));
      › if(empty($referent))
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/symfony/http-kernel/HttpKernel.php:153 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › // call controller
      › $response = $controller(...$arguments);
      › 
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/symfony/http-kernel/HttpKernel.php:75 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->handleRaw($request, $type);
      › } catch (\Exception $e) {
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/symfony/http-kernel/Kernel.php:202 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->getHttpKernel()->handle($request, $type, $catch);
      › } finally {
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/public/index.php:28 {
      › $request = Request::createFromGlobals();\r
      › $response = $kernel->handle($request);\r
      › $response->send();\r
    }
  }
}
logger 
Symfony\Bridge\Monolog\Logger {#118 …8}

Request Headers

Header Value
accept 
"*/*"
accept-encoding 
"gzip, br, deflate"
connection 
"close"
from 
"gptbot(at)openai.com"
host 
"jkc-formations.com"
user-agent 
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)"
x-accel-internal 
"/internal-nginx-static-location"
x-openai-host-hash 
"28490359"
x-php-ob-level 
"1"
x-real-ip 
"20.171.206.112"

Request Content

Request content not available (it was retrieved as a resource).

Response

Response Headers

Header Value
cache-control 
"no-cache, private"
content-type 
"text/html; charset=UTF-8"
date 
"Mon, 04 Nov 2024 08:28:28 GMT"
x-debug-exception 
"An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5B42S02%5D%3A%20Base%20table%20or%20view%20not%20found%3A%201146%20Table%20%27jkcformations.referents%27%20doesn%27t%20exist"
x-debug-exception-file 
"%2Fvar%2Fwww%2Fvhosts%2Fjkc-formations.com%2Fhttpdocs%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FMySQL%2FExceptionConverter.php:49"
x-debug-token 
"5c707a"

Cookies

Request Cookies

No request cookies

Response Cookies

No response cookies

Session

Session Metadata

No session metadata

Session Attributes

No session attributes

Session Usage

0 Usages
Stateless check enabled

Session not used.

Flashes

Flashes

No flash messages were created.

Server Parameters

Server Parameters

Defined in .env

Key Value
APP_ENV 
"dev"
APP_SECRET 
"a2c2c561f9de8e240e2a06452949c704"
DATABASE_URL 
"mysql://jkcformations:Jkcf!2022@127.0.0.1:3306/jkcformations?serverVersion=8&charset=utf8mb4"
MESSENGER_TRANSPORT_DSN 
"doctrine://default?auto_setup=0"

Defined as regular env variables

Key Value
APP_DEBUG 
"1"
CONTEXT_DOCUMENT_ROOT 
"/var/www/vhosts/jkc-formations.com/httpdocs/public"
CONTEXT_PREFIX 
""
DOCUMENT_ROOT 
"/var/www/vhosts/jkc-formations.com/httpdocs/public"
FCGI_ROLE 
"RESPONDER"
GATEWAY_INTERFACE 
"CGI/1.1"
HOME 
"/var/www/vhosts/jkc-formations.com"
HTTPS 
"on"
HTTP_ACCEPT 
"*/*"
HTTP_ACCEPT_ENCODING 
"gzip, br, deflate"
HTTP_CONNECTION 
"close"
HTTP_FROM 
"gptbot(at)openai.com"
HTTP_HOST 
"jkc-formations.com"
HTTP_USER_AGENT 
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)"
HTTP_X_ACCEL_INTERNAL 
"/internal-nginx-static-location"
HTTP_X_OPENAI_HOST_HASH 
"28490359"
HTTP_X_REAL_IP 
"20.171.206.112"
PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY 
"0"
PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY 
"0"
PATH 
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
PHP_SELF 
"/index.php"
QUERY_STRING 
"p=prospects/new/63496198d81be&amp%253Bp%3Dprospects%252Fnew%252F63496198d81be%26amp%253Bp%253Dprospects%25252Fnew%25252F63496198d81be%3D%26p%3Dprospects%252Fnew%252F63496198d81be"
REDIRECT_HTTPS 
"on"
REDIRECT_PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY 
"0"
REDIRECT_PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY 
"0"
REDIRECT_QUERY_STRING 
"p=prospects/new/63496198d81be&amp%253Bp%3Dprospects%252Fnew%252F63496198d81be%26amp%253Bp%253Dprospects%25252Fnew%25252F63496198d81be%3D%26p%3Dprospects%252Fnew%252F63496198d81be"
REDIRECT_SCRIPT_URI 
"https://jkc-formations.com/prospects/new/63496198d81be"
REDIRECT_SCRIPT_URL 
"/prospects/new/63496198d81be"
REDIRECT_STATUS 
"200"
REDIRECT_UNIQUE_ID 
"ZyiFrA3HObLRSuDAAgZ32gAAAFc"
REDIRECT_URL 
"/prospects/new/63496198d81be"
REMOTE_ADDR 
"20.171.206.112"
REMOTE_PORT 
"43436"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"https"
REQUEST_TIME 
1730708908
REQUEST_TIME_FLOAT 
1730708908.4141
REQUEST_URI 
"/prospects/new/63496198d81be?amp%253Bp%3Dprospects%252Fnew%252F63496198d81be%26amp%253Bp%253Dprospects%25252Fnew%25252F63496198d81be%3D%26p%3Dprospects%252Fnew%252F63496198d81be"
SCRIPT_FILENAME 
"/var/www/vhosts/jkc-formations.com/httpdocs/public/index.php"
SCRIPT_NAME 
"/index.php"
SCRIPT_URI 
"https://jkc-formations.com/prospects/new/63496198d81be"
SCRIPT_URL 
"/prospects/new/63496198d81be"
SERVER_ADDR 
"51.178.136.46"
SERVER_ADMIN 
"[no address given]"
SERVER_NAME 
"jkc-formations.com"
SERVER_PORT 
"443"
SERVER_PROTOCOL 
"HTTP/1.0"
SERVER_SIGNATURE 
"<address>Apache Server at jkc-formations.com Port 443</address>\n"
SERVER_SOFTWARE 
"Apache"
SYMFONY_DOTENV_VARS 
"MESSENGER_TRANSPORT_DSN,APP_ENV,APP_SECRET,DATABASE_URL"
UNIQUE_ID 
"ZyiFrA3HObLRSuDAAgZ32gAAAFc"
USER 
"jkc-formations.com_k5uxz7kqnf9"
proxy-nokeepalive 
"1"

Parent Request

Return to parent request (token = e4662c)

Key Value
_controller 
"error_controller"
_stopwatch_token 
"145ea2"
exception 
Symfony\Component\HttpKernel\Exception\NotFoundHttpException {#197
  -statusCode: 404
  -headers: []
  #message: "No route found for "GET https://jkc-formations.com/wp-content/themes/extol/settings.php%25252525252526quot%252526quot""
  #code: 0
  #file: "/var/www/vhosts/jkc-formations.com/httpdocs/vendor/symfony/http-kernel/EventListener/RouterListener.php"
  #line: 135
  -previous: Symfony\Component\Routing\Exception\ResourceNotFoundException {#171 …}
  trace: {
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/symfony/http-kernel/EventListener/RouterListener.php:135 {
      Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest(RequestEvent $event) …
      › 
      ›     throw new NotFoundHttpException($message, $e);
      › } catch (MethodNotAllowedException $e) {
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/symfony/event-dispatcher/Debug/WrappedListener.php:117 {
      Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object $event, string $eventName, EventDispatcherInterface $dispatcher): void …
      › 
      › ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
      › 
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/symfony/event-dispatcher/EventDispatcher.php:230 {
      Symfony\Component\EventDispatcher\EventDispatcher->callListeners(iterable $listeners, string $eventName, object $event) …
      ›     }
      ›     $listener($event, $eventName, $this);
      › }
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/symfony/event-dispatcher/EventDispatcher.php:59 {
      Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object $event, string $eventName = null): object …
      › if ($listeners) {
      ›     $this->callListeners($listeners, $eventName, $event);
      › }
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154 {
      Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object $event, string $eventName = null): object …
      › try {
      ›     $this->dispatcher->dispatch($event, $eventName);
      › } finally {
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/symfony/http-kernel/HttpKernel.php:129 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › $event = new RequestEvent($this, $request, $type);
      › $this->dispatcher->dispatch($event, KernelEvents::REQUEST);
      › 
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/symfony/http-kernel/HttpKernel.php:75 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->handleRaw($request, $type);
      › } catch (\Exception $e) {
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/vendor/symfony/http-kernel/Kernel.php:202 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->getHttpKernel()->handle($request, $type, $catch);
      › } finally {
    }
    /var/www/vhosts/jkc-formations.com/httpdocs/public/index.php:28 {
      › $request = Request::createFromGlobals();\r
      › $response = $kernel->handle($request);\r
      › $response->send();\r
    }
  }
}
logger 
Symfony\Bridge\Monolog\Logger {#118 …8}