When deleting a project with children, the database seems to become corrupted
After I deleted a project that contained children, issues of the projects of the affected rows showed up in the wrong project. I examined the database, and the lft and rgt columns of the project table in the database seemed to become corrupted. For some projects, the rgt value became less than the lft value. I was only able to fix this by manually editing the lft and rgt columns of the projects table.
Suggest making this a very high priority to fix if it is not already fixed -- this bug has the potential to show issues in the wrong project, which is a real security concern for those of us counting on redmine to keep issues contained in the correct projects.
Observed this in a recent 0.9-stable branch build, but not the latest, will try to determine exact build number and post here.