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
_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to : [email protected]
Unsubscribe : https://launchpad.net/~mahara-contributors
More help : https://help.launchpad.net/ListHelp
