http://opendata.kedirikab.go.id/dataset/4136/xlsx/download_excel?p=dataset%2F4136%2Fxlsx%2Fdownload_excel

Exceptions

An exception occurred while executing 'SELECT * FROM crosstab('select a.row_id, b.id, a.isi
from t_data a
join t_variabel b
on a.variabel_id = b.id
where a.pub_id = 4136 and b.is_tampil is true order by 1, 2')
AS ct (row_id int, periode_update text, kecamatan text, puskesmas text, 0_sampai_4_tahun_l text, 0_sampai_4_tahun_p text, 5_sampai_6_tahun_l text, 5_sampai_6_tahun_p text, 7_sampai_4_tahun_l text, 7_sampai_14_tahun_p text, 15_sampai_59_tahun_l text, 15_sampai_59_tahun_p text, lebih_besar_atau_sama_dengan_60_tahun_l text, lebih_besar_atau_sama_dengan_60_tahun_p text, total_l text, total_p text) where 1=1':

SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "0"
LINE 6: ...iode_update text, kecamatan text, puskesmas text, 0_sampai_4...
^

Exceptions 3

Doctrine\DBAL\Exception\ SyntaxErrorException

  1.             case '23505':
  2.                 return new UniqueConstraintViolationException($message$exception);
  3.             case '42601':
  4.                 return new SyntaxErrorException($message$exception);
  5.             case '42702':
  6.                 return new NonUniqueFieldNameException($message$exception);
  7.             case '42703':
  1.         if ($driverEx instanceof DriverException) {
  2.             return $driverEx;
  3.         }
  4.         if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DeprecatedDriverException) {
  5.             return $driver->convertException($msg$driverEx);
  6.         }
  7.         return new Exception($msg0$driverEx);
  8.     }
  1.             $msg .= ' with params ' self::formatParameters($params);
  2.         }
  3.         $msg .= ":\n\n" $driverEx->getMessage();
  4.         return self::wrapException($driver$driverEx$msg);
  5.     }
  6.     /**
  7.      * @deprecated
  8.      *
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php :: driverExceptionDuringQuery (line 2226)
  1.         $this->throw(
  2.             Exception::driverExceptionDuringQuery(
  3.                 $this->_driver,
  4.                 $e,
  5.                 $sql,
  6.                 $this->resolveParams($params$types)
  7.             )
  8.         );
  9.     }
  10.     /**
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php -> handleExceptionDuringQuery (line 185)
  1.         } catch (Throwable $ex) {
  2.             if ($logger) {
  3.                 $logger->stopQuery();
  4.             }
  5.             $this->conn->handleExceptionDuringQuery($ex$this->sql$this->params$this->types);
  6.         }
  7.         if ($logger) {
  8.             $logger->stopQuery();
  9.         }
Statement->execute() in src/Controller/Base/BaseController.php (line 321)
  1.         if ($page) {
  2.             $sql .= " OFFSET " $page;
  3.         }
  4.         $stmt $connection->prepare($sql);
  5.         $stmt->execute();
  6.         $result = array();
  7.         foreach ($stmt->fetchAll() as $data) {
  8.             $temp = array();
  9.             if ($state) {
  10.                 $temp['id'] = $data['row_id'];
BaseController->getDataTable() in src/Controller/Frontend/DatasetController.php (line 321)
  1.         $entityManager $this->getDoctrine()->getManager();
  2.         $entityManager->persist($publikasi);
  3.         $entityManager->flush();
  4.         $variabel $tVariabelRepo->findBy(['pub' => $id'is_tampil' => true], ['id' => 'asc']);
  5.         $dataset $this->getDataTable($idnullnullnull);
  6.         $styleFontCenter = array(
  7.             'alignment' => array('horizontal' => Alignment::HORIZONTAL_CENTER)
  8.         );
in vendor/symfony/http-kernel/HttpKernel.php -> downloadExcel (line 163)
  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 20)
  1.     Debug::enable();
  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[42601]: Syntax error: 7 ERROR: syntax error at or near "0" LINE 6: ...iode_update text, kecamatan text, puskesmas text, 0_sampai_4... ^

  1.  */
  2. final class Exception extends PDOException
  3. {
  4.     public static function new(\PDOException $exception): self
  5.     {
  6.         return new self($exception);
  7.     }
  8. }
  1.     public function execute($params null)
  2.     {
  3.         try {
  4.             return parent::execute($params);
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  8.     }
  9.     /**
  10.      * {@inheritdoc}
  1.         if ($logger) {
  2.             $logger->startQuery($this->sql$this->params$this->types);
  3.         }
  4.         try {
  5.             $stmt $this->stmt->execute($params);
  6.         } catch (Throwable $ex) {
  7.             if ($logger) {
  8.                 $logger->stopQuery();
  9.             }
Statement->execute() in src/Controller/Base/BaseController.php (line 321)
  1.         if ($page) {
  2.             $sql .= " OFFSET " $page;
  3.         }
  4.         $stmt $connection->prepare($sql);
  5.         $stmt->execute();
  6.         $result = array();
  7.         foreach ($stmt->fetchAll() as $data) {
  8.             $temp = array();
  9.             if ($state) {
  10.                 $temp['id'] = $data['row_id'];
BaseController->getDataTable() in src/Controller/Frontend/DatasetController.php (line 321)
  1.         $entityManager $this->getDoctrine()->getManager();
  2.         $entityManager->persist($publikasi);
  3.         $entityManager->flush();
  4.         $variabel $tVariabelRepo->findBy(['pub' => $id'is_tampil' => true], ['id' => 'asc']);
  5.         $dataset $this->getDataTable($idnullnullnull);
  6.         $styleFontCenter = array(
  7.             'alignment' => array('horizontal' => Alignment::HORIZONTAL_CENTER)
  8.         );
in vendor/symfony/http-kernel/HttpKernel.php -> downloadExcel (line 163)
  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 20)
  1.     Debug::enable();
  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[42601]: Syntax error: 7 ERROR: syntax error at or near "0" LINE 6: ...iode_update text, kecamatan text, puskesmas text, 0_sampai_4... ^

  1.      */
  2.     #[ReturnTypeWillChange]
  3.     public function execute($params null)
  4.     {
  5.         try {
  6.             return parent::execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  10.     }
  1.      */
  2.     #[ReturnTypeWillChange]
  3.     public function execute($params null)
  4.     {
  5.         try {
  6.             return parent::execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  10.     }
  1.         if ($logger) {
  2.             $logger->startQuery($this->sql$this->params$this->types);
  3.         }
  4.         try {
  5.             $stmt $this->stmt->execute($params);
  6.         } catch (Throwable $ex) {
  7.             if ($logger) {
  8.                 $logger->stopQuery();
  9.             }
Statement->execute() in src/Controller/Base/BaseController.php (line 321)
  1.         if ($page) {
  2.             $sql .= " OFFSET " $page;
  3.         }
  4.         $stmt $connection->prepare($sql);
  5.         $stmt->execute();
  6.         $result = array();
  7.         foreach ($stmt->fetchAll() as $data) {
  8.             $temp = array();
  9.             if ($state) {
  10.                 $temp['id'] = $data['row_id'];
BaseController->getDataTable() in src/Controller/Frontend/DatasetController.php (line 321)
  1.         $entityManager $this->getDoctrine()->getManager();
  2.         $entityManager->persist($publikasi);
  3.         $entityManager->flush();
  4.         $variabel $tVariabelRepo->findBy(['pub' => $id'is_tampil' => true], ['id' => 'asc']);
  5.         $dataset $this->getDataTable($idnullnullnull);
  6.         $styleFontCenter = array(
  7.             'alignment' => array('horizontal' => Alignment::HORIZONTAL_CENTER)
  8.         );
in vendor/symfony/http-kernel/HttpKernel.php -> downloadExcel (line 163)
  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 20)
  1.     Debug::enable();
  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 'SELECT * FROM crosstab('select a.row_id, b.id, a.isi 
                from t_data a 
                join t_variabel b 
                on a.variabel_id = b.id 
                where a.pub_id = 4136 and b.is_tampil is true  order by 1, 2')
                AS ct (row_id int, periode_update text, kecamatan text, puskesmas text, 0_sampai_4_tahun_l text, 0_sampai_4_tahun_p text, 5_sampai_6_tahun_l text, 5_sampai_6_tahun_p text, 7_sampai_4_tahun_l text, 7_sampai_14_tahun_p text, 15_sampai_59_tahun_l text, 15_sampai_59_tahun_p text, lebih_besar_atau_sama_dengan_60_tahun_l text, lebih_besar_atau_sama_dengan_60_tahun_p text, total_l text, total_p text) where 1=1':

SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "0"
LINE 6: ...iode_update text, kecamatan text, puskesmas text, 0_sampai_4...
                                                             ^

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php:73
  at Doctrine\DBAL\Driver\AbstractPostgreSQLDriver->convertException()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182)
  at Doctrine\DBAL\DBALException::wrapException()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159)
  at Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2226)
  at Doctrine\DBAL\Connection->handleExceptionDuringQuery()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:185)
  at Doctrine\DBAL\Statement->execute()
     (src/Controller/Base/BaseController.php:321)
  at App\Controller\Base\BaseController->getDataTable()
     (src/Controller/Frontend/DatasetController.php:321)
  at App\Controller\Frontend\DatasetController->downloadExcel()
     (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:20)                
[2/3] Exception
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "0"
LINE 6: ...iode_update text, kecamatan text, puskesmas text, 0_sampai_4...
                                                             ^

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119)
  at Doctrine\DBAL\Driver\PDOStatement->execute()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:179)
  at Doctrine\DBAL\Statement->execute()
     (src/Controller/Base/BaseController.php:321)
  at App\Controller\Base\BaseController->getDataTable()
     (src/Controller/Frontend/DatasetController.php:321)
  at App\Controller\Frontend\DatasetController->downloadExcel()
     (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:20)                
[1/3] PDOException
PDOException:
SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "0"
LINE 6: ...iode_update text, kecamatan text, puskesmas text, 0_sampai_4...
                                                             ^

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
  at PDOStatement->execute()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)
  at Doctrine\DBAL\Driver\PDOStatement->execute()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:179)
  at Doctrine\DBAL\Statement->execute()
     (src/Controller/Base/BaseController.php:321)
  at App\Controller\Base\BaseController->getDataTable()
     (src/Controller/Frontend/DatasetController.php:321)
  at App\Controller\Frontend\DatasetController->downloadExcel()
     (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:20)