Exceptions
Exceptions 3
Doctrine\DBAL\Exception\ TableNotFoundException
case 1050:return new TableExistsException($exception, $query);case 1051:case 1146:return new TableNotFoundException($exception, $query);case 1216:case 1217:case 1451:case 1452:
in
vendor/doctrine/dbal/src/Connection.php
->
convert
(line 1976)
private function handleDriverException(Driver\Exception $driverException,?Query $query): DriverException {$this->exceptionConverter ??= $this->_driver->getExceptionConverter();$exception = $this->exceptionConverter->convert($driverException, $query);if ($exception instanceof ConnectionLost) {$this->close();}
in
vendor/doctrine/dbal/src/Connection.php
->
handleDriverException
(line 1918)
Driver\Exception $e,string $sql,array $params = [],array $types = []): DriverException {return $this->handleDriverException($e, new Query($sql, $params, $types));}/** @internal */final public function convertException(Driver\Exception $e): DriverException{
in
vendor/doctrine/dbal/src/Connection.php
->
convertExceptionDuringQuery
(line 1111)
$result = $connection->query($sql);}return new Result($result, $this);} catch (Driver\Exception $e) {throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);} finally {if ($logger !== null) {$logger->stopQuery();}}
in
vendor/doctrine/dbal/src/Connection.php
->
executeQuery
(line 627)
** @throws Exception*/public function fetchOne(string $query, array $params = [], array $types = []){return $this->executeQuery($query, $params, $types)->fetchOne();}/*** Whether an actual connection to the database is established.*
public function __construct(private EntityManagerInterface $entityManager) {}public function getNumberOfEstablishments(): int{//try {return (int)$this->entityManager->getConnection()->fetchOne('SELECT COUNT(*) FROM erp');//} catch (Exception) {// return 0;//}}
class IndexController extends AbstractController{#[Route('/', name: 'homepage')]public function index(ErpHelper $erpHelper): Response{dump($erpHelper->getNumberOfEstablishments());return $this->render('index.html.twig', ['nbEstablishments' => $erpHelper->getNumberOfEstablishments()]);}}
in
vendor/symfony/http-kernel/HttpKernel.php
->
index
(line 195)
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);$controller = $event->getController();$arguments = $event->getArguments();// call controller$response = $controller(...$arguments);// viewif (!$response instanceof Response) {$event = new ViewEvent($this, $request, $type, $response, $event);$this->dispatcher->dispatch($event, KernelEvents::VIEW);
in
vendor/symfony/http-kernel/HttpKernel.php
->
handleRaw
(line 77)
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());$this->requestStack->push($request);$response = null;try {return $response = $this->handleRaw($request, $type);} catch (\Throwable $e) {if ($e instanceof \Error && !$this->handleAllThrowables) {throw $e;}
in
vendor/symfony/http-kernel/Kernel.php
->
handle
(line 205)
if (!$this->handlingHttpCache) {$this->resetServices = true;}try {return $this->getHttpKernel()->handle($request, $type, $catch);} finally {--$this->requestStackSize;}}
in
vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php
->
handle
(line 34)
) {}public function run(): int{$response = $this->kernel->handle($this->request);$response->send(false);if (\function_exists('fastcgi_finish_request') && !$this->debug) {fastcgi_finish_request();
in
vendor/autoload_runtime.php
->
run
(line 32)
$app = $app(...$args);exit($runtime->getRunner($app)->run());
<?phpuse App\Kernel;require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return function (array $context) {return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);};
Doctrine\DBAL\Driver\PDO\ Exception
in
vendor/doctrine/dbal/src/Driver/PDO/Exception.php
(line 24)
} else {$code = $exception->getCode();$sqlState = null;}return new self($exception->getMessage(), $sqlState, $code, $exception);}}
in
vendor/doctrine/dbal/src/Driver/PDO/Connection.php
::
new
(line 76)
$stmt = $this->connection->query($sql);assert($stmt instanceof PDOStatement);return new Result($stmt);} catch (PDOException $exception) {throw Exception::new($exception);}}/*** {@inheritDoc}
in
vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php
->
query
(line 33)
return $this->wrappedConnection->prepare($sql);}public function query(string $sql): Result{return $this->wrappedConnection->query($sql);}/*** {@inheritDoc}*/
in
vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Connection.php
->
query
(line 58)
$this->stopwatch?->start('doctrine', 'doctrine');$query->start();try {return parent::query($sql);} finally {$query->stop();$this->stopwatch?->stop('doctrine');}}
in
vendor/doctrine/dbal/src/Connection.php
->
query
(line 1106)
$this->bindParameters($stmt, $params, $types);$result = $stmt->execute();} else {$result = $connection->query($sql);}return new Result($result, $this);} catch (Driver\Exception $e) {throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
in
vendor/doctrine/dbal/src/Connection.php
->
executeQuery
(line 627)
** @throws Exception*/public function fetchOne(string $query, array $params = [], array $types = []){return $this->executeQuery($query, $params, $types)->fetchOne();}/*** Whether an actual connection to the database is established.*
public function __construct(private EntityManagerInterface $entityManager) {}public function getNumberOfEstablishments(): int{//try {return (int)$this->entityManager->getConnection()->fetchOne('SELECT COUNT(*) FROM erp');//} catch (Exception) {// return 0;//}}
class IndexController extends AbstractController{#[Route('/', name: 'homepage')]public function index(ErpHelper $erpHelper): Response{dump($erpHelper->getNumberOfEstablishments());return $this->render('index.html.twig', ['nbEstablishments' => $erpHelper->getNumberOfEstablishments()]);}}
in
vendor/symfony/http-kernel/HttpKernel.php
->
index
(line 195)
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);$controller = $event->getController();$arguments = $event->getArguments();// call controller$response = $controller(...$arguments);// viewif (!$response instanceof Response) {$event = new ViewEvent($this, $request, $type, $response, $event);$this->dispatcher->dispatch($event, KernelEvents::VIEW);
in
vendor/symfony/http-kernel/HttpKernel.php
->
handleRaw
(line 77)
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());$this->requestStack->push($request);$response = null;try {return $response = $this->handleRaw($request, $type);} catch (\Throwable $e) {if ($e instanceof \Error && !$this->handleAllThrowables) {throw $e;}
in
vendor/symfony/http-kernel/Kernel.php
->
handle
(line 205)
if (!$this->handlingHttpCache) {$this->resetServices = true;}try {return $this->getHttpKernel()->handle($request, $type, $catch);} finally {--$this->requestStackSize;}}
in
vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php
->
handle
(line 34)
) {}public function run(): int{$response = $this->kernel->handle($this->request);$response->send(false);if (\function_exists('fastcgi_finish_request') && !$this->debug) {fastcgi_finish_request();
in
vendor/autoload_runtime.php
->
run
(line 32)
$app = $app(...$args);exit($runtime->getRunner($app)->run());
<?phpuse App\Kernel;require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return function (array $context) {return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);};
PDOException
in
vendor/doctrine/dbal/src/Driver/PDO/Connection.php
(line 71)
}public function query(string $sql): ResultInterface{try {$stmt = $this->connection->query($sql);assert($stmt instanceof PDOStatement);return new Result($stmt);} catch (PDOException $exception) {throw Exception::new($exception);
in
vendor/doctrine/dbal/src/Driver/PDO/Connection.php
->
query
(line 71)
}public function query(string $sql): ResultInterface{try {$stmt = $this->connection->query($sql);assert($stmt instanceof PDOStatement);return new Result($stmt);} catch (PDOException $exception) {throw Exception::new($exception);
in
vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php
->
query
(line 33)
return $this->wrappedConnection->prepare($sql);}public function query(string $sql): Result{return $this->wrappedConnection->query($sql);}/*** {@inheritDoc}*/
in
vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Connection.php
->
query
(line 58)
$this->stopwatch?->start('doctrine', 'doctrine');$query->start();try {return parent::query($sql);} finally {$query->stop();$this->stopwatch?->stop('doctrine');}}
in
vendor/doctrine/dbal/src/Connection.php
->
query
(line 1106)
$this->bindParameters($stmt, $params, $types);$result = $stmt->execute();} else {$result = $connection->query($sql);}return new Result($result, $this);} catch (Driver\Exception $e) {throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
in
vendor/doctrine/dbal/src/Connection.php
->
executeQuery
(line 627)
** @throws Exception*/public function fetchOne(string $query, array $params = [], array $types = []){return $this->executeQuery($query, $params, $types)->fetchOne();}/*** Whether an actual connection to the database is established.*
public function __construct(private EntityManagerInterface $entityManager) {}public function getNumberOfEstablishments(): int{//try {return (int)$this->entityManager->getConnection()->fetchOne('SELECT COUNT(*) FROM erp');//} catch (Exception) {// return 0;//}}
class IndexController extends AbstractController{#[Route('/', name: 'homepage')]public function index(ErpHelper $erpHelper): Response{dump($erpHelper->getNumberOfEstablishments());return $this->render('index.html.twig', ['nbEstablishments' => $erpHelper->getNumberOfEstablishments()]);}}
in
vendor/symfony/http-kernel/HttpKernel.php
->
index
(line 195)
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);$controller = $event->getController();$arguments = $event->getArguments();// call controller$response = $controller(...$arguments);// viewif (!$response instanceof Response) {$event = new ViewEvent($this, $request, $type, $response, $event);$this->dispatcher->dispatch($event, KernelEvents::VIEW);
in
vendor/symfony/http-kernel/HttpKernel.php
->
handleRaw
(line 77)
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());$this->requestStack->push($request);$response = null;try {return $response = $this->handleRaw($request, $type);} catch (\Throwable $e) {if ($e instanceof \Error && !$this->handleAllThrowables) {throw $e;}
in
vendor/symfony/http-kernel/Kernel.php
->
handle
(line 205)
if (!$this->handlingHttpCache) {$this->resetServices = true;}try {return $this->getHttpKernel()->handle($request, $type, $catch);} finally {--$this->requestStackSize;}}
in
vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php
->
handle
(line 34)
) {}public function run(): int{$response = $this->kernel->handle($this->request);$response->send(false);if (\function_exists('fastcgi_finish_request') && !$this->debug) {fastcgi_finish_request();
in
vendor/autoload_runtime.php
->
run
(line 32)
$app = $app(...$args);exit($runtime->getRunner($app)->run());
<?phpuse App\Kernel;require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return function (array $context) {return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);};
Logs
| Level | Message |
|---|---|
| info 21:14:30 |
Matched route "_profiler". {
"route": "_profiler",
"route_parameters": {
"_route": "_profiler",
"_controller": "web_profiler.controller.profiler::panelAction",
"token": "latest"
},
"request_uri": "https://mail.mobility-app.fr/_profiler/latest?type=request",
"method": "GET"
}
|
| debug 21:14:30 |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
|
| debug 21:14:30 |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
|
| debug 21:14:30 |
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 21:14:30 |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
|
| debug 21:14:30 |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
|
| debug 21:14:30 |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
|
| debug 21:14:30 |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
|
| debug 21:14:30 |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
|
| debug 21:14:30 |
Notified event "kernel.request" to listener "App\EventSubscriber\ApiSignatureSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "App\\EventSubscriber\\ApiSignatureSubscriber::onKernelRequest"
}
|
| debug 21:14:30 |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". {
"event": "kernel.request",
"listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
|
| debug 21:14:30 |
Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". {
"event": "kernel.request",
"listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
|
| debug 21:14:30 |
Notified event "kernel.request" to listener "App\EventSubscriber\ApiRateLimitSubscriber::onKernelRequest". {
"event": "kernel.request",
"listener": "App\\EventSubscriber\\ApiRateLimitSubscriber::onKernelRequest"
}
|
| debug 21:14:30 |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". {
"event": "kernel.controller",
"listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
|
| debug 21:14:30 |
Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". {
"event": "kernel.controller",
"listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
|
| debug 21:14:30 |
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 21:14:30 |
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 21:14:30 |
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 21:14:30 |
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 21:14:30 |
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]
TableNotFoundException
|
|---|
Doctrine\DBAL\Exception\TableNotFoundException:
An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'saje9286_mobility_app.erp' doesn't exist
at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:51
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/dbal/src/Connection.php:627)
at Doctrine\DBAL\Connection->fetchOne()
(src/Helper/ErpHelper.php:15)
at App\Helper\ErpHelper->getNumberOfEstablishments()
(src/Controller/IndexController.php:15)
at App\Controller\IndexController->index()
(vendor/symfony/http-kernel/HttpKernel.php:195)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
(vendor/symfony/http-kernel/HttpKernel.php:77)
at Symfony\Component\HttpKernel\HttpKernel->handle()
(vendor/symfony/http-kernel/Kernel.php:205)
at Symfony\Component\HttpKernel\Kernel->handle()
(vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:34)
at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
(vendor/autoload_runtime.php:32)
at require_once('/home/saje9286/vendor/autoload_runtime.php')
(public/index.php:5)
|
|
[2/3]
Exception
|
|---|
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'saje9286_mobility_app.erp' doesn't exist
at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24
at Doctrine\DBAL\Driver\PDO\Exception::new()
(vendor/doctrine/dbal/src/Driver/PDO/Connection.php:76)
at Doctrine\DBAL\Driver\PDO\Connection->query()
(vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:33)
at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query()
(vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Connection.php:58)
at Symfony\Bridge\Doctrine\Middleware\Debug\DBAL3\Connection->query()
(vendor/doctrine/dbal/src/Connection.php:1106)
at Doctrine\DBAL\Connection->executeQuery()
(vendor/doctrine/dbal/src/Connection.php:627)
at Doctrine\DBAL\Connection->fetchOne()
(src/Helper/ErpHelper.php:15)
at App\Helper\ErpHelper->getNumberOfEstablishments()
(src/Controller/IndexController.php:15)
at App\Controller\IndexController->index()
(vendor/symfony/http-kernel/HttpKernel.php:195)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
(vendor/symfony/http-kernel/HttpKernel.php:77)
at Symfony\Component\HttpKernel\HttpKernel->handle()
(vendor/symfony/http-kernel/Kernel.php:205)
at Symfony\Component\HttpKernel\Kernel->handle()
(vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:34)
at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
(vendor/autoload_runtime.php:32)
at require_once('/home/saje9286/vendor/autoload_runtime.php')
(public/index.php:5)
|
|
[1/3]
PDOException
|
|---|
PDOException:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'saje9286_mobility_app.erp' doesn't exist
at vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71
at PDO->query()
(vendor/doctrine/dbal/src/Driver/PDO/Connection.php:71)
at Doctrine\DBAL\Driver\PDO\Connection->query()
(vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:33)
at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->query()
(vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Connection.php:58)
at Symfony\Bridge\Doctrine\Middleware\Debug\DBAL3\Connection->query()
(vendor/doctrine/dbal/src/Connection.php:1106)
at Doctrine\DBAL\Connection->executeQuery()
(vendor/doctrine/dbal/src/Connection.php:627)
at Doctrine\DBAL\Connection->fetchOne()
(src/Helper/ErpHelper.php:15)
at App\Helper\ErpHelper->getNumberOfEstablishments()
(src/Controller/IndexController.php:15)
at App\Controller\IndexController->index()
(vendor/symfony/http-kernel/HttpKernel.php:195)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
(vendor/symfony/http-kernel/HttpKernel.php:77)
at Symfony\Component\HttpKernel\HttpKernel->handle()
(vendor/symfony/http-kernel/Kernel.php:205)
at Symfony\Component\HttpKernel\Kernel->handle()
(vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:34)
at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
(vendor/autoload_runtime.php:32)
at require_once('/home/saje9286/vendor/autoload_runtime.php')
(public/index.php:5)
|