Error 500 Internal Server Error

GET http://www.winejobr.com/job/register.html

IP
172.18.0.1
Profiled on
Token
6df62a

Exceptions

PDOException Exception TableNotFoundException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'winejobr.job_offer' doesn't exist

Exceptions 3

Doctrine\DBAL\Exception\ TableNotFoundException

Show exception properties 
Doctrine\DBAL\Exception\TableNotFoundException {#727
  -query: Doctrine\DBAL\Query {#724
    -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 WHERE t0.id = ?"
    -params: array:1 [
      0 => "register.html"
    ]
    -types: array:1 [
      0 => "integer"
    ]
  }
}
in vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php (line 51)
  1. 1008 => new DatabaseDoesNotExist($exception, $query),
  2. 1213 => new DeadlockException($exception, $query),
  3. 1205 => new LockWaitTimeoutException($exception, $query),
  4. 1050 => new TableExistsException($exception, $query),
  5. 1051,
  6. 1146 => new TableNotFoundException($exception, $query),
  7. 1216,
  8. 1217,
  9. 1451,
  10. 1452,
  11. 1701 => new ForeignKeyConstraintViolationException($exception, $query),
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1460)
  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 1396)
  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 809)
  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. }
  8. }
  10. /**
  11. * Executes a caching query.
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> executeQuery (line 738)
  1. ): object|null {
  2. $this->switchPersisterContext(null, $limit);
  4. $sql = $this->getSelectSQL($criteria, $assoc, $lockMode, $limit, null, $orderBy);
  5. [$params, $types] = $this->expandParameters($criteria);
  6. $stmt = $this->conn->executeQuery($sql, $params, $types);
  8. if ($entity !== null) {
  9. $hints[Query::HINT_REFRESH] = true;
  10. $hints[Query::HINT_REFRESH_ENTITY] = $entity;
  11. }
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> load (line 756)
  1. /**
  2. * {@inheritDoc}
  3. */
  4. public function loadById(array $identifier, object|null $entity = null): object|null
  5. {
  6. return $this->load($identifier, $entity);
  7. }
  9. /**
  10. * {@inheritDoc}
  11. */
