mahara-contributors team mailing list archive

[Kristina Hoeppner <2003860@xxxxxxxxxxxxxxxxxx>]

Hi Kathrin,

This sounds like someone would need to double check your code or your
specific database. This is not possible via the free support.

I'll send you a message.

Thank you
Kristina

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

-- 
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:
  Invalid

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