https://validogresto.infostat-marketing.com/push/pushEvenement

Method
GET
HTTP Status
500
IP
154.120.161.117
Profiled on
Token
b6f108

ErrorController

Request

GET Parameters

No GET parameters

POST Parameters

Key Value
cdS 
"s4"
cdns 
"undefined"
cmnt 
"Qk9OIE5PTSA="
eve 
"CHGTNOM"
id 
"undefined"

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller 
"error_controller"
_stopwatch_token 
"d96da1"
exception 
Doctrine\DBAL\Exception\DriverException {#1074
  #message: """
    An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type bigint: "undefined"\n
    CONTEXT:  unnamed portal parameter $2 = '...'
    """
  #code: 7
  #file: "/home/infostatmut/validation_resto_new/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php"
  #line: 87
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#1081 …}
  -query: Doctrine\DBAL\Query {#1080 …}
  trace: {
    /home/infostatmut/validation_resto_new/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87 {
      Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
      › 
      ›     return new DriverException($exception, $query);
      › }
    }
    /home/infostatmut/validation_resto_new/vendor/doctrine/dbal/src/Connection.php:1976 {
      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 {#1081 …}
        $query: Doctrine\DBAL\Query {#1080 …}
      }
    }
    /home/infostatmut/validation_resto_new/vendor/doctrine/dbal/src/Connection.php:1918 {
      Doctrine\DBAL\Connection->convertExceptionDuringQuery(Exception $e, string $sql, array $params = [], array $types = []): DriverException …
      › ): DriverException {
      ›     return $this->handleDriverException($e, new Query($sql, $params, $types));
      › }
      arguments: {
        $driverException: Doctrine\DBAL\Driver\PDO\Exception {#1081 …}
        $query: Doctrine\DBAL\Query {#1080 …}
      }
    }
    /home/infostatmut/validation_resto_new/vendor/doctrine/dbal/src/Connection.php:1218 {
      Doctrine\DBAL\Connection->executeStatement($sql, array $params = [], array $types = []) …
      › } catch (Driver\Exception $e) {
      ›     throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
      › } finally {
      arguments: {
        $e: Doctrine\DBAL\Driver\PDO\Exception {#1081 …}
        $sql: "UPDATE ogresto.restaurant SET code_saisie = ? WHERE id = ?"
        $params: [ …2]
        $types: [ …2]
      }
    }
    /home/infostatmut/validation_resto_new/vendor/doctrine/orm/src/Query/Exec/SingleTableDeleteUpdateExecutor.php:43 {
      Doctrine\ORM\Query\Exec\SingleTableDeleteUpdateExecutor->execute(Connection $conn, array $params, array $types) …
      › 
      ›     return $conn->executeStatement($this->sqlStatements, $params, $types);
      › }
      arguments: {
        $sql: "UPDATE ogresto.restaurant SET code_saisie = ? WHERE id = ?"
        $params: [ …2]
        $types: [ …2]
      }
    }
    /home/infostatmut/validation_resto_new/vendor/doctrine/orm/src/Query.php:330 {
      Doctrine\ORM\Query->_doExecute() …
      › 
      ›     return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
      › }
      arguments: {
        $conn: Doctrine\DBAL\Connection {#335 …}
        $params: [ …2]
        $types: [ …2]
      }
    }
    /home/infostatmut/validation_resto_new/vendor/doctrine/orm/src/AbstractQuery.php:1218 {
      Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache($parameters = null, $hydrationMode = null) …
      › 
      › $stmt = $this->_doExecute();
      › 
    }
    /home/infostatmut/validation_resto_new/vendor/doctrine/orm/src/AbstractQuery.php:1172 {
      Doctrine\ORM\AbstractQuery->execute($parameters = null, $hydrationMode = null) …
      › 
      ›     return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
      › }
      arguments: {
        $parameters: null
        $hydrationMode: null
      }
    }
    /home/infostatmut/validation_resto_new/src/Repository/RestaurantRepository.php:471 {
      App\Repository\RestaurantRepository->setCodeSaisie($codeSaisie, $id) …
      ›     ->getQuery()
      ›     ->execute();
      › }
    }
    /home/infostatmut/validation_resto_new/src/Repository/RestaurantRepository.php:429 {
      App\Repository\RestaurantRepository->setEvenement($evenement, $codeSaisie, $codens, $comment, $id) …
      ›    $this->pushCommentaire($codens,$id,$comment);
      ›    return $this->setCodeSaisie($codeSaisie,$id);
      › }else{
      arguments: {
        $codeSaisie: "s4"
        $id: "undefined"
      }
    }
    /home/infostatmut/validation_resto_new/src/Service/AgentService.php:121 {
      App\Service\AgentService->setEvenement($evenement, $codeSaisie, $codens, $comment, $id) …
      › public function setEvenement($evenement, $codeSaisie,$codens,$comment,$id){
      ›     $response=$this->resultRestoRep->setEvenement($evenement, $codeSaisie,$codens,$comment,$id);
      ›     $a=["queryResponse"=>$response];
      arguments: {
        $evenement: "CHGTNOM"
        $codeSaisie: "s4"
        $codens: "undefined"
        $comment: "BON NOM "
        $id: "undefined"
      }
    }
    /home/infostatmut/validation_resto_new/src/Controller/API/APIController.php:203 {
      App\Controller\API\APIController->setEvenement(Request $request) …
      ›           $dataRequest['cdS'],$dataRequest['cdns'],
      ›           base64_decode($dataRequest['cmnt']),$dataRequest['id']),Response::HTTP_OK);
      › $response->headers->set('content-Type', 'application/json'); 
      arguments: {
        $evenement: "CHGTNOM"
        $codeSaisie: "s4"
        $codens: "undefined"
        $comment: "BON NOM "
        $id: "undefined"
      }
    }
    /home/infostatmut/validation_resto_new/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 {#2 …}
      }
    }
    /home/infostatmut/validation_resto_new/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 {#2 …}
        $type: 1
      }
    }
    /home/infostatmut/validation_resto_new/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 {#2 …}
        $type: 1
        $catch: true
      }
    }
    /home/infostatmut/validation_resto_new/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 {#2 …}
      }
    }
    /home/infostatmut/validation_resto_new/vendor/autoload_runtime.php:29 {
      require_once …
      ›         ->getRunner($app)
      ›         ->run()
      › );
    }
    /home/infostatmut/validation_resto_new/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
      › 
      arguments: {
        "/home/infostatmut/validation_resto_new/vendor/autoload_runtime.php"
      }
    }
  }
}
logger 
Symfony\Bridge\Monolog\Logger {#56 …9}

Request Headers

Header Value
accept 
"*/*"
accept-encoding 
"gzip, deflate, br, zstd"
accept-language 
"fr-FR,fr;q=0.9,en-US;q=0.8,en;q=0.7"
connection 
"close"
content-length 
"66"
content-type 
"application/x-www-form-urlencoded"
cookie 
"PHPSESSID=c22ed82e384aec01b85e11db40938671"
host 
"validogresto.infostat-marketing.com"
origin 
"https://validogresto.infostat-marketing.com"
priority 
"u=1, i"
referer 
"https://validogresto.infostat-marketing.com/pResto/specialDep"
sec-ch-ua 
""Not;A=Brand";v="99", "Google Chrome";v="139", "Chromium";v="139""
sec-ch-ua-mobile 
"?0"
sec-ch-ua-platform 
""Windows""
sec-fetch-dest 
"empty"
sec-fetch-mode 
"cors"
sec-fetch-site 
"same-origin"
user-agent 
"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36"
via 
"2.0 alproxy"
x-forwarded-proto 
"https"
x-php-ob-level 
"1"

Request Content

Raw

eve=CHGTNOM&cdS=s4&cdns=undefined&id=undefined&cmnt=Qk9OIE5PTSA%3D

Response

Response Headers

Header Value
cache-control 
"no-cache, private"
content-type 
"text/html; charset=UTF-8"
date 
"Tue, 26 Aug 2025 13:39:23 GMT"
x-debug-exception 
"An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5B22P02%5D%3A%20Invalid%20text%20representation%3A%207%20ERROR%3A%20%20invalid%20input%20syntax%20for%20type%20bigint%3A%20%22undefined%22%0ACONTEXT%3A%20%20unnamed%20portal%20parameter%20%242%20%3D%20%27...%27"
x-debug-exception-file 
"%2Fhome%2Finfostatmut%2Fvalidation_resto_new%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FPostgreSQL%2FExceptionConverter.php:87"
x-debug-token 
"b6f108"

Cookies

Request Cookies

Key Value
PHPSESSID 
"c22ed82e384aec01b85e11db40938671"

Response Cookies

No response cookies

Session 1

Session Metadata

Key Value
Created 
"Tue, 26 Aug 25 14:05:01 +0200"
Last used 
"Tue, 26 Aug 25 15:39:13 +0200"
Lifetime 
0

Session Attributes

Attribute Value
_security.last_username 
"tambatra@geomadagascar.com"
_security_main 
"O:74:"Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken":3:{i:0;N;i:1;s:4:"main";i:2;a:5:{i:0;O:15:"App\Entity\User":6:{s:19:"\x00App\Entity\User\x00id";i:15;s:22:"\x00App\Entity\User\x00email";s:26:"tambatra@geomadagascar.com";s:22:"\x00App\Entity\User\x00roles";a:1:{i:0;s:9:"ROLE_USER";}s:25:"\x00App\Entity\User\x00password";s:60:"$2y$13$MCvrWJhV9mlprpJZXt78NecAkSflkwc8QHiz8WH5dVSbEhU1cXHCy";s:21:"\x00App\Entity\User\x00name";s:8:"Tambatra";s:26:"\x00App\Entity\User\x00firstName";s:4:"Iray";}i:1;b:1;i:2;N;i:3;a:0:{}i:4;a:1:{i:0;s:9:"ROLE_USER";}}}"
codinsee 
"13216"
dep 
"13"
topo 
"liste"

Session Usage

1 Usages
Stateless check enabled
Usage
Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage:44
Show trace 
[
  [
    "file" => "/home/infostatmut/validation_resto_new/vendor/symfony/security-core/Authentication/Token/Storage/UsageTrackingTokenStorage.php"
    "line" => 44
    "function" => "getMetadataBag"
    "class" => "Symfony\Component\HttpFoundation\Session\Session"
    "type" => "->"
  ]
  [
    "file" => "/home/infostatmut/validation_resto_new/vendor/symfony/security-core/Authorization/AuthorizationChecker.php"
    "line" => 46
    "function" => "getToken"
    "class" => "Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage"
    "type" => "->"
  ]
  [
    "file" => "/home/infostatmut/validation_resto_new/vendor/symfony/framework-bundle/Controller/AbstractController.php"
    "line" => 191
    "function" => "isGranted"
    "class" => "Symfony\Component\Security\Core\Authorization\AuthorizationChecker"
    "type" => "->"
  ]
  [
    "file" => "/home/infostatmut/validation_resto_new/vendor/symfony/framework-bundle/Controller/AbstractController.php"
    "line" => 202
    "function" => "isGranted"
    "class" => "Symfony\Bundle\FrameworkBundle\Controller\AbstractController"
    "type" => "->"
  ]
  [
    "file" => "/home/infostatmut/validation_resto_new/src/Controller/API/APIController.php"
    "line" => 199
    "function" => "denyAccessUnlessGranted"
    "class" => "Symfony\Bundle\FrameworkBundle\Controller\AbstractController"
    "type" => "->"
  ]
  [
    "file" => "/home/infostatmut/validation_resto_new/vendor/symfony/http-kernel/HttpKernel.php"
    "line" => 163
    "function" => "setEvenement"
    "class" => "App\Controller\API\APIController"
    "type" => "->"
  ]
  [
    "file" => "/home/infostatmut/validation_resto_new/vendor/symfony/http-kernel/HttpKernel.php"
    "line" => 75
    "function" => "handleRaw"
    "class" => "Symfony\Component\HttpKernel\HttpKernel"
    "type" => "->"
  ]
  [
    "file" => "/home/infostatmut/validation_resto_new/vendor/symfony/http-kernel/Kernel.php"
    "line" => 202
    "function" => "handle"
    "class" => "Symfony\Component\HttpKernel\HttpKernel"
    "type" => "->"
  ]
  [
    "file" => "/home/infostatmut/validation_resto_new/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php"
    "line" => 35
    "function" => "handle"
    "class" => "Symfony\Component\HttpKernel\Kernel"
    "type" => "->"
  ]
  [
    "file" => "/home/infostatmut/validation_resto_new/vendor/autoload_runtime.php"
    "line" => 29
    "function" => "run"
    "class" => "Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner"
    "type" => "->"
  ]
  [
    "file" => "/home/infostatmut/validation_resto_new/public/index.php"
    "line" => 5
    "args" => [
      "/home/infostatmut/validation_resto_new/vendor/autoload_runtime.php"
    ]
    "function" => "require_once"
  ]
]

Flashes

Flashes

No flash messages were created.

Server Parameters

Server Parameters

Defined in .env

Key Value
APP_ENV 
"dev"
APP_SECRET 
"66e49efc64b159443445550ff907a8f5"
DATABASE_KEY 
"bvr#2606@ugt"
database_host 
"postgresql-infostatmut.alwaysdata.net"
database_name 
"infostatmut_ogrx"
database_password 
"bvr#2606@ugt"
database_port 
"5432"
database_user 
"infostatmut"

Defined as regular env variables

Key Value
APP_DEBUG 
"1"
CONTENT_LENGTH 
"66"
CONTENT_TYPE 
"application/x-www-form-urlencoded"
CONTEXT_DOCUMENT_ROOT 
"/home/infostatmut/validation_resto_new/public/"
CONTEXT_PREFIX 
""
DOCUMENT_ROOT 
"/home/infostatmut/validation_resto_new/public/"
FCGI_ROLE 
"RESPONDER"
GATEWAY_INTERFACE 
"CGI/1.1"
HOME 
"/home/infostatmut"
HTTPS 
"on"
HTTP_ACCEPT 
"*/*"
HTTP_ACCEPT_ENCODING 
"gzip, deflate, br, zstd"
HTTP_ACCEPT_LANGUAGE 
"fr-FR,fr;q=0.9,en-US;q=0.8,en;q=0.7"
HTTP_CONNECTION 
"close"
HTTP_COOKIE 
"PHPSESSID=c22ed82e384aec01b85e11db40938671"
HTTP_HOST 
"validogresto.infostat-marketing.com"
HTTP_ORIGIN 
"https://validogresto.infostat-marketing.com"
HTTP_PRIORITY 
"u=1, i"
HTTP_REFERER 
"https://validogresto.infostat-marketing.com/pResto/specialDep"
HTTP_SEC_CH_UA 
""Not;A=Brand";v="99", "Google Chrome";v="139", "Chromium";v="139""
HTTP_SEC_CH_UA_MOBILE 
"?0"
HTTP_SEC_CH_UA_PLATFORM 
""Windows""
HTTP_SEC_FETCH_DEST 
"empty"
HTTP_SEC_FETCH_MODE 
"cors"
HTTP_SEC_FETCH_SITE 
"same-origin"
HTTP_USER_AGENT 
"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36"
HTTP_VIA 
"2.0 alproxy"
HTTP_X_FORWARDED_PROTO 
"https"
LANG 
"en_US.UTF-8"
LC_ALL 
"en_US.UTF-8"
PATH 
"/home/infostatmut/.local/bin:/home/infostatmut/.local/share/gem/ruby/1.9.1/bin:/home/infostatmut/.gem/ruby/1.9.1/bin:/home/infostatmut/.composer/vendor/bin:/home/infostatmut/.npm-packages/bin:/usr/local/bin:/usr/bin:/bin"
PHPRC 
"/home/infostatmut/admin/config/php/php-8e9d1704ec.ini"
PHP_SELF 
"/index.php"
PHP_VERSION 
"8.1"
PWD 
"/usr/bin"
QUERY_STRING 
""
REDIRECT_HOME 
"/home/infostatmut"
REDIRECT_LANG 
"en_US.UTF-8"
REDIRECT_LC_ALL 
"en_US.UTF-8"
REDIRECT_STATUS 
"200"
REDIRECT_URL 
"/push/pushEvenement"
REMOTE_ADDR 
"154.120.161.117"
REMOTE_PORT 
"45808"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"https"
REQUEST_TIME 
1756215562
REQUEST_TIME_FLOAT 
1756215562.9639
REQUEST_URI 
"/push/pushEvenement"
SCRIPT_FILENAME 
"/home/infostatmut/validation_resto_new/public/index.php"
SCRIPT_NAME 
"/index.php"
SERVER_ADDR 
"fd00::1:9eed"
SERVER_ADMIN 
"[no address given]"
SERVER_NAME 
"validogresto.infostat-marketing.com"
SERVER_PORT 
"443"
SERVER_PROTOCOL 
"HTTP/1.1"
SERVER_SIGNATURE 
""
SERVER_SOFTWARE 
"Apache"
SHLVL 
"0"
SYMFONY_DOTENV_VARS 
"APP_ENV,APP_SECRET,DATABASE_KEY,database_host,database_port,database_name,database_user,database_password"
argc 
0
argv 
[]

Parent Request

Return to parent request (token = da7288)

Key Value
_controller 
"App\Controller\API\APIController::setEvenement"
_firewall_context 
"security.firewall.map.context.main"
_remove_csp_headers 
true
_route 
"push_evenement"
_route_params 
[]
_security_firewall_run 
"_security_main"
_stopwatch_token 
"af3bc8"