Error 500 Internal Server Error

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

IP
216.73.216.46
Profiled on
Token
9b1b0f

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. $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/src/Query/Parser.php -> semanticalError (line 908)
  1. assert($this->lexer->token !== null);
  2. $aliasIdentVariable = $this->lexer->token->value;
  3. $exists = isset($this->queryComponents[$aliasIdentVariable]);
  5. if ($exists) {
  6. $this->semanticalError(
  7. sprintf("'%s' is already defined.", $aliasIdentVariable),
  8. $this->lexer->token,
  9. );
  10. }
in vendor/doctrine/orm/src/Query/Parser.php -> AliasIdentificationVariable (line 1727)
  1. $this->match(TokenType::T_AS);
  2. }
  4. assert($this->lexer->lookahead !== null);
  6. $aliasIdentificationVariable = $this->AliasIdentificationVariable();
  7. $indexBy = $this->lexer->isNextToken(TokenType::T_INDEX) ? $this->IndexBy() : null;
  9. $identificationVariable = $joinAssociationPathExpression->identificationVariable;
  10. $field = $joinAssociationPathExpression->associationField;
in vendor/doctrine/orm/src/Query/Parser.php -> JoinAssociationDeclaration (line 1649)
  1. $next = $this->lexer->glimpse();
  2. assert($next !== null);
  3. $conditionalExpression = null;
  5. if ($next->type === TokenType::T_DOT) {
  6. $joinDeclaration = $this->JoinAssociationDeclaration();
  8. if ($this->lexer->isNextToken(TokenType::T_WITH)) {
  9. $this->match(TokenType::T_WITH);
  10. $conditionalExpression = $this->ConditionalExpression();
  11. }
in vendor/doctrine/orm/src/Query/Parser.php -> Join (line 1544)
  1. while (
  2. $this->lexer->isNextToken(TokenType::T_LEFT) ||
  3. $this->lexer->isNextToken(TokenType::T_INNER) ||
  4. $this->lexer->isNextToken(TokenType::T_JOIN)
  5. ) {
  6. $joins[] = $this->Join();
  7. }
  9. return new AST\IdentificationVariableDeclaration(
  10. $rangeVariableDeclaration,
  11. $indexBy,
in vendor/doctrine/orm/src/Query/Parser.php -> IdentificationVariableDeclaration (line 1301)
  1. public function FromClause(): AST\FromClause
  2. {
  3. $this->match(TokenType::T_FROM);
  5. $identificationVariableDeclarations = [];
  6. $identificationVariableDeclarations[] = $this->IdentificationVariableDeclaration();
  8. while ($this->lexer->isNextToken(TokenType::T_COMMA)) {
  9. $this->match(TokenType::T_COMMA);
  11. $identificationVariableDeclarations[] = $this->IdentificationVariableDeclaration();
in vendor/doctrine/orm/src/Query/Parser.php -> FromClause (line 843)
  1. /**
  2. * SelectStatement ::= SelectClause FromClause [WhereClause] [GroupByClause] [HavingClause] [OrderByClause]
  3. */
  4. public function SelectStatement(): AST\SelectStatement
  5. {
  6. $selectStatement = new AST\SelectStatement($this->SelectClause(), $this->FromClause());
  8. $selectStatement->whereClause = $this->lexer->isNextToken(TokenType::T_WHERE) ? $this->WhereClause() : null;
  9. $selectStatement->groupByClause = $this->lexer->isNextToken(TokenType::T_GROUP) ? $this->GroupByClause() : null;
  10. $selectStatement->havingClause = $this->lexer->isNextToken(TokenType::T_HAVING) ? $this->HavingClause() : null;
  11. $selectStatement->orderByClause = $this->lexer->isNextToken(TokenType::T_ORDER) ? $this->OrderByClause() : null;
in vendor/doctrine/orm/src/Query/Parser.php -> SelectStatement (line 814)
  2. $this->lexer->moveNext();
  4. switch ($this->lexer->lookahead->type ?? null) {
  5. case TokenType::T_SELECT:
  6. $statement = $this->SelectStatement();
  7. break;
  9. case TokenType::T_UPDATE:
  10. $statement = $this->UpdateStatement();
  11. break;
in vendor/doctrine/orm/src/Query/Parser.php -> QueryLanguage (line 238)
  1. * Parses and builds AST for the given Query.
  2. */
  3. public function getAST(): AST\SelectStatement|AST\UpdateStatement|AST\DeleteStatement
  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/src/Query/Parser.php -> getAST (line 330)
  1. /**
  2. * Parses a query string.
  3. */
  4. public function parse(): ParserResult
  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/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)
  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, $event);
  11. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
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. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  5. try {
  6. return $this->getHttpKernel()->handle($request, $type, $catch);
  7. } finally {
  8. --$this->requestStackSize;
  9. }
  10. }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. if (Kernel::VERSION_ID >= 60400) {
  9. $response->send(false);
  11. if (\function_exists('fastcgi_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. $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/src/Query/Parser.php -> semanticalError (line 908)
  1. assert($this->lexer->token !== null);
  2. $aliasIdentVariable = $this->lexer->token->value;
  3. $exists = isset($this->queryComponents[$aliasIdentVariable]);
  5. if ($exists) {
  6. $this->semanticalError(
  7. sprintf("'%s' is already defined.", $aliasIdentVariable),
  8. $this->lexer->token,
  9. );
  10. }
in vendor/doctrine/orm/src/Query/Parser.php -> AliasIdentificationVariable (line 1727)
  1. $this->match(TokenType::T_AS);
  2. }
  4. assert($this->lexer->lookahead !== null);
  6. $aliasIdentificationVariable = $this->AliasIdentificationVariable();
  7. $indexBy = $this->lexer->isNextToken(TokenType::T_INDEX) ? $this->IndexBy() : null;
  9. $identificationVariable = $joinAssociationPathExpression->identificationVariable;
  10. $field = $joinAssociationPathExpression->associationField;
in vendor/doctrine/orm/src/Query/Parser.php -> JoinAssociationDeclaration (line 1649)
  1. $next = $this->lexer->glimpse();
  2. assert($next !== null);
  3. $conditionalExpression = null;
  5. if ($next->type === TokenType::T_DOT) {
  6. $joinDeclaration = $this->JoinAssociationDeclaration();
  8. if ($this->lexer->isNextToken(TokenType::T_WITH)) {
  9. $this->match(TokenType::T_WITH);
  10. $conditionalExpression = $this->ConditionalExpression();
  11. }
in vendor/doctrine/orm/src/Query/Parser.php -> Join (line 1544)
  1. while (
  2. $this->lexer->isNextToken(TokenType::T_LEFT) ||
  3. $this->lexer->isNextToken(TokenType::T_INNER) ||
  4. $this->lexer->isNextToken(TokenType::T_JOIN)
  5. ) {
  6. $joins[] = $this->Join();
  7. }
  9. return new AST\IdentificationVariableDeclaration(
  10. $rangeVariableDeclaration,
  11. $indexBy,
in vendor/doctrine/orm/src/Query/Parser.php -> IdentificationVariableDeclaration (line 1301)
  1. public function FromClause(): AST\FromClause
  2. {
  3. $this->match(TokenType::T_FROM);
  5. $identificationVariableDeclarations = [];
  6. $identificationVariableDeclarations[] = $this->IdentificationVariableDeclaration();
  8. while ($this->lexer->isNextToken(TokenType::T_COMMA)) {
  9. $this->match(TokenType::T_COMMA);
  11. $identificationVariableDeclarations[] = $this->IdentificationVariableDeclaration();
in vendor/doctrine/orm/src/Query/Parser.php -> FromClause (line 843)
  1. /**
  2. * SelectStatement ::= SelectClause FromClause [WhereClause] [GroupByClause] [HavingClause] [OrderByClause]
  3. */
  4. public function SelectStatement(): AST\SelectStatement
  5. {
  6. $selectStatement = new AST\SelectStatement($this->SelectClause(), $this->FromClause());
  8. $selectStatement->whereClause = $this->lexer->isNextToken(TokenType::T_WHERE) ? $this->WhereClause() : null;
  9. $selectStatement->groupByClause = $this->lexer->isNextToken(TokenType::T_GROUP) ? $this->GroupByClause() : null;
  10. $selectStatement->havingClause = $this->lexer->isNextToken(TokenType::T_HAVING) ? $this->HavingClause() : null;
  11. $selectStatement->orderByClause = $this->lexer->isNextToken(TokenType::T_ORDER) ? $this->OrderByClause() : null;
in vendor/doctrine/orm/src/Query/Parser.php -> SelectStatement (line 814)
  2. $this->lexer->moveNext();
  4. switch ($this->lexer->lookahead->type ?? null) {
  5. case TokenType::T_SELECT:
  6. $statement = $this->SelectStatement();
  7. break;
  9. case TokenType::T_UPDATE:
  10. $statement = $this->UpdateStatement();
  11. break;
in vendor/doctrine/orm/src/Query/Parser.php -> QueryLanguage (line 238)
  1. * Parses and builds AST for the given Query.
  2. */
  3. public function getAST(): AST\SelectStatement|AST\UpdateStatement|AST\DeleteStatement
  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/src/Query/Parser.php -> getAST (line 330)
  1. /**
  2. * Parses a query string.
  3. */
  4. public function parse(): ParserResult
  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/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)
  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, $event);
  11. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
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. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  5. try {
  6. return $this->getHttpKernel()->handle($request, $type, $catch);
  7. } finally {
  8. --$this->requestStackSize;
  9. }
  10. }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. if (Kernel::VERSION_ID >= 60400) {
  9. $response->send(false);
  11. if (\function_exists('fastcgi_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 06:18:47 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "9b1b0f"
    },
    "request_uri": "https://gestionipre.investigacion-test.ing.uc.cl/_profiler/9b1b0f",
    "method": "GET"
}
DEBUG 06:18:47 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 06:18:47 event Notified event "kernel.request" to listener "Symfony\UX\Turbo\Request\RequestListener::__invoke". 
{
    "event": "kernel.request",
    "listener": "Symfony\\UX\\Turbo\\Request\\RequestListener::__invoke"
}
DEBUG 06:18:47 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 06:18:47 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 06:18:47 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 06:18:47 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 06:18:47 event Notified event "kernel.request" to listener "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\AssetMapper\\AssetMapperDevServerSubscriber::onKernelRequest"
}
DEBUG 06:18:47 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 06:18:47 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 06:18:47 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 06:18:47 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 06:18:47 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 06:18:47 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 06:18:47 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 06:18:47 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 06:18:47 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 06:18:47 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 06:18:47 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 06:18:47 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 06:18:47 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)