http://opendata.kedirikab.go.id/dataset?judul=%27.sleep%28hexdec%28dechex%2820%29%29%29.%27&p=dataset

Method
GET
HTTP Status
500
IP
172.16.25.100
Profiled on
Token
9e3ca5

ErrorController

Request

GET Parameters

Key Value
judul 
"'.sleep(hexdec(dechex(20))).'"
p 
"dataset"

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller 
"error_controller"
_stopwatch_token 
"afc305"
exception 
Doctrine\ORM\Query\QueryException {#1305
  #message: "[Syntax Error] line 0, col 102: Error: Expected Doctrine\ORM\Query\Lexer::T_CLOSE_PARENTHESIS, got '.'"
  #code: 0
  #file: "/var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php"
  #line: 32
  -previous: Doctrine\ORM\Query\QueryException {#1415 …}
  trace: {
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:32 {
      Doctrine\ORM\Query\QueryException::syntaxError($message, $previous = null) …
      › {
      ›     return new self('[Syntax Error] ' . $message, 0, $previous);
      › }
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:457 {
      Doctrine\ORM\Query\Parser->syntaxError($expected = '', $token = null) …
      › 
      ›     throw QueryException::syntaxError($message, QueryException::dqlError($this->query->getDQL() ?? ''));
      › }
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:311 {
      Doctrine\ORM\Query\Parser->match($token) …
      › if ($token < Lexer::T_IDENTIFIER) {
      ›     $this->syntaxError($this->lexer->getLiteral($token));
      › }
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/AST/Functions/LowerFunction.php:41 {
      Doctrine\ORM\Query\AST\Functions\LowerFunction->parse(Parser $parser) …
      › 
      ›     $parser->match(Lexer::T_CLOSE_PARENTHESIS);
      › }
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:3642 {
      Doctrine\ORM\Query\Parser->FunctionsReturningStrings() …
      › $function = new $funcClass($funcNameLower);
      › $function->parse($this);
      › 
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:3498 {
      Doctrine\ORM\Query\Parser->FunctionDeclaration() …
      › case isset(self::$stringFunctions[$funcName]):
      ›     return $this->FunctionsReturningStrings();
      › 
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:3016 {
      Doctrine\ORM\Query\Parser->StringPrimary() …
      ›     // do NOT directly go to FunctionsReturningString() because it doesn't check for custom functions.
      ›     return $this->FunctionDeclaration();
      › }
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:3313 {
      Doctrine\ORM\Query\Parser->LikeExpression() …
      › } else {
      ›     $stringPattern = $this->StringPrimary();
      › }
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2652 {
      Doctrine\ORM\Query\Parser->SimpleConditionalExpression() …
      › if ($token['type'] === Lexer::T_LIKE) {
      ›     return $this->LikeExpression();
      › }
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2534 {
      Doctrine\ORM\Query\Parser->ConditionalPrimary() …
      › if (! $this->lexer->isNextToken(Lexer::T_OPEN_PARENTHESIS)) {
      ›     $condPrimary->simpleConditionalExpression = $this->SimpleConditionalExpression();
      › 
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2513 {
      Doctrine\ORM\Query\Parser->ConditionalFactor() …
      › 
      › $conditionalPrimary = $this->ConditionalPrimary();
      › 
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2486 {
      Doctrine\ORM\Query\Parser->ConditionalTerm() …
      › 
      ›     $conditionalFactors[] = $this->ConditionalFactor();
      › }
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2456 {
      Doctrine\ORM\Query\Parser->ConditionalExpression() …
      › $conditionalTerms   = [];
      › $conditionalTerms[] = $this->ConditionalTerm();
      › 
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:1391 {
      Doctrine\ORM\Query\Parser->WhereClause() …
      › 
      ›     return new AST\WhereClause($this->ConditionalExpression());
      › }
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:882 {
      Doctrine\ORM\Query\Parser->SelectStatement() …
      › 
      › $selectStatement->whereClause   = $this->lexer->isNextToken(Lexer::T_WHERE) ? $this->WhereClause() : null;
      › $selectStatement->groupByClause = $this->lexer->isNextToken(Lexer::T_GROUP) ? $this->GroupByClause() : null;
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:849 {
      Doctrine\ORM\Query\Parser->QueryLanguage() …
      › case Lexer::T_SELECT:
      ›     $statement = $this->SelectStatement();
      ›     break;
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:256 {
      Doctrine\ORM\Query\Parser->getAST() …
      › // Parse & build AST
      › $AST = $this->QueryLanguage();
      › 
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:356 {
      Doctrine\ORM\Query\Parser->parse() …
      › {
      ›     $AST = $this->getAST();
      › 
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:256 {
      Doctrine\ORM\Tools\Pagination\Paginator->unbindUnusedQueryParams(Query $query): void …
      › $parser            = new Parser($query);
      › $parameterMappings = $parser->parse()->getParameterMappings();
      › /** @var Collection|Parameter[] $parameters */
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:245 {
      Doctrine\ORM\Tools\Pagination\Paginator->getCountQuery(): Query …
      ›     $this->appendTreeWalker($countQuery, CountWalker::class);
      ›     $this->unbindUnusedQueryParams($countQuery);
      › }
    }
    /var/www/html/open_data/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:118 {
      Doctrine\ORM\Tools\Pagination\Paginator->count() …
      › try {
      ›     $this->count = (int) array_sum(array_map('current', $this->getCountQuery()->getScalarResult()));
      › } catch (NoResultException $e) {
    }
    Doctrine\ORM\Tools\Pagination\Paginator->count() {}
    /var/www/html/open_data/vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber.php:46 {
      Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items(ItemsEvent $event): void …
      › } else {
      ›     $event->count = count($paginator);
      › }
    }
    /var/www/html/open_data/vendor/symfony/event-dispatcher/Debug/WrappedListener.php:118 {
      Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object $event, string $eventName, EventDispatcherInterface $dispatcher): void …
      › try {
      ›     ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
      › } finally {
    }
    /var/www/html/open_data/vendor/symfony/event-dispatcher/EventDispatcher.php:230 {
      Symfony\Component\EventDispatcher\EventDispatcher->callListeners(iterable $listeners, string $eventName, object $event) …
      ›     }
      ›     $listener($event, $eventName, $this);
      › }
    }
    /var/www/html/open_data/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);
      › }
    }
    /var/www/html/open_data/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154 {
      Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object $event, string $eventName = null): object …
      › try {
      ›     $this->dispatcher->dispatch($event, $eventName);
      › } finally {
    }
    /var/www/html/open_data/vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php:93 {
      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()) {
    }
    /var/www/html/open_data/var/cache/dev/ContainerF3J4NcO/PaginatorInterface_82dac15.php:30 {
      ContainerF3J4NcO\PaginatorInterface_82dac15->paginate($target, int $page = 1, int $limit = null, array $options = []): PaginationInterface …
      › 
      › if ($this->valueHolderd14db === $returnValue = $this->valueHolderd14db->paginate($target, $page, $limit, $options)) {
      ›     return $this;
    }
    /var/www/html/open_data/src/Controller/Frontend/DatasetController.php:79 {
      App\Controller\Frontend\DatasetController->index(SeoPageInterface $seoPage, Request $request, MKategoriRepository $mKategoriRepo, MKategoriDetailRepository $mKategoriDetailRepo, PaginatorInterface $paginatorInterface, TDivRepository $tDivRepo, MSektorRepository $mSektorRepo, MUrusanRepository $mUrusanRepo, MUrusanDetailRepository $mUrusanDetailRepository, TPublikasiRepository $tPublikasiRepository): Response …
      › 
      › $pagination = $paginatorInterface->paginate($queryBuilder, $request->query->getInt('page', 1), 10);
      › 
    }
    /var/www/html/open_data/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/html/open_data/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/html/open_data/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/html/open_data/public/index.php:20 {
      › $request = Request::createFromGlobals();
      › $response = $kernel->handle($request);
      › $response->send();
    }
  }
}
logger 
null

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""
authorization 
""
connection 
"close"
from 
"googlebot(at)googlebot.com"
host 
"opendata.kedirikab.go.id"
user-agent 
"Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.6778.69 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
x-forwarded-for 
"192.168.60.9"
x-forwarded-proto 
"https"
x-forwarded-scheme 
"https"
x-php-ob-level 
"1"
x-real-ip 
"192.168.60.9"

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 
"Tue, 26 Nov 2024 02:04:26 GMT"
x-debug-exception 
"%5BSyntax%20Error%5D%20line%200%2C%20col%20102%3A%20Error%3A%20Expected%20Doctrine%5CORM%5CQuery%5CLexer%3A%3AT_CLOSE_PARENTHESIS%2C%20got%20%27.%27"
x-debug-exception-file 
"%2Fvar%2Fwww%2Fhtml%2Fopen_data%2Fvendor%2Fdoctrine%2Form%2Flib%2FDoctrine%2FORM%2FQuery%2FQueryException.php:32"
x-debug-token 
"9e3ca5"

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
API_TOKEN 
"4a81432adf56aeb6aadfffa65ab70ab1"
API_URL 
"http://172.16.16.68/api_/opendata.php"
APP_CLIENT_ADDRESS 
"Jl. Sekartaji No.2, Sumber, Doko, Kec. Ngasem, Kabupaten Kediri, Jawa Timur"
APP_CLIENT_CONTACT 
"Telp. (0354) 682152"
APP_CLIENT_EMAIL 
""
APP_CLIENT_NAME 
"Kabupaten Kediri"
APP_CLIENT_SHORTNAME 
"Kabupaten Kediri"
APP_ENV 
"dev"
APP_ICON 
"assets/logo/logo_masbup.png"
APP_ICON_LOGO 
"assets/logo/kota_kediri.png"
APP_NAME 
"Open Data Kediri"
APP_SECRET 
"302717838b52f3d1699a25e8e3ef6a9d"
COLOR_DANGER 
"#b20238;"
COLOR_INFO 
"#e8d21d;"
COLOR_PRIMARY 
"#039fbe;"
COLOR_WARNING 
"#cf1578;"
DATABASE_URL 
"postgresql://postgres:opendata2022!@127.0.0.1:5432/open_data_kediri?serverVersion=13&charset=utf8"
OPEN_DATA_ICON 
"assets/logo/logo_masbup_merah.png"

Defined as regular env variables

Key Value
APP_DEBUG 
"1"
CONTEXT_DOCUMENT_ROOT 
"/var/www/html/open_data/public/"
CONTEXT_PREFIX 
""
DOCUMENT_ROOT 
"/var/www/html/open_data/public/"
GATEWAY_INTERFACE 
"CGI/1.1"
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_AUTHORIZATION 
""
HTTP_CONNECTION 
"close"
HTTP_FROM 
"googlebot(at)googlebot.com"
HTTP_HOST 
"opendata.kedirikab.go.id"
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.69 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
HTTP_X_FORWARDED_FOR 
"192.168.60.9"
HTTP_X_FORWARDED_PROTO 
"https"
HTTP_X_FORWARDED_SCHEME 
"https"
HTTP_X_REAL_IP 
"192.168.60.9"
PATH 
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
PHP_SELF 
"/index.php"
QUERY_STRING 
"p=dataset&judul=%27.sleep%28hexdec%28dechex%2820%29%29%29.%27&p=dataset"
REDIRECT_QUERY_STRING 
"p=dataset&judul=%27.sleep%28hexdec%28dechex%2820%29%29%29.%27&p=dataset"
REDIRECT_STATUS 
"200"
REDIRECT_URL 
"/dataset"
REMOTE_ADDR 
"172.16.25.100"
REMOTE_PORT 
"36634"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"http"
REQUEST_TIME 
1732586665
REQUEST_TIME_FLOAT 
1732586665.4299
REQUEST_URI 
"/dataset?judul=%27.sleep%28hexdec%28dechex%2820%29%29%29.%27&p=dataset"
SCRIPT_FILENAME 
"/var/www/html/open_data/public/index.php"
SCRIPT_NAME 
"/index.php"
SERVER_ADDR 
"172.16.16.52"
SERVER_ADMIN 
"[no address given]"
SERVER_NAME 
"opendata.kedirikab.go.id"
SERVER_PORT 
"80"
SERVER_PROTOCOL 
"HTTP/1.1"
SERVER_SIGNATURE 
""
SERVER_SOFTWARE 
"Apache"
SYMFONY_DOTENV_VARS 
"APP_ENV,APP_SECRET,DATABASE_URL,API_URL,API_TOKEN,APP_NAME,OPEN_DATA_ICON,APP_ICON,APP_ICON_LOGO,APP_CLIENT_NAME,APP_CLIENT_SHORTNAME,APP_CLIENT_ADDRESS,APP_CLIENT_CONTACT,APP_CLIENT_EMAIL,COLOR_PRIMARY,COLOR_WARNING,COLOR_INFO,COLOR_DANGER"

Parent Request

Return to parent request (token = 8c9092)

Key Value
_controller 
"App\Controller\Frontend\DatasetController::index"
_firewall_context 
"security.firewall.map.context.main"
_remove_csp_headers 
true
_route 
"dataset"
_route_params 
[]
_security_firewall_run 
"_security_main"
_stopwatch_token 
"d0486c"