Error 500 Internal Server Error

GET https://base.aproximite.fr/

Exceptions

An exception has been thrown during the rendering of a template ("An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.urlphoto' in 'SELECT'") in default/homepage.html.twig at line 13.

Exceptions 4

Twig\Error\ RuntimeError

Show exception properties
Twig\Error\RuntimeError {#3010
  -lineno: 13
  -rawMessage: "An exception has been thrown during the rendering of a template ("An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.urlphoto' in 'SELECT'")."
  -source: Twig\Source {#3014
    -code: """
      {# templates/default/homepage.html.twig #}\n
      {# homepage appelée par défaut par le fichier route dand le repoertoire config #}\n
      {% extends 'base.html.twig' %}\n
       {# the homepage is a special page which displays neither a header nor\n
      a footer. this is done with the 'trick' of defining empty Twig blocks without any content #}\n
      {% block entete %} {% set habilitation, vue = "","homepage" %}{% include 'entete.html.twig'\n
      %}{# pour la clarté des, la igne identique entete est mis dans un fichier à part, elle appelle les variables habilitations\n
      et vue #}{% endblock %}\n
      {% block body %}\n
      {% if not page is defined %}\n
          {% set page = 1 %}\n
      {% endif %}\n
      {{ render(controller("App\\Controller\\DefaultController::accueil",{'page':page}))}}\n
      {% endblock %}\n
      """
    -name: "default/homepage.html.twig"
    -path: "/var/www/sites/base/templates/default/homepage.html.twig"
  }
  -phpFile: "/var/www/sites/base/vendor/twig/twig/src/Template.php"
  -phpLine: 460
}
  1. et vue #}{% endblock %}
  2. {% block body %}
  3. {% if not page is defined %}
  4. {% set page = 1 %}
  5. {% endif %}
  6. {{ render(controller("App\\Controller\\DefaultController::accueil",{'page':page}))}}
  7. {% endblock %}
  1. yield from $this->unwrap()->yieldBlock('flashmessage', $context, $blocks);
  2. // line 83
  3. yield " </div>";
  4. // line 84
  5. yield " ";
  6. yield from $this->unwrap()->yieldBlock('body', $context, $blocks);
  7. // line 88
  8. yield " <div id=\"pieddepage\" class=\"row\">
  9. <div class=\"col\" style=\"text-align: center;\">
  10. <hr style=\"border-top:1px solid\">
  11. <a href=\"";
