Login
Zend Framework Default Application

An error occurred

Application error

Exception information:

Message: SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') ASC, `vmba_bowl`.`id` ASC' at line 2, query was: SELECT `vmba_bowl`.*, `bb`.`book_id` FROM `vmba_bowl` LEFT JOIN `vmba_bowl_book` AS `bb` ON bb.bowl_id = vmba_bowl.id WHERE ( 1 ) GROUP BY `vmba_bowl`.`id` ORDER BY CAST(ref%20AS%20SIGNED) ASC, `vmba_bowl`.`id` ASC

Stack trace:

#0 /opt/ZendFramework-1.12.20/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#1 /opt/ZendFramework-1.12.20/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /opt/ZendFramework-1.12.20/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `vmba_bo...', Array)
#3 /opt/ZendFramework-1.12.20/library/Zend/Db/Adapter/Abstract.php(737): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select), Array)
#4 /opt/webs/humanities-research.exeter.ac.uk/vmba/application/modules/public/controllers/BowlController.php(85): Zend_Db_Adapter_Abstract->fetchAll(Object(Zend_Db_Select))
#5 /opt/ZendFramework-1.12.20/library/Zend/Controller/Action.php(516): Public_BowlController->viewAction()
#6 /opt/ZendFramework-1.12.20/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('viewAction')
#7 /opt/ZendFramework-1.12.20/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#8 /opt/ZendFramework-1.12.20/library/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#9 /opt/ZendFramework-1.12.20/library/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#10 /opt/webs/humanities-research.exeter.ac.uk/vmba/public/index.php(26): Zend_Application->run()
#11 {main}  

Request Parameters:

array (
  'id' => '9',
  'order' => 'CAST(ref%20AS%20SIGNED)',
  'direction' => 'ASC',
  'module' => 'public',
  'controller' => 'bowl',
  'action' => 'view',
)