Delete Issue through the UserInterface does not delete related entris in bug_file and bug_history table

[TimS]

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

[atrol]

Looks like something is broken on your system.
I tried and entries in tables mantis_bug_file_table and mantis_bug_history_table were deleted.

[TimS]

(Kind of) good to know.
What could have gone wrong? We did not alter the schema nor did we change anything in the PHP code.

(Btw. we are using Mantis 2.25.4, i corrected that in the original post.)

[atrol]

2.25.4 is pretty outdated, it makes not that much sense to investigate based on that version.
Could you update to the lastest version, or at least to 2.25.8?

Check also your webserver and database logs for any errors or warnings.

[TimS]

Ok, i will get back to you if the upgrade is done!

[TimS]

I updated our setup to the latest version - 2.27.0 and the correct schema. And this seemed to have fixed the issue we hat with the database.

[atrol]

Glad to hear that it works.