https://deamonerp.fr/cpi2/public/fr/planning-formation?lieu=&p=fr%2Fplanning-formation&ref=Formation%20Pupitre%20SIEMENS%20840D&sujet=6&type=3

Forwarded to
ErrorController (e0b90d)
Method
GET
HTTP Status
500
IP
66.249.66.70
Profiled on
Token
d4dc3c

DefaultController :: planningFormation

Request

GET Parameters

Key Value
lieu 
""
p 
"fr/planning-formation"
ref 
"Formation Pupitre SIEMENS 840D"
sujet 
"6"
type 
"3"

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller 
"App\Controller\DefaultController::planningFormation"
_firewall_context 
"security.firewall.map.context.main"
_remove_csp_headers 
true
_route 
"app_planningFormation"
_route_params 
[
  "locale" => "fr"
]
_security_firewall_run 
"_security_main"
_stopwatch_token 
"de0f19"
locale 
"fr"

Request Headers

Header Value
accept 
"text/html,application/xhtml+xml,application/signed-exchange;v=b3,application/xml;q=0.9,*/*;q=0.8"
accept-encoding 
"gzip, deflate, br"
amp-cache-transform 
"google;v="1..8""
connection 
"close"
from 
"googlebot(at)googlebot.com"
host 
"deamonerp.fr"
user-agent 
"Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.6778.204 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
x-accel-internal 
"/internal-nginx-static-location"
x-php-ob-level 
"1"
x-real-ip 
"66.249.66.70"

Request Content

Request content not available (it was retrieved as a resource).

Response

Response Headers

Header Value
cache-control 
"private, must-revalidate"
content-type 
"text/html; charset=UTF-8"
date 
"Sat, 21 Dec 2024 16:11:49 GMT"
expires 
-1
pragma 
"no-cache"
vary 
"Accept"
x-debug-exception 
"%5BSemantical%20Error%5D%20line%200%2C%20col%2094%20near%20%27f%20WHERE%20f.SujetsFormations%27%3A%20Error%3A%20%27f%27%20is%20already%20defined."
x-debug-exception-file 
"%2Fvar%2Fwww%2Fvhosts%2Fdeamonerp.fr%2Fhttpdocs%2Fcpi2%2Fvendor%2Fdoctrine%2Form%2Flib%2FDoctrine%2FORM%2FQuery%2FQueryException.php:45"
x-debug-token 
"d4dc3c"
x-debug-token-link 
"https://deamonerp.fr/cpi2/public/_profiler/e0b90d"
x-previous-debug-token 
"e0b90d"
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_DEV 
"dev"
APP_ENV 
"dev"
APP_SECRET 
"7e5c786ce91b44b1d1df2ea0568252fb"
DATABASE_URL 
"mysql://cpi2:Piranha!2023@127.0.0.1:3306/cpi2"
GOOGLE_RECAPTCHA_SECRET 
""
GOOGLE_RECAPTCHA_SITE_KEY 
""
MESSENGER_TRANSPORT_DSN 
"doctrine://default?auto_setup=0"

Defined as regular env variables

