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 ] } }
// We have to match against the SQLSTATE in the error message in these cases.
if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
return new ConnectionException($exception, $query);
}
return new DriverException($exception, $query);
}
}
private function handleDriverException(
Driver\Exception $driverException,
?Query $query
): DriverException {
$this->exceptionConverter ??= $this->_driver->getExceptionConverter();
$exception = $this->exceptionConverter->convert($driverException, $query);
if ($exception instanceof ConnectionLost) {
$this->close();
}
Driver\Exception $e,
string $sql,
array $params = [],
array $types = []
): DriverException {
return $this->handleDriverException($e, new Query($sql, $params, $types));
}
/** @internal */
final public function convertException(Driver\Exception $e): DriverException
{
$result = $connection->query($sql);
}
return new Result($result, $this);
} catch (Driver\Exception $e) {
throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
} finally {
if ($logger !== null) {
$logger->stopQuery();
}
}
*
* @throws Exception
*/
public function fetchAllAssociative(string $query, array $params = [], array $types = []): array
{
return $this->executeQuery($query, $params, $types)->fetchAllAssociative();
}
/**
* Prepares and executes an SQL query and returns the result as an associative array with the keys
* mapped to the first column and the values mapped to the second column.
}
} else {
$value = [];
}
$data = $this->fetchAllAssociative($sql, $params, $types);
$value[$realKey] = $data;
$item->set($value);
array $params = [],
$types = [],
?QueryCacheProfile $qcp = null
): Result {
if ($qcp !== null) {
return $this->executeCacheQuery($sql, $params, $types, $qcp);
}
$connection = $this->getWrappedConnection();
$logger = $this->_config->getSQLLogger();
*
* @return Result
*/
public function execute(Connection $conn, array $params, array $types)
{
return $conn->executeQuery($this->sqlStatements, $params, $types, $this->queryCacheProfile);
}
}
$sqlParams,
$types,
$this->_em->getConnection()->getParams()
);
return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
}
/**
* @param array<string,mixed> $sqlParams
* @param array<string,Type> $types
$setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
$cache->save($cacheItem->set($result + [$realCacheKey => $data]));
};
}
$stmt = $this->_doExecute();
if (is_numeric($stmt)) {
$setCacheEntry($stmt);
return $stmt;
{
if ($this->cacheable && $this->isCacheEnabled()) {
return $this->executeUsingQueryCache($parameters, $hydrationMode);
}
return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
}
/**
* Execute query ignoring second level cache.
*
* @throws NonUniqueResultException If the query result is not unique.
* @throws NoResultException If the query returned no result.
*/
public function getSingleResult($hydrationMode = null)
{
$result = $this->execute(null, $hydrationMode);
if ($this->_hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
throw new NoResultException();
}
* @throws NoResultException If the query returned no result.
* @throws NonUniqueResultException If the query result is not unique.
*/
public function getSingleScalarResult()
{
return $this->getSingleResult(self::HYDRATE_SINGLE_SCALAR);
}
/**
* Sets a query hint. If the hint name is not recognized, it is silently ignored.
*
$query = $qb->getQuery();
$query->useQueryCache(true, 3600*24);
$query->useResultCache(true, 3600*24);
$count = $query->getSingleScalarResult();
return $count;
}
/**
$previousParams['offset'] = 0;
$previous = $this->router->generate('search', $previousParams);
}
$itemCount = $this->getItemCount($owner);
$next = "";
if(($offset + $count) < $itemCount)
{
$nextParams = $params;
$nextParams['offset'] = $offset + $count;
'userPreferencesJSON' => json_encode($userPreferences),
'covers' => $info,
'coversJson' => json_encode($info),
'search' => true,
'searchRoute' => $searchRoute,
'paginator' => $this->itemService->getItemPaginator()
));
}
/**
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
$response = null;
try {
return $response = $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}
$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}
) {
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
if (Kernel::VERSION_ID >= 60400) {
$response->send(false);
if (\function_exists('fastcgi_finish_request') && !$this->debug) {
$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);
$_SERVER['HTTPS'] = 'on';
$_SERVER['SERVER_PORT'] = 443;
}
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};
} else {
$code = $exception->getCode();
$sqlState = null;
}
return new self($exception->getMessage(), $sqlState, $code, $exception);
}
}
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);
}
}
/**
* {@inheritDoc}
*/
public function execute($params = null): Result
{
return $this->wrappedStatement->execute($params);
}
}
'sql' => $this->sql,
'params' => $params ?? $this->params,
'types' => $this->types,
]);
return parent::execute($params);
}
}
/**
* {@inheritDoc}
*/
public function execute($params = null): Result
{
return $this->wrappedStatement->execute($params);
}
}
$this->stopwatch?->start('doctrine', 'doctrine');
$query->start();
try {
return parent::execute($params);
} finally {
$query->stop();
$this->stopwatch?->stop('doctrine');
}
}
$stmt = $connection->prepare($sql);
$this->bindParameters($stmt, $params, $types);
$result = $stmt->execute();
} else {
$result = $connection->query($sql);
}
return new Result($result, $this);
*
* @throws Exception
*/
public function fetchAllAssociative(string $query, array $params = [], array $types = []): array
{
return $this->executeQuery($query, $params, $types)->fetchAllAssociative();
}
/**
* Prepares and executes an SQL query and returns the result as an associative array with the keys
* mapped to the first column and the values mapped to the second column.
}
} else {
$value = [];
}
$data = $this->fetchAllAssociative($sql, $params, $types);
$value[$realKey] = $data;
$item->set($value);
array $params = [],
$types = [],
?QueryCacheProfile $qcp = null
): Result {
if ($qcp !== null) {
return $this->executeCacheQuery($sql, $params, $types, $qcp);
}
$connection = $this->getWrappedConnection();
$logger = $this->_config->getSQLLogger();
*
* @return Result
*/
public function execute(Connection $conn, array $params, array $types)
{
return $conn->executeQuery($this->sqlStatements, $params, $types, $this->queryCacheProfile);
}
}
$sqlParams,
$types,
$this->_em->getConnection()->getParams()
);
return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
}
/**
* @param array<string,mixed> $sqlParams
* @param array<string,Type> $types
$setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
$cache->save($cacheItem->set($result + [$realCacheKey => $data]));
};
}
$stmt = $this->_doExecute();
if (is_numeric($stmt)) {
$setCacheEntry($stmt);
return $stmt;
{
if ($this->cacheable && $this->isCacheEnabled()) {
return $this->executeUsingQueryCache($parameters, $hydrationMode);
}
return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
}
/**
* Execute query ignoring second level cache.
*
* @throws NonUniqueResultException If the query result is not unique.
* @throws NoResultException If the query returned no result.
*/
public function getSingleResult($hydrationMode = null)
{
$result = $this->execute(null, $hydrationMode);
if ($this->_hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
throw new NoResultException();
}
* @throws NoResultException If the query returned no result.
* @throws NonUniqueResultException If the query result is not unique.
*/
public function getSingleScalarResult()
{
return $this->getSingleResult(self::HYDRATE_SINGLE_SCALAR);
}
/**
* Sets a query hint. If the hint name is not recognized, it is silently ignored.
*
$query = $qb->getQuery();
$query->useQueryCache(true, 3600*24);
$query->useResultCache(true, 3600*24);
$count = $query->getSingleScalarResult();
return $count;
}
/**
$previousParams['offset'] = 0;
$previous = $this->router->generate('search', $previousParams);
}
$itemCount = $this->getItemCount($owner);
$next = "";
if(($offset + $count) < $itemCount)
{
$nextParams = $params;
$nextParams['offset'] = $offset + $count;
'userPreferencesJSON' => json_encode($userPreferences),
'covers' => $info,
'coversJson' => json_encode($info),
'search' => true,
'searchRoute' => $searchRoute,
'paginator' => $this->itemService->getItemPaginator()
));
}
/**
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
$response = null;
try {
return $response = $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}
$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}
) {
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
if (Kernel::VERSION_ID >= 60400) {
$response->send(false);
if (\function_exists('fastcgi_finish_request') && !$this->debug) {
$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);
$_SERVER['HTTPS'] = 'on';
$_SERVER['SERVER_PORT'] = 443;
}
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};
. ' Statement::bindParam() or Statement::bindValue() instead.',
);
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);
. ' Statement::bindParam() or Statement::bindValue() instead.',
);
}
try {
$this->stmt->execute($params);
} catch (PDOException $exception) {
throw Exception::new($exception);
}
return new Result($this->stmt);
/**
* {@inheritDoc}
*/
public function execute($params = null): Result
{
return $this->wrappedStatement->execute($params);
}
}
'sql' => $this->sql,
'params' => $params ?? $this->params,
'types' => $this->types,
]);
return parent::execute($params);
}
}
/**
* {@inheritDoc}
*/
public function execute($params = null): Result
{
return $this->wrappedStatement->execute($params);
}
}
$this->stopwatch?->start('doctrine', 'doctrine');
$query->start();
try {
return parent::execute($params);
} finally {
$query->stop();
$this->stopwatch?->stop('doctrine');
}
}
$stmt = $connection->prepare($sql);
$this->bindParameters($stmt, $params, $types);
$result = $stmt->execute();
} else {
$result = $connection->query($sql);
}
return new Result($result, $this);
*
* @throws Exception
*/
public function fetchAllAssociative(string $query, array $params = [], array $types = []): array
{
return $this->executeQuery($query, $params, $types)->fetchAllAssociative();
}
/**
* Prepares and executes an SQL query and returns the result as an associative array with the keys
* mapped to the first column and the values mapped to the second column.
}
} else {
$value = [];
}
$data = $this->fetchAllAssociative($sql, $params, $types);
$value[$realKey] = $data;
$item->set($value);
array $params = [],
$types = [],
?QueryCacheProfile $qcp = null
): Result {
if ($qcp !== null) {
return $this->executeCacheQuery($sql, $params, $types, $qcp);
}
$connection = $this->getWrappedConnection();
$logger = $this->_config->getSQLLogger();
*
* @return Result
*/
public function execute(Connection $conn, array $params, array $types)
{
return $conn->executeQuery($this->sqlStatements, $params, $types, $this->queryCacheProfile);
}
}
$sqlParams,
$types,
$this->_em->getConnection()->getParams()
);
return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
}
/**
* @param array<string,mixed> $sqlParams
* @param array<string,Type> $types
$setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
$cache->save($cacheItem->set($result + [$realCacheKey => $data]));
};
}
$stmt = $this->_doExecute();
if (is_numeric($stmt)) {
$setCacheEntry($stmt);
return $stmt;
{
if ($this->cacheable && $this->isCacheEnabled()) {
return $this->executeUsingQueryCache($parameters, $hydrationMode);
}
return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
}
/**
* Execute query ignoring second level cache.
*
* @throws NonUniqueResultException If the query result is not unique.
* @throws NoResultException If the query returned no result.
*/
public function getSingleResult($hydrationMode = null)
{
$result = $this->execute(null, $hydrationMode);
if ($this->_hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
throw new NoResultException();
}
* @throws NoResultException If the query returned no result.
* @throws NonUniqueResultException If the query result is not unique.
*/
public function getSingleScalarResult()
{
return $this->getSingleResult(self::HYDRATE_SINGLE_SCALAR);
}
/**
* Sets a query hint. If the hint name is not recognized, it is silently ignored.
*
$query = $qb->getQuery();
$query->useQueryCache(true, 3600*24);
$query->useResultCache(true, 3600*24);
$count = $query->getSingleScalarResult();
return $count;
}
/**
$previousParams['offset'] = 0;
$previous = $this->router->generate('search', $previousParams);
}
$itemCount = $this->getItemCount($owner);
$next = "";
if(($offset + $count) < $itemCount)
{
$nextParams = $params;
$nextParams['offset'] = $offset + $count;
'userPreferencesJSON' => json_encode($userPreferences),
'covers' => $info,
'coversJson' => json_encode($info),
'search' => true,
'searchRoute' => $searchRoute,
'paginator' => $this->itemService->getItemPaginator()
));
}
/**
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = $controller(...$arguments);
// view
if (!$response instanceof Response) {
$event = new ViewEvent($this, $request, $type, $response, $event);
$this->dispatcher->dispatch($event, KernelEvents::VIEW);
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
$this->requestStack->push($request);
$response = null;
try {
return $response = $this->handleRaw($request, $type);
} catch (\Throwable $e) {
if ($e instanceof \Error && !$this->handleAllThrowables) {
throw $e;
}
$this->boot();
++$this->requestStackSize;
$this->resetServices = true;
try {
return $this->getHttpKernel()->handle($request, $type, $catch);
} finally {
--$this->requestStackSize;
}
}
) {
}
public function run(): int
{
$response = $this->kernel->handle($this->request);
if (Kernel::VERSION_ID >= 60400) {
$response->send(false);
if (\function_exists('fastcgi_finish_request') && !$this->debug) {
$app = $app(...$args);
exit(
$runtime
->getRunner($app)
->run()
);
$_SERVER['HTTPS'] = 'on';
$_SERVER['SERVER_PORT'] = 443;
}
}
require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
return function (array $context) {
return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
};
[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) |