Website: Basis CMS | VSO
URL: www.elan-media.nl

Error number: 0
Error file:
Error line:

Title: 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 ') ORDER BY `pcp`.`rank` ASC' at line 3, query was: SELECT DISTINCT `p`.*, `pt`.*, `pcp`.* FROM `common_publishers` AS `p` LEFT JOIN `common_publisher_translations` AS `pt` ON pt.publisher_id=p.publisher_id LEFT JOIN `common_publisher_category_publishers` AS `pcp` ON pcp.publisher_id=p.publisher_id WHERE (pcp.publisher_category_id = ) ORDER BY `pcp`.`rank` ASC

#0 /home/elanmedia/public_html/vendor/zendframework/zendframework1/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/elanmedia/public_html/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /home/elanmedia/public_html/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT DISTINCT...', Array)
#3 /home/elanmedia/public_html/vendor/zendframework/zendframework1/library/Zend/Db/Table/Abstract.php(1577): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select))
#4 /home/elanmedia/public_html/vendor/zendframework/zendframework1/library/Zend/Db/Table/Abstract.php(1392): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select))
#5 /home/elanmedia/public_html/mvc/application/modules/common/Models/DbTables/CommonPublishers.php(78): Zend_Db_Table_Abstract->fetchAll(Object(Zend_Db_Table_Select))
#6 /home/elanmedia/public_html/mvc/application/Models/Front/PublisherService.php(67): Models_DbTables_CommonPublishers->getAllRecordsJoinedCustom(Array, Array, Array, 0)
#7 /home/elanmedia/public_html/mvc/application/modules/front/controllers/VscPublisherCategoryDetailController.php(43): Front_PublisherService->getAllRecordsByCategory(Array)
#8 /home/elanmedia/public_html/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php(516): VscPublisherCategoryDetailController->viewAction()
#9 /home/elanmedia/public_html/vendor/zendframework/zendframework1/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('viewAction')
#10 /home/elanmedia/public_html/vendor/zendframework/zendframework1/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#11 /home/elanmedia/public_html/index.php(82): Zend_Controller_Front->dispatch()
#12 {main}