Error 500 Internal Server Error

GET https://managsyntest.avinconcept.fr/admin/messagerie/badge

Forwarded to ErrorController (8f7cb5)

Exceptions

An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "staff_messages" does not exist
LINE 1: SELECT COUNT(s0_.id) AS sclr_0 FROM staff_messages s0_ WHERE...
^

Exceptions 3

Doctrine\DBAL\Exception\ TableNotFoundException

Show exception properties
Doctrine\DBAL\Exception\TableNotFoundException {#1579
  -query: Doctrine\DBAL\Query {#1578
    -sql: "SELECT COUNT(s0_.id) AS sclr_0 FROM staff_messages s0_ WHERE ((s0_.recipient_user_id = ? OR s0_.recipient_user_id IS NULL)) AND s0_.sender_user_id <> ? AND s0_.is_read = false"
    -params: array:2 [
      0 => 1
      1 => 1
    ]
    -types: array:2 [
      0 => "integer"
      1 => "integer"
    ]
  }
}
  1. case '42703':
  2. return new InvalidFieldNameException($exception, $query);
  3. case '42P01':
  4. return new TableNotFoundException($exception, $query);
  5. case '42P07':
  6. return new TableExistsException($exception, $query);
  7. case '08006':
  1. private function handleDriverException(
  2. Driver\Exception $driverException,
  3. ?Query $query,
  4. ): DriverException {
  5. $this->exceptionConverter ??= $this->driver->getExceptionConverter();
  6. $exception = $this->exceptionConverter->convert($driverException, $query);
  7. if ($exception instanceof ConnectionLost) {
  8. $this->close();
  9. }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 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. }
  8. /** @internal */
  9. final public function convertException(Driver\Exception $e): DriverException
  10. {
in vendor/doctrine/dbal/src/Connection.php -> convertExceptionDuringQuery (line 809)
  1. $result = $connection->query($sql);
  2. }
  3. return new Result($result, $this);
  4. } catch (Driver\Exception $e) {
  5. throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
  6. }
  7. }
  8. /**
  9. * Executes a caching query.
  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. );
  5. return $executor->execute($this->em->getConnection(), $sqlParams, $types);
  6. }
  7. /**
  8. * @param array<string,mixed> $sqlParams
  9. * @param array<string,Type> $types
  1. $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2. $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3. };
  4. }
  5. $stmt = $this->_doExecute();
  6. if (is_numeric($stmt)) {
  7. $setCacheEntry($stmt);
  8. 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. }
  5. return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  6. }
  7. /**
  8. * Execute query ignoring second level cache.
  9. *
  1. * @throws NonUniqueResultException If the query result is not unique.
  2. * @throws NoResultException If the query returned no result.
  3. */
  4. public function getSingleResult(string|int|null $hydrationMode = null): mixed
  5. {
  6. $result = $this->execute(null, $hydrationMode);
  7. if ($this->hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
  8. throw new NoResultException();
  9. }
in vendor/doctrine/orm/src/AbstractQuery.php -> getSingleResult (line 801)
  1. * @throws NoResultException If the query returned no result.
  2. * @throws NonUniqueResultException If the query result is not unique.
  3. */
  4. public function getSingleScalarResult(): mixed
  5. {
  6. return $this->getSingleResult(self::HYDRATE_SINGLE_SCALAR);
  7. }
  8. /**
  9. * Sets a query hint. If the hint name is not recognized, it is silently ignored.
  10. *
AbstractQuery->getSingleScalarResult() in src/Controller/Admin/StaffInboxController.php (line 179)
  1. ->select('COUNT(m.id)')
  2. ->where('(m.recipientUserId = :me OR m.recipientUserId IS NULL)')
  3. ->andWhere('m.senderUserId != :me')
  4. ->andWhere('m.isRead = false')
  5. ->setParameter('me', $me->getId())
  6. ->getQuery()->getSingleScalarResult();
  7. return new JsonResponse(['count' => $count]);
  8. }
  9. /** @return User[] Staff actif de l'organisation, excluant $excludeId */
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  4. // call controller
  5. $response = $controller(...$arguments);
  6. // view
  7. if (!$response instanceof Response) {
  8. $event = new ViewEvent($this, $request, $type, $response, $event);
  9. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  2. $this->requestStack->push($request);
  3. $response = null;
  4. try {
  5. return $response = $this->handleRaw($request, $type);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  4. try {
  5. return $this->getHttpKernel()->handle($request, $type, $catch);
  6. } finally {
  7. --$this->requestStackSize;
  8. }
  9. }
  1. ) {
  2. }
  3. public function run(): int
  4. {
  5. $response = $this->kernel->handle($this->request);
  6. $response->send(false);
  7. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
  8. fastcgi_finish_request();
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  2. exit(
  3. $runtime
  4. ->getRunner($app)
  5. ->run()
  6. );
require_once('/var/www/html/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  2. use App\Kernel;
  3. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  4. return function (array $context) {
  5. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  6. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "staff_messages" does not exist LINE 1: SELECT COUNT(s0_.id) AS sclr_0 FROM staff_messages s0_ WHERE... ^

  1. } else {
  2. $code = $exception->getCode();
  3. $sqlState = null;
  4. }
  5. return new self($exception->getMessage(), $sqlState, $code, $exception);
  6. }
  7. }
  1. public function execute(): Result
  2. {
  3. try {
  4. $this->stmt->execute();
  5. } catch (PDOException $exception) {
  6. throw Exception::new($exception);
  7. }
  8. return new Result($this->stmt);
  9. }
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  3. public function execute(): Result
  4. {
  5. return $this->wrappedStatement->execute();
  6. }
  7. }
  1. 'sql' => $this->sql,
  2. 'params' => $this->params,
  3. 'types' => $this->types,
  4. ]);
  5. return parent::execute();
  6. }
  7. }
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  3. public function execute(): Result
  4. {
  5. return $this->wrappedStatement->execute();
  6. }
  7. }
  1. $this->stopwatch?->start('doctrine', 'doctrine');
  2. $query->start();
  3. try {
  4. return parent::execute();
  5. } finally {
  6. $query->stop();
  7. $this->stopwatch?->stop('doctrine');
  8. }
  9. }
  1. $stmt = $connection->prepare($sql);
  2. $this->bindParameters($stmt, $params, $types);
  3. $result = $stmt->execute();
  4. } else {
  5. $result = $connection->query($sql);
  6. }
  7. return new Result($result, $this);
  1. /**
  2. * {@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. );
  5. return $executor->execute($this->em->getConnection(), $sqlParams, $types);
  6. }
  7. /**
  8. * @param array<string,mixed> $sqlParams
  9. * @param array<string,Type> $types
  1. $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2. $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3. };
  4. }
  5. $stmt = $this->_doExecute();
  6. if (is_numeric($stmt)) {
  7. $setCacheEntry($stmt);
  8. 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. }
  5. return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  6. }
  7. /**
  8. * Execute query ignoring second level cache.
  9. *
  1. * @throws NonUniqueResultException If the query result is not unique.
  2. * @throws NoResultException If the query returned no result.
  3. */
  4. public function getSingleResult(string|int|null $hydrationMode = null): mixed
  5. {
  6. $result = $this->execute(null, $hydrationMode);
  7. if ($this->hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
  8. throw new NoResultException();
  9. }
in vendor/doctrine/orm/src/AbstractQuery.php -> getSingleResult (line 801)
  1. * @throws NoResultException If the query returned no result.
  2. * @throws NonUniqueResultException If the query result is not unique.
  3. */
  4. public function getSingleScalarResult(): mixed
  5. {
  6. return $this->getSingleResult(self::HYDRATE_SINGLE_SCALAR);
  7. }
  8. /**
  9. * Sets a query hint. If the hint name is not recognized, it is silently ignored.
  10. *
AbstractQuery->getSingleScalarResult() in src/Controller/Admin/StaffInboxController.php (line 179)
  1. ->select('COUNT(m.id)')
  2. ->where('(m.recipientUserId = :me OR m.recipientUserId IS NULL)')
  3. ->andWhere('m.senderUserId != :me')
  4. ->andWhere('m.isRead = false')
  5. ->setParameter('me', $me->getId())
  6. ->getQuery()->getSingleScalarResult();
  7. return new JsonResponse(['count' => $count]);
  8. }
  9. /** @return User[] Staff actif de l'organisation, excluant $excludeId */
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  4. // call controller
  5. $response = $controller(...$arguments);
  6. // view
  7. if (!$response instanceof Response) {
  8. $event = new ViewEvent($this, $request, $type, $response, $event);
  9. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  2. $this->requestStack->push($request);
  3. $response = null;
  4. try {
  5. return $response = $this->handleRaw($request, $type);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  4. try {
  5. return $this->getHttpKernel()->handle($request, $type, $catch);
  6. } finally {
  7. --$this->requestStackSize;
  8. }
  9. }
  1. ) {
  2. }
  3. public function run(): int
  4. {
  5. $response = $this->kernel->handle($this->request);
  6. $response->send(false);
  7. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
  8. fastcgi_finish_request();
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  2. exit(
  3. $runtime
  4. ->getRunner($app)
  5. ->run()
  6. );
require_once('/var/www/html/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  2. use App\Kernel;
  3. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  4. return function (array $context) {
  5. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  6. };

PDOException

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "staff_messages" does not exist LINE 1: SELECT COUNT(s0_.id) AS sclr_0 FROM staff_messages s0_ WHERE... ^

  1. }
  2. public function execute(): Result
  3. {
  4. try {
  5. $this->stmt->execute();
  6. } catch (PDOException $exception) {
  7. throw Exception::new($exception);
  8. }
  9. return new Result($this->stmt);
  1. }
  2. public function execute(): Result
  3. {
  4. try {
  5. $this->stmt->execute();
  6. } catch (PDOException $exception) {
  7. throw Exception::new($exception);
  8. }
  9. return new Result($this->stmt);
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  3. public function execute(): Result
  4. {
  5. return $this->wrappedStatement->execute();
  6. }
  7. }
  1. 'sql' => $this->sql,
  2. 'params' => $this->params,
  3. 'types' => $this->types,
  4. ]);
  5. return parent::execute();
  6. }
  7. }
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  3. public function execute(): Result
  4. {
  5. return $this->wrappedStatement->execute();
  6. }
  7. }
  1. $this->stopwatch?->start('doctrine', 'doctrine');
  2. $query->start();
  3. try {
  4. return parent::execute();
  5. } finally {
  6. $query->stop();
  7. $this->stopwatch?->stop('doctrine');
  8. }
  9. }
  1. $stmt = $connection->prepare($sql);
  2. $this->bindParameters($stmt, $params, $types);
  3. $result = $stmt->execute();
  4. } else {
  5. $result = $connection->query($sql);
  6. }
  7. return new Result($result, $this);
  1. /**
  2. * {@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. );
  5. return $executor->execute($this->em->getConnection(), $sqlParams, $types);
  6. }
  7. /**
  8. * @param array<string,mixed> $sqlParams
  9. * @param array<string,Type> $types
  1. $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2. $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3. };
  4. }
  5. $stmt = $this->_doExecute();
  6. if (is_numeric($stmt)) {
  7. $setCacheEntry($stmt);
  8. 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. }
  5. return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  6. }
  7. /**
  8. * Execute query ignoring second level cache.
  9. *
  1. * @throws NonUniqueResultException If the query result is not unique.
  2. * @throws NoResultException If the query returned no result.
  3. */
  4. public function getSingleResult(string|int|null $hydrationMode = null): mixed
  5. {
  6. $result = $this->execute(null, $hydrationMode);
  7. if ($this->hydrationMode !== self::HYDRATE_SINGLE_SCALAR && ! $result) {
  8. throw new NoResultException();
  9. }
in vendor/doctrine/orm/src/AbstractQuery.php -> getSingleResult (line 801)
  1. * @throws NoResultException If the query returned no result.
  2. * @throws NonUniqueResultException If the query result is not unique.
  3. */
  4. public function getSingleScalarResult(): mixed
  5. {
  6. return $this->getSingleResult(self::HYDRATE_SINGLE_SCALAR);
  7. }
  8. /**
  9. * Sets a query hint. If the hint name is not recognized, it is silently ignored.
  10. *
AbstractQuery->getSingleScalarResult() in src/Controller/Admin/StaffInboxController.php (line 179)
  1. ->select('COUNT(m.id)')
  2. ->where('(m.recipientUserId = :me OR m.recipientUserId IS NULL)')
  3. ->andWhere('m.senderUserId != :me')
  4. ->andWhere('m.isRead = false')
  5. ->setParameter('me', $me->getId())
  6. ->getQuery()->getSingleScalarResult();
  7. return new JsonResponse(['count' => $count]);
  8. }
  9. /** @return User[] Staff actif de l'organisation, excluant $excludeId */
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  4. // call controller
  5. $response = $controller(...$arguments);
  6. // view
  7. if (!$response instanceof Response) {
  8. $event = new ViewEvent($this, $request, $type, $response, $event);
  9. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  2. $this->requestStack->push($request);
  3. $response = null;
  4. try {
  5. return $response = $this->handleRaw($request, $type);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  4. try {
  5. return $this->getHttpKernel()->handle($request, $type, $catch);
  6. } finally {
  7. --$this->requestStackSize;
  8. }
  9. }
  1. ) {
  2. }
  3. public function run(): int
  4. {
  5. $response = $this->kernel->handle($this->request);
  6. $response->send(false);
  7. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
  8. fastcgi_finish_request();
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  2. exit(
  3. $runtime
  4. ->getRunner($app)
  5. ->run()
  6. );
require_once('/var/www/html/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  2. use App\Kernel;
  3. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  4. return function (array $context) {
  5. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  6. };

Logs

Level Channel Message
INFO 00:30:14 deprecation User Deprecated: Since api-platform/symfony 4.1: The "api_platform.validator.query_parameter_validator" service is deprecated use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
{
    "exception": {}
}
INFO 00:30:14 deprecation User Deprecated: Since api-platform/core 3.4: The class "ApiPlatform\ParameterValidator\ParameterValidator" is deprecated, use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
{
    "exception": {}
}
INFO 00:30:14 deprecation User Deprecated: Since api-platform/core 3.4: The class "ApiPlatform\ParameterValidator\Validator\ArrayItems" is deprecated, use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
{
    "exception": {}
}
INFO 00:30:14 deprecation User Deprecated: Since api-platform/core 3.4: The class "ApiPlatform\ParameterValidator\Validator\Bounds" is deprecated, use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
{
    "exception": {}
}
INFO 00:30:14 deprecation User Deprecated: Since api-platform/core 3.4: The class "ApiPlatform\ParameterValidator\Validator\Enum" is deprecated, use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
{
    "exception": {}
}
INFO 00:30:14 deprecation User Deprecated: Since api-platform/core 3.4: The class "ApiPlatform\ParameterValidator\Validator\Length" is deprecated, use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
{
    "exception": {}
}
INFO 00:30:14 deprecation User Deprecated: Since api-platform/core 3.4: The class "ApiPlatform\ParameterValidator\Validator\MultipleOf" is deprecated, use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
{
    "exception": {}
}
INFO 00:30:14 deprecation User Deprecated: Since api-platform/core 3.4: The class "ApiPlatform\ParameterValidator\Validator\Pattern" is deprecated, use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
{
    "exception": {}
}
INFO 00:30:14 deprecation User Deprecated: Since api-platform/core 3.4: The class "ApiPlatform\ParameterValidator\Validator\Required" is deprecated, use "\ApiPlatform\Metadata\Parameter::$constraints" instead.
{
    "exception": {}
}
INFO 00:30:14 deprecation User Deprecated: Since api-platform/core 3.4: Injecting the "ApiPlatform\JsonSchema\TypeFactoryInterface" inside "ApiPlatform\JsonSchema\SchemaFactory" is deprecated and "ApiPlatform\JsonSchema\TypeFactoryInterface" will be removed in 4.x.
{
    "exception": {}
}
INFO 00:30:14 doctrine Connecting with parameters {params}
{
    "params": {
        "driver": "pdo_pgsql",
        "charset": "utf8",
        "idle_connection_ttl": 600,
        "host": "db",
        "port": 5432,
        "user": "sm_user",
        "password": "<redacted>",
        "driverOptions": {
            "2": 30
        },
        "serverVersion": "16",
        "defaultTableOptions": {
            "charset": "utf8",
            "collate": "utf8_unicode_ci"
        },
        "dbname": "synagogue_manager_central"
    }
}
DEBUG 00:30:14 doctrine Executing statement: SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.level AS level_4, t0.db_name AS db_name_5, t0.vault_key_id AS vault_key_id_6, t0.default_locale AS default_locale_7, t0.available_locales AS available_locales_8, t0.plan AS plan_9, t0.max_families AS max_families_10, t0.monthly_sms_budget AS monthly_sms_budget_11, t0.payment_gateway AS payment_gateway_12, t0.logo_path AS logo_path_13, t0.slug AS slug_14, t0.primary_color AS primary_color_15, t0.president_name AS president_name_16, t0.subdomain_enabled AS subdomain_enabled_17, t0.custom_domain AS custom_domain_18, t0.street_number AS street_number_19, t0.address AS address_20, t0.city AS city_21, t0.zip AS zip_22, t0.country AS country_23, t0.timezone AS timezone_24, t0.latitude AS latitude_25, t0.longitude AS longitude_26, t0.reference_city AS reference_city_27, t0.phone AS phone_28, t0.email AS email_29, t0.website AS website_30, t0.siret AS siret_31, t0.stripe_customer_id AS stripe_customer_id_32, t0.stripe_subscription_id AS stripe_subscription_id_33, t0.is_active AS is_active_34, t0.has_cemetery_module AS has_cemetery_module_35, t0.has_wordpress_hosting AS has_wordpress_hosting_36, t0.consistoire_reverse_percent AS consistoire_reverse_percent_37, t0.consistoire_sharing_level AS consistoire_sharing_level_38, t0.fundraising_settings AS fundraising_settings_39, t0.pastoral_age_threshold AS pastoral_age_threshold_40, t0.created_at AS created_at_41, t0.trial_ends_at AS trial_ends_at_42, t0.parent_id AS parent_id_43 FROM organizations t0 WHERE t0.custom_domain = ? AND t0.is_active = ? LIMIT 1 (parameters: {params}, types: {types})

                            
INFO 00:30:14 request Matched route "_profiler".
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "64a16f"
    },
    "request_uri": "https://managmulhouse.avinconcept.fr/_profiler/64a16f",
    "method": "GET"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "Symfony\UX\Turbo\Request\RequestListener::__invoke".
{
    "event": "kernel.request",
    "listener": "Symfony\\UX\\Turbo\\Request\\RequestListener::__invoke"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Nelmio\\CorsBundle\\EventListener\\CorsListener::onKernelRequest"
}
DEBUG 00:30:14 event 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 00:30:14 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "App\EventListener\TenantRequestListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "App\\EventListener\\TenantRequestListener::onKernelRequest"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "ApiPlatform\Symfony\EventListener\AddFormatListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "ApiPlatform\\Symfony\\EventListener\\AddFormatListener::onKernelRequest"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "ApiPlatform\Symfony\EventListener\QueryParameterValidateListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "ApiPlatform\\Symfony\\EventListener\\QueryParameterValidateListener::onKernelRequest"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "App\EventListener\HostOrganizationAccessListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "App\\EventListener\\HostOrganizationAccessListener::onKernelRequest"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "ApiPlatform\Symfony\EventListener\ReadListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "ApiPlatform\\Symfony\\EventListener\\ReadListener::onKernelRequest"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "ApiPlatform\Symfony\EventListener\DeserializeListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "ApiPlatform\\Symfony\\EventListener\\DeserializeListener::onKernelRequest"
}
DEBUG 00:30:14 event Notified event "kernel.request" to listener "Knp\Bundle\PaginatorBundle\Subscriber\SlidingPaginationSubscriber::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Knp\\Bundle\\PaginatorBundle\\Subscriber\\SlidingPaginationSubscriber::onKernelRequest"
}
DEBUG 00:30:14 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 00:30:14 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 00:30:14 event 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 00:30:14 event 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 00:30:14 event 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 00:30:14 event 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 00:30:14 event Notified event "kernel.controller_arguments" to listener "ContainerU9zDAjQ\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "ContainerU9zDAjQ\\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
}
DEBUG 00:30:14 event 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] TableNotFoundException
Doctrine\DBAL\Exception\TableNotFoundException:
An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "staff_messages" does not exist
LINE 1: SELECT COUNT(s0_.id) AS sclr_0 FROM staff_messages s0_ WHERE...
                                            ^

  at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:72
  at Doctrine\DBAL\Driver\API\PostgreSQL\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 COUNT(s0_.id) AS sclr_0 FROM staff_messages s0_ WHERE ((s0_.recipient_user_id = ? OR s0_.recipient_user_id IS NULL)) AND s0_.sender_user_id <> ? AND s0_.is_read = false', array(1, 1), array('integer', 'integer'))
     (vendor/doctrine/dbal/src/Connection.php:809)
  at Doctrine\DBAL\Connection->executeQuery('SELECT COUNT(s0_.id) AS sclr_0 FROM staff_messages s0_ WHERE ((s0_.recipient_user_id = ? OR s0_.recipient_user_id IS NULL)) AND s0_.sender_user_id <> ? AND s0_.is_read = false', array(1, 1), array('integer', 'integer'), null)
     (vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27)
  at Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute(object(Connection), array(1, 1), array('integer', 'integer'))
     (vendor/doctrine/orm/src/Query.php:296)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 4)
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute(null, 4)
     (vendor/doctrine/orm/src/AbstractQuery.php:772)
  at Doctrine\ORM\AbstractQuery->getSingleResult(4)
     (vendor/doctrine/orm/src/AbstractQuery.php:801)
  at Doctrine\ORM\AbstractQuery->getSingleScalarResult()
     (src/Controller/Admin/StaffInboxController.php:179)
  at App\Controller\Admin\StaffInboxController->badge()
     (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:34)
  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[42P01]: Undefined table: 7 ERROR:  relation "staff_messages" does not exist