in vendor/twig/twig/src/Template.php -> doDisplay (line 402)
  1. {
  2. $context += $this->env->getGlobals();
  3. $blocks = array_merge($this->blocks, $blocks);
  4. try {
  5. yield from $this->doDisplay($context, $blocks);
  6. } catch (Error $e) {
  7. if (!$e->getSourceContext()) {
  8. $e->setSourceContext($this->getSourceContext());
  9. }
  1. $__internal_6f47bbe9983af81f1e7450e9a3e3768f = $this->extensions["Symfony\\Bridge\\Twig\\Extension\\ProfilerExtension"];
  2. $__internal_6f47bbe9983af81f1e7450e9a3e3768f->enter($__internal_6f47bbe9983af81f1e7450e9a3e3768f_prof = new \Twig\Profiler\Profile($this->getTemplateName(), "template", "default/homepage.html.twig"));
  3. $this->parent = $this->load("base.html.twig", 3);
  4. yield from $this->parent->unwrap()->yield($context, array_merge($this->blocks, $blocks));
  5. $__internal_5a27a8ba21ca79b61932376b2fa922d2->leave($__internal_5a27a8ba21ca79b61932376b2fa922d2_prof);
  6. $__internal_6f47bbe9983af81f1e7450e9a3e3768f->leave($__internal_6f47bbe9983af81f1e7450e9a3e3768f_prof);
in vendor/twig/twig/src/Template.php -> doDisplay (line 402)
  1. {
  2. $context += $this->env->getGlobals();
  3. $blocks = array_merge($this->blocks, $blocks);
  4. try {
  5. yield from $this->doDisplay($context, $blocks);
  6. } catch (Error $e) {
  7. if (!$e->getSourceContext()) {
  8. $e->setSourceContext($this->getSourceContext());
  9. }
  1. return $this->blocks;
  2. }
  3. public function display(array $context, array $blocks = []): void
  4. {
  5. foreach ($this->yield($context, $blocks) as $data) {
  6. echo $data;
  7. }
  8. }
  9. public function render(array $context): string
in vendor/twig/twig/src/Template.php -> display (line 373)
  1. ob_start();
  2. } else {
  3. ob_start(function () { return ''; });
  4. }
  5. try {
  6. $this->display($context);
  7. } catch (\Throwable $e) {
  8. while (ob_get_level() > $level) {
  9. ob_end_clean();
  10. }
  1. yield from $this->template->yieldBlock($name, $context);
  2. }
  3. public function render(array $context = []): string
  4. {
  5. return $this->template->render($context);
  6. }
  7. /**
  8. * @return void
  9. */
  1. * @throws SyntaxError When an error occurred during compilation
  2. * @throws RuntimeError When an error occurred during rendering
  3. */
  4. public function render($name, array $context = []): string
  5. {
  6. return $this->load($name)->render($context);
  7. }
  8. /**
  9. * Displays a template.
  10. *
  1. if (null !== $block) {
  2. return $this->container->get('twig')->load($view)->renderBlock($block, $parameters);
  3. }
  4. return $this->container->get('twig')->render($view, $parameters);
  5. }
  6. private function doRender(string $view, ?string $block, array $parameters, ?Response $response, string $method): Response
  7. {
  8. $content = $this->doRenderView($view, $block, $parameters, $method);
  1. return $this->container->get('twig')->render($view, $parameters);
  2. }
  3. private function doRender(string $view, ?string $block, array $parameters, ?Response $response, string $method): Response
  4. {
  5. $content = $this->doRenderView($view, $block, $parameters, $method);
  6. $response ??= new Response();
  7. if (200 === $response->getStatusCode()) {
  8. foreach ($parameters as $v) {
  9. if ($v instanceof FormInterface && $v->isSubmitted() && !$v->isValid()) {
  1. * If an invalid form is found in the list of parameters, a 422 status code is returned.
  2. * Forms found in parameters are auto-cast to form views.
  3. */
  4. protected function render(string $view, array $parameters = [], ?Response $response = null): Response
  5. {
  6. return $this->doRender($view, null, $parameters, $response, __FUNCTION__);
  7. }
  8. /**
  9. * Renders a block in a view.
  10. *
AbstractController->render() in src/Controller/DefaultController.php (line 37)
  1. */
  2. #[Route(path: '/', name: 'homepage')]
  3. public function Homepage()
  4. {
  5. $vue = 'default/homepage.html.twig';
  6. return $this->render($vue);
  7. }
  8. #[Route(path: '/entete', name: 'entete')]
  9. public function entete(ManagerRegistry $doctrine, AuthorizationCheckerInterface $authChecker, TranslatorInterface $translator, $route, $routeparams)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  4. // call controller
  5. $response = $controller(...$arguments);
  6. // view
  7. if (!$response instanceof Response) {
  8. $event = new ViewEvent($this, $request, $type, $response, $event);
  9. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  2. $this->requestStack->push($request);
  3. $response = null;
  4. try {
  5. return $response = $this->handleRaw($request, $type);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  4. try {
  5. return $this->getHttpKernel()->handle($request, $type, $catch);
  6. } finally {
  7. --$this->requestStackSize;
  8. }
  9. }
Kernel->handle() in public/index.php (line 37)
  1. Request::setTrustedHosts(explode(',', $trustedHosts));
  2. }
  3. $kernel = new Kernel($env, $debug);
  4. $request = Request::createFromGlobals();
  5. $response = $kernel->handle($request);
  6. $response->send();
  7. $kernel->terminate($request, $response);

Doctrine\DBAL\Exception\ InvalidFieldNameException

An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.urlphoto' in 'SELECT'

  1. 1557,
  2. 1569,
  3. 1586 => new UniqueConstraintViolationException($exception, $query),
  4. 1054,
  5. 1166,
  6. 1611 => new InvalidFieldNameException($exception, $query),
  7. 1052,
  8. 1060,
  9. 1110 => new NonUniqueFieldNameException($exception, $query),
  10. 1064,
  11. 1149,
  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);
  7. if ($exception instanceof ConnectionLost) {
  8. $this->close();
  9. }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1396)
  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. }
  8. /** @internal */
  9. final public function convertException(Driver\Exception $e): DriverException
  10. {
in vendor/doctrine/dbal/src/Connection.php -> convertExceptionDuringQuery (line 809)
  1. $result = $connection->query($sql);
  2. }
  3. return new Result($result, $this);
  4. } catch (Driver\Exception $e) {
  5. throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
  6. }
  7. }
  8. /**
  9. * Executes a caching query.
  1. ): array {
  2. $this->switchPersisterContext($offset, $limit);
  3. $sql = $this->getSelectSQL($criteria, null, null, $limit, $offset, $orderBy);
  4. [$params, $types] = $this->expandParameters($criteria);
  5. $stmt = $this->conn->executeQuery($sql, $params, $types);
  6. $hydrator = $this->em->newHydrator($this->currentPersisterContext->selectJoinSql ? Query::HYDRATE_OBJECT : Query::HYDRATE_SIMPLEOBJECT);
  7. return $hydrator->hydrateAll($stmt, $this->currentPersisterContext->rsm, [UnitOfWork::HINT_DEFEREAGERLOAD => true]);
  8. }
  1. */
  2. public function findBy(array $criteria, array|null $orderBy = null, int|null $limit = null, int|null $offset = null): array
  3. {
  4. $persister = $this->em->getUnitOfWork()->getEntityPersister($this->entityName);
  5. return $persister->loadAll($criteria, $orderBy, $limit, $offset);
  6. }
  7. /**
  8. * Finds a single entity by a set of criteria.
  9. *
  1. $fieldName,
  2. $method . $by,
  3. );
  4. }
  5. return $this->$method([$fieldName => $arguments[0]], ...array_slice($arguments, 1));
  6. }
  7. }
in vendor/doctrine/orm/src/EntityRepository.php -> resolveMagicCall (line 154)
  1. * @throws BadMethodCallException If the method called is invalid.
  2. */
  3. public function __call(string $method, array $arguments): mixed
  4. {
  5. if (str_starts_with($method, 'findBy')) {
  6. return $this->resolveMagicCall('findBy', substr($method, 6), $arguments);
  7. }
  8. if (str_starts_with($method, 'findOneBy')) {
  9. return $this->resolveMagicCall('findOneBy', substr($method, 9), $arguments);
  10. }
EntityRepository->__call() in src/Controller/DefaultController.php (line 341)
  1. } else {
  2. $titre = "Hello, dear";
  3. }
  4. $em = $doctrine->getManager();
  5. $parametres = $em->getRepository('App\Entity\Parametres')->findOneByActif(true);
  6. $produits = $em->getRepository('App\Entity\Produits')->findByDiapoproduits(true);
  7. //*************** INITIALISATION des diaporamas ***************************
  8. $diaporamasite = array();
  9. for ($i = 0; $i < $parametres->getNbdiapos(); $i++) {
  10. $j = $i + 1;
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  4. // call controller
  5. $response = $controller(...$arguments);
  6. // view
  7. if (!$response instanceof Response) {
  8. $event = new ViewEvent($this, $request, $type, $response, $event);
  9. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  2. $this->requestStack->push($request);
  3. $response = null;
  4. try {
  5. return $response = $this->handleRaw($request, $type);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  1. if (!IpUtils::checkIp('127.0.0.1', $trustedProxies)) {
  2. Request::setTrustedProxies(array_merge($trustedProxies, ['127.0.0.1']), Request::getTrustedHeaderSet());
  3. }
  4. try {
  5. return $kernel->handle($request, $type, $catch);
  6. } finally {
  7. // restore global state
  8. Request::setTrustedProxies($trustedProxies, $trustedHeaderSet);
  9. }
  10. }
  1. $subRequest->attributes->add($reference->attributes);
  2. }
  3. $level = ob_get_level();
  4. try {
  5. return SubRequestHandler::handle($this->kernel, $subRequest, HttpKernelInterface::SUB_REQUEST, false);
  6. } catch (\Exception $e) {
  7. // we dispatch the exception event to trigger the logging
  8. // the response that comes back is ignored
  9. if (isset($options['ignore_errors']) && $options['ignore_errors'] && $this->dispatcher) {
  10. $event = new ExceptionEvent($this->kernel, $request, HttpKernelInterface::SUB_REQUEST, $e);
  1. if (!$request = $this->requestStack->getCurrentRequest()) {
  2. throw new \LogicException('Rendering a fragment can only be done when handling a Request.');
  3. }
  4. return $this->deliver($this->renderers[$renderer]->render($uri, $request, $options));
  5. }
  6. /**
  7. * Delivers the Response as a string.
  8. *
  1. if (!isset($this->initialized[$renderer]) && $this->container->has($renderer)) {
  2. $this->addRenderer($this->container->get($renderer));
  3. $this->initialized[$renderer] = true;
  4. }
  5. return parent::render($uri, $renderer, $options);
  6. }
  7. }
  1. public function renderFragment(string|ControllerReference $uri, array $options = []): string
  2. {
  3. $strategy = $options['strategy'] ?? 'inline';
  4. unset($options['strategy']);
  5. return $this->handler->render($uri, $strategy, $options);
  6. }
  7. /**
  8. * Renders a fragment.
  9. *
  1. // line 11
  2. yield " ";
  3. $context["page"] = 1;
  4. }
  5. // line 13
  6. yield $this->env->getRuntime('Symfony\Bridge\Twig\Extension\HttpKernelRuntime')->renderFragment(Symfony\Bridge\Twig\Extension\HttpKernelExtension::controller("App\\Controller\\DefaultController::accueil", ["page" => (isset($context["page"]) || array_key_exists("page", $context) ? $context["page"] : (function () { throw new RuntimeError('Variable "page" does not exist.', 13, $this->source); })())]));
  7. yield "
  8. ";
  9. $__internal_6f47bbe9983af81f1e7450e9a3e3768f->leave($__internal_6f47bbe9983af81f1e7450e9a3e3768f_prof);
in vendor/twig/twig/src/Template.php -> block_body (line 446)
  1. throw new \LogicException('A block must be a method on a \Twig\Template instance.');
  2. }
  3. if (null !== $template) {
  4. try {
  5. yield from $template->$block($context, $blocks);
  6. } catch (Error $e) {
  7. if (!$e->getSourceContext()) {
  8. $e->setSourceContext($template->getSourceContext());
  9. }
  1. yield from $this->unwrap()->yieldBlock('flashmessage', $context, $blocks);
  2. // line 83
  3. yield " </div>";
  4. // line 84
  5. yield " ";
  6. yield from $this->unwrap()->yieldBlock('body', $context, $blocks);
  7. // line 88
  8. yield " <div id=\"pieddepage\" class=\"row\">
  9. <div class=\"col\" style=\"text-align: center;\">
  10. <hr style=\"border-top:1px solid\">
  11. <a href=\"";
in vendor/twig/twig/src/Template.php -> doDisplay (line 402)
  1. {
  2. $context += $this->env->getGlobals();
  3. $blocks = array_merge($this->blocks, $blocks);
  4. try {
  5. yield from $this->doDisplay($context, $blocks);
  6. } catch (Error $e) {
  7. if (!$e->getSourceContext()) {
  8. $e->setSourceContext($this->getSourceContext());
  9. }
  1. $__internal_6f47bbe9983af81f1e7450e9a3e3768f = $this->extensions["Symfony\\Bridge\\Twig\\Extension\\ProfilerExtension"];
  2. $__internal_6f47bbe9983af81f1e7450e9a3e3768f->enter($__internal_6f47bbe9983af81f1e7450e9a3e3768f_prof = new \Twig\Profiler\Profile($this->getTemplateName(), "template", "default/homepage.html.twig"));
  3. $this->parent = $this->load("base.html.twig", 3);
  4. yield from $this->parent->unwrap()->yield($context, array_merge($this->blocks, $blocks));
  5. $__internal_5a27a8ba21ca79b61932376b2fa922d2->leave($__internal_5a27a8ba21ca79b61932376b2fa922d2_prof);
  6. $__internal_6f47bbe9983af81f1e7450e9a3e3768f->leave($__internal_6f47bbe9983af81f1e7450e9a3e3768f_prof);
in vendor/twig/twig/src/Template.php -> doDisplay (line 402)
  1. {
  2. $context += $this->env->getGlobals();
  3. $blocks = array_merge($this->blocks, $blocks);
  4. try {
  5. yield from $this->doDisplay($context, $blocks);
  6. } catch (Error $e) {
  7. if (!$e->getSourceContext()) {
  8. $e->setSourceContext($this->getSourceContext());
  9. }
  1. return $this->blocks;
  2. }
  3. public function display(array $context, array $blocks = []): void
  4. {
  5. foreach ($this->yield($context, $blocks) as $data) {
  6. echo $data;
  7. }
  8. }
  9. public function render(array $context): string
in vendor/twig/twig/src/Template.php -> display (line 373)
  1. ob_start();
  2. } else {
  3. ob_start(function () { return ''; });
  4. }
  5. try {
  6. $this->display($context);
  7. } catch (\Throwable $e) {
  8. while (ob_get_level() > $level) {
  9. ob_end_clean();
  10. }
  1. yield from $this->template->yieldBlock($name, $context);
  2. }
  3. public function render(array $context = []): string
  4. {
  5. return $this->template->render($context);
  6. }
  7. /**
  8. * @return void
  9. */
  1. * @throws SyntaxError When an error occurred during compilation
  2. * @throws RuntimeError When an error occurred during rendering
  3. */
  4. public function render($name, array $context = []): string
  5. {
  6. return $this->load($name)->render($context);
  7. }
  8. /**
  9. * Displays a template.
  10. *
  1. if (null !== $block) {
  2. return $this->container->get('twig')->load($view)->renderBlock($block, $parameters);
  3. }
  4. return $this->container->get('twig')->render($view, $parameters);
  5. }
  6. private function doRender(string $view, ?string $block, array $parameters, ?Response $response, string $method): Response
  7. {
  8. $content = $this->doRenderView($view, $block, $parameters, $method);
  1. return $this->container->get('twig')->render($view, $parameters);
  2. }
  3. private function doRender(string $view, ?string $block, array $parameters, ?Response $response, string $method): Response
  4. {
  5. $content = $this->doRenderView($view, $block, $parameters, $method);
  6. $response ??= new Response();
  7. if (200 === $response->getStatusCode()) {
  8. foreach ($parameters as $v) {
  9. if ($v instanceof FormInterface && $v->isSubmitted() && !$v->isValid()) {
  1. * If an invalid form is found in the list of parameters, a 422 status code is returned.
  2. * Forms found in parameters are auto-cast to form views.
  3. */
  4. protected function render(string $view, array $parameters = [], ?Response $response = null): Response
  5. {
  6. return $this->doRender($view, null, $parameters, $response, __FUNCTION__);
  7. }
  8. /**
  9. * Renders a block in a view.
  10. *
AbstractController->render() in src/Controller/DefaultController.php (line 37)
  1. */
  2. #[Route(path: '/', name: 'homepage')]
  3. public function Homepage()
  4. {
  5. $vue = 'default/homepage.html.twig';
  6. return $this->render($vue);
  7. }
  8. #[Route(path: '/entete', name: 'entete')]
  9. public function entete(ManagerRegistry $doctrine, AuthorizationCheckerInterface $authChecker, TranslatorInterface $translator, $route, $routeparams)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  4. // call controller
  5. $response = $controller(...$arguments);
  6. // view
  7. if (!$response instanceof Response) {
  8. $event = new ViewEvent($this, $request, $type, $response, $event);
  9. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  2. $this->requestStack->push($request);
  3. $response = null;
  4. try {
  5. return $response = $this->handleRaw($request, $type);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  4. try {
  5. return $this->getHttpKernel()->handle($request, $type, $catch);
  6. } finally {
  7. --$this->requestStackSize;
  8. }
  9. }
Kernel->handle() in public/index.php (line 37)
  1. Request::setTrustedHosts(explode(',', $trustedHosts));
  2. }
  3. $kernel = new Kernel($env, $debug);
  4. $request = Request::createFromGlobals();
  5. $response = $kernel->handle($request);
  6. $response->send();
  7. $kernel->terminate($request, $response);

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.urlphoto' in 'SELECT'

  1. } else {
  2. $code = $exception->getCode();
  3. $sqlState = null;
  4. }
  5. return new self($exception->getMessage(), $sqlState, $code, $exception);
  6. }
  7. }
  1. public function execute(): Result
  2. {
  3. try {
  4. $this->stmt->execute();
  5. } catch (PDOException $exception) {
  6. throw Exception::new($exception);
  7. }
  8. return new Result($this->stmt);
  9. }
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  3. public function execute(): Result
  4. {
  5. return $this->wrappedStatement->execute();
  6. }
  7. }
  1. 'sql' => $this->sql,
  2. 'params' => $this->params,
  3. 'types' => $this->types,
  4. ]);
  5. return parent::execute();
  6. }
  7. }
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  3. public function execute(): Result
  4. {
  5. return $this->wrappedStatement->execute();
  6. }
  7. }
  1. $this->stopwatch?->start('doctrine', 'doctrine');
  2. $query->start();
  3. try {
  4. return parent::execute();
  5. } finally {
  6. $query->stop();
  7. $this->stopwatch?->stop('doctrine');
  8. }
  9. }
  1. $stmt = $connection->prepare($sql);
  2. $this->bindParameters($stmt, $params, $types);
  3. $result = $stmt->execute();
  4. } else {
  5. $result = $connection->query($sql);
  6. }
  7. return new Result($result, $this);
  1. ): array {
  2. $this->switchPersisterContext($offset, $limit);
  3. $sql = $this->getSelectSQL($criteria, null, null, $limit, $offset, $orderBy);
  4. [$params, $types] = $this->expandParameters($criteria);
  5. $stmt = $this->conn->executeQuery($sql, $params, $types);
  6. $hydrator = $this->em->newHydrator($this->currentPersisterContext->selectJoinSql ? Query::HYDRATE_OBJECT : Query::HYDRATE_SIMPLEOBJECT);
  7. return $hydrator->hydrateAll($stmt, $this->currentPersisterContext->rsm, [UnitOfWork::HINT_DEFEREAGERLOAD => true]);
  8. }
  1. */
  2. public function findBy(array $criteria, array|null $orderBy = null, int|null $limit = null, int|null $offset = null): array
  3. {
  4. $persister = $this->em->getUnitOfWork()->getEntityPersister($this->entityName);
  5. return $persister->loadAll($criteria, $orderBy, $limit, $offset);
  6. }
  7. /**
  8. * Finds a single entity by a set of criteria.
  9. *
  1. $fieldName,
  2. $method . $by,
  3. );
  4. }
  5. return $this->$method([$fieldName => $arguments[0]], ...array_slice($arguments, 1));
  6. }
  7. }
in vendor/doctrine/orm/src/EntityRepository.php -> resolveMagicCall (line 154)
  1. * @throws BadMethodCallException If the method called is invalid.
  2. */
  3. public function __call(string $method, array $arguments): mixed
  4. {
  5. if (str_starts_with($method, 'findBy')) {
  6. return $this->resolveMagicCall('findBy', substr($method, 6), $arguments);
  7. }
  8. if (str_starts_with($method, 'findOneBy')) {
  9. return $this->resolveMagicCall('findOneBy', substr($method, 9), $arguments);
  10. }
EntityRepository->__call() in src/Controller/DefaultController.php (line 341)
  1. } else {
  2. $titre = "Hello, dear";
  3. }
  4. $em = $doctrine->getManager();
  5. $parametres = $em->getRepository('App\Entity\Parametres')->findOneByActif(true);
  6. $produits = $em->getRepository('App\Entity\Produits')->findByDiapoproduits(true);
  7. //*************** INITIALISATION des diaporamas ***************************
  8. $diaporamasite = array();
  9. for ($i = 0; $i < $parametres->getNbdiapos(); $i++) {
  10. $j = $i + 1;
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  4. // call controller
  5. $response = $controller(...$arguments);
  6. // view
  7. if (!$response instanceof Response) {
  8. $event = new ViewEvent($this, $request, $type, $response, $event);
  9. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  2. $this->requestStack->push($request);
  3. $response = null;
  4. try {
  5. return $response = $this->handleRaw($request, $type);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  1. if (!IpUtils::checkIp('127.0.0.1', $trustedProxies)) {
  2. Request::setTrustedProxies(array_merge($trustedProxies, ['127.0.0.1']), Request::getTrustedHeaderSet());
  3. }
  4. try {
  5. return $kernel->handle($request, $type, $catch);
  6. } finally {
  7. // restore global state
  8. Request::setTrustedProxies($trustedProxies, $trustedHeaderSet);
  9. }
  10. }
  1. $subRequest->attributes->add($reference->attributes);
  2. }
  3. $level = ob_get_level();
  4. try {
  5. return SubRequestHandler::handle($this->kernel, $subRequest, HttpKernelInterface::SUB_REQUEST, false);
  6. } catch (\Exception $e) {
  7. // we dispatch the exception event to trigger the logging
  8. // the response that comes back is ignored
  9. if (isset($options['ignore_errors']) && $options['ignore_errors'] && $this->dispatcher) {
  10. $event = new ExceptionEvent($this->kernel, $request, HttpKernelInterface::SUB_REQUEST, $e);
  1. if (!$request = $this->requestStack->getCurrentRequest()) {
  2. throw new \LogicException('Rendering a fragment can only be done when handling a Request.');
  3. }
  4. return $this->deliver($this->renderers[$renderer]->render($uri, $request, $options));
  5. }
  6. /**
  7. * Delivers the Response as a string.
  8. *
  1. if (!isset($this->initialized[$renderer]) && $this->container->has($renderer)) {
  2. $this->addRenderer($this->container->get($renderer));
  3. $this->initialized[$renderer] = true;
  4. }
  5. return parent::render($uri, $renderer, $options);
  6. }
  7. }
  1. public function renderFragment(string|ControllerReference $uri, array $options = []): string
  2. {
  3. $strategy = $options['strategy'] ?? 'inline';
  4. unset($options['strategy']);
  5. return $this->handler->render($uri, $strategy, $options);
  6. }
  7. /**
  8. * Renders a fragment.
  9. *
  1. // line 11
  2. yield " ";
  3. $context["page"] = 1;
  4. }
  5. // line 13
  6. yield $this->env->getRuntime('Symfony\Bridge\Twig\Extension\HttpKernelRuntime')->renderFragment(Symfony\Bridge\Twig\Extension\HttpKernelExtension::controller("App\\Controller\\DefaultController::accueil", ["page" => (isset($context["page"]) || array_key_exists("page", $context) ? $context["page"] : (function () { throw new RuntimeError('Variable "page" does not exist.', 13, $this->source); })())]));
  7. yield "
  8. ";
  9. $__internal_6f47bbe9983af81f1e7450e9a3e3768f->leave($__internal_6f47bbe9983af81f1e7450e9a3e3768f_prof);
in vendor/twig/twig/src/Template.php -> block_body (line 446)
  1. throw new \LogicException('A block must be a method on a \Twig\Template instance.');
  2. }
  3. if (null !== $template) {
  4. try {
  5. yield from $template->$block($context, $blocks);
  6. } catch (Error $e) {
  7. if (!$e->getSourceContext()) {
  8. $e->setSourceContext($template->getSourceContext());
  9. }
  1. yield from $this->unwrap()->yieldBlock('flashmessage', $context, $blocks);
  2. // line 83
  3. yield " </div>";
  4. // line 84
  5. yield " ";
  6. yield from $this->unwrap()->yieldBlock('body', $context, $blocks);
  7. // line 88
  8. yield " <div id=\"pieddepage\" class=\"row\">
  9. <div class=\"col\" style=\"text-align: center;\">
  10. <hr style=\"border-top:1px solid\">
  11. <a href=\"";
in vendor/twig/twig/src/Template.php -> doDisplay (line 402)
  1. {
  2. $context += $this->env->getGlobals();
  3. $blocks = array_merge($this->blocks, $blocks);
  4. try {
  5. yield from $this->doDisplay($context, $blocks);
  6. } catch (Error $e) {
  7. if (!$e->getSourceContext()) {
  8. $e->setSourceContext($this->getSourceContext());
  9. }
  1. $__internal_6f47bbe9983af81f1e7450e9a3e3768f = $this->extensions["Symfony\\Bridge\\Twig\\Extension\\ProfilerExtension"];
  2. $__internal_6f47bbe9983af81f1e7450e9a3e3768f->enter($__internal_6f47bbe9983af81f1e7450e9a3e3768f_prof = new \Twig\Profiler\Profile($this->getTemplateName(), "template", "default/homepage.html.twig"));
  3. $this->parent = $this->load("base.html.twig", 3);
  4. yield from $this->parent->unwrap()->yield($context, array_merge($this->blocks, $blocks));
  5. $__internal_5a27a8ba21ca79b61932376b2fa922d2->leave($__internal_5a27a8ba21ca79b61932376b2fa922d2_prof);
  6. $__internal_6f47bbe9983af81f1e7450e9a3e3768f->leave($__internal_6f47bbe9983af81f1e7450e9a3e3768f_prof);
in vendor/twig/twig/src/Template.php -> doDisplay (line 402)
  1. {
  2. $context += $this->env->getGlobals();
  3. $blocks = array_merge($this->blocks, $blocks);
  4. try {
  5. yield from $this->doDisplay($context, $blocks);
  6. } catch (Error $e) {
  7. if (!$e->getSourceContext()) {
  8. $e->setSourceContext($this->getSourceContext());
  9. }
  1. return $this->blocks;
  2. }
  3. public function display(array $context, array $blocks = []): void
  4. {
  5. foreach ($this->yield($context, $blocks) as $data) {
  6. echo $data;
  7. }
  8. }
  9. public function render(array $context): string
in vendor/twig/twig/src/Template.php -> display (line 373)
  1. ob_start();
  2. } else {
  3. ob_start(function () { return ''; });
  4. }
  5. try {
  6. $this->display($context);
  7. } catch (\Throwable $e) {
  8. while (ob_get_level() > $level) {
  9. ob_end_clean();
  10. }
  1. yield from $this->template->yieldBlock($name, $context);
  2. }
  3. public function render(array $context = []): string
  4. {
  5. return $this->template->render($context);
  6. }
  7. /**
  8. * @return void
  9. */
  1. * @throws SyntaxError When an error occurred during compilation
  2. * @throws RuntimeError When an error occurred during rendering
  3. */
  4. public function render($name, array $context = []): string
  5. {
  6. return $this->load($name)->render($context);
  7. }
  8. /**
  9. * Displays a template.
  10. *
  1. if (null !== $block) {
  2. return $this->container->get('twig')->load($view)->renderBlock($block, $parameters);
  3. }
  4. return $this->container->get('twig')->render($view, $parameters);
  5. }
  6. private function doRender(string $view, ?string $block, array $parameters, ?Response $response, string $method): Response
  7. {
  8. $content = $this->doRenderView($view, $block, $parameters, $method);
  1. return $this->container->get('twig')->render($view, $parameters);
  2. }
  3. private function doRender(string $view, ?string $block, array $parameters, ?Response $response, string $method): Response
  4. {
  5. $content = $this->doRenderView($view, $block, $parameters, $method);
  6. $response ??= new Response();
  7. if (200 === $response->getStatusCode()) {
  8. foreach ($parameters as $v) {
  9. if ($v instanceof FormInterface && $v->isSubmitted() && !$v->isValid()) {
  1. * If an invalid form is found in the list of parameters, a 422 status code is returned.
  2. * Forms found in parameters are auto-cast to form views.
  3. */
  4. protected function render(string $view, array $parameters = [], ?Response $response = null): Response
  5. {
  6. return $this->doRender($view, null, $parameters, $response, __FUNCTION__);
  7. }
  8. /**
  9. * Renders a block in a view.
  10. *
AbstractController->render() in src/Controller/DefaultController.php (line 37)
  1. */
  2. #[Route(path: '/', name: 'homepage')]
  3. public function Homepage()
  4. {
  5. $vue = 'default/homepage.html.twig';
  6. return $this->render($vue);
  7. }
  8. #[Route(path: '/entete', name: 'entete')]
  9. public function entete(ManagerRegistry $doctrine, AuthorizationCheckerInterface $authChecker, TranslatorInterface $translator, $route, $routeparams)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  4. // call controller
  5. $response = $controller(...$arguments);
  6. // view
  7. if (!$response instanceof Response) {
  8. $event = new ViewEvent($this, $request, $type, $response, $event);
  9. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  2. $this->requestStack->push($request);
  3. $response = null;
  4. try {
  5. return $response = $this->handleRaw($request, $type);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  4. try {
  5. return $this->getHttpKernel()->handle($request, $type, $catch);
  6. } finally {
  7. --$this->requestStackSize;
  8. }
  9. }
Kernel->handle() in public/index.php (line 37)
  1. Request::setTrustedHosts(explode(',', $trustedHosts));
  2. }
  3. $kernel = new Kernel($env, $debug);
  4. $request = Request::createFromGlobals();
  5. $response = $kernel->handle($request);
  6. $response->send();
  7. $kernel->terminate($request, $response);

PDOException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.urlphoto' in 'SELECT'

  1. }
  2. public function execute(): Result
  3. {
  4. try {
  5. $this->stmt->execute();
  6. } catch (PDOException $exception) {
  7. throw Exception::new($exception);
  8. }
  9. return new Result($this->stmt);
  1. }
  2. public function execute(): Result
  3. {
  4. try {
  5. $this->stmt->execute();
  6. } catch (PDOException $exception) {
  7. throw Exception::new($exception);
  8. }
  9. return new Result($this->stmt);
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  3. public function execute(): Result
  4. {
  5. return $this->wrappedStatement->execute();
  6. }
  7. }
  1. 'sql' => $this->sql,
  2. 'params' => $this->params,
  3. 'types' => $this->types,
  4. ]);
  5. return parent::execute();
  6. }
  7. }
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  3. public function execute(): Result
  4. {
  5. return $this->wrappedStatement->execute();
  6. }
  7. }
  1. $this->stopwatch?->start('doctrine', 'doctrine');
  2. $query->start();
  3. try {
  4. return parent::execute();
  5. } finally {
  6. $query->stop();
  7. $this->stopwatch?->stop('doctrine');
  8. }
  9. }
  1. $stmt = $connection->prepare($sql);
  2. $this->bindParameters($stmt, $params, $types);
  3. $result = $stmt->execute();
  4. } else {
  5. $result = $connection->query($sql);
  6. }
  7. return new Result($result, $this);
  1. ): array {
  2. $this->switchPersisterContext($offset, $limit);
  3. $sql = $this->getSelectSQL($criteria, null, null, $limit, $offset, $orderBy);
  4. [$params, $types] = $this->expandParameters($criteria);
  5. $stmt = $this->conn->executeQuery($sql, $params, $types);
  6. $hydrator = $this->em->newHydrator($this->currentPersisterContext->selectJoinSql ? Query::HYDRATE_OBJECT : Query::HYDRATE_SIMPLEOBJECT);
  7. return $hydrator->hydrateAll($stmt, $this->currentPersisterContext->rsm, [UnitOfWork::HINT_DEFEREAGERLOAD => true]);
  8. }
  1. */
  2. public function findBy(array $criteria, array|null $orderBy = null, int|null $limit = null, int|null $offset = null): array
  3. {
  4. $persister = $this->em->getUnitOfWork()->getEntityPersister($this->entityName);
  5. return $persister->loadAll($criteria, $orderBy, $limit, $offset);
  6. }
  7. /**
  8. * Finds a single entity by a set of criteria.
  9. *
  1. $fieldName,
  2. $method . $by,
  3. );
  4. }
  5. return $this->$method([$fieldName => $arguments[0]], ...array_slice($arguments, 1));
  6. }
  7. }
in vendor/doctrine/orm/src/EntityRepository.php -> resolveMagicCall (line 154)
  1. * @throws BadMethodCallException If the method called is invalid.
  2. */
  3. public function __call(string $method, array $arguments): mixed
  4. {
  5. if (str_starts_with($method, 'findBy')) {
  6. return $this->resolveMagicCall('findBy', substr($method, 6), $arguments);
  7. }
  8. if (str_starts_with($method, 'findOneBy')) {
  9. return $this->resolveMagicCall('findOneBy', substr($method, 9), $arguments);
  10. }
EntityRepository->__call() in src/Controller/DefaultController.php (line 341)
  1. } else {
  2. $titre = "Hello, dear";
  3. }
  4. $em = $doctrine->getManager();
  5. $parametres = $em->getRepository('App\Entity\Parametres')->findOneByActif(true);
  6. $produits = $em->getRepository('App\Entity\Produits')->findByDiapoproduits(true);
  7. //*************** INITIALISATION des diaporamas ***************************
  8. $diaporamasite = array();
  9. for ($i = 0; $i < $parametres->getNbdiapos(); $i++) {
  10. $j = $i + 1;
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  4. // call controller
  5. $response = $controller(...$arguments);
  6. // view
  7. if (!$response instanceof Response) {
  8. $event = new ViewEvent($this, $request, $type, $response, $event);
  9. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  2. $this->requestStack->push($request);
  3. $response = null;
  4. try {
  5. return $response = $this->handleRaw($request, $type);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  1. if (!IpUtils::checkIp('127.0.0.1', $trustedProxies)) {
  2. Request::setTrustedProxies(array_merge($trustedProxies, ['127.0.0.1']), Request::getTrustedHeaderSet());
  3. }
  4. try {
  5. return $kernel->handle($request, $type, $catch);
  6. } finally {
  7. // restore global state
  8. Request::setTrustedProxies($trustedProxies, $trustedHeaderSet);
  9. }
  10. }
  1. $subRequest->attributes->add($reference->attributes);
  2. }
  3. $level = ob_get_level();
  4. try {
  5. return SubRequestHandler::handle($this->kernel, $subRequest, HttpKernelInterface::SUB_REQUEST, false);
  6. } catch (\Exception $e) {
  7. // we dispatch the exception event to trigger the logging
  8. // the response that comes back is ignored
  9. if (isset($options['ignore_errors']) && $options['ignore_errors'] && $this->dispatcher) {
  10. $event = new ExceptionEvent($this->kernel, $request, HttpKernelInterface::SUB_REQUEST, $e);
  1. if (!$request = $this->requestStack->getCurrentRequest()) {
  2. throw new \LogicException('Rendering a fragment can only be done when handling a Request.');
  3. }
  4. return $this->deliver($this->renderers[$renderer]->render($uri, $request, $options));
  5. }
  6. /**
  7. * Delivers the Response as a string.
  8. *
  1. if (!isset($this->initialized[$renderer]) && $this->container->has($renderer)) {
  2. $this->addRenderer($this->container->get($renderer));
  3. $this->initialized[$renderer] = true;
  4. }
  5. return parent::render($uri, $renderer, $options);
  6. }
  7. }
  1. public function renderFragment(string|ControllerReference $uri, array $options = []): string
  2. {
  3. $strategy = $options['strategy'] ?? 'inline';
  4. unset($options['strategy']);
  5. return $this->handler->render($uri, $strategy, $options);
  6. }
  7. /**
  8. * Renders a fragment.
  9. *
  1. // line 11
  2. yield " ";
  3. $context["page"] = 1;
  4. }
  5. // line 13
  6. yield $this->env->getRuntime('Symfony\Bridge\Twig\Extension\HttpKernelRuntime')->renderFragment(Symfony\Bridge\Twig\Extension\HttpKernelExtension::controller("App\\Controller\\DefaultController::accueil", ["page" => (isset($context["page"]) || array_key_exists("page", $context) ? $context["page"] : (function () { throw new RuntimeError('Variable "page" does not exist.', 13, $this->source); })())]));
  7. yield "
  8. ";
  9. $__internal_6f47bbe9983af81f1e7450e9a3e3768f->leave($__internal_6f47bbe9983af81f1e7450e9a3e3768f_prof);
in vendor/twig/twig/src/Template.php -> block_body (line 446)
  1. throw new \LogicException('A block must be a method on a \Twig\Template instance.');
  2. }
  3. if (null !== $template) {
  4. try {
  5. yield from $template->$block($context, $blocks);
  6. } catch (Error $e) {
  7. if (!$e->getSourceContext()) {
  8. $e->setSourceContext($template->getSourceContext());
  9. }
  1. yield from $this->unwrap()->yieldBlock('flashmessage', $context, $blocks);
  2. // line 83
  3. yield " </div>";
  4. // line 84
  5. yield " ";
  6. yield from $this->unwrap()->yieldBlock('body', $context, $blocks);
  7. // line 88
  8. yield " <div id=\"pieddepage\" class=\"row\">
  9. <div class=\"col\" style=\"text-align: center;\">
  10. <hr style=\"border-top:1px solid\">
  11. <a href=\"";
in vendor/twig/twig/src/Template.php -> doDisplay (line 402)
  1. {
  2. $context += $this->env->getGlobals();
  3. $blocks = array_merge($this->blocks, $blocks);
  4. try {
  5. yield from $this->doDisplay($context, $blocks);
  6. } catch (Error $e) {
  7. if (!$e->getSourceContext()) {
  8. $e->setSourceContext($this->getSourceContext());
  9. }
  1. $__internal_6f47bbe9983af81f1e7450e9a3e3768f = $this->extensions["Symfony\\Bridge\\Twig\\Extension\\ProfilerExtension"];
  2. $__internal_6f47bbe9983af81f1e7450e9a3e3768f->enter($__internal_6f47bbe9983af81f1e7450e9a3e3768f_prof = new \Twig\Profiler\Profile($this->getTemplateName(), "template", "default/homepage.html.twig"));
  3. $this->parent = $this->load("base.html.twig", 3);
  4. yield from $this->parent->unwrap()->yield($context, array_merge($this->blocks, $blocks));
  5. $__internal_5a27a8ba21ca79b61932376b2fa922d2->leave($__internal_5a27a8ba21ca79b61932376b2fa922d2_prof);
  6. $__internal_6f47bbe9983af81f1e7450e9a3e3768f->leave($__internal_6f47bbe9983af81f1e7450e9a3e3768f_prof);
in vendor/twig/twig/src/Template.php -> doDisplay (line 402)
  1. {
  2. $context += $this->env->getGlobals();
  3. $blocks = array_merge($this->blocks, $blocks);
  4. try {
  5. yield from $this->doDisplay($context, $blocks);
  6. } catch (Error $e) {
  7. if (!$e->getSourceContext()) {
  8. $e->setSourceContext($this->getSourceContext());
  9. }
  1. return $this->blocks;
  2. }
  3. public function display(array $context, array $blocks = []): void
  4. {
  5. foreach ($this->yield($context, $blocks) as $data) {
  6. echo $data;
  7. }
  8. }
  9. public function render(array $context): string
in vendor/twig/twig/src/Template.php -> display (line 373)
  1. ob_start();
  2. } else {
  3. ob_start(function () { return ''; });
  4. }
  5. try {
  6. $this->display($context);
  7. } catch (\Throwable $e) {
  8. while (ob_get_level() > $level) {
  9. ob_end_clean();
  10. }
  1. yield from $this->template->yieldBlock($name, $context);
  2. }
  3. public function render(array $context = []): string
  4. {
  5. return $this->template->render($context);
  6. }
  7. /**
  8. * @return void
  9. */
  1. * @throws SyntaxError When an error occurred during compilation
  2. * @throws RuntimeError When an error occurred during rendering
  3. */
  4. public function render($name, array $context = []): string
  5. {
  6. return $this->load($name)->render($context);
  7. }
  8. /**
  9. * Displays a template.
  10. *
  1. if (null !== $block) {
  2. return $this->container->get('twig')->load($view)->renderBlock($block, $parameters);
  3. }
  4. return $this->container->get('twig')->render($view, $parameters);
  5. }
  6. private function doRender(string $view, ?string $block, array $parameters, ?Response $response, string $method): Response
  7. {
  8. $content = $this->doRenderView($view, $block, $parameters, $method);
  1. return $this->container->get('twig')->render($view, $parameters);
  2. }
  3. private function doRender(string $view, ?string $block, array $parameters, ?Response $response, string $method): Response
  4. {
  5. $content = $this->doRenderView($view, $block, $parameters, $method);
  6. $response ??= new Response();
  7. if (200 === $response->getStatusCode()) {
  8. foreach ($parameters as $v) {
  9. if ($v instanceof FormInterface && $v->isSubmitted() && !$v->isValid()) {
  1. * If an invalid form is found in the list of parameters, a 422 status code is returned.
  2. * Forms found in parameters are auto-cast to form views.
  3. */
  4. protected function render(string $view, array $parameters = [], ?Response $response = null): Response
  5. {
  6. return $this->doRender($view, null, $parameters, $response, __FUNCTION__);
  7. }
  8. /**
  9. * Renders a block in a view.
  10. *
AbstractController->render() in src/Controller/DefaultController.php (line 37)
  1. */
  2. #[Route(path: '/', name: 'homepage')]
  3. public function Homepage()
  4. {
  5. $vue = 'default/homepage.html.twig';
  6. return $this->render($vue);
  7. }
  8. #[Route(path: '/entete', name: 'entete')]
  9. public function entete(ManagerRegistry $doctrine, AuthorizationCheckerInterface $authChecker, TranslatorInterface $translator, $route, $routeparams)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  4. // call controller
  5. $response = $controller(...$arguments);
  6. // view
  7. if (!$response instanceof Response) {
  8. $event = new ViewEvent($this, $request, $type, $response, $event);
  9. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  2. $this->requestStack->push($request);
  3. $response = null;
  4. try {
  5. return $response = $this->handleRaw($request, $type);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  4. try {
  5. return $this->getHttpKernel()->handle($request, $type, $catch);
  6. } finally {
  7. --$this->requestStackSize;
  8. }
  9. }
Kernel->handle() in public/index.php (line 37)
  1. Request::setTrustedHosts(explode(',', $trustedHosts));
  2. }
  3. $kernel = new Kernel($env, $debug);
  4. $request = Request::createFromGlobals();
  5. $response = $kernel->handle($request);
  6. $response->send();
  7. $kernel->terminate($request, $response);

Logs

Level Channel Message
INFO 00:30:45 request Matched route "_profiler".
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "d9bf2c"
    },
    "request_uri": "https://www.base.aproximite.fr/_profiler/d9bf2c",
    "method": "GET"
}

