https://www.virtualrealitycommerce.org/eshop/4/category/1?sort=productASC

Method
GET
HTTP Status
500
IP
66.249.73.76
Profiled on
Token
ef0f7f

ErrorController

Request

GET Parameters

Key Value
sort 
"productASC"

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_api_platform_links 
Symfony\Component\WebLink\GenericLinkProvider {#1614
  -links: [
    1612 => Symfony\Component\WebLink\Link {#1612
      -href: "https://www.virtualrealitycommerce.org/api/docs.jsonld"
      -rel: [
        "http://www.w3.org/ns/hydra/core#apiDocumentation" => "http://www.w3.org/ns/hydra/core#apiDocumentation"
      ]
      -attributes: []
    }
  ]
}
_controller 
"error_controller"
_stopwatch_token 
"0f3ee3"
exception 
Doctrine\DBAL\Exception\ConnectionException {#1230
  #message: "An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused"
  #code: 2002
  #file: "/var/www/webexciter/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
  #line: 101
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#1229 …}
  -query: null
  trace: {
    /var/www/webexciter/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/webexciter/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/webexciter/vendor/doctrine/dbal/src/Connection.php:1887 {
      Doctrine\DBAL\Connection->convertException(Exception $e): DriverException …
      › {
      ›     return $this->handleDriverException($e, null);
      › }
    }
    /var/www/webexciter/vendor/doctrine/dbal/src/Connection.php:380 {
      Doctrine\DBAL\Connection->connect() …
      › } catch (Driver\Exception $e) {
      ›     throw $this->convertException($e);
      › }
    }
    /var/www/webexciter/vendor/doctrine/dbal/src/Connection.php:453 {
      Doctrine\DBAL\Connection->getDatabasePlatformVersion() …
      › try {
      ›     $this->connect();
      › } catch (Exception $originalException) {
    }
    /var/www/webexciter/vendor/doctrine/dbal/src/Connection.php:411 {
      Doctrine\DBAL\Connection->detectDatabasePlatform(): AbstractPlatform …
      › {
      ›     $version = $this->getDatabasePlatformVersion();
      › 
    }
    /var/www/webexciter/vendor/doctrine/dbal/src/Connection.php:318 {
      Doctrine\DBAL\Connection->getDatabasePlatform() …
      › if ($this->platform === null) {
      ›     $this->platform = $this->detectDatabasePlatform();
      ›     $this->platform->setEventManager($this->_eventManager);
    }
    /var/www/webexciter/vendor/doctrine/orm/src/Mapping/ClassMetadataFactory.php:871 {
      Doctrine\ORM\Mapping\ClassMetadataFactory->getTargetPlatform(): AbstractPlatform …
      › if (! $this->targetPlatform) {
      ›     $this->targetPlatform = $this->em->getConnection()->getDatabasePlatform();
      › }
    }
    /var/www/webexciter/vendor/doctrine/orm/src/Mapping/ClassMetadataFactory.php:629 {
      Doctrine\ORM\Mapping\ClassMetadataFactory->completeIdGeneratorMapping(ClassMetadataInfo $class): void …
      › if ($idGenType === ClassMetadata::GENERATOR_TYPE_AUTO) {
      ›     $class->setIdGeneratorType($this->determineIdGeneratorStrategy($this->getTargetPlatform()));
      › }
    }
    /var/www/webexciter/vendor/doctrine/orm/src/Mapping/ClassMetadataFactory.php:160 {
      Doctrine\ORM\Mapping\ClassMetadataFactory->doLoadMetadata($class, $parent, $rootEntityFound, array $nonSuperclassParents) …
      › } else {
      ›     $this->completeIdGeneratorMapping($class);
      › }
    }
    /var/www/webexciter/vendor/doctrine/doctrine-bundle/src/Mapping/ClassMetadataFactory.php:18 {
      Doctrine\Bundle\DoctrineBundle\Mapping\ClassMetadataFactory->doLoadMetadata($class, $parent, $rootEntityFound, array $nonSuperclassParents): void …
      › {
      ›     parent::doLoadMetadata($class, $parent, $rootEntityFound, $nonSuperclassParents);
      › 
    }
    /var/www/webexciter/vendor/doctrine/persistence/src/Persistence/Mapping/AbstractClassMetadataFactory.php:343 {
      Doctrine\Persistence\Mapping\AbstractClassMetadataFactory->loadMetadata(string $name) …
      › 
      › $this->doLoadMetadata($class, $parent, $rootEntityFound, $visited);
      › 
    }
    /var/www/webexciter/vendor/doctrine/persistence/src/Persistence/Mapping/AbstractClassMetadataFactory.php:207 {
      Doctrine\Persistence\Mapping\AbstractClassMetadataFactory->getMetadataFor(string $className) …
      › } else {
      ›     $loadedMetadata = $this->loadMetadata($realClassName);
      ›     $classNames     = array_combine(
    }
    /var/www/webexciter/vendor/doctrine/orm/src/EntityManager.php:318 {
      Doctrine\ORM\EntityManager->getClassMetadata($className) …
      › {
      ›     return $this->metadataFactory->getMetadataFor($className);
      › }
    }
    /var/www/webexciter/vendor/doctrine/doctrine-bundle/src/Repository/ContainerRepositoryFactory.php:49 {
      Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->doGetRepository(EntityManagerInterface $entityManager, string $entityName, bool $strictTypeCheck): ObjectRepository …
      › {
      ›     $metadata            = $entityManager->getClassMetadata($entityName);
      ›     $repositoryServiceId = $metadata->customRepositoryClassName;
    }
    /var/www/webexciter/vendor/doctrine/doctrine-bundle/src/Repository/RepositoryFactoryCompatibility.php:38 {
      Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository(EntityManagerInterface $entityManager, $entityName): ObjectRepository …
      › {
      ›     return $this->doGetRepository($entityManager, $entityName, false);
      › }
    }
    /var/www/webexciter/vendor/doctrine/orm/src/EntityManager.php:831 {
      Doctrine\ORM\EntityManager->getRepository($entityName) …
      › 
      › $repository = $this->repositoryFactory->getRepository($this, $entityName);
      › if (! $repository instanceof EntityRepository) {
    }
    /var/www/webexciter/var/cache/dev/ContainerXwzpxXD/EntityManager_9a5be93.php:227 {
      ContainerXwzpxXD\EntityManager_9a5be93->getRepository($entityName) …
      › 
      ›     return $this->valueHolderf4f61->getRepository($entityName);
      › }
    }
    /var/www/webexciter/src/EventListener/RequestListener.php:91 {
      App\EventListener\RequestListener->__invoke(RequestEvent $event): void …
      › $em = $this->doctrine->getManager();
      › $eshop = $em->getRepository(Eshop::class)->getEshop($request->attributes->get('eshopId'));
      › $session->set('eshop', $eshop);
    }
    /var/www/webexciter/vendor/symfony/event-dispatcher/Debug/WrappedListener.php:115 {
      Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object $event, string $eventName, EventDispatcherInterface $dispatcher): void …
      › 
      › ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
      › 
    }
    /var/www/webexciter/vendor/symfony/event-dispatcher/EventDispatcher.php:230 {
      Symfony\Component\EventDispatcher\EventDispatcher->callListeners(iterable $listeners, string $eventName, object $event) …
      ›     }
      ›     $listener($event, $eventName, $this);
      › }
    }
    /var/www/webexciter/vendor/symfony/event-dispatcher/EventDispatcher.php:59 {
      Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object $event, string $eventName = null): object …
      › if ($listeners) {
      ›     $this->callListeners($listeners, $eventName, $event);
      › }
    }
    /var/www/webexciter/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:153 {
      Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object $event, string $eventName = null): object …
      › try {
      ›     $this->dispatcher->dispatch($event, $eventName);
      › } finally {
    }
    /var/www/webexciter/vendor/symfony/http-kernel/HttpKernel.php:139 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › $event = new RequestEvent($this, $request, $type);
      › $this->dispatcher->dispatch($event, KernelEvents::REQUEST);
      › 
    }
    /var/www/webexciter/vendor/symfony/http-kernel/HttpKernel.php:75 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
      › try {
      ›     return $this->handleRaw($request, $type);
      › } catch (\Exception $e) {
    }
    /var/www/webexciter/vendor/symfony/http-kernel/Kernel.php:202 {
      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/webexciter/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/webexciter/vendor/autoload_runtime.php:29 {
      require_once …
      ›         ->getRunner($app)
      ›         ->run()
      › );
    }
    /var/www/webexciter/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
      › 
      arguments: {
        "/var/www/webexciter/vendor/autoload_runtime.php"
      }
    }
  }
}
logger 
Symfony\Bridge\Monolog\Logger {#189 …9}

Request Headers

Header Value
accept 
"text/html,application/xhtml+xml,application/signed-exchange;v=b3,application/xml;q=0.9,*/*;q=0.8"
accept-encoding 
"gzip, deflate, br"
amp-cache-transform 
"google;v="1..8""
connection 
"keep-alive"
from 
"googlebot(at)googlebot.com"
host 
"www.virtualrealitycommerce.org"
user-agent 
"Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.6613.137 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
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, 21 Sep 2024 09:53:01 GMT"
x-debug-exception 
"An%20exception%20occurred%20in%20the%20driver%3A%20SQLSTATE%5BHY000%5D%20%5B2002%5D%20Connection%20refused"
x-debug-exception-file 
"%2Fvar%2Fwww%2Fwebexciter%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FMySQL%2FExceptionConverter.php:101"
x-debug-token 
"ef0f7f"

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_ENV 
"dev"
APP_SECRET 
"6cd0c47bbe7a0feccacf6fed3a8f7ff3"
CORS_ALLOW_ORIGIN 
"^https?://(localhost|127\.0\.0\.1)(:[0-9]+)?$"
DATABASE_URL 
"mysql://root:pswdb33@127.0.0.1:3306/alliancemarkets2"
DYNAMIC_DATABASE_URL 
"mysql://root:pswdb33@127.0.0.1:3306/am_demo"
ESHOP_DEMO_DATABASE_URL 
"mysql://root:pswdb33@127.0.0.1:3306/am_demo"
MAILER_DSN 
"smtp://info@virtualrealitycommerce.cz:p3U1b4j1-j1!@smtp.web4u.cz:587"
MESSENGER_TRANSPORT_DSN 
"doctrine://default?auto_setup=0"

Defined as regular env variables

Key Value
APP_DEBUG 
"1"
CONTEXT_DOCUMENT_ROOT 
"/var/www/webexciter/public"
CONTEXT_PREFIX 
""
DOCUMENT_ROOT 
"/var/www/webexciter/public"
GATEWAY_INTERFACE 
"CGI/1.1"
HTTPS 
"on"
HTTP_ACCEPT 
"text/html,application/xhtml+xml,application/signed-exchange;v=b3,application/xml;q=0.9,*/*;q=0.8"
HTTP_ACCEPT_ENCODING 
"gzip, deflate, br"
HTTP_AMP_CACHE_TRANSFORM 
"google;v="1..8""
HTTP_CONNECTION 
"keep-alive"
HTTP_FROM 
"googlebot(at)googlebot.com"
HTTP_HOST 
"www.virtualrealitycommerce.org"
HTTP_USER_AGENT 
"Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.6613.137 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
PATH 
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
PHP_SELF 
"/index.php"
QUERY_STRING 
"sort=productASC"
REDIRECT_HTTPS 
"on"
REDIRECT_QUERY_STRING 
"sort=productASC"
REDIRECT_SSL_TLS_SNI 
"www.virtualrealitycommerce.org"
REDIRECT_STATUS 
"200"
REDIRECT_URL 
"/eshop/4/category/1"
REMOTE_ADDR 
"66.249.73.76"
REMOTE_PORT 
"50034"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"https"
REQUEST_TIME 
1726912381
REQUEST_TIME_FLOAT 
1726912381.229
REQUEST_URI 
"/eshop/4/category/1?sort=productASC"
SCRIPT_FILENAME 
"/var/www/webexciter/public/index.php"
SCRIPT_NAME 
"/index.php"
SERVER_ADDR 
"81.91.93.29"
SERVER_ADMIN 
"[no address given]"
SERVER_NAME 
"www.virtualrealitycommerce.org"
SERVER_PORT 
"443"
SERVER_PROTOCOL 
"HTTP/1.1"
SERVER_SIGNATURE 
"<address>Apache/2.4.25 (Debian) Server at www.virtualrealitycommerce.org Port 443</address>\n"
SERVER_SOFTWARE 
"Apache/2.4.25 (Debian)"
SSL_TLS_SNI 
"www.virtualrealitycommerce.org"
SYMFONY_DOTENV_VARS 
"APP_ENV,APP_SECRET,DATABASE_URL,DYNAMIC_DATABASE_URL,ESHOP_DEMO_DATABASE_URL,MESSENGER_TRANSPORT_DSN,MAILER_DSN,CORS_ALLOW_ORIGIN"

Parent Request

Return to parent request (token = 29e997)

Key Value
_api_platform_links 
Symfony\Component\WebLink\GenericLinkProvider {#1836
  -links: [
    1834 => Symfony\Component\WebLink\Link {#1834
      -href: "https://www.virtualrealitycommerce.org/api/docs.jsonld"
      -rel: [
        "http://www.w3.org/ns/hydra/core#apiDocumentation" => "http://www.w3.org/ns/hydra/core#apiDocumentation"
      ]
      -attributes: []
    }
  ]
}
_controller 
"App\Controller\EshopController::eshopCategoryAction"
_firewall_context 
"security.firewall.map.context.main"
_remove_csp_headers 
true
_route 
"eshopCategory"
_route_params 
[
  "eshopId" => "4"
  "categoryId" => "1"
]
_security_firewall_run 
"_security_main"
_stopwatch_token 
"6e51e3"
categoryId 
"1"
eshopId 
"4"