Error 500 Internal Server Error

GET https://gestionipre.investigacion-test.ing.uc.cl/oportunity-research/2592

IP
43.128.12.124
Profiled on
Token
736668
Forwarded to ErrorController (ccff92)

Exceptions

PDOException Exception InvalidFieldNameException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't14.grade_confirmed' in 'field list'

Exceptions 3

Doctrine\DBAL\Exception\ InvalidFieldNameException

Show exception properties 
Doctrine\DBAL\Exception\InvalidFieldNameException {#1941
  -query: Doctrine\DBAL\Query {#1942
    -sql: "SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.last_update_date AS last_update_date_3, t0.authorized_by_letter AS authorized_by_letter_4, t0.banner_authorization_date AS banner_authorization_date_5, t0.comments AS comments_6, t0.numbers_code AS numbers_code_7, t0.initials_code AS initials_code_8, t0.class_name AS class_name_9, t0.motivation_letter AS motivation_letter_10, t0.student_year AS student_year_11, t0.student_id AS student_id_12, t0.oportunity_research_id AS oportunity_research_id_13, t14.id AS id_15, t14.initials_code AS initials_code_16, t14.numbers_code AS numbers_code_17, t14.semester AS semester_18, t14.academic_year AS academic_year_19, t14.class_name AS class_name_20, t14.section AS section_21, t14.creation_date AS creation_date_22, t14.creation_date_op AS creation_date_op_23, t14.name_op AS name_op_24, t14.cmd AS cmd_25, t14.credits AS credits_26, t14.description_op AS description_op_27, t14.modality_op AS modality_op_28, t14.phd_names AS phd_names_29, t14.nrc AS nrc_30, t14.alpha_score AS alpha_score_31, t14.numeric_score AS numeric_score_32, t14.grade_confirmed AS grade_confirmed_33, t14.special_authorization AS special_authorization_34, t14.special_authorization_date AS special_authorization_date_35, t14.application_id AS application_id_36, t14.student_id AS student_id_37, t14.oportunity_research_id AS oportunity_research_id_38, t14.report_id AS report_id_39, t14.responsible_mentor_id AS responsible_mentor_id_40, t14.rcer_submission_id AS rcer_submission_id_41, t0.state_id AS state_id_42 FROM application t0 LEFT JOIN research t14 ON t14.application_id = t0.id WHERE t0.oportunity_research_id = ?"
    -params: array:1 [
      0 => 2592
    ]
    -types: array:1 [
      0 => "integer"
    ]
  }
}
in vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php (line 69)
  1. return new UniqueConstraintViolationException($exception, $query);
  3. case 1054:
  4. case 1166:
  5. case 1611:
  6. return new InvalidFieldNameException($exception, $query);
  8. case 1052:
  9. case 1060:
  10. case 1110:
  11. return new NonUniqueFieldNameException($exception, $query);
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1976)
  1. private function handleDriverException(
  2. Driver\Exception $driverException,
  3. ?Query $query
  4. ): DriverException {
  5. $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
  6. $exception = $this->exceptionConverter->convert($driverException, $query);
  8. if ($exception instanceof ConnectionLost) {
  9. $this->close();
  10. }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1918)
  1. Driver\Exception $e,
  2. string $sql,
  3. array $params = [],
  4. array $types = []
  5. ): DriverException {
  6. return $this->handleDriverException($e, new Query($sql, $params, $types));
  7. }
  9. /** @internal */
  10. final public function convertException(Driver\Exception $e): DriverException
  11. {
in vendor/doctrine/dbal/src/Connection.php -> convertExceptionDuringQuery (line 1111)
  1. $result = $connection->query($sql);
  2. }
  4. return new Result($result, $this);
  5. } catch (Driver\Exception $e) {
  6. throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
  7. } finally {
  8. if ($logger !== null) {
  9. $logger->stopQuery();
  10. }
  11. }
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> executeQuery (line 1872)
  1. }
  3. $sql = $this->getSelectSQL($criteria, $assoc, null, $limit, $offset);
  4. [$params, $types] = $this->expandToManyParameters($parameters);
  6. return $this->conn->executeQuery($sql, $params, $types);
  7. }
  9. /**
  10. * {@inheritDoc}
  11. */
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> getOneToManyStatement (line 1817)
  1. AssociationMapping $assoc,
  2. object $sourceEntity,
  3. PersistentCollection $collection,
  4. ): mixed {
  5. assert($assoc instanceof OneToManyAssociationMapping);
  6. $stmt = $this->getOneToManyStatement($assoc, $sourceEntity);
  8. return $this->loadCollectionFromStatement($assoc, $stmt, $collection);
  9. }
  11. /** Builds criteria and execute SQL statement to fetch the one to many entities from. */
