Error 500 Internal Server Error

GET https://clevernursery.com/?_locale=ar_DZ

IP
162.158.91.62
Profiled on
Token
26722f

ErrorController

Request

GET Parameters

Key Value
_locale 
"ar_DZ"

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller 
"error_controller"
_links 
Symfony\Component\WebLink\GenericLinkProvider {#1537
  -links: [
    1536 => Symfony\Component\WebLink\Link {#1536
      -href: "https://clevernursery.com/api/docs.jsonld"
      -rel: [
        "http://www.w3.org/ns/hydra/core#apiDocumentation" => "http://www.w3.org/ns/hydra/core#apiDocumentation"
      ]
      -attributes: []
    }
  ]
}
_stopwatch_token 
"046519"
exception 
Doctrine\DBAL\Exception\ConnectionException {#1299
  #message: """
    An exception occurred in the driver: SQLSTATE[08006] [7] could not connect to server: Connection refused\n
    \tIs the server running on host "144.91.92.76" and accepting\n
    \tTCP/IP connections on port 5432?
    """
  #code: 7
  #file: "/var/www/clevernursery.com/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php"
  #line: 77
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#1307 …}
  -query: null
  trace: {
    /var/www/clevernursery.com/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:77 {
      Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
      ›     case '08006':
      ›         return new ConnectionException($exception, $query);
      › }
    }
    /var/www/clevernursery.com/vendor/doctrine/dbal/src/Connection.php:1938 {
      Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
      › $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
      › $exception                  = $this->exceptionConverter->convert($driverException, $query);
      › 
    }
    /var/www/clevernursery.com/vendor/doctrine/dbal/src/Connection.php:1886 {
      Doctrine\DBAL\Connection->convertException(Exception $e): DriverException …
      › {
      ›     return $this->handleDriverException($e, null);
      › }
    }
    /var/www/clevernursery.com/vendor/doctrine/dbal/src/Connection.php:379 {
      Doctrine\DBAL\Connection->connect() …
      › } catch (Driver\Exception $e) {
      ›     throw $this->convertException($e);
      › }
    }
    /var/www/clevernursery.com/vendor/doctrine/dbal/src/Connection.php:1654 {
      Doctrine\DBAL\Connection->getWrappedConnection() …
      › 
      › $this->connect();
      › 
    }
    /var/www/clevernursery.com/vendor/doctrine/dbal/src/Connection.php:1081 {
      Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], $types = [], QueryCacheProfile $qcp = null): Result …
      › 
      › $connection = $this->getWrappedConnection();
      › 
    }
    /var/www/clevernursery.com/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:939 {
      Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll(array $criteria = [], array $orderBy = null, $limit = null, $offset = null) …
      › [$params, $types] = $this->expandParameters($criteria);
      › $stmt             = $this->conn->executeQuery($sql, $params, $types);
      › 
    }
    /var/www/clevernursery.com/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:225 {
      Doctrine\ORM\EntityRepository->findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null) …
      › 
      ›     return $persister->loadAll($criteria, $orderBy, $limit, $offset);
      › }
    }
    /var/www/clevernursery.com/src/Controller/App/AppController.php:51 {
      App\Controller\App\AppController->index(Request $request, FollowerRepository $followerRepository, BlogService $blog): Response …
      › 'controller_name' => 'AppController',
      › 'products' => $this->prodRepo->findBy([], ['price' => 'ASC']),
      › 'form' => $form->createView(),
    }
    /var/www/clevernursery.com/vendor/symfony/http-kernel/HttpKernel.php:163 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › // call controller
      › $response = $controller(...$arguments);
      › 
    }
    /var/www/clevernursery.com/vendor/symfony/http-kernel/HttpKernel.php:74 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
      › try {
      ›     return $this->handleRaw($request, $type);
      › } catch (\Throwable $e) {
    }
    /var/www/clevernursery.com/vendor/symfony/http-kernel/Kernel.php:184 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
      › try {
      ›     return $this->getHttpKernel()->handle($request, $type, $catch);
      › } finally {
    }
    /var/www/clevernursery.com/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
      Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
      › {
      ›     $response = $this->kernel->handle($this->request);
      ›     $response->send();
    }
    /var/www/clevernursery.com/vendor/autoload_runtime.php:29 {
      require_once …
      ›         ->getRunner($app)
      ›         ->run()
      › );
    }
    /var/www/clevernursery.com/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
      › 
      arguments: {
        "/var/www/clevernursery.com/vendor/autoload_runtime.php"
      }
    }
  }
}
logger 
Symfony\Bridge\Monolog\Logger {#155 …9}

Request Headers

Header Value
accept 
"*/*"
accept-encoding 
"gzip, br"
cdn-loop 
"cloudflare; loops=1"
cf-connecting-ip 
"20.171.207.195"
cf-ipcountry 
"US"
cf-ray 
"986306ca6947b6c9-LAX"
cf-visitor 
"{"scheme":"https"}"
connection 
"Keep-Alive"
content-length 
""
content-type 
""
from 
"gptbot(at)openai.com"
host 
"clevernursery.com"
user-agent 
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)"
x-forwarded-for 
"20.171.207.195"
x-forwarded-proto 
"https"
x-openai-host-hash 
"161494255"
x-php-ob-level 
"1"

Request Content

Request content not available (it was retrieved as a resource).

Response

Response Headers

Header Value
cache-control 
"no-cache, private"
content-type 
"text/html; charset=UTF-8"
date 
"Sun, 28 Sep 2025 11:51:02 GMT"
vary 
"Accept"
x-debug-exception 
"An%20exception%20occurred%20in%20the%20driver%3A%20SQLSTATE%5B08006%5D%20%5B7%5D%20could%20not%20connect%20to%20server%3A%20Connection%20refused%0A%09Is%20the%20server%20running%20on%20host%20%22144.91.92.76%22%20and%20accepting%0A%09TCP%2FIP%20connections%20on%20port%205432%3F"
x-debug-exception-file 
"%2Fvar%2Fwww%2Fclevernursery.com%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FPostgreSQL%2FExceptionConverter.php:77"
x-debug-token 
"26722f"

Cookies

Request Cookies

No request cookies

Response Cookies

No response cookies

Session 1

Session Metadata

No session metadata

Session Attributes

No session attributes

Session Usage

1 Usages
Stateless check enabled
Usage
Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage:41
Show trace 
[
  [
    "file" => "/var/www/clevernursery.com/vendor/symfony/security-core/Authentication/Token/Storage/UsageTrackingTokenStorage.php"
    "line" => 41
    "function" => "getMetadataBag"
    "class" => "Symfony\Component\HttpFoundation\Session\Session"
    "type" => "->"
  ]
  [
    "file" => "/var/www/clevernursery.com/src/EventSubscriber/ControllerListenerSubscriber.php"
    "line" => 42
    "function" => "getToken"
    "class" => "Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage"
    "type" => "->"
  ]
  [
    "file" => "/var/www/clevernursery.com/vendor/symfony/event-dispatcher/Debug/WrappedListener.php"
    "line" => 116
    "function" => "onKernelController"
    "class" => "App\EventSubscriber\ControllerListenerSubscriber"
    "type" => "->"
  ]
  [
    "file" => "/var/www/clevernursery.com/vendor/symfony/event-dispatcher/EventDispatcher.php"
    "line" => 206
    "function" => "__invoke"
    "class" => "Symfony\Component\EventDispatcher\Debug\WrappedListener"
    "type" => "->"
  ]
  [
    "file" => "/var/www/clevernursery.com/vendor/symfony/event-dispatcher/EventDispatcher.php"
    "line" => 56
    "function" => "callListeners"
    "class" => "Symfony\Component\EventDispatcher\EventDispatcher"
    "type" => "->"
  ]
  [
    "file" => "/var/www/clevernursery.com/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php"
    "line" => 127
    "function" => "dispatch"
    "class" => "Symfony\Component\EventDispatcher\EventDispatcher"
    "type" => "->"
  ]
  [
    "file" => "/var/www/clevernursery.com/vendor/symfony/http-kernel/HttpKernel.php"
    "line" => 151
    "function" => "dispatch"
    "class" => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher"
    "type" => "->"
  ]
  [
    "file" => "/var/www/clevernursery.com/vendor/symfony/http-kernel/HttpKernel.php"
    "line" => 74
    "function" => "handleRaw"
    "class" => "Symfony\Component\HttpKernel\HttpKernel"
    "type" => "->"
  ]
  [
    "file" => "/var/www/clevernursery.com/vendor/symfony/http-kernel/Kernel.php"
    "line" => 184
    "function" => "handle"
    "class" => "Symfony\Component\HttpKernel\HttpKernel"
    "type" => "->"
  ]
  [
    "file" => "/var/www/clevernursery.com/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php"
    "line" => 35
    "function" => "handle"
    "class" => "Symfony\Component\HttpKernel\Kernel"
    "type" => "->"
  ]
  [
    "file" => "/var/www/clevernursery.com/vendor/autoload_runtime.php"
    "line" => 29
    "function" => "run"
    "class" => "Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner"
    "type" => "->"
  ]
  [
    "file" => "/var/www/clevernursery.com/public/index.php"
    "line" => 5
    "args" => [
      "/var/www/clevernursery.com/vendor/autoload_runtime.php"
    ]
    "function" => "require_once"
  ]
]

Flashes

Flashes

No flash messages were created.

Server Parameters

Server Parameters

Defined in .env

Key Value
APP_ENV 
"dev"
APP_SECRET 
"dcf2e89fddf2ba09fb25a5582a777a8e"
CORS_ALLOW_ORIGIN 
"^https?://(localhost|127\.0\.0\.1)(:[0-9]+)?$"
DATABASE_URL 
"postgresql://medicaalgerie:[email protected]:5432/clevernursery?serverVersion=12&charset=utf8"
JWT_PASSPHRASE 
"7bfc5e8427b7830392f4f3e143105f2b"
JWT_PUBLIC_KEY 
"%kernel.project_dir%/config/jwt/public.pem"
JWT_SECRET_KEY 
"%kernel.project_dir%/config/jwt/private.pem"
MAILER_DSN 
"null://null"
MESSENGER_TRANSPORT_DSN 
"doctrine://default?auto_setup=0"
OAUTH_FACEBOOK_ID 
"3119588744928385"
OAUTH_FACEBOOK_SECRET 
"11fc665a4ca260e2574d4987c5904c15"
OAUTH_GOOGLE_CLIENT_ID 
"1005499217043-um6ob6s9bsahqgt0ahqka7bec68quaem.apps.googleusercontent.com"
OAUTH_GOOGLE_CLIENT_SECRET 
"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"

Defined as regular env variables

Key Value
APP_DEBUG 
"1"
CONTENT_LENGTH 
""
CONTENT_TYPE 
""
DOCUMENT_ROOT 
"/var/www/clevernursery.com/public"
DOCUMENT_URI 
"/index.php"
FCGI_ROLE 
"RESPONDER"
GATEWAY_INTERFACE 
"CGI/1.1"
HOME 
"/var/www"
HTTPS 
"on"
HTTP_ACCEPT 
"*/*"
HTTP_ACCEPT_ENCODING 
"gzip, br"
HTTP_CDN_LOOP 
"cloudflare; loops=1"
HTTP_CF_CONNECTING_IP 
"20.171.207.195"
HTTP_CF_IPCOUNTRY 
"US"
HTTP_CF_RAY 
"986306ca6947b6c9-LAX"
HTTP_CF_VISITOR 
"{"scheme":"https"}"
HTTP_CONNECTION 
"Keep-Alive"
HTTP_FROM 
"gptbot(at)openai.com"
HTTP_HOST 
"clevernursery.com"
HTTP_USER_AGENT 
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)"
HTTP_X_FORWARDED_FOR 
"20.171.207.195"
HTTP_X_FORWARDED_PROTO 
"https"
HTTP_X_OPENAI_HOST_HASH 
"161494255"
PATH_INFO 
""
PHP_SELF 
"/index.php"
QUERY_STRING 
"_locale=ar_DZ"
REDIRECT_STATUS 
"200"
REMOTE_ADDR 
"162.158.91.62"
REMOTE_PORT 
"56800"
REMOTE_USER 
""
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"https"
REQUEST_TIME 
1759060261
REQUEST_TIME_FLOAT 
1759060261.885
REQUEST_URI 
"/?_locale=ar_DZ"
SCRIPT_FILENAME 
"/var/www/clevernursery.com/public/index.php"
SCRIPT_NAME 
"/index.php"
SERVER_ADDR 
"144.91.92.76"
SERVER_NAME 
"clevernursery.com"
SERVER_PORT 
"443"
SERVER_PROTOCOL 
"HTTP/1.1"
SERVER_SOFTWARE 
"nginx/1.24.0"
SYMFONY_DOTENV_VARS 
"APP_ENV,APP_SECRET,MESSENGER_TRANSPORT_DSN,DATABASE_URL,MAILER_DSN,CORS_ALLOW_ORIGIN,JWT_SECRET_KEY,JWT_PUBLIC_KEY,JWT_PASSPHRASE,OAUTH_FACEBOOK_ID,OAUTH_FACEBOOK_SECRET,OAUTH_GOOGLE_CLIENT_ID,OAUTH_GOOGLE_CLIENT_SECRET"
USER 
"www-data"

Parent Request

Return to parent request (token = 071cbb)

Key Value
_controller 
"App\Controller\App\AppController::index"
_firewall_context 
"security.firewall.map.context.main"
_links 
Symfony\Component\WebLink\GenericLinkProvider {#1601
  -links: [
    1602 => Symfony\Component\WebLink\Link {#1602
      -href: "https://clevernursery.com/api/docs.jsonld"
      -rel: [
        "http://www.w3.org/ns/hydra/core#apiDocumentation" => "http://www.w3.org/ns/hydra/core#apiDocumentation"
      ]
      -attributes: []
    }
  ]
}
_remove_csp_headers 
true
_route 
"app"
_route_params 
[]
_security_firewall_run 
"_security_main"
_stopwatch_token 
"9ce58f"