Doesn't look like we ever update FQN_TOTAL_TOPICS value in the cache. As a result, when we add and delete posts, the pagination value becomes off.
I have playing around with the JForum code for over a month now, and I feel not adopting Hibernate is the BIGGEST weakness of JForum. Developers have to understand and maintain a separate cache layer on top of the DAO code. This is error prone and the bugs are very hard to detect.
Hope the new version will be released soon, and I hope I don't have to rip apart all my customized codes In the area of DB access and Search, JForum is behind MvnForum and JBoss's Forum. [originally posted on jforum.net by sru]