Stack Traces 4

[4/4] RuntimeError
Twig\Error\RuntimeError:
An exception has been thrown during the rendering of a template ("An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.urlphoto' in 'SELECT'") in "default/homepage.html.twig" at line 13.

  at templates/default/homepage.html.twig:13
  at Twig\Template->yieldBlock()
     (var/cache/dev/twig/8c/8c42dcbb5dc01355c99afc695c8d8772.php:254)
  at __TwigTemplate_a0b1d5d5d38611de786fc92c8c7632ac->doDisplay()
     (vendor/twig/twig/src/Template.php:402)
  at Twig\Template->yield()
     (var/cache/dev/twig/17/17c3522d8af9b575f65159f4829ce3cf.php:54)
  at __TwigTemplate_020e859290cca9f5c893ef26e4580ba0->doDisplay()
     (vendor/twig/twig/src/Template.php:402)
  at Twig\Template->yield()
     (vendor/twig/twig/src/Template.php:358)
  at Twig\Template->display()
     (vendor/twig/twig/src/Template.php:373)
  at Twig\Template->render()
     (vendor/twig/twig/src/TemplateWrapper.php:51)
  at Twig\TemplateWrapper->render()
     (vendor/twig/twig/src/Environment.php:333)
  at Twig\Environment->render()
     (vendor/symfony/framework-bundle/Controller/AbstractController.php:462)
  at Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView()
     (vendor/symfony/framework-bundle/Controller/AbstractController.php:467)
  at Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender()
     (vendor/symfony/framework-bundle/Controller/AbstractController.php:279)
  at Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render()
     (src/Controller/DefaultController.php:37)
  at App\Controller\DefaultController->Homepage()
     (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:191)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:37)                
