プロジェクト

全般

プロフィール

Bug(バグ) #3922

kaoru n約8年前に更新

h3. Overview (現象)

/api_dev.php/activity/search.json?member_id=1&apiKey={API_KEY}
実行時に下記のエラーが発生する

<pre>
Warning: Cannot modify header information - headers already sent by (output started at /{OpenPNE}/lib/vendor/symfony/lib/exception/sfException.class.php:103) in /{OpenPNE}/lib/vendor/symfony/lib/response/sfWebResponse.class.php on line 357
{"error":{
"code":500,
"message":"SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens",
"debug":{
"name":"Doctrine_Connection_Mysql_Exception",
"message":"SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens",
"traces":[
"at () in SF_ROOT_DIR\/lib\/vendor\/symfony\/lib\/plugins\/sfDoctrinePlugin\/lib\/vendor\/doctrine\/Doctrine\/Connection.php line 1082",
"at Doctrine_Connection->rethrowException(object('PDOException'), object('Doctrine_Connection_Statement')) in SF_ROOT_DIR\/lib\/vendor\/symfony\/lib\/plugins\/sfDoctrinePlugin\/lib\/vendor\/doctrine\/Doctrine\/Connection\/Statement.php line 269",
"at Doctrine_Connection_Statement->execute(array('1', 3, 2, 1, 0, 1)) in SF_ROOT_DIR\/lib\/vendor\/symfony\/lib\/plugins\/sfDoctrinePlugin\/lib\/vendor\/doctrine\/Doctrine\/Connection.php line 1006",
"at Doctrine_Connection->execute('SELECT a.id AS a__id, a.member_id AS a__member_id, a.in_reply_to_activity_id AS a__in_reply_to_activity_id, a.body AS a__body, a.uri AS a__uri, a.public_flag AS a__public_flag, a.is_pc AS a__is_pc, a.is_mobile AS a__is_mobile, a.source AS a__source, a.source_uri AS a__source_uri, a.foreign_table AS a__foreign_table, a.foreign_id AS a__foreign_id, a.template AS a__template, a.template_param AS a__template_param, a.created_at AS a__created_at, a.updated_at AS a__updated_at, m.id AS m__id, m.name AS m__name, m.invite_member_id AS m__invite_member_id, m.is_login_rejected AS m__is_login_rejected, m.created_at AS m__created_at, m.updated_at AS m__updated_at, m.is_active AS m__is_active FROM activity_data a LEFT JOIN member m ON a.member_id = m.id WHERE (a.member_id = ? AND a.public_flag IN (?, ?)) AND (a.foreign_table IS NULL OR a.foreign_table <> \"community\") AND a.in_reply_to_activity_id IS NULL AND (m.is_active = ? OR m.is_active IS NULL) ORDER BY a.id DESC LIMIT 20', array('1', 3, 2, 1, 0, 1)) in SF_ROOT_DIR\/lib\/vendor\/symfony\/lib\/plugins\/sfDoctrinePlugin\/lib\/vendor\/doctrine\/Doctrine\/Query\/Abstract.php line 983",
"at Doctrine_Query_Abstract->_execute(array()) in SF_ROOT_DIR\/lib\/vendor\/symfony\/lib\/plugins\/sfDoctrinePlugin\/lib\/vendor\/doctrine\/Doctrine\/Query\/Abstract.php line 1033",
"at Doctrine_Query_Abstract->execute() in SF_ROOT_DIR\/plugins\/opTimelinePlugin\/lib\/model\/opTimeline.class.php line 305",
"at opTimeline->searchActivityDataByAPIRequestDataAndMemberId(array('member_id' => '1', 'apiKey' => '1933848fe0fcf602dd6ee0ce9e7bcc6a8735cee60a0174c3f77bc788b5e56379'), '1') in SF_ROOT_DIR\/plugins\/opTimelinePlugin\/apps\/api\/modules\/activity\/actions\/actions.class.php line 226",
"at activityActions->executeSearch(object('sfWebRequest')) in SF_ROOT_DIR\/lib\/vendor\/symfony\/lib\/action\/sfActions.class.php line 60",
"at sfActions->execute(object('sfWebRequest')) in SF_ROOT_DIR\/lib\/action\/opJsonApiActions.class.php line 39",
"at opJsonApiActions->execute(object('sfWebRequest')) in SF_ROOT_DIR\/lib\/vendor\/symfony\/lib\/filter\/sfExecutionFilter.class.php line 92",
"at sfExecutionFilter->executeAction(object('activityActions')) in SF_ROOT_DIR\/lib\/vendor\/symfony\/lib\/filter\/sfExecutionFilter.class.php line 78",
"at sfExecutionFilter->handleAction(object('sfFilterChain'), object('activityActions')) in SF_ROOT_DIR\/lib\/vendor\/symfony\/lib\/filter\/sfExecutionFilter.class.php line 42",
"at sfExecutionFilter->execute(object('sfFilterChain')) in SF_ROOT_DIR\/lib\/vendor\/symfony\/lib\/filter\/sfFilterChain.class.php line 53",
"at sfFilterChain->execute() in SF_ROOT_DIR\/lib\/vendor\/symfony\/lib\/filter\/sfRenderingFilter.class.php line 33",
"at sfRenderingFilter->execute(object('sfFilterChain')) in SF_ROOT_DIR\/lib\/vendor\/symfony\/lib\/filter\/sfFilterChain.class.php line 53",
"at sfFilterChain->execute() in SF_ROOT_DIR\/lib\/vendor\/symfony\/lib\/controller\/sfController.class.php line 238",
"at sfController->forward('activity', 'search') in SF_ROOT_DIR\/lib\/vendor\/symfony\/lib\/controller\/sfFrontWebController.class.php line 48",
"at sfFrontWebController->dispatch() in SF_ROOT_DIR\/lib\/vendor\/symfony\/lib\/util\/sfContext.class.php line 170",
"at sfContext->dispatch() in SF_ROOT_DIR\/web\/api_dev.php line 13"
]
}}}
</pre>

h3. Causes (原因)

未調査

h3. Way to fix (修正内容)

戻る