Error 500 Internal Server Error

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

Exceptions

An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 's1_.country' in 'SELECT'

Exceptions 3

Doctrine\DBAL\Exception\ InvalidFieldNameException

Show exception properties
Doctrine\DBAL\Exception\InvalidFieldNameException {#960
  -query: Doctrine\DBAL\Query {#963
    -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: array:2 [
      0 => "active"
      1 => "creation"
    ]
    -types: array:2 [
      0 => Doctrine\DBAL\ParameterType {#975
        +name: "STRING"
      }
      1 => Doctrine\DBAL\ParameterType {#975}
    ]
  }
}
  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,
  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 1396)
  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 809)
  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. }
  7. }
  8. /**
  9. * Executes a caching query.
  1. /**
  2. * {@inheritDoc}
  3. */
  4. public function execute(Connection $conn, array $params, array $types): Result
  5. {
  6. return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);
  7. }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 296)
  1. $sqlParams,
  2. $types,
  3. $this->em->getConnection()->getParams(),
  4. );
  5. return $executor->execute($this->em->getConnection(), $sqlParams, $types);
  6. }
  7. /**
  8. * @param array<string,mixed> $sqlParams
  9. * @param array<string,Type> $types
  1. $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2. $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3. };
  4. }
  5. $stmt = $this->_doExecute();
  6. if (is_numeric($stmt)) {
  7. $setCacheEntry($stmt);
  8. return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 886)
  1. ): mixed {
  2. if ($this->cacheable && $this->isCacheEnabled()) {
  3. return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4. }
  5. return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  6. }
  7. /**
  8. * Execute query ignoring second level cache.
  9. *
  1. *
  2. * @phpstan-param string|AbstractQuery::HYDRATE_* $hydrationMode
  3. */
  4. public function getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed
  5. {
  6. return $this->execute(null, $hydrationMode);
  7. }
  8. /**
  9. * Gets the array of results for the query.
  10. *
AbstractQuery->getResult() in src/Repository/IslandRepository.php (line 60)
  1. \App\Enum\IslandStatus::ACTIVE,
  2. \App\Enum\IslandStatus::CREATION,
  3. ])
  4. ->orderBy('i.name', 'ASC')
  5. ->getQuery()
  6. ->getResult();
  7. }
  8. // /**
  9. // * @return Island[] Returns an array of Island objects
  10. // */
IslandRepository->findPublicIslands() in src/Controller/IslandController.php (line 39)
  1. #[Route('/carte', name: 'app_map', methods: ['GET'])]
  2. public function map(IslandRepository $islandRepository): Response
  3. {
  4. // On expose uniquement les îlots ACTIVE et CREATION sur la carte publique
  5. $islands = $islandRepository->findPublicIslands();
  6. // Préparer les données pour Leaflet (JSON embarqué dans le template)
  7. $mapData = array_map(function (Island $island) {
  8. /** @var Media|null $hero */
  9. $hero = $island->getHeroMedia();
  1. $this->dispatcher->dispatch($event, KernelEvents::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, $event);
  9. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  2. $this->requestStack->push($request);
  3. $response = null;
  4. try {
  5. return $response = $this->handleRaw($request, $type);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  4. try {
  5. return $this->getHttpKernel()->handle($request, $type, $catch);
  6. } finally {
  7. --$this->requestStackSize;
  8. }
  9. }
  1. ) {
  2. }
  3. public function run(): int
  4. {
  5. $response = $this->kernel->handle($this->request);
  6. if (Kernel::VERSION_ID >= 60400) {
  7. $response->send(false);
  8. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  2. exit(
  3. $runtime
  4. ->getRunner($app)
  5. ->run()
  6. );
require_once('/var/www/archipel-staging/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  2. use App\Kernel;
  3. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  4. return function (array $context) {
  5. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  6. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42S22]: Column not found: 1054 Unknown column 's1_.country' in 'SELECT'

  1. } else {
  2. $code = $exception->getCode();
  3. $sqlState = null;
  4. }
  5. return new self($exception->getMessage(), $sqlState, $code, $exception);
  6. }
  7. }
  1. public function execute(): Result
  2. {
  3. try {
  4. $this->stmt->execute();
  5. } catch (PDOException $exception) {
  6. throw Exception::new($exception);
  7. }
  8. return new Result($this->stmt);
  9. }
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  3. public function execute(): Result
  4. {
  5. return $this->wrappedStatement->execute();
  6. }
  7. }
  1. 'sql' => $this->sql,
  2. 'params' => $this->params,
  3. 'types' => $this->types,
  4. ]);
  5. return parent::execute();
  6. }
  7. }
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  3. public function execute(): Result
  4. {
  5. return $this->wrappedStatement->execute();
  6. }
  7. }
  1. $this->stopwatch?->start('doctrine', 'doctrine');
  2. $query->start();
  3. try {
  4. return parent::execute();
  5. } finally {
  6. $query->stop();
  7. $this->stopwatch?->stop('doctrine');
  8. }
  9. }
  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. * {@inheritDoc}
  3. */
  4. public function execute(Connection $conn, array $params, array $types): Result
  5. {
  6. return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);
  7. }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 296)
  1. $sqlParams,
  2. $types,
  3. $this->em->getConnection()->getParams(),
  4. );
  5. return $executor->execute($this->em->getConnection(), $sqlParams, $types);
  6. }
  7. /**
  8. * @param array<string,mixed> $sqlParams
  9. * @param array<string,Type> $types
  1. $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2. $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3. };
  4. }
  5. $stmt = $this->_doExecute();
  6. if (is_numeric($stmt)) {
  7. $setCacheEntry($stmt);
  8. return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 886)
  1. ): mixed {
  2. if ($this->cacheable && $this->isCacheEnabled()) {
  3. return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4. }
  5. return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  6. }
  7. /**
  8. * Execute query ignoring second level cache.
  9. *
  1. *
  2. * @phpstan-param string|AbstractQuery::HYDRATE_* $hydrationMode
  3. */
  4. public function getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed
  5. {
  6. return $this->execute(null, $hydrationMode);
  7. }
  8. /**
  9. * Gets the array of results for the query.
  10. *
AbstractQuery->getResult() in src/Repository/IslandRepository.php (line 60)
  1. \App\Enum\IslandStatus::ACTIVE,
  2. \App\Enum\IslandStatus::CREATION,
  3. ])
  4. ->orderBy('i.name', 'ASC')
  5. ->getQuery()
  6. ->getResult();
  7. }
  8. // /**
  9. // * @return Island[] Returns an array of Island objects
  10. // */
