Error 500 Internal Server Error

GET https://sae301.mmi24d16.mmi-troyes.fr/backoffice

IP
216.73.216.48
Profiled on
Token
ac032c

ErrorController

Request

GET Parameters

None

POST Parameters

None

Uploaded Files

None

Request Attributes

Key Value
_controller 
"error_controller"
exception 
Doctrine\DBAL\Exception\ConnectionException {#553
  #message: "An exception occurred in the driver: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for symfony-db failed: Name or service not known"
  #code: 2002
  #file: "/var/www/sae301/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
  #line: 91
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#537 …}
  -query: null
  trace: {
    /var/www/sae301/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:91 {
      Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
      › 2005,
      › 2054 => new ConnectionException($exception, $query),
      › 2006,
    }
    /var/www/sae301/vendor/doctrine/dbal/src/Connection.php:1460 {
      Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
      › $this->exceptionConverter ??= $this->driver->getExceptionConverter();
      › $exception                  = $this->exceptionConverter->convert($driverException, $query);
      › 
      arguments: {
        $exception: Doctrine\DBAL\Driver\PDO\Exception {#537 …}
        $query: null
      }
    }
    /var/www/sae301/vendor/doctrine/dbal/src/Connection.php:1402 {
      Doctrine\DBAL\Connection->convertException(Exception $e): DriverException …
      › {
      ›     return $this->handleDriverException($e, null);
      › }
      arguments: {
        $driverException: Doctrine\DBAL\Driver\PDO\Exception {#537 …}
        $query: null
      }
    }
    /var/www/sae301/vendor/doctrine/dbal/src/Connection.php:224 {
      Doctrine\DBAL\Connection->connect(): Connection …
      › } catch (Driver\Exception $e) {
      ›     throw $this->convertException($e);
      › }
      arguments: {
        $e: Doctrine\DBAL\Driver\PDO\Exception {#537 …}
      }
    }
    /var/www/sae301/vendor/doctrine/dbal/src/Connection.php:792 {
      Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], array $types = [], ?QueryCacheProfile $qcp = null): Result …
      › 
      › $connection = $this->connect();
      › 
    }
    /var/www/sae301/vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:963 {
      Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll(array $criteria = [], ?array $orderBy = null, ?int $limit = null, ?int $offset = null): array …
      › [$params, $types] = $this->expandParameters($criteria);
      › $stmt             = $this->conn->executeQuery($sql, $params, $types);
      › 
      arguments: {
        $sql: "SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.type_service AS type_service_6, t0.adresse AS adresse_7, t0.date_souhaitee AS date_souhaitee_8, t0.creneau_horaire AS creneau_horaire_9, t0.message AS message_10, t0.photo AS photo_11, t0.urgence AS urgence_12, t0.accepte_conditions AS accepte_conditions_13, t0.autorisation_contact AS autorisation_contact_14, t0.date_creation AS date_creation_15, t0.statut AS statut_16, t0.creneau_id AS creneau_id_17 FROM commande t0 ORDER BY t0.date_creation DESC"
        $params: []
        $types: []
      }
    }
    /var/www/sae301/vendor/doctrine/orm/src/EntityRepository.php:110 {
      Doctrine\ORM\EntityRepository->findBy(array $criteria, ?array $orderBy = null, ?int $limit = null, ?int $offset = null): array …
      › 
      ›     return $persister->loadAll($criteria, $orderBy, $limit, $offset);
      › }
      arguments: {
        $criteria: []
        $orderBy: [ …1]
        $limit: null
        $offset: null
      }
    }
    /var/www/sae301/vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php:73 {
      Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy(array $criteria, ?array $orderBy = null, ?int $limit = null, ?int $offset = null): array …
      ›     return ($this->repository ??= $this->resolveRepository())
      ›         ->findBy($criteria, $orderBy, $limit, $offset);
      › }
      arguments: {
        $criteria: []
        $orderBy: [ …1]
        $limit: null
        $offset: null
      }
    }
    /var/www/sae301/src/Controller/BackOfficeController.php:24 {
      App\Controller\BackOfficeController->index(CommandeRepository $commandeRepository, ServiceRepository $serviceRepository, CreneauRepository $creneauRepository): Response …
      › ): Response {
      ›     $reservations = $commandeRepository->findBy([], ['dateCreation' => 'DESC']);
      › 
      arguments: {
        $criteria: []
        $orderBy: [ …1]
      }
    }
    /var/www/sae301/vendor/symfony/http-kernel/HttpKernel.php:183 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › // call controller
      › $response = $controller(...$arguments);
      › 
      arguments: {
        $commandeRepository: App\Repository\CommandeRepository {#372 …}
        $serviceRepository: App\Repository\ServiceRepository {#374 …}
        $creneauRepository: App\Repository\CreneauRepository {#375 …}
      }
    }
    /var/www/sae301/vendor/symfony/http-kernel/HttpKernel.php:76 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
      › try {
      ›     return $response = $this->handleRaw($request, $type);
      › } catch (\Throwable $e) {
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#5 …}
        $type: 1
      }
    }
    /var/www/sae301/vendor/symfony/http-kernel/Kernel.php:193 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
      › try {
      ›     return $this->getHttpKernel()->handle($request, $type, $catch);
      › } finally {
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#5 …}
        $type: 1
        $catch: true
      }
    }
    /var/www/sae301/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
      Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
      › {
      ›     $response = $this->kernel->handle($this->request);
      › 
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#5 …}
      }
    }
    /var/www/sae301/vendor/autoload_runtime.php:32 {
      require_once …
      ›         ->getRunner($app)
      ›         ->run()
      › );
    }
    /var/www/sae301/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
      › 
      arguments: {
        "/var/www/sae301/vendor/autoload_runtime.php"
      }
    }
  }
}
logger 
null

