https://install.oceanexpert.org/expert/54149

Forwarded to
ErrorController (f5fdfa)
Method
GET
HTTP Status
500
IP
207.46.13.87
Profiled on
Token
9a9597

Exceptions

PDOException Exception TableNotFoundException

HTTP 500 Internal Server Error

An exception occurred while executing 'SELECT r0_.name AS name_0 FROM regions r0_ WHERE r0_.id_region IN (?)' with params [""]:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'oceanexpert_dev.regions' doesn't exist

  • Exceptions 3
  • Logs
  • Stack Traces 3

Doctrine\DBAL\Exception\ TableNotFoundException

in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php (line 61)
  1.             case '1050':
  2.                 return new TableExistsException($message, $exception);
  4.             case '1051':
  5.             case '1146':
  6.                 return new TableNotFoundException($message, $exception);
  8.             case '1216':
  9.             case '1217':
  10.             case '1451':
  11.             case '1452':
in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php -> convertException (line 182)
  1.         if ($driverEx instanceof DriverException) {
  2.             return $driverEx;
  3.         }
  5.         if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DeprecatedDriverException) {
  6.             return $driver->convertException($msg, $driverEx);
  7.         }
  9.         return new Exception($msg, 0, $driverEx);
  10.     }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php :: wrapException (line 159)
  1.             $msg .= ' with params ' . self::formatParameters($params);
  2.         }
  4.         $msg .= ":\n\n" . $driverEx->getMessage();
  6.         return self::wrapException($driver, $driverEx, $msg);
  7.     }
  9.     /**
  10.      * @deprecated
  11.      *
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php :: driverExceptionDuringQuery (line 2226)
  1.         $this->throw(
  2.             Exception::driverExceptionDuringQuery(
  3.                 $this->_driver,
  4.                 $e,
  5.                 $sql,
  6.                 $this->resolveParams($params, $types)
  7.             )
  8.         );
  9.     }
  11.     /**
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php -> handleExceptionDuringQuery (line 1313)
  1.             } else {
  2.                 $stmt = $connection->query($sql);
  3.             }
  4.         } catch (Throwable $e) {
  5.             $this->handleExceptionDuringQuery(
  6.                 $e,
  7.                 $sql,
  8.                 $params,
  9.                 $types
  10.             );
  11.         }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php -> executeQuery (line 50)
  1.     /**
  2.      * {@inheritDoc}
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types)
  5.     {
  6.         return $conn->executeQuery($this->_sqlStatements, $params, $types, $this->queryCacheProfile);
  7.     }
  8. }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php -> execute (line 338)
  1.             $sqlParams,
  2.             $types,
  3.             $this->_em->getConnection()->getParams()
  4.         );
  6.         return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
  7.     }
  9.     private function evictResultSetCache(
  10.         AbstractSqlExecutor $executor,
  11.         array $sqlParams,
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> _doExecute (line 1000)
  2.                 $cache->save($cacheKey, $result, $queryCacheProfile->getLifetime());
  3.             };
  4.         }
  6.         $stmt = $this->_doExecute();
  8.         if (is_numeric($stmt)) {
  9.             $setCacheEntry($stmt);
  11.             return $stmt;
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> executeIgnoreQueryCache (line 954)
  1.     {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4.         }
  6.         return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7.     }
  9.     /**
  10.      * Execute query ignoring second level cache.
  11.      *
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> execute (line 757)
  1.      *
  2.      * @return mixed
  3.      */
  4.     public function getResult($hydrationMode = self::HYDRATE_OBJECT)
  5.     {
  6.         return $this->execute(null, $hydrationMode);
  7.     }
  9.     /**
  10.      * Gets the array of results for the query.
  11.      *
AbstractQuery->getResult() in src/OceanExpertBundle/Controller/ProfileController.php (line 1417)
  1.             ->select('a.name')
  2.             ->where('a.idRegion in (:codeArr)')
  3.             ->setParameter('codeArr', $codeArr)
  4.             ->getQuery();
  6.         $regions = $query->getResult();
  7.         $regionsList = array_column($regions, 'name');
  8.         return implode(', ', $regionsList);
  9.     }
  11.     /**
ProfileController->getResearchAreaByCodes() in src/OceanExpertBundle/Controller/ProfileController.php (line 461)
  2.             if (isset($expert['expertInfo']['studyregion'])) {
  3.                 $expert['studyregion'] = $this->getResearchAreaByCodes(
  4.                     explode(
  5.                         ',',
  6.                         $expert['expertInfo']['studyregion']
  7.                     )
  8.                 );
  9.             }
in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php -> viewProfileAction (line 169)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php -> handleRaw (line 81)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Exception $e) {
  8.             if ($e instanceof RequestExceptionInterface) {
  9.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  10.             }
  11.             if (false === $catch) {
in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php -> handle (line 201)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
Kernel->handle() in web/index.php (line 25)
  1.     Request::setTrustedHosts([$trustedHosts]);
  2. }
  4. $kernel = new AppKernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  5. $request = Request::createFromGlobals();
  6. $response = $kernel->handle($request);
  7. $response->send();
  8. $kernel->terminate($request, $response);
include('/var/www/html/oceanexpert_dev/web/index.php') in web/app.php (line 3)
  1. <?php
  3. include './index.php';

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'oceanexpert_dev.regions' doesn't exist
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php (line 18)
  1.  */
  2. final class Exception extends PDOException
  3. {
  4.     public static function new(\PDOException $exception): self
  5.     {
  6.         return new self($exception);
  7.     }
  8. }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php :: new (line 119)
  1.     public function execute($params = null)
  2.     {
  3.         try {
  4.             return parent::execute($params);
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  8.     }
  10.     /**
  11.      * {@inheritdoc}
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php -> execute (line 1304)
  1.                 [$sql, $params, $types] = SQLParserUtils::expandListParameters($sql, $params, $types);
  3.                 $stmt = $connection->prepare($sql);
  4.                 if ($types) {
  5.                     $this->_bindTypedValues($stmt, $params, $types);
  6.                     $stmt->execute();
  7.                 } else {
  8.                     $stmt->execute($params);
  9.                 }
  10.             } else {
  11.                 $stmt = $connection->query($sql);
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php -> executeQuery (line 50)
  1.     /**
  2.      * {@inheritDoc}
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types)
  5.     {
  6.         return $conn->executeQuery($this->_sqlStatements, $params, $types, $this->queryCacheProfile);
  7.     }
  8. }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php -> execute (line 338)
  1.             $sqlParams,
  2.             $types,
  3.             $this->_em->getConnection()->getParams()
  4.         );
  6.         return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
  7.     }
  9.     private function evictResultSetCache(
  10.         AbstractSqlExecutor $executor,
  11.         array $sqlParams,
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> _doExecute (line 1000)
  2.                 $cache->save($cacheKey, $result, $queryCacheProfile->getLifetime());
  3.             };
  4.         }
  6.         $stmt = $this->_doExecute();
  8.         if (is_numeric($stmt)) {
  9.             $setCacheEntry($stmt);
  11.             return $stmt;
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> executeIgnoreQueryCache (line 954)
  1.     {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4.         }
  6.         return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7.     }
  9.     /**
  10.      * Execute query ignoring second level cache.
  11.      *
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> execute (line 757)
  1.      *
  2.      * @return mixed
  3.      */
  4.     public function getResult($hydrationMode = self::HYDRATE_OBJECT)
  5.     {
  6.         return $this->execute(null, $hydrationMode);
  7.     }
  9.     /**
  10.      * Gets the array of results for the query.
  11.      *
AbstractQuery->getResult() in src/OceanExpertBundle/Controller/ProfileController.php (line 1417)
  1.             ->select('a.name')
  2.             ->where('a.idRegion in (:codeArr)')
  3.             ->setParameter('codeArr', $codeArr)
  4.             ->getQuery();
  6.         $regions = $query->getResult();
  7.         $regionsList = array_column($regions, 'name');
  8.         return implode(', ', $regionsList);
  9.     }
  11.     /**
ProfileController->getResearchAreaByCodes() in src/OceanExpertBundle/Controller/ProfileController.php (line 461)
  2.             if (isset($expert['expertInfo']['studyregion'])) {
  3.                 $expert['studyregion'] = $this->getResearchAreaByCodes(
  4.                     explode(
  5.                         ',',
  6.                         $expert['expertInfo']['studyregion']
  7.                     )
  8.                 );
  9.             }
in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php -> viewProfileAction (line 169)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php -> handleRaw (line 81)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Exception $e) {
  8.             if ($e instanceof RequestExceptionInterface) {
  9.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  10.             }
  11.             if (false === $catch) {
in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php -> handle (line 201)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
Kernel->handle() in web/index.php (line 25)
  1.     Request::setTrustedHosts([$trustedHosts]);
  2. }
  4. $kernel = new AppKernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  5. $request = Request::createFromGlobals();
  6. $response = $kernel->handle($request);
  7. $response->send();
  8. $kernel->terminate($request, $response);
include('/var/www/html/oceanexpert_dev/web/index.php') in web/app.php (line 3)
  1. <?php
  3. include './index.php';

PDOException

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'oceanexpert_dev.regions' doesn't exist
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php (line 117)
  1.      */
  2.     #[ReturnTypeWillChange]
  3.     public function execute($params = null)
  4.     {
  5.         try {
  6.             return parent::execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  10.     }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php -> execute (line 117)
  1.      */
  2.     #[ReturnTypeWillChange]
  3.     public function execute($params = null)
  4.     {
  5.         try {
  6.             return parent::execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  10.     }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php -> execute (line 1304)
  1.                 [$sql, $params, $types] = SQLParserUtils::expandListParameters($sql, $params, $types);
  3.                 $stmt = $connection->prepare($sql);
  4.                 if ($types) {
  5.                     $this->_bindTypedValues($stmt, $params, $types);
  6.                     $stmt->execute();
  7.                 } else {
  8.                     $stmt->execute($params);
  9.                 }
  10.             } else {
  11.                 $stmt = $connection->query($sql);
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php -> executeQuery (line 50)
  1.     /**
  2.      * {@inheritDoc}
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types)
  5.     {
  6.         return $conn->executeQuery($this->_sqlStatements, $params, $types, $this->queryCacheProfile);
  7.     }
  8. }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php -> execute (line 338)
  1.             $sqlParams,
  2.             $types,
  3.             $this->_em->getConnection()->getParams()
  4.         );
  6.         return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
  7.     }
  9.     private function evictResultSetCache(
  10.         AbstractSqlExecutor $executor,
  11.         array $sqlParams,
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> _doExecute (line 1000)
  2.                 $cache->save($cacheKey, $result, $queryCacheProfile->getLifetime());
  3.             };
  4.         }
  6.         $stmt = $this->_doExecute();
  8.         if (is_numeric($stmt)) {
  9.             $setCacheEntry($stmt);
  11.             return $stmt;
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> executeIgnoreQueryCache (line 954)
  1.     {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4.         }
  6.         return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7.     }
  9.     /**
  10.      * Execute query ignoring second level cache.
  11.      *
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> execute (line 757)
  1.      *
  2.      * @return mixed
  3.      */
  4.     public function getResult($hydrationMode = self::HYDRATE_OBJECT)
  5.     {
  6.         return $this->execute(null, $hydrationMode);
  7.     }
  9.     /**
  10.      * Gets the array of results for the query.
  11.      *
AbstractQuery->getResult() in src/OceanExpertBundle/Controller/ProfileController.php (line 1417)
  1.             ->select('a.name')
  2.             ->where('a.idRegion in (:codeArr)')
  3.             ->setParameter('codeArr', $codeArr)
  4.             ->getQuery();
  6.         $regions = $query->getResult();
  7.         $regionsList = array_column($regions, 'name');
  8.         return implode(', ', $regionsList);
  9.     }
  11.     /**
ProfileController->getResearchAreaByCodes() in src/OceanExpertBundle/Controller/ProfileController.php (line 461)
  2.             if (isset($expert['expertInfo']['studyregion'])) {
  3.                 $expert['studyregion'] = $this->getResearchAreaByCodes(
  4.                     explode(
  5.                         ',',
  6.                         $expert['expertInfo']['studyregion']
  7.                     )
  8.                 );
  9.             }
in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php -> viewProfileAction (line 169)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php -> handleRaw (line 81)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Exception $e) {
  8.             if ($e instanceof RequestExceptionInterface) {
  9.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  10.             }
  11.             if (false === $catch) {
in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php -> handle (line 201)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
Kernel->handle() in web/index.php (line 25)
  1.     Request::setTrustedHosts([$trustedHosts]);
  2. }
  4. $kernel = new AppKernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  5. $request = Request::createFromGlobals();
  6. $response = $kernel->handle($request);
  7. $response->send();
  8. $kernel->terminate($request, $response);
include('/var/www/html/oceanexpert_dev/web/index.php') in web/app.php (line 3)
  1. <?php
  3. include './index.php';