in vendor/doctrine/orm/src/UnitOfWork.php -> loadOneToManyCollection (line 2729)
  1. $assoc = $collection->getMapping();
  2. $persister = $this->getEntityPersister($assoc->targetEntity);
  4. switch ($assoc->type()) {
  5. case ClassMetadata::ONE_TO_MANY:
  6. $persister->loadOneToManyCollection($assoc, $collection->getOwner(), $collection);
  7. break;
  9. case ClassMetadata::MANY_TO_MANY:
  10. $persister->loadManyToManyCollection($assoc, $collection->getOwner(), $collection);
  11. break;
in vendor/doctrine/orm/src/PersistentCollection.php -> loadCollection (line 636)
  1. if ($this->isDirty) {
  2. $newlyAddedDirtyObjects = $this->unwrap()->toArray();
  3. }
  5. $this->unwrap()->clear();
  6. $this->getUnitOfWork()->loadCollection($this);
  7. $this->takeSnapshot();
  9. if ($newlyAddedDirtyObjects) {
  10. $this->restoreNewObjectsInDirtyCollection($newlyAddedDirtyObjects);
  11. }
in vendor/doctrine/orm/src/PersistentCollection.php -> doInitialize (line 186)
  1. {
  2. if ($this->initialized || ! $this->association) {
  3. return;
  4. }
  6. $this->doInitialize();
  8. $this->initialized = true;
  9. }
  11. /**
in vendor/doctrine/collections/src/AbstractLazyCollection.php -> initialize (line 315)
  1. * @phpstan-return Traversable<TKey,T>
  2. */
  3. #[ReturnTypeWillChange]
  4. public function getIterator()
  5. {
  6. $this->initialize();
  8. return $this->collection->getIterator();
  9. }
  11. /**
AbstractLazyCollection->getIterator() in src/Entity/OportunityResearch.php (line 338)
  2. public function getOpenVacants(): int
  3. {
  4. $usedVacants = 0;
  6. foreach ($this->applications as $application) {
  7. if ($application->getState()->isVacancyConsuming()) {
  8. $usedVacants++;
  9. }
  10. }
OportunityResearch->getOpenVacants() in src/Controller/OportunityResearchController.php (line 241)
  1. }
  3. $studentsCanApply = $settingsService->get('apply-by-student', true);
  4. $mentorsHaveActivePenalizations = $oportunityResearch->mentorsHaveActivePenalizations();
  5. $isCurrentUserPenalized = $currentUser && $currentUser->hasActivePenalizations();
  6. $hasOpenVacants = $oportunityResearch->getOpenVacants() > 0;
  7. $canCurrentUserApply = $studentsCanApply && !$isCurrentUserPenalized && !$mentorsHaveActivePenalizations && $hasOpenVacants;
  9. $year = $settingsService->getAcademicYearForResearchFromDate(new \DateTime());
  10. $semester = $settingsService->getSemesterForResearchFromDate(new \DateTime());
in vendor/symfony/http-kernel/HttpKernel.php -> show (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\DBAL\Driver\PDO\ Exception

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't14.grade_confirmed' in 'field list'

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 24)
  1. } else {
  2. $code = $exception->getCode();
  3. $sqlState = null;
  4. }
  6. return new self($exception->getMessage(), $sqlState, $code, $exception);
  7. }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 132)
  1. }
  3. try {
  4. $this->stmt->execute($params);
  5. } catch (PDOException $exception) {
  6. throw Exception::new($exception);
  7. }
  9. return new Result($this->stmt);
  10. }
  11. }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 69)
  1. /**
  2. * {@inheritDoc}
  3. */
  4. public function execute($params = null): Result
  5. {
  6. return $this->wrappedStatement->execute($params);
  7. }
  8. }
