https://dev.oceanexpert.org/expert/64111

Log Messages

  • Info. & Errors 1
  • Deprecations 289
  • Debug 114
  • PHP Notices 0
  • Container 693

Informational and error log messages generated during the execution of the application.

Level
  • Emergency
  • Alert
  • Critical
  • Error
  • Warning
  • Notice
  • Info
Channel
  • request
  • security
Message
INFO request Matched route
"view_profile"
.
0 of 0
[ "route" => "view_profile" "route_parameters" => [ "_route" => "view_profile" "_controller" => "OceanExpertBundle\Controller\ProfileController::viewProfileAction" "user" => "64111" ] "request_uri" => "https://dev.oceanexpert.org/expert/64111" "method" => "GET" ]
INFO security Populated the TokenStorage with an anonymous Token.
CRITICAL request Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: "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" at /var/www/html/oceanexpert_dev/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 61
0 of 0
[ "exception" => Doctrine\DBAL\Exception\TableNotFoundException {#2649 -driverException: Doctrine\DBAL\Driver\PDO\Exception {#2659 …} #message: """ An exception occurred while executing 'SELECT r0_.name AS name_0 FROM regions r0_ WHERE r0_.id_region IN (?)' with params [""]:\n \n SQLSTATE[42S02]: Base table or view not found: 1146 Table 'oceanexpert_dev.regions' doesn't exist """ #code: 0 #file: "/var/www/html/oceanexpert_dev/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php" #line: 61 -previous: Doctrine\DBAL\Driver\PDO\Exception {#2659 …} trace: { /var/www/html/oceanexpert_dev/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:61 { Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException($message, DriverException $exception) … › case '1146': return new TableNotFoundException($message, $exception);} /var/www/html/oceanexpert_dev/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182 { Doctrine\DBAL\DBALException::wrapException(Driver $driver, Throwable $driverEx, string $msg) … › if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DeprecatedDriverException) { return $driver->convertException($msg, $driverEx);} } /var/www/html/oceanexpert_dev/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159 { Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Driver $driver, Throwable $driverEx, $sql, array $params = []) … › › return self::wrapException($driver, $driverEx, $msg);} } /var/www/html/oceanexpert_dev/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2226 { Doctrine\DBAL\Connection->handleExceptionDuringQuery(Throwable $e, string $sql, array $params = [], array $types = []): void … › $sql, $this->resolveParams($params, $types)) } /var/www/html/oceanexpert_dev/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1313 { Doctrine\DBAL\Connection->executeQuery($sql, array $params = [], $types = [], QueryCacheProfile $qcp = null) … › $this->handleExceptionDuringQuery( $e, $sql, } /var/www/html/oceanexpert_dev/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:50 { Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Connection $conn, array $params, array $types) … › { return $conn->executeQuery($this->_sqlStatements, $params, $types, $this->queryCacheProfile);} } /var/www/html/oceanexpert_dev/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:338 { Doctrine\ORM\Query->_doExecute() … › › return $executor->execute($this->_em->getConnection(), $sqlParams, $types);} } /var/www/html/oceanexpert_dev/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1000 { Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache($parameters = null, $hydrationMode = null) … › › $stmt = $this->_doExecute();} /var/www/html/oceanexpert_dev/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:954 { Doctrine\ORM\AbstractQuery->execute($parameters = null, $hydrationMode = null) … › › return $this->executeIgnoreQueryCache($parameters, $hydrationMode);} } /var/www/html/oceanexpert_dev/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:757 { Doctrine\ORM\AbstractQuery->getResult($hydrationMode = self::HYDRATE_OBJECT) … › { return $this->execute(null, $hydrationMode);} } /var/www/html/oceanexpert_dev/src/OceanExpertBundle/Controller/ProfileController.php:1425 { OceanExpertBundle\Controller\ProfileController->getResearchAreaByCodes($codeArr) … › › $regions = $query->getResult();$regionsList = array_column($regions, 'name'); } /var/www/html/oceanexpert_dev/src/OceanExpertBundle/Controller/ProfileController.php:469 { OceanExpertBundle\Controller\ProfileController->viewProfileAction(Request $request, string $user = ''): Response … › ',', $expert['expertInfo']['studyregion']) } /var/www/html/oceanexpert_dev/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:169 { Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MASTER_REQUEST): Response … › // call controller$response = $controller(...$arguments);} /var/www/html/oceanexpert_dev/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:81 { Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true) … › try { return $this->handleRaw($request, $type);} catch (\Exception $e) { } /var/www/html/oceanexpert_dev/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:201 { Symfony\Component\HttpKernel\Kernel->handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true) … › try { return $this->getHttpKernel()->handle($request, $type, $catch);} finally { } /var/www/html/oceanexpert_dev/web/index.php:25 { include … › $request = Request::createFromGlobals();$response = $kernel->handle($request);$response->send(); } /var/www/html/oceanexpert_dev/web/app.php:3 { › › include './index.php';arguments: { "/var/www/html/oceanexpert_dev/web/index.php" } } } } ]
0 of 0
{ /var/www/html/oceanexpert_dev/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:61 { Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException($message, DriverException $exception) … › case '1146': return new TableNotFoundException($message, $exception);} /var/www/html/oceanexpert_dev/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182 { Doctrine\DBAL\DBALException::wrapException(Driver $driver, Throwable $driverEx, string $msg) … › if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DeprecatedDriverException) { return $driver->convertException($msg, $driverEx);} } /var/www/html/oceanexpert_dev/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159 { Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Driver $driver, Throwable $driverEx, $sql, array $params = []) … › › return self::wrapException($driver, $driverEx, $msg);} } /var/www/html/oceanexpert_dev/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2226 { Doctrine\DBAL\Connection->handleExceptionDuringQuery(Throwable $e, string $sql, array $params = [], array $types = []): void … › $sql, $this->resolveParams($params, $types)) } /var/www/html/oceanexpert_dev/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1313 { Doctrine\DBAL\Connection->executeQuery($sql, array $params = [], $types = [], QueryCacheProfile $qcp = null) … › $this->handleExceptionDuringQuery( $e, $sql, } /var/www/html/oceanexpert_dev/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:50 { Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Connection $conn, array $params, array $types) … › { return $conn->executeQuery($this->_sqlStatements, $params, $types, $this->queryCacheProfile);} } /var/www/html/oceanexpert_dev/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:338 { Doctrine\ORM\Query->_doExecute() … › › return $executor->execute($this->_em->getConnection(), $sqlParams, $types);} } /var/www/html/oceanexpert_dev/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1000 { Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache($parameters = null, $hydrationMode = null) … › › $stmt = $this->_doExecute();} /var/www/html/oceanexpert_dev/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:954 { Doctrine\ORM\AbstractQuery->execute($parameters = null, $hydrationMode = null) … › › return $this->executeIgnoreQueryCache($parameters, $hydrationMode);} } /var/www/html/oceanexpert_dev/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:757 { Doctrine\ORM\AbstractQuery->getResult($hydrationMode = self::HYDRATE_OBJECT) … › { return $this->execute(null, $hydrationMode);} } /var/www/html/oceanexpert_dev/src/OceanExpertBundle/Controller/ProfileController.php:1425 { OceanExpertBundle\Controller\ProfileController->getResearchAreaByCodes($codeArr) … › › $regions = $query->getResult();$regionsList = array_column($regions, 'name'); } /var/www/html/oceanexpert_dev/src/OceanExpertBundle/Controller/ProfileController.php:469 { OceanExpertBundle\Controller\ProfileController->viewProfileAction(Request $request, string $user = ''): Response … › ',', $expert['expertInfo']['studyregion']) } /var/www/html/oceanexpert_dev/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:169 { Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MASTER_REQUEST): Response … › // call controller$response = $controller(...$arguments);} /var/www/html/oceanexpert_dev/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:81 { Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true) … › try { return $this->handleRaw($request, $type);} catch (\Exception $e) { } /var/www/html/oceanexpert_dev/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:201 { Symfony\Component\HttpKernel\Kernel->handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true) … › try { return $this->getHttpKernel()->handle($request, $type, $catch);} finally { } /var/www/html/oceanexpert_dev/web/index.php:25 { include … › $request = Request::createFromGlobals();$response = $kernel->handle($request);$response->send(); } /var/www/html/oceanexpert_dev/web/app.php:3 { › › include './index.php';arguments: { "/var/www/html/oceanexpert_dev/web/index.php" } } }