Error 500 Internal Server Error

GET https://mitih-back.synexta-developpement.fr/login_agent

IP
216.73.216.137
Profiled on
Token
b6084f

ErrorController

Request

GET Parameters

None

POST Parameters

None

Uploaded Files

None

Request Attributes

Key Value
_controller 
"error_controller"
_stopwatch_token 
"f43b03"
exception 
Doctrine\DBAL\Exception\InvalidFieldNameException {#6063
  #message: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a0_.telephone' in 'field list'"
  #code: 1054
  #file: "/home/mitih/public_html/back/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
  #line: 67
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#6114 …}
  -query: Doctrine\DBAL\Query {#6170 …}
  trace: {
    /home/mitih/public_html/back/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67 {
      Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
      › case 1611:
      ›     return new InvalidFieldNameException($exception, $query);
      › 
    }
    /home/mitih/public_html/back/vendor/doctrine/dbal/src/Connection.php:1938 {
      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 {#6114 …}
        $query: Doctrine\DBAL\Query {#6170 …}
      }
    }
    /home/mitih/public_html/back/vendor/doctrine/dbal/src/Connection.php:1880 {
      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 {#6114 …}
        $query: Doctrine\DBAL\Query {#6170 …}
      }
    }
    /home/mitih/public_html/back/vendor/doctrine/dbal/src/Connection.php:1105 {
      Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], $types = [], QueryCacheProfile $qcp = null): Result …
      › } catch (Driver\Exception $e) {
      ›     throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
      › } finally {
      arguments: {
        $e: Doctrine\DBAL\Driver\PDO\Exception {#6114 …}
        $sql: "SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.prenom AS prenom_2, a0_.email AS email_3, a0_.telephone AS telephone_4, a0_.portable AS portable_5, a0_.ville AS ville_6, a0_.pays AS pays_7, a0_.code_postal AS code_postal_8, a0_.etat AS etat_9, a0_.competences AS competences_10, a0_.password AS password_11, a0_.adresse AS adresse_12, a0_.type AS type_13, a0_.filiale_id AS filiale_id_14, a0_.entreprise_id AS entreprise_id_15 FROM agent a0_ WHERE a0_.email = '' AND (a0_.password = '6e6da12a96dbbb7bf31b0a748f94f45466e88e0c' OR '6e6da12a96dbbb7bf31b0a748f94f45466e88e0c' = '80077ec5d3a78ea5bb10d9a1a959e378ff9a621d')"
        $params: []
        $types: []
      }
    }
    /home/mitih/public_html/back/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:33 {
      Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Connection $conn, array $params, array $types) …
      › {
      ›     return $conn->executeQuery($this->sqlStatements, $params, $types, $this->queryCacheProfile);
      › }
      arguments: {
        $sql: "SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.prenom AS prenom_2, a0_.email AS email_3, a0_.telephone AS telephone_4, a0_.portable AS portable_5, a0_.ville AS ville_6, a0_.pays AS pays_7, a0_.code_postal AS code_postal_8, a0_.etat AS etat_9, a0_.competences AS competences_10, a0_.password AS password_11, a0_.adresse AS adresse_12, a0_.type AS type_13, a0_.filiale_id AS filiale_id_14, a0_.entreprise_id AS entreprise_id_15 FROM agent a0_ WHERE a0_.email = '' AND (a0_.password = '6e6da12a96dbbb7bf31b0a748f94f45466e88e0c' OR '6e6da12a96dbbb7bf31b0a748f94f45466e88e0c' = '80077ec5d3a78ea5bb10d9a1a959e378ff9a621d')"
        $params: []
        $types: []
        $qcp: null
      }
    }
    /home/mitih/public_html/back/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:327 {
      Doctrine\ORM\Query->_doExecute() …
      › 
      ›     return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
      › }
      arguments: {
        $conn: Doctrine\DBAL\Connection {#5360 …}
        $params: []
        $types: []
      }
    }
    /home/mitih/public_html/back/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212 {
      Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache($parameters = null, $hydrationMode = null) …
      › 
      › $stmt = $this->_doExecute();
      › 
    }
    /home/mitih/public_html/back/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166 {
      Doctrine\ORM\AbstractQuery->execute($parameters = null, $hydrationMode = null) …
      › 
      ›     return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
      › }
      arguments: {
        $parameters: null
        $hydrationMode: null
      }
    }
    /home/mitih/public_html/back/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:953 {
      Doctrine\ORM\AbstractQuery->getOneOrNullResult($hydrationMode = null) …
      › try {
      ›     $result = $this->execute(null, $hydrationMode);
      › } catch (NoResultException $e) {
      arguments: {
        $parameters: null
        $hydrationMode: null
      }
    }
    /home/mitih/public_html/back/src/Service/SuperAdmin.php:344 {
      App\Service\SuperAdmin->getAgent($user, $mdp, $request, $utilisateurs): string …
      ›     '
      › )->getOneOrNullResult();
      › 
    }
    /home/mitih/public_html/back/src/Controller/AuthenticationController.php:549 {
      App\Controller\AuthenticationController->login_agent(Request $request, SuperAdmin $SuperAdmin, AgentRepository $agentRepository): Response …
      › $output = [];
      › $SuperAdminAgent = $SuperAdmin->getAgent(
      ›     $request->get('email'),
      arguments: {
        $user: null
        $mdp: "6e6da12a96dbbb7bf31b0a748f94f45466e88e0c"
        $request: Symfony\Component\HttpFoundation\Request {#2 …}
        $utilisateurs: null
      }
    }
    /home/mitih/public_html/back/vendor/symfony/http-kernel/HttpKernel.php:181 {
      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 …}
        $SuperAdmin: App\Service\SuperAdmin {#439 …}
        $agentRepository: App\Repository\AgentRepository {#2649 …}
      }
    }
    /home/mitih/public_html/back/vendor/symfony/http-kernel/HttpKernel.php:76 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
      › try {
      ›     return $response = $this->handleRaw($request, $type);
      › } catch (\Throwable $e) {
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#2 …}
        $type: 1
      }
    }
    /home/mitih/public_html/back/vendor/symfony/http-kernel/Kernel.php:197 {
      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/mitih/public_html/back/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/mitih/public_html/back/vendor/autoload_runtime.php:29 {
      require_once …
      ›         ->getRunner($app)
      ›         ->run()
      › );
    }
    /home/mitih/public_html/back/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
      › 
      arguments: {
        "/home/mitih/public_html/back/vendor/autoload_runtime.php"
      }
    }
  }
}
logger 
Symfony\Bridge\Monolog\Logger {#11399 …9}

Request Headers

Header Value
accept 
"*/*"
host 
"mitih-back.synexta-developpement.fr"
user-agent 
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
x-forwarded-for 
"216.73.216.137"
x-forwarded-host 
"mitih-back.synexta-developpement.fr"
x-forwarded-port 
"443"
x-forwarded-proto 
"https"
x-forwarded-server 
"mitih-back.synexta-developpement.fr"
x-https 
"1"
x-php-ob-level 
"0"
x-real-ip 
"216.73.216.137"

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, 11 Mar 2026 08:11:09 GMT"
vary 
"Accept"
x-debug-exception 
"An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5B42S22%5D%3A%20Column%20not%20found%3A%201054%20Unknown%20column%20%27a0_.telephone%27%20in%20%27field%20list%27"
x-debug-exception-file 
"%2Fhome%2Fmitih%2Fpublic_html%2Fback%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FMySQL%2FExceptionConverter.php:67"
x-debug-token 
"b6084f"

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 
"15bb5160ce3c76f6fc8c61fc3341ac4f"
DATABASE_URL 
"mysql://mitih_usr:JGaXmvq9z3ri@127.0.0.1:3306/mitih_db2"
MESSENGER_TRANSPORT_DSN 
"doctrine://default?auto_setup=0"

Defined as regular env variables

Key Value
APP_DEBUG 
"1"
CONTEXT_DOCUMENT_ROOT 
"/home/mitih/public_html/back"
CONTEXT_PREFIX 
""
DOCUMENT_ROOT 
"/home/mitih/public_html/back"
FCGI_ROLE 
"RESPONDER"
GATEWAY_INTERFACE 
"CGI/1.1"
HOME 
"/home/mitih"
HTTPS 
"on"
HTTP_ACCEPT 
"*/*"
HTTP_HOST 
"mitih-back.synexta-developpement.fr"
HTTP_USER_AGENT 
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
HTTP_X_FORWARDED_FOR 
"216.73.216.137"
HTTP_X_FORWARDED_HOST 
"mitih-back.synexta-developpement.fr"
HTTP_X_FORWARDED_PORT 
"443"
HTTP_X_FORWARDED_PROTO 
"https"
HTTP_X_FORWARDED_SERVER 
"mitih-back.synexta-developpement.fr"
HTTP_X_HTTPS 
"1"
HTTP_X_REAL_IP 
"216.73.216.137"
PATH 
"/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin"
PHP_SELF 
"/public/index.php"
QUERY_STRING 
""
REDIRECT_HTTPS 
"on"
REDIRECT_REDIRECT_HTTPS 
"on"
REDIRECT_REDIRECT_SCRIPT_URI 
"https://mitih-back.synexta-developpement.fr/login_agent"
REDIRECT_REDIRECT_SCRIPT_URL 
"/login_agent"
REDIRECT_REDIRECT_SSL_TLS_SNI 
"mitih-back.synexta-developpement.fr"
REDIRECT_REDIRECT_STATUS 
"200"
REDIRECT_REDIRECT_isproxyrequest 
"1"
REDIRECT_SCRIPT_URI 
"https://mitih-back.synexta-developpement.fr/login_agent"
REDIRECT_SCRIPT_URL 
"/login_agent"
REDIRECT_SSL_TLS_SNI 
"mitih-back.synexta-developpement.fr"
REDIRECT_STATUS 
"200"
REDIRECT_URL 
"/public/login_agent"
REMOTE_ADDR 
"216.73.216.137"
REMOTE_PORT 
"42296"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"https"
REQUEST_TIME 
1773216667
REQUEST_TIME_FLOAT 
1773216667.3555
REQUEST_URI 
"/login_agent"
SCRIPT_FILENAME 
"/home/mitih/public_html/back/public/index.php"
SCRIPT_NAME 
"/public/index.php"
SCRIPT_URI 
"https://mitih-back.synexta-developpement.fr/login_agent"
SCRIPT_URL 
"/login_agent"
SERVER_ADDR 
"161.97.83.251"
SERVER_ADMIN 
"webmaster@mitih-back.synexta-developpement.fr.mitih.synexta-developpement.fr"
SERVER_NAME 
"mitih-back.synexta-developpement.fr"
SERVER_PORT 
"443"
SERVER_PROTOCOL 
"HTTP/1.0"
SERVER_SIGNATURE 
""
SERVER_SOFTWARE 
"Apache"
SSL_TLS_SNI 
"mitih-back.synexta-developpement.fr"
SYMFONY_DOTENV_VARS 
"APP_ENV,APP_SECRET,DATABASE_URL,MESSENGER_TRANSPORT_DSN"
USER 
"mitih"
argc 
0
argv 
[]
proxy-nokeepalive 
"1"

Parent Request

Return to parent request (token = e01fcc)

Key Value
_controller 
"App\Controller\AuthenticationController::login_agent"
_firewall_context 
"security.firewall.map.context.main"
_remove_csp_headers 
true
_route 
"login_agent"
_route_params 
[]
_security_firewall_run 
"_security_main"
_stopwatch_token 
"3775c3"