You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
397 lines
36 KiB
397 lines
36 KiB
INFO - 2024-05-19 15:49:07 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. |
|
INFO - 2024-05-19 15:49:08 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. |
|
WARNING - 2024-05-19 15:49:35 --> [DEPRECATED] number_format(): Passing null to parameter #1 ($num) of type float is deprecated in APPPATH\Views\kanwil\dashboard.php on line 527. |
|
1 APPPATH\Views\kanwil\dashboard.php(527): number_format(null, 0, ',', '.') |
|
2 SYSTEMPATH\View\View.php(228): include('C:\\xampp\\htdocs\\engineN\\app\\Views\\kanwil\\dashboard.php') |
|
3 SYSTEMPATH\View\View.php(231): CodeIgniter\View\View->CodeIgniter\View\{closure}() |
|
4 SYSTEMPATH\Common.php(1178): CodeIgniter\View\View->render('kanwil/dashboard', [], true) |
|
5 APPPATH\Controllers\Kanwil.php(74): view('kanwil/dashboard', [...]) |
|
6 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Kanwil->index() |
|
7 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Kanwil)) |
|
8 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) |
|
9 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run() |
|
WARNING - 2024-05-19 15:49:35 --> [DEPRECATED] number_format(): Passing null to parameter #1 ($num) of type float is deprecated in APPPATH\Views\kanwil\dashboard.php on line 528. |
|
1 APPPATH\Views\kanwil\dashboard.php(528): number_format(null, 0, ',', '.') |
|
2 SYSTEMPATH\View\View.php(228): include('C:\\xampp\\htdocs\\engineN\\app\\Views\\kanwil\\dashboard.php') |
|
3 SYSTEMPATH\View\View.php(231): CodeIgniter\View\View->CodeIgniter\View\{closure}() |
|
4 SYSTEMPATH\Common.php(1178): CodeIgniter\View\View->render('kanwil/dashboard', [], true) |
|
5 APPPATH\Controllers\Kanwil.php(74): view('kanwil/dashboard', [...]) |
|
6 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Kanwil->index() |
|
7 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Kanwil)) |
|
8 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) |
|
9 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run() |
|
WARNING - 2024-05-19 15:49:35 --> [DEPRECATED] number_format(): Passing null to parameter #1 ($num) of type float is deprecated in APPPATH\Views\kanwil\dashboard.php on line 531. |
|
1 APPPATH\Views\kanwil\dashboard.php(531): number_format(null, 0, ',', '.') |
|
2 SYSTEMPATH\View\View.php(228): include('C:\\xampp\\htdocs\\engineN\\app\\Views\\kanwil\\dashboard.php') |
|
3 SYSTEMPATH\View\View.php(231): CodeIgniter\View\View->CodeIgniter\View\{closure}() |
|
4 SYSTEMPATH\Common.php(1178): CodeIgniter\View\View->render('kanwil/dashboard', [], true) |
|
5 APPPATH\Controllers\Kanwil.php(74): view('kanwil/dashboard', [...]) |
|
6 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Kanwil->index() |
|
7 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Kanwil)) |
|
8 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) |
|
9 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run() |
|
WARNING - 2024-05-19 15:49:35 --> [DEPRECATED] number_format(): Passing null to parameter #1 ($num) of type float is deprecated in APPPATH\Views\kanwil\dashboard.php on line 532. |
|
1 APPPATH\Views\kanwil\dashboard.php(532): number_format(null, 0, ',', '.') |
|
2 SYSTEMPATH\View\View.php(228): include('C:\\xampp\\htdocs\\engineN\\app\\Views\\kanwil\\dashboard.php') |
|
3 SYSTEMPATH\View\View.php(231): CodeIgniter\View\View->CodeIgniter\View\{closure}() |
|
4 SYSTEMPATH\Common.php(1178): CodeIgniter\View\View->render('kanwil/dashboard', [], true) |
|
5 APPPATH\Controllers\Kanwil.php(74): view('kanwil/dashboard', [...]) |
|
6 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Kanwil->index() |
|
7 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Kanwil)) |
|
8 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) |
|
9 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run() |
|
INFO - 2024-05-19 15:49:50 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. |
|
INFO - 2024-05-19 16:48:16 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. |
|
INFO - 2024-05-19 16:48:17 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. |
|
WARNING - 2024-05-19 16:48:22 --> [DEPRECATED] number_format(): Passing null to parameter #1 ($num) of type float is deprecated in APPPATH\Views\kanwil\dashboard.php on line 527. |
|
1 APPPATH\Views\kanwil\dashboard.php(527): number_format(null, 0, ',', '.') |
|
2 SYSTEMPATH\View\View.php(228): include('C:\\xampp\\htdocs\\engineN\\app\\Views\\kanwil\\dashboard.php') |
|
3 SYSTEMPATH\View\View.php(231): CodeIgniter\View\View->CodeIgniter\View\{closure}() |
|
4 SYSTEMPATH\Common.php(1178): CodeIgniter\View\View->render('kanwil/dashboard', [], true) |
|
5 APPPATH\Controllers\Kanwil.php(74): view('kanwil/dashboard', [...]) |
|
6 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Kanwil->index() |
|
7 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Kanwil)) |
|
8 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) |
|
9 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run() |
|
WARNING - 2024-05-19 16:48:22 --> [DEPRECATED] number_format(): Passing null to parameter #1 ($num) of type float is deprecated in APPPATH\Views\kanwil\dashboard.php on line 528. |
|
1 APPPATH\Views\kanwil\dashboard.php(528): number_format(null, 0, ',', '.') |
|
2 SYSTEMPATH\View\View.php(228): include('C:\\xampp\\htdocs\\engineN\\app\\Views\\kanwil\\dashboard.php') |
|
3 SYSTEMPATH\View\View.php(231): CodeIgniter\View\View->CodeIgniter\View\{closure}() |
|
4 SYSTEMPATH\Common.php(1178): CodeIgniter\View\View->render('kanwil/dashboard', [], true) |
|
5 APPPATH\Controllers\Kanwil.php(74): view('kanwil/dashboard', [...]) |
|
6 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Kanwil->index() |
|
7 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Kanwil)) |
|
8 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) |
|
9 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run() |
|
WARNING - 2024-05-19 16:48:22 --> [DEPRECATED] number_format(): Passing null to parameter #1 ($num) of type float is deprecated in APPPATH\Views\kanwil\dashboard.php on line 531. |
|
1 APPPATH\Views\kanwil\dashboard.php(531): number_format(null, 0, ',', '.') |
|
2 SYSTEMPATH\View\View.php(228): include('C:\\xampp\\htdocs\\engineN\\app\\Views\\kanwil\\dashboard.php') |
|
3 SYSTEMPATH\View\View.php(231): CodeIgniter\View\View->CodeIgniter\View\{closure}() |
|
4 SYSTEMPATH\Common.php(1178): CodeIgniter\View\View->render('kanwil/dashboard', [], true) |
|
5 APPPATH\Controllers\Kanwil.php(74): view('kanwil/dashboard', [...]) |
|
6 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Kanwil->index() |
|
7 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Kanwil)) |
|
8 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) |
|
9 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run() |
|
WARNING - 2024-05-19 16:48:22 --> [DEPRECATED] number_format(): Passing null to parameter #1 ($num) of type float is deprecated in APPPATH\Views\kanwil\dashboard.php on line 532. |
|
1 APPPATH\Views\kanwil\dashboard.php(532): number_format(null, 0, ',', '.') |
|
2 SYSTEMPATH\View\View.php(228): include('C:\\xampp\\htdocs\\engineN\\app\\Views\\kanwil\\dashboard.php') |
|
3 SYSTEMPATH\View\View.php(231): CodeIgniter\View\View->CodeIgniter\View\{closure}() |
|
4 SYSTEMPATH\Common.php(1178): CodeIgniter\View\View->render('kanwil/dashboard', [], true) |
|
5 APPPATH\Controllers\Kanwil.php(74): view('kanwil/dashboard', [...]) |
|
6 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Kanwil->index() |
|
7 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Kanwil)) |
|
8 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) |
|
9 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run() |
|
INFO - 2024-05-19 16:48:30 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. |
|
ERROR - 2024-05-19 16:48:30 --> ErrorException: oci_execute(): ORA-00942: table or view does not exist in C:\xampp\htdocs\engineN\system\Database\OCI8\Connection.php:199 |
|
Stack trace: |
|
#0 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(2, 'oci_execute(): ...', 'C:\\xampp\\htdocs...', 199) |
|
#1 C:\xampp\htdocs\engineN\system\Database\OCI8\Connection.php(199): oci_execute(Resource id #191, 32) |
|
#2 C:\xampp\htdocs\engineN\system\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT \r\n ...') |
|
#3 C:\xampp\htdocs\engineN\system\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT \r\n ...') |
|
#4 C:\xampp\htdocs\engineN\app\Models\Mpemby.php(381): CodeIgniter\Database\BaseConnection->query('SELECT \r\n ...') |
|
#5 C:\xampp\htdocs\engineN\app\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs(Array) |
|
#6 C:\xampp\htdocs\engineN\system\CodeIgniter.php(943): App\Controllers\Home->gmapkjs() |
|
#7 C:\xampp\htdocs\engineN\system\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home)) |
|
#8 C:\xampp\htdocs\engineN\system\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) |
|
#9 C:\xampp\htdocs\engineN\index.php(79): CodeIgniter\CodeIgniter->run() |
|
#10 {main} |
|
CRITICAL - 2024-05-19 16:48:30 --> CodeIgniter\Database\Exceptions\DatabaseException: oci_execute(): ORA-00942: table or view does not exist |
|
in SYSTEMPATH\Database\BaseConnection.php on line 647. |
|
1 APPPATH\Models\Mpemby.php(381): CodeIgniter\Database\BaseConnection->query('SELECT |
|
BLNBYR, |
|
(SELECT SUM(JUMLAH)POPULASI FROM KEWAJIBAN_FLAGN |
|
WHERE KD_MAP <> 0 AND KWLADM = \'170\' AND KD_MAP = \'\' AND KATEGORI = \'\') POPULASI, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST |
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS |
|
WHERE THNBYR BETWEEN \'2023\' AND \'2024\' AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\' |
|
GROUP BY NPWP,THNBYR,BLNBYR |
|
) |
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC |
|
') |
|
2 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...]) |
|
3 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs() |
|
4 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home)) |
|
5 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) |
|
6 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run() |
|
CRITICAL - 2024-05-19 16:48:30 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: oci_execute(): ORA-00942: table or view does not exist |
|
in SYSTEMPATH\Database\OCI8\Connection.php on line 211. |
|
1 SYSTEMPATH\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT |
|
BLNBYR, |
|
(SELECT SUM(JUMLAH)POPULASI FROM KEWAJIBAN_FLAGN |
|
WHERE KD_MAP <> 0 AND KWLADM = \'170\' AND KD_MAP = \'\' AND KATEGORI = \'\') POPULASI, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST |
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS |
|
WHERE THNBYR BETWEEN \'2023\' AND \'2024\' AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\' |
|
GROUP BY NPWP,THNBYR,BLNBYR |
|
) |
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC |
|
') |
|
2 SYSTEMPATH\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT |
|
BLNBYR, |
|
(SELECT SUM(JUMLAH)POPULASI FROM KEWAJIBAN_FLAGN |
|
WHERE KD_MAP <> 0 AND KWLADM = \'170\' AND KD_MAP = \'\' AND KATEGORI = \'\') POPULASI, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST |
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS |
|
WHERE THNBYR BETWEEN \'2023\' AND \'2024\' AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\' |
|
GROUP BY NPWP,THNBYR,BLNBYR |
|
) |
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC |
|
') |
|
3 APPPATH\Models\Mpemby.php(381): CodeIgniter\Database\BaseConnection->query('SELECT |
|
BLNBYR, |
|
(SELECT SUM(JUMLAH)POPULASI FROM KEWAJIBAN_FLAGN |
|
WHERE KD_MAP <> 0 AND KWLADM = \'170\' AND KD_MAP = \'\' AND KATEGORI = \'\') POPULASI, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST |
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS |
|
WHERE THNBYR BETWEEN \'2023\' AND \'2024\' AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\' |
|
GROUP BY NPWP,THNBYR,BLNBYR |
|
) |
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC |
|
') |
|
4 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...]) |
|
5 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs() |
|
6 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home)) |
|
7 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) |
|
8 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run() |
|
CRITICAL - 2024-05-19 16:48:30 --> [Caused by] ErrorException: oci_execute(): ORA-00942: table or view does not exist |
|
in SYSTEMPATH\Database\OCI8\Connection.php on line 199. |
|
1 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(2, 'oci_execute(): ORA-00942: table or view does not exist', 'C:\\xampp\\htdocs\\engineN\\system\\Database\\OCI8\\Connection.php', 199) |
|
2 SYSTEMPATH\Database\OCI8\Connection.php(199): oci_execute(resource (oci8 statement), 32) |
|
3 SYSTEMPATH\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT |
|
BLNBYR, |
|
(SELECT SUM(JUMLAH)POPULASI FROM KEWAJIBAN_FLAGN |
|
WHERE KD_MAP <> 0 AND KWLADM = \'170\' AND KD_MAP = \'\' AND KATEGORI = \'\') POPULASI, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST |
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS |
|
WHERE THNBYR BETWEEN \'2023\' AND \'2024\' AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\' |
|
GROUP BY NPWP,THNBYR,BLNBYR |
|
) |
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC |
|
') |
|
4 SYSTEMPATH\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT |
|
BLNBYR, |
|
(SELECT SUM(JUMLAH)POPULASI FROM KEWAJIBAN_FLAGN |
|
WHERE KD_MAP <> 0 AND KWLADM = \'170\' AND KD_MAP = \'\' AND KATEGORI = \'\') POPULASI, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST |
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS |
|
WHERE THNBYR BETWEEN \'2023\' AND \'2024\' AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\' |
|
GROUP BY NPWP,THNBYR,BLNBYR |
|
) |
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC |
|
') |
|
5 APPPATH\Models\Mpemby.php(381): CodeIgniter\Database\BaseConnection->query('SELECT |
|
BLNBYR, |
|
(SELECT SUM(JUMLAH)POPULASI FROM KEWAJIBAN_FLAGN |
|
WHERE KD_MAP <> 0 AND KWLADM = \'170\' AND KD_MAP = \'\' AND KATEGORI = \'\') POPULASI, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST |
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS |
|
WHERE THNBYR BETWEEN \'2023\' AND \'2024\' AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\' |
|
GROUP BY NPWP,THNBYR,BLNBYR |
|
) |
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC |
|
') |
|
6 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...]) |
|
7 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs() |
|
8 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home)) |
|
9 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) |
|
10 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run() |
|
CRITICAL - 2024-05-19 16:48:30 --> ErrorException: Uncaught Error: Call to undefined method CodeIgniter\Debug\ExceptionHandler::cleanPath() in C:\xampp\htdocs\engineN\app\Views\errors\html\error_exception.php:33 |
|
Stack trace: |
|
#0 C:\xampp\htdocs\engineN\system\Debug\BaseExceptionHandler.php(258): include() |
|
#1 C:\xampp\htdocs\engineN\system\Debug\BaseExceptionHandler.php(261): CodeIgniter\Debug\BaseExceptionHandler->CodeIgniter\Debug\{closure}() |
|
#2 C:\xampp\htdocs\engineN\system\Debug\ExceptionHandler.php(112): CodeIgniter\Debug\BaseExceptionHandler->render(Object(CodeIgniter\Database\Exceptions\DatabaseException), 500, 'C:\\xampp\\htdocs...') |
|
#3 C:\xampp\htdocs\engineN\system\Debug\Exceptions.php(156): CodeIgniter\Debug\ExceptionHandler->handle(Object(CodeIgniter\Database\Exceptions\DatabaseException), Object(CodeIgniter\HTTP\IncomingRequest), Object(CodeIgniter\HTTP\Response), 500, 8) |
|
#4 [internal function]: CodeIgniter\Debug\Exceptions->exceptionHandler(Object(CodeIgniter\Database\Exceptions\DatabaseException)) |
|
#5 {main} |
|
thrown |
|
【Previous Exception】 |
|
CodeIgniter\Database\Exceptions\DatabaseException |
|
oci_execute(): ORA-00942: table or view does not exist |
|
#0 C:\xampp\htdocs\engineN\app\Models\Mpemby.php(381): CodeIgniter\Database\BaseConnection->query('SELECT \r\n ...') |
|
#1 C:\xampp\htdocs\engineN\app\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs(Array) |
|
#2 C:\xampp\htdocs\engineN\system\CodeIgniter.php(943): App\Controllers\Home->gmapkjs() |
|
#3 C:\xampp\htdocs\engineN\system\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home)) |
|
#4 C:\xampp\htdocs\engineN\system\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) |
|
#5 C:\xampp\htdocs\engineN\index.php(79): CodeIgniter\CodeIgniter->run() |
|
#6 {main} |
|
in APPPATH\Views\errors\html\error_exception.php on line 33. |
|
1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler() |
|
INFO - 2024-05-19 17:11:54 --> Session: Class initialized using 'CodeIgniter\Session\Handlers\FileHandler' driver. |
|
ERROR - 2024-05-19 17:11:54 --> ErrorException: oci_execute(): ORA-00942: table or view does not exist in C:\xampp\htdocs\engineN\system\Database\OCI8\Connection.php:199 |
|
Stack trace: |
|
#0 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(2, 'oci_execute(): ...', 'C:\\xampp\\htdocs...', 199) |
|
#1 C:\xampp\htdocs\engineN\system\Database\OCI8\Connection.php(199): oci_execute(Resource id #192, 32) |
|
#2 C:\xampp\htdocs\engineN\system\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT \r\n ...') |
|
#3 C:\xampp\htdocs\engineN\system\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT \r\n ...') |
|
#4 C:\xampp\htdocs\engineN\app\Models\Mpemby.php(381): CodeIgniter\Database\BaseConnection->query('SELECT \r\n ...') |
|
#5 C:\xampp\htdocs\engineN\app\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs(Array) |
|
#6 C:\xampp\htdocs\engineN\system\CodeIgniter.php(943): App\Controllers\Home->gmapkjs() |
|
#7 C:\xampp\htdocs\engineN\system\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home)) |
|
#8 C:\xampp\htdocs\engineN\system\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) |
|
#9 C:\xampp\htdocs\engineN\index.php(79): CodeIgniter\CodeIgniter->run() |
|
#10 {main} |
|
CRITICAL - 2024-05-19 17:11:54 --> CodeIgniter\Database\Exceptions\DatabaseException: oci_execute(): ORA-00942: table or view does not exist |
|
in SYSTEMPATH\Database\BaseConnection.php on line 647. |
|
1 APPPATH\Models\Mpemby.php(381): CodeIgniter\Database\BaseConnection->query('SELECT |
|
BLNBYR, |
|
(SELECT SUM(JUMLAH)POPULASI FROM KEWAJIBAN_FLAGN |
|
WHERE KD_MAP <> 0 AND KWLADM = \'170\' AND KD_MAP = \'\' AND KATEGORI = \'\') POPULASI, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST |
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS |
|
WHERE THNBYR BETWEEN \'2023\' AND \'2024\' AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\' |
|
GROUP BY NPWP,THNBYR,BLNBYR |
|
) |
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC |
|
') |
|
2 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...]) |
|
3 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs() |
|
4 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home)) |
|
5 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) |
|
6 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run() |
|
CRITICAL - 2024-05-19 17:11:54 --> [Caused by] CodeIgniter\Database\Exceptions\DatabaseException: oci_execute(): ORA-00942: table or view does not exist |
|
in SYSTEMPATH\Database\OCI8\Connection.php on line 211. |
|
1 SYSTEMPATH\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT |
|
BLNBYR, |
|
(SELECT SUM(JUMLAH)POPULASI FROM KEWAJIBAN_FLAGN |
|
WHERE KD_MAP <> 0 AND KWLADM = \'170\' AND KD_MAP = \'\' AND KATEGORI = \'\') POPULASI, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST |
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS |
|
WHERE THNBYR BETWEEN \'2023\' AND \'2024\' AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\' |
|
GROUP BY NPWP,THNBYR,BLNBYR |
|
) |
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC |
|
') |
|
2 SYSTEMPATH\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT |
|
BLNBYR, |
|
(SELECT SUM(JUMLAH)POPULASI FROM KEWAJIBAN_FLAGN |
|
WHERE KD_MAP <> 0 AND KWLADM = \'170\' AND KD_MAP = \'\' AND KATEGORI = \'\') POPULASI, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST |
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS |
|
WHERE THNBYR BETWEEN \'2023\' AND \'2024\' AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\' |
|
GROUP BY NPWP,THNBYR,BLNBYR |
|
) |
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC |
|
') |
|
3 APPPATH\Models\Mpemby.php(381): CodeIgniter\Database\BaseConnection->query('SELECT |
|
BLNBYR, |
|
(SELECT SUM(JUMLAH)POPULASI FROM KEWAJIBAN_FLAGN |
|
WHERE KD_MAP <> 0 AND KWLADM = \'170\' AND KD_MAP = \'\' AND KATEGORI = \'\') POPULASI, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST |
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS |
|
WHERE THNBYR BETWEEN \'2023\' AND \'2024\' AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\' |
|
GROUP BY NPWP,THNBYR,BLNBYR |
|
) |
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC |
|
') |
|
4 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...]) |
|
5 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs() |
|
6 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home)) |
|
7 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) |
|
8 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run() |
|
CRITICAL - 2024-05-19 17:11:54 --> [Caused by] ErrorException: oci_execute(): ORA-00942: table or view does not exist |
|
in SYSTEMPATH\Database\OCI8\Connection.php on line 199. |
|
1 [internal function]: CodeIgniter\Debug\Exceptions->errorHandler(2, 'oci_execute(): ORA-00942: table or view does not exist', 'C:\\xampp\\htdocs\\engineN\\system\\Database\\OCI8\\Connection.php', 199) |
|
2 SYSTEMPATH\Database\OCI8\Connection.php(199): oci_execute(resource (oci8 statement), 32) |
|
3 SYSTEMPATH\Database\BaseConnection.php(693): CodeIgniter\Database\OCI8\Connection->execute('SELECT |
|
BLNBYR, |
|
(SELECT SUM(JUMLAH)POPULASI FROM KEWAJIBAN_FLAGN |
|
WHERE KD_MAP <> 0 AND KWLADM = \'170\' AND KD_MAP = \'\' AND KATEGORI = \'\') POPULASI, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST |
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS |
|
WHERE THNBYR BETWEEN \'2023\' AND \'2024\' AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\' |
|
GROUP BY NPWP,THNBYR,BLNBYR |
|
) |
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC |
|
') |
|
4 SYSTEMPATH\Database\BaseConnection.php(607): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT |
|
BLNBYR, |
|
(SELECT SUM(JUMLAH)POPULASI FROM KEWAJIBAN_FLAGN |
|
WHERE KD_MAP <> 0 AND KWLADM = \'170\' AND KD_MAP = \'\' AND KATEGORI = \'\') POPULASI, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST |
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS |
|
WHERE THNBYR BETWEEN \'2023\' AND \'2024\' AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\' |
|
GROUP BY NPWP,THNBYR,BLNBYR |
|
) |
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC |
|
') |
|
5 APPPATH\Models\Mpemby.php(381): CodeIgniter\Database\BaseConnection->query('SELECT |
|
BLNBYR, |
|
(SELECT SUM(JUMLAH)POPULASI FROM KEWAJIBAN_FLAGN |
|
WHERE KD_MAP <> 0 AND KWLADM = \'170\' AND KD_MAP = \'\' AND KATEGORI = \'\') POPULASI, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN 1 ELSE 0 END) WPBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN 1 ELSE 0 END) WPBYRPAST, |
|
SUM(CASE WHEN THNBYR = \'2024\' THEN TOTAL ELSE 0 END) JMLBYRNOW, |
|
SUM(CASE WHEN THNBYR = \'2023\' THEN TOTAL ELSE 0 END) JMLBYRPAST |
|
FROM (SELECT NPWP,THNBYR,BLNBYR,SUM(TOTAL) TOTAL FROM DASHBOARD_BESAR_MAPKJS |
|
WHERE THNBYR BETWEEN \'2023\' AND \'2024\' AND KWLADM = \'170\' AND KD_MAP = \'\' AND KJS = \'\' AND KATEGORI = \'\' |
|
GROUP BY NPWP,THNBYR,BLNBYR |
|
) |
|
GROUP BY BLNBYR ORDER BY BLNBYR ASC |
|
') |
|
6 APPPATH\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs([...]) |
|
7 SYSTEMPATH\CodeIgniter.php(943): App\Controllers\Home->gmapkjs() |
|
8 SYSTEMPATH\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home)) |
|
9 SYSTEMPATH\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(null, Object(Config\Cache), false) |
|
10 FCPATH\index.php(79): CodeIgniter\CodeIgniter->run() |
|
CRITICAL - 2024-05-19 17:11:54 --> ErrorException: Uncaught Error: Call to undefined method CodeIgniter\Debug\ExceptionHandler::cleanPath() in C:\xampp\htdocs\engineN\app\Views\errors\html\error_exception.php:33 |
|
Stack trace: |
|
#0 C:\xampp\htdocs\engineN\system\Debug\BaseExceptionHandler.php(258): include() |
|
#1 C:\xampp\htdocs\engineN\system\Debug\BaseExceptionHandler.php(261): CodeIgniter\Debug\BaseExceptionHandler->CodeIgniter\Debug\{closure}() |
|
#2 C:\xampp\htdocs\engineN\system\Debug\ExceptionHandler.php(112): CodeIgniter\Debug\BaseExceptionHandler->render(Object(CodeIgniter\Database\Exceptions\DatabaseException), 500, 'C:\\xampp\\htdocs...') |
|
#3 C:\xampp\htdocs\engineN\system\Debug\Exceptions.php(156): CodeIgniter\Debug\ExceptionHandler->handle(Object(CodeIgniter\Database\Exceptions\DatabaseException), Object(CodeIgniter\HTTP\IncomingRequest), Object(CodeIgniter\HTTP\Response), 500, 8) |
|
#4 [internal function]: CodeIgniter\Debug\Exceptions->exceptionHandler(Object(CodeIgniter\Database\Exceptions\DatabaseException)) |
|
#5 {main} |
|
thrown |
|
【Previous Exception】 |
|
CodeIgniter\Database\Exceptions\DatabaseException |
|
oci_execute(): ORA-00942: table or view does not exist |
|
#0 C:\xampp\htdocs\engineN\app\Models\Mpemby.php(381): CodeIgniter\Database\BaseConnection->query('SELECT \r\n ...') |
|
#1 C:\xampp\htdocs\engineN\app\Controllers\Home.php(190): App\Models\Mpemby->gmapkjs(Array) |
|
#2 C:\xampp\htdocs\engineN\system\CodeIgniter.php(943): App\Controllers\Home->gmapkjs() |
|
#3 C:\xampp\htdocs\engineN\system\CodeIgniter.php(503): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Home)) |
|
#4 C:\xampp\htdocs\engineN\system\CodeIgniter.php(361): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false) |
|
#5 C:\xampp\htdocs\engineN\index.php(79): CodeIgniter\CodeIgniter->run() |
|
#6 {main} |
|
in APPPATH\Views\errors\html\error_exception.php on line 33. |
|
1 [internal function]: CodeIgniter\Debug\Exceptions->shutdownHandler()
|
|
|