No posts exist for this topic

dcasmr · **No posts exist for this topic -** 04-25-2006, 01:28 AM

All of a sudden, I am getting the error: "No posts exist for this topic" when I click on a particular FORUM post. I deleted a userID from the database and that could have contributed to my headaches.

Anyhow, I found that I can display the forum post by going directly to this URL:
http://www.mysite.com/modules.php?na...ic&t=7&start=0
Basically, inside admin Panel when I click on the header (first page ) of the post it displays fine.

While reading the replies, I noticed that there is a second page to it. (In reality that does not exist). I think when anyone click on the forum article it is taking the person to the inexisting second page:
ERROR when clicking next.
http://www.mysite.com/modules.php?na...r=asc&start=15

I looked inthe database and the forum has the proper ID #206. So pratically clicking on the URL http://www.mysitet.com/modules.php?n...opic&p=206#206 should work.

I need help badly to get the forum displaying this post.

Thanks
dcasmr

Duke · 04-25-2006, 02:09 AM

Why not just find this post in the database and change the user number for this particular post so it's credited to a current member ID that is in the database?

dcasmr · 04-25-2006, 02:16 AM

Duke,

Thanks for your reply. Could you elaborate more? Could you give me some details as to which tables to look into? The last USER to reply to the post has a USERID = 388
The forum POSTID is #206 and I can see the message inside the database.

The sequence was:

385
387
xxx (386) deleted by me)
388 (last poster)

I had created a userID and changed it to 386, but it did not help.
Thanks,
dcasmr

myrtletrees · 04-25-2006, 12:13 PM

Like Duke said..try changing the post ID for that post in that topic in the Database.

in
nuke_bbposts

Look for that table.

Try changing the poster_id for that topic to one that exists, like your member ID#

change poster_id 386 to your poster_id# for topic_id 206

dcasmr · 04-27-2006, 08:45 AM

Thanks for your explanations. I tried that and it worked as far as bringing the post that was not showing up.
However, when I added a reply to thread, I got the same error again
"No posts exist for this topic"

I checked that the poster_id for the last reply was indeed pointing to the userid of the person who added it (236).
I optimize the databse, and resync with no results.

1.) I optimize all the tables in database.
2.) I re-synch the forum

None of this solved the problem.

Inside phpbb forum administration, when I click on the first page of the thread, it displays fine: see below:
modules.php?name=Forums&file=viewtopic&t=7&start=0

BUT, the next page which really does not contain a posted test is the one that display the error:
modules.php?name=Forums&file=viewtopic&t=7&start=1 5

Any help on how to fix the problem with the thread?

Thanks,
dcasmr

Duke · 04-28-2006, 01:44 AM

It may be slightly too complicated to actually change the post ID because it's likely to be linked in bb_posts, bb_posts_text, bb_search_wordlist, bb_search_wordmatch. I'm not 100% sure if this is the case but if so, you may want to try something else such as:

...if your certain about the user ID that was deleted, simply create a new user in your admin panel, then go into the db and change the user ID# number to match the user you deleted.

or,

...if you really need the thread why not simply copy if from the database and re-post it in the forums if your really stuck?

gsicard · 12-05-2008, 08:09 PM

Backup your database before trying this.

I have a similar issue on a site with over 15,000 members and many post in the forum.

So here is how it was fixed:

First run these queries on the nuke_bbposts table using phpmyadmin.

Step 1.
This gets rid of the '-1' poster_id and changes it to '1' which is the default Anonymous user.

Code:

UPDATE `databasename`.`nuke_bbposts` SET `poster_id` = '1' WHERE `nuke_bbposts`.`poster_id` = '-1';

Step 2.
This query shows you all your poster ids where nuke user id is blank.

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)

Write down all the poster_id values. You may nave to page through the table to get them all.

Step 3.
Then on the nuke_bbposts table run an sql command like this for each poster_id you wrote down in step 2.

Code:

UPDATE `databasename`.`nuke_bbposts` SET `poster_id` = '1' WHERE `nuke_bbposts`.`poster_id` = '??';

replace ?? with the poster_ids you wrote down and run the sql for each id.
someone could probably code this in a .php file for one click operation but I don't know how.

These steps worked for my very large site and took about 30 minutes to complete.
Molosser Dogs