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

Forwarded to
ErrorController (5884f8)
Method
GET
HTTP Status
500
IP
17.22.237.183
Profiled on
Token
c855c4

PropertyController :: showProperties

Request

GET Parameters

No GET parameters

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

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"

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 
"c855c4"
x-previous-debug-token 
"5884f8"
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_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 
[]

Sub Requests 1

ErrorController (token = 5884f8)

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}