http://opendata.kedirikab.go.id/index.php/dataset/4140/xlsx/download_excel

Forwarded to
ErrorController (55ef61)
Method
GET
HTTP Status
500
IP
172.16.25.100
Profiled on
Token
7e236e

Exceptions

PDOException Exception SyntaxErrorException

HTTP 500 Internal Server Error

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 = 4140 and b.is_tampil is true order by 1, 2')
AS ct (row_id int, periode_update text, kecamatan text, faskes_pemberi_layanan_vaksinasi_covid_19__pkm_rs_klinik_dll_ text, usia_6_11_tahun__anak__sasaran text, usia_6_11_tahun__anak__hasil text, usia_6_11_tahun__anak__persen text, usia_12_17_tahun__remaja__sasaran text, usia_12_17_tahun__remaja__hasil text, usia_12_17_tahun__remaja__persen text, usia_18_59_tahun__masyarakat_umum__sasaran text, usia_18_59_tahun__masyarakat_umum__hasil text, usia_18_59_tahun__masyarakat_umum__persen text, usia_>=_60_tahun_lansia_sasaran text, usia_>=_60_tahun_lansia__hasil text, usia_>=_60_tahun_lansia_persen text, cakupan_total_sasaran text, cakupan_total_hasil text, cakupan_total_persen text) where 1=1':

SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ">="
LINE 6: ...a_18_59_tahun__masyarakat_umum__persen text, usia_>=_60_tahu...
^

Exceptions 3

Doctrine\DBAL\Exception\ SyntaxErrorException

in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php (line 73)
  2.             case '23505':
  3.                 return new UniqueConstraintViolationException($message, $exception);
  5.             case '42601':
  6.                 return new SyntaxErrorException($message, $exception);
  8.             case '42702':
  9.                 return new NonUniqueFieldNameException($message, $exception);
  11.             case '42703':
