Fatal error: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens 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.id, a....', Array) #4 C:\www\jdih\application\services\KuesionerService.php(54): Zend_Db_Adapter_Pdo_Abstract->query('SELECT a.id, a....', Array) #5 C:\www\jdih\application\modules\default\controllers\IkmController.php(56): KuesionerService->getStatistikData('2') #6 \\172.16.30.152\LIBRARIES\libs\Zend\Controller\Action.php(528): IkmController->resultAction() #7 \\172.16.30.152\LIBRARIES\libs\Zend\Controller\Dispatcher\Standard.php(308): Zend_Controller_Action->dispatch('resultAction') #8 \\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)) #9 \\172.16.30.152\LIBRARIES\libs\Zend\Application\Bootstrap\Bootstrap.php(106): Zend_Controller_Front->dispatch() #10 \\172.16.30.152\LIBRARIES\libs\Zend\Application.php(400): Zend_Application_Bootstrap_Bootstrap->run() #11 C:\www\public\index.php(54): Zend_Application->run() #12 {main} Next Zend_Db_Statement_Exception: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens, query was: SELECT a.id, a.urutan, a.pertanyaan, b.pilihan, IFNULL(c.jumlah, 0) AS jumlah FROM kuesioner_pertanyaan a LEFT JOIN kuesioner_pilihan b ON a.id = b.id_kuesioner_pertanyaan AND b.status = 1 LEFT JOIN ( SELECT id_kuesioner_pertanyaan, jawaban, COUNT(*) AS jumlah FROM kuesioner_jawaban GROUP BY id_kuesioner_pertanyaan, jawaban ) c ON a.id = c.id_kuesioner_pertanyaan AND b.urutan = c.jawaban WHERE a.status = 1 AND a.id_kuesioner = 4 AND a.id IN (42, 45, 46, 48, 49, 51, 53, 54, 57, 58) GROUP BY a.id, b.pilihan; 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.id, a....', Array) #3 C:\www\jdih\application\services\KuesionerService.php(54): Zend_Db_Adapter_Pdo_Abstract->query('SELECT a.id, a....', Array) #4 C:\www\jdih\application\modules\default\controllers\IkmController.php(56): KuesionerService->getStatistikData('2') #5 \\172.16.30.152\LIBRARIES\libs\Zend\Controller\Action.php(528): IkmController->resultAction() #6 \\172.16.30.152\LIBRARIES\libs\Zend\Controller\Dispatcher\Standard.php(308): Zend_Controller_Action->dispatch('resultAction') #7 \\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)) #8 \\172.16.30.152\LIBRARIES\libs\Zend\Application\Bootstrap\Bootstrap.php(106): Zend_Controller_Front->dispatch() #9 \\172.16.30.152\LIBRARIES\libs\Zend\Application.php(400): Zend_Application_Bootstrap_Bootstrap->run() #10 C:\www\public\index.php(54): Zend_Application->run() #11 {main} thrown in \\172.16.30.152\LIBRARIES\libs\Zend\Db\Statement\Pdo.php on line 235