Message: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1, query was: SELECT AVG(usr_rating) as average_rating FROM `theater_rating_comments` WHERE isstatus = 1 AND video_id =
#0 /home/amplepoi/public_html/ampletheater.net/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/amplepoi/public_html/ampletheater.net/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #2 /home/amplepoi/public_html/ampletheater.net/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT AVG(usr_...', Array) #3 /home/amplepoi/public_html/ampletheater.net/library/Zend/Db/Adapter/Abstract.php(756): Zend_Db_Adapter_Pdo_Abstract->query('SELECT AVG(usr_...', Array) #4 /home/amplepoi/public_html/ampletheater.net/application/modules/admin/models/Admin.php(18929): Zend_Db_Adapter_Abstract->fetchRow('SELECT AVG(usr_...') #5 /home/amplepoi/public_html/ampletheater.net/application/modules/default/views/scripts/index/movie.phtml(3065): Admin_Model_Admin->ExecuteRowQuery('SELECT AVG(usr_...') #6 /home/amplepoi/public_html/ampletheater.net/library/Zend/View.php(157): include('/home/amplepoi/...') #7 /home/amplepoi/public_html/ampletheater.net/library/Zend/View/Abstract.php(888): Zend_View->_run('/home/amplepoi/...') #8 /home/amplepoi/public_html/ampletheater.net/library/Zend/Controller/Action/Helper/ViewRenderer.php(912): Zend_View_Abstract->render('index/movie.pht...') #9 /home/amplepoi/public_html/ampletheater.net/library/Zend/Controller/Action/Helper/ViewRenderer.php(933): Zend_Controller_Action_Helper_ViewRenderer->renderScript('index/movie.pht...', NULL) #10 /home/amplepoi/public_html/ampletheater.net/library/Zend/Controller/Action/Helper/ViewRenderer.php(972): Zend_Controller_Action_Helper_ViewRenderer->render() #11 /home/amplepoi/public_html/ampletheater.net/library/Zend/Controller/Action/HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch() #12 /home/amplepoi/public_html/ampletheater.net/library/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch() #13 /home/amplepoi/public_html/ampletheater.net/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('movieAction') #14 /home/amplepoi/public_html/ampletheater.net/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #15 /home/amplepoi/public_html/ampletheater.net/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch() #16 /home/amplepoi/public_html/ampletheater.net/library/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run() #17 /home/amplepoi/public_html/ampletheater.net/public/index.php(26): Zend_Application->run() #18 {main}
array ( 'id' => '12', 'controller' => 'index', 'action' => 'movie', )