[3/4] InvalidFieldNameException
Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.urlphoto' in 'SELECT'

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:63
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1460)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1396)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Connection.php:809)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:963)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll()
     (vendor/doctrine/orm/src/EntityRepository.php:110)
  at Doctrine\ORM\EntityRepository->findBy()
     (vendor/doctrine/orm/src/EntityRepository.php:235)
  at Doctrine\ORM\EntityRepository->resolveMagicCall()
     (vendor/doctrine/orm/src/EntityRepository.php:154)
  at Doctrine\ORM\EntityRepository->__call()
     (src/Controller/DefaultController.php:341)
  at App\Controller\DefaultController->accueil()
     (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/HttpCache/SubRequestHandler.php:86)
  at Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
     (vendor/symfony/http-kernel/Fragment/InlineFragmentRenderer.php:75)
  at Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render()
     (vendor/symfony/http-kernel/Fragment/FragmentHandler.php:81)
  at Symfony\Component\HttpKernel\Fragment\FragmentHandler->render()
     (vendor/symfony/http-kernel/DependencyInjection/LazyLoadingFragmentHandler.php:46)
  at Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render()
     (vendor/symfony/twig-bridge/Extension/HttpKernelRuntime.php:41)
  at Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment()
     (var/cache/dev/twig/17/17c3522d8af9b575f65159f4829ce3cf.php:108)
  at __TwigTemplate_020e859290cca9f5c893ef26e4580ba0->block_body()
     (vendor/twig/twig/src/Template.php:446)
  at Twig\Template->yieldBlock()
     (var/cache/dev/twig/8c/8c42dcbb5dc01355c99afc695c8d8772.php:254)
  at __TwigTemplate_a0b1d5d5d38611de786fc92c8c7632ac->doDisplay()
     (vendor/twig/twig/src/Template.php:402)
  at Twig\Template->yield()
     (var/cache/dev/twig/17/17c3522d8af9b575f65159f4829ce3cf.php:54)
  at __TwigTemplate_020e859290cca9f5c893ef26e4580ba0->doDisplay()
     (vendor/twig/twig/src/Template.php:402)
  at Twig\Template->yield()
     (vendor/twig/twig/src/Template.php:358)
  at Twig\Template->display()
     (vendor/twig/twig/src/Template.php:373)
  at Twig\Template->render()
     (vendor/twig/twig/src/TemplateWrapper.php:51)
  at Twig\TemplateWrapper->render()
     (vendor/twig/twig/src/Environment.php:333)
  at Twig\Environment->render()
     (vendor/symfony/framework-bundle/Controller/AbstractController.php:462)
  at Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView()
     (vendor/symfony/framework-bundle/Controller/AbstractController.php:467)
  at Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender()
     (vendor/symfony/framework-bundle/Controller/AbstractController.php:279)
  at Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render()
     (src/Controller/DefaultController.php:37)
  at App\Controller\DefaultController->Homepage()
     (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:191)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:37)                
