Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Page can’t be displayed: msSQL_server_update.asp
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Page can’t be displayed: msSQL_server_update.asp
 Post Reply Post Reply Page  <12
Author
  Topic Search Topic Search  Topic Options Topic Options
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140 		Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140 		Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140 		Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.