in vendor/doctrine/orm/src/EntityManager.php -> loadById (line 366)
  1. case $lockMode === LockMode::PESSIMISTIC_READ:
  2. case $lockMode === LockMode::PESSIMISTIC_WRITE:
  3. return $persister->load($sortedId, null, null, [], $lockMode);
  5. default:
  6. return $persister->loadById($sortedId);
  7. }
  8. }
  10. public function getReference(string $entityName, mixed $id): object|null
  11. {
in vendor/doctrine/orm/src/EntityRepository.php -> find (line 86)
  1. * @return object|null The entity instance or NULL if the entity can not be found.
  2. * @phpstan-return ?T
  3. */
  4. public function find(mixed $id, LockMode|int|null $lockMode = null, int|null $lockVersion = null): object|null
  5. {
  6. return $this->em->find($this->entityName, $id, $lockMode, $lockVersion);
  7. }
  9. /**
  10. * Finds all entities in the repository.
  11. *
in vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php -> find (line 61)
  2. public function find(mixed $id, LockMode|int|null $lockMode = null, int|null $lockVersion = null): object|null
  3. {
  4. /** @psalm-suppress InvalidReturnStatement This proxy is used only in combination with newer parent class */
  5. return ($this->repository ??= $this->resolveRepository())
  6. ->find($id, $lockMode, $lockVersion);
  7. }
  9. /**
  10. * {@inheritDoc}
  11. *
in vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php -> find (line 129)
  1. $cacheProvider->evictEntity($options->class, $id);
  2. }
  3. }
  5. try {
  6. return $manager->getRepository($options->class)->find($id);
  7. } catch (NoResultException|ConversionException) {
  8. return null;
  9. }
  10. }
in vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php -> find (line 69)
  1. if (null !== $options->expr) {
  2. if (null === $object = $this->findViaExpression($manager, $request, $options)) {
  3. $message = \sprintf(' The expression "%s" returned null.', $options->expr);
  4. }
  5. // find by identifier?
  6. } elseif (false === $object = $this->find($manager, $request, $options, $argument)) {
  7. // find by criteria
  8. if (!$criteria = $this->getCriteria($request, $options, $manager, $argument)) {
  9. if (!class_exists(NearMissValueResolverException::class)) {
  10. return [];
  11. }
in vendor/symfony/http-kernel/Controller/ArgumentResolver/TraceableValueResolver.php -> resolve (line 37)
  1. public function resolve(Request $request, ArgumentMetadata $argument): iterable
  2. {
  3. $method = $this->inner::class.'::'.__FUNCTION__;
  4. $this->stopwatch->start($method, 'controller.argument_value_resolver');
  6. yield from $this->inner->resolve($request, $argument);
  8. $this->stopwatch->stop($method);
  9. }
  10. }
in vendor/symfony/http-kernel/Controller/ArgumentResolver.php -> resolve (line 91)
  1. continue;
  2. }
  4. try {
  5. $count = 0;
  6. foreach ($resolver->resolve($request, $metadata) as $argument) {
  7. ++$count;
  8. $arguments[] = $argument;
  9. }
  10. } catch (NearMissValueResolverException $e) {
  11. $valueResolverExceptions[] = $e;
in vendor/symfony/http-kernel/Controller/TraceableArgumentResolver.php -> getArguments (line 33)
  1. public function getArguments(Request $request, callable $controller, ?\ReflectionFunctionAbstract $reflector = null): array
  2. {
  3. $e = $this->stopwatch->start('controller.get_arguments');
  5. try {
  6. return $this->resolver->getArguments($request, $controller, $reflector);
  7. } finally {
  8. $e->stop();
  9. }
  10. }
  11. }
in vendor/symfony/http-kernel/HttpKernel.php -> getArguments (line 175)
  1. $event = new ControllerEvent($this, $controller, $request, $type);
  2. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER);
  3. $controller = $event->getController();
  5. // controller arguments
  6. $arguments = $this->argumentResolver->getArguments($request, $controller, $event->getControllerReflector());
  8. $event = new ControllerArgumentsEvent($this, $event, $arguments, $request, $type);
  9. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  10. $controller = $event->getController();
  11. $arguments = $event->getArguments();
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $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 193)
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  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. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. if (Kernel::VERSION_ID >= 60400) {
  9. $response->send(false);
  11. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/var/www/html/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[42S02]: Base table or view not found: 1146 Table 'winejobr.job_offer' doesn't exist

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 24)
  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 57)
  1. public function execute(): Result
  2. {
  3. try {
  4. $this->stmt->execute();
  5. } catch (PDOException $exception) {
  6. throw Exception::new($exception);
  7. }
  9. return new Result($this->stmt);
  10. }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 24)
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  4. public function execute(): Result
  5. {
  6. return $this->wrappedStatement->execute();
  7. }
  8. }
in vendor/doctrine/dbal/src/Logging/Statement.php -> execute (line 46)
  1. 'sql' => $this->sql,
  2. 'params' => $this->params,
  3. 'types' => $this->types,
  4. ]);
  6. return parent::execute();
  7. }
  8. }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 24)
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  4. public function execute(): Result
  5. {
  6. return $this->wrappedStatement->execute();
  7. }
  8. }
in vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php -> execute (line 58)
  2. $this->stopwatch?->start('doctrine', 'doctrine');
  3. $query->start();
  5. try {
  6. return parent::execute();
  7. } finally {
  8. $query->stop();
  9. $this->stopwatch?->stop('doctrine');
  10. }
  11. }
in vendor/doctrine/dbal/src/Connection.php -> execute (line 802)
  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/src/Persisters/Entity/BasicEntityPersister.php -> executeQuery (line 738)
  1. ): object|null {
  2. $this->switchPersisterContext(null, $limit);
  4. $sql = $this->getSelectSQL($criteria, $assoc, $lockMode, $limit, null, $orderBy);
  5. [$params, $types] = $this->expandParameters($criteria);
  6. $stmt = $this->conn->executeQuery($sql, $params, $types);
  8. if ($entity !== null) {
  9. $hints[Query::HINT_REFRESH] = true;
  10. $hints[Query::HINT_REFRESH_ENTITY] = $entity;
  11. }
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> load (line 756)
  1. /**
  2. * {@inheritDoc}
  3. */
  4. public function loadById(array $identifier, object|null $entity = null): object|null
  5. {
  6. return $this->load($identifier, $entity);
  7. }
  9. /**
  10. * {@inheritDoc}
  11. */
