https://integral.dirmov.mil.ec/aspirantes/region/undefined/parroquias?p=aspirantes%2Fregion%2Fundefined%2Fparroquias

Forwarded to
ErrorController (d26038)
Method
GET
HTTP Status
500
IP
45.4.201.49
Profiled on
Token
49dfd2

DominioController :: getParroquiasPorRegionAction

Request

GET Parameters

Key Value
p 
"aspirantes/region/undefined/parroquias"

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller 
"App\Controller\DominioController::getParroquiasPorRegionAction"
_firewall_context 
"security.firewall.map.context.main"
_remove_csp_headers 
true
_route 
"parroquias_por_region"
_route_params 
[
  "sel" => -1
  "region" => "undefined"
]
_security_firewall_run 
"_security_main"
_stopwatch_token 
"35bc44"
region 
"undefined"
sel 
-1

Request Headers

Header Value
accept 
"text/html, */*; q=0.01"
accept-encoding 
"gzip, deflate, br"
accept-language 
"es-419,es;q=0.9"
authorization 
""
connection 
"keep-alive"
host 
"integral.dirmov.mil.ec"
referer 
"https://integral.dirmov.mil.ec/aspirantes/registro/linea"
sec-fetch-dest 
"empty"
sec-fetch-mode 
"cors"
sec-fetch-site 
"same-origin"
user-agent 
"Mozilla/5.0 (iPhone; CPU iPhone OS 17_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.6 Mobile/15E148 Safari/604.1"
x-php-ob-level 
"1"
x-requested-with 
"XMLHttpRequest"

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 
"Fri, 20 Sep 2024 20:29:43 GMT"
x-debug-exception 
"%5BSemantical%20Error%5D%20line%200%2C%20col%20179%20near%20%27undefined%20ORDER%27%3A%20Error%3A%20%27undefined%27%20is%20not%20defined."
x-debug-exception-file 
"%2Fdata%2Fproduccion%2Fintegral%2Fvendor%2Fdoctrine%2Form%2Flib%2FDoctrine%2FORM%2FQuery%2FQueryException.php:43"
x-debug-token 
"49dfd2"
x-debug-token-link 
"https://integral.dirmov.mil.ec/_profiler/d26038"
x-previous-debug-token 
"d26038"
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 
"c4d61b67844c8a03b086ad08643ebb84"
DATABASE_URL 
"postgresql://postgres:@integral2024@200.6.25.30:5432/integral_produccion"
LOCK_DSN 
"semaphore"
MAILER_DSN 
"smtp://dirmov1@bfound.ec:Molero1401Dlrowcp2301@darnell.nocdirect.com:465"
MESSENGER_TRANSPORT_DSN 
"doctrine://default?auto_setup=0"
ws_dinardap 
"http://interoperabilidad.dinardap.gob.ec:7979/interoperador?wsdl"
ws_dinardap_v2 
"http://interoperabilidad.dinardap.gob.ec/interoperador-v2?wsdl"

Defined as regular env variables

Key Value
APP_DEBUG 
"1"
CONTEXT_DOCUMENT_ROOT 
"/data/produccion/integral/public"
CONTEXT_PREFIX 
""
DOCUMENT_ROOT 
"/data/produccion/integral/public"
GATEWAY_INTERFACE 
"CGI/1.1"
HTTPS 
"on"
HTTP_ACCEPT 
"text/html, */*; q=0.01"
HTTP_ACCEPT_ENCODING 
"gzip, deflate, br"
HTTP_ACCEPT_LANGUAGE 
"es-419,es;q=0.9"
HTTP_AUTHORIZATION 
""
HTTP_CONNECTION 
"keep-alive"
HTTP_HOST 
"integral.dirmov.mil.ec"
HTTP_REFERER 
"https://integral.dirmov.mil.ec/aspirantes/registro/linea"
HTTP_SEC_FETCH_DEST 
"empty"
HTTP_SEC_FETCH_MODE 
"cors"
HTTP_SEC_FETCH_SITE 
"same-origin"
HTTP_USER_AGENT 
"Mozilla/5.0 (iPhone; CPU iPhone OS 17_6_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.6 Mobile/15E148 Safari/604.1"
HTTP_X_REQUESTED_WITH 
"XMLHttpRequest"
PATH 
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
PHP_SELF 
"/index.php"
QUERY_STRING 
"p=aspirantes/region/undefined/parroquias"
REDIRECT_HTTPS 
"on"
REDIRECT_HTTP_AUTHORIZATION 
""
REDIRECT_QUERY_STRING 
"p=aspirantes/region/undefined/parroquias"
REDIRECT_SCRIPT_URI 
"https://integral.dirmov.mil.ec/aspirantes/region/undefined/parroquias"
REDIRECT_SCRIPT_URL 
"/aspirantes/region/undefined/parroquias"
REDIRECT_SSL_TLS_SNI 
"integral.dirmov.mil.ec"
REDIRECT_STATUS 
"200"
REDIRECT_URL 
"/aspirantes/region/undefined/parroquias"
REMOTE_ADDR 
"45.4.201.49"
REMOTE_PORT 
"9891"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"https"
REQUEST_TIME 
1726864183
REQUEST_TIME_FLOAT 
1726864183.4654
REQUEST_URI 
"/aspirantes/region/undefined/parroquias"
SCRIPT_FILENAME 
"/data/produccion/integral/public/index.php"
SCRIPT_NAME 
"/index.php"
SCRIPT_URI 
"https://integral.dirmov.mil.ec/aspirantes/region/undefined/parroquias"
SCRIPT_URL 
"/aspirantes/region/undefined/parroquias"
SERVER_ADDR 
"200.6.25.29"
SERVER_ADMIN 
"[no address given]"
SERVER_NAME 
"integral.dirmov.mil.ec"
SERVER_PORT 
"443"
SERVER_PROTOCOL 
"HTTP/1.1"
SERVER_SIGNATURE 
"<address>Apache/2.4.52 (Ubuntu) Server at integral.dirmov.mil.ec Port 443</address>\n"
SERVER_SOFTWARE 
"Apache/2.4.52 (Ubuntu)"
SSL_TLS_SNI 
"integral.dirmov.mil.ec"
SYMFONY_DOTENV_VARS 
"APP_ENV,APP_SECRET,MESSENGER_TRANSPORT_DSN,DATABASE_URL,MAILER_DSN,LOCK_DSN,ws_dinardap,ws_dinardap_v2"

