Symfony Exception

PDOException Exception DriverException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: "en"
CONTEXT: unnamed portal parameter $2 = '...'

Exceptions 3

Doctrine\DBAL\Exception\ DriverException

Show exception properties
Doctrine\DBAL\Exception\DriverException {#10362
  -query: Doctrine\DBAL\Query {#10364
    -sql: "SELECT COUNT('p.id') AS sclr_0 FROM rs_item r0_ LEFT JOIN rs_location r1_ ON r0_.location = r1_.id INNER JOIN rs_size r2_ ON (r0_.size = r2_.id) WHERE r0_.category IN (?) AND r0_.owner = ? AND r2_.maxvisitors >= ? AND r0_.published = ? AND (r0_.id NOT IN (SELECT DISTINCT (r3_.item) FROM rs_reservation r3_, rs_item r4_ WHERE (r3_.starttime > ? OR r3_.endtime > ?) AND (r3_.starttime < ? OR r3_.endtime < ?) AND r3_.status NOT IN (?, ?) AND r4_.id = r3_.item AND r4_.exclusive = true))"
    -params: array:10 [
      0 => "item"
      1 => "en"
      2 => "1"
      3 => true
      4 => "2024-03-28T16:43:29+00:00"
      5 => "2024-03-28T16:43:29+00:00"
      6 => "2024-03-29T16:43:29+00:00"
      7 => "2024-03-29T16:43:29+00:00"
      8 => "removed"
      9 => "cancelled"
    ]
    -types: array:10 [
      0 => 2
      1 => 2
      2 => 2
      3 => "boolean"
      4 => 2
      5 => 2
      6 => 2
      7 => 2
      8 => 2
      9 => 2
    ]
  }
}
  1.         // We have to match against the SQLSTATE in the error message in these cases.
  2.         if ($exception->getCode() === && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
  3.             return new ConnectionException($exception$query);
  4.         }
  5.         return new DriverException($exception$query);
  6.     }
  7. }
  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 1885)
  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 1106)
  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.         }