Key Value
APP_DEBUG 
"1"
CONTEXT_DOCUMENT_ROOT 
"/var/www/vhosts/deamonerp.fr/httpdocs"
CONTEXT_PREFIX 
""
DOCUMENT_ROOT 
"/var/www/vhosts/deamonerp.fr/httpdocs"
FCGI_ROLE 
"RESPONDER"
GATEWAY_INTERFACE 
"CGI/1.1"
HTTPS 
"on"
HTTP_ACCEPT 
"text/html,application/xhtml+xml,application/signed-exchange;v=b3,application/xml;q=0.9,*/*;q=0.8"
HTTP_ACCEPT_ENCODING 
"gzip, deflate, br"
HTTP_AMP_CACHE_TRANSFORM 
"google;v="1..8""
HTTP_CONNECTION 
"close"
HTTP_FROM 
"googlebot(at)googlebot.com"
HTTP_HOST 
"deamonerp.fr"
HTTP_USER_AGENT 
"Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.6778.204 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
HTTP_X_ACCEL_INTERNAL 
"/internal-nginx-static-location"
HTTP_X_REAL_IP 
"66.249.66.70"
PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY 
"0"
PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY 
"0"
PATH 
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
PHP_SELF 
"/cpi2/public/index.php"
PP_CUSTOM_PHP_CGI_INDEX 
"plesk-php74-fastcgi"
PP_CUSTOM_PHP_INI 
"/var/www/vhosts/system/deamonerp.fr/etc/php.ini"
QUERY_STRING 
"p=fr/planning-formation&sujet=6&type=3&lieu=&ref=Formation%20Pupitre%20SIEMENS%20840D"
REDIRECT_HTTPS 
"on"
REDIRECT_PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY 
"0"
REDIRECT_PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY 
"0"
REDIRECT_QUERY_STRING 
"p=fr/planning-formation&sujet=6&type=3&lieu=&ref=Formation%20Pupitre%20SIEMENS%20840D"
REDIRECT_SCRIPT_URI 
"https://deamonerp.fr/cpi2/public/fr/planning-formation"
REDIRECT_SCRIPT_URL 
"/cpi2/public/fr/planning-formation"
REDIRECT_STATUS 
"200"
REDIRECT_UNIQUE_ID 
"Z2boxKvYv7GBWparLB@53wAAAAo"
REDIRECT_URL 
"/cpi2/public/fr/planning-formation"
REMOTE_ADDR 
"66.249.66.70"
REMOTE_PORT 
"41596"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"https"
REQUEST_TIME 
1734797508
REQUEST_TIME_FLOAT 
1734797508.5723
REQUEST_URI 
"/cpi2/public/fr/planning-formation?sujet=6&type=3&lieu=&ref=Formation%20Pupitre%20SIEMENS%20840D"
SCRIPT_FILENAME 
"/var/www/vhosts/deamonerp.fr/httpdocs/cpi2/public/index.php"
SCRIPT_NAME 
"/cpi2/public/index.php"
SCRIPT_URI 
"https://deamonerp.fr/cpi2/public/fr/planning-formation"
SCRIPT_URL 
"/cpi2/public/fr/planning-formation"
SERVER_ADDR 
"141.94.247.171"
SERVER_ADMIN 
"[no address given]"
SERVER_NAME 
"deamonerp.fr"
SERVER_PORT 
"443"
SERVER_PROTOCOL 
"HTTP/1.0"
SERVER_SIGNATURE 
"<address>Apache Server at deamonerp.fr Port 443</address>\n"
SERVER_SOFTWARE 
"Apache"
SYMFONY_DOTENV_VARS 
"APP_ENV,APP_DEV,APP_SECRET,DATABASE_URL,MESSENGER_TRANSPORT_DSN,GOOGLE_RECAPTCHA_SITE_KEY,GOOGLE_RECAPTCHA_SECRET"
UNIQUE_ID 
"Z2boxKvYv7GBWparLB@53wAAAAo"

Sub Requests 1

ErrorController (token = e0b90d)