in vendor/doctrine/orm/src/EntityManager.php -> loadById (line 366)
  1. case $lockMode === LockMode::PESSIMISTIC_READ:
  2. case $lockMode === LockMode::PESSIMISTIC_WRITE:
  3. return $persister->load($sortedId, null, null, [], $lockMode);
  5. default:
  6. return $persister->loadById($sortedId);
  7. }
  8. }
  10. public function getReference(string $entityName, mixed $id): object|null
  11. {
in vendor/doctrine/orm/src/EntityRepository.php -> find (line 86)
  1. * @return object|null The entity instance or NULL if the entity can not be found.
  2. * @phpstan-return ?T
  3. */
  4. public function find(mixed $id, LockMode|int|null $lockMode = null, int|null $lockVersion = null): object|null
  5. {
  6. return $this->em->find($this->entityName, $id, $lockMode, $lockVersion);
  7. }
  9. /**
  10. * Finds all entities in the repository.
  11. *
in vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php -> find (line 61)
  2. public function find(mixed $id, LockMode|int|null $lockMode = null, int|null $lockVersion = null): object|null
  3. {
  4. /** @psalm-suppress InvalidReturnStatement This proxy is used only in combination with newer parent class */
  5. return ($this->repository ??= $this->resolveRepository())
  6. ->find($id, $lockMode, $lockVersion);
  7. }
  9. /**
  10. * {@inheritDoc}
  11. *
in vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php -> find (line 129)
  1. $cacheProvider->evictEntity($options->class, $id);
  2. }
  3. }
  5. try {
  6. return $manager->getRepository($options->class)->find($id);
  7. } catch (NoResultException|ConversionException) {
  8. return null;
  9. }
  10. }
in vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php -> find (line 69)
  1. if (null !== $options->expr) {
  2. if (null === $object = $this->findViaExpression($manager, $request, $options)) {
  3. $message = \sprintf(' The expression "%s" returned null.', $options->expr);
  4. }
  5. // find by identifier?
  6. } elseif (false === $object = $this->find($manager, $request, $options, $argument)) {
  7. // find by criteria
  8. if (!$criteria = $this->getCriteria($request, $options, $manager, $argument)) {
  9. if (!class_exists(NearMissValueResolverException::class)) {
  10. return [];
  11. }
in vendor/symfony/http-kernel/Controller/ArgumentResolver/TraceableValueResolver.php -> resolve (line 37)
  1. public function resolve(Request $request, ArgumentMetadata $argument): iterable
  2. {
  3. $method = $this->inner::class.'::'.__FUNCTION__;
  4. $this->stopwatch->start($method, 'controller.argument_value_resolver');
  6. yield from $this->inner->resolve($request, $argument);
  8. $this->stopwatch->stop($method);
  9. }
  10. }
in vendor/symfony/http-kernel/Controller/ArgumentResolver.php -> resolve (line 91)
  1. continue;
  2. }
  4. try {
  5. $count = 0;
  6. foreach ($resolver->resolve($request, $metadata) as $argument) {
  7. ++$count;
  8. $arguments[] = $argument;
  9. }
  10. } catch (NearMissValueResolverException $e) {
  11. $valueResolverExceptions[] = $e;
in vendor/symfony/http-kernel/Controller/TraceableArgumentResolver.php -> getArguments (line 33)
  1. public function getArguments(Request $request, callable $controller, ?\ReflectionFunctionAbstract $reflector = null): array
  2. {
  3. $e = $this->stopwatch->start('controller.get_arguments');
  5. try {
  6. return $this->resolver->getArguments($request, $controller, $reflector);
  7. } finally {
  8. $e->stop();
  9. }
  10. }
  11. }
in vendor/symfony/http-kernel/HttpKernel.php -> getArguments (line 175)
  1. $event = new ControllerEvent($this, $controller, $request, $type);
  2. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER);
  3. $controller = $event->getController();
  5. // controller arguments
  6. $arguments = $this->argumentResolver->getArguments($request, $controller, $event->getControllerReflector());
  8. $event = new ControllerArgumentsEvent($this, $event, $arguments, $request, $type);
  9. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  10. $controller = $event->getController();
  11. $arguments = $event->getArguments();
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $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 193)
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  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. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. if (Kernel::VERSION_ID >= 60400) {
  9. $response->send(false);
  11. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/var/www/html/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[42S02]: Base table or view not found: 1146 Table 'winejobr.job_offer' doesn't exist

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 55)
  1. }
  3. public function execute(): Result
  4. {
  5. try {
  6. $this->stmt->execute();
  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 55)
  1. }
  3. public function execute(): Result
  4. {
  5. try {
  6. $this->stmt->execute();
  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 24)
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  4. public function execute(): Result
  5. {
  6. return $this->wrappedStatement->execute();
  7. }
  8. }
in vendor/doctrine/dbal/src/Logging/Statement.php -> execute (line 46)
  1. 'sql' => $this->sql,
  2. 'params' => $this->params,
  3. 'types' => $this->types,
  4. ]);
  6. return parent::execute();
  7. }
  8. }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 24)
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  4. public function execute(): Result
  5. {
  6. return $this->wrappedStatement->execute();
  7. }
  8. }
in vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php -> execute (line 58)
  2. $this->stopwatch?->start('doctrine', 'doctrine');
  3. $query->start();
  5. try {
  6. return parent::execute();
  7. } finally {
  8. $query->stop();
  9. $this->stopwatch?->stop('doctrine');
  10. }
  11. }
in vendor/doctrine/dbal/src/Connection.php -> execute (line 802)
  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/src/Persisters/Entity/BasicEntityPersister.php -> executeQuery (line 738)
  1. ): object|null {
  2. $this->switchPersisterContext(null, $limit);
  4. $sql = $this->getSelectSQL($criteria, $assoc, $lockMode, $limit, null, $orderBy);
  5. [$params, $types] = $this->expandParameters($criteria);
  6. $stmt = $this->conn->executeQuery($sql, $params, $types);
  8. if ($entity !== null) {
  9. $hints[Query::HINT_REFRESH] = true;
  10. $hints[Query::HINT_REFRESH_ENTITY] = $entity;
  11. }
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> load (line 756)
  1. /**
  2. * {@inheritDoc}
  3. */
  4. public function loadById(array $identifier, object|null $entity = null): object|null
  5. {
  6. return $this->load($identifier, $entity);
  7. }
  9. /**
  10. * {@inheritDoc}
  11. */
