mahara-contributors team mailing list archive

[Kathrin Wunderlich <2003860@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

When deleting a old user account an nonrecoverable error occured. As far
as I can tell, a constraint on the artefact table in the parent column
is responsible for this, when the query "DELETE FROM `artefact` WHERE id
IN (id1,id2)" is executed. id1 is a comment and id2 is a reply to that
comment. With other words, id2 has id1 as its parent. Point 3 of the
answer of ypercube in this discussion
(https://dba.stackexchange.com/questions/153420/mysql-delete-row-that-
has-a-foreign-key-constraint-which-reference-to-itself/153424) might be
an explanation.

I can not reproduce a reply to a comment with our currently installed
Mahara version (e.g. I can't find a reply-button), but according to the
manual for our version there should be (or at least was) the option to
reply (see the picture under
https://manual.mahara.org/en/22.04/portfolio/feedback.html). I also have
more DB entries of this kind.

Since not all data of the deleted user was deleted due to the error/bug,
any help to delete/find the remaining data would be appreciated.

We run Mahara 22.04.3 on MySQL 8.0.31 and PHP7.4. I attached the
redacted apache error log.

** Affects: mahara
     Importance: Undecided
         Status: New

** Attachment added: "Apache Error Log"
   https://bugs.launchpad.net/bugs/2003860/+attachment/5643341/+files/apache-error.log_edit.txt

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

Title:
  Nonrecoverable error on account deletion

Status in Mahara:
  New

Bug description:
  When deleting a old user account an nonrecoverable error occured. As
  far as I can tell, a constraint on the artefact table in the parent
  column is responsible for this, when the query "DELETE FROM `artefact`
  WHERE id IN (id1,id2)" is executed. id1 is a comment and id2 is a
  reply to that comment. With other words, id2 has id1 as its parent.
  Point 3 of the answer of ypercube in this discussion
  (https://dba.stackexchange.com/questions/153420/mysql-delete-row-that-
  has-a-foreign-key-constraint-which-reference-to-itself/153424) might
  be an explanation.

  I can not reproduce a reply to a comment with our currently installed
  Mahara version (e.g. I can't find a reply-button), but according to
  the manual for our version there should be (or at least was) the
  option to reply (see the picture under
  https://manual.mahara.org/en/22.04/portfolio/feedback.html). I also
  have more DB entries of this kind.

  Since not all data of the deleted user was deleted due to the
  error/bug, any help to delete/find the remaining data would be
  appreciated.

  We run Mahara 22.04.3 on MySQL 8.0.31 and PHP7.4. I attached the
  redacted apache error log.

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