https://www.riders.pkchallenge.bzh/sections/31&filters=all

Method
GET
HTTP Status
500
IP
47.79.6.191
Profiled on
Token
58da1c

Exceptions

PDOException Exception InvalidFieldNameException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.time' in 'field list'

  • Exceptions 3
  • Logs
  • Stack Traces 3

Doctrine\DBAL\Exception\ InvalidFieldNameException

in vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php (line 67)
  1.                 return new UniqueConstraintViolationException($exception, $query);
  3.             case 1054:
  4.             case 1166:
  5.             case 1611:
  6.                 return new InvalidFieldNameException($exception, $query);
  8.             case 1052:
  9.             case 1060:
  10.             case 1110:
  11.                 return new NonUniqueFieldNameException($exception, $query);
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1931)
  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);
  8.         if ($exception instanceof ConnectionLost) {
  9.             $this->close();
  10.         }
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.     }
  9.     /** @internal */
  10.     final public function convertException(Driver\Exception $e): DriverException
  11.     {
in vendor/doctrine/dbal/src/Connection.php -> convertExceptionDuringQuery (line 1099)
  1.                 $result = $connection->query($sql);
  2.             }
  4.             return new Result($result, $this);
  5.         } catch (Driver\Exception $e) {
  6.             throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
  7.         } finally {
  8.             if ($logger !== null) {
  9.                 $logger->stopQuery();
  10.             }
  11.         }
in vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php -> executeQuery (line 916)
  1.     {
  2.         $this->switchPersisterContext($offset, $limit);
  4.         $sql              = $this->getSelectSQL($criteria, null, null, $limit, $offset, $orderBy);
  5.         [$params, $types] = $this->expandParameters($criteria);
  6.         $stmt             = $this->conn->executeQuery($sql, $params, $types);
  8.         $hydrator = $this->em->newHydrator($this->currentPersisterContext->selectJoinSql ? Query::HYDRATE_OBJECT : Query::HYDRATE_SIMPLEOBJECT);
  10.         return $hydrator->hydrateAll($stmt, $this->currentPersisterContext->rsm, [UnitOfWork::HINT_DEFEREAGERLOAD => true]);
  11.     }
in vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php -> loadAll (line 225)
  1.      */
  2.     public function findBy(array $criteria, ?array $orderBy = null, $limit = null, $offset = null)
  3.     {
  4.         $persister = $this->_em->getUnitOfWork()->getEntityPersister($this->_entityName);
  6.         return $persister->loadAll($criteria, $orderBy, $limit, $offset);
  7.     }
  9.     /**
  10.      * Finds a single entity by a set of criteria.
  11.      *
EntityRepository->findBy(array('Piste' => object(Piste)), array('time' => 'ASC')) in src/Controller/PistesController.php (line 55)
  1.         if ($filters == "all") {
  2.             return $this->render('pistes/show.html.twig', [
  3.                 'controller_name' => 'PistesController',
  4.                 'Pistes' => $this->pisteRepository->findOneBy(['id' => $id]),
  5.                 'Sponsors' => $this->sponsorsRepository->findAll(),
  6.                 'Classement' => $this->timePistesRepository->findBy(['Piste' => $this->pisteRepository->findOneBy(['id' => $id])], ['time' => 'ASC']),
  7.                 'pistesForBase' => $this->pisteRepository->findAll(),
  8.             ]);
  9.         } else {
  10.             $support = $this->supportRepository->findOneBy(['name' => $filters]);
  11.             return $this->render('pistes/show.html.twig', [
in vendor/symfony/http-kernel/HttpKernel.php -> show (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/home/lesenfanhi/www/riders/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.time' in 'field list'

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)
  1.         } else {
  2.             $code     = $exception->getCode();
  3.             $sqlState = null;
  4.         }
  6.         return new self($exception->getMessage(), $sqlState, $code, $exception);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 123)
  1.         }
  3.         try {
  4.             $this->stmt->execute($params);
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  9.         return new Result($this->stmt);
  10.     }
  11. }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 69)
  1.     /**
  2.      * {@inheritdoc}
  3.      */
  4.     public function execute($params = null): Result
  5.     {
  6.         return $this->wrappedStatement->execute($params);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Logging/Statement.php -> execute (line 98)
  1.             'sql'    => $this->sql,
  2.             'params' => $params ?? $this->params,
  3.             'types'  => $this->types,
  4.         ]);
  6.         return parent::execute($params);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 69)
  1.     /**
  2.      * {@inheritdoc}
  3.      */
  4.     public function execute($params = null): Result
  5.     {
  6.         return $this->wrappedStatement->execute($params);
  7.     }
  8. }
in vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php -> execute (line 65)
  1.         $this->debugDataHolder->addQuery($this->connectionName, $query = clone $this->query);
  3.         $query->start();
  5.         try {
  6.             $result = parent::execute($params);
  7.         } finally {
  8.             $query->stop();
  9.         }
  11.         return $result;
in vendor/doctrine/dbal/src/Connection.php -> execute (line 1092)
  2.                 $stmt = $connection->prepare($sql);
  4.                 $this->bindParameters($stmt, $params, $types);
  6.                 $result = $stmt->execute();
  7.             } else {
  8.                 $result = $connection->query($sql);
  9.             }
  11.             return new Result($result, $this);
in vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php -> executeQuery (line 916)
  1.     {
  2.         $this->switchPersisterContext($offset, $limit);
  4.         $sql              = $this->getSelectSQL($criteria, null, null, $limit, $offset, $orderBy);
  5.         [$params, $types] = $this->expandParameters($criteria);
  6.         $stmt             = $this->conn->executeQuery($sql, $params, $types);
  8.         $hydrator = $this->em->newHydrator($this->currentPersisterContext->selectJoinSql ? Query::HYDRATE_OBJECT : Query::HYDRATE_SIMPLEOBJECT);
  10.         return $hydrator->hydrateAll($stmt, $this->currentPersisterContext->rsm, [UnitOfWork::HINT_DEFEREAGERLOAD => true]);
  11.     }
in vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php -> loadAll (line 225)
  1.      */
  2.     public function findBy(array $criteria, ?array $orderBy = null, $limit = null, $offset = null)
  3.     {
  4.         $persister = $this->_em->getUnitOfWork()->getEntityPersister($this->_entityName);
  6.         return $persister->loadAll($criteria, $orderBy, $limit, $offset);
  7.     }
  9.     /**
  10.      * Finds a single entity by a set of criteria.
  11.      *
EntityRepository->findBy(array('Piste' => object(Piste)), array('time' => 'ASC')) in src/Controller/PistesController.php (line 55)
  1.         if ($filters == "all") {
  2.             return $this->render('pistes/show.html.twig', [
  3.                 'controller_name' => 'PistesController',
  4.                 'Pistes' => $this->pisteRepository->findOneBy(['id' => $id]),
  5.                 'Sponsors' => $this->sponsorsRepository->findAll(),
  6.                 'Classement' => $this->timePistesRepository->findBy(['Piste' => $this->pisteRepository->findOneBy(['id' => $id])], ['time' => 'ASC']),
  7.                 'pistesForBase' => $this->pisteRepository->findAll(),
  8.             ]);
  9.         } else {
  10.             $support = $this->supportRepository->findOneBy(['name' => $filters]);
  11.             return $this->render('pistes/show.html.twig', [
in vendor/symfony/http-kernel/HttpKernel.php -> show (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/home/lesenfanhi/www/riders/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

PDOException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.time' in 'field list'

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 121)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 121)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 69)
  1.     /**
  2.      * {@inheritdoc}
  3.      */
  4.     public function execute($params = null): Result
  5.     {
  6.         return $this->wrappedStatement->execute($params);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Logging/Statement.php -> execute (line 98)
  1.             'sql'    => $this->sql,
  2.             'params' => $params ?? $this->params,
  3.             'types'  => $this->types,
  4.         ]);
  6.         return parent::execute($params);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 69)
  1.     /**
  2.      * {@inheritdoc}
  3.      */
  4.     public function execute($params = null): Result
  5.     {
  6.         return $this->wrappedStatement->execute($params);
  7.     }
  8. }
in vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php -> execute (line 65)
  1.         $this->debugDataHolder->addQuery($this->connectionName, $query = clone $this->query);
  3.         $query->start();
  5.         try {
  6.             $result = parent::execute($params);
  7.         } finally {
  8.             $query->stop();
  9.         }
  11.         return $result;
in vendor/doctrine/dbal/src/Connection.php -> execute (line 1092)
  2.                 $stmt = $connection->prepare($sql);
  4.                 $this->bindParameters($stmt, $params, $types);
  6.                 $result = $stmt->execute();
  7.             } else {
  8.                 $result = $connection->query($sql);
  9.             }
  11.             return new Result($result, $this);
in vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php -> executeQuery (line 916)
  1.     {
  2.         $this->switchPersisterContext($offset, $limit);
  4.         $sql              = $this->getSelectSQL($criteria, null, null, $limit, $offset, $orderBy);
  5.         [$params, $types] = $this->expandParameters($criteria);
  6.         $stmt             = $this->conn->executeQuery($sql, $params, $types);
  8.         $hydrator = $this->em->newHydrator($this->currentPersisterContext->selectJoinSql ? Query::HYDRATE_OBJECT : Query::HYDRATE_SIMPLEOBJECT);
  10.         return $hydrator->hydrateAll($stmt, $this->currentPersisterContext->rsm, [UnitOfWork::HINT_DEFEREAGERLOAD => true]);
  11.     }
in vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php -> loadAll (line 225)
  1.      */
  2.     public function findBy(array $criteria, ?array $orderBy = null, $limit = null, $offset = null)
  3.     {
  4.         $persister = $this->_em->getUnitOfWork()->getEntityPersister($this->_entityName);
  6.         return $persister->loadAll($criteria, $orderBy, $limit, $offset);
  7.     }
  9.     /**
  10.      * Finds a single entity by a set of criteria.
  11.      *
EntityRepository->findBy(array('Piste' => object(Piste)), array('time' => 'ASC')) in src/Controller/PistesController.php (line 55)
  1.         if ($filters == "all") {
  2.             return $this->render('pistes/show.html.twig', [
  3.                 'controller_name' => 'PistesController',
  4.                 'Pistes' => $this->pisteRepository->findOneBy(['id' => $id]),
  5.                 'Sponsors' => $this->sponsorsRepository->findAll(),
  6.                 'Classement' => $this->timePistesRepository->findBy(['Piste' => $this->pisteRepository->findOneBy(['id' => $id])], ['time' => 'ASC']),
  7.                 'pistesForBase' => $this->pisteRepository->findAll(),
  8.             ]);
  9.         } else {
  10.             $support = $this->supportRepository->findOneBy(['name' => $filters]);
  11.             return $this->render('pistes/show.html.twig', [
in vendor/symfony/http-kernel/HttpKernel.php -> show (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/home/lesenfanhi/www/riders/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };