http://opendata.kedirikab.go.id/dataset?judul=%27%2Bsleep%2820.to_i%29%2B%27&p=dataset

Forwarded to
ErrorController (55f1d2)
Method
GET
HTTP Status
500
IP
172.16.25.100
Profiled on
Token
a8f27a

Exceptions

QueryException QueryException

HTTP 500 Internal Server Error

[Syntax Error] line 0, col 102: Error: Expected Doctrine\ORM\Query\Lexer::T_CLOSE_PARENTHESIS, got '+'

Exceptions 2

Doctrine\ORM\Query\ QueryException

in vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php (line 32)
  1.      *
  2.      * @return QueryException
  3.      */
  4.     public static function syntaxError($message, $previous = null)
  5.     {
  6.         return new self('[Syntax Error] ' . $message, 0, $previous);
  7.     }
  9.     /**
  10.      * @param string         $message
  11.      * @param Exception|null $previous
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php :: syntaxError (line 457)
  2.         $message  = sprintf('line 0, col %d: Error: ', $tokenPos);
  3.         $message .= $expected !== '' ? sprintf('Expected %s, got ', $expected) : 'Unexpected ';
  4.         $message .= $this->lexer->lookahead === null ? 'end of string.' : sprintf("'%s'", $token['value']);
  6.         throw QueryException::syntaxError($message, QueryException::dqlError($this->query->getDQL() ?? ''));
  7.     }
  9.     /**
  10.      * Generates a new semantical error.
  11.      *
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> syntaxError (line 311)
  1.             return;
  2.         }
  4.         // If parameter is not identifier (1-99) must be exact match
  5.         if ($token < Lexer::T_IDENTIFIER) {
  6.             $this->syntaxError($this->lexer->getLiteral($token));
  7.         }
  9.         // If parameter is keyword (200+) must be exact match
  10.         if ($token > Lexer::T_IDENTIFIER) {
  11.             $this->syntaxError($this->lexer->getLiteral($token));
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/AST/Functions/LowerFunction.php -> match (line 41)
  1.         $parser->match(Lexer::T_IDENTIFIER);
  2.         $parser->match(Lexer::T_OPEN_PARENTHESIS);
  4.         $this->stringPrimary = $parser->StringPrimary();
  6.         $parser->match(Lexer::T_CLOSE_PARENTHESIS);
  7.     }
  8. }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> parse (line 3642)
  1.         assert($this->lexer->lookahead !== null);
  2.         $funcNameLower = strtolower($this->lexer->lookahead['value']);
  3.         $funcClass     = self::$stringFunctions[$funcNameLower];
  5.         $function = new $funcClass($funcNameLower);
  6.         $function->parse($this);
  8.         return $function;
  9.     }
  11.     /** @return Functions\FunctionNode */
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> FunctionsReturningStrings (line 3498)
  1.         switch (true) {
  2.             case $customFunctionDeclaration !== null:
  3.                 return $customFunctionDeclaration;
  5.             case isset(self::$stringFunctions[$funcName]):
  6.                 return $this->FunctionsReturningStrings();
  8.             case isset(self::$numericFunctions[$funcName]):
  9.                 return $this->FunctionsReturningNumerics();
  11.             case isset(self::$datetimeFunctions[$funcName]):
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> FunctionDeclaration (line 3016)
  1.                     return $this->StateFieldPathExpression();
  2.                 }
  4.                 if ($peek['value'] === '(') {
  5.                     // do NOT directly go to FunctionsReturningString() because it doesn't check for custom functions.
  6.                     return $this->FunctionDeclaration();
  7.                 }
  9.                 $this->syntaxError("'.' or '('");
  10.                 break;
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> StringPrimary (line 3313)
  1.         if ($this->lexer->isNextToken(Lexer::T_INPUT_PARAMETER)) {
  2.             $this->match(Lexer::T_INPUT_PARAMETER);
  3.             assert($this->lexer->token !== null);
  4.             $stringPattern = new AST\InputParameter($this->lexer->token['value']);
  5.         } else {
  6.             $stringPattern = $this->StringPrimary();
  7.         }
  9.         $escapeChar = null;
  11.         if ($this->lexer->lookahead !== null && $this->lexer->lookahead['type'] === Lexer::T_ESCAPE) {
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> LikeExpression (line 2652)
  1.         if ($token['type'] === Lexer::T_BETWEEN) {
  2.             return $this->BetweenExpression();
  3.         }
  5.         if ($token['type'] === Lexer::T_LIKE) {
  6.             return $this->LikeExpression();
  7.         }
  9.         if ($token['type'] === Lexer::T_IN) {
  10.             return $this->InExpression();
  11.         }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> SimpleConditionalExpression (line 2534)
  1.     public function ConditionalPrimary()
  2.     {
  3.         $condPrimary = new AST\ConditionalPrimary();
  5.         if (! $this->lexer->isNextToken(Lexer::T_OPEN_PARENTHESIS)) {
  6.             $condPrimary->simpleConditionalExpression = $this->SimpleConditionalExpression();
  8.             return $condPrimary;
  9.         }
  11.         // Peek beyond the matching closing parenthesis ')'
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> ConditionalPrimary (line 2513)
  1.             $this->match(Lexer::T_NOT);
  3.             $not = true;
  4.         }
  6.         $conditionalPrimary = $this->ConditionalPrimary();
  8.         // Phase 1 AST optimization: Prevent AST\ConditionalFactor
  9.         // if only one AST\ConditionalPrimary is defined
  10.         if (! $not) {
  11.             return $conditionalPrimary;
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> ConditionalFactor (line 2486)
  1.         $conditionalFactors[] = $this->ConditionalFactor();
  3.         while ($this->lexer->isNextToken(Lexer::T_AND)) {
  4.             $this->match(Lexer::T_AND);
  6.             $conditionalFactors[] = $this->ConditionalFactor();
  7.         }
  9.         // Phase 1 AST optimization: Prevent AST\ConditionalTerm
  10.         // if only one AST\ConditionalFactor is defined
  11.         if (count($conditionalFactors) === 1) {
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> ConditionalTerm (line 2456)
  1.      * @return AST\ConditionalExpression|AST\ConditionalFactor|AST\ConditionalPrimary|AST\ConditionalTerm
  2.      */
  3.     public function ConditionalExpression()
  4.     {
  5.         $conditionalTerms   = [];
  6.         $conditionalTerms[] = $this->ConditionalTerm();
  8.         while ($this->lexer->isNextToken(Lexer::T_OR)) {
  9.             $this->match(Lexer::T_OR);
  11.             $conditionalTerms[] = $this->ConditionalTerm();
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> ConditionalExpression (line 1391)
  1.      */
  2.     public function WhereClause()
  3.     {
  4.         $this->match(Lexer::T_WHERE);
  6.         return new AST\WhereClause($this->ConditionalExpression());
  7.     }
  9.     /**
  10.      * HavingClause ::= "HAVING" ConditionalExpression
  11.      *
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> WhereClause (line 882)
  1.      */
  2.     public function SelectStatement()
  3.     {
  4.         $selectStatement = new AST\SelectStatement($this->SelectClause(), $this->FromClause());
  6.         $selectStatement->whereClause   = $this->lexer->isNextToken(Lexer::T_WHERE) ? $this->WhereClause() : null;
  7.         $selectStatement->groupByClause = $this->lexer->isNextToken(Lexer::T_GROUP) ? $this->GroupByClause() : null;
  8.         $selectStatement->havingClause  = $this->lexer->isNextToken(Lexer::T_HAVING) ? $this->HavingClause() : null;
  9.         $selectStatement->orderByClause = $this->lexer->isNextToken(Lexer::T_ORDER) ? $this->OrderByClause() : null;
  11.         return $selectStatement;
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> SelectStatement (line 849)
  2.         $this->lexer->moveNext();
  4.         switch ($this->lexer->lookahead['type'] ?? null) {
  5.             case Lexer::T_SELECT:
  6.                 $statement = $this->SelectStatement();
  7.                 break;
  9.             case Lexer::T_UPDATE:
  10.                 $statement = $this->UpdateStatement();
  11.                 break;
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> QueryLanguage (line 256)
  1.      * @return AST\SelectStatement|AST\UpdateStatement|AST\DeleteStatement
  2.      */
  3.     public function getAST()
  4.     {
  5.         // Parse & build AST
  6.         $AST = $this->QueryLanguage();
  8.         // Process any deferred validations of some nodes in the AST.
  9.         // This also allows post-processing of the AST for modification purposes.
  10.         $this->processDeferredIdentificationVariables();
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> getAST (line 356)
  1.      *
  2.      * @return ParserResult
  3.      */
  4.     public function parse()
  5.     {
  6.         $AST = $this->getAST();
  8.         $customWalkers = $this->query->getHint(Query::HINT_CUSTOM_TREE_WALKERS);
  9.         if ($customWalkers !== false) {
  10.             $this->customTreeWalkers = $customWalkers;
  11.         }
in vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php -> parse (line 256)
  1.     }
  3.     private function unbindUnusedQueryParams(Query $query): void
  4.     {
  5.         $parser            = new Parser($query);
  6.         $parameterMappings = $parser->parse()->getParameterMappings();
  7.         /** @var Collection|Parameter[] $parameters */
  8.         $parameters = $query->getParameters();
  10.         foreach ($parameters as $key => $parameter) {
  11.             $parameterName = $parameter->getName();
in vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php -> unbindUnusedQueryParams (line 245)
  2.             $countQuery->setHint(Query::HINT_CUSTOM_OUTPUT_WALKER, CountOutputWalker::class);
  3.             $countQuery->setResultSetMapping($rsm);
  4.         } else {
  5.             $this->appendTreeWalker($countQuery, CountWalker::class);
  6.             $this->unbindUnusedQueryParams($countQuery);
  7.         }
  9.         $countQuery->setFirstResult(0)->setMaxResults(null);
  11.         return $countQuery;
in vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php -> getCountQuery (line 118)
  1.     #[ReturnTypeWillChange]
  2.     public function count()
  3.     {
  4.         if ($this->count === null) {
  5.             try {
  6.                 $this->count = (int) array_sum(array_map('current', $this->getCountQuery()->getScalarResult()));
  7.             } catch (NoResultException $e) {
  8.                 $this->count = 0;
  9.             }
  10.         }
Paginator->count()
in vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber.php count (line 46)
  1.         $paginator = new Paginator($event->target, $fetchJoinCollection);
  2.         $paginator->setUseOutputWalkers($useOutputWalkers);
  3.         if (($count = $event->target->getHint(self::HINT_COUNT)) !== false) {
  4.             $event->count = (int) $count;
  5.         } else {
  6.             $event->count = count($paginator);
  7.         }
  8.         $event->items = iterator_to_array($paginator);
  9.     }
  11.     public static function getSubscribedEvents(): array
in vendor/symfony/event-dispatcher/Debug/WrappedListener.php -> items (line 118)
  1.         $this->priority = $dispatcher->getListenerPriority($eventName, $this->listener);
  3.         $e = $this->stopwatch->start($this->name, 'event_listener');
  5.         try {
  6.             ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
  7.         } finally {
  8.             if ($e->isStarted()) {
  9.                 $e->stop();
  10.             }
  11.         }
in vendor/symfony/event-dispatcher/EventDispatcher.php -> __invoke (line 230)
  2.         foreach ($listeners as $listener) {
  3.             if ($stoppable && $event->isPropagationStopped()) {
  4.                 break;
  5.             }
  6.             $listener($event, $eventName, $this);
  7.         }
  8.     }
  10.     /**
  11.      * Sorts the internal list of listeners for the given event by priority.
in vendor/symfony/event-dispatcher/EventDispatcher.php -> callListeners (line 59)
  1.         } else {
  2.             $listeners = $this->getListeners($eventName);
  3.         }
  5.         if ($listeners) {
  6.             $this->callListeners($listeners, $eventName, $event);
  7.         }
  9.         return $event;
  10.     }
in vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php -> dispatch (line 154)
  1.         try {
  2.             $this->beforeDispatch($eventName, $event);
  3.             try {
  4.                 $e = $this->stopwatch->start($eventName, 'section');
  5.                 try {
  6.                     $this->dispatcher->dispatch($event, $eventName);
  7.                 } finally {
  8.                     if ($e->isStarted()) {
  9.                         $e->stop();
  10.                     }
  11.                 }
in vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php -> dispatch (line 93)
  1.         $this->eventDispatcher->dispatch($beforeEvent, 'knp_pager.before');
  2.         // items
  3.         $itemsEvent = new Event\ItemsEvent($offset, $limit);
  4.         $itemsEvent->options = &$options;
  5.         $itemsEvent->target = &$target;
  6.         $this->eventDispatcher->dispatch($itemsEvent, 'knp_pager.items');
  7.         if (!$itemsEvent->isPropagationStopped()) {
  8.             throw new \RuntimeException('One of listeners must count and slice given target');
  9.         }
  10.         if ($page > ceil($itemsEvent->count / $limit)) {
  11.             $pageOutOfRangeOption = $options[PaginatorInterface::PAGE_OUT_OF_RANGE] ?? $this->defaultOptions[PaginatorInterface::PAGE_OUT_OF_RANGE];
in var/cache/dev/ContainerF3J4NcO/PaginatorInterface_82dac15.php -> paginate (line 30)
  2.     public function paginate($target, int $page = 1, ?int $limit = null, array $options = []) : \Knp\Component\Pager\Pagination\PaginationInterface
  3.     {
  4.         $this->initializer56dfc && ($this->initializer56dfc->__invoke($valueHolderd14db, $this, 'paginate', array('target' => $target, 'page' => $page, 'limit' => $limit, 'options' => $options), $this->initializer56dfc) || 1) && $this->valueHolderd14db = $valueHolderd14db;
  6.         if ($this->valueHolderd14db === $returnValue = $this->valueHolderd14db->paginate($target, $page, $limit, $options)) {
  7.             return $this;
  8.         }
  10.         return $returnValue;
  11.     }
PaginatorInterface_82dac15->paginate() in src/Controller/Frontend/DatasetController.php (line 79)
  1.             $queryBuilder = $queryBuilder->andWhere("this.sektor = " . $request->get('sektor'));
  2.         }
  3.         $queryBuilder = $queryBuilder->addOrderBy('this.id', 'desc');
  4.         // dump($queryBuilder->getQuery()->getResult());exit;
  6.         $pagination = $paginatorInterface->paginate($queryBuilder, $request->query->getInt('page', 1), 10);
  8.         $kategori = array();
  9.         $icons = array();
  10.         foreach ($pagination as $pub) {
  11.             $kategori_detail = $mUrusanDetailRepository->findBy(['reff_id' => $pub->getId(), 'reff_name' => 'PUBLIKASI'], ['id' => 'ASC']);
in vendor/symfony/http-kernel/HttpKernel.php -> index (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 75)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Exception $e) {
  8.             if ($e instanceof RequestExceptionInterface) {
  9.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  10.             }
  11.             if (false === $catch) {
in vendor/symfony/http-kernel/Kernel.php -> handle (line 202)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
Kernel->handle() in public/index.php (line 20)
  1.     Debug::enable();
  2. }
  4. $kernel = new Kernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  5. $request = Request::createFromGlobals();
  6. $response = $kernel->handle($request);
  7. $response->send();
  8. $kernel->terminate($request, $response);

Doctrine\ORM\Query\ QueryException

SELECT this FROM App\Entity\TPublikasi this WHERE this.status = 3 AND lower(this.judul) LIKE lower('%'+sleep(20.to_i)+'%') ORDER BY this.id desc

in vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php (line 21)
  1.      *
  2.      * @return QueryException
  3.      */
  4.     public static function dqlError($dql)
  5.     {
  6.         return new self($dql);
  7.     }
  9.     /**
  10.      * @param string         $message
  11.      * @param Exception|null $previous
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php :: dqlError (line 457)
  2.         $message  = sprintf('line 0, col %d: Error: ', $tokenPos);
  3.         $message .= $expected !== '' ? sprintf('Expected %s, got ', $expected) : 'Unexpected ';
  4.         $message .= $this->lexer->lookahead === null ? 'end of string.' : sprintf("'%s'", $token['value']);
  6.         throw QueryException::syntaxError($message, QueryException::dqlError($this->query->getDQL() ?? ''));
  7.     }
  9.     /**
  10.      * Generates a new semantical error.
  11.      *
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> syntaxError (line 311)
  1.             return;
  2.         }
  4.         // If parameter is not identifier (1-99) must be exact match
  5.         if ($token < Lexer::T_IDENTIFIER) {
  6.             $this->syntaxError($this->lexer->getLiteral($token));
  7.         }
  9.         // If parameter is keyword (200+) must be exact match
  10.         if ($token > Lexer::T_IDENTIFIER) {
  11.             $this->syntaxError($this->lexer->getLiteral($token));
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/AST/Functions/LowerFunction.php -> match (line 41)
  1.         $parser->match(Lexer::T_IDENTIFIER);
  2.         $parser->match(Lexer::T_OPEN_PARENTHESIS);
  4.         $this->stringPrimary = $parser->StringPrimary();
  6.         $parser->match(Lexer::T_CLOSE_PARENTHESIS);
  7.     }
  8. }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> parse (line 3642)
  1.         assert($this->lexer->lookahead !== null);
  2.         $funcNameLower = strtolower($this->lexer->lookahead['value']);
  3.         $funcClass     = self::$stringFunctions[$funcNameLower];
  5.         $function = new $funcClass($funcNameLower);
  6.         $function->parse($this);
  8.         return $function;
  9.     }
  11.     /** @return Functions\FunctionNode */
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> FunctionsReturningStrings (line 3498)
  1.         switch (true) {
  2.             case $customFunctionDeclaration !== null:
  3.                 return $customFunctionDeclaration;
  5.             case isset(self::$stringFunctions[$funcName]):
  6.                 return $this->FunctionsReturningStrings();
  8.             case isset(self::$numericFunctions[$funcName]):
  9.                 return $this->FunctionsReturningNumerics();
  11.             case isset(self::$datetimeFunctions[$funcName]):
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> FunctionDeclaration (line 3016)
  1.                     return $this->StateFieldPathExpression();
  2.                 }
  4.                 if ($peek['value'] === '(') {
  5.                     // do NOT directly go to FunctionsReturningString() because it doesn't check for custom functions.
  6.                     return $this->FunctionDeclaration();
  7.                 }
  9.                 $this->syntaxError("'.' or '('");
  10.                 break;
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> StringPrimary (line 3313)
  1.         if ($this->lexer->isNextToken(Lexer::T_INPUT_PARAMETER)) {
  2.             $this->match(Lexer::T_INPUT_PARAMETER);
  3.             assert($this->lexer->token !== null);
  4.             $stringPattern = new AST\InputParameter($this->lexer->token['value']);
  5.         } else {
  6.             $stringPattern = $this->StringPrimary();
  7.         }
  9.         $escapeChar = null;
  11.         if ($this->lexer->lookahead !== null && $this->lexer->lookahead['type'] === Lexer::T_ESCAPE) {
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> LikeExpression (line 2652)
  1.         if ($token['type'] === Lexer::T_BETWEEN) {
  2.             return $this->BetweenExpression();
  3.         }
  5.         if ($token['type'] === Lexer::T_LIKE) {
  6.             return $this->LikeExpression();
  7.         }
  9.         if ($token['type'] === Lexer::T_IN) {
  10.             return $this->InExpression();
  11.         }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> SimpleConditionalExpression (line 2534)
  1.     public function ConditionalPrimary()
  2.     {
  3.         $condPrimary = new AST\ConditionalPrimary();
  5.         if (! $this->lexer->isNextToken(Lexer::T_OPEN_PARENTHESIS)) {
  6.             $condPrimary->simpleConditionalExpression = $this->SimpleConditionalExpression();
  8.             return $condPrimary;
  9.         }
  11.         // Peek beyond the matching closing parenthesis ')'
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> ConditionalPrimary (line 2513)
  1.             $this->match(Lexer::T_NOT);
  3.             $not = true;
  4.         }
  6.         $conditionalPrimary = $this->ConditionalPrimary();
  8.         // Phase 1 AST optimization: Prevent AST\ConditionalFactor
  9.         // if only one AST\ConditionalPrimary is defined
  10.         if (! $not) {
  11.             return $conditionalPrimary;
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> ConditionalFactor (line 2486)
  1.         $conditionalFactors[] = $this->ConditionalFactor();
  3.         while ($this->lexer->isNextToken(Lexer::T_AND)) {
  4.             $this->match(Lexer::T_AND);
  6.             $conditionalFactors[] = $this->ConditionalFactor();
  7.         }
  9.         // Phase 1 AST optimization: Prevent AST\ConditionalTerm
  10.         // if only one AST\ConditionalFactor is defined
  11.         if (count($conditionalFactors) === 1) {
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> ConditionalTerm (line 2456)
  1.      * @return AST\ConditionalExpression|AST\ConditionalFactor|AST\ConditionalPrimary|AST\ConditionalTerm
  2.      */
  3.     public function ConditionalExpression()
  4.     {
  5.         $conditionalTerms   = [];
  6.         $conditionalTerms[] = $this->ConditionalTerm();
  8.         while ($this->lexer->isNextToken(Lexer::T_OR)) {
  9.             $this->match(Lexer::T_OR);
  11.             $conditionalTerms[] = $this->ConditionalTerm();
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> ConditionalExpression (line 1391)
  1.      */
  2.     public function WhereClause()
  3.     {
  4.         $this->match(Lexer::T_WHERE);
  6.         return new AST\WhereClause($this->ConditionalExpression());
  7.     }
  9.     /**
  10.      * HavingClause ::= "HAVING" ConditionalExpression
  11.      *
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> WhereClause (line 882)
  1.      */
  2.     public function SelectStatement()
  3.     {
  4.         $selectStatement = new AST\SelectStatement($this->SelectClause(), $this->FromClause());
  6.         $selectStatement->whereClause   = $this->lexer->isNextToken(Lexer::T_WHERE) ? $this->WhereClause() : null;
  7.         $selectStatement->groupByClause = $this->lexer->isNextToken(Lexer::T_GROUP) ? $this->GroupByClause() : null;
  8.         $selectStatement->havingClause  = $this->lexer->isNextToken(Lexer::T_HAVING) ? $this->HavingClause() : null;
  9.         $selectStatement->orderByClause = $this->lexer->isNextToken(Lexer::T_ORDER) ? $this->OrderByClause() : null;
  11.         return $selectStatement;
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> SelectStatement (line 849)
  2.         $this->lexer->moveNext();
  4.         switch ($this->lexer->lookahead['type'] ?? null) {
  5.             case Lexer::T_SELECT:
  6.                 $statement = $this->SelectStatement();
  7.                 break;
  9.             case Lexer::T_UPDATE:
  10.                 $statement = $this->UpdateStatement();
  11.                 break;
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> QueryLanguage (line 256)
  1.      * @return AST\SelectStatement|AST\UpdateStatement|AST\DeleteStatement
  2.      */
  3.     public function getAST()
  4.     {
  5.         // Parse & build AST
  6.         $AST = $this->QueryLanguage();
  8.         // Process any deferred validations of some nodes in the AST.
  9.         // This also allows post-processing of the AST for modification purposes.
  10.         $this->processDeferredIdentificationVariables();
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> getAST (line 356)
  1.      *
  2.      * @return ParserResult
  3.      */
  4.     public function parse()
  5.     {
  6.         $AST = $this->getAST();
  8.         $customWalkers = $this->query->getHint(Query::HINT_CUSTOM_TREE_WALKERS);
  9.         if ($customWalkers !== false) {
  10.             $this->customTreeWalkers = $customWalkers;
  11.         }
in vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php -> parse (line 256)
  1.     }
  3.     private function unbindUnusedQueryParams(Query $query): void
  4.     {
  5.         $parser            = new Parser($query);
  6.         $parameterMappings = $parser->parse()->getParameterMappings();
  7.         /** @var Collection|Parameter[] $parameters */
  8.         $parameters = $query->getParameters();
  10.         foreach ($parameters as $key => $parameter) {
  11.             $parameterName = $parameter->getName();
in vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php -> unbindUnusedQueryParams (line 245)
  2.             $countQuery->setHint(Query::HINT_CUSTOM_OUTPUT_WALKER, CountOutputWalker::class);
  3.             $countQuery->setResultSetMapping($rsm);
  4.         } else {
  5.             $this->appendTreeWalker($countQuery, CountWalker::class);
  6.             $this->unbindUnusedQueryParams($countQuery);
  7.         }
  9.         $countQuery->setFirstResult(0)->setMaxResults(null);
  11.         return $countQuery;
in vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php -> getCountQuery (line 118)
  1.     #[ReturnTypeWillChange]
  2.     public function count()
  3.     {
  4.         if ($this->count === null) {
  5.             try {
  6.                 $this->count = (int) array_sum(array_map('current', $this->getCountQuery()->getScalarResult()));
  7.             } catch (NoResultException $e) {
  8.                 $this->count = 0;
  9.             }
  10.         }
Paginator->count()
in vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber.php count (line 46)
  1.         $paginator = new Paginator($event->target, $fetchJoinCollection);
  2.         $paginator->setUseOutputWalkers($useOutputWalkers);
  3.         if (($count = $event->target->getHint(self::HINT_COUNT)) !== false) {
  4.             $event->count = (int) $count;
  5.         } else {
  6.             $event->count = count($paginator);
  7.         }
  8.         $event->items = iterator_to_array($paginator);
  9.     }
  11.     public static function getSubscribedEvents(): array
in vendor/symfony/event-dispatcher/Debug/WrappedListener.php -> items (line 118)
  1.         $this->priority = $dispatcher->getListenerPriority($eventName, $this->listener);
  3.         $e = $this->stopwatch->start($this->name, 'event_listener');
  5.         try {
  6.             ($this->optimizedListener ?? $this->listener)($event, $eventName, $dispatcher);
  7.         } finally {
  8.             if ($e->isStarted()) {
  9.                 $e->stop();
  10.             }
  11.         }
in vendor/symfony/event-dispatcher/EventDispatcher.php -> __invoke (line 230)
  2.         foreach ($listeners as $listener) {
  3.             if ($stoppable && $event->isPropagationStopped()) {
  4.                 break;
  5.             }
  6.             $listener($event, $eventName, $this);
  7.         }
  8.     }
  10.     /**
  11.      * Sorts the internal list of listeners for the given event by priority.
in vendor/symfony/event-dispatcher/EventDispatcher.php -> callListeners (line 59)
  1.         } else {
  2.             $listeners = $this->getListeners($eventName);
  3.         }
  5.         if ($listeners) {
  6.             $this->callListeners($listeners, $eventName, $event);
  7.         }
  9.         return $event;
  10.     }
in vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php -> dispatch (line 154)
  1.         try {
  2.             $this->beforeDispatch($eventName, $event);
  3.             try {
  4.                 $e = $this->stopwatch->start($eventName, 'section');
  5.                 try {
  6.                     $this->dispatcher->dispatch($event, $eventName);
  7.                 } finally {
  8.                     if ($e->isStarted()) {
  9.                         $e->stop();
  10.                     }
  11.                 }
in vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php -> dispatch (line 93)
  1.         $this->eventDispatcher->dispatch($beforeEvent, 'knp_pager.before');
  2.         // items
  3.         $itemsEvent = new Event\ItemsEvent($offset, $limit);
  4.         $itemsEvent->options = &$options;
  5.         $itemsEvent->target = &$target;
  6.         $this->eventDispatcher->dispatch($itemsEvent, 'knp_pager.items');
  7.         if (!$itemsEvent->isPropagationStopped()) {
  8.             throw new \RuntimeException('One of listeners must count and slice given target');
  9.         }
  10.         if ($page > ceil($itemsEvent->count / $limit)) {
  11.             $pageOutOfRangeOption = $options[PaginatorInterface::PAGE_OUT_OF_RANGE] ?? $this->defaultOptions[PaginatorInterface::PAGE_OUT_OF_RANGE];
in var/cache/dev/ContainerF3J4NcO/PaginatorInterface_82dac15.php -> paginate (line 30)
  2.     public function paginate($target, int $page = 1, ?int $limit = null, array $options = []) : \Knp\Component\Pager\Pagination\PaginationInterface
  3.     {
  4.         $this->initializer56dfc && ($this->initializer56dfc->__invoke($valueHolderd14db, $this, 'paginate', array('target' => $target, 'page' => $page, 'limit' => $limit, 'options' => $options), $this->initializer56dfc) || 1) && $this->valueHolderd14db = $valueHolderd14db;
  6.         if ($this->valueHolderd14db === $returnValue = $this->valueHolderd14db->paginate($target, $page, $limit, $options)) {
  7.             return $this;
  8.         }
  10.         return $returnValue;
  11.     }
PaginatorInterface_82dac15->paginate() in src/Controller/Frontend/DatasetController.php (line 79)
  1.             $queryBuilder = $queryBuilder->andWhere("this.sektor = " . $request->get('sektor'));
  2.         }
  3.         $queryBuilder = $queryBuilder->addOrderBy('this.id', 'desc');
  4.         // dump($queryBuilder->getQuery()->getResult());exit;
  6.         $pagination = $paginatorInterface->paginate($queryBuilder, $request->query->getInt('page', 1), 10);
  8.         $kategori = array();
  9.         $icons = array();
  10.         foreach ($pagination as $pub) {
  11.             $kategori_detail = $mUrusanDetailRepository->findBy(['reff_id' => $pub->getId(), 'reff_name' => 'PUBLIKASI'], ['id' => 'ASC']);
in vendor/symfony/http-kernel/HttpKernel.php -> index (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 75)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Exception $e) {
  8.             if ($e instanceof RequestExceptionInterface) {
  9.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  10.             }
  11.             if (false === $catch) {
in vendor/symfony/http-kernel/Kernel.php -> handle (line 202)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
Kernel->handle() in public/index.php (line 20)
  1.     Debug::enable();
  2. }
  4. $kernel = new Kernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  5. $request = Request::createFromGlobals();
  6. $response = $kernel->handle($request);
  7. $response->send();
  8. $kernel->terminate($request, $response);

Stack Traces 2

[2/2] QueryException 
Doctrine\ORM\Query\QueryException:
[Syntax Error] line 0, col 102: Error: Expected Doctrine\ORM\Query\Lexer::T_CLOSE_PARENTHESIS, got '+'

  at vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:32
  at Doctrine\ORM\Query\QueryException::syntaxError()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:457)
  at Doctrine\ORM\Query\Parser->syntaxError()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:311)
  at Doctrine\ORM\Query\Parser->match()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/AST/Functions/LowerFunction.php:41)
  at Doctrine\ORM\Query\AST\Functions\LowerFunction->parse()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:3642)
  at Doctrine\ORM\Query\Parser->FunctionsReturningStrings()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:3498)
  at Doctrine\ORM\Query\Parser->FunctionDeclaration()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:3016)
  at Doctrine\ORM\Query\Parser->StringPrimary()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:3313)
  at Doctrine\ORM\Query\Parser->LikeExpression()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2652)
  at Doctrine\ORM\Query\Parser->SimpleConditionalExpression()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2534)
  at Doctrine\ORM\Query\Parser->ConditionalPrimary()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2513)
  at Doctrine\ORM\Query\Parser->ConditionalFactor()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2486)
  at Doctrine\ORM\Query\Parser->ConditionalTerm()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2456)
  at Doctrine\ORM\Query\Parser->ConditionalExpression()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:1391)
  at Doctrine\ORM\Query\Parser->WhereClause()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:882)
  at Doctrine\ORM\Query\Parser->SelectStatement()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:849)
  at Doctrine\ORM\Query\Parser->QueryLanguage()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:256)
  at Doctrine\ORM\Query\Parser->getAST()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:356)
  at Doctrine\ORM\Query\Parser->parse()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:256)
  at Doctrine\ORM\Tools\Pagination\Paginator->unbindUnusedQueryParams()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:245)
  at Doctrine\ORM\Tools\Pagination\Paginator->getCountQuery()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:118)
  at Doctrine\ORM\Tools\Pagination\Paginator->count()
  at count()
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber.php:46)
  at Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items()
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:118)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:230)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:59)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php:93)
  at Knp\Component\Pager\Paginator->paginate()
     (var/cache/dev/ContainerF3J4NcO/PaginatorInterface_82dac15.php:30)
  at ContainerF3J4NcO\PaginatorInterface_82dac15->paginate()
     (src/Controller/Frontend/DatasetController.php:79)
  at App\Controller\Frontend\DatasetController->index()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:20)
[1/2] QueryException 
Doctrine\ORM\Query\QueryException:
SELECT this FROM App\Entity\TPublikasi this WHERE this.status = 3 AND lower(this.judul) LIKE lower('%'+sleep(20.to_i)+'%') ORDER BY this.id desc

  at vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:21
  at Doctrine\ORM\Query\QueryException::dqlError()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:457)
  at Doctrine\ORM\Query\Parser->syntaxError()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:311)
  at Doctrine\ORM\Query\Parser->match()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/AST/Functions/LowerFunction.php:41)
  at Doctrine\ORM\Query\AST\Functions\LowerFunction->parse()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:3642)
  at Doctrine\ORM\Query\Parser->FunctionsReturningStrings()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:3498)
  at Doctrine\ORM\Query\Parser->FunctionDeclaration()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:3016)
  at Doctrine\ORM\Query\Parser->StringPrimary()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:3313)
  at Doctrine\ORM\Query\Parser->LikeExpression()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2652)
  at Doctrine\ORM\Query\Parser->SimpleConditionalExpression()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2534)
  at Doctrine\ORM\Query\Parser->ConditionalPrimary()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2513)
  at Doctrine\ORM\Query\Parser->ConditionalFactor()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2486)
  at Doctrine\ORM\Query\Parser->ConditionalTerm()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2456)
  at Doctrine\ORM\Query\Parser->ConditionalExpression()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:1391)
  at Doctrine\ORM\Query\Parser->WhereClause()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:882)
  at Doctrine\ORM\Query\Parser->SelectStatement()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:849)
  at Doctrine\ORM\Query\Parser->QueryLanguage()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:256)
  at Doctrine\ORM\Query\Parser->getAST()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:356)
  at Doctrine\ORM\Query\Parser->parse()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:256)
  at Doctrine\ORM\Tools\Pagination\Paginator->unbindUnusedQueryParams()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:245)
  at Doctrine\ORM\Tools\Pagination\Paginator->getCountQuery()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:118)
  at Doctrine\ORM\Tools\Pagination\Paginator->count()
  at count()
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber.php:46)
  at Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items()
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:118)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:230)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:59)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php:93)
  at Knp\Component\Pager\Paginator->paginate()
     (var/cache/dev/ContainerF3J4NcO/PaginatorInterface_82dac15.php:30)
  at ContainerF3J4NcO\PaginatorInterface_82dac15->paginate()
     (src/Controller/Frontend/DatasetController.php:79)
  at App\Controller\Frontend\DatasetController->index()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:20)