| Author |
 Topic Search  Topic Options
|
racekites 
Newbie
Joined: 18 November 2004
Status: Offline
Points: 33
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: 7.9 -> 8.03 upgrade error
Posted: 05 July 2006 at 11:17am |
|
Hey guys
I'm on SQLServer and have just done a test upgrade from 7.9 to 8.03 and all went well apart from one error in Stage 2 of the upgrade process :
Stage 2: Creating New Database Tables and Fields.....
Error Dropping Contraints in Table tblPermissions
The object 'DF__tblPermiss__Read__5AEE82B9' is dependent on column 'Read'.
Complete
.
.
.
Error Discription: The object 'DF__tblPermiss__Read__5AEE82B9' is dependent on column 'Read'.
SQL Server database is set up, but with Error!
Is this a problem ??
Cheers
A
Edited by racekites - 05 July 2006 at 11:18am
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 July 2006 at 12:43pm |
|
This shouldn't be an issue.
The line in question is trying to delete the column tblPermissions -> Read
It doesn't matter if this field gets left in, but if you wanted to you can manually remove this column from the database.
|
|
|
|
calaware
Newbie
Joined: 07 July 2006
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
Posted: 07 July 2006 at 6:32am |
|
I am also trying to upgrade and I can't get past the form. I have followed the directions through browsing to the upgrade page, but I have no idea where to find the information to enter into the form fields (Database server name, name of database, database server username, database server password, and SQL server username). I'm quite the novice.
Can someone please point me in the right direction?
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: 07 July 2006 at 9:28am |
|
First findout what database type you are using.
It sounds like you are using the SQL Server upgrade tool if it is asking for the database name, password, etc. If you are using an SQL Server Database your web host can give you these details.
If you are using Access, then you need to download the Access database upgrade tool, which doesn't ask for these details as they are not required for the Access version.
|
|
|
|
calaware
Newbie
Joined: 07 July 2006
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
Posted: 07 July 2006 at 6:14pm |
|
I am, indeed, using Access, but I can't get past the same step. It asks for "Database Location and File Name:
Must be located on the same server or network mapped drive" and I have no idea what to enter here.
Again, I'm a complete novice.
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: 07 July 2006 at 8:57pm |
|
You enter the path from the upgrade tool to your Access database and the name of your Access database.
For example if the Access database was in a folder below the upgrade tool file called 'private' and the Access database was called 'wwForum.mdb' you would enter:-
private/wwForum.mdb
If the 'wwForum.mdb' database was two folders above the Access upgrade tool in a folder called 'private' then you would need to move up a directory using ../ eg:-
../../private/wwForum.mdb
|
|
|
|
