** Changed in: mahara/21.04
Status: Confirmed => Fix Committed
** Changed in: mahara/20.10
Status: Confirmed => Fix Committed
** Changed in: mahara/20.04
Status: Confirmed => Fix Committed
--
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: mahara-contributors
https://bugs.launchpad.net/bugs/1940033
Title:
Unable to delete account when they have a collection with a cover
image
Status in Mahara:
Fix Committed
Status in Mahara 20.04 series:
Fix Committed
Status in Mahara 20.10 series:
Fix Committed
Status in Mahara 21.04 series:
Fix Committed
Status in Mahara 21.10 series:
Fix Committed
Bug description:
We get ERROR: update or delete on table "artefact" violates foreign
key constraint "coll_cov_fk" on table "collection"
To test:
1) New site
2) Log in as admin and create a new user
3) Masquerade as new user
4) add a page
5) add a collection and add a cover image to the collection
6) add page to collection
7) stop masquerading (be admin again)
8) click on the 'Suspend or delete this account' and chose delete account
Expected result account is deleted
Actual outcome get error
The problem is the coverimage artefact id is still in the collection
table when we try to delete the artefact.
In the delete_user() function the deletion of artefacts happens before
the deletion of collections
We should maybe try those the other way around
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1940033/+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