[2/4] Exception
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.urlphoto' in 'SELECT'

  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:57)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/doctrine/dbal/src/Logging/Statement.php:46)
  at Doctrine\DBAL\Logging\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php:58)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:802)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:963)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll()
     (vendor/doctrine/orm/src/EntityRepository.php:110)
  at Doctrine\ORM\EntityRepository->findBy()
     (vendor/doctrine/orm/src/EntityRepository.php:235)
  at Doctrine\ORM\EntityRepository->resolveMagicCall()
     (vendor/doctrine/orm/src/EntityRepository.php:154)
  at Doctrine\ORM\EntityRepository->__call()
     (src/Controller/DefaultController.php:341)
  at App\Controller\DefaultController->accueil()
     (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/HttpCache/SubRequestHandler.php:86)
  at Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
     (vendor/symfony/http-kernel/Fragment/InlineFragmentRenderer.php:75)
  at Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render()
     (vendor/symfony/http-kernel/Fragment/FragmentHandler.php:81)
  at Symfony\Component\HttpKernel\Fragment\FragmentHandler->render()
     (vendor/symfony/http-kernel/DependencyInjection/LazyLoadingFragmentHandler.php:46)
  at Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render()
     (vendor/symfony/twig-bridge/Extension/HttpKernelRuntime.php:41)
  at Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment()
     (var/cache/dev/twig/17/17c3522d8af9b575f65159f4829ce3cf.php:108)
  at __TwigTemplate_020e859290cca9f5c893ef26e4580ba0->block_body()
     (vendor/twig/twig/src/Template.php:446)
  at Twig\Template->yieldBlock()
     (var/cache/dev/twig/8c/8c42dcbb5dc01355c99afc695c8d8772.php:254)
  at __TwigTemplate_a0b1d5d5d38611de786fc92c8c7632ac->doDisplay()
     (vendor/twig/twig/src/Template.php:402)
  at Twig\Template->yield()
     (var/cache/dev/twig/17/17c3522d8af9b575f65159f4829ce3cf.php:54)
  at __TwigTemplate_020e859290cca9f5c893ef26e4580ba0->doDisplay()
     (vendor/twig/twig/src/Template.php:402)
  at Twig\Template->yield()
     (vendor/twig/twig/src/Template.php:358)
  at Twig\Template->display()
     (vendor/twig/twig/src/Template.php:373)
  at Twig\Template->render()
     (vendor/twig/twig/src/TemplateWrapper.php:51)
  at Twig\TemplateWrapper->render()
     (vendor/twig/twig/src/Environment.php:333)
  at Twig\Environment->render()
     (vendor/symfony/framework-bundle/Controller/AbstractController.php:462)
  at Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView()
     (vendor/symfony/framework-bundle/Controller/AbstractController.php:467)
  at Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender()
     (vendor/symfony/framework-bundle/Controller/AbstractController.php:279)
  at Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render()
     (src/Controller/DefaultController.php:37)
  at App\Controller\DefaultController->Homepage()
     (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:191)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:37)                
