mahara-contributors team mailing list archive

[Robert Lyon <1940033@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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

** Affects: mahara
     Importance: High
         Status: Confirmed

** Affects: mahara/20.04
     Importance: High
         Status: New

** Affects: mahara/20.10
     Importance: High
         Status: New

** Affects: mahara/21.04
     Importance: High
         Status: New

** Affects: mahara/21.10
     Importance: High
         Status: Confirmed

** Changed in: mahara
       Status: New => Confirmed

** Changed in: mahara
   Importance: Undecided => High

** Changed in: mahara
    Milestone: None => 21.10.0

** Also affects: mahara/21.10
   Importance: High
       Status: Confirmed

** Also affects: mahara/21.04
   Importance: Undecided
       Status: New

** Also affects: mahara/20.10
   Importance: Undecided
       Status: New

** Also affects: mahara/20.04
   Importance: Undecided
       Status: New

** Changed in: mahara/21.04
    Milestone: None => 21.04.2

** Changed in: mahara/20.10
    Milestone: None => 20.10.3

** Changed in: mahara/20.04
    Milestone: None => 20.04.5

** Changed in: mahara/21.04
   Importance: Undecided => High

** Changed in: mahara/20.10
   Importance: Undecided => High

** Changed in: mahara/20.04
   Importance: Undecided => High

-- 
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 user when they have a collection with a cover image

Status in Mahara:
  Confirmed
Status in Mahara 20.04 series:
  New
Status in Mahara 20.10 series:
  New
Status in Mahara 21.04 series:
  New
Status in Mahara 21.10 series:
  Confirmed

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