An error occurred
Application error
Exception information:
Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'CAST%28ref AS SIGNED%29' in 'order clause', 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%28ref AS SIGNED%29` 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' => '48', 'order' => 'CAST%28ref AS SIGNED%29', 'direction' => 'ASC', 'module' => 'public', 'controller' => 'bowl', 'action' => 'view', )