•  
      request #6365 Notice DB error when removing user from project or changing user rights
    Infos
    #6365
    Yannis ROSSETTO (rossettoy)
    2014-03-05 14:34
    2014-03-05 09:21
    6440
    Details
    Notice DB error when removing user from project or changing user rights
    When I remove a user from a project or when I change user rights in project admin, I've got the following notices :

    Notice DB Error ==> DELETE plugin_mediawiki_PROJECT.mwuser_groups FROM plugin_mediawiki_PROJECT.mwuser_groups JOIN plugin_mediawiki_valid_tuleap_6_10.mwuser ON (plugin_mediawiki_PROJECT.mwuser.user_id = plugin_mediawiki_PROJECT.mwuser_groups.ug_user) WHERE plugin_mediawiki_PROJECT.mwuser.user_name = 'USER'

    Notice DB Error ==> INSERT INTO plugin_mediawiki_PROJECT.mwuser_groups(ug_user, ug_group) (SELECT mwuser.user_id, tuleap_mwgroups.real_name AS ug_name FROM plugin_mediawiki_PROJECT.mwuser JOIN user ON (user.user_name = REPLACE(mwuser.user_name, ' ', '_')) JOIN ugroup_user ON (ugroup_user.user_id = user.user_id) JOIN ugroup ON (ugroup.ugroup_id = ugroup_user.ugroup_id AND ugroup.group_id = 102) JOIN plugin_mediawiki_ugroup_mapping ugroup_mapping ON (ugroup_mapping.ugroup_id = ugroup_user.ugroup_id) JOIN plugin_mediawiki_tuleap_mwgroups tuleap_mwgroups ON (tuleap_mwgroups.mw_group_name = ugroup_mapping.mw_group_name) WHERE user.user_id = .108) UNION (SELECT mwuser.user_id, tuleap_mwgroups.real_name AS ug_name FROM plugin_mediawiki_PROJECT.mwuser ...

    Some other information :
    -------------------------------

    MediawikiDao->resetUserGroupsForUser( ) ../mediawikiPlugin.class.php:587
    MediawikiDao->deleteUserGroupsForUser( ) ../MediawikiDao.class.php:237

    MediawikiDao->resetUserGroupsForUser( ) ../mediawikiPlugin.class.php:587
    MediawikiDao->feedMediawikiUserGroupsWithTuleapMapping( ) ../MediawikiDao.class.php:238
    Mediawiki
    development
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Empty
    Declined
    2014-03-05
    Attachments
    Empty
    References
    References list is empty

    Follow-ups

    User avatar
    Was due to badely configured project

    • Status changed from New to Declined
    • Close date set to 2014-03-05
    User avatar
    • Original Submission
      Something went wrong, the follow up content couldn't be loaded
      Only formatting have been changed, you should switch to markup to see the changes
    User avatar
    • Summary
      -Notice DB error when removing user from project 
      +Notice DB error when removing user from project or changing user rights 
    • Original Submission
      Something went wrong, the follow up content couldn't be loaded
      Only formatting have been changed, you should switch to markup to see the changes