Project

General

Profile

Bug(バグ) #3922

activity/search.json のパラメータに member_id のみを設定するとサーバエラーが発生する

Added by kaoru n over 3 years ago. Updated over 3 years ago.

Status:
New(新規)
Priority:
Normal(通常)
Assignee:
-
Start date:
2016-03-24
Due date:
% Done:

0%

3.6 で発生するか:
Unknown (未調査)
3.8 で発生するか:
Unknown (未調査)

Description

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 (原因)

未調査

Way to fix (修正内容)

History

#1 Updated by kaoru n over 3 years ago

  • Subject changed from activity/search.json no to activity/search.json のパラメータに member_id のみを設定するとサーバエラーが発生する
  • Description updated (diff)

Also available in: Atom PDF