| View previous topic :: View next topic |
| Author |
Message |
nomeus Corporal

Joined: 21 Dec 2006 Posts: 16
|
Posted: Sat Feb 07, 2009 8:40 pm Post subject: some forum pages appear to be there but not really there |
|
|
hello all. not sure if this is more of a phpbb question or what....
some of my threads at www.flurbex.com dont work when trying to go to the very last page. for example, it might say 1-22 but when you click 22 it says "No posts exist for this topic". its not all threads but it seems to be the threads that have a lot of pages.
thank you. |
|
| Back to top |
|
 |
|
|
 |
Slackervaara Staff Sergeant

Joined: 10 Sep 2003 Posts: 46
|
Posted: Sat Feb 07, 2009 8:53 pm Post subject: |
|
|
I had exactly this problem earlier and it was caused by the fact, that I had deleted members directly from the database and thus their posts were still present, which gives this error.
I had to check, if I had posts available in the database from non-members. I had to create this member again and then delete it through admin.php as one always should. I had approx 10 members that I had to do this for.
Read more here:
http://ravenphpscripts.com/posts15854-highlight-topic.html |
|
| Back to top |
|
 |
nomeus Corporal

Joined: 21 Dec 2006 Posts: 16
|
Posted: Sat Feb 07, 2009 8:56 pm Post subject: |
|
|
this is EXACTLY what i did!!!
ill never be able to restore those members now. i have no record of them that i can think of.....how terrible! my forums will forever be messed up. |
|
| Back to top |
|
 |
Slackervaara Staff Sergeant

Joined: 10 Sep 2003 Posts: 46
|
Posted: Sat Feb 07, 2009 9:01 pm Post subject: |
|
|
You can fix it, because I did it.
I checked for missing members like this.
I looked in the database with phpMyAdmin in nuke_users for members that were missing. You can easily see, if a user_id is missing.
Then go to nuke_bbposts and Search. Search for poster_id with the number of the user_id of the missing member. If the missing member have posts still present in the database they will show up then.
Create a new account for a member. Then in phpMyAdmin change the user_id to the number of the missing member with posts for this account. After that you can via admin.php delete that account. Afterwards you can check that the posts have been deleted. This solved the problem I had. |
|
| Back to top |
|
 |
nomeus Corporal

Joined: 21 Dec 2006 Posts: 16
|
Posted: Sat Feb 07, 2009 9:31 pm Post subject: |
|
|
this is as far as i got....
i got confused with your instructions after that. i tried!! |
|
| Back to top |
|
 |
Slackervaara Staff Sergeant

Joined: 10 Sep 2003 Posts: 46
|
Posted: Sat Feb 07, 2009 9:37 pm Post subject: |
|
|
| So user_id 553, which is a missing member, have a single post. Then you create a new member from Administration. Then change in phpMyAdmin user_id to 553. Then you delete the member from the Administration through the name you gave it. |
|
| Back to top |
|
 |
nomeus Corporal

Joined: 21 Dec 2006 Posts: 16
|
Posted: Sat Feb 07, 2009 9:40 pm Post subject: |
|
|
| ill give it a shot! thank you!! |
|
| Back to top |
|
 |
nomeus Corporal

Joined: 21 Dec 2006 Posts: 16
|
Posted: Sat Feb 07, 2009 11:10 pm Post subject: |
|
|
| man that was very tedious....i learned my lesson the hard way...thank you so much for this very helpful tip!! worked fine but it sucks trying to fix it. |
|
| Back to top |
|
 |
candy12345 Private

Joined: 22 Dec 2009 Posts: 2
|
Posted: Tue Dec 22, 2009 10:22 pm Post subject: |
|
|
this is EXACTLY what i did!!!
ill never be able to restore those members now. i have no record of them that i can think of.....how terrible! my forums will forever be messed up.mbt walking shoes |
|
| Back to top |
|
 |
|
|
 |
|