mahara-contributors team mailing list archive

[Aaron Wells <1471227@xxxxxxxxxxxxxxxxxx>]

Hi Howard

That error message sounds like there are still users in your database
who are set to use one the institution's authentication methods. You'll
need to change them to use an authentication method for a different
institution. There are some instructions for that on the Mahara manual:
http://manual.mahara.org/en/15.04/administration/users.html#change-the-
authentication-method-and-remote-username-in-bulk

If you removed all those members from the institution already, though,
Mahara should have changed their authentication methods at that time. So
that's a bug, if they're still linked to the old auth method.

Can you provide some more details? What steps did you take to remove
these users from the institution?

Cheers,
Aaron

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

-- 
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/1471227

Title:
  Unable to delete an institution

Status in Mahara ePortfolio:
  Incomplete

Bug description:
  Mahara 15.04. MySQL database

  Removed all users from an Institution and attempted to delete it. On
  confirmation am SQL error was generated:

  [WAR] f4 (lib/errors.php:747) Failed to get a recordset: mysqli error: [1451: Cannot delete or update a parent row: a foreign key constraint fails 
  ("mahara15"."auth_remote_user", CONSTRAINT "authremouser_aut_fk" FOREIGN KEY ("authinstance") REFERENCES "auth_instance" ("id"))] in adodb_throw(DELETE FROM "auth_instance"  WHERE "institution" = 'education' , )
  Command was: DELETE FROM "auth_instance"  WHERE "institution" = ?  and values was (education)

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