FUDforum: Database discussions » Regenerate tv table without running consistency checker

Home » General » Database discussions » Regenerate tv table without running consistency checker

Show: Today's Messages :: Unread Messages :: Polls :: Message Navigator
| Subscribe to topic | Bookmark topic

Regenerate tv table without running consistency checker [message #167882]

Wed, 31 October 2012 10:05

eclipsewebmaster

Messages: 46
Registered: November 2009
Location: Ottawa, Ontario, Canada

Karma: 0

Member

remove from buddy list
ignore all messages by this user

Hi,

I have a fud_tv table that has gone bad and needed to be truncated. The forum has posts, but now they are obviously not showing. I've tried creating a new post but that didn't fix it. Is there a way of regenerating the fud_tv table of a specific forum without running the consistency checker? The CC takes hours to run on our site.

Thanks!

Report message to a moderator

Rate author: +1 -1

Re: Regenerate tv table without running consistency checker [message #167883 is a reply to message #167882]

Wed, 31 October 2012 11:37

naudefj

Messages: 3775
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

remove from buddy list
ignore all messages by this user

You can probably pull the relevant code from the consistency checker, but you would definitely be on your own.

PS: I wanted to implement an option to choose between quick and thorough consistency checking, but haven't had a chance to code it yet.

Report message to a moderator

Rate author: +1 -1