IslandRepository->findPublicIslands() in src/Controller/IslandController.php (line 39)
  1. #[Route('/carte', name: 'app_map', methods: ['GET'])]
  2. public function map(IslandRepository $islandRepository): Response
  3. {
  4. // On expose uniquement les îlots ACTIVE et CREATION sur la carte publique
  5. $islands = $islandRepository->findPublicIslands();
  6. // Préparer les données pour Leaflet (JSON embarqué dans le template)
  7. $mapData = array_map(function (Island $island) {
  8. /** @var Media|null $hero */
  9. $hero = $island->getHeroMedia();
  1. $this->dispatcher->dispatch($event, KernelEvents::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, $event);
  9. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  2. $this->requestStack->push($request);
  3. $response = null;
  4. try {
  5. return $response = $this->handleRaw($request, $type);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  4. try {
  5. return $this->getHttpKernel()->handle($request, $type, $catch);
  6. } finally {
  7. --$this->requestStackSize;
  8. }
  9. }
  1. ) {
  2. }
  3. public function run(): int
  4. {
  5. $response = $this->kernel->handle($this->request);
  6. if (Kernel::VERSION_ID >= 60400) {
  7. $response->send(false);
  8. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  2. exit(
  3. $runtime
  4. ->getRunner($app)
  5. ->run()
  6. );
require_once('/var/www/archipel-staging/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  2. use App\Kernel;
  3. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  4. return function (array $context) {
  5. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  6. };

PDOException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 's1_.country' in 'SELECT'

  1. }
  2. public function execute(): Result
  3. {
  4. try {
  5. $this->stmt->execute();
  6. } catch (PDOException $exception) {
  7. throw Exception::new($exception);
  8. }
  9. return new Result($this->stmt);
  1. }
  2. public function execute(): Result
  3. {
  4. try {
  5. $this->stmt->execute();
  6. } catch (PDOException $exception) {
  7. throw Exception::new($exception);
  8. }
  9. return new Result($this->stmt);
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  3. public function execute(): Result
  4. {
  5. return $this->wrappedStatement->execute();
  6. }
  7. }
  1. 'sql' => $this->sql,
  2. 'params' => $this->params,
  3. 'types' => $this->types,
  4. ]);
  5. return parent::execute();
  6. }
  7. }
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  3. public function execute(): Result
  4. {
  5. return $this->wrappedStatement->execute();
  6. }
  7. }
  1. $this->stopwatch?->start('doctrine', 'doctrine');
  2. $query->start();
  3. try {
  4. return parent::execute();
  5. } finally {
  6. $query->stop();
  7. $this->stopwatch?->stop('doctrine');
  8. }
  9. }
  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. * {@inheritDoc}
  3. */
  4. public function execute(Connection $conn, array $params, array $types): Result
  5. {
  6. return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);
  7. }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 296)
  1. $sqlParams,
  2. $types,
  3. $this->em->getConnection()->getParams(),
  4. );
  5. return $executor->execute($this->em->getConnection(), $sqlParams, $types);
  6. }
  7. /**
  8. * @param array<string,mixed> $sqlParams
  9. * @param array<string,Type> $types
  1. $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2. $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3. };
  4. }
  5. $stmt = $this->_doExecute();
  6. if (is_numeric($stmt)) {
  7. $setCacheEntry($stmt);
  8. return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 886)
  1. ): mixed {
  2. if ($this->cacheable && $this->isCacheEnabled()) {
  3. return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4. }
  5. return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  6. }
  7. /**
  8. * Execute query ignoring second level cache.
  9. *
  1. *
  2. * @phpstan-param string|AbstractQuery::HYDRATE_* $hydrationMode
  3. */
  4. public function getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed
  5. {
  6. return $this->execute(null, $hydrationMode);
  7. }
  8. /**
  9. * Gets the array of results for the query.
  10. *
AbstractQuery->getResult() in src/Repository/IslandRepository.php (line 60)
  1. \App\Enum\IslandStatus::ACTIVE,
  2. \App\Enum\IslandStatus::CREATION,
  3. ])
  4. ->orderBy('i.name', 'ASC')
  5. ->getQuery()
  6. ->getResult();
  7. }
  8. // /**
  9. // * @return Island[] Returns an array of Island objects
  10. // */
