Symfony Exception

PDOException Exception SyntaxErrorException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND i.status = 1 AND i.lng = 'en'' at line 1

Exceptions 3

Doctrine\DBAL\Exception\ SyntaxErrorException

  1.             case 1382:
  2.             case 1479:
  3.             case 1541:
  4.             case 1554:
  5.             case 1626:
  6.                 return new SyntaxErrorException($exception$query);
  7.             case 1044:
  8.             case 1045:
  9.             case 1046:
  10.             case 1049:
  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 1851)
  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 1070)
  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.         } finally {
  7.             if ($logger !== null) {
  8.                 $logger->stopQuery();
  9.             }
  10.         }
Connection->executeQuery() in src/Repository/Product/ItemNewRepository.php (line 137)
  1.                 $sqlWhere[] = "JSON_CONTAINS(i.filters, '{\"fid\":\"".$fid."\"}')";
  2.             }
  3.             $querySQL .= implode(' AND '$sqlWhere) . ' AND i.status = 1 AND i.lng = \'' $lng '\'';
  4.             $statement $this->entityManager->getConnection()->executeQuery($querySQL);
  5.             $results $statement->fetchAllAssociative();
  6.             if ($results)
  7.             {
  8.                 $productIDs = [];
ItemNewRepository->search() in src/Controller/SearchController.php (line 278)
  1.                 'pages' => $pages,
  2.                 'page' => $page,
  3.             ));
  4.         }
  5.         $result $this->entityManager->getRepository(ItemNew::class)->search($searchData);
  6. //        dd($result);
  7.         $allFilters $this->entityManager->getRepository(ItemNew::class)->generateFilters($searchData);
  8.         $total count($allFilters);
  1.         $this->dispatcher->dispatch($eventKernelEvents::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);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $this->handleRaw($request$type);
  6.         } catch (\Exception $e) {
  7.             if ($e instanceof RequestExceptionInterface) {
  8.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  9.             }
  10.             if (false === $catch) {
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices true;
  4.         try {
  5.             return $this->getHttpKernel()->handle($request$type$catch);
  6.         } finally {
  7.             --$this->requestStackSize;
  8.         }
  9.     }
Kernel->handle() in public/index.php (line 22)
  1.     Request::setTrustedHosts([$trustedHosts]);
  2. }
  3. $kernel = new Kernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  4. $request Request::createFromGlobals();
  5. $response $kernel->handle($request);
  6. $response->send();
  7. $kernel->terminate($request$response);

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND i.status = 1 AND i.lng = 'en'' at line 1

  1.         } else {
  2.             $code     $exception->getCode();
  3.             $sqlState null;
  4.         }
  5.         return new self($exception->getMessage(), $sqlState$code$exception);
  6.     }
  7. }
  1.             $stmt $this->connection->query($sql);
  2.             assert($stmt instanceof PDOStatement);
  3.             return new Result($stmt);
  4.         } catch (PDOException $exception) {
  5.             throw Exception::new($exception);
  6.         }
  7.     }
  8.     /**
  9.      * {@inheritdoc}
  1.         return $this->wrappedConnection->prepare($sql);
  2.     }
  3.     public function query(string $sql): Result
  4.     {
  5.         return $this->wrappedConnection->query($sql);
  6.     }
  7.     /**
  8.      * {@inheritdoc}
  9.      */
  1.         }
  2.         $query->start();
  3.         try {
  4.             $result parent::query($sql);
  5.         } finally {
  6.             $query->stop();
  7.             if (null !== $this->stopwatch) {
  8.                 $this->stopwatch->stop('doctrine');
  1.                 $this->bindParameters($stmt$params$types);
  2.                 $result $stmt->execute();
  3.             } else {
  4.                 $result $connection->query($sql);
  5.             }
  6.             return new Result($result$this);
  7.         } catch (Driver\Exception $e) {
  8.             throw $this->convertExceptionDuringQuery($e$sql$params$types);
Connection->executeQuery() in src/Repository/Product/ItemNewRepository.php (line 137)
  1.                 $sqlWhere[] = "JSON_CONTAINS(i.filters, '{\"fid\":\"".$fid."\"}')";
  2.             }
  3.             $querySQL .= implode(' AND '$sqlWhere) . ' AND i.status = 1 AND i.lng = \'' $lng '\'';
  4.             $statement $this->entityManager->getConnection()->executeQuery($querySQL);
  5.             $results $statement->fetchAllAssociative();
  6.             if ($results)
  7.             {
  8.                 $productIDs = [];
ItemNewRepository->search() in src/Controller/SearchController.php (line 278)
  1.                 'pages' => $pages,
  2.                 'page' => $page,
  3.             ));
  4.         }
  5.         $result $this->entityManager->getRepository(ItemNew::class)->search($searchData);
  6. //        dd($result);
  7.         $allFilters $this->entityManager->getRepository(ItemNew::class)->generateFilters($searchData);
  8.         $total count($allFilters);
  1.         $this->dispatcher->dispatch($eventKernelEvents::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);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $this->handleRaw($request$type);
  6.         } catch (\Exception $e) {
  7.             if ($e instanceof RequestExceptionInterface) {
  8.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  9.             }
  10.             if (false === $catch) {
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices true;
  4.         try {
  5.             return $this->getHttpKernel()->handle($request$type$catch);
  6.         } finally {
  7.             --$this->requestStackSize;
  8.         }
  9.     }
Kernel->handle() in public/index.php (line 22)
  1.     Request::setTrustedHosts([$trustedHosts]);
  2. }
  3. $kernel = new Kernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  4. $request Request::createFromGlobals();
  5. $response $kernel->handle($request);
  6. $response->send();
  7. $kernel->terminate($request$response);

