https://test.dombusin.com/uk/catalog/search?start=9600

Exceptions

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 MariaDB server version for the right syntax to use near 'язок' GROUP BY color order by size' 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 1524:
  8.                 if (strpos($exception->getMessage(), 'Plugin \'mysql_native_password\' is not loaded') === false) {
  9.                     break;
  10.                 }
  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 1918)
  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/Statement.php -> convertExceptionDuringQuery (line 194)
  1.             return new Result(
  2.                 $this->stmt->execute($params),
  3.                 $this->conn,
  4.             );
  5.         } catch (Driver\Exception $ex) {
  6.             throw $this->conn->convertExceptionDuringQuery($ex$this->sql$this->params$this->types);
  7.         } finally {
  8.             if ($logger !== null) {
  9.                 $logger->stopQuery();
  10.             }
  11.         }
  1.         if ($params === []) {
  2.             $params null// Workaround as long execute() exists and used internally.
  3.         }
  4.         return $this->execute($params);
  5.     }
  6.     /**
  7.      * Executes the statement with the currently bound parameters and return affected rows.
  8.      *
Statement->executeQuery() in src/Repository/CubeRepository.php (line 85)
  1.                 $sql "SELECT prod, `color` FROM cube WHERE `model` = '".$model."' AND `size` = $size AND inpack = '$inpack' AND prod != $prod_id_except";
  2.             } else {
  3.                 $sql "SELECT prod, `color` FROM cube WHERE `model` = '".$model."' AND `size` = $size AND inpack = '$inpack' GROUP BY color order by size";
  4.             }
  5.             
  6.             $results $this->getEntityManager()->getConnection()->prepare($sql)->executeQuery()->fetchAllAssociative();
  7.             $colors = [];
  8.             foreach ($results as $k => $r) {
  9.                 if (!isset($colors[$k])) {
  10.                     $colors[$k] = [];
  11.                 }
in vendor/symfony/cache/LockRegistry.php -> App\Repository\{closure} (line 112)
  1.                 if ($locked || !$wouldBlock) {
  2.                     $logger && $logger->info(sprintf('Lock %s, now computing item "{key}"'$locked 'acquired' 'not supported'), ['key' => $item->getKey()]);
  3.                     self::$lockedFiles[$key] = true;
  4.                     $value $callback($item$save);
  5.                     if ($save) {
  6.                         if ($setMetadata) {
  7.                             $setMetadata($item);
  8.                         }
  1.             if (!isset($this->callbackWrapper)) {
  2.                 $this->setCallbackWrapper($this->setCallbackWrapper(null));
  3.             }
  4.             try {
  5.                 $value = ($this->callbackWrapper)($callback$item$save$pool, function (CacheItem $item) use ($setMetadata$startTime, &$metadata) {
  6.                     $setMetadata($item$startTime$metadata);
  7.                 }, $this->logger ?? null);
  8.                 $setMetadata($item$startTime$metadata);
  9.                 return $value;
in vendor/symfony/cache-contracts/CacheTrait.php -> Symfony\Component\Cache\Traits\{closure} (line 64)
  1.             }
  2.         }
  3.         if ($recompute) {
  4.             $save true;
  5.             $item->set($callback($item$save));
  6.             if ($save) {
  7.                 $pool->save($item);
  8.             }
  9.         }
  1.             CacheItem::class
  2.         );
  3.         $this->callbackWrapper ??= \Closure::fromCallable([LockRegistry::class, 'compute']);
  4.         return $this->contractsGet($pool$key, function (CacheItem $itembool &$save) use ($pool$callback$setMetadata, &$metadata$key) {
  5.             // don't wrap nor save recursive calls
  6.             if (isset($this->computing[$key])) {
  7.                 $value $callback($item$save);
  8.                 $save false;
  1.  */
  2. trait CacheTrait
  3. {
  4.     public function get(string $key, callable $callback, ?float $beta null, ?array &$metadata null): mixed
  5.     {
  6.         return $this->doGet($this$key$callback$beta$metadata);
  7.     }
  8.     public function delete(string $key): bool
  9.     {
  10.         return $this->deleteItem($key);
TagAwareAdapter->get() in src/Repository/CubeRepository.php (line 78)
  1.         return $qb->getQuery()->getResult();
  2.     }
  3.     public function getColors(string $modelint $sizestring $inpackint $prod_id_except 0): array
  4.     {
  5.         $colors $this->appCache->get('cube_'.$model."_s".$size."_i".$inpack."_".$this->requestStack->getCurrentRequest()->getLocale(), function (ItemInterface $item) use ($model$size$inpack$prod_id_except): array {
  6.             if ($prod_id_except) {
  7.                 $sql "SELECT prod, `color` FROM cube WHERE `model` = '".$model."' AND `size` = $size AND inpack = '$inpack' AND prod != $prod_id_except";
  8.             } else {
  9.                 $sql "SELECT prod, `color` FROM cube WHERE `model` = '".$model."' AND `size` = $size AND inpack = '$inpack' GROUP BY color order by size";
  10.             }
CubeRepository->getColors() in src/Controller/CatalogController.php (line 476)
  1.                 // }
  2.                 
  3.                 if (isset($prod_chars[317]) && isset($prod_chars[415])) {
  4.                     $color $prod_chars[317]['cvid'];
  5.                     $size $prod_chars[415]['cvid'];
  6.                     $show_prods[$k]->colors $this->Cube->getColors($v->getModel(), $size$v->getInpack());
  7.                     $show_prods[$k]->sizes $this->Cube->getSizes($v->getModel(), $color$v->getInpack());
  8.                     $show_prods[$k]->inpacks $this->Cube->getPacks($v->getModel(), $color$size);
  9.                 }
  10.             }
  11.         }
  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.     }
  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.         if ($this->surrogate) {
  2.             $this->surrogate->addSurrogateCapability($request);
  3.         }
  4.         // always a "master" request (as the real master request can be in cache)
  5.         $response SubRequestHandler::handle($this->kernel$requestHttpKernelInterface::MAIN_REQUEST$catch);
  6.         /*
  7.          * Support stale-if-error given on Responses or as a config option.
  8.          * RFC 7234 summarizes in Section 4.2.4 (but also mentions with the individual
  9.          * Cache-Control directives) that
  1.     protected function forward(Request $requestbool $catch falseResponse $entry null): Response
  2.     {
  3.         $this->getKernel()->boot();
  4.         $this->getKernel()->getContainer()->set('cache'$this);
  5.         return parent::forward($request$catch$entry);
  6.     }
  7.     /**
  8.      * Returns an array of options to customize the Cache configuration.
  9.      */
  1.         // avoid that the backend sends no content
  2.         $subRequest->headers->remove('If-Modified-Since');
  3.         $subRequest->headers->remove('If-None-Match');
  4.         $response $this->forward($subRequest$catch);
  5.         if ($response->isCacheable()) {
  6.             $this->store($request$response);
  7.         }
  1.         }
  2.         if (null === $entry) {
  3.             $this->record($request'miss');
  4.             return $this->fetch($request$catch);
  5.         }
  6.         if (!$this->isFreshEnough($request$entry)) {
  7.             $this->record($request'stale');
  1.                 reload the cache by fetching a fresh response and caching it (if possible).
  2.             */
  3.             $this->record($request'reload');
  4.             $response $this->fetch($request$catch);
  5.         } else {
  6.             $response $this->lookup($request$catch);
  7.         }
  8.         $this->restoreResponseBody($request$response);
  9.         if (HttpKernelInterface::MAIN_REQUEST === $type) {
  1.     {
  2.         if (!$this->booted) {
  3.             $container $this->container ?? $this->preBoot();
  4.             if ($container->has('http_cache')) {
  5.                 return $container->get('http_cache')->handle($request$type$catch);
  6.             }
  7.         }
  8.         $this->boot();
  9.         ++$this->requestStackSize;
  1.         $this->request $request;
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         $response->send();
  7.         if ($this->kernel instanceof TerminableInterface) {
  8.             $this->kernel->terminate($this->request$response);
  9.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/home/test.dombusin.com/public_html/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  2. use App\Kernel;
  3. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  4. return function (array $context) {    
  5.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  6. };

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 MariaDB server version for the right syntax to use near 'язок' GROUP BY color order by size' 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.         }
  2.         try {
  3.             $this->stmt->execute($params);
  4.         } catch (PDOException $exception) {
  5.             throw Exception::new($exception);
  6.         }
  7.         return new Result($this->stmt);
  8.     }
  9. }
  1.     /**
  2.      * {@inheritDoc}
  3.      */
  4.     public function execute($params null): Result
  5.     {
  6.         return $this->wrappedStatement->execute($params);
  7.     }
  8. }
  1.         $this->debugDataHolder->addQuery($this->connectionName$query = clone $this->query);
  2.         $query->start();
  3.         try {
  4.             $result parent::execute($params);
  5.         } finally {
  6.             $query->stop();
  7.         }
  8.         return $result;
  1.             $logger->startQuery($this->sql$this->params$this->types);
  2.         }
  3.         try {
  4.             return new Result(
  5.                 $this->stmt->execute($params),
  6.                 $this->conn,
  7.             );
  8.         } catch (Driver\Exception $ex) {
  9.             throw $this->conn->convertExceptionDuringQuery($ex$this->sql$this->params$this->types);
  10.         } finally {
  1.         if ($params === []) {
  2.             $params null// Workaround as long execute() exists and used internally.
  3.         }
  4.         return $this->execute($params);
  5.     }
  6.     /**
  7.      * Executes the statement with the currently bound parameters and return affected rows.
  8.      *
Statement->executeQuery() in src/Repository/CubeRepository.php (line 85)
  1.                 $sql "SELECT prod, `color` FROM cube WHERE `model` = '".$model."' AND `size` = $size AND inpack = '$inpack' AND prod != $prod_id_except";
  2.             } else {
  3.                 $sql "SELECT prod, `color` FROM cube WHERE `model` = '".$model."' AND `size` = $size AND inpack = '$inpack' GROUP BY color order by size";
  4.             }
  5.             
  6.             $results $this->getEntityManager()->getConnection()->prepare($sql)->executeQuery()->fetchAllAssociative();
  7.             $colors = [];
  8.             foreach ($results as $k => $r) {
  9.                 if (!isset($colors[$k])) {
  10.                     $colors[$k] = [];
  11.                 }
in vendor/symfony/cache/LockRegistry.php -> App\Repository\{closure} (line 112)
  1.                 if ($locked || !$wouldBlock) {
  2.                     $logger && $logger->info(sprintf('Lock %s, now computing item "{key}"'$locked 'acquired' 'not supported'), ['key' => $item->getKey()]);
  3.                     self::$lockedFiles[$key] = true;
  4.                     $value $callback($item$save);
  5.                     if ($save) {
  6.                         if ($setMetadata) {
  7.                             $setMetadata($item);
  8.                         }
  1.             if (!isset($this->callbackWrapper)) {
  2.                 $this->setCallbackWrapper($this->setCallbackWrapper(null));
  3.             }
  4.             try {
  5.                 $value = ($this->callbackWrapper)($callback$item$save$pool, function (CacheItem $item) use ($setMetadata$startTime, &$metadata) {
  6.                     $setMetadata($item$startTime$metadata);
  7.                 }, $this->logger ?? null);
  8.                 $setMetadata($item$startTime$metadata);
  9.                 return $value;
in vendor/symfony/cache-contracts/CacheTrait.php -> Symfony\Component\Cache\Traits\{closure} (line 64)
  1.             }
  2.         }
  3.         if ($recompute) {
  4.             $save true;
  5.             $item->set($callback($item$save));
  6.             if ($save) {
  7.                 $pool->save($item);
  8.             }
  9.         }
  1.             CacheItem::class
  2.         );
  3.         $this->callbackWrapper ??= \Closure::fromCallable([LockRegistry::class, 'compute']);
  4.         return $this->contractsGet($pool$key, function (CacheItem $itembool &$save) use ($pool$callback$setMetadata, &$metadata$key) {
  5.             // don't wrap nor save recursive calls
  6.             if (isset($this->computing[$key])) {
  7.                 $value $callback($item$save);
  8.                 $save false;
  1.  */
  2. trait CacheTrait
  3. {
  4.     public function get(string $key, callable $callback, ?float $beta null, ?array &$metadata null): mixed
  5.     {
  6.         return $this->doGet($this$key$callback$beta$metadata);
  7.     }
  8.     public function delete(string $key): bool
  9.     {
  10.         return $this->deleteItem($key);
TagAwareAdapter->get() in src/Repository/CubeRepository.php (line 78)
  1.         return $qb->getQuery()->getResult();
  2.     }
  3.     public function getColors(string $modelint $sizestring $inpackint $prod_id_except 0): array
  4.     {
  5.         $colors $this->appCache->get('cube_'.$model."_s".$size."_i".$inpack."_".$this->requestStack->getCurrentRequest()->getLocale(), function (ItemInterface $item) use ($model$size$inpack$prod_id_except): array {
  6.             if ($prod_id_except) {
  7.                 $sql "SELECT prod, `color` FROM cube WHERE `model` = '".$model."' AND `size` = $size AND inpack = '$inpack' AND prod != $prod_id_except";
  8.             } else {
  9.                 $sql "SELECT prod, `color` FROM cube WHERE `model` = '".$model."' AND `size` = $size AND inpack = '$inpack' GROUP BY color order by size";
  10.             }
CubeRepository->getColors() in src/Controller/CatalogController.php (line 476)
  1.                 // }
  2.                 
  3.                 if (isset($prod_chars[317]) && isset($prod_chars[415])) {
  4.                     $color $prod_chars[317]['cvid'];
  5.                     $size $prod_chars[415]['cvid'];
  6.                     $show_prods[$k]->colors $this->Cube->getColors($v->getModel(), $size$v->getInpack());
  7.                     $show_prods[$k]->sizes $this->Cube->getSizes($v->getModel(), $color$v->getInpack());
  8.                     $show_prods[$k]->inpacks $this->Cube->getPacks($v->getModel(), $color$size);
  9.                 }
  10.             }
  11.         }
  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.     }
  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.         if ($this->surrogate) {
  2.             $this->surrogate->addSurrogateCapability($request);
  3.         }
  4.         // always a "master" request (as the real master request can be in cache)
  5.         $response SubRequestHandler::handle($this->kernel$requestHttpKernelInterface::MAIN_REQUEST$catch);
  6.         /*
  7.          * Support stale-if-error given on Responses or as a config option.
  8.          * RFC 7234 summarizes in Section 4.2.4 (but also mentions with the individual
  9.          * Cache-Control directives) that
  1.     protected function forward(Request $requestbool $catch falseResponse $entry null): Response
  2.     {
  3.         $this->getKernel()->boot();
  4.         $this->getKernel()->getContainer()->set('cache'$this);
  5.         return parent::forward($request$catch$entry);
  6.     }
  7.     /**
  8.      * Returns an array of options to customize the Cache configuration.
  9.      */
  1.         // avoid that the backend sends no content
  2.         $subRequest->headers->remove('If-Modified-Since');
  3.         $subRequest->headers->remove('If-None-Match');
  4.         $response $this->forward($subRequest$catch);
  5.         if ($response->isCacheable()) {
  6.             $this->store($request$response);
  7.         }
  1.         }
  2.         if (null === $entry) {
  3.             $this->record($request'miss');
  4.             return $this->fetch($request$catch);
  5.         }
  6.         if (!$this->isFreshEnough($request$entry)) {
  7.             $this->record($request'stale');
  1.                 reload the cache by fetching a fresh response and caching it (if possible).
  2.             */
  3.             $this->record($request'reload');
  4.             $response $this->fetch($request$catch);
  5.         } else {
  6.             $response $this->lookup($request$catch);
  7.         }
  8.         $this->restoreResponseBody($request$response);
  9.         if (HttpKernelInterface::MAIN_REQUEST === $type) {
  1.     {
  2.         if (!$this->booted) {
  3.             $container $this->container ?? $this->preBoot();
  4.             if ($container->has('http_cache')) {
  5.                 return $container->get('http_cache')->handle($request$type$catch);
  6.             }
  7.         }
  8.         $this->boot();
  9.         ++$this->requestStackSize;
  1.         $this->request $request;
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         $response->send();
  7.         if ($this->kernel instanceof TerminableInterface) {
  8.             $this->kernel->terminate($this->request$response);
  9.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/home/test.dombusin.com/public_html/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  2. use App\Kernel;
  3. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  4. return function (array $context) {    
  5.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  6. };

PDOException

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'язок' GROUP BY color order by size' at line 1

  1.                     ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  4.         try {
  5.             $this->stmt->execute($params);
  6.         } catch (PDOException $exception) {
  7.             throw Exception::new($exception);
  8.         }
  9.         return new Result($this->stmt);
  1.                     ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  4.         try {
  5.             $this->stmt->execute($params);
  6.         } catch (PDOException $exception) {
  7.             throw Exception::new($exception);
  8.         }
  9.         return new Result($this->stmt);
  1.     /**
  2.      * {@inheritDoc}
  3.      */
  4.     public function execute($params null): Result
  5.     {
  6.         return $this->wrappedStatement->execute($params);
  7.     }
  8. }
  1.         $this->debugDataHolder->addQuery($this->connectionName$query = clone $this->query);
  2.         $query->start();
  3.         try {
  4.             $result parent::execute($params);
  5.         } finally {
  6.             $query->stop();
  7.         }
  8.         return $result;
  1.             $logger->startQuery($this->sql$this->params$this->types);
  2.         }
  3.         try {
  4.             return new Result(
  5.                 $this->stmt->execute($params),
  6.                 $this->conn,
  7.             );
  8.         } catch (Driver\Exception $ex) {
  9.             throw $this->conn->convertExceptionDuringQuery($ex$this->sql$this->params$this->types);
  10.         } finally {
  1.         if ($params === []) {
  2.             $params null// Workaround as long execute() exists and used internally.
  3.         }
  4.         return $this->execute($params);
  5.     }
  6.     /**
  7.      * Executes the statement with the currently bound parameters and return affected rows.
  8.      *
Statement->executeQuery() in src/Repository/CubeRepository.php (line 85)
  1.                 $sql "SELECT prod, `color` FROM cube WHERE `model` = '".$model."' AND `size` = $size AND inpack = '$inpack' AND prod != $prod_id_except";
  2.             } else {
  3.                 $sql "SELECT prod, `color` FROM cube WHERE `model` = '".$model."' AND `size` = $size AND inpack = '$inpack' GROUP BY color order by size";
  4.             }
  5.             
  6.             $results $this->getEntityManager()->getConnection()->prepare($sql)->executeQuery()->fetchAllAssociative();
  7.             $colors = [];
  8.             foreach ($results as $k => $r) {
  9.                 if (!isset($colors[$k])) {
  10.                     $colors[$k] = [];
  11.                 }
in vendor/symfony/cache/LockRegistry.php -> App\Repository\{closure} (line 112)
  1.                 if ($locked || !$wouldBlock) {
  2.                     $logger && $logger->info(sprintf('Lock %s, now computing item "{key}"'$locked 'acquired' 'not supported'), ['key' => $item->getKey()]);
  3.                     self::$lockedFiles[$key] = true;
  4.                     $value $callback($item$save);
  5.                     if ($save) {
  6.                         if ($setMetadata) {
  7.                             $setMetadata($item);
  8.                         }
  1.             if (!isset($this->callbackWrapper)) {
  2.                 $this->setCallbackWrapper($this->setCallbackWrapper(null));
  3.             }
  4.             try {
  5.                 $value = ($this->callbackWrapper)($callback$item$save$pool, function (CacheItem $item) use ($setMetadata$startTime, &$metadata) {
  6.                     $setMetadata($item$startTime$metadata);
  7.                 }, $this->logger ?? null);
  8.                 $setMetadata($item$startTime$metadata);
  9.                 return $value;
in vendor/symfony/cache-contracts/CacheTrait.php -> Symfony\Component\Cache\Traits\{closure} (line 64)
  1.             }
  2.         }
  3.         if ($recompute) {
  4.             $save true;
  5.             $item->set($callback($item$save));
  6.             if ($save) {
  7.                 $pool->save($item);
  8.             }
  9.         }
  1.             CacheItem::class
  2.         );
  3.         $this->callbackWrapper ??= \Closure::fromCallable([LockRegistry::class, 'compute']);
  4.         return $this->contractsGet($pool$key, function (CacheItem $itembool &$save) use ($pool$callback$setMetadata, &$metadata$key) {
  5.             // don't wrap nor save recursive calls
  6.             if (isset($this->computing[$key])) {
  7.                 $value $callback($item$save);
  8.                 $save false;
  1.  */
  2. trait CacheTrait
  3. {
  4.     public function get(string $key, callable $callback, ?float $beta null, ?array &$metadata null): mixed
  5.     {
  6.         return $this->doGet($this$key$callback$beta$metadata);
  7.     }
  8.     public function delete(string $key): bool
  9.     {
  10.         return $this->deleteItem($key);
TagAwareAdapter->get() in src/Repository/CubeRepository.php (line 78)
  1.         return $qb->getQuery()->getResult();
  2.     }
  3.     public function getColors(string $modelint $sizestring $inpackint $prod_id_except 0): array
  4.     {
  5.         $colors $this->appCache->get('cube_'.$model."_s".$size."_i".$inpack."_".$this->requestStack->getCurrentRequest()->getLocale(), function (ItemInterface $item) use ($model$size$inpack$prod_id_except): array {
  6.             if ($prod_id_except) {
  7.                 $sql "SELECT prod, `color` FROM cube WHERE `model` = '".$model."' AND `size` = $size AND inpack = '$inpack' AND prod != $prod_id_except";
  8.             } else {
  9.                 $sql "SELECT prod, `color` FROM cube WHERE `model` = '".$model."' AND `size` = $size AND inpack = '$inpack' GROUP BY color order by size";
  10.             }
CubeRepository->getColors() in src/Controller/CatalogController.php (line 476)
  1.                 // }
  2.                 
  3.                 if (isset($prod_chars[317]) && isset($prod_chars[415])) {
  4.                     $color $prod_chars[317]['cvid'];
  5.                     $size $prod_chars[415]['cvid'];
  6.                     $show_prods[$k]->colors $this->Cube->getColors($v->getModel(), $size$v->getInpack());
  7.                     $show_prods[$k]->sizes $this->Cube->getSizes($v->getModel(), $color$v->getInpack());
  8.                     $show_prods[$k]->inpacks $this->Cube->getPacks($v->getModel(), $color$size);
  9.                 }
  10.             }
  11.         }
  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.     }
  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.         if ($this->surrogate) {
  2.             $this->surrogate->addSurrogateCapability($request);
  3.         }
  4.         // always a "master" request (as the real master request can be in cache)
  5.         $response SubRequestHandler::handle($this->kernel$requestHttpKernelInterface::MAIN_REQUEST$catch);
  6.         /*
  7.          * Support stale-if-error given on Responses or as a config option.
  8.          * RFC 7234 summarizes in Section 4.2.4 (but also mentions with the individual
  9.          * Cache-Control directives) that
  1.     protected function forward(Request $requestbool $catch falseResponse $entry null): Response
  2.     {
  3.         $this->getKernel()->boot();
  4.         $this->getKernel()->getContainer()->set('cache'$this);
  5.         return parent::forward($request$catch$entry);
  6.     }
  7.     /**
  8.      * Returns an array of options to customize the Cache configuration.
  9.      */
  1.         // avoid that the backend sends no content
  2.         $subRequest->headers->remove('If-Modified-Since');
  3.         $subRequest->headers->remove('If-None-Match');
  4.         $response $this->forward($subRequest$catch);
  5.         if ($response->isCacheable()) {
  6.             $this->store($request$response);
  7.         }
  1.         }
  2.         if (null === $entry) {
  3.             $this->record($request'miss');
  4.             return $this->fetch($request$catch);
  5.         }
  6.         if (!$this->isFreshEnough($request$entry)) {
  7.             $this->record($request'stale');
  1.                 reload the cache by fetching a fresh response and caching it (if possible).
  2.             */
  3.             $this->record($request'reload');
  4.             $response $this->fetch($request$catch);
  5.         } else {
  6.             $response $this->lookup($request$catch);
  7.         }
  8.         $this->restoreResponseBody($request$response);
  9.         if (HttpKernelInterface::MAIN_REQUEST === $type) {
  1.     {
  2.         if (!$this->booted) {
  3.             $container $this->container ?? $this->preBoot();
  4.             if ($container->has('http_cache')) {
  5.                 return $container->get('http_cache')->handle($request$type$catch);
  6.             }
  7.         }
  8.         $this->boot();
  9.         ++$this->requestStackSize;
  1.         $this->request $request;
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         $response->send();
  7.         if ($this->kernel instanceof TerminableInterface) {
  8.             $this->kernel->terminate($this->request$response);
  9.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/home/test.dombusin.com/public_html/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  2. use App\Kernel;
  3. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  4. return function (array $context) {    
  5.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  6. };

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 MariaDB server version for the right syntax to use near 'язок' GROUP BY color order by size' at line 1

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:88
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1976)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1918)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Statement.php:194)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Repository/CubeRepository.php:85)
  at App\Repository\CubeRepository->App\Repository\{closure}()
     (vendor/symfony/cache/LockRegistry.php:112)
  at Symfony\Component\Cache\LockRegistry::compute()
     (vendor/symfony/cache/Traits/ContractsTrait.php:107)
  at Symfony\Component\Cache\Adapter\TagAwareAdapter->Symfony\Component\Cache\Traits\{closure}()
     (vendor/symfony/cache-contracts/CacheTrait.php:64)
  at Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet()
     (vendor/symfony/cache/Traits/ContractsTrait.php:90)
  at Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet()
     (vendor/symfony/cache-contracts/CacheTrait.php:30)
  at Symfony\Component\Cache\Adapter\TagAwareAdapter->get()
     (src/Repository/CubeRepository.php:78)
  at App\Repository\CubeRepository->getColors()
     (src/Controller/CatalogController.php:476)
  at App\Controller\CatalogController->prodList()
     (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()
     (vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php:86)
  at Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:457)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
     (vendor/symfony/framework-bundle/HttpCache/HttpCache.php:71)
  at Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward()
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:430)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:328)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:212)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
     (vendor/symfony/http-kernel/Kernel.php:193)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/home/test.dombusin.com/public_html/vendor/autoload_runtime.php')
     (public/index.php:5)                
