Zend_Controller_Exception
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 8, query was: SELECT SQL_CALC_FOUND_ROWS CastMaster.*, `StaffMaster`.*, `LevelMaster`.*, `PhotoMaster`.`photoCode`, `MerchantMaster`.`merchantCode`, `MerchantMaster`.`merchantName`, `MerchantMaster`.`merchantContract`, `MerchantMaster`.`merchantUpdate`, `MerchantMaster`.`merchantStatus`, `MerchantMaster`.`merchantPictures`, `MerchantMaster`.`merchantBorder`, `MerchantMaster`.`merchantDomain`, `MerchantMaster`.`merchantPass`, `MerchantMaster`.`merchantStation`, `MerchantMaster`.`merchantKey`, `MerchantMaster`.`merchantTransfer`, `MerchantMaster`.`merchantKa3`, `MerchantMaster`.`merchantTel1`, `MerchantMaster`.`merchantDeliver`, `ContractMaster`.`contractCode`, `ContractMaster`.`contractName`, `ContractMaster`.`contractStatus`, `ContractMaster`.`contractBorder`, `ScheduleTran`.*, `ScheduleTypeMaster`.* FROM `CastMaster` LEFT JOIN `StaffMaster` ON castStaff=staffCode LEFT JOIN `LevelMaster` ON castLevel=levelCode LEFT JOIN `PhotoMaster` ON photoCast=castCode AND photoIndex = 1 INNER JOIN `MerchantMaster` ON castMerchant=merchantCode INNER JOIN `ContractMaster` ON contractCode=merchantContract LEFT JOIN `ScheduleTran` ON staffCode=scheduleStaff AND scheduleDate = '2024/03/29' AND (scheduleStation IS NULL OR scheduleStation = merchantStation) LEFT JOIN `ScheduleTypeMaster` ON scheduleType=stypeCode WHERE (staffStatus != '9') AND (castStatus != '9') AND (castMerchant = '7') AND (castStatus = '1') AND (castCode = ?)#0 /apps/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #1 /apps/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #2 /apps/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT SQL_CALC...', Array) #3 /apps/library/Zend/Db/Adapter/Abstract.php(759): Zend_Db_Adapter_Pdo_Abstract->query('SELECT SQL_CALC...', Array) #4 /apps/cms/Application/Model/Db/Selector.php(92): Zend_Db_Adapter_Abstract->fetchRow('SELECT SQL_CALC...') #5 /apps/cms/Application/View/Helper/Smarty.php(551): Application_Model_Db_Selector->fetchRow() #6 /tmp/95bf00511beea94c3c9ab67e58d43641bf9766a5_0.file.Profile_w.tpl.php(72): Application_View_Helper_Smarty->getCastRow(NULL) #7 /apps/library/Smarty/sysplugins/smarty_internal_runtime_inheritance.php(248): Block_65775614265f7b17b18ed69_13442957->callBlock(Object(Smarty_Internal_Template)) #8 /apps/library/Smarty/sysplugins/smarty_internal_runtime_inheritance.php(184): Smarty_Internal_Runtime_Inheritance->callBlock(Object(Block_65775614265f7b17b18ed69_13442957), Object(Smarty_Internal_Template)) #9 /apps/library/Smarty/sysplugins/smarty_internal_runtime_inheritance.php(186): Smarty_Internal_Runtime_Inheritance->process(Object(Smarty_Internal_Template), Object(Block_65775614265f7b17b18ed69_13442957), Object(Block_11766648065f79f29565d36_43083188)) #10 /apps/library/Smarty/sysplugins/smarty_internal_runtime_inheritance.php(156): Smarty_Internal_Runtime_Inheritance->process(Object(Smarty_Internal_Template), Object(Block_11766648065f79f29565d36_43083188)) #11 /tmp/962e96396f12e4cdb5a0826712e55066900a93b9_0.file.BaseforW.tpl.php(49): Smarty_Internal_Runtime_Inheritance->instanceBlock(Object(Smarty_Internal_Template), 'Block_117666480...', 'title') #12 /apps/library/Smarty/sysplugins/smarty_template_resource_base.php(123): content_65f79f29575c35_78944183(Object(Smarty_Internal_Template)) #13 /apps/library/Smarty/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode(Object(Smarty_Internal_Template)) #14 /apps/library/Smarty/sysplugins/smarty_internal_template.php(216): Smarty_Template_Compiled->render(Object(Smarty_Internal_Template)) #15 /apps/library/Smarty/sysplugins/smarty_internal_template.php(385): Smarty_Internal_Template->render() #16 /apps/library/Smarty/sysplugins/smarty_internal_runtime_inheritance.php(116): Smarty_Internal_Template->_subTemplateRender('BaseforW.tpl', NULL, NULL, 0, 3600, Array, 2, false, NULL, NULL) #17 /tmp/95bf00511beea94c3c9ab67e58d43641bf9766a5_0.file.Profile_w.tpl.php(58): Smarty_Internal_Runtime_Inheritance->endChild(Object(Smarty_Internal_Template), 'BaseforW.tpl') #18 /apps/library/Smarty/sysplugins/smarty_template_resource_base.php(123): content_65f7b17b20da75_51074087(Object(Smarty_Internal_Template)) #19 /apps/library/Smarty/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode(Object(Smarty_Internal_Template)) #20 /apps/library/Smarty/sysplugins/smarty_internal_template.php(216): Smarty_Template_Compiled->render(Object(Smarty_Internal_Template)) #21 /apps/library/Smarty/sysplugins/smarty_internal_templatebase.php(232): Smarty_Internal_Template->render(false, 0) #22 /apps/library/Smarty/sysplugins/smarty_internal_templatebase.php(116): Smarty_Internal_TemplateBase->_execute(Object(Smarty_Internal_Template), NULL, NULL, NULL, 0) #23 /apps/cms/Application/View/Render/Smarty.php(106): Smarty_Internal_TemplateBase->fetch('/apps/cms/Var/T...') #24 /apps/cms/Application/View/Render/Smarty.php(210): Application_View_Render_Smarty->render(NULL) #25 /apps/cms/Application/Controller/Plugin.php(29): Application_View_Render_Smarty->applicationRender() #26 /apps/library/Zend/Controller/Plugin/Broker.php(354): Application_Controller_Plugin->dispatchLoopShutdown() #27 /apps/library/Zend/Controller/Front.php(979): Zend_Controller_Plugin_Broker->dispatchLoopShutdown() #28 /apps/cms/Interface/Public.php(162): Zend_Controller_Front->dispatch() #29 {main}
#0 /apps/library/Zend/Controller/Front.php(979): Zend_Controller_Plugin_Broker->dispatchLoopShutdown() #1 /apps/cms/Interface/Public.php(162): Zend_Controller_Front->dispatch() #2 {main}
エラーを補足した為、動作を一旦停止させました。