Web Wiz Forums - database upgrade error

database upgrade error

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=30784
Printed Date: 31 March 2026 at 2:40am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: database upgrade error

Posted By: alexli
Subject: database upgrade error
Date Posted: 24 June 2013 at 6:22pm

I am trying to upgrade my forum from ver9.68 to ver10.15. I got following error (in blue) when upgrading the MS-SQL Server 2005 database. Please let me know what is wrong and what are the solutions. My database is 1.2GB, and I tried a few times and all got the same error.

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.Answer
Timeout expired.CompleteComplete

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!

Replies:

Posted By: WebWiz-Bruce
Date Posted: 25 June 2013 at 12:41pm

Make sure that your databases log file has enough room to grow. Altering a table that requires the table to be rebuilt requires that the log file can grow to at least the same size as the database.

If that does not work and you still get a timeout returned from the SQL Server you can use SQL Server management Studio to change the SQL Server settings;

1. In the options under "Query Execution", you can set the "Execution Timeout" there. You can set it to 0 for unlimited

2. In options under "Designers", it says "Transaction Timeout after", you can check a box and put in a value there.

If this still does not solve the issue after the upgrade is complete you may need to add the following to your database tblThread table manually running the following in SQL Server Management Studio. Run each below separately as two quires.

ALTER TABLE [DBO].[tblThread] ADD [Answer] [bit] NOT NULL DEFAULT (0)

ALTER TABLE [DBO].[tblThread] ADD [Thanks] [int] NOT NULL DEFAULT (0)

-------------
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