https://dev.ehymns.org/hymns/bshop

Forwarded to
ErrorController (bea268)
Method
GET
HTTP Status
500
IP
95.108.213.103
Profiled on
Token
c01d34

HymnsController :: index

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::index"
_firewall_context 
"security.firewall.map.context.main"
_remove_csp_headers 
true
_route 
"hymns"
_route_params 
[
  "hymnType" => "bshop"
]
_security_firewall_run 
"_security_main"
_stopwatch_token 
"1c580d"
hymnType 
"bshop"

Request Headers

Header Value
accept 
"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8"
accept-encoding 
"gzip,deflate"
connection 
"keep-alive"
from 
"support@search.yandex.ru"
host 
"dev.ehymns.org"
user-agent 
"Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
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 
"Sat, 09 Aug 2025 09:51:14 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 
"c01d34"
x-debug-token-link 
"https://dev.ehymns.org/_profiler/bea268"
x-previous-debug-token 
"bea268"
x-robots-tag 
"noindex"

Cookies

Request Cookies

No request cookies

Response Cookies

No response cookies

Session

Session Metadata

No session metadata

Session Attributes

No session attributes

Session Usage

0 Usages
Stateless check enabled

Session not used.

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 
"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8"
HTTP_ACCEPT_ENCODING 
"gzip,deflate"
HTTP_CONNECTION 
"keep-alive"
HTTP_FROM 
"support@search.yandex.ru"
HTTP_HOST 
"dev.ehymns.org"
HTTP_USER_AGENT 
"Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
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 
"/hymns/bshop"
REMOTE_ADDR 
"95.108.213.103"
REMOTE_PORT 
"54640"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"https"
REQUEST_TIME 
1754733074
REQUEST_TIME_FLOAT 
1754733074.7995
REQUEST_URI 
"/hymns/bshop"
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 = bea268)

Key Value
_controller 
"error_controller"
_stopwatch_token 
"f10864"
exception 
Doctrine\DBAL\Exception\TableNotFoundException {#629
  #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 {#632 …}
  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/Query/Exec/FinalizedSelectExecutor.php:31 {
      Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute(Connection $conn, array $params, array $types): Result …
      › {
      ›     return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);
      › }
    }
    /var/www/dev.ehymns/vendor/doctrine/orm/src/Query.php:330 {
      Doctrine\ORM\Query->_doExecute() …
      › 
      ›     return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
      › }
    }
    /var/www/dev.ehymns/vendor/doctrine/orm/src/AbstractQuery.php:1218 {
      Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache($parameters = null, $hydrationMode = null) …
      › 
      › $stmt = $this->_doExecute();
      › 
    }
    /var/www/dev.ehymns/vendor/doctrine/orm/src/AbstractQuery.php:1172 {
      Doctrine\ORM\AbstractQuery->execute($parameters = null, $hydrationMode = null) …
      › 
      ›     return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
      › }
    }
    /var/www/dev.ehymns/src/Repository/HymnTypesViewRepository.php:43 {
      App\Repository\HymnTypesViewRepository->findByTypeOrderedByTitle(string $hymnType) …
      ›                 ->getQuery()
      ›                 ->execute();
      › }
    }
    /var/www/dev.ehymns/src/Controller/HymnsController.php:37 {
      App\Controller\HymnsController->index(ManagerRegistry $doctrine, string $hymnType): Response …
      › {
      ›     $hymns = $doctrine->getRepository(HymnTypesView::class)->findByTypeOrderedByTitle($hymnType);
      › 
    }
    /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}