phpbb DB Maintenance mod for phpnuke

slackervaara · Worker Joined: Aug 26, 2007 Posts: 234

If there are a topic with many replies and I would get No posts exists for this topic, I would check the nuke_bbtopics table and the topic_id of the offending topic. Then I would check the topic_replies, if the number is correct and adjust, if topic replies were wrong. I think this should fix this error.

warren-the-ape · Posted: Sun Jun 08, 2008 5:53 am

Well just to let you guys now that my 'problem' is fixed now Smile

Problem between quotes cause everything was still working as it should be, just a few pages with no topics in them Razz

I changed all '-1' id's to the correct owner, some old guest posts to '1'. (in bb_posts and bb_topics).

bb_topics was a b#tchy job to do, since i had to check every topic manually to see if it corresponded with the correct user.

Well at least its all cleaned up now, and forum integrity back to 100% Cool

montego · Posted: Mon Jun 09, 2008 5:26 am

slackervaara · Worker Joined: Aug 26, 2007 Posts: 234

Happy to hear that it is working now. Maybe you could have used Search in the bb_topic s table to check for -1. Search is a very fast and efficient way to rapidly find such things.

warren-the-ape · Posted: Tue Jun 10, 2008 1:22 am

Yep of course I used the search, would be close to impossible without it Razz

But with bb_posts i could search on ID + poster name, this wasnt possible in bb_topics (only an id there). And since there were different users with an -1 ID i had to check them manually to see if they belonged to the right user Crying or Very sad

Around 250 topics(starts) in total with an -1 ID, so took me a while Wink