in vendor/doctrine/dbal/src/Logging/Statement.php -> execute (line 98)
  1. 'sql' => $this->sql,
  2. 'params' => $params ?? $this->params,
  3. 'types' => $this->types,
  4. ]);
  6. return parent::execute($params);
  7. }
  8. }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 69)
  1. /**
  2. * {@inheritDoc}
  3. */
  4. public function execute($params = null): Result
  5. {
  6. return $this->wrappedStatement->execute($params);
  7. }
  8. }
in vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Statement.php -> execute (line 70)
  2. $this->stopwatch?->start('doctrine', 'doctrine');
  3. $query->start();
  5. try {
  6. return parent::execute($params);
  7. } finally {
  8. $query->stop();
  9. $this->stopwatch?->stop('doctrine');
  10. }
  11. }
in vendor/doctrine/dbal/src/Connection.php -> execute (line 1104)
  2. $stmt = $connection->prepare($sql);
  4. $this->bindParameters($stmt, $params, $types);
  6. $result = $stmt->execute();
  7. } else {
  8. $result = $connection->query($sql);
  9. }
  11. return new Result($result, $this);
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> executeQuery (line 1872)
  1. }
  3. $sql = $this->getSelectSQL($criteria, $assoc, null, $limit, $offset);
  4. [$params, $types] = $this->expandToManyParameters($parameters);
  6. return $this->conn->executeQuery($sql, $params, $types);
  7. }
  9. /**
  10. * {@inheritDoc}
  11. */
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> getOneToManyStatement (line 1817)
  1. AssociationMapping $assoc,
  2. object $sourceEntity,
  3. PersistentCollection $collection,
  4. ): mixed {
  5. assert($assoc instanceof OneToManyAssociationMapping);
  6. $stmt = $this->getOneToManyStatement($assoc, $sourceEntity);
  8. return $this->loadCollectionFromStatement($assoc, $stmt, $collection);
  9. }
  11. /** Builds criteria and execute SQL statement to fetch the one to many entities from. */
