No topics exist pagination bug

Posted: Tue Sep 19, 2006 3:44 pm

I have a few forums that after a certain amount of posts, the pagination will add a page but it's not counting the posts correctly. It's a weird error and kinda hard to explain but when you click on that forum it says that no posts exist for this topic and you have to go to the previous page to see the latest post.

Here's an example:
[ Only registered users can see links on this board! Get registered or login! ]

That page (page 3) has the latest post on it. But there's an extra page in the pagination that doesn't contain any posts (page 4).

It doesn't happen on all forums...just a few and I haven't found any reason why this happens or how to fix it. This has happened on Nuke 7.6 and 7.9 on several different versions of phpbb.

Any ideas?
Thank you for any advice.

Posted: Tue Sep 19, 2006 7:03 pm

Did you delete any users from the database? That will stop their posts from displaying and throw off the counts

Posted: Wed Sep 20, 2006 3:42 am

Yes. And come to think of it, this problem is happening in forums that the old member has posted in. Is there a way to resynch?

Posted: Wed Sep 20, 2006 7:40 am

You'd have to recreate that user

Posted: Wed Sep 20, 2006 7:52 am

In the case of the link I gave above, all the posts from that person have long been deleted. So even bringing back that username wouldn't fix that forum. At least it doesn't seem like it would. All of the posts in that forum have an active user attached to it.
I'm pretty sure the pagination number is created each time a page is loaded by querying the post count and dividing it by the posts per page set in the ACP. Since this is done on each page load, it seems there is something else wrong in the database throwing off the math.

Posted: Wed Sep 20, 2006 12:34 pm

You could try going through the admin panel and hitting Resync on those forums. Don't know if it will help or not

Posted: Wed Sep 20, 2006 12:37 pm

I did, it didn't LOL. I even tried a script from phpbb hacks that seemed like it would fix similar problems by finding posts without users...etc. It worked well fixing discrepancies but still left pagination all screwy.