https://www.scicawally.com/front/end/property/a-vendre-villa-duplex-resident-10-pieces-suis

Method
GET
HTTP Status
500
IP
17.22.237.183
Profiled on
Token
5884f8

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 
"c33c22"
exception 
Doctrine\DBAL\Exception\ConnectionException {#657
  #message: "An exception occurred in the driver: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for scicawwwebmaster.mysql.db failed: Name or service not known"
  #code: 2002
  #file: "/home/scicaww/sci-cawally/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
  #line: 101
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#577 …}
  -query: null
  trace: {
    /home/scicaww/sci-cawally/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);
      › 
    }
    /home/scicaww/sci-cawally/vendor/doctrine/dbal/src/Connection.php:1908 {
      Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
      › $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
      › $exception                  = $this->exceptionConverter->convert($driverException, $query);
      › 
      arguments: {
        $exception: Doctrine\DBAL\Driver\PDO\Exception {#577 …}
        $query: null
      }
    }
    /home/scicaww/sci-cawally/vendor/doctrine/dbal/src/Connection.php:1857 {
      Doctrine\DBAL\Connection->convertException(Exception $e): DriverException …
      › {
      ›     return $this->handleDriverException($e, null);
      › }
      arguments: {
        $driverException: Doctrine\DBAL\Driver\PDO\Exception {#577 …}
        $query: null
      }
    }
    /home/scicaww/sci-cawally/vendor/doctrine/dbal/src/Connection.php:348 {
      Doctrine\DBAL\Connection->connect() …
      › } catch (Driver\Exception $e) {
      ›     throw $this->convertException($e);
      › }
      arguments: {
        $e: Doctrine\DBAL\Driver\PDO\Exception {#577 …}
      }
    }
    /home/scicaww/sci-cawally/vendor/doctrine/dbal/src/Connection.php:1619 {
      Doctrine\DBAL\Connection->getWrappedConnection() …
      › 
      › $this->connect();
      › 
    }
    /home/scicaww/sci-cawally/vendor/doctrine/dbal/src/Connection.php:1046 {
      Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], $types = [], QueryCacheProfile $qcp = null): Result …
      › 
      › $connection = $this->getWrappedConnection();
      › 
    }
    /home/scicaww/sci-cawally/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:750 {
      Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(array $criteria, $entity = null, $assoc = null, array $hints = [], $lockMode = null, $limit = null, array $orderBy = null) …
      › [$params, $types] = $this->expandParameters($criteria);
      › $stmt             = $this->conn->executeQuery($sql, $params, $types);
      › 
      arguments: {
        $sql: "SELECT t0.id AS id_1, t0.title AS title_2, t0.desription AS desription_3, t0.firstimage AS firstimage_4, t0.price AS price_5, t0.is_solde AS is_solde_6, t0.is_rent AS is_rent_7, t0.is_to_sale AS is_to_sale_8, t0.surface AS surface_9, t0.room AS room_10, t0.shower AS shower_11, t0.floor AS floor_12, t0.city AS city_13, t0.quatier AS quatier_14, t0.slug AS slug_15, t0.created_at AS created_at_16, t0.illustration1 AS illustration1_17, t0.illustration2 AS illustration2_18, t0.illustration3 AS illustration3_19, t0.illustration4 AS illustration4_20, t0.property_types_id AS property_types_id_21 FROM property t0 WHERE t0.slug = ? LIMIT 1"
        $params: [ …1]
        $types: [ …1]
      }
    }
    /home/scicaww/sci-cawally/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:241 {
      Doctrine\ORM\EntityRepository->findOneBy(array $criteria, array $orderBy = null) …
      › 
      ›     return $persister->load($criteria, null, null, [], null, 1, $orderBy);
      › }
      arguments: {
        $criteria: [ …1]
        $entity: null
        $assoc: null
        $hints: []
        $lockMode: null
        $limit: 1
        $orderBy: null
      }
    }
    /home/scicaww/sci-cawally/vendor/sensio/framework-extra-bundle/src/Request/ParamConverter/DoctrineParamConverter.php:238 {
      Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->findOneBy($class, Request $request, $options) …
      › 
      ›     return $em->getRepository($class)->$repositoryMethod($criteria);
      › } catch (NoResultException $e) {
      arguments: {
        $criteria: [ …1]
      }
    }
    /home/scicaww/sci-cawally/vendor/sensio/framework-extra-bundle/src/Request/ParamConverter/DoctrineParamConverter.php:93 {
      Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->apply(Request $request, ParamConverter $configuration) …
      › // find by criteria
      › if (false === $object = $this->findOneBy($class, $request, $options)) {
      ›     if ($configuration->isOptional()) {
      arguments: {
        $class: "App\Entity\Admin\Property"
        $request: Symfony\Component\HttpFoundation\Request {#52 …}
        $options: [ …9]
      }
    }
    /home/scicaww/sci-cawally/vendor/sensio/framework-extra-bundle/src/Request/ParamConverter/ParamConverterManager.php:84 {
      Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->applyConverter(Request $request, ParamConverter $configuration) …
      › if ($converter->supports($configuration)) {
      ›     if ($converter->apply($request, $configuration)) {
      ›         return;
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#52 …}
        $configuration: Sensio\Bundle\FrameworkExtraBundle\Configuration\ParamConverter {#468 …}
      }
    }
    /home/scicaww/sci-cawally/vendor/sensio/framework-extra-bundle/src/Request/ParamConverter/ParamConverterManager.php:48 {
      Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->apply(Request $request, $configurations) …
      › foreach ($configurations as $configuration) {
      ›     $this->applyConverter($request, $configuration);
      › }
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#52 …}
        $configuration: Sensio\Bundle\FrameworkExtraBundle\Configuration\ParamConverter {#468 …}
      }
    }
    /home/scicaww/sci-cawally/vendor/sensio/framework-extra-bundle/src/EventListener/ParamConverterListener.php:72 {
      Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener->onKernelController(KernelEvent $event) …
      › 
      ›     $this->manager->apply($request, $configurations);
      › }
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#52 …}
        $configurations: [ …2]
      }
    }
    /home/scicaww/sci-cawally/vendor/symfony/event-dispatcher/Debug/WrappedListener.php:111 {
      Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object $event, string $eventName, EventDispatcherInterface $dispatcher): void …
      › 
      › ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
      › 
      arguments: {
        $event: Symfony\Component\HttpKernel\Event\ControllerEvent {#401 …}
        ...: {
          "kernel.controller"
          Symfony\Component\HttpKernel\Debug\TraceableEventDispatcher {#136 …}
        }
      }
    }
    /home/scicaww/sci-cawally/vendor/symfony/event-dispatcher/EventDispatcher.php:230 {
      Symfony\Component\EventDispatcher\EventDispatcher->callListeners(iterable $listeners, string $eventName, object $event) …
      ›     }
      ›     $listener($event, $eventName, $this);
      › }
      arguments: {
        $event: Symfony\Component\HttpKernel\Event\ControllerEvent {#401 …}
        $eventName: "kernel.controller"
        $dispatcher: Symfony\Component\HttpKernel\Debug\TraceableEventDispatcher {#136 …}
      }
    }
    /home/scicaww/sci-cawally/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);
      › }
      arguments: {
        $listeners: [ …7]
        $eventName: "kernel.controller"
        $event: Symfony\Component\HttpKernel\Event\ControllerEvent {#401 …}
      }
    }
    /home/scicaww/sci-cawally/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:152 {
      Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object $event, string $eventName = null): object …
      › try {
      ›     $this->dispatcher->dispatch($event, $eventName);
      › } finally {
      arguments: {
        $event: Symfony\Component\HttpKernel\Event\ControllerEvent {#401 …}
        $eventName: "kernel.controller"
      }
    }
    /home/scicaww/sci-cawally/vendor/symfony/http-kernel/HttpKernel.php:151 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › $event = new ControllerEvent($this, $controller, $request, $type);
      › $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER);
      › $controller = $event->getController();
      arguments: {
        $event: Symfony\Component\HttpKernel\Event\ControllerEvent {#401 …}
        $eventName: "kernel.controller"
      }
    }
    /home/scicaww/sci-cawally/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) {
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#52 …}
        $type: 1
      }
    }
    /home/scicaww/sci-cawally/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 {
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#52 …}
        $type: 1
        $catch: true
      }
    }
    /home/scicaww/sci-cawally/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
      Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
      › {
      ›     $response = $this->kernel->handle($this->request);
      ›     $response->send();
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#52 …}
      }
    }
    /home/scicaww/sci-cawally/vendor/autoload_runtime.php:29 {
      require_once …
      ›         ->getRunner($app)
      ›         ->run()
      › );
    }
    /home/scicaww/sci-cawally/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
      › 
      arguments: {
        "/home/scicaww/sci-cawally/vendor/autoload_runtime.php"
      }
    }
  }
}
logger 
Symfony\Bridge\Monolog\Logger {#82 …8}

Request Headers

Header Value
accept 
"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8"
accept-encoding 
"gzip,identity"
host 
"www.scicawally.com"
remote-ip 
"17.22.237.183"
user-agent 
"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4 Safari/605.1.15 (Applebot/0.1; +http://www.apple.com/go/applebot)"
x-forwarded-for 
"17.22.237.183"
x-forwarded-proto 
"https"
x-ovhrequest-id 
"99f1c70dbab999889887844cd5345e90"
x-php-ob-level 
"1"
x-predictor 
"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 
"Wed, 29 Oct 2025 20:53:00 GMT"
x-debug-exception 
"An%20exception%20occurred%20in%20the%20driver%3A%20SQLSTATE%5BHY000%5D%20%5B2002%5D%20php_network_getaddresses%3A%20getaddrinfo%20for%20scicawwwebmaster.mysql.db%20failed%3A%20Name%20or%20service%20not%20known"
x-debug-exception-file 
"%2Fhome%2Fscicaww%2Fsci-cawally%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FMySQL%2FExceptionConverter.php:101"
x-debug-token 
"5884f8"

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 
"347bb84460fcf91180e61df67995ca89"
DATABASE_URL 
"mysql://scicawwwebmaster:SCI2022k1@scicawwwebmaster.mysql.db:3306/scicawwwebmaster?serverVersion=5.7&charset=utf8mb4"
MAILER_DSN 
"gmail+smtp://kevinskouame@gmail.com:mlkma1405@default"
MESSENGER_TRANSPORT_DSN 
"doctrine://default?auto_setup=0"

Defined as regular env variables

Key Value
APP_DEBUG 
"1"
CFG_CLUSTER 
"cluster128"
DOCUMENT_ROOT 
"/home/scicaww/sci-cawally/public"
ENVIRONMENT 
"production"
FCGI_ROLE 
"RESPONDER"
GATEWAY_INTERFACE 
"CGI/1.1"
GEOIP_AREA_CODE 
"0"
GEOIP_COUNTRY_CODE 
"US"
GEOIP_COUNTRY_NAME 
"United States"
GEOIP_DMA_CODE 
"0"
GEOIP_LATITUDE 
"37.750999"
GEOIP_LONGITUDE 
"-97.821999"
HTTPS 
"on"
HTTP_ACCEPT 
"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8"
HTTP_ACCEPT_ENCODING 
"gzip,identity"
HTTP_HOST 
"www.scicawally.com"
HTTP_REMOTE_IP 
"17.22.237.183"
HTTP_USER_AGENT 
"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4 Safari/605.1.15 (Applebot/0.1; +http://www.apple.com/go/applebot)"
HTTP_X_FORWARDED_FOR 
"17.22.237.183"
HTTP_X_FORWARDED_PROTO 
"https"
HTTP_X_OVHREQUEST_ID 
"99f1c70dbab999889887844cd5345e90"
HTTP_X_PREDICTOR 
"1"
PHP_SELF 
"/index.php"
QUERY_STRING 
""
REDIRECT_STATUS 
"200"
REDIRECT_URL 
"/front/end/property/a-vendre-villa-duplex-resident-10-pieces-suis"
REMOTE_ADDR 
"17.22.237.183"
REMOTE_PORT 
"32124"
REQUEST_METHOD 
"GET"
REQUEST_TIME 
1761771180
REQUEST_TIME_FLOAT 
1761771180.3602
REQUEST_URI 
"/front/end/property/a-vendre-villa-duplex-resident-10-pieces-suis"
SCRIPT_FILENAME 
"/home/scicaww/sci-cawally/public/index.php"
SCRIPT_NAME 
"/index.php"
SCRIPT_URI 
"https://www.scicawally.com:443/front/end/property/a-vendre-villa-duplex-resident-10-pieces-suis"
SCRIPT_URL 
"/front/end/property/a-vendre-villa-duplex-resident-10-pieces-suis"
SERVER_ADDR 
"10.128.20.17"
SERVER_ADMIN 
"postmaster@www.scicawally.com"
SERVER_NAME 
"www.scicawally.com"
SERVER_PORT 
"443"
SERVER_PROTOCOL 
"HTTP/1.1"
SERVER_SIGNATURE 
""
SERVER_SOFTWARE 
"Apache"
SYMFONY_DOTENV_VARS 
"APP_ENV,APP_SECRET,MESSENGER_TRANSPORT_DSN,DATABASE_URL,MAILER_DSN"
UNIQUE_ID 
"aQJ@rGh7fCfFpGonRJlNPAAAC2M"
USER 
"scicaww"
argc 
0
argv 
[]

Parent Request

Return to parent request (token = c855c4)

Key Value
_controller 
"App\Controller\FrontEnd\PropertyController::showProperties"
_firewall_context 
"security.firewall.map.context.main"
_remove_csp_headers 
true
_route 
"front_property_show"
_route_params 
[
  "slug" => "a-vendre-villa-duplex-resident-10-pieces-suis"
]
_security_firewall_run 
"_security_main"
_stopwatch_token 
"9ac0f1"
slug 
"a-vendre-villa-duplex-resident-10-pieces-suis"