Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Upgrade Timeouts
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Upgrade Timeouts

 Post Reply Post Reply
Author
Tirian View Drop Down
Newbie
Newbie


Joined: 07 September 2004
Location: United States
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote Tirian Quote  Post ReplyReply Direct Link To This Post Topic: Upgrade Timeouts
    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
Quote 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?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
Tirian View Drop Down
Newbie
Newbie


Joined: 07 September 2004
Location: United States
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote Tirian Quote  Post ReplyReply Direct Link To This Post 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


Edited by Tirian - 13 July 2007 at 5:50pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 13 July 2007 at 8:44pm
Thanks Tirian I will certainly look into this.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.