Error 500 Internal Server Error

GET https://demo-sarl.logistic.odoip.cloud/dashboard/parcels

Browse referrer URL
IP
82.66.223.236
Profiled on
Token
2c303e

Exceptions

PDOException Exception InvalidFieldNameException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column p0_.sender_confirm_otp does not exist
LINE 1: ...signature_base64 AS delivery_signature_base64_11, p0_.sender...
^

Exceptions 3

Doctrine\DBAL\Exception\ InvalidFieldNameException

Show exception properties 
Doctrine\DBAL\Exception\InvalidFieldNameException {#1045
  -query: Doctrine\DBAL\Query {#1047
    -sql: "SELECT p0_.id AS id_0, p0_.tracking_code AS tracking_code_1, p0_.reference AS reference_2, p0_.status AS status_3, p0_.weight_kg AS weight_kg_4, p0_.declared_value AS declared_value_5, p0_.description AS description_6, p0_.packages_count AS packages_count_7, p0_.price_total AS price_total_8, p0_.currency AS currency_9, p0_.payment_status AS payment_status_10, p0_.delivery_signature_base64 AS delivery_signature_base64_11, p0_.sender_confirm_otp AS sender_confirm_otp_12, p0_.sender_confirmed_at AS sender_confirmed_at_13, p0_.recipient_confirm_otp AS recipient_confirm_otp_14, p0_.recipient_confirmed_at AS recipient_confirmed_at_15, p0_.pickup_notes AS pickup_notes_16, p0_.delivery_notes AS delivery_notes_17, p0_.picked_up_at AS picked_up_at_18, p0_.delivered_at AS delivered_at_19, p0_.received_confirmed_at AS received_confirmed_at_20, p0_.received_confirmed_by AS received_confirmed_by_21, p0_.created_at AS created_at_22, p0_.updated_at AS updated_at_23, a1_.id AS id_24, a1_.type AS type_25, a1_.contact_name AS contact_name_26, a1_.phone AS phone_27, a1_.line1 AS line1_28, a1_.line2 AS line2_29, a1_.city AS city_30, a1_.postal_code AS postal_code_31, a1_.country_code AS country_code_32, a1_.latitude AS latitude_33, a1_.longitude AS longitude_34, a1_.notes AS notes_35, p0_.tenant_id AS tenant_id_36, p0_.sender_id AS sender_id_37, p0_.recipient_id AS recipient_id_38, p0_.container_id AS container_id_39, p0_.driver_id AS driver_id_40, a1_.tenant_id AS tenant_id_41 FROM parcel p0_ LEFT JOIN address a1_ ON p0_.recipient_id = a1_.id AND (a1_.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d') WHERE (p0_.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d') ORDER BY p0_.created_at DESC"
    -params: []
    -types: []
  }
}
in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 69)
  2. case '42702':
  3. return new NonUniqueFieldNameException($exception, $query);
  5. case '42703':
  6. return new InvalidFieldNameException($exception, $query);
  8. case '42P01':
  9. return new TableNotFoundException($exception, $query);
  11. case '42P07':
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/Query/Exec/FinalizedSelectExecutor.php -> executeQuery (line 27)
  1. /**
  2. * {@inheritDoc}
  3. */
  4. public function execute(Connection $conn, array $params, array $types): Result
  5. {
  6. return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);
  7. }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 296)
  1. $sqlParams,
  2. $types,
  3. $this->em->getConnection()->getParams(),
  4. );
  6. return $executor->execute($this->em->getConnection(), $sqlParams, $types);
  7. }
  9. /**
  10. * @param array<string,mixed> $sqlParams
  11. * @param array<string,Type> $types
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 930)
  1. $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2. $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3. };
  4. }
  6. $stmt = $this->_doExecute();
  8. if (is_numeric($stmt)) {
  9. $setCacheEntry($stmt);
  11. return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 886)
  1. ): mixed {
  2. if ($this->cacheable && $this->isCacheEnabled()) {
  3. return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4. }
  6. return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7. }
  9. /**
  10. * Execute query ignoring second level cache.
  11. *
in vendor/doctrine/orm/src/AbstractQuery.php -> execute (line 688)
  1. *
  2. * @phpstan-param string|AbstractQuery::HYDRATE_* $hydrationMode
  3. */
  4. public function getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed
  5. {
  6. return $this->execute(null, $hydrationMode);
  7. }
  9. /**
  10. * Gets the array of results for the query.
  11. *
AbstractQuery->getResult() in src/Controller/ParcelController.php (line 56)
  1. $qb->andWhere('p.status = :s')->setParameter('s', $status);
  2. }
  4. return $this->render('dashboard_parcels.html.twig', [
  5. 'tenant' => $tenant,
  6. 'parcels' => $qb->getQuery()->getResult(),
  7. 'q' => $q,
  8. 'status' => $status,
  9. ]);
  10. }
in vendor/symfony/http-kernel/HttpKernel.php -> index (line 183)
  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 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/logistic/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 static function (array $context) {
  8. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42703]: Undefined column: 7 ERROR: column p0_.sender_confirm_otp does not exist LINE 1: ...signature_base64 AS delivery_signature_base64_11, p0_.sender... ^

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/Connection.php :: new (line 62)
  1. $stmt = $this->connection->query($sql);
  2. assert($stmt instanceof PDOStatement);
  4. return new Result($stmt);
  5. } catch (PDOException $exception) {
  6. throw Exception::new($exception);
  7. }
  8. }
  10. public function quote(string $value): string
  11. {
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php -> query (line 24)
  1. return $this->wrappedConnection->prepare($sql);
  2. }
  4. public function query(string $sql): Result
  5. {
  6. return $this->wrappedConnection->query($sql);
  7. }
  9. public function quote(string $value): string
  10. {
  11. return $this->wrappedConnection->quote($value);
in vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php -> query (line 55)
  2. $this->stopwatch?->start('doctrine', 'doctrine');
  3. $query->start();
  5. try {
  6. return parent::query($sql);
  7. } finally {
  8. $query->stop();
  9. $this->stopwatch?->stop('doctrine');
  10. }
  11. }
in vendor/doctrine/dbal/src/Connection.php -> query (line 804)
  2. $this->bindParameters($stmt, $params, $types);
  4. $result = $stmt->execute();
  5. } else {
  6. $result = $connection->query($sql);
  7. }
  9. return new Result($result, $this);
  10. } catch (Driver\Exception $e) {
  11. throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
in vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php -> executeQuery (line 27)
  1. /**
  2. * {@inheritDoc}
  3. */
  4. public function execute(Connection $conn, array $params, array $types): Result
  5. {
  6. return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);
  7. }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 296)
  1. $sqlParams,
  2. $types,
  3. $this->em->getConnection()->getParams(),
  4. );
  6. return $executor->execute($this->em->getConnection(), $sqlParams, $types);
  7. }
  9. /**
  10. * @param array<string,mixed> $sqlParams
  11. * @param array<string,Type> $types
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 930)
  1. $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2. $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3. };
  4. }
  6. $stmt = $this->_doExecute();
  8. if (is_numeric($stmt)) {
  9. $setCacheEntry($stmt);
  11. return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 886)
  1. ): mixed {
  2. if ($this->cacheable && $this->isCacheEnabled()) {
  3. return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4. }
  6. return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7. }
  9. /**
  10. * Execute query ignoring second level cache.
  11. *
in vendor/doctrine/orm/src/AbstractQuery.php -> execute (line 688)
  1. *
  2. * @phpstan-param string|AbstractQuery::HYDRATE_* $hydrationMode
  3. */
  4. public function getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed
  5. {
  6. return $this->execute(null, $hydrationMode);
  7. }
  9. /**
  10. * Gets the array of results for the query.
  11. *
AbstractQuery->getResult() in src/Controller/ParcelController.php (line 56)
  1. $qb->andWhere('p.status = :s')->setParameter('s', $status);
  2. }
  4. return $this->render('dashboard_parcels.html.twig', [
  5. 'tenant' => $tenant,
  6. 'parcels' => $qb->getQuery()->getResult(),
  7. 'q' => $q,
  8. 'status' => $status,
  9. ]);
  10. }
in vendor/symfony/http-kernel/HttpKernel.php -> index (line 183)
  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 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/logistic/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 static function (array $context) {
  8. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

PDOException

SQLSTATE[42703]: Undefined column: 7 ERROR: column p0_.sender_confirm_otp does not exist LINE 1: ...signature_base64 AS delivery_signature_base64_11, p0_.sender... ^

in vendor/doctrine/dbal/src/Driver/PDO/Connection.php (line 57)
  1. }
  3. public function query(string $sql): Result
  4. {
  5. try {
  6. $stmt = $this->connection->query($sql);
  7. assert($stmt instanceof PDOStatement);
  9. return new Result($stmt);
  10. } catch (PDOException $exception) {
  11. throw Exception::new($exception);
in vendor/doctrine/dbal/src/Driver/PDO/Connection.php -> query (line 57)
  1. }
  3. public function query(string $sql): Result
  4. {
  5. try {
  6. $stmt = $this->connection->query($sql);
  7. assert($stmt instanceof PDOStatement);
  9. return new Result($stmt);
  10. } catch (PDOException $exception) {
  11. throw Exception::new($exception);
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php -> query (line 24)
  1. return $this->wrappedConnection->prepare($sql);
  2. }
  4. public function query(string $sql): Result
  5. {
  6. return $this->wrappedConnection->query($sql);
  7. }
  9. public function quote(string $value): string
  10. {
  11. return $this->wrappedConnection->quote($value);
in vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php -> query (line 55)
  2. $this->stopwatch?->start('doctrine', 'doctrine');
  3. $query->start();
  5. try {
  6. return parent::query($sql);
  7. } finally {
  8. $query->stop();
  9. $this->stopwatch?->stop('doctrine');
  10. }
  11. }
in vendor/doctrine/dbal/src/Connection.php -> query (line 804)
  2. $this->bindParameters($stmt, $params, $types);
  4. $result = $stmt->execute();
  5. } else {
  6. $result = $connection->query($sql);
  7. }
  9. return new Result($result, $this);
  10. } catch (Driver\Exception $e) {
  11. throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
in vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php -> executeQuery (line 27)
  1. /**
  2. * {@inheritDoc}
  3. */
  4. public function execute(Connection $conn, array $params, array $types): Result
  5. {
  6. return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);
  7. }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 296)
  1. $sqlParams,
  2. $types,
  3. $this->em->getConnection()->getParams(),
  4. );
  6. return $executor->execute($this->em->getConnection(), $sqlParams, $types);
  7. }
  9. /**
  10. * @param array<string,mixed> $sqlParams
  11. * @param array<string,Type> $types
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 930)
  1. $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2. $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3. };
  4. }
  6. $stmt = $this->_doExecute();
  8. if (is_numeric($stmt)) {
  9. $setCacheEntry($stmt);
  11. return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 886)
  1. ): mixed {
  2. if ($this->cacheable && $this->isCacheEnabled()) {
  3. return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4. }
  6. return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7. }
  9. /**
  10. * Execute query ignoring second level cache.
  11. *
in vendor/doctrine/orm/src/AbstractQuery.php -> execute (line 688)
  1. *
  2. * @phpstan-param string|AbstractQuery::HYDRATE_* $hydrationMode
  3. */
  4. public function getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed
  5. {
  6. return $this->execute(null, $hydrationMode);
  7. }
  9. /**
  10. * Gets the array of results for the query.
  11. *
AbstractQuery->getResult() in src/Controller/ParcelController.php (line 56)
  1. $qb->andWhere('p.status = :s')->setParameter('s', $status);
  2. }
  4. return $this->render('dashboard_parcels.html.twig', [
  5. 'tenant' => $tenant,
  6. 'parcels' => $qb->getQuery()->getResult(),
  7. 'q' => $q,
  8. 'status' => $status,
  9. ]);
  10. }
in vendor/symfony/http-kernel/HttpKernel.php -> index (line 183)
  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 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/logistic/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 static function (array $context) {
  8. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

Logs

Level Message
info 17:56:19 Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "2c303e"
    },
    "request_uri": "https://www.logistic.odoip.cloud/_profiler/2c303e",
    "method": "GET"
}
debug 17:56:19 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
debug 17:56:19 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
debug 17:56:19 Notified event "kernel.request" to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Nelmio\\CorsBundle\\EventListener\\CorsListener::onKernelRequest"
}
debug 17:56:19 Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest"
}
debug 17:56:19 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
debug 17:56:19 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
debug 17:56:19 Notified event "kernel.request" to listener "App\EventSubscriber\TenantResolverSubscriber::onRequest". 
{
    "event": "kernel.request",
    "listener": "App\\EventSubscriber\\TenantResolverSubscriber::onRequest"
}
debug 17:56:19 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
debug 17:56:19 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
debug 17:56:19 Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
debug 17:56:19 Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
debug 17:56:19 Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
debug 17:56:19 Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
debug 17:56:19 Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
debug 17:56:19 Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\IsSignatureValidAttributeListener::onKernelControllerArguments"
}
debug 17:56:19 Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
}
debug 17:56:19 Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
debug 17:56:19 Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
debug 17:56:19 Notified event "kernel.controller_arguments" to listener "ContainerMNxRErp\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "ContainerMNxRErp\\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
}
debug 17:56:19 Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}

Stack Traces 3

[3/3] InvalidFieldNameException 
Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR:  column p0_.sender_confirm_otp does not exist
LINE 1: ...signature_base64 AS delivery_signature_base64_11, p0_.sender...
                                                             ^

  at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:69
  at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1460)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1396)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Connection.php:809)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27)
  at Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute()
     (vendor/doctrine/orm/src/Query.php:296)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/src/AbstractQuery.php:688)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/Controller/ParcelController.php:56)
  at App\Controller\ParcelController->index()
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:193)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (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/logistic/vendor/autoload_runtime.php')
     (public/index.php:5)
[2/3] Exception 
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42703]: Undefined column: 7 ERROR:  column p0_.sender_confirm_otp does not exist
LINE 1: ...signature_base64 AS delivery_signature_base64_11, p0_.sender...
                                                             ^

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:62)
  at Doctrine\DBAL\Driver\PDO\Connection->query()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:55)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Connection->query()
     (vendor/doctrine/dbal/src/Connection.php:804)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27)
  at Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute()
     (vendor/doctrine/orm/src/Query.php:296)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/src/AbstractQuery.php:688)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/Controller/ParcelController.php:56)
  at App\Controller\ParcelController->index()
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:193)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (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/logistic/vendor/autoload_runtime.php')
     (public/index.php:5)
[1/3] PDOException 
PDOException:
SQLSTATE[42703]: Undefined column: 7 ERROR:  column p0_.sender_confirm_otp does not exist
LINE 1: ...signature_base64 AS delivery_signature_base64_11, p0_.sender...
                                                             ^

  at vendor/doctrine/dbal/src/Driver/PDO/Connection.php:57
  at PDO->query()
     (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:57)
  at Doctrine\DBAL\Driver\PDO\Connection->query()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:55)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Connection->query()
     (vendor/doctrine/dbal/src/Connection.php:804)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27)
  at Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute()
     (vendor/doctrine/orm/src/Query.php:296)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/src/AbstractQuery.php:688)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/Controller/ParcelController.php:56)
  at App\Controller\ParcelController->index()
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:193)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (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/logistic/vendor/autoload_runtime.php')
     (public/index.php:5)