| Author |
 Topic Search  Topic Options
|
wolfman 
Groupie
Joined: 04 August 2004
Location: United States
Status: Offline
Points: 51
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: upgrade tool - error -
Posted: 28 February 2007 at 3:43pm |
Database Updated Started
Stage 1: Database Connection..... Complete
Stage 2: Creating New Database Tables and Fields.....
Error Update the Table tblThread
Timeout expired
Error Dropping Contraints in Table tblPermissions
The object 'DF__tblPermiss__Read__5AEE82B9' is dependent on column 'Read'.
Complete
Stage 3: Creating Index's on database..... Complete
Stage 4: Entering default values for new fields..... 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: The object 'DF__tblPermiss__Read__5AEE82B9' is dependent on column 'Read'.
SQL Server database is set up, but with Error!
Any ideas?
WOLF
|
 |
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 February 2007 at 3:52pm |
|
looks like your server timeout.
Probably best to go back to your backup database, delete the field, tblPermisisons -> Read manually, then run the update tool again.
You may also want to do this at a time when the SQL server isn't underload so you don't get the timeout error.
|
|
|
|
wolfman
Groupie
Joined: 04 August 2004
Location: United States
Status: Offline
Points: 51
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 February 2007 at 5:53pm |
Thanks Borg - I tried this and I received the following error
Also - the server shouldn't time out as there is nothing using the database or SQL server. Any ideas?
Database Updated Started
Stage 1: Database Connection..... Complete
Stage 2: Creating New Database Tables and Fields.....
Error Update the Table tblThread
Timeout expired
Error Dropping Contraints in Table tblPermissions
ALTER TABLE DROP COLUMN failed because column 'Read' does not exist in table 'tblPermissions'.
Complete
Stage 3: Creating Index's on database..... Complete
Stage 4: Entering default values for new fields..... 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: ALTER TABLE DROP COLUMN failed because column 'Read' does not exist in table 'tblPermissions'.
SQL Server database is set up, but with Error!
|
|
wolfman
Groupie
Joined: 04 August 2004
Location: United States
Status: Offline
Points: 51
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 March 2007 at 1:16pm |
When removing the read feild from the table I receive the above error. any ideas from anyone?
thanks!
|
|
wolfman
Groupie
Joined: 04 August 2004
Location: United States
Status: Offline
Points: 51
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 June 2007 at 7:57pm |
I have had a horrible time of trying to upgrade the SQL version of forums from 7 to 8.
I originally started with ver 7 access and then converted to SQL - now I would greatly like to convert from SQL 7 to SQL 8.
I ran the migration tool several times, receiving the above errors.
I am at my wits end with this and am wondering if there are any wiz/SQL gurus out there that could help. I am willing to pay for the help needed to successfully upgrade the forums to ver 8.06.
Anyone willing to do this, please contact me via PM and we can discuss details. The forums are currently located at http://www.uptempoairforums.com
Thank you
Wolf
Edited by wolfman - 28 June 2007 at 7:58pm
|
|
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 June 2007 at 10:32am |
|
Upgrading from Access to SQL is probably what's coursed the problem.
The rest of the file should run fine and skip this error. The actual error drops the column 'read' from the table tblPermissions this has been done to make the database compatible with SQL Server.
However, you can either manually remove this field from the database, or just leave it in as it makes no odds as the field isn't used anymore.
|
|
|
|
wolfman
Groupie
Joined: 04 August 2004
Location: United States
Status: Offline
Points: 51
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 June 2007 at 12:15pm |
maybe I am not leaving important files in the directory structure. The instructions say to remove all version 7 code... What files should I take out to do this? And what files if anything should I leave in?
|
|
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 June 2007 at 1:13pm |
|
Version 7 will not work witha version 8 database as it will corrupt the database.
When upgrading from version 7 to version 8 the only thing that remains is the database, all other files should be removed except for the upload folder if your users have uploaded their own files.
|
|
|
|
