Symfony Profiler

"dataset/4136/xlsx/download_excel"

"error_controller"

"14db8b"

Doctrine\DBAL\Exception\SyntaxErrorException {#1439
  -driverException: Doctrine\DBAL\Driver\PDO\Exception {#1353 …}
  #message: """
    An exception occurred while executing 'SELECT * FROM crosstab('select a.row_id, b.id, a.isi \n
                    from t_data a \n
                    join t_variabel b \n
                    on a.variabel_id = b.id \n
                    where a.pub_id = 4136 and b.is_tampil is true  order by 1, 2')\n
                    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':\n
    \n
    SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "0"\n
    LINE 6: ...iode_update text, kecamatan text, puskesmas text, 0_sampai_4...\n
                                                                 ^
    """
  #code: 0
  #file: "/var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php"
  #line: 73
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#1353 …}
  trace: {
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php:73 {
      Doctrine\DBAL\Driver\AbstractPostgreSQLDriver->convertException($message, DriverException $exception) …
      › case '42601':
      ›     return new SyntaxErrorException($message, $exception);
      › 
    }
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182 {
      Doctrine\DBAL\DBALException::wrapException(Driver $driver, Throwable $driverEx, string $msg) …
      › if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DeprecatedDriverException) {
      ›     return $driver->convertException($msg, $driverEx);
      › }
    }
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:159 {
      Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Driver $driver, Throwable $driverEx, $sql, array $params = []) …
      › 
      ›     return self::wrapException($driver, $driverEx, $msg);
      › }
    }
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:2226 {
      Doctrine\DBAL\Connection->handleExceptionDuringQuery(Throwable $e, string $sql, array $params = [], array $types = []): void …
      ›     $sql,
      ›     $this->resolveParams($params, $types)
      › )
    }
    /var/www/html/open_data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:185 {
      Doctrine\DBAL\Statement->execute($params = null) …
      › 
      ›     $this->conn->handleExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
      › }
    }
    /var/www/html/open_data/src/Controller/Base/BaseController.php:321 {
      App\Controller\Base\BaseController->getDataTable($id, $limit, $page, $get, $state = null, $row = null) …
      › $stmt = $connection->prepare($sql);
      › $stmt->execute();
      › $result = array();
    }
    /var/www/html/open_data/src/Controller/Frontend/DatasetController.php:321 {
      App\Controller\Frontend\DatasetController->downloadExcel(?string $id, string $tipe, TPublikasiRepository $tPublikasiRepo, TVariabelRepository $tVariabelRepo) …
      › $variabel = $tVariabelRepo->findBy(['pub' => $id, 'is_tampil' => true], ['id' => 'asc']);
      › $dataset = $this->getDataTable($id, null, null, null);
      › 
    }
    /var/www/html/open_data/vendor/symfony/http-kernel/HttpKernel.php:163 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › // call controller
      › $response = $controller(...$arguments);
      › 
    }
    /var/www/html/open_data/vendor/symfony/http-kernel/HttpKernel.php:75 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->handleRaw($request, $type);
      › } catch (\Exception $e) {
    }
    /var/www/html/open_data/vendor/symfony/http-kernel/Kernel.php:202 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->getHttpKernel()->handle($request, $type, $catch);
      › } finally {
    }
    /var/www/html/open_data/public/index.php:20 {
      › $request = Request::createFromGlobals();
      › $response = $kernel->handle($request);
      › $response->send();
    }
  }
}

null

"*/*"

"gzip, br, zstd, deflate"

""

"close"

"opendata.kedirikab.go.id"

"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"

"192.168.60.9"

"https"

"https"

"1"

"192.168.60.9"

"no-cache, private"

"text/html; charset=UTF-8"

"Fri, 22 Nov 2024 05:21:51 GMT"

"An%20exception%20occurred%20while%20executing%20%27SELECT%20%2A%20FROM%20crosstab%28%27select%20a.row_id%2C%20b.id%2C%20a.isi%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20from%20t_data%20a%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20join%20t_variabel%20b%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20on%20a.variabel_id%20%3D%20b.id%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20where%20a.pub_id%20%3D%204136%20and%20b.is_tampil%20is%20true%20%20order%20by%201%2C%202%27%29%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20AS%20ct%20%28row_id%20int%2C%20periode_update%20text%2C%20kecamatan%20text%2C%20puskesmas%20text%2C%200_sampai_4_tahun_l%20text%2C%200_sampai_4_tahun_p%20text%2C%205_sampai_6_tahun_l%20text%2C%205_sampai_6_tahun_p%20text%2C%207_sampai_4_tahun_l%20text%2C%207_sampai_14_tahun_p%20text%2C%2015_sampai_59_tahun_l%20text%2C%2015_sampai_59_tahun_p%20text%2C%20lebih_besar_atau_sama_dengan_60_tahun_l%20text%2C%20lebih_besar_atau_sama_dengan_60_tahun_p%20text%2C%20total_l%20text%2C%20total_p%20text%29%20where%201%3D1%27%3A%0A%0ASQLSTATE%5B42601%5D%3A%20Syntax%20error%3A%207%20ERROR%3A%20%20syntax%20error%20at%20or%20near%20%220%22%0ALINE%206%3A%20...iode_update%20text%2C%20kecamatan%20text%2C%20puskesmas%20text%2C%200_sampai_4...%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%5E"

"%2Fvar%2Fwww%2Fhtml%2Fopen_data%2Fvendor%2Fdoctrine%2Fdbal%2Flib%2FDoctrine%2FDBAL%2FDriver%2FAbstractPostgreSQLDriver.php:73"

"778ec7"

"4a81432adf56aeb6aadfffa65ab70ab1"

"http://172.16.16.68/api_/opendata.php"

"Jl. Sekartaji No.2, Sumber, Doko, Kec. Ngasem, Kabupaten Kediri, Jawa Timur"

"Telp. (0354) 682152"

""

"Kabupaten Kediri"

"Kabupaten Kediri"

"dev"

"assets/logo/logo_masbup.png"

"assets/logo/kota_kediri.png"

"Open Data Kediri"

"302717838b52f3d1699a25e8e3ef6a9d"

"#b20238;"

"#e8d21d;"

"#039fbe;"

"#cf1578;"

"postgresql://postgres:opendata2022!@127.0.0.1:5432/open_data_kediri?serverVersion=13&charset=utf8"

"assets/logo/logo_masbup_merah.png"

"1"

"/var/www/html/open_data/public/"

""

"/var/www/html/open_data/public/"

"CGI/1.1"

"*/*"

"gzip, br, zstd, deflate"

""

"close"

"opendata.kedirikab.go.id"

"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"

"192.168.60.9"

"https"

"https"

"192.168.60.9"

"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"

"/index.php"

"p=dataset/4136/xlsx/download_excel"

"p=dataset/4136/xlsx/download_excel"

"200"

"/dataset/4136/xlsx/download_excel"

"172.16.25.100"

"39216"

"GET"

"http"

1732252911

1732252911.2953

"/dataset/4136/xlsx/download_excel"

"/var/www/html/open_data/public/index.php"

"/index.php"

"172.16.16.52"

"[no address given]"

"opendata.kedirikab.go.id"

"80"

"HTTP/1.1"

""

"Apache"

"APP_ENV,APP_SECRET,DATABASE_URL,API_URL,API_TOKEN,APP_NAME,OPEN_DATA_ICON,APP_ICON,APP_ICON_LOGO,APP_CLIENT_NAME,APP_CLIENT_SHORTNAME,APP_CLIENT_ADDRESS,APP_CLIENT_CONTACT,APP_CLIENT_EMAIL,COLOR_PRIMARY,COLOR_WARNING,COLOR_INFO,COLOR_DANGER"

"App\Controller\Frontend\DatasetController::downloadExcel"

"security.firewall.map.context.main"

true

"dataset_excel"

[
  "id" => "4136"
  "tipe" => "xlsx"
]

"_security_main"

"7928c3"

"4136"

"xlsx"