in vendor/doctrine/orm/src/UnitOfWork.php -> loadOneToManyCollection (line 2729)
  1. $assoc = $collection->getMapping();
  2. $persister = $this->getEntityPersister($assoc->targetEntity);
  4. switch ($assoc->type()) {
  5. case ClassMetadata::ONE_TO_MANY:
  6. $persister->loadOneToManyCollection($assoc, $collection->getOwner(), $collection);
  7. break;
  9. case ClassMetadata::MANY_TO_MANY:
  10. $persister->loadManyToManyCollection($assoc, $collection->getOwner(), $collection);
  11. break;
in vendor/doctrine/orm/src/PersistentCollection.php -> loadCollection (line 636)
  1. if ($this->isDirty) {
  2. $newlyAddedDirtyObjects = $this->unwrap()->toArray();
  3. }
  5. $this->unwrap()->clear();
  6. $this->getUnitOfWork()->loadCollection($this);
  7. $this->takeSnapshot();
  9. if ($newlyAddedDirtyObjects) {
  10. $this->restoreNewObjectsInDirtyCollection($newlyAddedDirtyObjects);
  11. }
in vendor/doctrine/orm/src/PersistentCollection.php -> doInitialize (line 186)
  1. {
  2. if ($this->initialized || ! $this->association) {
  3. return;
  4. }
  6. $this->doInitialize();
  8. $this->initialized = true;
  9. }
  11. /**
in vendor/doctrine/collections/src/AbstractLazyCollection.php -> initialize (line 315)
  1. * @phpstan-return Traversable<TKey,T>
  2. */
  3. #[ReturnTypeWillChange]
  4. public function getIterator()
  5. {
  6. $this->initialize();
  8. return $this->collection->getIterator();
  9. }
  11. /**
AbstractLazyCollection->getIterator() in src/Entity/OportunityResearch.php (line 338)
  2. public function getOpenVacants(): int
  3. {
  4. $usedVacants = 0;
  6. foreach ($this->applications as $application) {
  7. if ($application->getState()->isVacancyConsuming()) {
  8. $usedVacants++;
  9. }
  10. }
OportunityResearch->getOpenVacants() in src/Controller/OportunityResearchController.php (line 241)
  1. }
  3. $studentsCanApply = $settingsService->get('apply-by-student', true);
  4. $mentorsHaveActivePenalizations = $oportunityResearch->mentorsHaveActivePenalizations();
  5. $isCurrentUserPenalized = $currentUser && $currentUser->hasActivePenalizations();
  6. $hasOpenVacants = $oportunityResearch->getOpenVacants() > 0;
  7. $canCurrentUserApply = $studentsCanApply && !$isCurrentUserPenalized && !$mentorsHaveActivePenalizations && $hasOpenVacants;
  9. $year = $settingsService->getAcademicYearForResearchFromDate(new \DateTime());
  10. $semester = $settingsService->getSemesterForResearchFromDate(new \DateTime());
in vendor/symfony/http-kernel/HttpKernel.php -> show (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. };

PDOException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't14.grade_confirmed' in 'field list'

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 130)
  1. . ' Statement::bindParam() or Statement::bindValue() instead.',
  2. );
  3. }
  5. try {
  6. $this->stmt->execute($params);
  7. } catch (PDOException $exception) {
  8. throw Exception::new($exception);
  9. }
  11. return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 130)
  1. . ' Statement::bindParam() or Statement::bindValue() instead.',
  2. );
  3. }
  5. try {
  6. $this->stmt->execute($params);
  7. } catch (PDOException $exception) {
  8. throw Exception::new($exception);
  9. }
  11. return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 69)
  1. /**
  2. * {@inheritDoc}
  3. */
  4. public function execute($params = null): Result
  5. {
  6. return $this->wrappedStatement->execute($params);
  7. }
  8. }
in vendor/doctrine/dbal/src/Logging/Statement.php -> execute (line 98)
  1. 'sql' => $this->sql,
  2. 'params' => $params ?? $this->params,
  3. 'types' => $this->types,
  4. ]);
  6. return parent::execute($params);
  7. }
  8. }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 69)
  1. /**
  2. * {@inheritDoc}
  3. */
  4. public function execute($params = null): Result
  5. {
  6. return $this->wrappedStatement->execute($params);
  7. }
  8. }
in vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Statement.php -> execute (line 70)
  2. $this->stopwatch?->start('doctrine', 'doctrine');
  3. $query->start();
  5. try {
  6. return parent::execute($params);
  7. } finally {
  8. $query->stop();
  9. $this->stopwatch?->stop('doctrine');
  10. }
  11. }
in vendor/doctrine/dbal/src/Connection.php -> execute (line 1104)
  2. $stmt = $connection->prepare($sql);
  4. $this->bindParameters($stmt, $params, $types);
  6. $result = $stmt->execute();
  7. } else {
  8. $result = $connection->query($sql);
  9. }
  11. return new Result($result, $this);
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> executeQuery (line 1872)
  1. }
  3. $sql = $this->getSelectSQL($criteria, $assoc, null, $limit, $offset);
  4. [$params, $types] = $this->expandToManyParameters($parameters);
  6. return $this->conn->executeQuery($sql, $params, $types);
  7. }
  9. /**
  10. * {@inheritDoc}
  11. */
in vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php -> getOneToManyStatement (line 1817)
  1. AssociationMapping $assoc,
  2. object $sourceEntity,
  3. PersistentCollection $collection,
  4. ): mixed {
  5. assert($assoc instanceof OneToManyAssociationMapping);
  6. $stmt = $this->getOneToManyStatement($assoc, $sourceEntity);
  8. return $this->loadCollectionFromStatement($assoc, $stmt, $collection);
  9. }
  11. /** Builds criteria and execute SQL statement to fetch the one to many entities from. */
in vendor/doctrine/orm/src/UnitOfWork.php -> loadOneToManyCollection (line 2729)
  1. $assoc = $collection->getMapping();
  2. $persister = $this->getEntityPersister($assoc->targetEntity);
  4. switch ($assoc->type()) {
  5. case ClassMetadata::ONE_TO_MANY:
  6. $persister->loadOneToManyCollection($assoc, $collection->getOwner(), $collection);
  7. break;
  9. case ClassMetadata::MANY_TO_MANY:
  10. $persister->loadManyToManyCollection($assoc, $collection->getOwner(), $collection);
  11. break;
in vendor/doctrine/orm/src/PersistentCollection.php -> loadCollection (line 636)
  1. if ($this->isDirty) {
  2. $newlyAddedDirtyObjects = $this->unwrap()->toArray();
  3. }
  5. $this->unwrap()->clear();
  6. $this->getUnitOfWork()->loadCollection($this);
  7. $this->takeSnapshot();
  9. if ($newlyAddedDirtyObjects) {
  10. $this->restoreNewObjectsInDirtyCollection($newlyAddedDirtyObjects);
  11. }
in vendor/doctrine/orm/src/PersistentCollection.php -> doInitialize (line 186)
  1. {
  2. if ($this->initialized || ! $this->association) {
  3. return;
  4. }
  6. $this->doInitialize();
  8. $this->initialized = true;
  9. }
  11. /**
in vendor/doctrine/collections/src/AbstractLazyCollection.php -> initialize (line 315)
  1. * @phpstan-return Traversable<TKey,T>
  2. */
  3. #[ReturnTypeWillChange]
  4. public function getIterator()
  5. {
  6. $this->initialize();
  8. return $this->collection->getIterator();
  9. }
  11. /**
AbstractLazyCollection->getIterator() in src/Entity/OportunityResearch.php (line 338)
  2. public function getOpenVacants(): int
  3. {
  4. $usedVacants = 0;
  6. foreach ($this->applications as $application) {
  7. if ($application->getState()->isVacancyConsuming()) {
  8. $usedVacants++;
  9. }
  10. }
OportunityResearch->getOpenVacants() in src/Controller/OportunityResearchController.php (line 241)
  1. }
  3. $studentsCanApply = $settingsService->get('apply-by-student', true);
  4. $mentorsHaveActivePenalizations = $oportunityResearch->mentorsHaveActivePenalizations();
  5. $isCurrentUserPenalized = $currentUser && $currentUser->hasActivePenalizations();
  6. $hasOpenVacants = $oportunityResearch->getOpenVacants() > 0;
  7. $canCurrentUserApply = $studentsCanApply && !$isCurrentUserPenalized && !$mentorsHaveActivePenalizations && $hasOpenVacants;
  9. $year = $settingsService->getAcademicYearForResearchFromDate(new \DateTime());
  10. $semester = $settingsService->getSemesterForResearchFromDate(new \DateTime());
in vendor/symfony/http-kernel/HttpKernel.php -> show (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 09:14:13 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "736668"
    },
    "request_uri": "https://gestionipre.investigacion-test.ing.uc.cl/_profiler/736668",
    "method": "GET"
}
DEBUG 09:14:13 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 09:14:13 event Notified event "kernel.request" to listener "Symfony\UX\Turbo\Request\RequestListener::__invoke". 
{
    "event": "kernel.request",
    "listener": "Symfony\\UX\\Turbo\\Request\\RequestListener::__invoke"
}
DEBUG 09:14:13 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 09:14:13 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 09:14:13 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 09:14:13 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 09:14:13 event Notified event "kernel.request" to listener "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\AssetMapper\\AssetMapperDevServerSubscriber::onKernelRequest"
}
DEBUG 09:14:13 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 09:14:13 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 09:14:13 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 09:14:13 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 09:14:13 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 09:14:13 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 09:14:13 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 09:14:13 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 09:14:13 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 09:14:13 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 09:14:13 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 09:14:13 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 09:14:13 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 3

[3/3] InvalidFieldNameException 
Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't14.grade_confirmed' in 'field list'

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:69
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1976)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1918)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Connection.php:1111)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:1872)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement()
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:1817)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection()
     (vendor/doctrine/orm/src/UnitOfWork.php:2729)
  at Doctrine\ORM\UnitOfWork->loadCollection()
     (vendor/doctrine/orm/src/PersistentCollection.php:636)
  at Doctrine\ORM\PersistentCollection->doInitialize()
     (vendor/doctrine/orm/src/PersistentCollection.php:186)
  at Doctrine\ORM\PersistentCollection->initialize()
     (vendor/doctrine/collections/src/AbstractLazyCollection.php:315)
  at Doctrine\Common\Collections\AbstractLazyCollection->getIterator()
     (src/Entity/OportunityResearch.php:338)
  at App\Entity\OportunityResearch->getOpenVacants()
     (src/Controller/OportunityResearchController.php:241)
  at App\Controller\OportunityResearchController->show()
     (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)
[2/3] Exception 
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 't14.grade_confirmed' in 'field list'

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:132)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/doctrine/dbal/src/Logging/Statement.php:98)
  at Doctrine\DBAL\Logging\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Statement.php:70)
  at Symfony\Bridge\Doctrine\Middleware\Debug\DBAL3\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:1104)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:1872)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement()
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:1817)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection()
     (vendor/doctrine/orm/src/UnitOfWork.php:2729)
  at Doctrine\ORM\UnitOfWork->loadCollection()
     (vendor/doctrine/orm/src/PersistentCollection.php:636)
  at Doctrine\ORM\PersistentCollection->doInitialize()
     (vendor/doctrine/orm/src/PersistentCollection.php:186)
  at Doctrine\ORM\PersistentCollection->initialize()
     (vendor/doctrine/collections/src/AbstractLazyCollection.php:315)
  at Doctrine\Common\Collections\AbstractLazyCollection->getIterator()
     (src/Entity/OportunityResearch.php:338)
  at App\Entity\OportunityResearch->getOpenVacants()
     (src/Controller/OportunityResearchController.php:241)
  at App\Controller\OportunityResearchController->show()
     (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/3] PDOException 
PDOException:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 't14.grade_confirmed' in 'field list'

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130
  at PDOStatement->execute()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/doctrine/dbal/src/Logging/Statement.php:98)
  at Doctrine\DBAL\Logging\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Statement.php:70)
  at Symfony\Bridge\Doctrine\Middleware\Debug\DBAL3\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:1104)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:1872)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement()
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:1817)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection()
     (vendor/doctrine/orm/src/UnitOfWork.php:2729)
  at Doctrine\ORM\UnitOfWork->loadCollection()
     (vendor/doctrine/orm/src/PersistentCollection.php:636)
  at Doctrine\ORM\PersistentCollection->doInitialize()
     (vendor/doctrine/orm/src/PersistentCollection.php:186)
  at Doctrine\ORM\PersistentCollection->initialize()
     (vendor/doctrine/collections/src/AbstractLazyCollection.php:315)
  at Doctrine\Common\Collections\AbstractLazyCollection->getIterator()
     (src/Entity/OportunityResearch.php:338)
  at App\Entity\OportunityResearch->getOpenVacants()
     (src/Controller/OportunityResearchController.php:241)
  at App\Controller\OportunityResearchController->show()
     (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)