Web Wiz Forums - Upgrade from 9.x to 10.x

Print Page | Close Window

Upgrade from 9.x to 10.x - stalled?

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=30071
Printed Date: 31 March 2026 at 6:36pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Upgrade from 9.x to 10.x - stalled?

Posted By: JakePehrson
Subject: Upgrade from 9.x to 10.x - stalled?
Date Posted: 27 December 2011 at 11:22pm

I started the update for Web Wiz Forum 9.x to 10.x. It has not move from the following screen for quite a while.

Your Database is being updated. Please be patient as this may take a few minutes to complete.

Stage 1: Creating New Database Tables and Fields.....

I hope that it is possible that it is still updating. I am not sure how long I should wait it has already been about 45 minutes. I do have a fairly active message board, but only have a few thousand users and maybe 100,000 posts. Can I close the current browser and try the update again? Should I continue to wait. If so how long? Is there a way to verify that the update was done?

Thanks in advanced.

Replies:

Posted By: JakePehrson
Date Posted: 28 December 2011 at 12:16am

Well. I let it run for quite a while (2 hours) and it was doing nothing. I tried to restart the update, but it said the database was already up to date.

I was hoping that the update finished, but didn't let me know. I tried to make a post, but I get the following error.

Server Error in Forum Application
An error has occurred while executing SQL query on database.
Please contact the Forum Administrator.

Support Error Code:- err_SQLServer_get_topic_posts_data
File Name:- forum_posts.asp
Forum Version:- 10.03

I am able to see all the existing posts and log into the admin section.

What can I do now?

I have the forum locked and have a lot of people anxiously waiting for me to get this fixed.

Thanks.

Posted By: JakePehrson
Date Posted: 28 December 2011 at 12:25am

Sorry for all the posts.

One more bit of information. When I initially did the update I selected it was a 2005 database (since I was told by my hosting company it was). I noticed in the admin section it is identifying it as a 2000 database. I change the setting in the database_settings.asp file to reflect the database not being a 2005 database, but I am not sure if this has done irreparable harm to the database during the update.

Thanks

Posted By: WebWiz-Bruce
Date Posted: 28 December 2011 at 11:26am

A forum with 100,000 posts should take around 3 to 4 minutes to do on a good host, but if the servers are overloaded it can take allot longer.

You also have to make sure you have enough log file and free space on your database to allow the tables to be rebuilt when new fields are added.

The SQL Server 2000 and 2005/2008 versions have the same database. The difference is the setting in the database_settings.asp file which tells the forum to use server side paging for faster performance if using SQL Server 2005 or above.

-------------
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: JakePehrson
Date Posted: 28 December 2011 at 2:24pm

Bruce,

What can I do at this point. I am getting an error on the website. See above.

Posted By: WebWiz-Bruce
Date Posted: 28 December 2011 at 2:45pm

It sounds like the upgrade failed as it did not move beyond Stage 1.

You should restore your database to the backup you created before attempting the upgrade and tyry again.

Make sure the database has enough resources (database size and log file size), and that the database server is not overloaded, and then try again.

Posted By: JakePehrson
Date Posted: 28 December 2011 at 10:43pm

Okay,

I restore from backup and tried again to see if it would work. This time I used Firefox instead of IE I got the following:

Your Database is being updated. Please be patient as this may take a few minutes to complete.

Stage 1: Creating New Database Tables and Fields.....

Error Altering the Table tblThread
Timeout expired.Complete

Stage 2: Entering default values for new fields..... Complete

Stage 3: Migrating forum configuration settings to new format..... Complete

Stage 4: Migrate Post Count to new Point System (this may take some time to complete)..... Complete

Timeout expired

SQL Server database is updated, but with Error!

Click here to go to your http://www.utahreefs.com/forum/default.asp" rel="nofollow - - Forum Admin Area

Posted By: WebWiz-Bruce
Date Posted: 29 December 2011 at 10:44am

Your database server has timedout while trying to add the new fields to the tblThread table. Either the timeout is set to low on the database server, or you have millions of posts in your forum.

The following fields need to be added to the tblThread table manually:-

1. Answer - datatype = bit - default value = 0

2. Thanks - data type = integer - default value = 0

Posted By: JakePehrson
Date Posted: 29 December 2011 at 4:37pm

Thanks for all your help Bruce. I appreciate it.