in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php -> convertException (line 182)
  1.         if ($driverEx instanceof DriverException) {
  2.             return $driverEx;
  3.         }
  5.         if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DeprecatedDriverException) {
  6.             return $driver->convertException($msg, $driverEx);
  7.         }
  9.         return new Exception($msg, 0, $driverEx);
  10.     }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php :: wrapException (line 159)
  1.             $msg .= ' with params ' . self::formatParameters($params);
  2.         }
  4.         $msg .= ":\n\n" . $driverEx->getMessage();
  6.         return self::wrapException($driver, $driverEx, $msg);
  7.     }
  9.     /**
  10.      * @deprecated
  11.      *
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.     }
  11.     /**
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php -> handleExceptionDuringQuery (line 185)
  1.         } catch (Throwable $ex) {
  2.             if ($logger) {
  3.                 $logger->stopQuery();
  4.             }
  6.             $this->conn->handleExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  7.         }
  9.         if ($logger) {
  10.             $logger->stopQuery();
  11.         }
Statement->execute() in src/Controller/Base/BaseController.php (line 321)
  1.         if ($page) {
  2.             $sql .= " OFFSET " . $page;
  3.         }
  5.         $stmt = $connection->prepare($sql);
  6.         $stmt->execute();
  7.         $result = array();
  8.         foreach ($stmt->fetchAll() as $data) {
  9.             $temp = array();
  10.             if ($state) {
  11.                 $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();
  5.         $variabel = $tVariabelRepo->findBy(['pub' => $id, 'is_tampil' => true], ['id' => 'asc']);
  6.         $dataset = $this->getDataTable($id, null, null, null);
  8.         $styleFontCenter = array(
  9.             'alignment' => array('horizontal' => Alignment::HORIZONTAL_CENTER)
  10.         );
in vendor/symfony/http-kernel/HttpKernel.php -> downloadExcel (line 163)
  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 75)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  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 202)
  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 20)
  1.     Debug::enable();
  2. }
  4. $kernel = new Kernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  5. $request = Request::createFromGlobals();
  6. $response = $kernel->handle($request);
  7. $response->send();
  8. $kernel->terminate($request, $response);

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ">=" LINE 6: ...a_18_59_tahun__masyarakat_umum__persen text, usia_>=_60_tahu... ^

in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php (line 18)
  1.  */
  2. final class Exception extends PDOException
  3. {
  4.     public static function new(\PDOException $exception): self
  5.     {
  6.         return new self($exception);
  7.     }
  8. }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php :: new (line 119)
  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.     }
  10.     /**
  11.      * {@inheritdoc}
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php -> execute (line 179)
  1.         if ($logger) {
  2.             $logger->startQuery($this->sql, $this->params, $this->types);
  3.         }
  5.         try {
  6.             $stmt = $this->stmt->execute($params);
  7.         } catch (Throwable $ex) {
  8.             if ($logger) {
  9.                 $logger->stopQuery();
  10.             }
Statement->execute() in src/Controller/Base/BaseController.php (line 321)
  1.         if ($page) {
  2.             $sql .= " OFFSET " . $page;
  3.         }
  5.         $stmt = $connection->prepare($sql);
  6.         $stmt->execute();
  7.         $result = array();
  8.         foreach ($stmt->fetchAll() as $data) {
  9.             $temp = array();
  10.             if ($state) {
  11.                 $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();
  5.         $variabel = $tVariabelRepo->findBy(['pub' => $id, 'is_tampil' => true], ['id' => 'asc']);
  6.         $dataset = $this->getDataTable($id, null, null, null);
  8.         $styleFontCenter = array(
  9.             'alignment' => array('horizontal' => Alignment::HORIZONTAL_CENTER)
  10.         );
in vendor/symfony/http-kernel/HttpKernel.php -> downloadExcel (line 163)
  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 75)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  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 202)
  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 20)
  1.     Debug::enable();
  2. }
  4. $kernel = new Kernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  5. $request = Request::createFromGlobals();
  6. $response = $kernel->handle($request);
  7. $response->send();
  8. $kernel->terminate($request, $response);

PDOException

SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ">=" LINE 6: ...a_18_59_tahun__masyarakat_umum__persen text, usia_>=_60_tahu... ^

in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php (line 117)
  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.     }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php -> execute (line 117)
  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.     }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php -> execute (line 179)
  1.         if ($logger) {
  2.             $logger->startQuery($this->sql, $this->params, $this->types);
  3.         }
  5.         try {
  6.             $stmt = $this->stmt->execute($params);
  7.         } catch (Throwable $ex) {
  8.             if ($logger) {
  9.                 $logger->stopQuery();
  10.             }
Statement->execute() in src/Controller/Base/BaseController.php (line 321)
  1.         if ($page) {
  2.             $sql .= " OFFSET " . $page;
  3.         }
  5.         $stmt = $connection->prepare($sql);
  6.         $stmt->execute();
  7.         $result = array();
  8.         foreach ($stmt->fetchAll() as $data) {
  9.             $temp = array();
  10.             if ($state) {
  11.                 $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();
  5.         $variabel = $tVariabelRepo->findBy(['pub' => $id, 'is_tampil' => true], ['id' => 'asc']);
  6.         $dataset = $this->getDataTable($id, null, null, null);
  8.         $styleFontCenter = array(
  9.             'alignment' => array('horizontal' => Alignment::HORIZONTAL_CENTER)
  10.         );
in vendor/symfony/http-kernel/HttpKernel.php -> downloadExcel (line 163)
  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 75)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  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 202)
  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 20)
  1.     Debug::enable();
  2. }
  4. $kernel = new Kernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  5. $request = Request::createFromGlobals();
  6. $response = $kernel->handle($request);
  7. $response->send();
  8. $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 = 4140 and b.is_tampil is true  order by 1, 2')
                AS ct (row_id int, periode_update text, kecamatan text, faskes_pemberi_layanan_vaksinasi_covid_19__pkm_rs_klinik_dll_ text, usia_6_11_tahun__anak__sasaran text, usia_6_11_tahun__anak__hasil text, usia_6_11_tahun__anak__persen text, usia_12_17_tahun__remaja__sasaran text, usia_12_17_tahun__remaja__hasil text, usia_12_17_tahun__remaja__persen text, usia_18_59_tahun__masyarakat_umum__sasaran text, usia_18_59_tahun__masyarakat_umum__hasil text, usia_18_59_tahun__masyarakat_umum__persen text, usia_>=_60_tahun_lansia_sasaran text, usia_>=_60_tahun_lansia__hasil text, usia_>=_60_tahun_lansia_persen text, cakupan_total_sasaran text, cakupan_total_hasil text, cakupan_total_persen text) where 1=1':

SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near ">="
LINE 6: ...a_18_59_tahun__masyarakat_umum__persen text, usia_>=_60_tahu...
                                                             ^

  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 ">="
LINE 6: ...a_18_59_tahun__masyarakat_umum__persen text, usia_>=_60_tahu...
                                                             ^

  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 ">="
LINE 6: ...a_18_59_tahun__masyarakat_umum__persen text, usia_>=_60_tahu...
                                                             ^

  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)