No posts exist for this topic

Worker Joined: Feb 06, 2004 Posts: 147

I deleted a user from my forum and as a result (I think) I am now getting the error message No posts exist for this topic.

I went to Forums and clicked on Resync but that did not help. I also saw a post stating to create a user with the missing ID and then deleting their posts. See below from Nukecops:

Code:

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!  


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

P.S. The error message happens with ONLY one post.
I do not understand that message. If you create a USERID, that means it is a brand new one with no post. In any case, I created a USERID from my site login and then changed the ID to the missing one (386).

Still, I cannot get the posts displayed. I need any pointers or if you understand the above reply better than I do, please help.

Thanks,
dcasmr

Posted: Mon Apr 24, 2006 9:04 pm

I went to admin and click on the FORUM. From there, I clicked on the offending
post. It has two pages 1 and 2. If I click on 1 the posted message displays fine.
If I click on 2, I get "No posts exist for this topic"
[ Only registered users can see links on this board! Get registered or login! ]
displays fine.

I know I am close, but do not know what else to do. Maybe, if I could delete page 2? But then, when I click on that, I get the error message.

The offending page is: [ Only registered users can see links on this board! Get registered or login! ]

Any one?
Thanks

Sorry did not mean to reply to my own post, but add the new info.... I would like to delete it...

Posted: Tue Apr 25, 2006 5:52 am

How again did you delete the user? The reason I ask is that from the Administration Control Panel, the User function, that delete will set the posts back to the anonymous used id of "1".

Posted: Tue Apr 25, 2006 6:05 am

Montego,
Thanks for replying. I deleted the user from nuke_users table in the database. I am very puzzled that inside admin panel, when I click on Forums and double-click on the header of the posted message, it displays when it is at firts page [ Only registered users can see links on this board! Get registered or login! ]

Someone suggested in Nukecops to ran SQL codes to find posts with missing posters with the following:
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)

When I do I get:
1 NULL
1 NULL
1 NULL
1 NULL
1 NULL
1 NULL
1 NULL
1 NULL
1 NULL
53 NULL

But do I do with such? Delete them from Nuke_user table?

Thanks,
dcasmr

Posted: Tue Apr 25, 2006 6:43 am

First of all, deleting users directly out of the nuke_users table is not a good idea, as you have found. There are about 10 - 12 different SQL updates that are made in the User admin module when a user is deleted and it is intended to make sure all references to that user are set somewhere rather than being left in "limbo".

Regarding that query, I would suggest including the field "post_id" on that query so that you can find each post in the table. Was user "53" the one that you originally deleted?

Posted: Tue Apr 25, 2006 6:53 am

The user I deleted had an ID 386. My Nuke_user table looked like
385
387
With a missing 386. So I created a dummy user with a userID 386 but that did not help. The query above is pointing to things probably not directly related because it was working before I deleted the user two days. I updated to bbtonuke 2.20 with no success and I not sure if patching to 3.2 will help.
Here is when I add post_id in query

poster_id post_id username
1 12 NULL
1 13 NULL
1 15 NULL
1 26 NULL
53 29 NULL
1 31 NULL
1 32 NULL
1 34 NULL
1 35 NULL
1 38 NULL

Thanks

Posted: Tue Apr 25, 2006 7:06 am

Are any of these posts the one causing the issue?

By the way, I am not accustomed to seing user "1" having no username. I have checked all my installations, and mine say "Anonymous". Not sure that has anything to do with this.

Posted: Tue Apr 25, 2006 7:11 am

I do not think so because I have been deleting users from nuke_user table a long time ago and the forum where working. The post that is causing the problem is this #206.
see below: [ Only registered users can see links on this board! Get registered or login! ]

The same post display fine when I used the link I found from inside admin panel, clicking on FORUMS and the post. It seems to have to pages the first one work.

This works. [ Only registered users can see links on this board! Get registered or login! ]

Notice that at the very bottom it has the Next for the second page. That one does not work. I think that from the site main page, when the user click on the article, it takes him to the page that does not work.

Posted: Sat Apr 29, 2006 1:28 am

I solved the problem. The forum was saying that I have 15 replies to the topic when physically, I was seeing only eight. I am not sure why the other messages were not showing. One thing, the forum was initially opened to everybody including anonymous visitors.

Anyhow, I went into Forums, configurations and increased the number of allowable responses per page which was incidently 15 to 40 (something bigger than 15 to start with). When I clicked on the topic, everything worked and the infamous message "No posts exist for this topic" disappeared. To test that my finding works well, I added a reply to the thread and everything worked.

So, I think that if you have a thread that shows only a few responses it could be that some messages are not showing due to deleting users or other things and the number of pages set in Admin / Forums / Configurations need to be increased to solve the problem.

PS. I got great help from Raven, Montego and Evaders99 while troubleshooting this problem which made me understand many things about the Forum and nuke_users as well as optimizing a database (which I have never done).

Thank you for your excellent support here.

Posted: Sun Apr 30, 2006 9:22 am

dcasmr, glad you worked this out. Sorry about not replying sooner. I was away from the boards for a few days.

I will have to keep an eye on the deleting of users. I have never had an issue with using the nuke ACP --> Users --> enter username --> Delete process. All Forum posts and topics were address properly. However, you may have hit on a situation that was never thought of. I wonder if you are right about this being the "clue":

Quote:

One thing, the forum was initially opened to everybody including anonymous visitors.

Thanks for letting us know that you got this working.

Posted: Sun Jul 30, 2006 1:12 pm

Sometimes a forum shows 3 pages of posts but when I click on the 3 I get this error.

Quote:

No posts exist for this topic.

Page 1 and 2 work fine. This only started recently when my site was migrated to a new 'platform' at powweb.

Posted: Sun Jul 30, 2006 9:13 pm

Quote:

This only started recently when my site was migrated to a new 'platform' at powweb.

I have not experienced this issue, so can you please be more specific with what you mean by the above?