Sub Requests 1

ErrorController (token = d26038)

Key Value
_controller 
"error_controller"
_stopwatch_token 
"b72822"
exception 
Doctrine\ORM\Query\QueryException {#651
  #message: "[Semantical Error] line 0, col 179 near 'undefined ORDER': Error: 'undefined' is not defined."
  #code: 0
  #file: "/data/produccion/integral/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php"
  #line: 43
  -previous: Doctrine\ORM\Query\QueryException {#441 …}
  trace: {
    /data/produccion/integral/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:43 {
      Doctrine\ORM\Query\QueryException::semanticalError($message, $previous = null) …
      › {
      ›     return new self('[Semantical Error] ' . $message, 0, $previous);
      › }
    }
    /data/produccion/integral/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:545 {
      Doctrine\ORM\Query\Parser->semanticalError($message = '', $token = null) …
      › 
      ›     throw QueryException::semanticalError($message, QueryException::dqlError($this->query->getDQL()));
      › }
    }
    /data/produccion/integral/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:651 {
      Doctrine\ORM\Query\Parser->processDeferredIdentificationVariables(): void …
      ›     sprintf("'%s' is not defined.", $identVariable),
      ›     $deferredItem['token']
      › );
    }
    /data/produccion/integral/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:311 {
      Doctrine\ORM\Query\Parser->getAST() …
      › // This also allows post-processing of the AST for modification purposes.
      › $this->processDeferredIdentificationVariables();
      › 
    }
    /data/produccion/integral/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:407 {
      Doctrine\ORM\Query\Parser->parse() …
      › {
      ›     $AST = $this->getAST();
      › 
    }
    /data/produccion/integral/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:274 {
      Doctrine\ORM\Query->parse(): ParserResult …
      › 
      › $this->parserResult = $parser->parse();
      › 
    }
    /data/produccion/integral/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:286 {
      Doctrine\ORM\Query->_doExecute() …
      › {
      ›     $executor = $this->parse()->getSqlExecutor();
      › 
    }
    /data/produccion/integral/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1221 {
      Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache($parameters = null, $hydrationMode = null) …
      › 
      › $stmt = $this->_doExecute();
      › 
    }
    /data/produccion/integral/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1175 {
      Doctrine\ORM\AbstractQuery->execute($parameters = null, $hydrationMode = null) …
      › 
      ›     return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
      › }
    }
    /data/produccion/integral/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:911 {
      Doctrine\ORM\AbstractQuery->getResult($hydrationMode = self::HYDRATE_OBJECT) …
      › {
      ›     return $this->execute(null, $hydrationMode);
      › }
    }
    /data/produccion/integral/src/Controller/DominioController.php:47 {
      App\Controller\DominioController->getParroquiasPorRegionAction($region, $sel = -1) …
      › ->orderBy('p.valor')
      › ->getQuery()->getResult();
      › 
    }
    /data/produccion/integral/vendor/symfony/http-kernel/HttpKernel.php:153 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › // call controller
      › $response = $controller(...$arguments);
      › 
    }
    /data/produccion/integral/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) {
    }
    /data/produccion/integral/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 {
    }
    /data/produccion/integral/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
      Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
      › {
      ›     $response = $this->kernel->handle($this->request);
      ›     $response->send();
    }
    /data/produccion/integral/vendor/autoload_runtime.php:29 {
      require_once …
      ›         ->getRunner($app)
      ›         ->run()
      › );
    }
    /data/produccion/integral/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
      › 
      arguments: {
        "/data/produccion/integral/vendor/autoload_runtime.php"
      }
    }
  }
}
logger 
Symfony\Bridge\Monolog\Logger {#133 …8}