mahara-contributors team mailing list archive

[Hugh Davenport <1036664@xxxxxxxxxxxxxxxxxx>]

*** This bug is a duplicate of bug 1034268 ***
    https://bugs.launchpad.net/bugs/1034268

Looks like bug #1034268 that has been fixed. Though i may of been wrong
with mysql, may of been postgres xD

** This bug has been marked a duplicate of bug 1034268
   Can't delete an institution on mysql

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/1036664

Title:
  Deleting institution brings warning

Status in Mahara ePortfolio:
  Invalid

Bug description:
  I want to delete 1 institution from my instance (master). That
  institution had 1 user which I removed from the institution. The user
  does not have any auth method from the institution to be deleted
  anymore. When I attempt the deletion process, the following warnings
  are displayed and a generic "Site unavailable" message displayed.
  Might this be similar to what was already be fixed in Bug #548166?

  [WAR] fb (lib/errors.php:749) Failed to get a recordset: postgres7 error: [-1: ERROR:  update or delete on table "institution" violates foreign key constraint "instdata_ins_fk" on table "institution_data"
  DETAIL:  Key (name)=(test) is still referenced from table "institution_data".] in adodb_throw(DELETE FROM "institution"  WHERE "name" = ? , Array)
  Command was: DELETE FROM "institution"  WHERE "name" = ?  and values was (test)
  Call stack (most recent first):

      log_message("Failed to get a recordset: postgres7 error: [-1: E...", 8, true, true) at /home/kristina/code/mahara/htdocs/lib/errors.php:109
      log_warn("Failed to get a recordset: postgres7 error: [-1: E...") at /home/kristina/code/mahara/htdocs/lib/errors.php:749
      SQLException->__construct("Failed to get a recordset: postgres7 error: [-1: E...") at /home/kristina/code/mahara/htdocs/lib/dml.php:932
      delete_records("institution", "name", "test") at /home/kristina/code/mahara/htdocs/admin/users/institutions.php:168
      delete_submit(object(Pieform), array(size 4)) at Unknown:0
      call_user_func_array("delete_submit", array(size 2)) at /home/kristina/code/mahara/htdocs/lib/pieforms/pieform.php:514
      Pieform->__construct(array(size 2)) at /home/kristina/code/mahara/htdocs/lib/pieforms/pieform.php:161
      Pieform::process(array(size 2)) at /home/kristina/code/mahara/htdocs/lib/pieforms/pieform.php:71
      pieform(array(size 2)) at /home/kristina/code/mahara/htdocs/admin/users/institutions.php:191

  [WAR] fb (lib/dml.php:932) Failed to get a recordset: postgres7 error: [-1: ERROR:  update or delete on table "institution" violates foreign key constraint "instdata_ins_fk" on table "institution_data"
  DETAIL:  Key (name)=(test) is still referenced from table "institution_data".] in adodb_throw(DELETE FROM "institution"  WHERE "name" = ? , Array)
  Command was: DELETE FROM "institution"  WHERE "name" = ?  and values was (test)
  Call stack (most recent first):

      delete_records("institution", "name", "test") at /home/kristina/code/mahara/htdocs/admin/users/institutions.php:168
      delete_submit(object(Pieform), array(size 4)) at Unknown:0
      call_user_func_array("delete_submit", array(size 2)) at /home/kristina/code/mahara/htdocs/lib/pieforms/pieform.php:514
      Pieform->__construct(array(size 2)) at /home/kristina/code/mahara/htdocs/lib/pieforms/pieform.php:161
      Pieform::process(array(size 2)) at /home/kristina/code/mahara/htdocs/lib/pieforms/pieform.php:71
      pieform(array(size 2)) at /home/kristina/code/mahara/htdocs/admin/users/institutions.php:191

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