https://annuairesdz.com/search?page=4079&page%3D306=

Forwarded to
ErrorController (b7e65e)
Method
GET
HTTP Status
500
IP
20.171.207.123
Profiled on
Token
945dd8

SearchController :: search

Request

GET Parameters

Key Value
page 
"4079"
page=306 
""

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller 
"App\Controller\SearchController::search"
_firewall_context 
"security.firewall.map.context.main"
_remove_csp_headers 
true
_route 
"search"
_route_params 
[]
_security_firewall_run 
"_security_main"
_stopwatch_token 
"13f99f"

Request Headers

Header Value
accept 
"*/*"
accept-encoding 
"br, gzip"
from 
"gptbot(at)openai.com"
host 
"annuairesdz.com"
remote-ip 
"20.171.207.123"
remote-port 
"41818"
scheme 
"https"
user-agent 
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)"
x-ae 
"br"
x-cdn-any-ip 
"46.105.204.29"
x-cdn-request-id 
"931775205"
x-forwarded-for 
"20.171.207.123"
x-forwarded-proto 
"https"
x-openai-host-hash 
"922982656"
x-ovhrequest-id 
"0aa7475988a4c701b0cc9ba6ebdf14a3"
x-php-ob-level 
"1"
x-predictor 
"1"
x-remote-ip 
"20.171.207.123"
x-remote-port 
"41818"
x-scheme 
"https"
x-varnish 
"937469773"

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 
"Sun, 29 Jun 2025 22:19:06 GMT"
x-debug-exception 
"An%20exception%20occurred%20in%20the%20driver%3A%20SQLSTATE%5BHY000%5D%20%5B2002%5D%20Connection%20refused"
x-debug-exception-file 
"%2Fhome%2Fannuairepn%2Fwww%2Faea%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FMySQL%2FExceptionConverter.php:101"
x-debug-token 
"945dd8"
x-debug-token-link 
"https://annuairesdz.com/_profiler/b7e65e"
x-previous-debug-token 
"b7e65e"
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 
"737f78545655c2f0ee2e9ee9fdd941aa"
DATABASE_URL 
"mysql://annuairepnbakli:TiliwaA31000@annuairepnbakli.mysql.db:3306/annuairepnbakli?serverVersion=5.7"
MESSENGER_TRANSPORT_DSN 
"doctrine://default?auto_setup=0"

Defined as regular env variables

Key Value
APP_DEBUG 
"1"
CFG_CLUSTER 
"cluster029"
DOCUMENT_ROOT 
"/home/annuairepn/www/aea"
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 
"*/*"
HTTP_ACCEPT_ENCODING 
"br, gzip"
HTTP_FROM 
"gptbot(at)openai.com"
HTTP_HOST 
"annuairesdz.com"
HTTP_REMOTE_IP 
"20.171.207.123"
HTTP_REMOTE_PORT 
"41818"
HTTP_SCHEME 
"https"
HTTP_USER_AGENT 
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)"
HTTP_X_AE 
"br"
HTTP_X_CDN_ANY_IP 
"46.105.204.29"
HTTP_X_CDN_REQUEST_ID 
"931775205"
HTTP_X_FORWARDED_FOR 
"20.171.207.123"
HTTP_X_FORWARDED_PROTO 
"https"
HTTP_X_OPENAI_HOST_HASH 
"922982656"
HTTP_X_OVHREQUEST_ID 
"0aa7475988a4c701b0cc9ba6ebdf14a3"
HTTP_X_PREDICTOR 
"1"
HTTP_X_REMOTE_IP 
"20.171.207.123"
HTTP_X_REMOTE_PORT 
"41818"
HTTP_X_SCHEME 
"https"
HTTP_X_VARNISH 
"937469773"
MAGIC_QUOTES 
"0"
PHP_SELF 
"/public/index.php"
PHP_VER 
"7_2"
QUERY_STRING 
"page%3D306=&page=4079"
REDIRECT_QUERY_STRING 
"page%3D306=&page=4079"
REDIRECT_STATUS 
"200"
REDIRECT_URL 
"/index.php"
REGISTER_GLOBALS 
"0"
REMOTE_ADDR 
"20.171.207.123"
REMOTE_PORT 
"64420"
REQUEST_METHOD 
"GET"
REQUEST_TIME 
1751235546
REQUEST_TIME_FLOAT 
1751235546.2236
REQUEST_URI 
"/search?page%3D306=&page=4079"
SCRIPT_FILENAME 
"/home/annuairepn/www/aea/public/index.php"
SCRIPT_NAME 
"/public/index.php"
SCRIPT_URI 
"https://annuairesdz.com:443/search"
SCRIPT_URL 
"/search"
SERVER_ADDR 
"10.29.40.35"
SERVER_ADMIN 
"postmaster@annuairesdz.com"
SERVER_NAME 
"annuairesdz.com"
SERVER_PORT 
"443"
SERVER_PROTOCOL 
"HTTP/1.1"
SERVER_SIGNATURE 
""
SERVER_SOFTWARE 
"Apache"
SYMFONY_DOTENV_VARS 
"APP_ENV,APP_SECRET,DATABASE_URL,MESSENGER_TRANSPORT_DSN"
UNIQUE_ID 
"aGG72qQSawP3a4eCQ@SDDgAAAys"
USER 
"annuairepn"
ZEND_OPTIMIZER 
"1"
argc 
1
argv 
[
  "page%3D306=&page=4079"
]

Sub Requests 1

ErrorController (token = b7e65e)

Key Value
_controller 
"error_controller"
_stopwatch_token 
"3b8e45"
exception 
Doctrine\DBAL\Exception\ConnectionException {#889
  #message: "An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused"
  #code: 2002
  #file: "/home/annuairepn/www/aea/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
  #line: 101
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#870 …}
  -query: null
  trace: {
    /home/annuairepn/www/aea/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/annuairepn/www/aea/vendor/doctrine/dbal/src/Connection.php:1943 {
      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 {#870 …}
        $query: null
      }
    }
    /home/annuairepn/www/aea/vendor/doctrine/dbal/src/Connection.php:1891 {
      Doctrine\DBAL\Connection->convertException(Exception $e): DriverException …
      › {
      ›     return $this->handleDriverException($e, null);
      › }
      arguments: {
        $driverException: Doctrine\DBAL\Driver\PDO\Exception {#870 …}
        $query: null
      }
    }
    /home/annuairepn/www/aea/vendor/doctrine/dbal/src/Connection.php:380 {
      Doctrine\DBAL\Connection->connect() …
      › } catch (Driver\Exception $e) {
      ›     throw $this->convertException($e);
      › }
      arguments: {
        $e: Doctrine\DBAL\Driver\PDO\Exception {#870 …}
      }
    }
    /home/annuairepn/www/aea/vendor/doctrine/dbal/src/Connection.php:1659 {
      Doctrine\DBAL\Connection->getWrappedConnection() …
      › 
      › $this->connect();
      › 
    }
    /home/annuairepn/www/aea/vendor/doctrine/dbal/src/Connection.php:1082 {
      Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], $types = [], QueryCacheProfile $qcp = null): Result …
      › 
      › $connection = $this->getWrappedConnection();
      › 
    }
    /home/annuairepn/www/aea/vendor/doctrine/orm/src/Query/Exec/SingleSelectExecutor.php:29 {
      Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Connection $conn, array $params, array $types): Result …
      › {
      ›     return $conn->executeQuery($this->sqlStatements, $params, $types, $this->queryCacheProfile);
      › }
      arguments: {
        $sql: "SELECT count(DISTINCT b0_.id) AS sclr_0 FROM business_information b0_"
        $params: []
        $types: []
        $qcp: null
      }
    }
    /home/annuairepn/www/aea/vendor/doctrine/orm/src/Query.php:284 {
      Doctrine\ORM\Query->_doExecute(): Result|int …
      › 
      ›     return $executor->execute($this->em->getConnection(), $sqlParams, $types);
      › }
      arguments: {
        $conn: Doctrine\DBAL\Connection {#661 …}
        $params: []
        $types: []
      }
    }
    /home/annuairepn/www/aea/vendor/doctrine/orm/src/AbstractQuery.php:935 {
      Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(Doctrine\Common\Collections\ArrayCollection|array|null $parameters = null, string|int|null $hydrationMode = null): mixed …
      › 
      › $stmt = $this->_doExecute();
      › 
    }
    /home/annuairepn/www/aea/vendor/doctrine/orm/src/AbstractQuery.php:891 {
      Doctrine\ORM\AbstractQuery->execute(Doctrine\Common\Collections\ArrayCollection|array|null $parameters = null, string|int|null $hydrationMode = null): mixed …
      › 
      ›     return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
      › }
      arguments: {
        $parameters: null
        $hydrationMode: 3
      }
    }
    /home/annuairepn/www/aea/vendor/doctrine/orm/src/AbstractQuery.php:725 {
      Doctrine\ORM\AbstractQuery->getScalarResult(): array …
      › {
      ›     return $this->execute(null, self::HYDRATE_SCALAR);
      › }
      arguments: {
        $parameters: null
        $hydrationMode: 3
      }
    }
    /home/annuairepn/www/aea/vendor/doctrine/orm/src/Tools/Pagination/Paginator.php:96 {
      Doctrine\ORM\Tools\Pagination\Paginator->count(): int …
      › try {
      ›     $this->count = (int) array_sum(array_map('current', $this->getCountQuery()->getScalarResult()));
      › } catch (NoResultException) {
    }
    Doctrine\ORM\Tools\Pagination\Paginator->count() {}
    /home/annuairepn/www/aea/vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber.php:43 {
      Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items(ItemsEvent $event): void …
      › } else {
      ›     $event->count = count($paginator);
      › }
      arguments: {
        $value: Doctrine\ORM\Tools\Pagination\Paginator {#787 …}
      }
    }
    /home/annuairepn/www/aea/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);
      › 
      arguments: {
        $event: Knp\Component\Pager\Event\ItemsEvent {#733 …}
        ...: {
          "knp_pager.items"
          Symfony\Component\HttpKernel\Debug\TraceableEventDispatcher {#137 …}
        }
      }
    }
    /home/annuairepn/www/aea/vendor/symfony/event-dispatcher/EventDispatcher.php:230 {
      Symfony\Component\EventDispatcher\EventDispatcher->callListeners(iterable $listeners, string $eventName, object $event) …
      ›     }
      ›     $listener($event, $eventName, $this);
      › }
      arguments: {
        $event: Knp\Component\Pager\Event\ItemsEvent {#733 …}
        $eventName: "knp_pager.items"
        $dispatcher: Symfony\Component\HttpKernel\Debug\TraceableEventDispatcher {#137 …}
      }
    }
    /home/annuairepn/www/aea/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: [ …21]
        $eventName: "knp_pager.items"
        $event: Knp\Component\Pager\Event\ItemsEvent {#733 …}
      }
    }
    /home/annuairepn/www/aea/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 {
      arguments: {
        $event: Knp\Component\Pager\Event\ItemsEvent {#733 …}
        $eventName: "knp_pager.items"
      }
    }
    /home/annuairepn/www/aea/vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php:92 {
      Knp\Component\Pager\Paginator->paginate($target, int $page = 1, int $limit = null, array $options = []): PaginationInterface …
      › $itemsEvent->target = &$target;
      › $this->eventDispatcher->dispatch($itemsEvent, 'knp_pager.items');
      › if (!$itemsEvent->isPropagationStopped()) {
      arguments: {
        $event: Knp\Component\Pager\Event\ItemsEvent {#733 …}
        $eventName: "knp_pager.items"
      }
    }
    /home/annuairepn/www/aea/src/Controller/SearchController.php:48 {
      App\Controller\SearchController->search(Request $request, PaginatorInterface $paginator, BusinessInformationRepository $repository): Response …
      › $request->query->getInt('page', 1),
      › 21);
      › 
      arguments: {
        $target: Doctrine\ORM\Query {#631 …}
        $page: 4079
        $limit: 21
      }
    }
    /home/annuairepn/www/aea/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);
      › 
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#15 …}
        $paginator: Knp\Component\Pager\Paginator {#457 …}
        $repository: App\Repository\BusinessInformationRepository {#490 …}
      }
    }
    /home/annuairepn/www/aea/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 {#15 …}
        $type: 1
      }
    }
    /home/annuairepn/www/aea/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 {#15 …}
        $type: 1
        $catch: true
      }
    }
    /home/annuairepn/www/aea/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 {#15 …}
      }
    }
    /home/annuairepn/www/aea/vendor/autoload_runtime.php:29 {
      require_once …
      ›         ->getRunner($app)
      ›         ->run()
      › );
    }
    /home/annuairepn/www/aea/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
      › 
      arguments: {
        "/home/annuairepn/www/aea/vendor/autoload_runtime.php"
      }
    }
  }
}
logger 
Symfony\Bridge\Monolog\Logger {#71 …9}