Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.SUBSTRING_INDEX(waktu_diterima,"-",1) as jam_awal, IF(UPPER(SUBSTRING_INDEX(waktu_diterima,"-",-1)) = "ALL DAY","",SUBSTRING_INDEX(waktu_diterima,"-",-1))' in 'field list' in \\172.16.30.152\LIBRARIES\libs\Zend\Db\Statement\Pdo.php:228 Stack trace: #0 \\172.16.30.152\LIBRARIES\libs\Zend\Db\Statement\Pdo.php(228): PDOStatement->execute(Array) #1 \\172.16.30.152\LIBRARIES\libs\Zend\Db\Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #2 \\172.16.30.152\LIBRARIES\libs\Zend\Db\Adapter\Abstract.php(480): Zend_Db_Statement->execute(Array) #3 \\172.16.30.152\LIBRARIES\libs\Zend\Db\Adapter\Pdo\Abstract.php(267): Zend_Db_Adapter_Abstract->query('SELECT `a`.*, `...', Array) #4 \\172.16.30.152\LIBRARIES\libs\Zend\Db\Table\Abstract.php(1590): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select)) #5 \\172.16.30.152\LIBRARIES\libs\Zend\Db\Table\Abstract.php(1452): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select)) #6 C:\www\humas\application\services\FormMasyarakatService.php(86): Zend_Db_Table_Abstract->fetchRow(Object(Zend_Db_Table_Select)) #7 C:\www\humas\application\modules\default\controllers\GaleriController.php(80): FormMasyarakatService->getData('22') #8 \\172.16.30.152\LIBRARIES\libs\Zend\Controller\Action.php(528): GaleriController->detailAction() #9 \\172.16.30.152\LIBRARIES\libs\Zend\Controller\Dispatcher\Standard.php(308): Zend_Controller_Action->dispatch('detailAction') #10 \\172.16.30.152\LIBRARIES\libs\Zend\Controller\Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #11 \\172.16.30.152\LIBRARIES\libs\Zend\Application\Bootstrap\Bootstrap.php(106): Zend_Controller_Front->dispatch() #12 \\172.16.30.152\LIBRARIES\libs\Zend\Application.php(400): Zend_Application_Bootstrap_Bootstrap->run() #13 C:\www\public\index.php(54): Zend_Application->run() #14 {main} Next Zend_Db_Statement_Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.SUBSTRING_INDEX(waktu_diterima,"-",1) as jam_awal, IF(UPPER(SUBSTRING_INDEX(waktu_diterima,"-",-1)) = "ALL DAY","",SUBSTRING_INDEX(waktu_diterima,"-",-1))' in 'field list', query was: SELECT `a`.*, `a`.`SUBSTRING_INDEX(waktu_diterima,"-",1) as jam_awal, IF(UPPER(SUBSTRING_INDEX(waktu_diterima,"-",-1)) = "ALL DAY","",SUBSTRING_INDEX(waktu_diterima,"-",-1))` AS `jam_akhir`, `b`.`nama` AS `nama_petugas_pdm_tujuan`, `c`.`nama` AS `nama_petugas_pdm`, `d`.`jenis_kunjungan` FROM `form_masyarakat` AS `a` LEFT JOIN `db_siap`.`view_pegawai` AS `b` ON a.id_petugas_pdm_tujuan = b.id LEFT JOIN `db_siap`.`view_pegawai` AS `c` ON a.id_petugas_pdm = c.id LEFT JOIN `jenis_kunjungan` AS `d` ON a.id_jenis_kunjungan = d.id WHERE (a.id = '22') LIMIT 1 in \\172.16.30.152\LIBRARIES\libs\Zend\Db\Statement\Pdo.php:235 Stack trace: #0 \\172.16.30.152\LIBRARIES\libs\Zend\Db\Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #1 \\172.16.30.152\LIBRARIES\libs\Zend\Db\Adapter\Abstract.php(480): Zend_Db_Statement->execute(Array) #2 \\172.16.30.152\LIBRARIES\libs\Zend\Db\Adapter\Pdo\Abstract.php(267): Zend_Db_Adapter_Abstract->query('SELECT `a`.*, `...', Array) #3 \\172.16.30.152\LIBRARIES\libs\Zend\Db\Table\Abstract.php(1590): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select)) #4 \\172.16.30.152\LIBRARIES\libs\Zend\Db\Table\Abstract.php(1452): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select)) #5 C:\www\humas\application\services\FormMasyarakatService.php(86): Zend_Db_Table_Abstract->fetchRow(Object(Zend_Db_Table_Select)) #6 C:\www\humas\application\modules\default\controllers\GaleriController.php(80): FormMasyarakatService->getData('22') #7 \\172.16.30.152\LIBRARIES\libs\Zend\Controller\Action.php(528): GaleriController->detailAction() #8 \\172.16.30.152\LIBRARIES\libs\Zend\Controller\Dispatcher\Standard.php(308): Zend_Controller_Action->dispatch('detailAction') #9 \\172.16.30.152\LIBRARIES\libs\Zend\Controller\Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #10 \\172.16.30.152\LIBRARIES\libs\Zend\Application\Bootstrap\Bootstrap.php(106): Zend_Controller_Front->dispatch() #11 \\172.16.30.152\LIBRARIES\libs\Zend\Application.php(400): Zend_Application_Bootstrap_Bootstrap->run() #12 C:\www\public\index.php(54): Zend_Application->run() #13 {main} thrown in \\172.16.30.152\LIBRARIES\libs\Zend\Db\Statement\Pdo.php on line 235