Upgrade Timeouts
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=23764
Printed Date: 07 April 2026 at 7:47am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Upgrade Timeouts
Posted By: Tirian
Subject: Upgrade Timeouts
Date Posted: 13 July 2007 at 4:47pm
|
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
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? ------------- http://www.narniaweb.com/ |
Microsoft OLE DB Provider for SQL Server error '80040e31' Replies:
Posted By: WebWiz-Bruce
Date Posted: 13 July 2007 at 5:01pm
|
The version 7 to 9 upgrade tool is virtually the same as what's been used for years for upgrading from 7 to 8 with just a few bits added. The tblThreads.File_Upload field is not used in version 9 so this field wouldn't be added by the upgrade tool. The Hide field should be created OK as this is the same code as been used for years without any issue in the version 7 to version 8 upgrade tool. The re-population of the database after the upgrade is set to 2 hours on the script timeout unless the servers app pool forces it to shut down sooner. Maybe worth checking with your web host on this one. If it has stopped like it has in your case just run the tool again, ignore the errors for the database part as they will just inform you that those fields have already been created. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Tirian
Date Posted: 13 July 2007 at 5:41pm
|
Thanks Borg. I'll look into it. I'm trying to figure out what steps to take next to get the software working better and part of that may involve moving the forum part of the site to your servers. Still trying to figure that part out.
BUG FIX for you in 9b1:
admin_batch_delete_posts.asp ---> references file_upload field
Edit: Oops: Line 125 ------------- http://www.narniaweb.com/ |
Posted By: WebWiz-Bruce
Date Posted: 13 July 2007 at 8:44pm
|
Thanks Tirian I will certainly look into this.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |