https://dev.ehymns.org/top5

HymnsController :: top5

Request

GET Parameters

No GET parameters

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller
"App\Controller\HymnsController::top5"
_firewall_context
"security.firewall.map.context.main"
_remove_csp_headers
true
_route
"hymnsTop5"
_route_params
[]
_security_firewall_run
"_security_main"
_stopwatch_token
"67c686"

Request Headers

Header Value
accept
"*/*"
accept-encoding
"gzip, br, deflate"
cookie
"PHPSESSID=dlibm6thc45ebocgk7rc046j2n"
from
"gptbot(at)openai.com"
host
"dev.ehymns.org"
user-agent
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)"
x-openai-host-hash
"466939863"
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, 14 Sep 2025 18:49:57 GMT"
vary
"Accept"
x-debug-exception
"An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5B42S02%5D%3A%20Base%20table%20or%20view%20not%20found%3A%201146%20Table%20%27dev_ehymns.v_hymntypes%27%20doesn%27t%20exist"
x-debug-exception-file
"%2Fvar%2Fwww%2Fdev.ehymns%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FMySQL%2FExceptionConverter.php:49"
x-debug-token
"975860"
x-debug-token-link
"https://dev.ehymns.org/_profiler/19a41e"
x-previous-debug-token
"19a41e"
x-robots-tag
"noindex"

Cookies

Request Cookies

Key Value
PHPSESSID
"dlibm6thc45ebocgk7rc046j2n"

Response Cookies

No response cookies

Session 1

Session Metadata

Key Value
Created
"Sun, 14 Sep 25 14:45:54 -0400"
Last used
"Sun, 14 Sep 25 14:49:51 -0400"
Lifetime
0

Session Attributes

Attribute Value
_csrf/https-admin_dashboard_form
"ZT3Z3HzaMx0jMobtsKTdNk0PA4qYB4GwTo81sbseNnY"
_csrf/https-authenticate
"45Y6FwvQ3npovDTqOoKKNbGJjndZc6YXpx-BJDmiluk"

Session Usage

1 Usages
Stateless check enabled
Usage
Symfony\Component\Security\Http\Firewall\ContextListener:195
[
  [
    "file" => "/var/www/dev.ehymns/vendor/symfony/security-http/Firewall/ContextListener.php"
    "line" => 195
    "function" => "remove"
    "class" => "Symfony\Component\HttpFoundation\Session\Session"
    "type" => "->"
  ]
  [
    "file" => "/var/www/dev.ehymns/vendor/symfony/event-dispatcher/Debug/WrappedListener.php"
    "line" => 118
    "function" => "onKernelResponse"
    "class" => "Symfony\Component\Security\Http\Firewall\ContextListener"
    "type" => "->"
  ]
  [
    "file" => "/var/www/dev.ehymns/vendor/symfony/event-dispatcher/EventDispatcher.php"
    "line" => 230
    "function" => "__invoke"
    "class" => "Symfony\Component\EventDispatcher\Debug\WrappedListener"
    "type" => "->"
  ]
  [
    "file" => "/var/www/dev.ehymns/vendor/symfony/event-dispatcher/EventDispatcher.php"
    "line" => 59
    "function" => "callListeners"
    "class" => "Symfony\Component\EventDispatcher\EventDispatcher"
    "type" => "->"
  ]
  [
    "file" => "/var/www/dev.ehymns/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php"
    "line" => 154
    "function" => "dispatch"
    "class" => "Symfony\Component\EventDispatcher\EventDispatcher"
    "type" => "->"
  ]
  [
    "file" => "/var/www/dev.ehymns/vendor/symfony/http-kernel/HttpKernel.php"
    "line" => 196
    "function" => "dispatch"
    "class" => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher"
    "type" => "->"
  ]
  [
    "file" => "/var/www/dev.ehymns/vendor/symfony/http-kernel/HttpKernel.php"
    "line" => 249
    "function" => "filterResponse"
    "class" => "Symfony\Component\HttpKernel\HttpKernel"
    "type" => "->"
  ]
  [
    "file" => "/var/www/dev.ehymns/vendor/symfony/http-kernel/HttpKernel.php"
    "line" => 86
    "function" => "handleThrowable"
    "class" => "Symfony\Component\HttpKernel\HttpKernel"
    "type" => "->"
  ]
  [
    "file" => "/var/www/dev.ehymns/vendor/symfony/http-kernel/Kernel.php"
    "line" => 202
    "function" => "handle"
    "class" => "Symfony\Component\HttpKernel\HttpKernel"
    "type" => "->"
  ]
  [
    "file" => "/var/www/dev.ehymns/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php"
    "line" => 35
    "function" => "handle"
    "class" => "Symfony\Component\HttpKernel\Kernel"
    "type" => "->"
  ]
  [
    "file" => "/var/www/dev.ehymns/vendor/autoload_runtime.php"
    "line" => 35
    "function" => "run"
    "class" => "Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner"
    "type" => "->"
  ]
  [
    "file" => "/var/www/dev.ehymns/public/index.php"
    "line" => 5
    "args" => [
      "/var/www/dev.ehymns/vendor/autoload_runtime.php"
    ]
    "function" => "require_once"
  ]
]

Flashes

Flashes

No flash messages were created.

Server Parameters

Server Parameters

Defined in .env

