http://opendata.kedirikab.go.id/index.php/dataset/3815/csv/download_excel

Forwarded to
ErrorController (adf6e9)
Method
GET
HTTP Status
500
IP
172.16.25.100
Profiled on
Token
4486b2

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 = 3815 and b.is_tampil is true order by 1, 2')
AS ct (row_id int, periode_update text, no text, indikator text, satuan text, 2020 text, 2021 text, 2022 text) where 1=1':

SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "2020"
LINE 6: ...pdate text, no text, indikator text, satuan text, 2020 text,...
^

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 "2020" LINE 6: ...pdate text, no text, indikator text, satuan text, 2020 text,... ^

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 "2020" LINE 6: ...pdate text, no text, indikator text, satuan text, 2020 text,... ^

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 = 3815 and b.is_tampil is true  order by 1, 2')
                AS ct (row_id int, periode_update text, no text, indikator text, satuan text, 2020 text, 2021 text, 2022 text) where 1=1':

SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "2020"
LINE 6: ...pdate text, no text, indikator text, satuan text, 2020 text,...
                                                             ^

  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 "2020"
LINE 6: ...pdate text, no text, indikator text, satuan text, 2020 text,...
                                                             ^

  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 "2020"
LINE 6: ...pdate text, no text, indikator text, satuan text, 2020 text,...
                                                             ^

  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)