7.9 -> 8.03 upgrade error
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=20546
Printed Date: 11 April 2026 at 11:42am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: 7.9 -> 8.03 upgrade error
Posted By: racekites
Subject: 7.9 -> 8.03 upgrade error
Date 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
|
Replies:
Posted By: WebWiz-Bruce
Date 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.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: calaware
Date 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!
|
Posted By: WebWiz-Bruce
Date 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.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: calaware
Date 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!
|
Posted By: WebWiz-Bruce
Date 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
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
|