PDOException

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND i.status = 1 AND i.lng = 'en'' at line 1

  1.     }
  2.     public function query(string $sql): ResultInterface
  3.     {
  4.         try {
  5.             $stmt $this->connection->query($sql);
  6.             assert($stmt instanceof PDOStatement);
  7.             return new Result($stmt);
  8.         } catch (PDOException $exception) {
  9.             throw Exception::new($exception);
  1.     }
  2.     public function query(string $sql): ResultInterface
  3.     {
  4.         try {
  5.             $stmt $this->connection->query($sql);
  6.             assert($stmt instanceof PDOStatement);
  7.             return new Result($stmt);
  8.         } catch (PDOException $exception) {
  9.             throw Exception::new($exception);
  1.         return $this->wrappedConnection->prepare($sql);
  2.     }
  3.     public function query(string $sql): Result
  4.     {
  5.         return $this->wrappedConnection->query($sql);
  6.     }
  7.     /**
  8.      * {@inheritdoc}
  9.      */
  1.         }
  2.         $query->start();
  3.         try {
  4.             $result parent::query($sql);
  5.         } finally {
  6.             $query->stop();
  7.             if (null !== $this->stopwatch) {
  8.                 $this->stopwatch->stop('doctrine');
  1.                 $this->bindParameters($stmt$params$types);
  2.                 $result $stmt->execute();
  3.             } else {
  4.                 $result $connection->query($sql);
  5.             }
  6.             return new Result($result$this);
  7.         } catch (Driver\Exception $e) {
  8.             throw $this->convertExceptionDuringQuery($e$sql$params$types);
Connection->executeQuery() in src/Repository/Product/ItemNewRepository.php (line 137)
  1.                 $sqlWhere[] = "JSON_CONTAINS(i.filters, '{\"fid\":\"".$fid."\"}')";
  2.             }
  3.             $querySQL .= implode(' AND '$sqlWhere) . ' AND i.status = 1 AND i.lng = \'' $lng '\'';
  4.             $statement $this->entityManager->getConnection()->executeQuery($querySQL);
  5.             $results $statement->fetchAllAssociative();
  6.             if ($results)
  7.             {
  8.                 $productIDs = [];
ItemNewRepository->search() in src/Controller/SearchController.php (line 278)
  1.                 'pages' => $pages,
  2.                 'page' => $page,
  3.             ));
  4.         }
  5.         $result $this->entityManager->getRepository(ItemNew::class)->search($searchData);
  6. //        dd($result);
  7.         $allFilters $this->entityManager->getRepository(ItemNew::class)->generateFilters($searchData);
  8.         $total count($allFilters);
  1.         $this->dispatcher->dispatch($eventKernelEvents::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);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $this->handleRaw($request$type);
  6.         } catch (\Exception $e) {
  7.             if ($e instanceof RequestExceptionInterface) {
  8.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  9.             }
  10.             if (false === $catch) {
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices true;
  4.         try {
  5.             return $this->getHttpKernel()->handle($request$type$catch);
  6.         } finally {
  7.             --$this->requestStackSize;
  8.         }
  9.     }
Kernel->handle() in public/index.php (line 22)
  1.     Request::setTrustedHosts([$trustedHosts]);
  2. }
  3. $kernel = new Kernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  4. $request Request::createFromGlobals();
  5. $response $kernel->handle($request);
  6. $response->send();
  7. $kernel->terminate($request$response);

Stack Traces 3

[3/3] SyntaxErrorException
Doctrine\DBAL\Exception\SyntaxErrorException:
An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND i.status = 1 AND i.lng = 'en'' at line 1

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:86
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1908)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1851)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Connection.php:1070)
  at Doctrine\DBAL\Connection->executeQuery()
     (src/Repository/Product/ItemNewRepository.php:137)
  at App\Repository\Product\ItemNewRepository->search()
     (src/Controller/SearchController.php:278)
  at App\Controller\SearchController->searchNew()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:22)                
[2/3] Exception
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND i.status = 1 AND i.lng = 'en'' at line 1

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:74)
  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/Connection.php:62)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Connection->query()
     (vendor/doctrine/dbal/src/Connection.php:1065)
  at Doctrine\DBAL\Connection->executeQuery()
     (src/Repository/Product/ItemNewRepository.php:137)
  at App\Repository\Product\ItemNewRepository->search()
     (src/Controller/SearchController.php:278)
  at App\Controller\SearchController->searchNew()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:22)                
[1/3] PDOException
PDOException:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND i.status = 1 AND i.lng = 'en'' at line 1

  at vendor/doctrine/dbal/src/Driver/PDO/Connection.php:69
  at PDO->query()
     (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:69)
  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/Connection.php:62)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Connection->query()
     (vendor/doctrine/dbal/src/Connection.php:1065)
  at Doctrine\DBAL\Connection->executeQuery()
     (src/Repository/Product/ItemNewRepository.php:137)
  at App\Repository\Product\ItemNewRepository->search()
     (src/Controller/SearchController.php:278)
  at App\Controller\SearchController->searchNew()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:22)