https://www.peoplewhotravel.com/afficheMessage?idMessage=39%3D

Forwarded to
ErrorController (b5a843)
Method
GET
HTTP Status
500
IP
217.113.194.130
Profiled on
Token
f5714b

Exceptions

QueryException QueryException

HTTP 500 Internal Server Error

[Syntax Error] line 0, col 58: Error: Expected end of string, got '='

Exceptions 2

Doctrine\ORM\Query\ QueryException

in vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php (line 54)
  1.      *
  2.      * @return QueryException
  3.      */
  4.     public static function syntaxError($message, $previous = null)
  5.     {
  6.         return new self('[Syntax Error] ' . $message, 0, $previous);
  7.     }
  9.     /**
  10.      * @param string          $message
  11.      * @param \Exception|null $previous
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php :: syntaxError (line 457)
  2.         $message  = "line 0, col {$tokenPos}: Error: ";
  3.         $message .= ($expected !== '') ? "Expected {$expected}, got " : 'Unexpected ';
  4.         $message .= ($this->lexer->lookahead === null) ? 'end of string.' : "'{$token['value']}'";
  6.         throw QueryException::syntaxError($message, QueryException::dqlError($this->query->getDQL()));
  7.     }
  9.     /**
  10.      * Generates a new semantical error.
  11.      *
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> syntaxError (line 866)
  1.                 break;
  2.         }
  4.         // Check for end of string
  5.         if ($this->lexer->lookahead !== null) {
  6.             $this->syntaxError('end of string');
  7.         }
  9.         return $statement;
  10.     }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> QueryLanguage (line 261)
  1.      *         \Doctrine\ORM\Query\AST\DeleteStatement
  2.      */
  3.     public function getAST()
  4.     {
  5.         // Parse & build AST
  6.         $AST = $this->QueryLanguage();
  8.         // Process any deferred validations of some nodes in the AST.
  9.         // This also allows post-processing of the AST for modification purposes.
  10.         $this->processDeferredIdentificationVariables();
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> getAST (line 360)
  1.      *
  2.      * @return ParserResult
  3.      */
  4.     public function parse()
  5.     {
  6.         $AST = $this->getAST();
  8.         if (($customWalkers = $this->query->getHint(Query::HINT_CUSTOM_TREE_WALKERS)) !== false) {
  9.             $this->customTreeWalkers = $customWalkers;
  10.         }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php -> parse (line 286)
  1.         }
  3.         // Cache miss.
  4.         $parser = new Parser($this);
  6.         $this->_parserResult = $parser->parse();
  8.         $queryCache->save($hash, $this->_parserResult, $this->_queryCacheTTL);
  10.         return $this->_parserResult;
  11.     }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php -> _parse (line 298)
  1.     /**
  2.      * {@inheritdoc}
  3.      */
  4.     protected function _doExecute()
  5.     {
  6.         $executor = $this->_parse()->getSqlExecutor();
  8.         if ($this->_queryCacheProfile) {
  9.             $executor->setQueryCacheProfile($this->_queryCacheProfile);
  10.         } else {
  11.             $executor->removeQueryCacheProfile();
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> _doExecute (line 992)
  2.                 $cache->save($cacheKey, $result, $queryCacheProfile->getLifetime());
  3.             };
  4.         }
  6.         $stmt = $this->_doExecute();
  8.         if (is_numeric($stmt)) {
  9.             $setCacheEntry($stmt);
  11.             return $stmt;
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> executeIgnoreQueryCache (line 947)
  1.     {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4.         }
  6.         return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7.     }
  9.     /**
  10.      * Execute query ignoring second level cache.
  11.      *
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> execute (line 750)
  1.      *
  2.      * @return mixed
  3.      */
  4.     public function getResult($hydrationMode = self::HYDRATE_OBJECT)
  5.     {
  6.         return $this->execute(null, $hydrationMode);
  7.     }
  9.     /**
  10.      * Gets the array of results for the query.
  11.      *
AbstractQuery->getResult() in src/Controller/AfficheMessageController.php (line 43)
  1.             $user = $session->get('user', null);
  2.         
  3.             $idMessage = $_GET['idMessage'];
  4.          
  5.             $em = $this->getDoctrine()->getManager();
  6.             $message0 = $em->createQueryBuilder('msg')->select('m')->from('App\Entity\MessageParametre', 'm')->where('m.id ='.$idMessage)->getQuery()->getResult();
  7.             $message = $message0[0];
  8.             $id_pseudo = $message->getIdParametre();
  9.             $stmt_pseudo  = $em->getConnection()->prepare('SELECT `pseudo` FROM `parametres` WHERE `parametres`.`id_parametres` ='.$id_pseudo);
  10.             $stmt_pseudo->execute();
  11.             $pseudo = ($stmt_pseudo->fetchAll())[0]['pseudo'];
in vendor/symfony/http-kernel/HttpKernel.php -> afficheMessage (line 158)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 80)
  1.     public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
  2.     {
  3.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Exception $e) {
  8.             if ($e instanceof RequestExceptionInterface) {
  9.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  10.             }
  11.             if (false === $catch) {
in vendor/symfony/http-kernel/Kernel.php -> handle (line 201)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
Kernel->handle() in public/index.php (line 36)
  2. $kernel = new Kernel($env, $debug);
  4. $request = Request::createFromGlobals();
  6. $response = $kernel->handle($request);
  8. $response->send();
  10. $kernel->terminate($request, $response);

Doctrine\ORM\Query\ QueryException

SELECT m FROM App\Entity\MessageParametre m WHERE m.id =39=
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php (line 43)
  1.      *
  2.      * @return QueryException
  3.      */
  4.     public static function dqlError($dql)
  5.     {
  6.         return new self($dql);
  7.     }
  9.     /**
  10.      * @param string          $message
  11.      * @param \Exception|null $previous
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php :: dqlError (line 457)
  2.         $message  = "line 0, col {$tokenPos}: Error: ";
  3.         $message .= ($expected !== '') ? "Expected {$expected}, got " : 'Unexpected ';
  4.         $message .= ($this->lexer->lookahead === null) ? 'end of string.' : "'{$token['value']}'";
  6.         throw QueryException::syntaxError($message, QueryException::dqlError($this->query->getDQL()));
  7.     }
  9.     /**
  10.      * Generates a new semantical error.
  11.      *
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> syntaxError (line 866)
  1.                 break;
  2.         }
  4.         // Check for end of string
  5.         if ($this->lexer->lookahead !== null) {
  6.             $this->syntaxError('end of string');
  7.         }
  9.         return $statement;
  10.     }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> QueryLanguage (line 261)
  1.      *         \Doctrine\ORM\Query\AST\DeleteStatement
  2.      */
  3.     public function getAST()
  4.     {
  5.         // Parse & build AST
  6.         $AST = $this->QueryLanguage();
  8.         // Process any deferred validations of some nodes in the AST.
  9.         // This also allows post-processing of the AST for modification purposes.
  10.         $this->processDeferredIdentificationVariables();
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php -> getAST (line 360)
  1.      *
  2.      * @return ParserResult
  3.      */
  4.     public function parse()
  5.     {
  6.         $AST = $this->getAST();
  8.         if (($customWalkers = $this->query->getHint(Query::HINT_CUSTOM_TREE_WALKERS)) !== false) {
  9.             $this->customTreeWalkers = $customWalkers;
  10.         }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php -> parse (line 286)
  1.         }
  3.         // Cache miss.
  4.         $parser = new Parser($this);
  6.         $this->_parserResult = $parser->parse();
  8.         $queryCache->save($hash, $this->_parserResult, $this->_queryCacheTTL);
  10.         return $this->_parserResult;
  11.     }
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php -> _parse (line 298)
  1.     /**
  2.      * {@inheritdoc}
  3.      */
  4.     protected function _doExecute()
  5.     {
  6.         $executor = $this->_parse()->getSqlExecutor();
  8.         if ($this->_queryCacheProfile) {
  9.             $executor->setQueryCacheProfile($this->_queryCacheProfile);
  10.         } else {
  11.             $executor->removeQueryCacheProfile();
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> _doExecute (line 992)
  2.                 $cache->save($cacheKey, $result, $queryCacheProfile->getLifetime());
  3.             };
  4.         }
  6.         $stmt = $this->_doExecute();
  8.         if (is_numeric($stmt)) {
  9.             $setCacheEntry($stmt);
  11.             return $stmt;
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> executeIgnoreQueryCache (line 947)
  1.     {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4.         }
  6.         return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7.     }
  9.     /**
  10.      * Execute query ignoring second level cache.
  11.      *
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> execute (line 750)
  1.      *
  2.      * @return mixed
  3.      */
  4.     public function getResult($hydrationMode = self::HYDRATE_OBJECT)
  5.     {
  6.         return $this->execute(null, $hydrationMode);
  7.     }
  9.     /**
  10.      * Gets the array of results for the query.
  11.      *
AbstractQuery->getResult() in src/Controller/AfficheMessageController.php (line 43)
  1.             $user = $session->get('user', null);
  2.         
  3.             $idMessage = $_GET['idMessage'];
  4.          
  5.             $em = $this->getDoctrine()->getManager();
  6.             $message0 = $em->createQueryBuilder('msg')->select('m')->from('App\Entity\MessageParametre', 'm')->where('m.id ='.$idMessage)->getQuery()->getResult();
  7.             $message = $message0[0];
  8.             $id_pseudo = $message->getIdParametre();
  9.             $stmt_pseudo  = $em->getConnection()->prepare('SELECT `pseudo` FROM `parametres` WHERE `parametres`.`id_parametres` ='.$id_pseudo);
  10.             $stmt_pseudo->execute();
  11.             $pseudo = ($stmt_pseudo->fetchAll())[0]['pseudo'];
in vendor/symfony/http-kernel/HttpKernel.php -> afficheMessage (line 158)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 80)
  1.     public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
  2.     {
  3.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Exception $e) {
  8.             if ($e instanceof RequestExceptionInterface) {
  9.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  10.             }
  11.             if (false === $catch) {
in vendor/symfony/http-kernel/Kernel.php -> handle (line 201)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
Kernel->handle() in public/index.php (line 36)
  2. $kernel = new Kernel($env, $debug);
  4. $request = Request::createFromGlobals();
  6. $response = $kernel->handle($request);
  8. $response->send();
  10. $kernel->terminate($request, $response);

Stack Traces 2

[2/2] QueryException 

Doctrine\ORM\Query\QueryException:
[Syntax Error] line 0, col 58: Error: Expected end of string, got '='

  at vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:54
  at Doctrine\ORM\Query\QueryException::syntaxError()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:457)
  at Doctrine\ORM\Query\Parser->syntaxError()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:866)
  at Doctrine\ORM\Query\Parser->QueryLanguage()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:261)
  at Doctrine\ORM\Query\Parser->getAST()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:360)
  at Doctrine\ORM\Query\Parser->parse()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:286)
  at Doctrine\ORM\Query->_parse()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:298)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:992)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:947)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:750)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/Controller/AfficheMessageController.php:43)
  at App\Controller\AfficheMessageController->afficheMessage()
     (vendor/symfony/http-kernel/HttpKernel.php:158)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:80)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:201)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:36)

[1/2] QueryException 

Doctrine\ORM\Query\QueryException:
SELECT m FROM App\Entity\MessageParametre m WHERE m.id =39=

  at vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:43
  at Doctrine\ORM\Query\QueryException::dqlError()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:457)
  at Doctrine\ORM\Query\Parser->syntaxError()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:866)
  at Doctrine\ORM\Query\Parser->QueryLanguage()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:261)
  at Doctrine\ORM\Query\Parser->getAST()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:360)
  at Doctrine\ORM\Query\Parser->parse()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:286)
  at Doctrine\ORM\Query->_parse()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:298)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:992)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:947)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:750)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/Controller/AfficheMessageController.php:43)
  at App\Controller\AfficheMessageController->afficheMessage()
     (vendor/symfony/http-kernel/HttpKernel.php:158)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:80)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:201)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:36)