[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 MariaDB server version for the right syntax to use near 'язок' GROUP BY color order by size' at line 1

  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:132)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php:65)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:190)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Repository/CubeRepository.php:85)
  at App\Repository\CubeRepository->App\Repository\{closure}()
     (vendor/symfony/cache/LockRegistry.php:112)
  at Symfony\Component\Cache\LockRegistry::compute()
     (vendor/symfony/cache/Traits/ContractsTrait.php:107)
  at Symfony\Component\Cache\Adapter\TagAwareAdapter->Symfony\Component\Cache\Traits\{closure}()
     (vendor/symfony/cache-contracts/CacheTrait.php:64)
  at Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet()
     (vendor/symfony/cache/Traits/ContractsTrait.php:90)
  at Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet()
     (vendor/symfony/cache-contracts/CacheTrait.php:30)
  at Symfony\Component\Cache\Adapter\TagAwareAdapter->get()
     (src/Repository/CubeRepository.php:78)
  at App\Repository\CubeRepository->getColors()
     (src/Controller/CatalogController.php:476)
  at App\Controller\CatalogController->prodList()
     (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()
     (vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php:86)
  at Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:457)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
     (vendor/symfony/framework-bundle/HttpCache/HttpCache.php:71)
  at Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward()
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:430)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:328)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:212)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
     (vendor/symfony/http-kernel/Kernel.php:193)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/home/test.dombusin.com/public_html/vendor/autoload_runtime.php')
     (public/index.php:5)                
