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/28' AND (scheduleStation IS NULL OR scheduleStation = merchantStation)
 LEFT JOIN `ScheduleTypeMaster` ON scheduleType=stypeCode WHERE (staffStatus != '9') AND (castStatus != '9') AND (castMerchant = '518') 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/297c8e40e5f9e255bf42510967dcba8585430405_0.file.Base.tpl.php(50): Application_View_Helper_Smarty->getCastRow(NULL)
#7 /apps/library/Smarty/sysplugins/smarty_template_resource_base.php(123): content_65f79aadc0e7b0_39085171(Object(Smarty_Internal_Template))
#8 /apps/library/Smarty/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode(Object(Smarty_Internal_Template))
#9 /apps/library/Smarty/sysplugins/smarty_internal_template.php(216): Smarty_Template_Compiled->render(Object(Smarty_Internal_Template))
#10 /apps/library/Smarty/sysplugins/smarty_internal_template.php(385): Smarty_Internal_Template->render()
#11 /apps/library/Smarty/sysplugins/smarty_internal_runtime_inheritance.php(116): Smarty_Internal_Template->_subTemplateRender('Base.tpl', NULL, NULL, 0, 3600, Array, 2, false, NULL, NULL)
#12 /tmp/451f84b97e4d53bf2a489acaf24a15240e010410_0.file.Gravure.tpl.php(64): Smarty_Internal_Runtime_Inheritance->endChild(Object(Smarty_Internal_Template), 'Base.tpl')
#13 /apps/library/Smarty/sysplugins/smarty_template_resource_base.php(123): content_65f79c6d384cb0_31627263(Object(Smarty_Internal_Template))
#14 /apps/library/Smarty/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode(Object(Smarty_Internal_Template))
#15 /apps/library/Smarty/sysplugins/smarty_internal_template.php(216): Smarty_Template_Compiled->render(Object(Smarty_Internal_Template))
#16 /apps/library/Smarty/sysplugins/smarty_internal_templatebase.php(232): Smarty_Internal_Template->render(false, 0)
#17 /apps/library/Smarty/sysplugins/smarty_internal_templatebase.php(116): Smarty_Internal_TemplateBase->_execute(Object(Smarty_Internal_Template), NULL, NULL, NULL, 0)
#18 /apps/cms/Application/View/Render/Smarty.php(106): Smarty_Internal_TemplateBase->fetch('/apps/cms/Var/T...')
#19 /apps/cms/Application/View/Render/Smarty.php(210): Application_View_Render_Smarty->render(NULL)
#20 /apps/cms/Application/Controller/Plugin.php(29): Application_View_Render_Smarty->applicationRender()
#21 /apps/library/Zend/Controller/Plugin/Broker.php(354): Application_Controller_Plugin->dispatchLoopShutdown()
#22 /apps/library/Zend/Controller/Front.php(979): Zend_Controller_Plugin_Broker->dispatchLoopShutdown()
#23 /apps/cms/Interface/Public.php(162): Zend_Controller_Front->dispatch()
#24 {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}
500
ご迷惑をお掛けしております

エラーを補足した為、動作を一旦停止させました。

戻る