[1/4] PDOException
PDOException:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.urlphoto' in 'SELECT'

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:55
  at PDOStatement->execute()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:55)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/doctrine/dbal/src/Logging/Statement.php:46)
  at Doctrine\DBAL\Logging\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php:58)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:802)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/src/Persisters/Entity/BasicEntityPersister.php:963)
  at Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll()
     (vendor/doctrine/orm/src/EntityRepository.php:110)
  at Doctrine\ORM\EntityRepository->findBy()
     (vendor/doctrine/orm/src/EntityRepository.php:235)
  at Doctrine\ORM\EntityRepository->resolveMagicCall()
     (vendor/doctrine/orm/src/EntityRepository.php:154)
  at Doctrine\ORM\EntityRepository->__call()
     (src/Controller/DefaultController.php:341)
  at App\Controller\DefaultController->accueil()
     (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/HttpCache/SubRequestHandler.php:86)
  at Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
     (vendor/symfony/http-kernel/Fragment/InlineFragmentRenderer.php:75)
  at Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render()
     (vendor/symfony/http-kernel/Fragment/FragmentHandler.php:81)
  at Symfony\Component\HttpKernel\Fragment\FragmentHandler->render()
     (vendor/symfony/http-kernel/DependencyInjection/LazyLoadingFragmentHandler.php:46)
  at Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render()
     (vendor/symfony/twig-bridge/Extension/HttpKernelRuntime.php:41)
  at Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment()
     (var/cache/dev/twig/17/17c3522d8af9b575f65159f4829ce3cf.php:108)
  at __TwigTemplate_020e859290cca9f5c893ef26e4580ba0->block_body()
     (vendor/twig/twig/src/Template.php:446)
  at Twig\Template->yieldBlock()
     (var/cache/dev/twig/8c/8c42dcbb5dc01355c99afc695c8d8772.php:254)
  at __TwigTemplate_a0b1d5d5d38611de786fc92c8c7632ac->doDisplay()
     (vendor/twig/twig/src/Template.php:402)
  at Twig\Template->yield()
     (var/cache/dev/twig/17/17c3522d8af9b575f65159f4829ce3cf.php:54)
  at __TwigTemplate_020e859290cca9f5c893ef26e4580ba0->doDisplay()
     (vendor/twig/twig/src/Template.php:402)
  at Twig\Template->yield()
     (vendor/twig/twig/src/Template.php:358)
  at Twig\Template->display()
     (vendor/twig/twig/src/Template.php:373)
  at Twig\Template->render()
     (vendor/twig/twig/src/TemplateWrapper.php:51)
  at Twig\TemplateWrapper->render()
     (vendor/twig/twig/src/Environment.php:333)
  at Twig\Environment->render()
     (vendor/symfony/framework-bundle/Controller/AbstractController.php:462)
  at Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView()
     (vendor/symfony/framework-bundle/Controller/AbstractController.php:467)
  at Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender()
     (vendor/symfony/framework-bundle/Controller/AbstractController.php:279)
  at Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render()
     (src/Controller/DefaultController.php:37)
  at App\Controller\DefaultController->Homepage()
     (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:191)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:37)