mahara-contributors team mailing list archive

[Robert Lyon <robertl@xxxxxxxxxxxxxxx>]

** Changed in: mahara/15.04
    Milestone: 15.04.4 => 15.04.5

-- 
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:
  Triaged
Status in Mahara 15.04 series:
  Triaged
Status in Mahara 15.10 series:
  Triaged
Status in Mahara 16.04 series:
  Triaged

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