OpenPNE 3

activity/community.json を用いるために opTimelinePlugin を入れた状態で コミュニティホーム を閲覧するとチケットのエラーが発生し続ける場合がある．これは一度発生した OpenPNE では継続的に発生するものであると思われる．

エラーが発生するリクエストは下記URLである．ただし，下記URLは URL と apiKey を差し替えている．

http://sns.example.com/api.php/activity/search.json?count=20&since_id=&target=community&target_id=2&count=20&post%5Bforeign%5D=community&post%5BforeignId%5D=2&notify%5Blib%5D=http%3A%2F%2Fsns.example.com%2FopTimelinePlugin%2Fjs%2Fjquery.desktopify.js&notify%5Btitle%5D=%E3%81%B5%E3%81%9F%E3%81%A4%E3%82%81+%E3%81%AE%E6%9C%80%E6%96%B0%E6%8A%95%E7%A8%BF&timer=5000&apiKey=******

レスポンス

{"error":{"code":500,"message":"Internal Server Error"}}

Jul 06 22:07:44 symfony [info] {Doctrine_Connection_Statement} execute : SELECT m.id AS m__id, m.member_id AS m__member_id, m.name AS m__name, m.value AS m__value, m.value_datetime AS m__value_datetime, m.name_value_hash AS m__name_value_hash, m.created_at AS m__created_at, m.updated_at AS m__updated_at, m2.id AS m2__id, m2.name AS m2__name, m2.invite_member_id AS m2__invite_member_id, m2.is_login_rejected AS m2__is_login_rejected, m2.created_at AS m2__created_at, m2.updated_at AS m2__updated_at, m2.is_active AS m2__is_active FROM member_config m LEFT JOIN member m2 ON m.member_id = m2.id WHERE (m.value = ? AND (m2.is_active = ? OR m2.is_active IS NULL)) LIMIT 1 - (******, 1)
Jul 06 22:07:44 symfony [info] {Doctrine_Connection_Statement} execute : SELECT m.id AS m__id, m.member_id AS m__member_id, m.name AS m__name, m.value AS m__value, m.value_datetime AS m__value_datetime, m.name_value_hash AS m__name_value_hash, m.created_at AS m__created_at, m.updated_at AS m__updated_at FROM member_config m WHERE (m.member_id = ?) - (1)
Jul 06 22:07:44 symfony [info] {Doctrine_Connection_Statement} 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 (?, ?, ?, ?)) OR (a.member_id IN (SELECT m2.member_id_to AS m2__member_id_to FROM member_relationship m2 WHERE (m2.member_id_from = ? AND m2.is_friend = 1 AND m2.member_id_to NOT IN (?, ?, ?, ?))) AND a.public_flag IN (?, ?)) OR a.public_flag IN (?, ?, ?)) AND a.foreign_table = "community" AND a.foreign_id = ? AND EXISTS (SELECT c.id AS c__id, c.community_id AS c__community_id, c.member_id AS c__member_id, c.is_pre AS c__is_pre, c.is_receive_mail_pc AS c__is_receive_mail_pc, c.is_receive_mail_mobile AS c__is_receive_mail_mobile, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM community_member c WHERE (c.member_id = a.member_id AND c.community_id = ?)) AND a.id > ? 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 - (1, 3, 2, 1, 0, 1, 3, 4, 2, 1, 0, 1, 0, 2, 2, , 1)
Jul 06 22:07:44 symfony [err] {Doctrine_Connection_Mysql_Exception} SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

また、他の環境では下記のようなSQLが構築されているようである．

Apr 26 18:06:28 symfony [info] {Doctrine_Connection_Statement} 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 (?, ?, ?, ?)) OR (a.member_id IN (SELECT m2.member_id_to AS m2__member_id_to FROM member_relationship m2 WHERE (m2.member_id_from = ? AND m2.is_friend = 1 AND m2.member_id_to NOT IN (?, ?, ?, ?))) AND a.public_flag IN (?)) OR a.public_flag IN (?, ?, ?)) AND a.foreign_table = "community" AND a.foreign_id = ? AND EXISTS (SELECT c.id AS c__id, c.community_id AS c__community_id, c.member_id AS c__member_id, c.is_pre AS c__is_pre, c.is_receive_mail_pc AS c__is_receive_mail_pc, c.is_receive_mail_mobile AS c__is_receive_mail_mobile, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM community_member c WHERE (c.member_id = a.member_id AND c.community_id = ?)) 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 - (1, 3, 2, 1, 0, 1, 2, 2, 1, 0, 1, 0, 2, 2, 1)
Apr 26 18:06:28 symfony [err] {Doctrine_Connection_Mysql_Exception} SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

更新履歴 f9eaaaf97258be8b38d4b6e9e36d79195481d5fc で適用されました。

#3135 でサブクエリに関する問題の別チケットを作成しました。