LINE 1: SELECT COUNT(s0_.id) AS sclr_0 FROM staff_messages s0_ WHERE...
                                            ^

  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 COUNT(s0_.id) AS sclr_0 FROM staff_messages s0_ WHERE ((s0_.recipient_user_id = ? OR s0_.recipient_user_id IS NULL)) AND s0_.sender_user_id <> ? AND s0_.is_read = false', array(1, 1), array('integer', 'integer'), null)
     (vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27)
  at Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute(object(Connection), array(1, 1), array('integer', 'integer'))
     (vendor/doctrine/orm/src/Query.php:296)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 4)
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute(null, 4)
     (vendor/doctrine/orm/src/AbstractQuery.php:772)
  at Doctrine\ORM\AbstractQuery->getSingleResult(4)
     (vendor/doctrine/orm/src/AbstractQuery.php:801)
  at Doctrine\ORM\AbstractQuery->getSingleScalarResult()
     (src/Controller/Admin/StaffInboxController.php:179)
  at App\Controller\Admin\StaffInboxController->badge()
     (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:34)
  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[42P01]: Undefined table: 7 ERROR:  relation "staff_messages" does not exist
LINE 1: SELECT COUNT(s0_.id) AS sclr_0 FROM staff_messages s0_ WHERE...
                                            ^

  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 COUNT(s0_.id) AS sclr_0 FROM staff_messages s0_ WHERE ((s0_.recipient_user_id = ? OR s0_.recipient_user_id IS NULL)) AND s0_.sender_user_id <> ? AND s0_.is_read = false', array(1, 1), array('integer', 'integer'), null)
     (vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:27)
  at Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute(object(Connection), array(1, 1), array('integer', 'integer'))
     (vendor/doctrine/orm/src/Query.php:296)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 4)
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute(null, 4)
     (vendor/doctrine/orm/src/AbstractQuery.php:772)
  at Doctrine\ORM\AbstractQuery->getSingleResult(4)
     (vendor/doctrine/orm/src/AbstractQuery.php:801)
  at Doctrine\ORM\AbstractQuery->getSingleScalarResult()
     (src/Controller/Admin/StaffInboxController.php:179)
  at App\Controller\Admin\StaffInboxController->badge()
     (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:34)
  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)