mahara-contributors team mailing list archive

[Lisa Seeto <1843509@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

1. Have an institution test, then add a few members
2. Go to the user search, filter by institution and select all members
3 Select edit selected users, then delete them

Expected results, users are successfully deleted
Actual results:
warnings are produced and Mahara site becomes unavailable.
One of the warnings: 

[WAR] c8 (lib/errors.php:859) Failed to get a recordset: postgres8 error: [-1: ERROR:  update or delete on table "view" violates foreign key constraint "arteanno_vie_fk" on table "artefact_annotation"
DETAIL:  Key (id)=(261) is still referenced from table "artefact_annotation".] in adodb_throw(DELETE FROM "view"  WHERE "id" = ? , Array)Command was: DELETE FROM "view"  WHERE "id" = ?  and values was (0:261)

** Affects: mahara
     Importance: High
     Assignee: Lisa Seeto (lisaseeto)
         Status: In Progress

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

Title:
  Bulk delete of users results in warning message and site unavailable

Status in Mahara:
  In Progress

Bug description:
  1. Have an institution test, then add a few members
  2. Go to the user search, filter by institution and select all members
  3 Select edit selected users, then delete them

  Expected results, users are successfully deleted
  Actual results:
  warnings are produced and Mahara site becomes unavailable.
  One of the warnings: 

  [WAR] c8 (lib/errors.php:859) Failed to get a recordset: postgres8 error: [-1: ERROR:  update or delete on table "view" violates foreign key constraint "arteanno_vie_fk" on table "artefact_annotation"
  DETAIL:  Key (id)=(261) is still referenced from table "artefact_annotation".] in adodb_throw(DELETE FROM "view"  WHERE "id" = ? , Array)Command was: DELETE FROM "view"  WHERE "id" = ?  and values was (0:261)

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