I like what you've done with v 9. I'm using a heavily modded version of 7.6 now and I really need to bite the bullet and upgrade since my current forum is ridiculously slow when we get any sort of traffic. I get SQL errors all the time.
I have about 800K posts and when I ran the 7.x upgrade I got a DNS error after about a half hour. The updates weren't buffering in as they happened either. It seems as though all of the changes went through and the forum, although for some reason the "hide" field in the tblThreads folder didn't make it through. I added it manually (had to up my SQL timeout settings) and now I can access the admin tool.
Also, it doesn't appear that the upgrade tool creates the threads.file_uploads bit field. I had to manually add that myself.
When I try to resync the post count to I get
Microsoft OLE DB Provider for SQL Server error '80040e31' Timeout expired /forum9b1/functions/functions_common.asp, line 732 |
I went to the database_connection file and updatedthe timout to be 900 seconds but that made no difference.
I'm running SQL Server 2000.
It seems that everything I'm doing is timing out because I have so many posts. Any idea of where I could go to up that timeout value?