"No posts exist for this topic" error

Shannymara · Master Joined: Oct 04, 2004 Posts: 5395 Location: Oklahoma

There is a bug in the message board software that sometimes causes the post count in threads to be larger than it should be. The software might think a thread contains 100 posts when in fact it only has 90, for example. When that happens, you will get an error that says "No posts exist for this topic" if you click on the "extra" page links, or if you try to go directly to the last post.

If you get that error, you can still view the last messages in the thread. You can either click on lower page number links until you see the messages, or you can manually decrease the last number in the link. For example, you could change

http://www.peakoil.com/fortopic32079-30.html

to

http://www.peakoil.com/fortopic32079-25.html

In that example, you're saying you want to view the thread starting with the 25th message instead of the 30th. Lower the number until you no longer get the error.

I am researching ways to fix this to suggest to the site owner, but meanwhile please use the above workaround if you get that error. Thanks!
_________________
"Every junkie's like a setting sun..." - Neil Young

TWilliam · Light Sweet Crude Joined: Nov 28, 2004 Posts: 1698

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... "

Shannymara · Master Joined: Oct 04, 2004 Posts: 5395 Location: Oklahoma

Yup.

Discussion about the problem, with link to a hack that will fix it.

I think manually editing the db would be too tedious, because there are so many threads with that problem, and we'd probably miss some as well. From what I can tell, that hack will correct all of the errors at once.

Thanks for your input.
_________________
"Every junkie's like a setting sun..." - Neil Young

Shannymara · Master Joined: Oct 04, 2004 Posts: 5395 Location: Oklahoma

"Bump" (pseudo-bump since this is a sticky) to let y'all know I'm still working on this issue...
_________________
"Every junkie's like a setting sun..." - Neil Young

admin

Thanks Shannymara. I think all the links are fixed now.

Shannymara · Master Joined: Oct 04, 2004 Posts: 5395 Location: Oklahoma

Thanks for working on it, Dan. I just checked a few of the long threads, and still get the error. E.g.:

http://www.peakoil.com/fortopic10093-750.html

http://www.peakoil.com/fortopic10541-495.html

If you guys can get that fixed, I'll go:

qgreenjumpers

And it would be a great birthday present, too.
_________________
"Every junkie's like a setting sun..." - Neil Young

admin

Happy Birthday --

I used both the fix you posted and this new fix here:
http://www.phpbb.com/community/viewtopic.php?f=18&t=135383

I'm going to unsticky -- since it should be solved for now.

Shannymara · Master Joined: Oct 04, 2004 Posts: 5395 Location: Oklahoma

Thank you!!! Very Happy

_________________
"Every junkie's like a setting sun..." - Neil Young

MD

Happy birthday!
_________________
"Don't ever become a pessimist... a pessimist is correct oftener than an optimist, but an optimist has more fun, and neither can stop the march of events."
Robert A. Heinlein

md@peakoil.com