Donate Bitcoin

Donate Paypal


PeakOil is You

PeakOil is You

"No posts exist for this topic" error

Having trouble? Is the forum having trouble?

Moderator: admin

Re: "No posts exist for this topic" error

Unread postby TWilliam » Fri 14 Sep 2007, 22:23:38

Hi Shannymara,

The "bug" you're referring to is a result of posts being deleted from any particular thread showing this problem; apparently the database does not decrement the value in the field that keeps track of the number of posts when deletions occur. Tho' I don't know what the relevant field is named nor the table in which it resides, if this site is a typical LAMP-based forum (Linux, Apache, MySQL, Php), then it's not that difficult to access the database using tools such as MySQL Administrator to manually correct the increment. Of course, you need admin access to the database to do so...
"It means buckle your seatbelt, Dorothy, because Kansas? Is goin' bye-bye... "
User avatar
TWilliam
Expert
Expert
 
Posts: 2591
Joined: Sun 28 Nov 2004, 04:00:00

Re: "No posts exist for this topic" error

Unread postby admin » Sun 08 Jun 2008, 16:48:43

Thanks Shannymara. I think all the links are fixed now.
User avatar
admin
l33t
l33t
 
Posts: 259
Joined: Sun 29 Feb 2004, 04:00:00
Location: Cambridge, MA

Re: "No posts exist for this topic" error

Unread postby admin » Sun 08 Jun 2008, 18:45:13

Happy Birthday --

I used both the fix you posted and this new fix here:
http://www.phpbb.com/community/viewtopi ... 8&t=135383

I'm going to unsticky -- since it should be solved for now.
User avatar
admin
l33t
l33t
 
Posts: 259
Joined: Sun 29 Feb 2004, 04:00:00
Location: Cambridge, MA

Re: "No posts exist for this topic" error

Unread postby MD » Sun 08 Jun 2008, 23:49:54

Happy birthday!
Stop filling dumpsters, as much as you possibly can, and everything will get better.

Just think it through.
It's not hard to do.
User avatar
MD
COB
COB
 
Posts: 4953
Joined: Mon 02 May 2005, 03:00:00
Location: On the ball

Re: "No posts exist for this topic" error

Unread postby joewp » Mon 29 Dec 2008, 21:51:17

Since this still seems to be a problem, if any of the people with access to the board's php code want to try it, there's a hack to phpBB2 here that should be a quick and dirty fix to the problem. While it won't prevent the issue from happening in the first place, it will correct the errors in the database that cause the pagination to be wrong, resulting in the message "No posts exist for this topic". It also does other things to help keep the database in order and in sync and it's been around for several years and people on the phpBB forums recommend it. Here's a thread on the phpBB forums in which this issue is discussed and praise heaped on the above hack for fixing the issue.

I could help if necessary.
Joe P. joeparente.com
"Only when the last tree is cut; only when the last river is polluted; only when the last fish is caught; only then will they realize that you cannot eat money." - Cree Indian Proverb
User avatar
joewp
Intermediate Crude
Intermediate Crude
 
Posts: 2054
Joined: Tue 05 Apr 2005, 03:00:00
Location: Keeping dry in South Florida


Return to Technical Support

Who is online

Users browsing this forum: No registered users and 201 guests