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