Exceptions
Exceptions 3
Doctrine\DBAL\Exception\ TableNotFoundException
Show exception properties
Doctrine\DBAL\Exception\TableNotFoundException {#817 -query: Doctrine\DBAL\Query {#815 -sql: "SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5" -params: [] -types: [] } }
1008 => new DatabaseDoesNotExist($exception, $query),1213 => new DeadlockException($exception, $query),1205 => new LockWaitTimeoutException($exception, $query),1050 => new TableExistsException($exception, $query),1051,1146 => new TableNotFoundException($exception, $query),1216,1217,1451,1452,1701 => new ForeignKeyConstraintViolationException($exception, $query),
in
vendor/doctrine/dbal/src/Connection.php
->
convert
(line 1460)
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();}
in
vendor/doctrine/dbal/src/Connection.php
->
handleDriverException
(line 1396)
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{
in
vendor/doctrine/dbal/src/Connection.php
->
convertExceptionDuringQuery
(line 809)
$result = $connection->query($sql);}return new Result($result, $this);} catch (Driver\Exception $e) {throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);}}/*** Executes a caching query.
in
vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php
->
executeQuery
(line 963)
): array {$this->switchPersisterContext($offset, $limit);$sql = $this->getSelectSQL($criteria, null, null, $limit, $offset, $orderBy);[$params, $types] = $this->expandParameters($criteria);$stmt = $this->conn->executeQuery($sql, $params, $types);$hydrator = $this->em->newHydrator($this->currentPersisterContext->selectJoinSql ? Query::HYDRATE_OBJECT : Query::HYDRATE_SIMPLEOBJECT);return $hydrator->hydrateAll($stmt, $this->currentPersisterContext->rsm, [UnitOfWork::HINT_DEFEREAGERLOAD => true]);}
in
vendor/doctrine/orm/src/EntityRepository.php
->
loadAll
(line 110)
*/public function findBy(array $criteria, array|null $orderBy = null, int|null $limit = null, int|null $offset = null): array{$persister = $this->em->getUnitOfWork()->getEntityPersister($this->entityName);return $persister->loadAll($criteria, $orderBy, $limit, $offset);}/*** Finds a single entity by a set of criteria.*
in
vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php
->
findBy
(line 73)
* @psalm-suppress InvalidReturnType This proxy is used only in combination with newer parent class*/public function findBy(array $criteria, array|null $orderBy = null, int|null $limit = null, int|null $offset = null): array{return ($this->repository ??= $this->resolveRepository())->findBy($criteria, $orderBy, $limit, $offset);}/** {@inheritDoc} */public function findOneBy(array $criteria, array|null $orderBy = null): object|null{
ServiceEntityRepositoryProxy->findBy(array(), array('id' => 'DESC'), 5)
in
src/Controller/HomeController.php
(line 16)
{#[Route('/', name: 'app_home')]public function index(JobOfferRepository $jobOfferRepository): Response{// On récupère les 5 dernières annonces postées$latestJobs = $jobOfferRepository->findBy([], ['id' => 'DESC'], 5);return $this->render('home/index.html.twig', ['latestJobs' => $latestJobs]);}
in
vendor/symfony/http-kernel/HttpKernel.php
->
index
(line 183)
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);$controller = $event->getController();$arguments = $event->getArguments();// call controller$response = $controller(...$arguments);// viewif (!$response instanceof Response) {$event = new ViewEvent($this, $request, $type, $response, $event);$this->dispatcher->dispatch($event, KernelEvents::VIEW);
in
vendor/symfony/http-kernel/HttpKernel.php
->
handleRaw
(line 76)
$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;}
in
vendor/symfony/http-kernel/Kernel.php
->
handle
(line 193)
if (!$this->handlingHttpCache) {$this->resetServices = true;}try {return $this->getHttpKernel()->handle($request, $type, $catch);} finally {--$this->requestStackSize;}}
in
vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php
->
handle
(line 35)
) {}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) {
in
vendor/autoload_runtime.php
->
run
(line 32)
$app = $app(...$args);exit($runtime->getRunner($app)->run());
<?phpuse App\Kernel;require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return function (array $context) {return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);};
Doctrine\DBAL\Driver\PDO\ Exception
in
vendor/doctrine/dbal/src/Driver/PDO/Exception.php
(line 24)
} else {$code = $exception->getCode();$sqlState = null;}return new self($exception->getMessage(), $sqlState, $code, $exception);}}
in
vendor/doctrine/dbal/src/Driver/PDO/Connection.php
::
new
(line 62)
$stmt = $this->connection->query($sql);assert($stmt instanceof PDOStatement);return new Result($stmt);} catch (PDOException $exception) {throw Exception::new($exception);}}public function quote(string $value): string{
in
vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php
->
query
(line 24)
return $this->wrappedConnection->prepare($sql);}public function query(string $sql): Result{return $this->wrappedConnection->query($sql);}public function quote(string $value): string{return $this->wrappedConnection->quote($value);
in
vendor/doctrine/dbal/src/Logging/Connection.php
->
query
(line 39)
public function query(string $sql): Result{$this->logger->debug('Executing query: {sql}', ['sql' => $sql]);return parent::query($sql);}public function exec(string $sql): int|string{$this->logger->debug('Executing statement: {sql}', ['sql' => $sql]);
in
vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php
->
query
(line 24)
return $this->wrappedConnection->prepare($sql);}public function query(string $sql): Result{return $this->wrappedConnection->query($sql);}public function quote(string $value): string{return $this->wrappedConnection->quote($value);
in
vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php
->
query
(line 55)
$this->stopwatch?->start('doctrine', 'doctrine');$query->start();try {return parent::query($sql);} finally {$query->stop();$this->stopwatch?->stop('doctrine');}}
in
vendor/doctrine/dbal/src/Connection.php
->
query
(line 804)
$this->bindParameters($stmt, $params, $types);$result = $stmt->execute();} else {$result = $connection->query($sql);}return new Result($result, $this);} catch (Driver\Exception $e) {throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
in
vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php
->
executeQuery
(line 963)
): array {$this->switchPersisterContext($offset, $limit);$sql = $this->getSelectSQL($criteria, null, null, $limit, $offset, $orderBy);[$params, $types] = $this->expandParameters($criteria);$stmt = $this->conn->executeQuery($sql, $params, $types);$hydrator = $this->em->newHydrator($this->currentPersisterContext->selectJoinSql ? Query::HYDRATE_OBJECT : Query::HYDRATE_SIMPLEOBJECT);return $hydrator->hydrateAll($stmt, $this->currentPersisterContext->rsm, [UnitOfWork::HINT_DEFEREAGERLOAD => true]);}
in
vendor/doctrine/orm/src/EntityRepository.php
->
loadAll
(line 110)
*/public function findBy(array $criteria, array|null $orderBy = null, int|null $limit = null, int|null $offset = null): array{$persister = $this->em->getUnitOfWork()->getEntityPersister($this->entityName);return $persister->loadAll($criteria, $orderBy, $limit, $offset);}/*** Finds a single entity by a set of criteria.*
in
vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php
->
findBy
(line 73)
* @psalm-suppress InvalidReturnType This proxy is used only in combination with newer parent class*/public function findBy(array $criteria, array|null $orderBy = null, int|null $limit = null, int|null $offset = null): array{return ($this->repository ??= $this->resolveRepository())->findBy($criteria, $orderBy, $limit, $offset);}/** {@inheritDoc} */public function findOneBy(array $criteria, array|null $orderBy = null): object|null{
ServiceEntityRepositoryProxy->findBy(array(), array('id' => 'DESC'), 5)
in
src/Controller/HomeController.php
(line 16)
{#[Route('/', name: 'app_home')]public function index(JobOfferRepository $jobOfferRepository): Response{// On récupère les 5 dernières annonces postées$latestJobs = $jobOfferRepository->findBy([], ['id' => 'DESC'], 5);return $this->render('home/index.html.twig', ['latestJobs' => $latestJobs]);}
in
vendor/symfony/http-kernel/HttpKernel.php
->
index
(line 183)
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);$controller = $event->getController();$arguments = $event->getArguments();// call controller$response = $controller(...$arguments);// viewif (!$response instanceof Response) {$event = new ViewEvent($this, $request, $type, $response, $event);$this->dispatcher->dispatch($event, KernelEvents::VIEW);
in
vendor/symfony/http-kernel/HttpKernel.php
->
handleRaw
(line 76)
$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;}
in
vendor/symfony/http-kernel/Kernel.php
->
handle
(line 193)
if (!$this->handlingHttpCache) {$this->resetServices = true;}try {return $this->getHttpKernel()->handle($request, $type, $catch);} finally {--$this->requestStackSize;}}
in
vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php
->
handle
(line 35)
) {}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) {
in
vendor/autoload_runtime.php
->
run
(line 32)
$app = $app(...$args);exit($runtime->getRunner($app)->run());
<?phpuse App\Kernel;require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return function (array $context) {return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);};
PDOException
in
vendor/doctrine/dbal/src/Driver/PDO/Connection.php
(line 57)
}public function query(string $sql): Result{try {$stmt = $this->connection->query($sql);assert($stmt instanceof PDOStatement);return new Result($stmt);} catch (PDOException $exception) {throw Exception::new($exception);
in
vendor/doctrine/dbal/src/Driver/PDO/Connection.php
->
query
(line 57)
}public function query(string $sql): Result{try {$stmt = $this->connection->query($sql);assert($stmt instanceof PDOStatement);return new Result($stmt);} catch (PDOException $exception) {throw Exception::new($exception);
in
vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php
->
query
(line 24)
return $this->wrappedConnection->prepare($sql);}public function query(string $sql): Result{return $this->wrappedConnection->query($sql);}public function quote(string $value): string{return $this->wrappedConnection->quote($value);
in
vendor/doctrine/dbal/src/Logging/Connection.php
->
query
(line 39)
public function query(string $sql): Result{$this->logger->debug('Executing query: {sql}', ['sql' => $sql]);return parent::query($sql);}public function exec(string $sql): int|string{$this->logger->debug('Executing statement: {sql}', ['sql' => $sql]);
in
vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php
->
query
(line 24)
return $this->wrappedConnection->prepare($sql);}public function query(string $sql): Result{return $this->wrappedConnection->query($sql);}public function quote(string $value): string{return $this->wrappedConnection->quote($value);
in
vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php
->
query
(line 55)
$this->stopwatch?->start('doctrine', 'doctrine');$query->start();try {return parent::query($sql);} finally {$query->stop();$this->stopwatch?->stop('doctrine');}}
in
vendor/doctrine/dbal/src/Connection.php
->
query
(line 804)
$this->bindParameters($stmt, $params, $types);$result = $stmt->execute();} else {$result = $connection->query($sql);}return new Result($result, $this);} catch (Driver\Exception $e) {throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
in
vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php
->
executeQuery
(line 963)
): array {$this->switchPersisterContext($offset, $limit);$sql = $this->getSelectSQL($criteria, null, null, $limit, $offset, $orderBy);[$params, $types] = $this->expandParameters($criteria);$stmt = $this->conn->executeQuery($sql, $params, $types);$hydrator = $this->em->newHydrator($this->currentPersisterContext->selectJoinSql ? Query::HYDRATE_OBJECT : Query::HYDRATE_SIMPLEOBJECT);return $hydrator->hydrateAll($stmt, $this->currentPersisterContext->rsm, [UnitOfWork::HINT_DEFEREAGERLOAD => true]);}
in
vendor/doctrine/orm/src/EntityRepository.php
->
loadAll
(line 110)
*/public function findBy(array $criteria, array|null $orderBy = null, int|null $limit = null, int|null $offset = null): array{$persister = $this->em->getUnitOfWork()->getEntityPersister($this->entityName);return $persister->loadAll($criteria, $orderBy, $limit, $offset);}/*** Finds a single entity by a set of criteria.*
in
vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php
->
findBy
(line 73)
* @psalm-suppress InvalidReturnType This proxy is used only in combination with newer parent class*/public function findBy(array $criteria, array|null $orderBy = null, int|null $limit = null, int|null $offset = null): array{return ($this->repository ??= $this->resolveRepository())->findBy($criteria, $orderBy, $limit, $offset);}/** {@inheritDoc} */public function findOneBy(array $criteria, array|null $orderBy = null): object|null{
ServiceEntityRepositoryProxy->findBy(array(), array('id' => 'DESC'), 5)
in
src/Controller/HomeController.php
(line 16)
{#[Route('/', name: 'app_home')]public function index(JobOfferRepository $jobOfferRepository): Response{// On récupère les 5 dernières annonces postées$latestJobs = $jobOfferRepository->findBy([], ['id' => 'DESC'], 5);return $this->render('home/index.html.twig', ['latestJobs' => $latestJobs]);}
in
vendor/symfony/http-kernel/HttpKernel.php
->
index
(line 183)
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);$controller = $event->getController();$arguments = $event->getArguments();// call controller$response = $controller(...$arguments);// viewif (!$response instanceof Response) {$event = new ViewEvent($this, $request, $type, $response, $event);$this->dispatcher->dispatch($event, KernelEvents::VIEW);
in
vendor/symfony/http-kernel/HttpKernel.php
->
handleRaw
(line 76)
$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;}
in
vendor/symfony/http-kernel/Kernel.php
->
handle
(line 193)
if (!$this->handlingHttpCache) {$this->resetServices = true;}try {return $this->getHttpKernel()->handle($request, $type, $catch);} finally {--$this->requestStackSize;}}
in
vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php
->
handle
(line 35)
) {}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) {
in
vendor/autoload_runtime.php
->
run
(line 32)
$app = $app(...$args);exit($runtime->getRunner($app)->run());
<?phpuse App\Kernel;require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return function (array $context) {return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);};
Logs
| Level | Channel | Message |
|---|---|---|
| INFO 05:53:15 | request |
Matched route "_profiler". {
"route": "_profiler",
"route_parameters": {
"_route": "_profiler",
"_controller": "web_profiler.controller.profiler::panelAction",
"token": "7835c0"
},
"request_uri": "http://www.winejobr.com/_profiler/7835c0?panel=exception&type=request",
"method": "GET"
}
|
Stack Traces 3
|
[3/3]
TableNotFoundException
|
|---|
Doctrine\DBAL\Exception\TableNotFoundException:
An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'winejobr.job_offer' doesn't exist
at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:51
at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), object(Query))
(vendor/doctrine/dbal/src/Connection.php:1460)
at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query))
(vendor/doctrine/dbal/src/Connection.php:1396)
at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), 'SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5', array(), array())
(vendor/doctrine/dbal/src/Connection.php:809)
at Doctrine\DBAL\Connection->executeQuery('SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5', array(), array())
(vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:963)
at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll(array(), array('id' => 'DESC'), 5, null)
(vendor/doctrine/orm/src/EntityRepository.php:110)
at Doctrine\ORM\EntityRepository->findBy(array(), array('id' => 'DESC'), 5, null)
(vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php:73)
at Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy(array(), array('id' => 'DESC'), 5)
(src/Controller/HomeController.php:16)
at App\Controller\HomeController->index(object(JobOfferRepository))
(vendor/symfony/http-kernel/HttpKernel.php:183)
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:193)
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:32)
at require_once('/var/www/html/vendor/autoload_runtime.php')
(public/index.php:5)
|
|
[2/3]
Exception
|
|---|
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'winejobr.job_offer' doesn't exist
at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24
at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException))
(vendor/doctrine/dbal/src/Driver/PDO/Connection.php:62)
at Doctrine\DBAL\Driver\PDO\Connection->query('SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5')
(vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:24)
at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query('SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5')
(vendor/doctrine/dbal/src/Logging/Connection.php:39)
at Doctrine\DBAL\Logging\Connection->query('SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5')
(vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:24)
at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query('SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5')
(vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:55)
at Symfony\Bridge\Doctrine\Middleware\Debug\Connection->query('SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5')
(vendor/doctrine/dbal/src/Connection.php:804)
at Doctrine\DBAL\Connection->executeQuery('SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5', array(), array())
(vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:963)
at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll(array(), array('id' => 'DESC'), 5, null)
(vendor/doctrine/orm/src/EntityRepository.php:110)
at Doctrine\ORM\EntityRepository->findBy(array(), array('id' => 'DESC'), 5, null)
(vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php:73)
at Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy(array(), array('id' => 'DESC'), 5)
(src/Controller/HomeController.php:16)
at App\Controller\HomeController->index(object(JobOfferRepository))
(vendor/symfony/http-kernel/HttpKernel.php:183)
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:193)
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:32)
at require_once('/var/www/html/vendor/autoload_runtime.php')
(public/index.php:5)
|
|
[1/3]
PDOException
|
|---|
PDOException:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'winejobr.job_offer' doesn't exist
at vendor/doctrine/dbal/src/Driver/PDO/Connection.php:57
at PDO->query('SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5')
(vendor/doctrine/dbal/src/Driver/PDO/Connection.php:57)
at Doctrine\DBAL\Driver\PDO\Connection->query('SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5')
(vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:24)
at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query('SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5')
(vendor/doctrine/dbal/src/Logging/Connection.php:39)
at Doctrine\DBAL\Logging\Connection->query('SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5')
(vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:24)
at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query('SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5')
(vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:55)
at Symfony\Bridge\Doctrine\Middleware\Debug\Connection->query('SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5')
(vendor/doctrine/dbal/src/Connection.php:804)
at Doctrine\DBAL\Connection->executeQuery('SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.contract_type AS contract_type_4, t0.company_name AS company_name_5, t0.location AS location_6, t0.salary AS salary_7, t0.education_level AS education_level_8, t0.min_experience AS min_experience_9, t0.advantages AS advantages_10 FROM job_offer t0 ORDER BY t0.id DESC LIMIT 5', array(), array())
(vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:963)
at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll(array(), array('id' => 'DESC'), 5, null)
(vendor/doctrine/orm/src/EntityRepository.php:110)
at Doctrine\ORM\EntityRepository->findBy(array(), array('id' => 'DESC'), 5, null)
(vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php:73)
at Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy(array(), array('id' => 'DESC'), 5)
(src/Controller/HomeController.php:16)
at App\Controller\HomeController->index(object(JobOfferRepository))
(vendor/symfony/http-kernel/HttpKernel.php:183)
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:193)
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:32)
at require_once('/var/www/html/vendor/autoload_runtime.php')
(public/index.php:5)
|