Error 500 Internal Server Error

GET http://skolkakrupa.cz/news/vanocni-prani

Forwarded to ErrorController (b0da40)

Exceptions

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

  • Exceptions 3
  • Logs
  • Stack Traces 3

Doctrine\DBAL\Exception\ DriverException

  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 1874)
  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 1099)
  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.         }
  1.     {
  2.         $this->switchPersisterContext(null$limit);
  3.         $sql              $this->getSelectSQL($criteria$assoc$lockMode$limitnull$orderBy);
  4.         [$params$types] = $this->expandParameters($criteria);
  5.         $stmt             $this->conn->executeQuery($sql$params$types);
  6.         if ($entity !== null) {
  7.             $hints[Query::HINT_REFRESH]        = true;
  8.             $hints[Query::HINT_REFRESH_ENTITY] = $entity;
  9.         }
  1.     /**
  2.      * {@inheritdoc}
  3.      */
  4.     public function loadById(array $identifier$entity null)
  5.     {
  6.         return $this->load($identifier$entity);
  7.     }
  8.     /**
  9.      * {@inheritdoc}
  10.      */
  1.             case $lockMode === LockMode::PESSIMISTIC_READ:
  2.             case $lockMode === LockMode::PESSIMISTIC_WRITE:
  3.                 return $persister->load($sortedIdnullnull, [], $lockMode);
  4.             default:
  5.                 return $persister->loadById($sortedId);
  6.         }
  7.     }
  8.     /**
  9.      * {@inheritDoc}
  1.      * @return object|null The entity instance or NULL if the entity can not be found.
  2.      * @psalm-return ?T
  3.      */
  4.     public function find($id$lockMode null$lockVersion null)
  5.     {
  6.         return $this->_em->find($this->_entityName$id$lockMode$lockVersion);
  7.     }
  8.     /**
  9.      * Finds all entities in the repository.
  10.      *
  1.                 $cacheProvider->evictEntity($class$id);
  2.             }
  3.         }
  4.         try {
  5.             return $om->getRepository($class)->$method($id);
  6.         } catch (NoResultException $e) {
  7.             return;
  8.         } catch (ConversionException $e) {
  9.             return;
  10.         }
  1.             if (null === $object) {
  2.                 $errorMessage sprintf('The expression "%s" returned null'$expr);
  3.             }
  4.             // find by identifier?
  5.         } elseif (false === $object $this->find($class$request$options$name)) {
  6.             // find by criteria
  7.             if (false === $object $this->findOneBy($class$request$options)) {
  8.                 if ($configuration->isOptional()) {
  9.                     $object null;
  10.                 } else {
  1.             return;
  2.         }
  3.         foreach ($this->all() as $converter) {
  4.             if ($converter->supports($configuration)) {
  5.                 if ($converter->apply($request$configuration)) {
  6.                     return;
  7.                 }
  8.             }
  9.         }
  10.     }
  1.         if (\is_object($configurations)) {
  2.             $configurations = [$configurations];
  3.         }
  4.         foreach ($configurations as $configuration) {
  5.             $this->applyConverter($request$configuration);
  6.         }
  7.     }
  8.     /**
  9.      * Applies converter on request based on the given configuration.
  1.             }
  2.             $configurations $this->autoConfigure($r$request$configurations);
  3.         }
  4.         $this->manager->apply($request$configurations);
  5.     }
  6.     private function autoConfigure(\ReflectionFunctionAbstract $rRequest $request$configurations)
  7.     {
  8.         foreach ($r->getParameters() as $param) {
  1.         $this->called true;
  2.         $this->priority ??= $dispatcher->getListenerPriority($eventName$this->listener);
  3.         $e $this->stopwatch->start($this->name'event_listener');
  4.         ($this->optimizedListener ?? $this->listener)($event$eventName$dispatcher);
  5.         if ($e->isStarted()) {
  6.             $e->stop();
  7.         }
  1.         foreach ($listeners as $listener) {
  2.             if ($stoppable && $event->isPropagationStopped()) {
  3.                 break;
  4.             }
  5.             $listener($event$eventName$this);
  6.         }
  7.     }
  8.     /**
  9.      * Sorts the internal list of listeners for the given event by priority.
  1.         } else {
  2.             $listeners $this->getListeners($eventName);
  3.         }
  4.         if ($listeners) {
  5.             $this->callListeners($listeners$eventName$event);
  6.         }
  7.         return $event;
  8.     }
  1.         try {
  2.             $this->beforeDispatch($eventName$event);
  3.             try {
  4.                 $e $this->stopwatch->start($eventName'section');
  5.                 try {
  6.                     $this->dispatcher->dispatch($event$eventName);
  7.                 } finally {
  8.                     if ($e->isStarted()) {
  9.                         $e->stop();
  10.                     }
  11.                 }
  1.         if (false === $controller $this->resolver->getController($request)) {
  2.             throw new NotFoundHttpException(sprintf('Unable to find the controller for path "%s". The route is wrongly configured.'$request->getPathInfo()));
  3.         }
  4.         $event = new ControllerEvent($this$controller$request$type);
  5.         $this->dispatcher->dispatch($eventKernelEvents::CONTROLLER);
  6.         $controller $event->getController();
  7.         // controller arguments
  8.         $arguments $this->argumentResolver->getArguments($request$controller$event->getControllerReflector());
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $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.         $this->request $request;
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         $response->send();
  7.         if ($this->kernel instanceof TerminableInterface) {
  8.             $this->kernel->terminate($this->request$response);
  9.         }
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 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[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: "vanocni-prani" CONTEXT: unnamed portal parameter $1 = '...'

  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->debugDataHolder->addQuery($this->connectionName$query = clone $this->query);
  2.         $query->start();
  3.         try {
  4.             $result parent::execute($params);
  5.         } finally {
  6.             $query->stop();
  7.         }
  8.         return $result;
  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.         $this->switchPersisterContext(null$limit);
  3.         $sql              $this->getSelectSQL($criteria$assoc$lockMode$limitnull$orderBy);
  4.         [$params$types] = $this->expandParameters($criteria);
  5.         $stmt             $this->conn->executeQuery($sql$params$types);
  6.         if ($entity !== null) {
  7.             $hints[Query::HINT_REFRESH]        = true;
  8.             $hints[Query::HINT_REFRESH_ENTITY] = $entity;
  9.         }
  1.     /**
  2.      * {@inheritdoc}
  3.      */
  4.     public function loadById(array $identifier$entity null)
  5.     {
  6.         return $this->load($identifier$entity);
  7.     }
  8.     /**
  9.      * {@inheritdoc}
  10.      */
  1.             case $lockMode === LockMode::PESSIMISTIC_READ:
  2.             case $lockMode === LockMode::PESSIMISTIC_WRITE:
  3.                 return $persister->load($sortedIdnullnull, [], $lockMode);
  4.             default:
  5.                 return $persister->loadById($sortedId);
  6.         }
  7.     }
  8.     /**
  9.      * {@inheritDoc}
  1.      * @return object|null The entity instance or NULL if the entity can not be found.
  2.      * @psalm-return ?T
  3.      */
  4.     public function find($id$lockMode null$lockVersion null)
  5.     {
  6.         return $this->_em->find($this->_entityName$id$lockMode$lockVersion);
  7.     }
  8.     /**
  9.      * Finds all entities in the repository.
  10.      *
  1.                 $cacheProvider->evictEntity($class$id);
  2.             }
  3.         }
  4.         try {
  5.             return $om->getRepository($class)->$method($id);
  6.         } catch (NoResultException $e) {
  7.             return;
  8.         } catch (ConversionException $e) {
  9.             return;
  10.         }
  1.             if (null === $object) {
  2.                 $errorMessage sprintf('The expression "%s" returned null'$expr);
  3.             }
  4.             // find by identifier?
  5.         } elseif (false === $object $this->find($class$request$options$name)) {
  6.             // find by criteria
  7.             if (false === $object $this->findOneBy($class$request$options)) {
  8.                 if ($configuration->isOptional()) {
  9.                     $object null;
  10.                 } else {
  1.             return;
  2.         }
  3.         foreach ($this->all() as $converter) {
  4.             if ($converter->supports($configuration)) {
  5.                 if ($converter->apply($request$configuration)) {
  6.                     return;
  7.                 }
  8.             }
  9.         }
  10.     }
  1.         if (\is_object($configurations)) {
  2.             $configurations = [$configurations];
  3.         }
  4.         foreach ($configurations as $configuration) {
  5.             $this->applyConverter($request$configuration);
  6.         }
  7.     }
  8.     /**
  9.      * Applies converter on request based on the given configuration.
  1.             }
  2.             $configurations $this->autoConfigure($r$request$configurations);
  3.         }
  4.         $this->manager->apply($request$configurations);
  5.     }
  6.     private function autoConfigure(\ReflectionFunctionAbstract $rRequest $request$configurations)
  7.     {
  8.         foreach ($r->getParameters() as $param) {
  1.         $this->called true;
  2.         $this->priority ??= $dispatcher->getListenerPriority($eventName$this->listener);
  3.         $e $this->stopwatch->start($this->name'event_listener');
  4.         ($this->optimizedListener ?? $this->listener)($event$eventName$dispatcher);
  5.         if ($e->isStarted()) {
  6.             $e->stop();
  7.         }
  1.         foreach ($listeners as $listener) {
  2.             if ($stoppable && $event->isPropagationStopped()) {
  3.                 break;
  4.             }
  5.             $listener($event$eventName$this);
  6.         }
  7.     }
  8.     /**
  9.      * Sorts the internal list of listeners for the given event by priority.
  1.         } else {
  2.             $listeners $this->getListeners($eventName);
  3.         }
  4.         if ($listeners) {
  5.             $this->callListeners($listeners$eventName$event);
  6.         }
  7.         return $event;
  8.     }
  1.         try {
  2.             $this->beforeDispatch($eventName$event);
  3.             try {
  4.                 $e $this->stopwatch->start($eventName'section');
  5.                 try {
  6.                     $this->dispatcher->dispatch($event$eventName);
  7.                 } finally {
  8.                     if ($e->isStarted()) {
  9.                         $e->stop();
  10.                     }
  11.                 }
  1.         if (false === $controller $this->resolver->getController($request)) {
  2.             throw new NotFoundHttpException(sprintf('Unable to find the controller for path "%s". The route is wrongly configured.'$request->getPathInfo()));
  3.         }
  4.         $event = new ControllerEvent($this$controller$request$type);
  5.         $this->dispatcher->dispatch($eventKernelEvents::CONTROLLER);
  6.         $controller $event->getController();
  7.         // controller arguments
  8.         $arguments $this->argumentResolver->getArguments($request$controller$event->getControllerReflector());
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $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.         $this->request $request;
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         $response->send();
  7.         if ($this->kernel instanceof TerminableInterface) {
  8.             $this->kernel->terminate($this->request$response);
  9.         }
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 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[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: "vanocni-prani" CONTEXT: unnamed portal parameter $1 = '...'

  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->debugDataHolder->addQuery($this->connectionName$query = clone $this->query);
  2.         $query->start();
  3.         try {
  4.             $result parent::execute($params);
  5.         } finally {
  6.             $query->stop();
  7.         }
  8.         return $result;
  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.         $this->switchPersisterContext(null$limit);
  3.         $sql              $this->getSelectSQL($criteria$assoc$lockMode$limitnull$orderBy);
  4.         [$params$types] = $this->expandParameters($criteria);
  5.         $stmt             $this->conn->executeQuery($sql$params$types);
  6.         if ($entity !== null) {
  7.             $hints[Query::HINT_REFRESH]        = true;
  8.             $hints[Query::HINT_REFRESH_ENTITY] = $entity;
  9.         }
  1.     /**
  2.      * {@inheritdoc}
  3.      */
  4.     public function loadById(array $identifier$entity null)
  5.     {
  6.         return $this->load($identifier$entity);
  7.     }
  8.     /**
  9.      * {@inheritdoc}
  10.      */
  1.             case $lockMode === LockMode::PESSIMISTIC_READ:
  2.             case $lockMode === LockMode::PESSIMISTIC_WRITE:
  3.                 return $persister->load($sortedIdnullnull, [], $lockMode);
  4.             default:
  5.                 return $persister->loadById($sortedId);
  6.         }
  7.     }
  8.     /**
  9.      * {@inheritDoc}
  1.      * @return object|null The entity instance or NULL if the entity can not be found.
  2.      * @psalm-return ?T
  3.      */
  4.     public function find($id$lockMode null$lockVersion null)
  5.     {
  6.         return $this->_em->find($this->_entityName$id$lockMode$lockVersion);
  7.     }
  8.     /**
  9.      * Finds all entities in the repository.
  10.      *
  1.                 $cacheProvider->evictEntity($class$id);
  2.             }
  3.         }
  4.         try {
  5.             return $om->getRepository($class)->$method($id);
  6.         } catch (NoResultException $e) {
  7.             return;
  8.         } catch (ConversionException $e) {
  9.             return;
  10.         }
  1.             if (null === $object) {
  2.                 $errorMessage sprintf('The expression "%s" returned null'$expr);
  3.             }
  4.             // find by identifier?
  5.         } elseif (false === $object $this->find($class$request$options$name)) {
  6.             // find by criteria
  7.             if (false === $object $this->findOneBy($class$request$options)) {
  8.                 if ($configuration->isOptional()) {
  9.                     $object null;
  10.                 } else {
  1.             return;
  2.         }
  3.         foreach ($this->all() as $converter) {
  4.             if ($converter->supports($configuration)) {
  5.                 if ($converter->apply($request$configuration)) {
  6.                     return;
  7.                 }
  8.             }
  9.         }
  10.     }
  1.         if (\is_object($configurations)) {
  2.             $configurations = [$configurations];
  3.         }
  4.         foreach ($configurations as $configuration) {
  5.             $this->applyConverter($request$configuration);
  6.         }
  7.     }
  8.     /**
  9.      * Applies converter on request based on the given configuration.
  1.             }
  2.             $configurations $this->autoConfigure($r$request$configurations);
  3.         }
  4.         $this->manager->apply($request$configurations);
  5.     }
  6.     private function autoConfigure(\ReflectionFunctionAbstract $rRequest $request$configurations)
  7.     {
  8.         foreach ($r->getParameters() as $param) {
  1.         $this->called true;
  2.         $this->priority ??= $dispatcher->getListenerPriority($eventName$this->listener);
  3.         $e $this->stopwatch->start($this->name'event_listener');
  4.         ($this->optimizedListener ?? $this->listener)($event$eventName$dispatcher);
  5.         if ($e->isStarted()) {
  6.             $e->stop();
  7.         }
  1.         foreach ($listeners as $listener) {
  2.             if ($stoppable && $event->isPropagationStopped()) {
  3.                 break;
  4.             }
  5.             $listener($event$eventName$this);
  6.         }
  7.     }
  8.     /**
  9.      * Sorts the internal list of listeners for the given event by priority.
  1.         } else {
  2.             $listeners $this->getListeners($eventName);
  3.         }
  4.         if ($listeners) {
  5.             $this->callListeners($listeners$eventName$event);
  6.         }
  7.         return $event;
  8.     }
  1.         try {
  2.             $this->beforeDispatch($eventName$event);
  3.             try {
  4.                 $e $this->stopwatch->start($eventName'section');
  5.                 try {
  6.                     $this->dispatcher->dispatch($event$eventName);
  7.                 } finally {
  8.                     if ($e->isStarted()) {
  9.                         $e->stop();
  10.                     }
  11.                 }
  1.         if (false === $controller $this->resolver->getController($request)) {
  2.             throw new NotFoundHttpException(sprintf('Unable to find the controller for path "%s". The route is wrongly configured.'$request->getPathInfo()));
  3.         }
  4.         $event = new ControllerEvent($this$controller$request$type);
  5.         $this->dispatcher->dispatch($eventKernelEvents::CONTROLLER);
  6.         $controller $event->getController();
  7.         // controller arguments
  8.         $arguments $this->argumentResolver->getArguments($request$controller$event->getControllerReflector());
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $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.         $this->request $request;
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         $response->send();
  7.         if ($this->kernel instanceof TerminableInterface) {
  8.             $this->kernel->terminate($this->request$response);
  9.         }
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 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. };