Bug(バグ) #3922
activity/search.json のパラメータに member_id のみを設定するとサーバエラーが発生する
ステータス:
New(新規)
優先度:
Normal(通常)
担当者:
-
対象バージョン:
-
開始日:
2016-03-24
期日:
進捗率:
0%
3.6 で発生するか:
Unknown (未調査)
3.8 で発生するか:
Unknown (未調査)
説明
Overview (現象)¶
/api_dev.php/activity/search.json?member_id=1&apiKey={API_KEY}
実行時に下記のエラーが発生する
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" ] }}}
Causes (原因)¶
未調査