Help me: Bug in Admin Control Pannel

[Migrated From Jforum.net]

Hello,

I found this Bug in Jforum 2.1.7:

Step 1: create a forum with moderating role

Step 2: User A create a new topic

Step 3: User B goes into the topic and would like to provide an answer. For this user B open "post reply" dialog.

Step 4: During user B opend this window ("post reply"), the topic deleted by a moderator. User B send the answer.
User B get the message, that it is a moderated forum and that the answer must be activated by a moderator.

Step 5:
In Admin Control Pannel is the counter for the messages, that must be activated, is not correct.
The Answer from user B will be counted. This is the Bug: you can see a list of Messages (counter), but the message is not exist, becouse the topic is deleted.

Any idea for the solution?

I think, that the info Object in CenericModerationDao get wrong values.

Line 194:

info.addInfo(rs.getString("forum_name"), rs.getInt("forum_id"), rs.getInt("total"));

Thsi part retrieve wrong value:

rs.getInt("total")

Thanks 8) ,

No Spam
[originally posted on jforum.net by nospam]

[Migrated From Jforum.net]

Sorry, this line retrieve right values:

rs.getInt("total")

But the problem is not solved. In DB exist post, which not exist realy. This messages will be counted in Admin Control Panel.

I need a solution for this problem... ;o)
[originally posted on jforum.net by nospam]

[Migrated From Jforum.net]

Possible solution:
Before saving an answer you can check whether a topic still exist.

If no -> throw an exception, If yes --> save the message

Where and how I can check this?
[originally posted on jforum.net by nospam]

[Migrated From Jforum.net]

.
[originally posted on jforum.net by nospam]