Key Value
APP_DEBUG
"1"
APP_ENV
"dev"
APP_SECRET
"2063b3be02f70a5b4f0effa0cb6b6fff"
DATABASE_URL
"mysql://ehymns:uBLoZgABaHqoT405@127.0.0.1:3306/dev_ehymns?serverVersion=5.7"
MAILER_DSN
"gmail://admin@ehymns.org:MyName!1987@localhost"

Defined as regular env variables

Key Value
CONTEXT_DOCUMENT_ROOT
"/var/www/dev.ehymns/public"
CONTEXT_PREFIX
""
DOCUMENT_ROOT
"/var/www/dev.ehymns/public"
GATEWAY_INTERFACE
"CGI/1.1"
HTTPS
"on"
HTTP_ACCEPT
"*/*"
HTTP_ACCEPT_ENCODING
"gzip, br, deflate"
HTTP_COOKIE
"PHPSESSID=dlibm6thc45ebocgk7rc046j2n"
HTTP_FROM
"gptbot(at)openai.com"
HTTP_HOST
"dev.ehymns.org"
HTTP_USER_AGENT
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)"
HTTP_X_OPENAI_HOST_HASH
"466939863"
PATH
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
PHP_SELF
"/index.php"
QUERY_STRING
""
REDIRECT_HTTPS
"on"
REDIRECT_SSL_TLS_SNI
"dev.ehymns.org"
REDIRECT_STATUS
"200"
REDIRECT_URL
"/top5"
REMOTE_ADDR
"20.171.207.214"
REMOTE_PORT
"47076"
REQUEST_METHOD
"GET"
REQUEST_SCHEME
"https"
REQUEST_TIME
1757875797
REQUEST_TIME_FLOAT
1757875797.2084
REQUEST_URI
"/top5"
SCRIPT_FILENAME
"/var/www/dev.ehymns/public/index.php"
SCRIPT_NAME
"/index.php"
SERVER_ADDR
"167.172.230.192"
SERVER_ADMIN
"admin@ehymns.org"
SERVER_NAME
"dev.ehymns.org"
SERVER_PORT
"443"
SERVER_PROTOCOL
"HTTP/1.1"
SERVER_SIGNATURE
"<address>Apache/2.4.64 (Ubuntu) Server at dev.ehymns.org Port 443</address>\n"
SERVER_SOFTWARE
"Apache/2.4.64 (Ubuntu)"
SSL_TLS_SNI
"dev.ehymns.org"
SYMFONY_DOTENV_VARS
"APP_ENV,APP_DEBUG,APP_SECRET,DATABASE_URL,MAILER_DSN"

Sub Requests 1

ErrorController (token = 19a41e)

Key Value
_controller
"error_controller"
_stopwatch_token
"cba463"
exception
Doctrine\DBAL\Exception\TableNotFoundException {#638
  #message: "An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dev_ehymns.v_hymntypes' doesn't exist"
  #code: 1146
  #file: "/var/www/dev.ehymns/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
  #line: 49
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#634 …}
  -query: Doctrine\DBAL\Query {#636 …}
  trace: {
    /var/www/dev.ehymns/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:49 {
      Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
      › case 1146:    return new TableNotFoundException($exception, $query);}
    /var/www/dev.ehymns/vendor/doctrine/dbal/src/Connection.php:1939 {
      Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
      › $this->exceptionConverter ??= $this->_driver->getExceptionConverter();$exception                  = $this->exceptionConverter->convert($driverException, $query);}
    /var/www/dev.ehymns/vendor/doctrine/dbal/src/Connection.php:1881 {
      Doctrine\DBAL\Connection->convertExceptionDuringQuery(Exception $e, string $sql, array $params = [], array $types = []): DriverException …
      › ): DriverException {    return $this->handleDriverException($e, new Query($sql, $params, $types));}
    }
    /var/www/dev.ehymns/vendor/doctrine/dbal/src/Connection.php:1106 {
      Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], $types = [], ?QueryCacheProfile $qcp = null): Result …
      › } catch (Driver\Exception $e) {    throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);} finally {
    }
    /var/www/dev.ehymns/vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:969 {
      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/dev.ehymns/vendor/doctrine/orm/src/EntityRepository.php:224 {
      Doctrine\ORM\EntityRepository->findBy(array $criteria, ?array $orderBy = null, $limit = null, $offset = null) …
      › 
      ›     return $persister->loadAll($criteria, $orderBy, $limit, $offset);}
    }
    /var/www/dev.ehymns/src/Controller/HymnsController.php:236 {
      App\Controller\HymnsController->top5(ManagerRegistry $doctrine, Request $request): Response …
      › 
      › $all = $doctrine->getRepository(HymnTypesView::class)->findBy([], [    'hymn_hit_count' => 'DESC',
    }
    /var/www/dev.ehymns/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/dev.ehymns/vendor/symfony/http-kernel/HttpKernel.php:75 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {    return $this->handleRaw($request, $type);} catch (\Exception $e) {
    }
    /var/www/dev.ehymns/vendor/symfony/http-kernel/Kernel.php:202 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {    return $this->getHttpKernel()->handle($request, $type, $catch);} finally {
    }
    /var/www/dev.ehymns/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/dev.ehymns/vendor/autoload_runtime.php:35 {
      require_once …
      ›         ->getRunner($app)        ->run());
    }
    /var/www/dev.ehymns/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';arguments: {
        "/var/www/dev.ehymns/vendor/autoload_runtime.php"
      }
    }
  }
}
logger
Symfony\Bridge\Monolog\Logger {#94 …9}