Web Wiz Support and Community Forums : Page can’t be displayed: msSQL_server_update.asp https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 16:00:34 +0000 Wed, 29 Mar 2006 11:45:18 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19011 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Page can’t be displayed: msSQL_server_update.asp : I think I&#039;ll try that but...]]> https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102815.html#102815 Author: iSec
Subject: 19011
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..!]]> Wed, 29 Mar 2006 11:45:18 +0000 https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102815.html#102815 <![CDATA[Page can’t be displayed: msSQL_server_update.asp : I don&#039;t really know how...]]> https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102813.html#102813 Author: WebWiz-Bruce
Subject: 19011
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.


Edited by -boRg- - 29 March 2006 at 11:40am]]> Wed, 29 Mar 2006 11:39:23 +0000 https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102813.html#102813 <![CDATA[Page can’t be displayed: msSQL_server_update.asp : In EM, when I try to restore the...]]> https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102807.html#102807 Author: iSec
Subject: 19011
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...
]]> Wed, 29 Mar 2006 11:20:40 +0000 https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102807.html#102807 <![CDATA[Page can’t be displayed: msSQL_server_update.asp : As far as the errors go with columns...]]> https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102793.html#102793 Author: WebWiz-Bruce
Subject: 19011
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.
]]> Wed, 29 Mar 2006 09:59:44 +0000 https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102793.html#102793 <![CDATA[Page can’t be displayed: msSQL_server_update.asp : Finally, we got something... ...]]> https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102755.html#102755 Author: iSec
Subject: 19011
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!
]]> Tue, 28 Mar 2006 17:52:48 +0000 https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102755.html#102755 <![CDATA[Page can’t be displayed: msSQL_server_update.asp : If I recall, the forum has about...]]> https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102753.html#102753 Author: iSec
Subject: 19011
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...  ]]> Tue, 28 Mar 2006 17:45:14 +0000 https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102753.html#102753 <![CDATA[Page can’t be displayed: msSQL_server_update.asp : As long as the common.asp file...]]> https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102751.html#102751 Author: WebWiz-Bruce
Subject: 19011
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.
]]> Tue, 28 Mar 2006 17:41:16 +0000 https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102751.html#102751 <![CDATA[Page can’t be displayed: msSQL_server_update.asp : I see, I&#039;ll give it another...]]> https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102749.html#102749 Author: iSec
Subject: 19011
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 Unhappy.. 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.

]]> Tue, 28 Mar 2006 17:35:45 +0000 https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102749.html#102749 <![CDATA[Page can’t be displayed: msSQL_server_update.asp : It all depends on how big your...]]> https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102747.html#102747 Author: WebWiz-Bruce
Subject: 19011
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.
]]> Tue, 28 Mar 2006 17:28:07 +0000 https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102747.html#102747 <![CDATA[Page can’t be displayed: msSQL_server_update.asp : How long does the conversion tool...]]> https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102744.html#102744 Author: iSec
Subject: 19011
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?]]> Tue, 28 Mar 2006 17:22:07 +0000 https://forums.webwiz.net/page-cant-be-displayed-mssql-server-update-asp_topic19011_post102744.html#102744