•  
      request #16187 Administration of project members is broken on new instances
    Infos
    #16187
    Thomas Gerbet (tgerbet)
    2020-08-05 10:08
    2020-08-04 15:26
    17449
    Details
    Administration of project members is broken on new instances
    Issues have been introduced by request #16149.

    The user autocompleter throws warnings and the SQL query to retrieve the project members does not work at all.

    The administration of project members is not the only parts being affected but it's the only one that does not work at all.

    Traces:
    2020/08/04 07:00:50 [error] 1387#0: *1191 FastCGI sent in stderr: "PHP message: PHP Notice: Error encountered while retrieving data ==> SELECT
    user.realname,
    user.user_id,
    user.user_name,
    user.email,
    user.status,
    user_group.admin_flags,
    user_group.wiki_flags,
    user_group.forum_flags,
    user_group.news_flags,
    user.has_avatar,
    IF(generic_user.group_id, 1, 0) AS is_generic,
    GROUP_CONCAT(DISTINCT ugroup_user.ugroup_id) AS ugroups_ids
    FROM user_group
    INNER JOIN user
    ON (
    user.user_id = user_group.user_id
    )
    LEFT JOIN generic_user
    ON (
    generic_user.user_id = user.user_id
    AND generic_user.group_id = 126
    )
    ...PHP message: PHP Warning: Invalid argument supplied for foreach() in /usr/share/tuleap/src/common/Project/Admin/ProjectMembers/ProjectMembersController.php on line 339" while reading response header from upstream, client: 172.22.0.4, server: tuleap, request: "GET /project/126/admin/members HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "tuleap", referrer: "https://tuleap/project/admin/editgroupinfo.php?group_id=126"
    2020/08/04 07:00:51 [error] 1387#0: *1186 FastCGI sent in stderr: "PHP message: PHP Notice: Undefined index: has_avatar in /usr/share/tuleap/src/www/user/autocomplete.php on line 107" while reading response header from upstream, client: 172.22.0.4, server: tuleap, request: "GET /user/autocomplete.php?return_type=json_for_select_2&name=ProjectMember&page=1&codendi_user_only=0&project_id=126 HTTP/1.1"
    Other
    development
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Thomas Gerbet (tgerbet)
    Closed
    2020-08-05
    Attachments
    Empty
    References

    Follow-ups