"No posts exist for this topic"

Nuke Cadet Joined: Feb 02, 2004 Posts: 6

When a thread exceeds 7 pages the pages get out of sync. The index tells more pages than really are. When I click on the latest post or page I get the message ""No posts exist for this topic"

I resync the forum, without luck. Also I have no post usernames with -1.

Please advice.

Nuke Soldier Joined: Dec 19, 2003 Posts: 32

Just had this error with one of my topics but it was when it went to page 6. i sync'd in forum admin but no luck.

running 7.1 from raven.
any ideas?

Nuke Cadet Joined: May 11, 2003 Posts: 5

Are you using block-phpBB_Forums block at the main page? We use it, an we have the same problem.

I recently got this error, but only clicking the topic name at the main page, in this block. But when I search for the topic at the Forum (via the Forum link at the left), and click the topic name I can see the topic. This is because when you click the topic name at the Forum, the link points to the topic, not to the post. In the main page, the link points to the post. When the posts number reaches x times the number of the displayed post in one page, the error occurs. For example, if you set the number of the diplayed posts at one page to 40, and you have 81 posts, the error occurs, but only when you click to the link containing the post number at the main page.

I hope sometime somebody will resolve this problem.

Nuke Cadet Joined: Feb 02, 2004 Posts: 6

Is there no one who can help solving this problem *bump*

Nuke Soldier Joined: Dec 19, 2003 Posts: 32

still looking for some help on this one also. just had it happen to another thread.

Nuke Soldier Joined: May 24, 2003 Posts: 22

I'm looking for help too. If you know anything, please post Smile

Nuke Cadet Joined: Jan 14, 2004 Posts: 5

Same problem here.

Nuke Cadet Joined: Feb 02, 2004 Posts: 6

Glad I'm not the only one with this problem. To bad no solution is posted yet.

Nuke Cadet Joined: Jun 16, 2004 Posts: 1

I know how to solve such problem! Rolling Eyes

This bug is because u have deleted some users from your DB.
So u can watch yuor SQL DB and find what user id's are missing though the table (phpbb/nuke)_users. For example:
Here are user_id's
1
2
3
5
Here u can see that user id 4 is missing, so u can create it or u can change the value 'user_id' at (phpbb/nuke)_posts.

So how did I... I found missing user_id's and created users with such id's, and then deleted their posts! Razz

So the main problem is the missing user id's in the (phpbb/nuke)_users.

____________
I hope that it can solve your problems.
Sorry for my possible mistakes, I'm Russian.
If u'll have some questions, u can [url=mailto:ms_m@bk.ru]mail me[/url].
Good LUCK! Laughing

Nuke Cadet Joined: Feb 02, 2004 Posts: 6

Thanks Stringy, that solved my problem. Very Happy

Posted: Fri Sep 17, 2004 2:22 am

I had the very same problem, but this didn't worked out for me.
For some reason the posts that has been made by deleted users has now as poster_id the value of '-1'.
That user didn't exist in my db so I was getting this error. When I created the user problems stopped.
Also now is shown as poster name the name of user with id '-1' instead of the real one.
Is this normal or there is a fix about?
Phpnuke version is 6.5 and upgrade is not possible at the time... Smile

thanks

Nuke Cadet Joined: Jan 03, 2005 Posts: 2

I have the same "No posts exist for this topic". I know for my case, it is due to some users being deleted not by me but it happen once in a while. The database goes corrupted and I have to 'repair' the db. After I 'repair', sometime, users get deleted.

What I will do is backup everynight so that I can refer back which user is missing.

But the problem now is that I have close to 4000 members. It will be difficult for me to check the user_id in sequence.

Is there a SQL that can check which user_id is missing?

Thanks.

Nuke Cadet Joined: Jan 03, 2005 Posts: 2

i found something that checks for which post's poster is missing

Code:

SELECT nuke_bbposts.poster_id, nuke_users.username
FROM nuke_bbposts
LEFT JOIN nuke_users
ON nuke_bbposts.poster_id = nuke_users.user_id
WHERE (nuke_users.username IS NULL)

so, once i know their id, i will search in a backup copy of the database and insert them back to the online db.

but i still can't find missing members who did not post.

anyone?

Nuke Cadet Joined: Oct 12, 2005 Posts: 2

I have just set up nuke 7.7 (phpbb2.0.14) and am trying to transfer an existing forum (phpbb2.0.15) to it. I have tried over and over, and the only problem I have now, is that i get the "No posts exist for this topic" message whenever I try to read posts. ALL topics are doing this. The admin panel shows the posts (985 of them) but I cannot get them to display.
I checked for deleted users (there are none)
I checked for the -1 ids and changed them all to 1 with no effect.
I re-synced everything with the admin page.

I'm hoping somone can help! Very Happy

Site Admin Joined: Aug 17, 2003 Posts: 12373

What do you have in your topics tables?