Error 500 Internal Server Error

GET https://gestionipre.investigacion-test.ing.uc.cl/oportunity-research/public?prerequisite=IIC2433

IP
216.73.216.46
Profiled on
Token
78a841

Exceptions

QueryException QueryException

HTTP 500 Internal Server Error

[Semantical Error] line 0, col 266 near 'p WHERE o.hidden': Error: 'p' is already defined.

Exceptions 2

Doctrine\ORM\Query\ QueryException

in vendor/doctrine/orm/src/Query/QueryException.php (line 28)
  1. return new self('[Syntax Error] ' . $message, 0, $previous);
  2. }
  4. public static function semanticalError(string $message, Throwable|null $previous = null): self
  5. {
  6. return new self('[Semantical Error] ' . $message, 0, $previous);
  7. }
  9. public static function invalidLockMode(): self
  10. {
  11. return new self('Invalid lock mode hint provided.');
in vendor/doctrine/orm/src/Query/Parser.php :: semanticalError (line 465)
  1. $pos = $token->position + $distance;
  2. $pos = strpos($dql, ' ', $length > $pos ? $pos : $length);
  3. $length = $pos !== false ? $pos - $token->position : $distance;
  5. $tokenPos = $token->position > 0 ? $token->position : '-1';
  6. $tokenStr = substr($dql, $token->position, $length);
  8. // Building informative message
  9. $message = 'line 0, col ' . $tokenPos . " near '" . $tokenStr . "': Error: " . $message;
  11. throw QueryException::semanticalError($message, QueryException::dqlError($this->query->getDQL()));
in vendor/doctrine/orm/src/Query/Parser.php -> semanticalError (line 908)
  1. */
  2. public function AliasIdentificationVariable(): string
  3. {
  4. $this->match(TokenType::T_IDENTIFIER);
  6. assert($this->lexer->token !== null);
  7. $aliasIdentVariable = $this->lexer->token->value;
  8. $exists = isset($this->queryComponents[$aliasIdentVariable]);
  10. if ($exists) {
  11. $this->semanticalError(
in vendor/doctrine/orm/src/Query/Parser.php -> AliasIdentificationVariable (line 1727)
  2. return new AST\RangeVariableDeclaration($abstractSchemaName, $aliasIdentificationVariable);
  3. }
  5. /**
  6. * JoinAssociationDeclaration ::= JoinAssociationPathExpression ["AS"] AliasIdentificationVariable [IndexBy]
  7. */
  8. public function JoinAssociationDeclaration(): AST\JoinAssociationDeclaration
  9. {
  10. $joinAssociationPathExpression = $this->JoinAssociationPathExpression();
in vendor/doctrine/orm/src/Query/Parser.php -> JoinAssociationDeclaration (line 1649)
  1. // Do nothing
  2. }
  4. $this->match(TokenType::T_JOIN);
  6. $next = $this->lexer->glimpse();
  7. assert($next !== null);
  8. $conditionalExpression = null;
  10. if ($next->type === TokenType::T_DOT) {
  11. $joinDeclaration = $this->JoinAssociationDeclaration();
in vendor/doctrine/orm/src/Query/Parser.php -> Join (line 1544)
  1. ? $this->IndexBy()
  2. : null;
  4. $rangeVariableDeclaration->isRoot = true;
  6. while (
  7. $this->lexer->isNextToken(TokenType::T_LEFT) ||
  8. $this->lexer->isNextToken(TokenType::T_INNER) ||
  9. $this->lexer->isNextToken(TokenType::T_JOIN)
  10. ) {
  11. $joins[] = $this->Join();
in vendor/doctrine/orm/src/Query/Parser.php -> IdentificationVariableDeclaration (line 1301)
  1. }
  3. /**
  4. * FromClause ::= "FROM" IdentificationVariableDeclaration {"," IdentificationVariableDeclaration}*
  5. */
  6. public function FromClause(): AST\FromClause
  7. {
  8. $this->match(TokenType::T_FROM);
  10. $identificationVariableDeclarations = [];
  11. $identificationVariableDeclarations[] = $this->IdentificationVariableDeclaration();
in vendor/doctrine/orm/src/Query/Parser.php -> FromClause (line 843)
  1. }
  3. return $statement;
  4. }
  6. /**
  7. * SelectStatement ::= SelectClause FromClause [WhereClause] [GroupByClause] [HavingClause] [OrderByClause]
  8. */
  9. public function SelectStatement(): AST\SelectStatement
  10. {
  11. $selectStatement = new AST\SelectStatement($this->SelectClause(), $this->FromClause());
in vendor/doctrine/orm/src/Query/Parser.php -> SelectStatement (line 814)
  1. * QueryLanguage ::= SelectStatement | UpdateStatement | DeleteStatement
  2. */
  3. public function QueryLanguage(): AST\SelectStatement|AST\UpdateStatement|AST\DeleteStatement
  4. {
  5. $statement = null;
  7. $this->lexer->moveNext();
  9. switch ($this->lexer->lookahead->type ?? null) {
  10. case TokenType::T_SELECT:
  11. $statement = $this->SelectStatement();
in vendor/doctrine/orm/src/Query/Parser.php -> QueryLanguage (line 238)
  1. {
  2. return $this->em;
  3. }
  5. /**
  6. * Parses and builds AST for the given Query.
  7. */
  8. public function getAST(): AST\SelectStatement|AST\UpdateStatement|AST\DeleteStatement
  9. {
  10. // Parse & build AST
  11. $AST = $this->QueryLanguage();
in vendor/doctrine/orm/src/Query/Parser.php -> getAST (line 330)
  2. $this->lexer->token = null;
  3. $this->lexer->lookahead = null;
  4. }
  6. /**
  7. * Parses a query string.
  8. */
  9. public function parse(): ParserResult
  10. {
  11. $AST = $this->getAST();
in vendor/doctrine/orm/src/Query.php -> parse (line 248)
  1. }
  3. // Cache miss.
  4. $parser = new Parser($this);
  6. $this->parserResult = $parser->parse();
  8. $queryCache->save($cacheItem->set($this->parserResult)->expiresAfter($this->queryCacheTTL));
  10. return $this->parserResult;
  11. }
in vendor/doctrine/orm/src/Query.php -> parse (line 717)
  1. $this->state = self::STATE_DIRTY;
  2. }
  4. private function getSqlExecutor(): AbstractSqlExecutor
  5. {
  6. return $this->parse()->prepareSqlExecutor($this);
  7. }
  8. }
in vendor/doctrine/orm/src/Query.php -> getSqlExecutor (line 257)
  1. return $this->parserResult;
  2. }
  4. protected function _doExecute(): Result|int
  5. {
  6. $executor = $this->getSqlExecutor();
  8. if ($this->queryCacheProfile) {
  9. $executor->setQueryCacheProfile($this->queryCacheProfile);
  10. } else {
  11. $executor->removeQueryCacheProfile();
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 930)
  1. $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2. $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3. };
  4. }
  6. $stmt = $this->_doExecute();
  8. if (is_numeric($stmt)) {
  9. $setCacheEntry($stmt);
  11. return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 886)
  1. ): mixed {
  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/src/AbstractQuery.php -> execute (line 688)
  1. *
  2. * @phpstan-param string|AbstractQuery::HYDRATE_* $hydrationMode
  3. */
  4. public function getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed
  5. {
  6. return $this->execute(null, $hydrationMode);
  7. }
  9. /**
  10. * Gets the array of results for the query.
  11. *
AbstractQuery->getResult() in src/Repository/OportunityResearchRepository.php (line 752)
  1. $qb->join('o.prerequisites', 'p')
  2. ->andWhere('LOWER(p.courseNumber) LIKE LOWER(:prerequisite)')
  3. ->setParameter('prerequisite', '%' . $prerequisite . '%');
  4. }
  6. return $qb->getQuery()->getResult();
  7. }
  9. // /**
  10. // * @return OportunityResearch[] Returns an array of OportunityResearch objects
  11. // */
OportunityResearchRepository->getQueryByPrerequisite() in src/Repository/OportunityResearchRepository.php (line 433)
  1. ->groupBy('o.id')
  2. ->having('o.vacants - usedVacants > 0')
  3. ->setParameter('twoYearsAgo', (new \DateTime())->modify('-2 years'))
  4. ->setParameter('now', new \DateTime());
  6. return $this->getQueryByPrerequisite($qb, $prerequisite);
  7. }
  9. public function findPublicOportunitiesByPrerequisite($prerequisite): ?array
  10. {
  11. $query = $this->getEntityManager()
OportunityResearchRepository->findPublicAvailableOportunitiesByPrerequisite() in src/Controller/OportunityResearchController.php (line 65)
  1. ): Response {
  2. $prerequisite = $request->query->get('prerequisite');
  3. $keyword = $request->query->get('keyword');
  4. $department = $request->query->get('department');
  5. if ($prerequisite) {
  6. $oportunityResearches = $oportunityResearchRepository->findPublicAvailableOportunitiesByPrerequisite($prerequisite);
  7. } else if ($keyword) {
  8. $oportunityResearches = $oportunityResearchRepository->findPublicAvailableOportunitiesByKeyword($keyword);
  9. } else if ($department) {
  10. $oportunityResearches = $oportunityResearchRepository->findAvailable($department);
  11. } else {
in vendor/symfony/http-kernel/HttpKernel.php -> publicIndex (line 183)
  2. $event = new ControllerArgumentsEvent($this, $event, $arguments, $request, $type);
  3. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  4. $controller = $event->getController();
  5. $arguments = $event->getArguments();
  7. // call controller
  8. $response = $controller(...$arguments);
  10. // view
  11. if (!$response instanceof Response) {
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $this->handleRaw($request, $type);
  7. } catch (\Throwable $e) {
  8. if ($e instanceof \Error && !$this->handleAllThrowables) {
  9. throw $e;
  10. }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 193)
  1. $this->boot();
  2. ++$this->requestStackSize;
  3. if (!$this->handlingHttpCache) {
  4. $this->resetServices = true;
  5. }
  7. try {
  8. return $this->getHttpKernel()->handle($request, $type, $catch);
  9. } finally {
  10. --$this->requestStackSize;
  11. }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1. }
  3. public function run(): int
  4. {
  5. $response = $this->kernel->handle($this->request);
  7. $response->send(false);
  9. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
  10. fastcgi_finish_request();
  11. } elseif (\function_exists('litespeed_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/var/www/html/gestionipre/vendor/autoload_runtime.php') in public/index.php (line 7)
  2. use App\Kernel;
  4. date_default_timezone_set('America/Santiago');
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Doctrine\ORM\Query\ QueryException

SELECT o, SUM(CASE WHEN s.vacancyConsuming IS NOT NULL AND s.vacancyConsuming = true THEN 1 ELSE 0 END) AS HIDDEN usedVacants FROM App\Entity\OportunityResearch o LEFT JOIN o.applications a LEFT JOIN a.state s INNER JOIN o.prerequisites p INNER JOIN o.prerequisites p WHERE o.hidden = false AND o.public = 1 AND ((o.usePublishedDeadline = false OR o.publishedDeadline > :now)) AND o.lastActivityDate >= :twoYearsAgo AND LOWER(p.courseNumber) LIKE LOWER(:prerequisite) GROUP BY o.id HAVING o.vacants - usedVacants > 0

in vendor/doctrine/orm/src/Query/QueryException.php (line 18)
  2. class QueryException extends Exception implements ORMException
  3. {
  4. public static function dqlError(string $dql): self
  5. {
  6. return new self($dql);
  7. }
  9. public static function syntaxError(string $message, Throwable|null $previous = null): self
  10. {
  11. return new self('[Syntax Error] ' . $message, 0, $previous);
in vendor/doctrine/orm/src/Query/Parser.php :: dqlError (line 465)
  1. $pos = $token->position + $distance;
  2. $pos = strpos($dql, ' ', $length > $pos ? $pos : $length);
  3. $length = $pos !== false ? $pos - $token->position : $distance;
  5. $tokenPos = $token->position > 0 ? $token->position : '-1';
  6. $tokenStr = substr($dql, $token->position, $length);
  8. // Building informative message
  9. $message = 'line 0, col ' . $tokenPos . " near '" . $tokenStr . "': Error: " . $message;
  11. throw QueryException::semanticalError($message, QueryException::dqlError($this->query->getDQL()));
in vendor/doctrine/orm/src/Query/Parser.php -> semanticalError (line 908)
  1. */
  2. public function AliasIdentificationVariable(): string
  3. {
  4. $this->match(TokenType::T_IDENTIFIER);
  6. assert($this->lexer->token !== null);
  7. $aliasIdentVariable = $this->lexer->token->value;
  8. $exists = isset($this->queryComponents[$aliasIdentVariable]);
  10. if ($exists) {
  11. $this->semanticalError(
in vendor/doctrine/orm/src/Query/Parser.php -> AliasIdentificationVariable (line 1727)
  2. return new AST\RangeVariableDeclaration($abstractSchemaName, $aliasIdentificationVariable);
  3. }
  5. /**
  6. * JoinAssociationDeclaration ::= JoinAssociationPathExpression ["AS"] AliasIdentificationVariable [IndexBy]
  7. */
  8. public function JoinAssociationDeclaration(): AST\JoinAssociationDeclaration
  9. {
  10. $joinAssociationPathExpression = $this->JoinAssociationPathExpression();
in vendor/doctrine/orm/src/Query/Parser.php -> JoinAssociationDeclaration (line 1649)
  1. // Do nothing
  2. }
  4. $this->match(TokenType::T_JOIN);
  6. $next = $this->lexer->glimpse();
  7. assert($next !== null);
  8. $conditionalExpression = null;
  10. if ($next->type === TokenType::T_DOT) {
  11. $joinDeclaration = $this->JoinAssociationDeclaration();
in vendor/doctrine/orm/src/Query/Parser.php -> Join (line 1544)
  1. ? $this->IndexBy()
  2. : null;
  4. $rangeVariableDeclaration->isRoot = true;
  6. while (
  7. $this->lexer->isNextToken(TokenType::T_LEFT) ||
  8. $this->lexer->isNextToken(TokenType::T_INNER) ||
  9. $this->lexer->isNextToken(TokenType::T_JOIN)
  10. ) {
  11. $joins[] = $this->Join();
in vendor/doctrine/orm/src/Query/Parser.php -> IdentificationVariableDeclaration (line 1301)
  1. }
  3. /**
  4. * FromClause ::= "FROM" IdentificationVariableDeclaration {"," IdentificationVariableDeclaration}*
  5. */
  6. public function FromClause(): AST\FromClause
  7. {
  8. $this->match(TokenType::T_FROM);
  10. $identificationVariableDeclarations = [];
  11. $identificationVariableDeclarations[] = $this->IdentificationVariableDeclaration();
in vendor/doctrine/orm/src/Query/Parser.php -> FromClause (line 843)
  1. }
  3. return $statement;
  4. }
  6. /**
  7. * SelectStatement ::= SelectClause FromClause [WhereClause] [GroupByClause] [HavingClause] [OrderByClause]
  8. */
  9. public function SelectStatement(): AST\SelectStatement
  10. {
  11. $selectStatement = new AST\SelectStatement($this->SelectClause(), $this->FromClause());
in vendor/doctrine/orm/src/Query/Parser.php -> SelectStatement (line 814)
  1. * QueryLanguage ::= SelectStatement | UpdateStatement | DeleteStatement
  2. */
  3. public function QueryLanguage(): AST\SelectStatement|AST\UpdateStatement|AST\DeleteStatement
  4. {
  5. $statement = null;
  7. $this->lexer->moveNext();
  9. switch ($this->lexer->lookahead->type ?? null) {
  10. case TokenType::T_SELECT:
  11. $statement = $this->SelectStatement();
in vendor/doctrine/orm/src/Query/Parser.php -> QueryLanguage (line 238)
  1. {
  2. return $this->em;
  3. }
  5. /**
  6. * Parses and builds AST for the given Query.
  7. */
  8. public function getAST(): AST\SelectStatement|AST\UpdateStatement|AST\DeleteStatement
  9. {
  10. // Parse & build AST
  11. $AST = $this->QueryLanguage();
in vendor/doctrine/orm/src/Query/Parser.php -> getAST (line 330)
  2. $this->lexer->token = null;
  3. $this->lexer->lookahead = null;
  4. }
  6. /**
  7. * Parses a query string.
  8. */
  9. public function parse(): ParserResult
  10. {
  11. $AST = $this->getAST();
in vendor/doctrine/orm/src/Query.php -> parse (line 248)
  1. }
  3. // Cache miss.
  4. $parser = new Parser($this);
  6. $this->parserResult = $parser->parse();
  8. $queryCache->save($cacheItem->set($this->parserResult)->expiresAfter($this->queryCacheTTL));
  10. return $this->parserResult;
  11. }
in vendor/doctrine/orm/src/Query.php -> parse (line 717)
  1. $this->state = self::STATE_DIRTY;
  2. }
  4. private function getSqlExecutor(): AbstractSqlExecutor
  5. {
  6. return $this->parse()->prepareSqlExecutor($this);
  7. }
  8. }
in vendor/doctrine/orm/src/Query.php -> getSqlExecutor (line 257)
  1. return $this->parserResult;
  2. }
  4. protected function _doExecute(): Result|int
  5. {
  6. $executor = $this->getSqlExecutor();
  8. if ($this->queryCacheProfile) {
  9. $executor->setQueryCacheProfile($this->queryCacheProfile);
  10. } else {
  11. $executor->removeQueryCacheProfile();
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 930)
  1. $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2. $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3. };
  4. }
  6. $stmt = $this->_doExecute();
  8. if (is_numeric($stmt)) {
  9. $setCacheEntry($stmt);
  11. return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 886)
  1. ): mixed {
  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/src/AbstractQuery.php -> execute (line 688)
  1. *
  2. * @phpstan-param string|AbstractQuery::HYDRATE_* $hydrationMode
  3. */
  4. public function getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed
  5. {
  6. return $this->execute(null, $hydrationMode);
  7. }
  9. /**
  10. * Gets the array of results for the query.
  11. *
AbstractQuery->getResult() in src/Repository/OportunityResearchRepository.php (line 752)
  1. $qb->join('o.prerequisites', 'p')
  2. ->andWhere('LOWER(p.courseNumber) LIKE LOWER(:prerequisite)')
  3. ->setParameter('prerequisite', '%' . $prerequisite . '%');
  4. }
  6. return $qb->getQuery()->getResult();
  7. }
  9. // /**
  10. // * @return OportunityResearch[] Returns an array of OportunityResearch objects
  11. // */
OportunityResearchRepository->getQueryByPrerequisite() in src/Repository/OportunityResearchRepository.php (line 433)
  1. ->groupBy('o.id')
  2. ->having('o.vacants - usedVacants > 0')
  3. ->setParameter('twoYearsAgo', (new \DateTime())->modify('-2 years'))
  4. ->setParameter('now', new \DateTime());
  6. return $this->getQueryByPrerequisite($qb, $prerequisite);
  7. }
  9. public function findPublicOportunitiesByPrerequisite($prerequisite): ?array
  10. {
  11. $query = $this->getEntityManager()
OportunityResearchRepository->findPublicAvailableOportunitiesByPrerequisite() in src/Controller/OportunityResearchController.php (line 65)
  1. ): Response {
  2. $prerequisite = $request->query->get('prerequisite');
  3. $keyword = $request->query->get('keyword');
  4. $department = $request->query->get('department');
  5. if ($prerequisite) {
  6. $oportunityResearches = $oportunityResearchRepository->findPublicAvailableOportunitiesByPrerequisite($prerequisite);
  7. } else if ($keyword) {
  8. $oportunityResearches = $oportunityResearchRepository->findPublicAvailableOportunitiesByKeyword($keyword);
  9. } else if ($department) {
  10. $oportunityResearches = $oportunityResearchRepository->findAvailable($department);
  11. } else {
in vendor/symfony/http-kernel/HttpKernel.php -> publicIndex (line 183)
  2. $event = new ControllerArgumentsEvent($this, $event, $arguments, $request, $type);
  3. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  4. $controller = $event->getController();
  5. $arguments = $event->getArguments();
  7. // call controller
  8. $response = $controller(...$arguments);
  10. // view
  11. if (!$response instanceof Response) {
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $this->handleRaw($request, $type);
  7. } catch (\Throwable $e) {
  8. if ($e instanceof \Error && !$this->handleAllThrowables) {
  9. throw $e;
  10. }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 193)
  1. $this->boot();
  2. ++$this->requestStackSize;
  3. if (!$this->handlingHttpCache) {
  4. $this->resetServices = true;
  5. }
  7. try {
  8. return $this->getHttpKernel()->handle($request, $type, $catch);
  9. } finally {
  10. --$this->requestStackSize;
  11. }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1. }
  3. public function run(): int
  4. {
  5. $response = $this->kernel->handle($this->request);
  7. $response->send(false);
  9. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
  10. fastcgi_finish_request();
  11. } elseif (\function_exists('litespeed_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/var/www/html/gestionipre/vendor/autoload_runtime.php') in public/index.php (line 7)
  2. use App\Kernel;
  4. date_default_timezone_set('America/Santiago');
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Logs

Level Channel Message
INFO 17:08:36 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "78a841"
    },
    "request_uri": "https://gestionipre.investigacion-test.ing.uc.cl/_profiler/78a841?panel=exception&type=request",
    "method": "GET"
}
DEBUG 17:08:36 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 17:08:36 event Notified event "kernel.request" to listener "Symfony\UX\Turbo\Request\RequestListener::__invoke". 
{
    "event": "kernel.request",
    "listener": "Symfony\\UX\\Turbo\\Request\\RequestListener::__invoke"
}
DEBUG 17:08:36 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 17:08:36 event Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest"
}
DEBUG 17:08:36 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 17:08:36 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 17:08:36 event Notified event "kernel.request" to listener "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\AssetMapper\\AssetMapperDevServerSubscriber::onKernelRequest"
}
DEBUG 17:08:36 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 17:08:36 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 17:08:36 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 17:08:36 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 17:08:36 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 17:08:36 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 17:08:36 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 17:08:36 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\IsSignatureValidAttributeListener::onKernelControllerArguments"
}
DEBUG 17:08:36 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
}
DEBUG 17:08:36 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
DEBUG 17:08:36 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
DEBUG 17:08:36 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\Controller\\ArgumentResolver\\RequestPayloadValueResolver::onKernelControllerArguments"
}
DEBUG 17:08:36 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}

