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