IslandRepository->findPublicIslands() in src/Controller/IslandController.php (line 39)
  1. #[Route('/carte', name: 'app_map', methods: ['GET'])]
  2. public function map(IslandRepository $islandRepository): Response
  3. {
  4. // On expose uniquement les îlots ACTIVE et CREATION sur la carte publique
  5. $islands = $islandRepository->findPublicIslands();
  6. // Préparer les données pour Leaflet (JSON embarqué dans le template)
  7. $mapData = array_map(function (Island $island) {
  8. /** @var Media|null $hero */
  9. $hero = $island->getHeroMedia();
  1. $this->dispatcher->dispatch($event, KernelEvents::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, $event);
  9. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  2. $this->requestStack->push($request);
  3. $response = null;
  4. try {
  5. return $response = $this->handleRaw($request, $type);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  4. try {
  5. return $this->getHttpKernel()->handle($request, $type, $catch);
  6. } finally {
  7. --$this->requestStackSize;
  8. }
  9. }
  1. ) {
  2. }
  3. public function run(): int
  4. {
  5. $response = $this->kernel->handle($this->request);
  6. if (Kernel::VERSION_ID >= 60400) {
  7. $response->send(false);
  8. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  2. exit(
  3. $runtime
  4. ->getRunner($app)
  5. ->run()
  6. );
require_once('/var/www/archipel-staging/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  2. use App\Kernel;
  3. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  4. return function (array $context) {
  5. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  6. };

Logs

Level Channel Message
INFO 13:31:58 request Matched route "_profiler".
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "c00d45"
    },
    "request_uri": "https://staging.archipel.faktr.fr/_profiler/c00d45?panel=exception&type=request",
    "method": "GET"
}

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 's1_.country' in 'SELECT'

  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:1460)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1396)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Connection.php:809)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27)
  at Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute()
     (vendor/doctrine/orm/src/Query.php:296)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/src/AbstractQuery.php:688)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/Repository/IslandRepository.php:60)
  at App\Repository\IslandRepository->findPublicIslands()
     (src/Controller/IslandController.php:39)
  at App\Controller\IslandController->map()
     (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:191)
  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:32)
  at require_once('/var/www/archipel-staging/vendor/autoload_runtime.php')
     (public/index.php:5)                
[2/3] Exception
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's1_.country' in 'SELECT'

  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/Query/Exec/FinalizedSelectExecutor.php:27)
  at Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute()
     (vendor/doctrine/orm/src/Query.php:296)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/src/AbstractQuery.php:688)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/Repository/IslandRepository.php:60)
  at App\Repository\IslandRepository->findPublicIslands()
     (src/Controller/IslandController.php:39)
  at App\Controller\IslandController->map()
     (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:191)
  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:32)
  at require_once('/var/www/archipel-staging/vendor/autoload_runtime.php')
     (public/index.php:5)                
[1/3] PDOException
PDOException:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 's1_.country' in 'SELECT'

  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/Query/Exec/FinalizedSelectExecutor.php:27)
  at Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute()
     (vendor/doctrine/orm/src/Query.php:296)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/src/AbstractQuery.php:688)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/Repository/IslandRepository.php:60)
  at App\Repository\IslandRepository->findPublicIslands()
     (src/Controller/IslandController.php:39)
  at App\Controller\IslandController->map()
     (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:191)
  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:32)
  at require_once('/var/www/archipel-staging/vendor/autoload_runtime.php')
     (public/index.php:5)