Delete Issue through the UserInterface does not delete related entris in bug_file and bug_history table
Posted: 21 Nov 2024, 20:15
Hello dear maintainers,
we are running MantisBt since forever. One Project contains almost 100000 entries with several attachments ranging from logfiles to sometimes 40MB huge files. This project exists since 2012. Running filters on this project takes an aweful amount of time, so we decided to prune the oldest entries.
We started doing this through the UserInterface (no sql). Out of curiosity i checked what happens with the related tables and i discovered the following:
* mantis_bug_file_table : entries related to an issue do not get deleted if the issue itself gets deleted
* mantis_bug_history_table: applies also here
Is that by design or is our schema broken? I could not find anything in the admin guide.
Thank in advance and for this awesome tool!
Tim
We are running MantisBt 2.25.4 with Schema Version 211 and MariaDb 10.11.4. PHP is on 8.0.13
we are running MantisBt since forever. One Project contains almost 100000 entries with several attachments ranging from logfiles to sometimes 40MB huge files. This project exists since 2012. Running filters on this project takes an aweful amount of time, so we decided to prune the oldest entries.
We started doing this through the UserInterface (no sql). Out of curiosity i checked what happens with the related tables and i discovered the following:
* mantis_bug_file_table : entries related to an issue do not get deleted if the issue itself gets deleted
* mantis_bug_history_table: applies also here
Is that by design or is our schema broken? I could not find anything in the admin guide.
Thank in advance and for this awesome tool!
Tim
We are running MantisBt 2.25.4 with Schema Version 211 and MariaDb 10.11.4. PHP is on 8.0.13