Key Value
_controller 
"error_controller"
_stopwatch_token 
"424fac"
exception 
Doctrine\ORM\Query\QueryException {#1440
  #message: "[Semantical Error] line 0, col 94 near 'f WHERE f.SujetsFormations': Error: 'f' is already defined."
  #code: 0
  #file: "/var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php"
  #line: 45
  -previous: Doctrine\ORM\Query\QueryException {#1490 …}
  trace: {
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:45 {
      Doctrine\ORM\Query\QueryException::semanticalError($message, $previous = null) …
      › {
      ›     return new self('[Semantical Error] ' . $message, 0, $previous);
      › }
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:495 {
      Doctrine\ORM\Query\Parser->semanticalError($message = '', $token = null) …
      › 
      ›     throw QueryException::semanticalError($message, QueryException::dqlError($this->query->getDQL()));
      › }
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:956 {
      Doctrine\ORM\Query\Parser->AliasIdentificationVariable() …
      ›     sprintf("'%s' is already defined.", $aliasIdentVariable),
      ›     $this->lexer->token
      › );
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:1815 {
      Doctrine\ORM\Query\Parser->JoinAssociationDeclaration() …
      › 
      › $aliasIdentificationVariable = $this->AliasIdentificationVariable();
      › $indexBy                     = $this->lexer->isNextToken(Lexer::T_INDEX) ? $this->IndexBy() : null;
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:1740 {
      Doctrine\ORM\Query\Parser->Join() …
      › assert($next !== null);
      › $joinDeclaration = $next->type === Lexer::T_DOT ? $this->JoinAssociationDeclaration() : $this->RangeVariableDeclaration();
      › $adhocConditions = $this->lexer->isNextToken(Lexer::T_WITH);
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:1633 {
      Doctrine\ORM\Query\Parser->IdentificationVariableDeclaration() …
      › ) {
      ›     $joins[] = $this->Join();
      › }
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:1351 {
      Doctrine\ORM\Query\Parser->FromClause() …
      › $identificationVariableDeclarations   = [];
      › $identificationVariableDeclarations[] = $this->IdentificationVariableDeclaration();
      › 
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:881 {
      Doctrine\ORM\Query\Parser->SelectStatement() …
      › {
      ›     $selectStatement = new AST\SelectStatement($this->SelectClause(), $this->FromClause());
      › 
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:850 {
      Doctrine\ORM\Query\Parser->QueryLanguage() …
      › case Lexer::T_SELECT:
      ›     $statement = $this->SelectStatement();
      ›     break;
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:257 {
      Doctrine\ORM\Query\Parser->getAST() …
      › // Parse & build AST
      › $AST = $this->QueryLanguage();
      › 
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:357 {
      Doctrine\ORM\Query\Parser->parse() …
      › {
      ›     $AST = $this->getAST();
      › 
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:274 {
      Doctrine\ORM\Query->parse(): ParserResult …
      › 
      › $this->parserResult = $parser->parse();
      › 
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:286 {
      Doctrine\ORM\Query->_doExecute() …
      › {
      ›     $executor = $this->parse()->getSqlExecutor();
      › 
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212 {
      Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache($parameters = null, $hydrationMode = null) …
      › 
      › $stmt = $this->_doExecute();
      › 
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166 {
      Doctrine\ORM\AbstractQuery->execute($parameters = null, $hydrationMode = null) …
      › 
      ›     return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
      › }
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:901 {
      Doctrine\ORM\AbstractQuery->getResult($hydrationMode = self::HYDRATE_OBJECT) …
      › {
      ›     return $this->execute(null, $hydrationMode);
      › }
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/src/Repository/SessionsFormationsRepository.php:62 {
      App\Repository\SessionsFormationsRepository->findByCriteria($criteria) …
      › 
      ›     return $qb->getQuery()->getResult();
      › }
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/src/Controller/DefaultController.php:1309 {
      App\Controller\DefaultController->planningFormation($locale, FormationsRepository $formationsRepository, VersionsFormationsRepository $versionsFormationsRepository, TypesFormationsRepository $typesFormationsRepository, SujetsFormationsRepository $sujetsFormationsRepository, LogicielsFormationsRepository $logicielsFormationsRepository, SessionsFormationsRepository $sessionsFormationsRepository, Request $request): Response …
      › 
      › $sessionsformations = $sessionsFormationsRepository->findByCriteria($sessionsCriteria);
      › 
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/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);
      › 
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/symfony/http-kernel/HttpKernel.php:75 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->handleRaw($request, $type);
      › } catch (\Exception $e) {
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/symfony/http-kernel/Kernel.php:202 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->getHttpKernel()->handle($request, $type, $catch);
      › } finally {
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
      Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
      › {
      ›     $response = $this->kernel->handle($this->request);
      ›     $response->send();
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/autoload_runtime.php:35 {
      require_once …
      ›         ->getRunner($app)
      ›         ->run()
      › );
    }
    /var/www/vhosts/deamonerp.fr/httpdocs/cpi2/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
      › if($_SERVER['REMOTE_ADDR'] == '90.63.222.84')
      arguments: {
        "/var/www/vhosts/deamonerp.fr/httpdocs/cpi2/vendor/autoload_runtime.php"
      }
    }
  }
}
logger 
Symfony\Bridge\Monolog\Logger {#106 …9}