Stack Traces 2

[2/2] QueryException 
Doctrine\ORM\Query\QueryException:
[Semantical Error] line 0, col 266 near 'p WHERE o.hidden': Error: 'p' is already defined.

  at vendor/doctrine/orm/src/Query/QueryException.php:28
  at Doctrine\ORM\Query\QueryException::semanticalError()
     (vendor/doctrine/orm/src/Query/Parser.php:465)
  at Doctrine\ORM\Query\Parser->semanticalError()
     (vendor/doctrine/orm/src/Query/Parser.php:908)
  at Doctrine\ORM\Query\Parser->AliasIdentificationVariable()
     (vendor/doctrine/orm/src/Query/Parser.php:1727)
  at Doctrine\ORM\Query\Parser->JoinAssociationDeclaration()
     (vendor/doctrine/orm/src/Query/Parser.php:1649)
  at Doctrine\ORM\Query\Parser->Join()
     (vendor/doctrine/orm/src/Query/Parser.php:1544)
  at Doctrine\ORM\Query\Parser->IdentificationVariableDeclaration()
     (vendor/doctrine/orm/src/Query/Parser.php:1301)
  at Doctrine\ORM\Query\Parser->FromClause()
     (vendor/doctrine/orm/src/Query/Parser.php:843)
  at Doctrine\ORM\Query\Parser->SelectStatement()
     (vendor/doctrine/orm/src/Query/Parser.php:814)
  at Doctrine\ORM\Query\Parser->QueryLanguage()
     (vendor/doctrine/orm/src/Query/Parser.php:238)
  at Doctrine\ORM\Query\Parser->getAST()
     (vendor/doctrine/orm/src/Query/Parser.php:330)
  at Doctrine\ORM\Query\Parser->parse()
     (vendor/doctrine/orm/src/Query.php:248)
  at Doctrine\ORM\Query->parse()
     (vendor/doctrine/orm/src/Query.php:717)
  at Doctrine\ORM\Query->getSqlExecutor()
     (vendor/doctrine/orm/src/Query.php:257)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/src/AbstractQuery.php:688)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/Repository/OportunityResearchRepository.php:752)
  at App\Repository\OportunityResearchRepository->getQueryByPrerequisite()
     (src/Repository/OportunityResearchRepository.php:433)
  at App\Repository\OportunityResearchRepository->findPublicAvailableOportunitiesByPrerequisite()
     (src/Controller/OportunityResearchController.php:65)
  at App\Controller\OportunityResearchController->publicIndex()
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:193)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:32)
  at require_once('/var/www/html/gestionipre/vendor/autoload_runtime.php')
     (public/index.php:7)
