EXCEPTION_OTHER


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 ' '9'))' at line 2, query was: SELECT COUNT(1) AS `zend_paginator_row_count` FROM `work`
NATURAL JOIN `company` WHERE (company_parent IN ('1', '4', '0')) AND (work_status = 1) AND (company_status=1) AND (EXISTS (SELECT * FROM work_to_job LEFT JOIN site_jobRelation ON work_to_job.job_id=site_jobRelation.job_id WHERE work_to_job.work_id=work.work_id AND siteJob_id='84')) AND (EXISTS (SELECT * FROM work_to_employment WHERE work_to_employment.work_id=work.work_id AND employment_id ='2', '9'))

#0 /var/www/includes/ZendFramework/1.12.20/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/includes/ZendFramework/1.12.20/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /var/www/includes/ZendFramework/1.12.20/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Select), Array)
#3 /var/www/includes/ZendFramework/1.12.20/Zend/Db/Select.php(711): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select))
#4 /var/www/includes/ZendFramework/1.12.20/Zend/Paginator/Adapter/DbSelect.php(142): Zend_Db_Select->query(2)
#5 /var/www/includes/ZendFramework/1.12.20/Zend/Paginator/Adapter/DbSelect.php(183): Zend_Paginator_Adapter_DbSelect->setRowCount(Object(Zend_Db_Select))
#6 [internal function]: Zend_Paginator_Adapter_DbSelect->count()
#7 /var/www/includes/ZendFramework/1.12.20/Zend/Paginator.php(534): count(Object(Zend_Paginator_Adapter_DbSelect))
#8 /var/www/includes/ZendFramework/1.12.20/Zend/Paginator.php(1081): Zend_Paginator->getTotalItemCount()
#9 /var/www/includes/ZendFramework/1.12.20/Zend/Paginator.php(753): Zend_Paginator->_calculatePageCount()
#10 /var/www/vhosts/e-sigoto.net/applications/site/default/models/WorkModel.php(103): Zend_Paginator->setItemCountPerPage(10)
#11 /var/www/vhosts/e-sigoto.net/applications/site/default/controllers/SearchController.php(73): WorkModel->workList()
#12 /var/www/includes/ZendFramework/1.12.20/Zend/Controller/Action.php(516): SearchController->indexAction()
#13 /var/www/includes/ZendFramework/1.12.20/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('indexAction')
#14 /var/www/includes/ZendFramework/1.12.20/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#15 /var/www/vhosts/e-sigoto.net/applications/site/bootstrap.php(161): Zend_Controller_Front->dispatch()
#16 /var/www/vhosts/e-sigoto.net/www/index.php(10): QjinApp::bootstrap()
#17 {main}


このページの先頭へ