Page can’t be displayed: msSQL_server_update.asp
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=19011
Printed Date: 12 April 2026 at 2:22pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Page can’t be displayed: msSQL_server_update.asp
Posted By: iSec
Subject: Page can’t be displayed: msSQL_server_update.asp
Date Posted: 28 March 2006 at 3:15pm
|
Edit: I went ahead and uploaded the new forum version then performed the db conversion... at last, he conversion page gave me page cannot be displayed and then when I try acessing the forum I get: Server Error in Forum Application ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 28 March 2006 at 4:23pm
|
The version of the Upload Tool you have requires that it is placed in with the other version 8 files in the main forum directory. However, I have just created a new version that can run in it's own directory. You can download this new version from the Upgrade Tool page, I've simply changed the download file over to the newer version. |
Posted By: iSec
Date Posted: 28 March 2006 at 4:25pm
|
Opss, you skipped me....
I edited my last post ..I'll re-try with the updated tool. ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: iSec
Date Posted: 28 March 2006 at 5:22pm
|
How long does the conversion tool take to finish? It already took about 30 minutes and still goin... is this normal? ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: WebWiz-Bruce
Date Posted: 28 March 2006 at 5:28pm
|
It all depends on how big your forum is. Also for SQL Server it will depend on how fast the SQL Server is and the network speed. It is the part that populates the new database that can take time, for each topic the Thread_ID of the first and last posts need to be read from the tblTopics table then that data needs to be placed into the tblTopics table. This is some de-normalisation on the database to speed up performance with SQL queries. It took around 6 minutes on this forum to do with around 15,000 topics, but the SQL Server is installed locally so I didn't have the issue of network load that can slow things down and the server is a dedicated server so web sever load was also not an issue. |
Posted By: iSec
Date Posted: 28 March 2006 at 5:35pm
|
I see, I'll give it another 30 minutes and see... I just hope that it is doing the right thing ... I've been up since last night working on it ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
.. Does it matter which forum version is uploaded...because I still have 7.9x on the server while the conversion is going on...and the common file and default file are both removed.Posted By: WebWiz-Bruce
Date Posted: 28 March 2006 at 5:41pm
|
As long as the common.asp file is removed from the old version it will mean that no-one can access the database while the precess is going on. Once the process is complete you can not use your version 7.x anymore. I'm surpriesed how long it is taking, but you haven't said what size your database is and if it is on a slow server or network. |
Posted By: iSec
Date Posted: 28 March 2006 at 5:45pm
|
If I recall, the forum has about 40,000 topics... The server that hosts the db is not slow... ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: iSec
Date Posted: 28 March 2006 at 5:52pm
|
Finally, we got something...
----------------------------------------
Database Updated Started Stage 1: Database Connection..... Complete Stage 2: Creating New Database Tables and Fields..... Error Updating the Table tblForum Column names in each table must be unique. Column name 'Sub_ID' in table 'DBO.tblForum' is specified more than once. Error Updating the Table tblTopic The log file for database 'iraqvoi_forum' is full. Back up the transaction log for the database to free up some log space. Error Update the Table tblThread The log file for database 'iraqvoi_forum' is full. Back up the transaction log for the database to free up some log space. Error Updating the Table tblPermissions Column names in each table must be unique. Column name 'View_Forum' in table 'DBO.tblPermissions' is specified more than once. Error Dropping Contraints in Table tblPermissions ALTER TABLE DROP COLUMN failed because column 'Read' does not exist in table 'tblPermissions'. Error Altering the Table tblAuthor The log file for database 'iraqvoi_forum' is full. Back up the transaction log for the database to free up some log space. Error Altering the Table tblConfiguration The log file for database 'iraqvoi_forum' is full. Back up the transaction log for the database to free up some log space. Error Altering the Table tblDateTimeFormat Column names in each table must be unique. Column name 'ID' in table 'DBO.tblDateTimeFormat' is specified more than once. Error Creating the Table tblPollVote There is already an object named 'tblPollVote' in the database. Error Creating the Table tblSession There is already an object named 'tblSession' in the database. Complete Stage 3: Creating Index's on database..... Error Creating one or more Index's There is already an index on table 'tblSession' named 'Session_ID'. Complete Stage 4: Entering default values for new fields..... Error entering default values in the Table tblAuthor Invalid column name 'No_of_PM'. Error entering default values in the Table tblConfiguration Invalid column name 'Topic_icon'. Complete Stage 5: Populating Database with Default Forum Permissions (this may take some time to complete)..... Permissions are reset to original defaults, you may need to update them once the upgrade is complete. Complete Stage 6: Populating Database with Forum Statistics (this may take some time to complete).....Complete Stage 7: Populating Database with Topic Statistics (this may take some time to complete)..... Complete Error Discription: Invalid column name 'Start_Thread_ID'. SQL Server database is set up, but with Error! ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: WebWiz-Bruce
Date Posted: 29 March 2006 at 9:59am
|
As far as the errors go with columns already created this means that either you have run the upgrade tool more than once or you have modified the database from the original version 7 database. If you have modified the database you will need to remove any columns you have added before you use the upgrade tool. You also have an error that your transaction log is full, this also nees to be looked at, and al;so make sure your databases recovery model is set to simple. The rest of the errors are beceuase the new fields couldn't be cerated properly. What you will need to do is go back to your original backed-up version 7 database, remove any modifications you made to the database, then run the upgrade tool again. Also, make sure you read the upgrade tool instructions very carefully. |
Posted By: iSec
Date Posted: 29 March 2006 at 11:20am
|
In EM, when I try to restore the db I get this error on some tables... 
the only change that I made to the db is adding the arcade... I saw that there are three tables for the arcade and I also unselected them when I wanted to resotre the db...but as you can see in the above picture...I get this row 1116 error! I tried all different methods to restore the d/b but I still can't... I'm stuck now
I'm also wondering whether I should change the destination table names to dbo ... this image below shows the backup are all dbo's and when i try to import the dta it does not appear as dbo...
 ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |
Posted By: WebWiz-Bruce
Date Posted: 29 March 2006 at 11:39am
|
I don't really know how to use the DTS tools that well so don't know what to suggest. I would try making the updates locally then delete the database on the server and re-upload the whole new database. |
Posted By: iSec
Date Posted: 29 March 2006 at 11:45am
|
I think I'll try that but after freeing up space with the log file I was able to restore 58,000 rows except I got that error shown in the 1st image of my previous post. After I did so, I went to see if my forum is back...but I can't login ...it says invalid username/password..! ------------- "When it gets dark enough, you can see the stars" -Charles A. Beard |