in vendor/doctrine/orm/src/EntityManager.php -> loadById (line 366)
  1. case $lockMode === LockMode::PESSIMISTIC_READ:
  2. case $lockMode === LockMode::PESSIMISTIC_WRITE:
  3. return $persister->load($sortedId, null, null, [], $lockMode);
  5. default:
  6. return $persister->loadById($sortedId);
  7. }
  8. }
  10. public function getReference(string $entityName, mixed $id): object|null
  11. {
in vendor/doctrine/orm/src/EntityRepository.php -> find (line 86)
  1. * @return object|null The entity instance or NULL if the entity can not be found.
  2. * @phpstan-return ?T
  3. */
  4. public function find(mixed $id, LockMode|int|null $lockMode = null, int|null $lockVersion = null): object|null
  5. {
  6. return $this->em->find($this->entityName, $id, $lockMode, $lockVersion);
  7. }
  9. /**
  10. * Finds all entities in the repository.
  11. *
in vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php -> find (line 61)
  2. public function find(mixed $id, LockMode|int|null $lockMode = null, int|null $lockVersion = null): object|null
  3. {
  4. /** @psalm-suppress InvalidReturnStatement This proxy is used only in combination with newer parent class */
  5. return ($this->repository ??= $this->resolveRepository())
  6. ->find($id, $lockMode, $lockVersion);
  7. }
  9. /**
  10. * {@inheritDoc}
  11. *
in vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php -> find (line 129)
  1. $cacheProvider->evictEntity($options->class, $id);
  2. }
  3. }
  5. try {
  6. return $manager->getRepository($options->class)->find($id);
  7. } catch (NoResultException|ConversionException) {
  8. return null;
  9. }
  10. }
in vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php -> find (line 69)
  1. if (null !== $options->expr) {
  2. if (null === $object = $this->findViaExpression($manager, $request, $options)) {
  3. $message = \sprintf(' The expression "%s" returned null.', $options->expr);
  4. }
  5. // find by identifier?
  6. } elseif (false === $object = $this->find($manager, $request, $options, $argument)) {
  7. // find by criteria
  8. if (!$criteria = $this->getCriteria($request, $options, $manager, $argument)) {
  9. if (!class_exists(NearMissValueResolverException::class)) {
  10. return [];
  11. }
in vendor/symfony/http-kernel/Controller/ArgumentResolver/TraceableValueResolver.php -> resolve (line 37)
  1. public function resolve(Request $request, ArgumentMetadata $argument): iterable
  2. {
  3. $method = $this->inner::class.'::'.__FUNCTION__;
  4. $this->stopwatch->start($method, 'controller.argument_value_resolver');
  6. yield from $this->inner->resolve($request, $argument);
  8. $this->stopwatch->stop($method);
  9. }
  10. }
in vendor/symfony/http-kernel/Controller/ArgumentResolver.php -> resolve (line 91)
  1. continue;
  2. }
  4. try {
  5. $count = 0;
  6. foreach ($resolver->resolve($request, $metadata) as $argument) {
  7. ++$count;
  8. $arguments[] = $argument;
  9. }
  10. } catch (NearMissValueResolverException $e) {
  11. $valueResolverExceptions[] = $e;
in vendor/symfony/http-kernel/Controller/TraceableArgumentResolver.php -> getArguments (line 33)
  1. public function getArguments(Request $request, callable $controller, ?\ReflectionFunctionAbstract $reflector = null): array
  2. {
  3. $e = $this->stopwatch->start('controller.get_arguments');
  5. try {
  6. return $this->resolver->getArguments($request, $controller, $reflector);
  7. } finally {
  8. $e->stop();
  9. }
  10. }
  11. }
in vendor/symfony/http-kernel/HttpKernel.php -> getArguments (line 175)
  1. $event = new ControllerEvent($this, $controller, $request, $type);
  2. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER);
  3. $controller = $event->getController();
  5. // controller arguments
  6. $arguments = $this->argumentResolver->getArguments($request, $controller, $event->getControllerReflector());
  8. $event = new ControllerArgumentsEvent($this, $event, $arguments, $request, $type);
  9. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  10. $controller = $event->getController();
  11. $arguments = $event->getArguments();
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $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 193)
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  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. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. if (Kernel::VERSION_ID >= 60400) {
  9. $response->send(false);
  11. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/var/www/html/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. };

Logs

Level Channel Message
INFO 02:45:49 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "6df62a"
    },
    "request_uri": "http://www.winejobr.com/_profiler/6df62a",
    "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 WHERE t0.id = ?', array('register.html'), array('integer'))
     (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 WHERE t0.id = ?', array('register.html'), array('integer'))
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:738)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(array('id' => 'register.html'), null)
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:756)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById(array('id' => 'register.html'))
     (vendor/doctrine/orm/src/EntityManager.php:366)
  at Doctrine\ORM\EntityManager->find('App\\Entity\\JobOffer', array(), null, null)
     (vendor/doctrine/orm/src/EntityRepository.php:86)
  at Doctrine\ORM\EntityRepository->find('register.html', null, null)
     (vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php:61)
  at Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find('register.html')
     (vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php:129)
  at Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find(object(EntityManagerGhost614a58f), object(Request), object(MapEntity), object(ArgumentMetadata))
     (vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php:69)
  at Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve(object(Request), object(ArgumentMetadata))
     (vendor/symfony/http-kernel/Controller/ArgumentResolver/TraceableValueResolver.php:37)
  at Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve(object(Request), object(ArgumentMetadata))
     (vendor/symfony/http-kernel/Controller/ArgumentResolver.php:91)
  at Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments(object(Request), array(object(JobController), 'show'), object(ReflectionMethod))
     (vendor/symfony/http-kernel/Controller/TraceableArgumentResolver.php:33)
  at Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments(object(Request), array(object(JobController), 'show'), object(ReflectionMethod))
     (vendor/symfony/http-kernel/HttpKernel.php:175)
  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/Statement.php:57)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/doctrine/dbal/src/Logging/Statement.php:46)
  at Doctrine\DBAL\Logging\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php:58)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:802)
  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 WHERE t0.id = ?', array('register.html'), array('integer'))
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:738)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(array('id' => 'register.html'), null)
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:756)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById(array('id' => 'register.html'))
     (vendor/doctrine/orm/src/EntityManager.php:366)
  at Doctrine\ORM\EntityManager->find('App\\Entity\\JobOffer', array(), null, null)
     (vendor/doctrine/orm/src/EntityRepository.php:86)
  at Doctrine\ORM\EntityRepository->find('register.html', null, null)
     (vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php:61)
  at Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find('register.html')
     (vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php:129)
  at Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find(object(EntityManagerGhost614a58f), object(Request), object(MapEntity), object(ArgumentMetadata))
     (vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php:69)
  at Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve(object(Request), object(ArgumentMetadata))
     (vendor/symfony/http-kernel/Controller/ArgumentResolver/TraceableValueResolver.php:37)
  at Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve(object(Request), object(ArgumentMetadata))
     (vendor/symfony/http-kernel/Controller/ArgumentResolver.php:91)
  at Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments(object(Request), array(object(JobController), 'show'), object(ReflectionMethod))
     (vendor/symfony/http-kernel/Controller/TraceableArgumentResolver.php:33)
  at Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments(object(Request), array(object(JobController), 'show'), object(ReflectionMethod))
     (vendor/symfony/http-kernel/HttpKernel.php:175)
  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/Statement.php:55
  at PDOStatement->execute()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:55)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/doctrine/dbal/src/Logging/Statement.php:46)
  at Doctrine\DBAL\Logging\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php:58)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:802)
  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 WHERE t0.id = ?', array('register.html'), array('integer'))
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:738)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(array('id' => 'register.html'), null)
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:756)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById(array('id' => 'register.html'))
     (vendor/doctrine/orm/src/EntityManager.php:366)
  at Doctrine\ORM\EntityManager->find('App\\Entity\\JobOffer', array(), null, null)
     (vendor/doctrine/orm/src/EntityRepository.php:86)
  at Doctrine\ORM\EntityRepository->find('register.html', null, null)
     (vendor/doctrine/doctrine-bundle/src/Repository/ServiceEntityRepositoryProxy.php:61)
  at Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find('register.html')
     (vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php:129)
  at Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find(object(EntityManagerGhost614a58f), object(Request), object(MapEntity), object(ArgumentMetadata))
     (vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php:69)
  at Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve(object(Request), object(ArgumentMetadata))
     (vendor/symfony/http-kernel/Controller/ArgumentResolver/TraceableValueResolver.php:37)
  at Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve(object(Request), object(ArgumentMetadata))
     (vendor/symfony/http-kernel/Controller/ArgumentResolver.php:91)
  at Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments(object(Request), array(object(JobController), 'show'), object(ReflectionMethod))
     (vendor/symfony/http-kernel/Controller/TraceableArgumentResolver.php:33)
  at Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments(object(Request), array(object(JobController), 'show'), object(ReflectionMethod))
     (vendor/symfony/http-kernel/HttpKernel.php:175)
  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)