[1/2] QueryException 
Doctrine\ORM\Query\QueryException:
SELECT o, SUM(CASE WHEN s.vacancyConsuming IS NOT NULL AND s.vacancyConsuming = true THEN 1 ELSE 0 END) AS HIDDEN usedVacants FROM App\Entity\OportunityResearch o LEFT JOIN o.applications a LEFT JOIN a.state s INNER JOIN o.prerequisites p INNER JOIN o.prerequisites p WHERE o.hidden = false AND o.public = 1 AND ((o.usePublishedDeadline = false OR o.publishedDeadline > :now)) AND o.lastActivityDate >= :twoYearsAgo AND LOWER(p.courseNumber) LIKE LOWER(:prerequisite) GROUP BY o.id HAVING o.vacants - usedVacants > 0

  at vendor/doctrine/orm/src/Query/QueryException.php:18
  at Doctrine\ORM\Query\QueryException::dqlError()
     (vendor/doctrine/orm/src/Query/Parser.php:465)
  at Doctrine\ORM\Query\Parser->semanticalError()
     (vendor/doctrine/orm/src/Query/Parser.php:908)
  at Doctrine\ORM\Query\Parser->AliasIdentificationVariable()
     (vendor/doctrine/orm/src/Query/Parser.php:1727)
  at Doctrine\ORM\Query\Parser->JoinAssociationDeclaration()
     (vendor/doctrine/orm/src/Query/Parser.php:1649)
  at Doctrine\ORM\Query\Parser->Join()
     (vendor/doctrine/orm/src/Query/Parser.php:1544)
  at Doctrine\ORM\Query\Parser->IdentificationVariableDeclaration()
     (vendor/doctrine/orm/src/Query/Parser.php:1301)
  at Doctrine\ORM\Query\Parser->FromClause()
     (vendor/doctrine/orm/src/Query/Parser.php:843)
  at Doctrine\ORM\Query\Parser->SelectStatement()
     (vendor/doctrine/orm/src/Query/Parser.php:814)
  at Doctrine\ORM\Query\Parser->QueryLanguage()
     (vendor/doctrine/orm/src/Query/Parser.php:238)
  at Doctrine\ORM\Query\Parser->getAST()
     (vendor/doctrine/orm/src/Query/Parser.php:330)
  at Doctrine\ORM\Query\Parser->parse()
     (vendor/doctrine/orm/src/Query.php:248)
  at Doctrine\ORM\Query->parse()
     (vendor/doctrine/orm/src/Query.php:717)
  at Doctrine\ORM\Query->getSqlExecutor()
     (vendor/doctrine/orm/src/Query.php:257)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/src/AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/src/AbstractQuery.php:688)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/Repository/OportunityResearchRepository.php:752)
  at App\Repository\OportunityResearchRepository->getQueryByPrerequisite()
     (src/Repository/OportunityResearchRepository.php:433)
  at App\Repository\OportunityResearchRepository->findPublicAvailableOportunitiesByPrerequisite()
     (src/Controller/OportunityResearchController.php:65)
  at App\Controller\OportunityResearchController->publicIndex()
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:193)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:32)
  at require_once('/var/www/html/gestionipre/vendor/autoload_runtime.php')
     (public/index.php:7)