Previous Thread
Next Thread
Print Thread
Hop To
#236656 05/06/2010 11:29 AM
Joined: May 2007
Posts: 52
journeyman
journeyman
Joined: May 2007
Posts: 52
I created a new forum last week and there's currently only 2 Global Announcements and 2 regular threads in it, but on the actual forum post/thread indicator is showing 4294967295 posts and 4294967295 threads. (see attachment)

Any idea what could be making this so wonky?

Attachments
Screen shot 2010-05-06 at 12.28.06 PM.png


Cara-
Community Producer at:
Canadian Parents.com Message Boards
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
This was a bug in our older versions on certain servers. You can fix that forum with the following SQL query:

SQL Query
update ubbt_FORUMS 
set FORUM_TOPICS='2',
FORUM_POSTS='58' 
where FORUM_ID='164'

That's for your current stats in that forum, if there are more topics or replies before you run that query, then you'll need to adjust it accordingly.

Joined: May 2007
Posts: 52
journeyman
journeyman
Joined: May 2007
Posts: 52
Thanks Rick, I'm just getting back to this now. There has been another reply to the thread. I'm wondering how I should change the above to reflect that. I've never had to do this type of stuff so it makes me nervous! eek


Cara-
Community Producer at:
Canadian Parents.com Message Boards
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
SQL Query
update ubbt_FORUMS 
set FORUM_TOPICS='2',
FORUM_POSTS='4' 
where FORUM_ID='164'

Sorry about that, my original query had a bad post count. So that query will work with your current posts. I would recommend upgrading at some point as the bug has been fixed and there are some built in tools to rebuild various counts.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
1 members (Geoff), 1,124 guests, and 219 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240501)