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 :: Polls :: Message Navigator
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 14:05 Go to next message
eclipsewebmaster is currently offline  eclipsewebmaster   
Messages: 46
Registered: November 2009
Location: Ottawa, Ontario, Canada
Karma: 0
Member
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 15:37 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
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 15: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
Will do, thanks!
Re: Regenerate tv table without running consistency checker [message #167889 is a reply to message #167885] Wed, 31 October 2012 17:42 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Here's a good start:
http://fudforum.svn.sourceforge.net/fudforum/?rev=5559&view=rev
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Looking for some direction in solving SQL errors
Next Topic: HY000: database is locked
Goto Forum:
  

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

Current Time: Thu Nov 21 09:26:06 GMT 2024

Total time taken to generate the page: 0.02150 seconds