in vendor/doctrine/dbal/src/Connection.php -> executeQuery (line 902)
  1.      *
  2.      * @throws Exception
  3.      */
  4.     public function fetchAllAssociative(string $query, array $params = [], array $types = []): array
  5.     {
  6.         return $this->executeQuery($query$params$types)->fetchAllAssociative();
  7.     }
  8.     /**
  9.      * Prepares and executes an SQL query and returns the result as an associative array with the keys
  10.      * mapped to the first column and the values mapped to the second column.
in vendor/doctrine/dbal/src/Connection.php -> fetchAllAssociative (line 1152)
  1.             }
  2.         } else {
  3.             $value = [];
  4.         }
  5.         $data $this->fetchAllAssociative($sql$params$types);
  6.         $value[$realKey] = $data;
  7.         $item->set($value);
in vendor/doctrine/dbal/src/Connection.php -> executeCacheQuery (line 1079)
  1.         array $params = [],
  2.         $types = [],
  3.         ?QueryCacheProfile $qcp null
  4.     ): Result {
  5.         if ($qcp !== null) {
  6.             return $this->executeCacheQuery($sql$params$types$qcp);
  7.         }
  8.         $connection $this->getWrappedConnection();
  9.         $logger $this->_config->getSQLLogger();
  1.      *
  2.      * @return Result
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types)
  5.     {
  6.         return $conn->executeQuery($this->sqlStatements$params$types$this->queryCacheProfile);
  7.     }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 327)
  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
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 1212)
  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 1166)
  1.     {
  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.      * @throws NonUniqueResultException If the query result is not unique.
  2.      * @throws NoResultException        If the query returned no result.
  3.      */
  4.     public function getSingleResult($hydrationMode null)
  5.     {
  6.         $result $this->execute(null$hydrationMode);
  7.         if ($this->_hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
  8.             throw new NoResultException();
  9.         }
in vendor/doctrine/orm/src/AbstractQuery.php -> getSingleResult (line 1020)
  1.      * @throws NoResultException        If the query returned no result.
  2.      * @throws NonUniqueResultException If the query result is not unique.
  3.      */
  4.     public function getSingleScalarResult()
  5.     {
  6.         return $this->getSingleResult(self::HYDRATE_SINGLE_SCALAR);
  7.     }
  8.     /**
  9.      * Sets a query hint. If the hint name is not recognized, it is silently ignored.
  10.      *
AbstractQuery->getSingleScalarResult() in src/Service/ItemService.php (line 563)
  1.         $query $qb->getQuery();
  2.         $query->useQueryCache(true3600*24);
  3.         $query->useResultCache(true3600*24);
  4.         $count $query->getSingleScalarResult();
  5.         return $count;
  6.     }
  7.     /**
ItemService->getItemCount('en') in src/Service/ItemService.php (line 616)
  1.                 $previousParams['offset'] = 0;
  2.             $previous $this->router->generate('search'$previousParams);
  3.         }
  4.         $itemCount $this->getItemCount($owner);
  5.         $next "";
  6.         if(($offset $count) < $itemCount)
  7.         {
  8.             $nextParams $params;
  9.             $nextParams['offset'] = $offset $count;
ItemService->getItemPaginator() in src/Controller/ItemController.php (line 452)
  1.             'userPreferencesJSON' => json_encode($userPreferences),
  2.             'covers'              => $info,
  3.             'coversJson'          => json_encode($info),
  4.             'search'              => true,
  5.             'searchRoute'         => $searchRoute,
  6.             'paginator'           => $this->itemService->getItemPaginator()
  7.         ));
  8.     }
  9.     /**
  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$event);
  9.             $this->dispatcher->dispatch($eventKernelEvents::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.         $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.     }
  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 29)
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/app/vendor/autoload_runtime.php') in public/index.php (line 13)
  1.         $_SERVER['HTTPS'] = 'on';
  2.         $_SERVER['SERVER_PORT'] = 443;
  3.     }
  4. }
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  6. return function (array $context) {
  7.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  8. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: "en" CONTEXT: unnamed portal parameter $2 = '...'

  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.     }
  9. }
  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->stopwatch?->start('doctrine''doctrine');
  2.         $query->start();
  3.         try {
  4.             return parent::execute($params);
  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);
in vendor/doctrine/dbal/src/Connection.php -> executeQuery (line 902)
  1.      *
  2.      * @throws Exception
  3.      */
  4.     public function fetchAllAssociative(string $query, array $params = [], array $types = []): array
  5.     {
  6.         return $this->executeQuery($query$params$types)->fetchAllAssociative();
  7.     }
  8.     /**
  9.      * Prepares and executes an SQL query and returns the result as an associative array with the keys
  10.      * mapped to the first column and the values mapped to the second column.
in vendor/doctrine/dbal/src/Connection.php -> fetchAllAssociative (line 1152)
  1.             }
  2.         } else {
  3.             $value = [];
  4.         }
  5.         $data $this->fetchAllAssociative($sql$params$types);
  6.         $value[$realKey] = $data;
  7.         $item->set($value);
in vendor/doctrine/dbal/src/Connection.php -> executeCacheQuery (line 1079)
  1.         array $params = [],
  2.         $types = [],
  3.         ?QueryCacheProfile $qcp null
  4.     ): Result {
  5.         if ($qcp !== null) {
  6.             return $this->executeCacheQuery($sql$params$types$qcp);
  7.         }
  8.         $connection $this->getWrappedConnection();
  9.         $logger $this->_config->getSQLLogger();
  1.      *
  2.      * @return Result
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types)
  5.     {
  6.         return $conn->executeQuery($this->sqlStatements$params$types$this->queryCacheProfile);
  7.     }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 327)
  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
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 1212)
  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 1166)
  1.     {
  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.      * @throws NonUniqueResultException If the query result is not unique.
  2.      * @throws NoResultException        If the query returned no result.
  3.      */
  4.     public function getSingleResult($hydrationMode null)
  5.     {
  6.         $result $this->execute(null$hydrationMode);
  7.         if ($this->_hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
  8.             throw new NoResultException();
  9.         }
in vendor/doctrine/orm/src/AbstractQuery.php -> getSingleResult (line 1020)
  1.      * @throws NoResultException        If the query returned no result.
  2.      * @throws NonUniqueResultException If the query result is not unique.
  3.      */
  4.     public function getSingleScalarResult()
  5.     {
  6.         return $this->getSingleResult(self::HYDRATE_SINGLE_SCALAR);
  7.     }
  8.     /**
  9.      * Sets a query hint. If the hint name is not recognized, it is silently ignored.
  10.      *
AbstractQuery->getSingleScalarResult() in src/Service/ItemService.php (line 563)
  1.         $query $qb->getQuery();
  2.         $query->useQueryCache(true3600*24);
  3.         $query->useResultCache(true3600*24);
  4.         $count $query->getSingleScalarResult();
  5.         return $count;
  6.     }
  7.     /**
ItemService->getItemCount('en') in src/Service/ItemService.php (line 616)
  1.                 $previousParams['offset'] = 0;
  2.             $previous $this->router->generate('search'$previousParams);
  3.         }
  4.         $itemCount $this->getItemCount($owner);
  5.         $next "";
  6.         if(($offset $count) < $itemCount)
  7.         {
  8.             $nextParams $params;
  9.             $nextParams['offset'] = $offset $count;
ItemService->getItemPaginator() in src/Controller/ItemController.php (line 452)
  1.             'userPreferencesJSON' => json_encode($userPreferences),
  2.             'covers'              => $info,
  3.             'coversJson'          => json_encode($info),
  4.             'search'              => true,
  5.             'searchRoute'         => $searchRoute,
  6.             'paginator'           => $this->itemService->getItemPaginator()
  7.         ));
  8.     }
  9.     /**
  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$event);
  9.             $this->dispatcher->dispatch($eventKernelEvents::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.         $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.     }
  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 29)
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/app/vendor/autoload_runtime.php') in public/index.php (line 13)
  1.         $_SERVER['HTTPS'] = 'on';
  2.         $_SERVER['SERVER_PORT'] = 443;
  3.     }
  4. }
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  6. return function (array $context) {
  7.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  8. };

PDOException

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: "en" CONTEXT: unnamed portal parameter $2 = '...'

  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->stopwatch?->start('doctrine''doctrine');
  2.         $query->start();
  3.         try {
  4.             return parent::execute($params);
  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);
in vendor/doctrine/dbal/src/Connection.php -> executeQuery (line 902)
  1.      *
  2.      * @throws Exception
  3.      */
  4.     public function fetchAllAssociative(string $query, array $params = [], array $types = []): array
  5.     {
  6.         return $this->executeQuery($query$params$types)->fetchAllAssociative();
  7.     }
  8.     /**
  9.      * Prepares and executes an SQL query and returns the result as an associative array with the keys
  10.      * mapped to the first column and the values mapped to the second column.
in vendor/doctrine/dbal/src/Connection.php -> fetchAllAssociative (line 1152)
  1.             }
  2.         } else {
  3.             $value = [];
  4.         }
  5.         $data $this->fetchAllAssociative($sql$params$types);
  6.         $value[$realKey] = $data;
  7.         $item->set($value);
in vendor/doctrine/dbal/src/Connection.php -> executeCacheQuery (line 1079)
  1.         array $params = [],
  2.         $types = [],
  3.         ?QueryCacheProfile $qcp null
  4.     ): Result {
  5.         if ($qcp !== null) {
  6.             return $this->executeCacheQuery($sql$params$types$qcp);
  7.         }
  8.         $connection $this->getWrappedConnection();
  9.         $logger $this->_config->getSQLLogger();
  1.      *
  2.      * @return Result
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types)
  5.     {
  6.         return $conn->executeQuery($this->sqlStatements$params$types$this->queryCacheProfile);
  7.     }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 327)
  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
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 1212)
  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 1166)
  1.     {
  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.      * @throws NonUniqueResultException If the query result is not unique.
  2.      * @throws NoResultException        If the query returned no result.
  3.      */
  4.     public function getSingleResult($hydrationMode null)
  5.     {
  6.         $result $this->execute(null$hydrationMode);
  7.         if ($this->_hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
  8.             throw new NoResultException();
  9.         }
in vendor/doctrine/orm/src/AbstractQuery.php -> getSingleResult (line 1020)
  1.      * @throws NoResultException        If the query returned no result.
  2.      * @throws NonUniqueResultException If the query result is not unique.
  3.      */
  4.     public function getSingleScalarResult()
  5.     {
  6.         return $this->getSingleResult(self::HYDRATE_SINGLE_SCALAR);
  7.     }
  8.     /**
  9.      * Sets a query hint. If the hint name is not recognized, it is silently ignored.
  10.      *
AbstractQuery->getSingleScalarResult() in src/Service/ItemService.php (line 563)
  1.         $query $qb->getQuery();
  2.         $query->useQueryCache(true3600*24);
  3.         $query->useResultCache(true3600*24);
  4.         $count $query->getSingleScalarResult();
  5.         return $count;
  6.     }
  7.     /**
ItemService->getItemCount('en') in src/Service/ItemService.php (line 616)
  1.                 $previousParams['offset'] = 0;
  2.             $previous $this->router->generate('search'$previousParams);
  3.         }
  4.         $itemCount $this->getItemCount($owner);
  5.         $next "";
  6.         if(($offset $count) < $itemCount)
  7.         {
  8.             $nextParams $params;
  9.             $nextParams['offset'] = $offset $count;
ItemService->getItemPaginator() in src/Controller/ItemController.php (line 452)
  1.             'userPreferencesJSON' => json_encode($userPreferences),
  2.             'covers'              => $info,
  3.             'coversJson'          => json_encode($info),
  4.             'search'              => true,
  5.             'searchRoute'         => $searchRoute,
  6.             'paginator'           => $this->itemService->getItemPaginator()
  7.         ));
  8.     }
  9.     /**
  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$event);
  9.             $this->dispatcher->dispatch($eventKernelEvents::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.         $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.     }
  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 29)
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/app/vendor/autoload_runtime.php') in public/index.php (line 13)
  1.         $_SERVER['HTTPS'] = 'on';
  2.         $_SERVER['SERVER_PORT'] = 443;
  3.     }
  4. }
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  6. return function (array $context) {
  7.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  8. };

Stack Traces 3

[3/3] DriverException
Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: "en"
CONTEXT:  unnamed portal parameter $2 = '...'

  at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87
  at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1943)
  at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1885)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), 'SELECT COUNT(\'p.id\') AS sclr_0 FROM rs_item r0_ LEFT JOIN rs_location r1_ ON r0_.location = r1_.id INNER JOIN rs_size r2_ ON (r0_.size = r2_.id) WHERE r0_.category IN (?) AND r0_.owner = ? AND r2_.maxvisitors >= ? AND r0_.published = ? AND (r0_.id NOT IN (SELECT DISTINCT (r3_.item) FROM rs_reservation r3_, rs_item r4_ WHERE (r3_.starttime > ? OR r3_.endtime > ?) AND (r3_.starttime < ? OR r3_.endtime < ?) AND r3_.status NOT IN (?, ?) AND r4_.id = r3_.item AND r4_.exclusive = true))', array('item', 'en', '1', true, '2024-03-28T16:43:29+00:00', '2024-03-28T16:43:29+00:00', '2024-03-29T16:43:29+00:00', '2024-03-29T16:43:29+00:00', 'removed', 'cancelled'), array(2, 2, 2, 'boolean', 2, 2, 2, 2, 2, 2))
     (vendor/doctrine/dbal/src/Connection.php:1106)
  at Doctrine\DBAL\Connection->executeQuery('SELECT COUNT(\'p.id\') AS sclr_0 FROM rs_item r0_ LEFT JOIN rs_location r1_ ON r0_.location = r1_.id INNER JOIN rs_size r2_ ON (r0_.size = r2_.id) WHERE r0_.category IN (?) AND r0_.owner = ? AND r2_.maxvisitors >= ? AND r0_.published = ? AND (r0_.id NOT IN (SELECT DISTINCT (r3_.item) FROM rs_reservation r3_, rs_item r4_ WHERE (r3_.starttime > ? OR r3_.endtime > ?) AND (r3_.starttime < ? OR r3_.endtime < ?) AND r3_.status NOT IN (?, ?) AND r4_.id = r3_.item AND r4_.exclusive = true))', array('item', 'en', '1', true, '2024-03-28T16:43:29+00:00', '2024-03-28T16:43:29+00:00', '2024-03-29T16:43:29+00:00', '2024-03-29T16:43:29+00:00', 'removed', 'cancelled'), array(2, 2, 2, 'boolean', 2, 2, 2, 2, 2, 2))
     (vendor/doctrine/dbal/src/Connection.php:902)
  at Doctrine\DBAL\Connection->fetchAllAssociative('SELECT COUNT(\'p.id\') AS sclr_0 FROM rs_item r0_ LEFT JOIN rs_location r1_ ON r0_.location = r1_.id INNER JOIN rs_size r2_ ON (r0_.size = r2_.id) WHERE r0_.category IN (?) AND r0_.owner = ? AND r2_.maxvisitors >= ? AND r0_.published = ? AND (r0_.id NOT IN (SELECT DISTINCT (r3_.item) FROM rs_reservation r3_, rs_item r4_ WHERE (r3_.starttime > ? OR r3_.endtime > ?) AND (r3_.starttime < ? OR r3_.endtime < ?) AND r3_.status NOT IN (?) AND r4_.id = r3_.item AND r4_.exclusive = true))', array('item', 'en', '1', true, '2024-03-28T16:43:29+00:00', '2024-03-28T16:43:29+00:00', '2024-03-29T16:43:29+00:00', '2024-03-29T16:43:29+00:00', array('removed', 'cancelled')), array(2, 2, 2, 'boolean', 2, 2, 2, 2, 102))
     (vendor/doctrine/dbal/src/Connection.php:1152)
  at Doctrine\DBAL\Connection->executeCacheQuery('SELECT COUNT(\'p.id\') AS sclr_0 FROM rs_item r0_ LEFT JOIN rs_location r1_ ON r0_.location = r1_.id INNER JOIN rs_size r2_ ON (r0_.size = r2_.id) WHERE r0_.category IN (?) AND r0_.owner = ? AND r2_.maxvisitors >= ? AND r0_.published = ? AND (r0_.id NOT IN (SELECT DISTINCT (r3_.item) FROM rs_reservation r3_, rs_item r4_ WHERE (r3_.starttime > ? OR r3_.endtime > ?) AND (r3_.starttime < ? OR r3_.endtime < ?) AND r3_.status NOT IN (?) AND r4_.id = r3_.item AND r4_.exclusive = true))', array('item', 'en', '1', true, '2024-03-28T16:43:29+00:00', '2024-03-28T16:43:29+00:00', '2024-03-29T16:43:29+00:00', '2024-03-29T16:43:29+00:00', array('removed', 'cancelled')), array(2, 2, 2, 'boolean', 2, 2, 2, 2, 102), object(QueryCacheProfile))
     (vendor/doctrine/dbal/src/Connection.php:1079)
  at Doctrine\DBAL\Connection->executeQuery('SELECT COUNT(\'p.id\') AS sclr_0 FROM rs_item r0_ LEFT JOIN rs_location r1_ ON r0_.location = r1_.id INNER JOIN rs_size r2_ ON (r0_.size = r2_.id) WHERE r0_.category IN (?) AND r0_.owner = ? AND r2_.maxvisitors >= ? AND r0_.published = ? AND (r0_.id NOT IN (SELECT DISTINCT (r3_.item) FROM rs_reservation r3_, rs_item r4_ WHERE (r3_.starttime > ? OR r3_.endtime > ?) AND (r3_.starttime < ? OR r3_.endtime < ?) AND r3_.status NOT IN (?) AND r4_.id = r3_.item AND r4_.exclusive = true))', array('item', 'en', '1', true, '2024-03-28T16:43:29+00:00', '2024-03-28T16:43:29+00:00', '2024-03-29T16:43:29+00:00', '2024-03-29T16:43:29+00:00', array('removed', 'cancelled')), array(2, 2, 2, 'boolean', 2, 2, 2, 2, 102), object(QueryCacheProfile))
     (vendor/doctrine/orm/src/Query/Exec/SingleSelectExecutor.php:33)
  at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(object(Connection), array('item', 'en', '1', true, '2024-03-28T16:43:29+00:00', '2024-03-28T16:43:29+00:00', '2024-03-29T16:43:29+00:00', '2024-03-29T16:43:29+00:00', array('removed', 'cancelled')), array(2, 2, 2, 'boolean', 2, 2, 2, 2, 102))
     (vendor/doctrine/orm/src/Query.php:327)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:1212)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 4)
     (vendor/doctrine/orm/src/AbstractQuery.php:1166)
  at Doctrine\ORM\AbstractQuery->execute(null, 4)
     (vendor/doctrine/orm/src/AbstractQuery.php:991)
  at Doctrine\ORM\AbstractQuery->getSingleResult(4)
     (vendor/doctrine/orm/src/AbstractQuery.php:1020)
  at Doctrine\ORM\AbstractQuery->getSingleScalarResult()
     (src/Service/ItemService.php:563)
  at App\Service\ItemService->getItemCount('en')
     (src/Service/ItemService.php:616)
  at App\Service\ItemService->getItemPaginator()
     (src/Controller/ItemController.php:452)
  at App\Controller\ItemController->search(object(Request), '-1', '-1', '-1', '-1', '-1', '10', '10')
     (vendor/symfony/http-kernel/HttpKernel.php:181)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:197)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/app/vendor/autoload_runtime.php')
     (public/index.php:13)                
[2/3] Exception
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: "en"
CONTEXT:  unnamed portal parameter $2 = '...'

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
  at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException))
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:132)
  at Doctrine\DBAL\Driver\PDO\Statement->execute(null)
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute(null)
     (vendor/doctrine/dbal/src/Logging/Statement.php:98)
  at Doctrine\DBAL\Logging\Statement->execute(null)
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute(null)
     (vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Statement.php:70)
  at Symfony\Bridge\Doctrine\Middleware\Debug\DBAL3\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:1099)
  at Doctrine\DBAL\Connection->executeQuery('SELECT COUNT(\'p.id\') AS sclr_0 FROM rs_item r0_ LEFT JOIN rs_location r1_ ON r0_.location = r1_.id INNER JOIN rs_size r2_ ON (r0_.size = r2_.id) WHERE r0_.category IN (?) AND r0_.owner = ? AND r2_.maxvisitors >= ? AND r0_.published = ? AND (r0_.id NOT IN (SELECT DISTINCT (r3_.item) FROM rs_reservation r3_, rs_item r4_ WHERE (r3_.starttime > ? OR r3_.endtime > ?) AND (r3_.starttime < ? OR r3_.endtime < ?) AND r3_.status NOT IN (?, ?) AND r4_.id = r3_.item AND r4_.exclusive = true))', array('item', 'en', '1', true, '2024-03-28T16:43:29+00:00', '2024-03-28T16:43:29+00:00', '2024-03-29T16:43:29+00:00', '2024-03-29T16:43:29+00:00', 'removed', 'cancelled'), array(2, 2, 2, 'boolean', 2, 2, 2, 2, 2, 2))
     (vendor/doctrine/dbal/src/Connection.php:902)
  at Doctrine\DBAL\Connection->fetchAllAssociative('SELECT COUNT(\'p.id\') AS sclr_0 FROM rs_item r0_ LEFT JOIN rs_location r1_ ON r0_.location = r1_.id INNER JOIN rs_size r2_ ON (r0_.size = r2_.id) WHERE r0_.category IN (?) AND r0_.owner = ? AND r2_.maxvisitors >= ? AND r0_.published = ? AND (r0_.id NOT IN (SELECT DISTINCT (r3_.item) FROM rs_reservation r3_, rs_item r4_ WHERE (r3_.starttime > ? OR r3_.endtime > ?) AND (r3_.starttime < ? OR r3_.endtime < ?) AND r3_.status NOT IN (?) AND r4_.id = r3_.item AND r4_.exclusive = true))', array('item', 'en', '1', true, '2024-03-28T16:43:29+00:00', '2024-03-28T16:43:29+00:00', '2024-03-29T16:43:29+00:00', '2024-03-29T16:43:29+00:00', array('removed', 'cancelled')), array(2, 2, 2, 'boolean', 2, 2, 2, 2, 102))
     (vendor/doctrine/dbal/src/Connection.php:1152)
  at Doctrine\DBAL\Connection->executeCacheQuery('SELECT COUNT(\'p.id\') AS sclr_0 FROM rs_item r0_ LEFT JOIN rs_location r1_ ON r0_.location = r1_.id INNER JOIN rs_size r2_ ON (r0_.size = r2_.id) WHERE r0_.category IN (?) AND r0_.owner = ? AND r2_.maxvisitors >= ? AND r0_.published = ? AND (r0_.id NOT IN (SELECT DISTINCT (r3_.item) FROM rs_reservation r3_, rs_item r4_ WHERE (r3_.starttime > ? OR r3_.endtime > ?) AND (r3_.starttime < ? OR r3_.endtime < ?) AND r3_.status NOT IN (?) AND r4_.id = r3_.item AND r4_.exclusive = true))', array('item', 'en', '1', true, '2024-03-28T16:43:29+00:00', '2024-03-28T16:43:29+00:00', '2024-03-29T16:43:29+00:00', '2024-03-29T16:43:29+00:00', array('removed', 'cancelled')), array(2, 2, 2, 'boolean', 2, 2, 2, 2, 102), object(QueryCacheProfile))
     (vendor/doctrine/dbal/src/Connection.php:1079)
  at Doctrine\DBAL\Connection->executeQuery('SELECT COUNT(\'p.id\') AS sclr_0 FROM rs_item r0_ LEFT JOIN rs_location r1_ ON r0_.location = r1_.id INNER JOIN rs_size r2_ ON (r0_.size = r2_.id) WHERE r0_.category IN (?) AND r0_.owner = ? AND r2_.maxvisitors >= ? AND r0_.published = ? AND (r0_.id NOT IN (SELECT DISTINCT (r3_.item) FROM rs_reservation r3_, rs_item r4_ WHERE (r3_.starttime > ? OR r3_.endtime > ?) AND (r3_.starttime < ? OR r3_.endtime < ?) AND r3_.status NOT IN (?) AND r4_.id = r3_.item AND r4_.exclusive = true))', array('item', 'en', '1', true, '2024-03-28T16:43:29+00:00', '2024-03-28T16:43:29+00:00', '2024-03-29T16:43:29+00:00', '2024-03-29T16:43:29+00:00', array('removed', 'cancelled')), array(2, 2, 2, 'boolean', 2, 2, 2, 2, 102), object(QueryCacheProfile))
     (vendor/doctrine/orm/src/Query/Exec/SingleSelectExecutor.php:33)
  at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(object(Connection), array('item', 'en', '1', true, '2024-03-28T16:43:29+00:00', '2024-03-28T16:43:29+00:00', '2024-03-29T16:43:29+00:00', '2024-03-29T16:43:29+00:00', array('removed', 'cancelled')), array(2, 2, 2, 'boolean', 2, 2, 2, 2, 102))
     (vendor/doctrine/orm/src/Query.php:327)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:1212)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 4)
     (vendor/doctrine/orm/src/AbstractQuery.php:1166)
  at Doctrine\ORM\AbstractQuery->execute(null, 4)
     (vendor/doctrine/orm/src/AbstractQuery.php:991)
  at Doctrine\ORM\AbstractQuery->getSingleResult(4)
     (vendor/doctrine/orm/src/AbstractQuery.php:1020)
  at Doctrine\ORM\AbstractQuery->getSingleScalarResult()
     (src/Service/ItemService.php:563)
  at App\Service\ItemService->getItemCount('en')
     (src/Service/ItemService.php:616)
  at App\Service\ItemService->getItemPaginator()
     (src/Controller/ItemController.php:452)
  at App\Controller\ItemController->search(object(Request), '-1', '-1', '-1', '-1', '-1', '10', '10')
     (vendor/symfony/http-kernel/HttpKernel.php:181)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:197)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/app/vendor/autoload_runtime.php')
     (public/index.php:13)                
[1/3] PDOException
PDOException:
SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: "en"
CONTEXT:  unnamed portal parameter $2 = '...'

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130
  at PDOStatement->execute(null)
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)
  at Doctrine\DBAL\Driver\PDO\Statement->execute(null)
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute(null)
     (vendor/doctrine/dbal/src/Logging/Statement.php:98)
  at Doctrine\DBAL\Logging\Statement->execute(null)
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute(null)
     (vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Statement.php:70)
  at Symfony\Bridge\Doctrine\Middleware\Debug\DBAL3\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:1099)
  at Doctrine\DBAL\Connection->executeQuery('SELECT COUNT(\'p.id\') AS sclr_0 FROM rs_item r0_ LEFT JOIN rs_location r1_ ON r0_.location = r1_.id INNER JOIN rs_size r2_ ON (r0_.size = r2_.id) WHERE r0_.category IN (?) AND r0_.owner = ? AND r2_.maxvisitors >= ? AND r0_.published = ? AND (r0_.id NOT IN (SELECT DISTINCT (r3_.item) FROM rs_reservation r3_, rs_item r4_ WHERE (r3_.starttime > ? OR r3_.endtime > ?) AND (r3_.starttime < ? OR r3_.endtime < ?) AND r3_.status NOT IN (?, ?) AND r4_.id = r3_.item AND r4_.exclusive = true))', array('item', 'en', '1', true, '2024-03-28T16:43:29+00:00', '2024-03-28T16:43:29+00:00', '2024-03-29T16:43:29+00:00', '2024-03-29T16:43:29+00:00', 'removed', 'cancelled'), array(2, 2, 2, 'boolean', 2, 2, 2, 2, 2, 2))
     (vendor/doctrine/dbal/src/Connection.php:902)
  at Doctrine\DBAL\Connection->fetchAllAssociative('SELECT COUNT(\'p.id\') AS sclr_0 FROM rs_item r0_ LEFT JOIN rs_location r1_ ON r0_.location = r1_.id INNER JOIN rs_size r2_ ON (r0_.size = r2_.id) WHERE r0_.category IN (?) AND r0_.owner = ? AND r2_.maxvisitors >= ? AND r0_.published = ? AND (r0_.id NOT IN (SELECT DISTINCT (r3_.item) FROM rs_reservation r3_, rs_item r4_ WHERE (r3_.starttime > ? OR r3_.endtime > ?) AND (r3_.starttime < ? OR r3_.endtime < ?) AND r3_.status NOT IN (?) AND r4_.id = r3_.item AND r4_.exclusive = true))', array('item', 'en', '1', true, '2024-03-28T16:43:29+00:00', '2024-03-28T16:43:29+00:00', '2024-03-29T16:43:29+00:00', '2024-03-29T16:43:29+00:00', array('removed', 'cancelled')), array(2, 2, 2, 'boolean', 2, 2, 2, 2, 102))
     (vendor/doctrine/dbal/src/Connection.php:1152)
  at Doctrine\DBAL\Connection->executeCacheQuery('SELECT COUNT(\'p.id\') AS sclr_0 FROM rs_item r0_ LEFT JOIN rs_location r1_ ON r0_.location = r1_.id INNER JOIN rs_size r2_ ON (r0_.size = r2_.id) WHERE r0_.category IN (?) AND r0_.owner = ? AND r2_.maxvisitors >= ? AND r0_.published = ? AND (r0_.id NOT IN (SELECT DISTINCT (r3_.item) FROM rs_reservation r3_, rs_item r4_ WHERE (r3_.starttime > ? OR r3_.endtime > ?) AND (r3_.starttime < ? OR r3_.endtime < ?) AND r3_.status NOT IN (?) AND r4_.id = r3_.item AND r4_.exclusive = true))', array('item', 'en', '1', true, '2024-03-28T16:43:29+00:00', '2024-03-28T16:43:29+00:00', '2024-03-29T16:43:29+00:00', '2024-03-29T16:43:29+00:00', array('removed', 'cancelled')), array(2, 2, 2, 'boolean', 2, 2, 2, 2, 102), object(QueryCacheProfile))
     (vendor/doctrine/dbal/src/Connection.php:1079)
  at Doctrine\DBAL\Connection->executeQuery('SELECT COUNT(\'p.id\') AS sclr_0 FROM rs_item r0_ LEFT JOIN rs_location r1_ ON r0_.location = r1_.id INNER JOIN rs_size r2_ ON (r0_.size = r2_.id) WHERE r0_.category IN (?) AND r0_.owner = ? AND r2_.maxvisitors >= ? AND r0_.published = ? AND (r0_.id NOT IN (SELECT DISTINCT (r3_.item) FROM rs_reservation r3_, rs_item r4_ WHERE (r3_.starttime > ? OR r3_.endtime > ?) AND (r3_.starttime < ? OR r3_.endtime < ?) AND r3_.status NOT IN (?) AND r4_.id = r3_.item AND r4_.exclusive = true))', array('item', 'en', '1', true, '2024-03-28T16:43:29+00:00', '2024-03-28T16:43:29+00:00', '2024-03-29T16:43:29+00:00', '2024-03-29T16:43:29+00:00', array('removed', 'cancelled')), array(2, 2, 2, 'boolean', 2, 2, 2, 2, 102), object(QueryCacheProfile))
     (vendor/doctrine/orm/src/Query/Exec/SingleSelectExecutor.php:33)
  at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(object(Connection), array('item', 'en', '1', true, '2024-03-28T16:43:29+00:00', '2024-03-28T16:43:29+00:00', '2024-03-29T16:43:29+00:00', '2024-03-29T16:43:29+00:00', array('removed', 'cancelled')), array(2, 2, 2, 'boolean', 2, 2, 2, 2, 102))
     (vendor/doctrine/orm/src/Query.php:327)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:1212)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 4)
     (vendor/doctrine/orm/src/AbstractQuery.php:1166)
  at Doctrine\ORM\AbstractQuery->execute(null, 4)
     (vendor/doctrine/orm/src/AbstractQuery.php:991)
  at Doctrine\ORM\AbstractQuery->getSingleResult(4)
     (vendor/doctrine/orm/src/AbstractQuery.php:1020)
  at Doctrine\ORM\AbstractQuery->getSingleScalarResult()
     (src/Service/ItemService.php:563)
  at App\Service\ItemService->getItemCount('en')
     (src/Service/ItemService.php:616)
  at App\Service\ItemService->getItemPaginator()
     (src/Controller/ItemController.php:452)
  at App\Controller\ItemController->search(object(Request), '-1', '-1', '-1', '-1', '-1', '10', '10')
     (vendor/symfony/http-kernel/HttpKernel.php:181)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:197)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/app/vendor/autoload_runtime.php')
     (public/index.php:13)