Issues going missing!!

[ugogo.info]

Hi!

We're shocked, stunned and not a little amazed and seriously need help!

We installed mantis 1.1.8 ( a clean install, no upgrades) and have been using it for over 3 weeks. Suddenly issues disappeared!

When we try to insert their number in the view issue link of another issue, we get this report:

APPLICATION ERROR #1100

Issue 57 not found.

Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.

Please help!

We need them back!

[atrol]

Check the contens of your database.
If you don't find your issues in table mantis_bug_table someone probably removed them.

I hope you have a daily backup.

[ugogo.info]

Hi!

Well these ones missed the backup.

Thanks, I check as you suggested, and they definitely are no longer in the table.

I check with the other two administrators, and they don't know how to delete issues.

Is there any way to get a log to find out how deleted them?

[ugogo.info]

Hi atrol

Thanks for that information. Yes, they are misising from that table. So I've downgraded the other two administrators to managers and disallowed everyone so that they cannot delete issues.

Is there anywhere I can view a log of who deleted issues? The changelog link just gives me a blank page.

Thanks!

[atrol]

Is there anywhere I can view a log of who deleted issues? The changelog link just gives me a blank page.

AFAIK there is no way to get this information with "normal" tools. Deleting an issue deletes all of it including the entries in the history table.
If it is important for you, maybe someone with a deep knowledge of database is able to recover the information.

[ugogo.info]

OK great, thanks vm. Well I made sure nobody but me can delete issues, so if they still go missing I might have to get a log created.

But so far so good.

[sjenkinsdc]

I've just had this same issue. Many of our issues have just disappeared. How could this have happened? I find it hard to believe that someone went in and willy nilly deleted random issues.

[atrol]

AFAIK there is no known bug in MantisBT related to lost issues.
You could check your webserver logs, whether there are entries for issue removals.

[ugogo.info]

Hi sjenkinsdc

I don't know if this will help you, but I have been experimenting trying to replicate what caused them to disappear, and I think I figured it out.

I made a new project, then created issues in that project.
Then I deleted the project, expecting the issues to moved up to the parent project.
But they weren't, they just disappeared.

I remember at the time I was re-organising the hierarchy of our projects, so I guess that is how our issues went missing.

Did that help at all?

[srouleau]

Hi sjenkinsdc
Then I deleted the project, expecting the issues to moved up to the parent project.
But they weren't, they just disappeared.

Ouch. Unfortunately for you, I think Mantis did the right thing -- deleting a project should delete its issues, just like moving a project to become a 'child' of another project should ... move the defects with it.

Steph