[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 MariaDB server version for the right syntax to use near 'язок' GROUP BY color order by size' at line 1

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130
  at PDOStatement->execute()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php:65)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:190)
  at Doctrine\DBAL\Statement->execute()
     (vendor/doctrine/dbal/src/Statement.php:224)
  at Doctrine\DBAL\Statement->executeQuery()
     (src/Repository/CubeRepository.php:85)
  at App\Repository\CubeRepository->App\Repository\{closure}()
     (vendor/symfony/cache/LockRegistry.php:112)
  at Symfony\Component\Cache\LockRegistry::compute()
     (vendor/symfony/cache/Traits/ContractsTrait.php:107)
  at Symfony\Component\Cache\Adapter\TagAwareAdapter->Symfony\Component\Cache\Traits\{closure}()
     (vendor/symfony/cache-contracts/CacheTrait.php:64)
  at Symfony\Component\Cache\Adapter\TagAwareAdapter->contractsGet()
     (vendor/symfony/cache/Traits/ContractsTrait.php:90)
  at Symfony\Component\Cache\Adapter\TagAwareAdapter->doGet()
     (vendor/symfony/cache-contracts/CacheTrait.php:30)
  at Symfony\Component\Cache\Adapter\TagAwareAdapter->get()
     (src/Repository/CubeRepository.php:78)
  at App\Repository\CubeRepository->getColors()
     (src/Controller/CatalogController.php:476)
  at App\Controller\CatalogController->prodList()
     (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()
     (vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php:86)
  at Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle()
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:457)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->forward()
     (vendor/symfony/framework-bundle/HttpCache/HttpCache.php:71)
  at Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward()
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:430)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch()
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:328)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup()
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:212)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->handle()
     (vendor/symfony/http-kernel/Kernel.php:193)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:29)
  at require_once('/home/test.dombusin.com/public_html/vendor/autoload_runtime.php')
     (public/index.php:5)