| Author |
 Topic Search  Topic Options
|
JakePehrson 
Groupie
Joined: 24 September 2002
Location: United States
Status: Offline
Points: 49
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Upgrade from 9.x to 10.x - stalled?
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.
|
 |
JakePehrson
Groupie
Joined: 24 September 2002
Location: United States
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
JakePehrson
Groupie
Joined: 24 September 2002
Location: United States
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
JakePehrson
Groupie
Joined: 24 September 2002
Location: United States
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
JakePehrson
Groupie
Joined: 24 September 2002
Location: United States
Status: Offline
Points: 49
|
Post Options
Thanks(0)
Quote Reply
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 Forum Homepage
Click here to login to your Forum Admin Area
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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 |
|
|
|
