FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » Database discussions » Regenerate tv table without running consistency checker
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Regenerate tv table without running consistency checker [message #167882] Wed, 31 October 2012 10:05 Go to next message
eclipsewebmaster is currently offline  eclipsewebmaster   
Messages: 46
Registered: November 2009
Location: Ottawa, Ontario, Canada
Karma: 0
Member
add to 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!
Re: Regenerate tv table without running consistency checker [message #167883 is a reply to message #167882] Wed, 31 October 2012 11:37 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3631
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to 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.
Re: Regenerate tv table without running consistency checker [message #167885 is a reply to message #167883] Wed, 31 October 2012 11:49 Go to previous messageGo to next message
eclipsewebmaster is currently offline  eclipsewebmaster   
Messages: 46
Registered: November 2009
Location: Ottawa, Ontario, Canada
Karma: 0
Member
add to buddy list
ignore all messages by this user
Will do, thanks!
Re: Regenerate tv table without running consistency checker [message #167889 is a reply to message #167885] Wed, 31 October 2012 13:42 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3631
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Here's a good start:
http://fudforum.svn.sourceforge.net/fudforum/?rev=5559&view=rev
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Looking for some direction in solving SQL errors
Next Topic: Datebase software
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 11 12:20:15 EST 2017

Total time taken to generate the page: 0.00777 seconds