Error 500 Internal Server Error

GET https://staging.archipel.faktr.fr/carte

Forwarded to ErrorController (c00d45)

IslandController :: map

Request

GET Parameters

None

POST Parameters

None

Uploaded Files

None

Request Attributes

Key Value
_controller
"App\Controller\IslandController::map"
_firewall_context
"security.firewall.map.context.main"
_remove_csp_headers
true
_route
"app_map"
_route_params
[]
_security_authenticators
[]
_security_firewall_run
"_security_main"
_security_skipped_authenticators
[
  Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator {#565
    -supports: false
    -passport: null
    -duration: null
    -stub: "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
    -authenticated: null
    -exception: null
    -authenticator: Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator {#506 …}
  }
]
_stopwatch_token
"610dbf"

Request Headers

Header Value
accept
"*/*"
accept-encoding
"gzip, br, zstd, deflate"
host
"staging.archipel.faktr.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; charset=UTF-8"
date
"Sun, 24 May 2026 10:28:36 GMT"
set-cookie
[
  "main_deauth_profile_token=c00d45; path=/; secure; httponly; samesite=lax"
  "main_auth_profile_token=deleted; expires=Sat, 24 May 2025 10:28:35 GMT; Max-Age=0; path=/; httponly"
]
vary
"Accept"
x-debug-exception
"An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5B42S22%5D%3A%20Column%20not%20found%3A%201054%20Unknown%20column%20%27s1_.country%27%20in%20%27SELECT%27"
x-debug-exception-file
"%2Fvar%2Fwww%2Farchipel-staging%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FMySQL%2FExceptionConverter.php:63"
x-debug-token
"c41b48"
x-debug-token-link
"https://staging.archipel.faktr.fr/_profiler/c00d45"
x-previous-debug-token
"c00d45"
x-robots-tag
"noindex"

Cookies

Request Cookies

No request cookies

Response Cookies

Key Value
main_auth_profile_token
Symfony\Component\HttpFoundation\Cookie {#1514
  #expire: 1
  #path: "/"
  -sameSite: null
  -secureDefault: true
  #name: "main_auth_profile_token"
  #value: null
  #domain: null
  #secure: false
  #httpOnly: true
  -raw: false
  -partitioned: false
}
main_deauth_profile_token
Symfony\Component\HttpFoundation\Cookie {#222
  #expire: 0
  #path: "/"
  -sameSite: "lax"
  -secureDefault: true
  #name: "main_deauth_profile_token"
  #value: "c00d45"
  #domain: null
  #secure: null
  #httpOnly: true
  -raw: false
  -partitioned: false
}

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
"1"
APP_ENV
"dev"
APP_SECRET
"qsidjfoisqjfqs23dsjfsdoi83sdfep2"
APP_SHARE_DIR
"var/share"
DATABASE_URL
"mysql://archipel:Vdz79pmpd@127.0.0.1:3306/archipel_staging?serverVersion=10.6.23-MariaDB&charset=utf8mb4"
DEFAULT_URI
"http://localhost"
MESSENGER_TRANSPORT_DSN
"doctrine://default?auto_setup=0"
SIGHTENGINE_API_SECRET
"MRT8ME66Le6ohcRTJBiJHrtEQqBEcgE3"
SIGHTENGINE_API_USER
"1268477980"

Defined as regular env variables

Key Value
APP_PROJECT_DIR
"/var/www/archipel-staging"
APP_RUNTIME
"Symfony\Component\Runtime\SymfonyRuntime"
APP_RUNTIME_OPTIONS
[
  "project_dir" => "/var/www/archipel-staging"
]
CONTENT_LENGTH
""
CONTENT_TYPE
""
DOCUMENT_ROOT
"/var/www/archipel-staging/public"
DOCUMENT_URI
"/index.php"
FCGI_ROLE
"RESPONDER"
GATEWAY_INTERFACE
"CGI/1.1"
HOME
"/var/www"
HTTPS
"on"
HTTP_ACCEPT
"*/*"
HTTP_ACCEPT_ENCODING
"gzip, br, zstd, deflate"
HTTP_HOST
"staging.archipel.faktr.fr"
HTTP_USER_AGENT
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
PHP_SELF
"/index.php"
QUERY_STRING
""
REDIRECT_STATUS
"200"
REMOTE_ADDR
"216.73.217.75"
REMOTE_PORT
"50501"
REMOTE_USER
""
REQUEST_METHOD
"GET"
REQUEST_SCHEME
"https"
REQUEST_TIME
1779618515
REQUEST_TIME_FLOAT
1779618515.963
REQUEST_URI
"/carte"
SCRIPT_FILENAME
"/var/www/archipel-staging/public/index.php"
SCRIPT_NAME
"/index.php"
SERVER_ADDR
"217.154.119.29"
SERVER_NAME
"staging.archipel.faktr.fr"
SERVER_PORT
"443"
SERVER_PROTOCOL
"HTTP/2.0"
SERVER_SOFTWARE
"nginx/1.18.0"
SYMFONY_DOTENV_PATH
"/var/www/archipel-staging/.env"
SYMFONY_DOTENV_VARS
"APP_ENV,APP_DEBUG,APP_SECRET,APP_SHARE_DIR,DEFAULT_URI,DATABASE_URL,MESSENGER_TRANSPORT_DSN,SIGHTENGINE_API_USER,SIGHTENGINE_API_SECRET"
USER
"www-data"

Sub Requests 1

ErrorController (token = c00d45)

Key Value
_controller
"error_controller"
_stopwatch_token
"973ec3"
exception
Doctrine\DBAL\Exception\InvalidFieldNameException {#960
  #message: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 's1_.country' in 'SELECT'"
  #code: 1054
  #file: "/var/www/archipel-staging/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
  #line: 63
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#964 …}
  -query: Doctrine\DBAL\Query {#963 …}
  trace: {
    /var/www/archipel-staging/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:63 {
      Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
      › 1166,1611 => new InvalidFieldNameException($exception, $query),1052,
    }
    /var/www/archipel-staging/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);}
    /var/www/archipel-staging/vendor/doctrine/dbal/src/Connection.php:1396 {
      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/archipel-staging/vendor/doctrine/dbal/src/Connection.php:809 {
      Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], array $types = [], ?QueryCacheProfile $qcp = null): Result …
      › } catch (Driver\Exception $e) {    throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);}
    }
    /var/www/archipel-staging/vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27 {
      Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute(Connection $conn, array $params, array $types): Result …
      › {    return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);}
    }
    /var/www/archipel-staging/vendor/doctrine/orm/src/Query.php:296 {
      Doctrine\ORM\Query->_doExecute(): Result|int …
      › 
      ›     return $executor->execute($this->em->getConnection(), $sqlParams, $types);}
    }
    /var/www/archipel-staging/vendor/doctrine/orm/src/AbstractQuery.php:930 {
      Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(Doctrine\Common\Collections\ArrayCollection|array|null $parameters = null, string|int|null $hydrationMode = null): mixed …
      › 
      › $stmt = $this->_doExecute();}
    /var/www/archipel-staging/vendor/doctrine/orm/src/AbstractQuery.php:886 {
      Doctrine\ORM\AbstractQuery->execute(Doctrine\Common\Collections\ArrayCollection|array|null $parameters = null, string|int|null $hydrationMode = null): mixed …
      › 
      ›     return $this->executeIgnoreQueryCache($parameters, $hydrationMode);}
    }
    /var/www/archipel-staging/vendor/doctrine/orm/src/AbstractQuery.php:688 {
      Doctrine\ORM\AbstractQuery->getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed …
      › {    return $this->execute(null, $hydrationMode);}
    }
    /var/www/archipel-staging/src/Repository/IslandRepository.php:60 {
      App\Repository\IslandRepository->findPublicIslands(): array …
      ›         ->getQuery()        ->getResult();}
    }
    /var/www/archipel-staging/src/Controller/IslandController.php:39 {
      App\Controller\IslandController->map(IslandRepository $islandRepository): Response …
      › // On expose uniquement les îlots ACTIVE et CREATION sur la carte publique$islands = $islandRepository->findPublicIslands();}
    /var/www/archipel-staging/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);}
    /var/www/archipel-staging/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) {
    }
    /var/www/archipel-staging/vendor/symfony/http-kernel/Kernel.php:191 {
      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 {
    }
    /var/www/archipel-staging/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
      Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
      › {    $response = $this->kernel->handle($this->request);}
    /var/www/archipel-staging/vendor/autoload_runtime.php:32 {
      require_once …
      ›         ->getRunner($app)        ->run());
    }
    /var/www/archipel-staging/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';arguments: {
        "/var/www/archipel-staging/vendor/autoload_runtime.php"
      }
    }
  }
}
logger
Symfony\Bridge\Monolog\Processor\DebugProcessor {#153
  -records: [
    2 => [
      [
        "timestamp" => 1779618515
        "timestamp_rfc3339" => "2026-05-24T10:28:35.969+00:00"
        "message" => "Matched route "{route}"."
        "priority" => 200
        "priorityName" => "INFO"
        "context" => [
          "route" => "app_map"
          "route_parameters" => [
            "_route" => "app_map"
            "_controller" => "App\Controller\IslandController::map"
          ]
          "request_uri" => "https://staging.archipel.faktr.fr/carte"
          "method" => "GET"
        ]
        "channel" => "request"
      ]
      [
        "timestamp" => 1779618515
        "timestamp_rfc3339" => "2026-05-24T10:28:35.970+00:00"
        "message" => "Checking for authenticator support."
        "priority" => 100
        "priorityName" => "DEBUG"
        "context" => [
          "firewall_name" => "main"
          "authenticators" => 1
        ]
        "channel" => "security"
      ]
      [
        "timestamp" => 1779618515
        "timestamp_rfc3339" => "2026-05-24T10:28:35.970+00:00"
        "message" => "Checking support on authenticator."
        "priority" => 100
        "priorityName" => "DEBUG"
        "context" => [
          "firewall_name" => "main"
          "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
        ]
        "channel" => "security"
      ]
      [
        "timestamp" => 1779618515
        "timestamp_rfc3339" => "2026-05-24T10:28:35.970+00:00"
        "message" => "Authenticator does not support the request."
        "priority" => 100
        "priorityName" => "DEBUG"
        "context" => [
          "firewall_name" => "main"
          "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
        ]
        "channel" => "security"
      ]
      [
        "timestamp" => 1779618515
        "timestamp_rfc3339" => "2026-05-24T10:28:35.977+00:00"
        "message" => "Connecting with parameters {params}"
        "priority" => 200
        "priorityName" => "INFO"
        "context" => [
          "params" => [
            "driver" => "pdo_mysql"
            "idle_connection_ttl" => 600
            "host" => "127.0.0.1"
            "port" => 3306
            "user" => "archipel"
            "password" => "<redacted>"
            "driverOptions" => []
            "defaultTableOptions" => []
            "dbname" => "archipel_staging"
            "serverVersion" => "10.6.23-MariaDB"
            "charset" => "utf8mb4"
          ]
        ]
        "channel" => "doctrine"
      ]
      [
        "timestamp" => 1779618515
        "timestamp_rfc3339" => "2026-05-24T10:28:35.978+00:00"
        "message" => "Executing statement: {sql} (parameters: {params}, types: {types})"
        "priority" => 100
        "priorityName" => "DEBUG"
        "context" => [
          "sql" => "SELECT i0_.id AS id_0, i0_.slug AS slug_1, i0_.name AS name_2, i0_.description AS description_3, i0_.surface AS surface_4, i0_.latitude AS latitude_5, i0_.longitude AS longitude_6, i0_.status AS status_7, i0_.created_at AS created_at_8, i0_.updated_at AS updated_at_9, s1_.id AS id_10, s1_.name AS name_11, s1_.slug AS slug_12, s1_.address AS address_13, s1_.postcode AS postcode_14, s1_.city AS city_15, s1_.phone AS phone_16, s1_.country AS country_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, m2_.id AS id_20, m2_.original_filename AS original_filename_21, m2_.stored_filename AS stored_filename_22, m2_.mime_type AS mime_type_23, m2_.size AS size_24, m2_.context AS context_25, m2_.status AS status_26, m2_.created_at AS created_at_27, m2_.is_hero AS is_hero_28, i0_.school_id AS school_id_29, m2_.island_id AS island_id_30, m2_.uploaded_by_id AS uploaded_by_id_31, m2_.camera_trap_id AS camera_trap_id_32 FROM island i0_ LEFT JOIN school s1_ ON i0_.school_id = s1_.id LEFT JOIN media m2_ ON i0_.id = m2_.island_id WHERE i0_.status IN (?, ?) AND i0_.latitude IS NOT NULL AND i0_.longitude IS NOT NULL ORDER BY i0_.name ASC"
          "params" => [
            1 => "active"
            2 => "creation"
          ]
          "types" => [
            1 => Doctrine\DBAL\ParameterType {#975
              +name: "STRING"
            }
            2 => Doctrine\DBAL\ParameterType {#975}
          ]
        ]
        "channel" => "doctrine"
      ]
      [
        "timestamp" => 1779618515
        "timestamp_rfc3339" => "2026-05-24T10:28:35.980+00:00"
        "message" => "Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 's1_.country' in 'SELECT'" at ExceptionConverter.php line 63"
        "priority" => 500
        "priorityName" => "CRITICAL"
        "context" => [
          "exception" => Doctrine\DBAL\Exception\InvalidFieldNameException {#960
            #message: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 's1_.country' in 'SELECT'"
            #code: 1054
            #file: "/var/www/archipel-staging/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
            #line: 63
            -previous: Doctrine\DBAL\Driver\PDO\Exception {#964 …}
            -query: Doctrine\DBAL\Query {#963 …}
            trace: {
              /var/www/archipel-staging/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:63 {
                Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
                › 1166,1611 => new InvalidFieldNameException($exception, $query),1052,
              }
              /var/www/archipel-staging/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);}
              /var/www/archipel-staging/vendor/doctrine/dbal/src/Connection.php:1396 {
                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/archipel-staging/vendor/doctrine/dbal/src/Connection.php:809 {
                Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], array $types = [], ?QueryCacheProfile $qcp = null): Result …
                › } catch (Driver\Exception $e) {    throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);}
              }
              /var/www/archipel-staging/vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27 {
                Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute(Connection $conn, array $params, array $types): Result …
                › {    return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);}
              }
              /var/www/archipel-staging/vendor/doctrine/orm/src/Query.php:296 {
                Doctrine\ORM\Query->_doExecute(): Result|int …
                › 
                ›     return $executor->execute($this->em->getConnection(), $sqlParams, $types);}
              }
              /var/www/archipel-staging/vendor/doctrine/orm/src/AbstractQuery.php:930 {
                Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(Doctrine\Common\Collections\ArrayCollection|array|null $parameters = null, string|int|null $hydrationMode = null): mixed …
                › 
                › $stmt = $this->_doExecute();}
              /var/www/archipel-staging/vendor/doctrine/orm/src/AbstractQuery.php:886 {
                Doctrine\ORM\AbstractQuery->execute(Doctrine\Common\Collections\ArrayCollection|array|null $parameters = null, string|int|null $hydrationMode = null): mixed …
                › 
                ›     return $this->executeIgnoreQueryCache($parameters, $hydrationMode);}
              }
              /var/www/archipel-staging/vendor/doctrine/orm/src/AbstractQuery.php:688 {
                Doctrine\ORM\AbstractQuery->getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed …
                › {    return $this->execute(null, $hydrationMode);}
              }
              /var/www/archipel-staging/src/Repository/IslandRepository.php:60 {
                App\Repository\IslandRepository->findPublicIslands(): array …
                ›         ->getQuery()        ->getResult();}
              }
              /var/www/archipel-staging/src/Controller/IslandController.php:39 {
                App\Controller\IslandController->map(IslandRepository $islandRepository): Response …
                › // On expose uniquement les îlots ACTIVE et CREATION sur la carte publique$islands = $islandRepository->findPublicIslands();}
              /var/www/archipel-staging/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);}
              /var/www/archipel-staging/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) {
              }
              /var/www/archipel-staging/vendor/symfony/http-kernel/Kernel.php:191 {
                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 {
              }
              /var/www/archipel-staging/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
                Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
                › {    $response = $this->kernel->handle($this->request);}
              /var/www/archipel-staging/vendor/autoload_runtime.php:32 {
                require_once …
                ›         ->getRunner($app)        ->run());
              }
              /var/www/archipel-staging/public/index.php:5 {
                › 
                › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';arguments: {
                  "/var/www/archipel-staging/vendor/autoload_runtime.php"
                }
              }
            }
          }
        ]
        "channel" => "request"
      ]
    ]
  ]
  -errorCount: [
    2 => 1
  ]
  -requestStack: Symfony\Component\HttpKernel\Debug\VirtualRequestStack {#152 …}
}