http://api-dev.frivol.com/api/public/content/category/tree

ErrorController

Request

GET Parameters

No GET parameters

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller
"error_controller"
_stopwatch_token
"12d609"
exception
Doctrine\DBAL\Exception\ConnectionException {#2074
  #message: "An exception occurred in the driver: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for mainlb.interquest.nl failed: No address associated with hostname"
  #code: 2002
  #file: "/var/www/api-dev/apps/api/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
  #line: 101
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#2144 …}
  -query: null
  trace: {
    /var/www/api-dev/apps/api/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:101 {
      Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
      › case 2054:    return new ConnectionException($exception, $query);}
    /var/www/api-dev/apps/api/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/api-dev/apps/api/vendor/doctrine/dbal/src/Connection.php:1886 {
      Doctrine\DBAL\Connection->convertException(Exception $e): DriverException …
      › {    return $this->handleDriverException($e, null);}
    }
    /var/www/api-dev/apps/api/vendor/doctrine/dbal/src/Connection.php:379 {
      Doctrine\DBAL\Connection->connect() …
      › } catch (Driver\Exception $e) {    throw $this->convertException($e);}
    }
    /var/www/api-dev/apps/api/vendor/doctrine/dbal/src/Connection.php:1654 {
      Doctrine\DBAL\Connection->getWrappedConnection() …
      › 
      › $this->connect();}
    /var/www/api-dev/apps/api/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/api-dev/apps/api/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:33 {
      Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Connection $conn, array $params, array $types) …
      › {    return $conn->executeQuery($this->sqlStatements, $params, $types, $this->queryCacheProfile);}
    }
    /var/www/api-dev/apps/api/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:327 {
      Doctrine\ORM\Query->_doExecute() …
      › 
      ›     return $executor->execute($this->_em->getConnection(), $sqlParams, $types);}
    }
    /var/www/api-dev/apps/api/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212 {
      Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache($parameters = null, $hydrationMode = null) …
      › 
      › $stmt = $this->_doExecute();}
    /var/www/api-dev/apps/api/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166 {
      Doctrine\ORM\AbstractQuery->execute($parameters = null, $hydrationMode = null) …
      › 
      ›     return $this->executeIgnoreQueryCache($parameters, $hydrationMode);}
    }
    /var/www/api-dev/apps/api/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901 {
      Doctrine\ORM\AbstractQuery->getResult($hydrationMode = self::HYDRATE_OBJECT) …
      › {    return $this->execute(null, $hydrationMode);}
    }
    /var/www/api-dev/apps/api/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:177 {
      Doctrine\ORM\Tools\Pagination\Paginator->getIterator() …
      ›         ->setCacheable($this->query->isCacheable())        ->getResult($this->query->getHydrationMode());}
    }
    /var/www/api-dev/apps/api/src/StructSerializer/Main/StructSerializer.php:33 {
      App\StructSerializer\Main\StructSerializer->multipleToArray(StructOptions $options, iterable $entities): array …
      › $elements = [];foreach ($entities as $entity) {    $elements[] = $this->toArray($options, $entity);
    }
    /var/www/api-dev/apps/api/src/Controller/Content/PublicCategoryController.php:51 {
      App\Controller\Content\PublicCategoryController->tree(): JsonResponse …
      › return new JsonResponse([    'data' => $this->structSerializer->multipleToArray($options, $paginator),    'total' => $paginator->count(),
    }
    /var/www/api-dev/apps/api/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/api-dev/apps/api/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/api-dev/apps/api/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/api-dev/apps/api/public/index.php:56 {$request = Request::createFromGlobals();$response = $kernel->handle($request);$response->send();
    }
  }
}
logger
Symfony\Bridge\Monolog\Logger {#1004 …9}

Request Headers

Header Value
accept
"*/*"
accept-encoding
"gzip"
host
"api-dev.frivol.com"
user-agent
"Symfony HttpClient/Curl"
x-forwarded-for
"172.16.252.3"
x-forwarded-host
"api-dev.frivol.com"
x-forwarded-proto
"https"
x-php-ob-level
"1"
x-real-ip
"172.16.252.3"

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
"Tue, 07 Oct 2025 20:03:04 GMT"
vary
"Accept"
x-debug-exception
"An%20exception%20occurred%20in%20the%20driver%3A%20SQLSTATE%5BHY000%5D%20%5B2002%5D%20php_network_getaddresses%3A%20getaddrinfo%20for%20mainlb.interquest.nl%20failed%3A%20No%20address%20associated%20with%20hostname"
x-debug-exception-file
"%2Fvar%2Fwww%2Fapi-dev%2Fapps%2Fapi%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FMySQL%2FExceptionConverter.php:101"
x-debug-token
"808907"

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_ADMIN_PAYMENT_REPORT_RECIPIENT
"info@interquestmedia.com"
APP_ADVERTISER_IDS
"6002585"
APP_ENV
"dev"
APP_GROUPS_NOTIFICATION_QUEUE_KEY
"apigroupnotifications"
APP_HOST_ASSETS
"https://assets.frivol.com"
APP_HOST_ASSETS_WWW
"https://frontend-dev.frivol.com"
APP_MAILSPOOL_KEY
"apimailspool"
APP_MOGELMAIL_APIKEY
"__FILL_ME__"
APP_PATH_NFS
"/mnt/storage"
APP_PATH_NFS_BILLINGS
"/mnt/storage/billings"
APP_PATH_NFS_BONUSIMAGE
"/mnt/storage/froalaeditor"
APP_PATH_NFS_CATEGORIES
"/mnt/storage/categoryimages"
APP_PATH_NFS_CATEGORIES_GROUPS
"/mnt/storage/categoryimages/groups"
APP_PATH_NFS_CONTENT
"/mnt/storage/content"
APP_PATH_NFS_KYC
"/mnt/storage/kyc"
APP_PATH_NFS_LINKS
"/mnt/storage/links"
APP_PATH_NFS_MEMBERMEDIA
"/mnt/storage/membermedia"
APP_PATH_NFS_MEMBERMEDIA_VIDEOS
"/mnt/storage/media/videos"
APP_PATH_NFS_OUTSTANDING_BALANCES
"/mnt/storage/outstanding_balances"
APP_PATH_NFS_PUBLIC
"/public"
APP_PAYMENT_PROVIDER_SOFORT_CONFIGKEY
"__FILL_ME__"
APP_SECRET
"34rtjASDQWERwer34"
APP_SUPPORT_USERNAME
"support"
APP_SYSTEM_JOBQUEUE
"jobs:apiqueue"
ATMS_USER_PASSWORD
"__FILL_ME__"
AWS_ENDPOINT
"http://minio01.frivol:9000"
AWS_KEY
"__FILL_ME__"
AWS_LIIP_BUCKET
"mediacache"
AWS_REGION
"us-east-1"
AWS_SECRET
"__FILL_ME__"
AWS_VERSION
"latest"
CORS_ALLOW_ORIGIN
".*"
DATABASE_ARCHIVE_URL
"__FILL_ME__"
DATABASE_URL
"mysql://frivol_dev:A1b2C3d4E5f6@mainlb.interquest.nl/frivol_dev?serverVersion=mariadb-10.2.33"
ELASTICSEARCH_HOST
"http://mainlb.interquest.nl:9200"
ELASTICSEARCH_URL
"http://mainlb.interquest.nl:9200/"
EMERCHANTPAY_PARTNERID
"__FILL_ME__"
EMERCHANTPAY_PASSWORD
"__FILL_ME__"
EMERCHANTPAY_PROJECTID
"__FILL_ME__"
FFMPEG_BINARIES_FFMPEG
"/usr/bin/ffmpeg"
FFMPEG_BINARIES_FFPROBE
"/usr/bin/ffprobe"
FFMPEG_BINARIES_QTFASTSTART
"/usr/bin/qt-faststart"
JWT_PASSPHRASE
"__FILL_ME__"
JWT_PUBLIC_KEY
"%kernel.project_dir%/config/jwt/public.pem"
JWT_SECRET_KEY
"%kernel.project_dir%/config/jwt/private.pem"
KEILA_API_HOST
"https://newsletter.frivol.com"
KEILA_API_KEY
"__FILL_ME__"
LIVECAM_ACCESS_KEY
"__FILL_ME__"
LOCK_DSN
"semaphore"
MAILER_HOSTNAME_BACKUP1
"frivol-ams2-mta10"
MAILER_HOSTNAME_HIGH
"frivol-ams2-mta8"
MAILER_HOSTNAME_HIGHEST
"frivol-ams2-mta1"
MAILER_HOSTNAME_MASS1
"frivol-ams2-mta5"
MAILER_HOSTNAME_MASS2
"frivol-ams2-mta6"
MAILER_HOSTNAME_MASS3
"frivol-ams2-mta7"
MAILER_HOSTNAME_REGULAR
"frivol-ams2-mta9"
MAILER_PASSWORD
"__FILL_ME__"
MAILER_URL
"null://localhost"
MAILER_USERNAME_BACKUP1
"frivol@frivol-ams2-mta10.isprime.nl"
MAILER_USERNAME_HIGH
"frivol@frivol-ams2-mta8.isprime.nl"
MAILER_USERNAME_HIGHEST
"frivol@frivol-ams2-mta1.isprime.nl"
MAILER_USERNAME_MASS1
"frivol@frivol-ams2-mta5.isprime.nl"
MAILER_USERNAME_MASS2
"frivol@frivol-ams2-mta6.isprime.nl"
MAILER_USERNAME_MASS3
"frivol@frivol-ams2-mta7.isprime.nl"
MAILER_USERNAME_REGULAR
"frivol@frivol-ams2-mta9.isprime.nl"
MICROPAYMENT_ACCESS_TOKEN
"__FILL_ME__"
MICROPAYMENT_PROJECT_ID
"__FILL_ME__"
REALTIME_MEMBER_SEARCH
"false"
REDIS_HOST
"localhost"
REDIS_PORT
"6379"
SENTRY_DSN
"__FILL_ME__"
UNZER_PRIVATE_KEY
"p-priv-2a10Cg4IRoDUulcCNjGjKoDhO8QfylMb"
UNZER_PUBLIC_KEY
"p-pub-2a10yDv914uignkJYV5Vi7gSsIOLohV8"
WKHTMLTOIMAGE_PATH
"%kernel.project_dir%/bin/wkhtmltoimage-amd64"
WKHTMLTOPDF_PATH
"%kernel.project_dir%/bin/wkhtmltopdf-amd64"
YOTI_CLIENT_TOKEN
"c9cac635-e07c-4d53-a8c9-e0ce8be6d703"
YOTI_PEM_PATH
"config/yoti/yoti_frivol.com-access-security.pem"
ZAMMAD_TOKEN
"__FILL_ME__"
ZAMMAD_URL
"http://172.16.252.71"

Defined as regular env variables

Key Value
APP_DEBUG
"1"
CONTENT_LENGTH
""
CONTENT_TYPE
""
DOCUMENT_ROOT
"/var/www/api-dev/apps/api/public"
DOCUMENT_URI
"/index.php"
FCGI_ROLE
"RESPONDER"
GATEWAY_INTERFACE
"CGI/1.1"
HOME
"/var/www"
HTTP_ACCEPT
"*/*"
HTTP_ACCEPT_ENCODING
"gzip"
HTTP_HOST
"api-dev.frivol.com"
HTTP_USER_AGENT
"Symfony HttpClient/Curl"
HTTP_X_FORWARDED_FOR
"172.16.252.3"
HTTP_X_FORWARDED_HOST
"api-dev.frivol.com"
HTTP_X_FORWARDED_PROTO
"https"
HTTP_X_REAL_IP
"172.16.252.3"
PHP_SELF
"/index.php"
QUERY_STRING
""
REDIRECT_STATUS
"200"
REMOTE_ADDR
"172.16.252.190"
REMOTE_PORT
"45250"
REMOTE_USER
""
REQUEST_METHOD
"GET"
REQUEST_SCHEME
"http"
REQUEST_TIME
1759867384
REQUEST_TIME_FLOAT
1759867384.5677
REQUEST_URI
"/api/public/content/category/tree"
SCRIPT_FILENAME
"/var/www/api-dev/apps/api/public/index.php"
SCRIPT_NAME
"/index.php"
SERVER_ADDR
"172.16.252.130"
SERVER_NAME
"api-dev.frivol.com"
SERVER_PORT
"80"
SERVER_PROTOCOL
"HTTP/1.1"
SERVER_SOFTWARE
"nginx/1.24.0"
SYMFONY_DOTENV_VARS
"APP_ENV,APP_HOST_ASSETS,APP_HOST_ASSETS_WWW,APP_PATH_NFS,APP_PATH_NFS_KYC,APP_PATH_NFS_PUBLIC,APP_PATH_NFS_CONTENT,APP_PATH_NFS_LINKS,APP_PATH_NFS_BILLINGS,APP_PATH_NFS_OUTSTANDING_BALANCES,APP_PATH_NFS_CATEGORIES,APP_PATH_NFS_CATEGORIES_GROUPS,APP_PATH_NFS_BONUSIMAGE,APP_PATH_NFS_MEMBERMEDIA,APP_PATH_NFS_MEMBERMEDIA_VIDEOS,APP_SYSTEM_JOBQUEUE,APP_ADVERTISER_IDS,KEILA_API_HOST,KEILA_API_KEY,LIVECAM_ACCESS_KEY,ATMS_USER_PASSWORD,REDIS_HOST,REDIS_PORT,FFMPEG_BINARIES_FFMPEG,FFMPEG_BINARIES_FFPROBE,FFMPEG_BINARIES_QTFASTSTART,REALTIME_MEMBER_SEARCH,ELASTICSEARCH_HOST,UNZER_PUBLIC_KEY,UNZER_PRIVATE_KEY,EMERCHANTPAY_PARTNERID,EMERCHANTPAY_PASSWORD,EMERCHANTPAY_PROJECTID,APP_PAYMENT_PROVIDER_SOFORT_CONFIGKEY,MAILER_HOSTNAME_REGULAR,MAILER_USERNAME_REGULAR,APP_SECRET,APP_GROUPS_NOTIFICATION_QUEUE_KEY,APP_SUPPORT_USERNAME,APP_MAILSPOOL_KEY,APP_MOGELMAIL_APIKEY,DATABASE_URL,DATABASE_ARCHIVE_URL,CORS_ALLOW_ORIGIN,MAILER_URL,MAILER_PASSWORD,JWT_SECRET_KEY,JWT_PUBLIC_KEY,JWT_PASSPHRASE,WKHTMLTOPDF_PATH,WKHTMLTOIMAGE_PATH,AWS_KEY,AWS_SECRET,AWS_VERSION,AWS_REGION,AWS_ENDPOINT,AWS_LIIP_BUCKET,ELASTICSEARCH_URL,LOCK_DSN,SENTRY_DSN,MICROPAYMENT_ACCESS_TOKEN,MICROPAYMENT_PROJECT_ID,ZAMMAD_URL,ZAMMAD_TOKEN,APP_ADMIN_PAYMENT_REPORT_RECIPIENT,MAILER_HOSTNAME_HIGHEST,MAILER_HOSTNAME_HIGH,MAILER_HOSTNAME_MASS1,MAILER_HOSTNAME_MASS2,MAILER_HOSTNAME_MASS3,MAILER_HOSTNAME_BACKUP1,MAILER_USERNAME_HIGHEST,MAILER_USERNAME_HIGH,MAILER_USERNAME_MASS1,MAILER_USERNAME_MASS2,MAILER_USERNAME_MASS3,MAILER_USERNAME_BACKUP1,YOTI_CLIENT_TOKEN,YOTI_PEM_PATH"
USER
"www-data"

Parent Request

Return to parent request (token = 375aff)

Key Value
_controller
"App\Controller\Content\PublicCategoryController::tree"
_firewall_context
"security.firewall.map.context.publicapi"
_remove_csp_headers
true
_route
"app_content_publiccategory_tree"
_route_params
[]
_stopwatch_token
"005bde"