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

Method
GET
HTTP Status
500
IP
172.16.25.100
Profiled on
Token
33d43a

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 = 4139 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 = 4139 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)