php error happened
| Technical information | |
| Error type | 256 |
| Error description | You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 163 |
| URL | satsdn.bbksdajatim.org/print.php? |
| Error file | /home2/bbksdaja/public_html/satsdn/connections/Connection.php |
| Error line | 611 |
| SQL query | SELECT data_sats.id_sats, data_sats.serial, ktr_balai.nama as balai, DATE_FORMAT ( data_sats.tgl_sats, '%d %M %Y' ) as tgl_sats, COALESCE ( ktr_seksi.nama, ktr_bidang.nama, '---' ) AS kantor, concat( users.no_depan, data_sats.nomor, users.no_tengah, DATE_FORMAT ( data_sats.tgl_sats, '%m/%Y' )) AS nosats, DATE_FORMAT ( data_sats.tgl_berlaku_awal, '%d %M' ) AS mulai, DATE_FORMAT ( data_sats.tgl_berlaku_akhir, '%d %M %Y' ) AS berakhir, ( SELECT ifnull(perusahaan.izin, '---') FROM perusahaan WHERE data_sats.pengirim = perusahaan.id ) AS izinpengirim, ( SELECT ifnull(DATE_FORMAT (perusahaan.tglizin,'%d %M %Y' ), '---') FROM perusahaan WHERE data_sats.pengirim = perusahaan.id) AS tglizin, IFNULL( data_sats.no_permohonan, '---' ) AS nomohon, ifNULL( DATE_FORMAT ( data_sats.tgl_permohonan,'%d %M %Y'), '---' ) AS tglmohon, IFNULL( data_sats.no_bap, '---' ) AS nobap, IFNULL( DATE_FORMAT ( data_sats.tgl_bap,'%d %M %Y'), '---' ) AS tglbap, |