https://ticketsdemo.softguard.com/public/member/reports/working-hours/status

Method
GET
HTTP Status
200
IP
149.87.86.182
Profiled on
Token
b01f2e

Exceptions

QueryException QueryException

HTTP 500 Internal Server Error

[Semantical Error] line 0, col 215 near 'idor,
': Error: Class Webkul\UVDesk\CoreFrameworkBundle\Entity\User has no field or association named idor

Exceptions 2

Doctrine\ORM\Query\ QueryException

in vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php (line 65)
  1.      *
  2.      * @return QueryException
  3.      */
  4.     public static function semanticalError($message, $previous = null)
  5.     {
  6.         return new self('[Semantical Error] ' . $message, 0, $previous);
  7.     }
  9.     /**
  10.      * @return QueryException
  11.      */
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php::semanticalError (line 492)
  1.         $tokenStr = substr($dql, $token['position'], $length);
  3.         // Building informative message
  4.         $message = 'line 0, col ' . $tokenPos . " near '" . $tokenStr . "': Error: " . $message;
  6.         throw QueryException::semanticalError($message, QueryException::dqlError($this->query->getDQL()));
  7.     }
  9.     /**
  10.      * Peeks beyond the matched closing parenthesis and returns the first token after that one.
  11.      *
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php->semanticalError (line 765)
  2.             // Check if field or association exists
  3.             if ( ! isset($class->associationMappings[$field]) && ! isset($class->fieldMappings[$field])) {
  4.                 $this->semanticalError(
  5.                     'Class ' . $class->name . ' has no field or association named ' . $field,
  6.                     $deferredItem['token']
  7.                 );
  8.             }
  10.             $fieldType = AST\PathExpression::TYPE_STATE_FIELD;
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php->processDeferredPathExpressions (line 272)
  1.         if ($this->deferredPartialObjectExpressions) {
  2.             $this->processDeferredPartialObjectExpressions();
  3.         }
  5.         if ($this->deferredPathExpressions) {
  6.             $this->processDeferredPathExpressions();
  7.         }
  9.         if ($this->deferredResultVariables) {
  10.             $this->processDeferredResultVariables();
  11.         }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php->getAST (line 360)
  1.      *
  2.      * @return ParserResult
  3.      */
  4.     public function parse()
  5.     {
  6.         $AST = $this->getAST();
  8.         if (($customWalkers = $this->query->getHint(Query::HINT_CUSTOM_TREE_WALKERS)) !== false) {
  9.             $this->customTreeWalkers = $customWalkers;
  10.         }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php->parse (line 286)
  1.         }
  3.         // Cache miss.
  4.         $parser = new Parser($this);
  6.         $this->_parserResult = $parser->parse();
  8.         $queryCache->save($hash, $this->_parserResult, $this->_queryCacheTTL);
  10.         return $this->_parserResult;
  11.     }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php->_parse (line 298)
  1.     /**
  2.      * {@inheritdoc}
  3.      */
  4.     protected function _doExecute()
  5.     {
  6.         $executor = $this->_parse()->getSqlExecutor();
  8.         if ($this->_queryCacheProfile) {
  9.             $executor->setQueryCacheProfile($this->_queryCacheProfile);
  10.         } else {
  11.             $executor->removeQueryCacheProfile();
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php->_doExecute (line 967)
  2.                 $cache->save($cacheKey, $result, $queryCacheProfile->getLifetime());
  3.             };
  4.         }
  6.         $stmt = $this->_doExecute();
  8.         if (is_numeric($stmt)) {
  9.             $setCacheEntry($stmt);
  11.             return $stmt;
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php->executeIgnoreQueryCache (line 922)
  1.     {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4.         }
  6.         return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7.     }
  9.     /**
  10.      * Execute query ignoring second level cache.
  11.      *
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php->execute (line 726)
  1.      *
  2.      * @return mixed
  3.      */
  4.     public function getResult($hydrationMode = self::HYDRATE_OBJECT)
  5.     {
  6.         return $this->execute(null, $hydrationMode);
  7.     }
  9.     /**
  10.      * Gets the array of results for the query.
  11.      *
AbstractQuery->getResult() in src/Controller/WorkingHoursController.php (line 54)
  1.             WHERE a.isEnabled = 1
  2.             AND sr.code = 'ROLE_AGENT'
  3.             ORDER BY a.firstName, a.lastName
  4.         ");
  5.         
  6.         $agents = $agentsQuery->getResult();
  7.         
  8.         // Agrupar agentes por región
  9.         $agentsByRegion = [];
  10.         foreach ($agents as $agent) {
  11.             $regionName = $agent['supportGroupName'] ?: 'Sin región asignada';
in vendor/symfony/http-kernel/HttpKernel.php->getWorkingHoursStatusAction (line 151)
  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 68)
  1.     public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
  2.     {
  3.         $request->headers->set('X-Php-Ob-Level', ob_get_level());
  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 198)
  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 25)
  1.     Request::setTrustedHosts([$trustedHosts]);
  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 a.id as agentId, a.firstName, a.lastName, a.email, a.isEnabled, a.lastactivity, a.idor, sg.name as supportGroupName, sg.description as supportGroupDescription, sr.code as supportRoleCode FROM UVDeskCoreFrameworkBundle:User a JOIN UVDeskCoreFrameworkBundle:UserInstance ui WITH a.id = ui.user JOIN UVDeskCoreFrameworkBundle:SupportRole sr WITH ui.supportRole = sr.id LEFT JOIN UVDeskCoreFrameworkBundle:SupportGroup sg WITH a.idor = sg.id WHERE a.isEnabled = 1 AND sr.code = 'ROLE_AGENT' ORDER BY a.firstName, a.lastName

in vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php (line 43)
  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 492)
  1.         $tokenStr = substr($dql, $token['position'], $length);
  3.         // Building informative message
  4.         $message = 'line 0, col ' . $tokenPos . " near '" . $tokenStr . "': Error: " . $message;
  6.         throw QueryException::semanticalError($message, QueryException::dqlError($this->query->getDQL()));
  7.     }
  9.     /**
  10.      * Peeks beyond the matched closing parenthesis and returns the first token after that one.
  11.      *
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php->semanticalError (line 765)
  2.             // Check if field or association exists
  3.             if ( ! isset($class->associationMappings[$field]) && ! isset($class->fieldMappings[$field])) {
  4.                 $this->semanticalError(
  5.                     'Class ' . $class->name . ' has no field or association named ' . $field,
  6.                     $deferredItem['token']
  7.                 );
  8.             }
  10.             $fieldType = AST\PathExpression::TYPE_STATE_FIELD;
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php->processDeferredPathExpressions (line 272)
  1.         if ($this->deferredPartialObjectExpressions) {
  2.             $this->processDeferredPartialObjectExpressions();
  3.         }
  5.         if ($this->deferredPathExpressions) {
  6.             $this->processDeferredPathExpressions();
  7.         }
  9.         if ($this->deferredResultVariables) {
  10.             $this->processDeferredResultVariables();
  11.         }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php->getAST (line 360)
  1.      *
  2.      * @return ParserResult
  3.      */
  4.     public function parse()
  5.     {
  6.         $AST = $this->getAST();
  8.         if (($customWalkers = $this->query->getHint(Query::HINT_CUSTOM_TREE_WALKERS)) !== false) {
  9.             $this->customTreeWalkers = $customWalkers;
  10.         }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php->parse (line 286)
  1.         }
  3.         // Cache miss.
  4.         $parser = new Parser($this);
  6.         $this->_parserResult = $parser->parse();
  8.         $queryCache->save($hash, $this->_parserResult, $this->_queryCacheTTL);
  10.         return $this->_parserResult;
  11.     }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php->_parse (line 298)
  1.     /**
  2.      * {@inheritdoc}
  3.      */
  4.     protected function _doExecute()
  5.     {
  6.         $executor = $this->_parse()->getSqlExecutor();
  8.         if ($this->_queryCacheProfile) {
  9.             $executor->setQueryCacheProfile($this->_queryCacheProfile);
  10.         } else {
  11.             $executor->removeQueryCacheProfile();
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php->_doExecute (line 967)
  2.                 $cache->save($cacheKey, $result, $queryCacheProfile->getLifetime());
  3.             };
  4.         }
  6.         $stmt = $this->_doExecute();
  8.         if (is_numeric($stmt)) {
  9.             $setCacheEntry($stmt);
  11.             return $stmt;
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php->executeIgnoreQueryCache (line 922)
  1.     {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4.         }
  6.         return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7.     }
  9.     /**
  10.      * Execute query ignoring second level cache.
  11.      *
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php->execute (line 726)
  1.      *
  2.      * @return mixed
  3.      */
  4.     public function getResult($hydrationMode = self::HYDRATE_OBJECT)
  5.     {
  6.         return $this->execute(null, $hydrationMode);
  7.     }
  9.     /**
  10.      * Gets the array of results for the query.
  11.      *
AbstractQuery->getResult() in src/Controller/WorkingHoursController.php (line 54)
  1.             WHERE a.isEnabled = 1
  2.             AND sr.code = 'ROLE_AGENT'
  3.             ORDER BY a.firstName, a.lastName
  4.         ");
  5.         
  6.         $agents = $agentsQuery->getResult();
  7.         
  8.         // Agrupar agentes por región
  9.         $agentsByRegion = [];
  10.         foreach ($agents as $agent) {
  11.             $regionName = $agent['supportGroupName'] ?: 'Sin región asignada';
in vendor/symfony/http-kernel/HttpKernel.php->getWorkingHoursStatusAction (line 151)
  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 68)
  1.     public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
  2.     {
  3.         $request->headers->set('X-Php-Ob-Level', ob_get_level());
  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 198)
  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 25)
  1.     Request::setTrustedHosts([$trustedHosts]);
  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:
[Semantical Error] line 0, col 215 near 'idor,
      ': Error: Class Webkul\UVDesk\CoreFrameworkBundle\Entity\User has no field or association named idor

  at vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:65
  at Doctrine\ORM\Query\QueryException::semanticalError()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:492)
  at Doctrine\ORM\Query\Parser->semanticalError()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:765)
  at Doctrine\ORM\Query\Parser->processDeferredPathExpressions()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:272)
  at Doctrine\ORM\Query\Parser->getAST()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:360)
  at Doctrine\ORM\Query\Parser->parse()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:286)
  at Doctrine\ORM\Query->_parse()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:298)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:967)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:922)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:726)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/Controller/WorkingHoursController.php:54)
  at App\Controller\WorkingHoursController->getWorkingHoursStatusAction()
     (vendor/symfony/http-kernel/HttpKernel.php:151)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:198)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:25)

[1/2] QueryException 

Doctrine\ORM\Query\QueryException:

            SELECT 
                a.id as agentId,
                a.firstName,
                a.lastName,
                a.email,
                a.isEnabled,
                a.lastactivity,
                a.idor,
                sg.name as supportGroupName,
                sg.description as supportGroupDescription,
                sr.code as supportRoleCode
            FROM UVDeskCoreFrameworkBundle:User a
            JOIN UVDeskCoreFrameworkBundle:UserInstance ui WITH a.id = ui.user
            JOIN UVDeskCoreFrameworkBundle:SupportRole sr WITH ui.supportRole = sr.id
            LEFT JOIN UVDeskCoreFrameworkBundle:SupportGroup sg WITH a.idor = sg.id
            WHERE a.isEnabled = 1
            AND sr.code = 'ROLE_AGENT'
            ORDER BY a.firstName, a.lastName
        

  at vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:43
  at Doctrine\ORM\Query\QueryException::dqlError()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:492)
  at Doctrine\ORM\Query\Parser->semanticalError()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:765)
  at Doctrine\ORM\Query\Parser->processDeferredPathExpressions()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:272)
  at Doctrine\ORM\Query\Parser->getAST()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:360)
  at Doctrine\ORM\Query\Parser->parse()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:286)
  at Doctrine\ORM\Query->_parse()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:298)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:967)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:922)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:726)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/Controller/WorkingHoursController.php:54)
  at App\Controller\WorkingHoursController->getWorkingHoursStatusAction()
     (vendor/symfony/http-kernel/HttpKernel.php:151)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:68)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:198)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:25)