← Back to team overview

mahara-contributors team mailing list archive

[Bug 1223810] Re: Multiple institutions breaks institution move

 

Hi Howard,

You should be able to do it with a couple of update statements in the
DB.

UPDATE usr_institution SET institution = X WHERE institution = Y;

UPDATE usr SET authinstance = A WHERE authinstance = B;

If you're using MNet or SAML then you should also update the users'
records in the auth_remote_user table.

UPDATE auth_remote_user SET authinstance = A WHERE authinstance = B;

Since it sounds like there's not actually a Mahara bug here, I'm going
to go ahead and close this bug.

Cheers,
Aaron

** Changed in: mahara
       Status: New => Invalid

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1223810

Title:
  Multiple institutions breaks institution move

Status in Mahara ePortfolio:
  Invalid

Bug description:
  Bug found in 1.6

  Where there are multiple institutions and membership of multiple
  institutions are permitted the bulk move of users from one institution
  to another is broken.

  The bulk move refuses to consider users who are in more than one
  institution. See code in htdocs/admin/users/bulk.php for the function
  changeauth_validate(). The validation simply fails if there is more
  than one institution record for the user.

  So, if I select all users in an institution and them attempt to move
  them to a different institution and there are ANY users in multiple
  institutions in the list the move will fail for all users.

  Worse - I can't think of any obvious workaround.

  What I want is for *just* the institution that I selected to be moved
  to the alternate institution. There would also need to be a check that
  this didn't result in a duplicate if they were in that institution
  already.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1223810/+subscriptions


References