Request Headers

Header Value
accept 
"*/*"
accept-encoding 
"gzip, br, zstd, deflate"
host 
"sae301.mmi24d16.mmi-troyes.fr"
user-agent 
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
x-php-ob-level 
"1"

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"
date 
"Fri, 27 Mar 2026 22:09:11 GMT"
vary 
"Accept"
x-debug-token 
"ac032c"

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_DEBUG 
"0"
APP_ENV 
"dev"
APP_SECRET 
"0e45725f562c11ea63176e764ac8544b"
APP_SHARE_DIR 
"var/share"
DATABASE_URL 
"mysql://root:PASSWORD@symfony-db:3306/sae301?serverVersion=10.8.8-MariaDB&charset=utf8mb4"
DEFAULT_URI 
"http://localhost"
MAILER_DSN 
"null://null"
MESSENGER_TRANSPORT_DSN 
"doctrine://default?auto_setup=0"

Defined as regular env variables

Key Value
APP_PROJECT_DIR 
"/var/www/sae301"
APP_RUNTIME 
"Symfony\Component\Runtime\SymfonyRuntime"
APP_RUNTIME_OPTIONS 
[
  "project_dir" => "/var/www/sae301"
]
CONTEXT_DOCUMENT_ROOT 
"/var/www/sae301/public"
CONTEXT_PREFIX 
""
DOCUMENT_ROOT 
"/var/www/sae301/public"
FCGI_ROLE 
"RESPONDER"
GATEWAY_INTERFACE 
"CGI/1.1"
H2PUSH 
"off"
H2_PUSH 
"off"
H2_PUSHED 
""
H2_PUSHED_ON 
""
H2_STREAM_ID 
"1"
H2_STREAM_TAG 
"4007026-18-1"
HOME 
"/var/www"
HTTP2 
"on"
HTTPS 
"on"
HTTP_ACCEPT 
"*/*"
HTTP_ACCEPT_ENCODING 
"gzip, br, zstd, deflate"
HTTP_HOST 
"sae301.mmi24d16.mmi-troyes.fr"
HTTP_USER_AGENT 
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
PATH 
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
PHP_SELF 
"/index.php"
QUERY_STRING 
""
REDIRECT_H2PUSH 
"off"
REDIRECT_H2_PUSH 
"off"
REDIRECT_H2_PUSHED 
""
REDIRECT_H2_PUSHED_ON 
""
REDIRECT_H2_STREAM_ID 
"1"
REDIRECT_H2_STREAM_TAG 
"4007026-18-1"
REDIRECT_HTTP2 
"on"
REDIRECT_HTTPS 
"on"
REDIRECT_SSL_TLS_SNI 
"sae301.mmi24d16.mmi-troyes.fr"
REDIRECT_STATUS 
"200"
REDIRECT_URL 
"/backoffice"
REMOTE_ADDR 
"216.73.216.48"
REMOTE_PORT 
"37585"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"https"
REQUEST_TIME 
1774649347
REQUEST_TIME_FLOAT 
1774649347.779
REQUEST_URI 
"/backoffice"
SCRIPT_FILENAME 
"/var/www/sae301/public/index.php"
SCRIPT_NAME 
"/index.php"
SERVER_ADDR 
"45.147.96.56"
SERVER_ADMIN 
"[no address given]"
SERVER_NAME 
"sae301.mmi24d16.mmi-troyes.fr"
SERVER_PORT 
"443"
SERVER_PROTOCOL 
"HTTP/2.0"
SERVER_SIGNATURE 
"<address>Apache/2.4.66 (Debian) Server at sae301.mmi24d16.mmi-troyes.fr Port 443</address>\n"
SERVER_SOFTWARE 
"Apache/2.4.66 (Debian)"
SSL_TLS_SNI 
"sae301.mmi24d16.mmi-troyes.fr"
SYMFONY_DOTENV_PATH 
"/var/www/sae301/.env"
SYMFONY_DOTENV_VARS 
"APP_ENV,APP_SECRET,APP_SHARE_DIR,DEFAULT_URI,DATABASE_URL,MESSENGER_TRANSPORT_DSN,MAILER_DSN,APP_DEBUG"
USER 
"www-data"
proxy-nokeepalive 
"1"

Parent Request

Return to parent request (token = 1c42e9)

Key Value
_controller 
"App\Controller\BackOfficeController::index"
_firewall_context 
"security.firewall.map.context.main"
_route 
"app_backoffice"
_route_params 
[]
_security_authenticators 
[]
_security_firewall_run 
"_security_main"
_security_skipped_authenticators 
[]