BugNET

Open source issue tracking & project management
| Login

Import Update!

We are currently in transition and have moved our discussions to CodePlex. These forums will remain as reference until we launch of our new site in the upcoming weeks. After that they will be removed.

Thank you for your patience during our transition.

Forums

HomeHomeSupportSupportUpgrading BugNE...Upgrading BugNE...Upgrade to 0.7 RC1 ErrorsUpgrade to 0.7 RC1 Errors
Previous
 
Next
New Post
6/5/2009 3:34 AM
 

Here's the output message from running this script on the database. The script was revision 805. Looks like still some of the same errors as previous.

 

Cleaning up all deleted bugs and related tables

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)
Cleaning up project tables

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)
Deleting orphaned records in user projects table

(4 row(s) affected)
Deleting orphaned records in user roles table

(4 row(s) affected)
Updating bugs with missing versions
Updating bugs with orphaned assigned user ids
Updating bugs with orphaned reporter user ids
Updating bugs with orphaned last updated user ids
Updating bugs with orphaned components
Updating bug attachments with orphaned users
Updating bug comments with orphaned users
Updating bug history records with orphaned users
Deleting bug notifications for orphaned users

(0 row(s) affected)
Updating bug time entries for orphaned users
Updating project creators with orphaned user ids
Updating project managers with orphaned user ids
Updating project mailboxes with orphaned users
Msg 3725, Level 16, State 0, Line 1
The constraint 'PK__Component__09DE7BCC' is being referenced by table 'Bug', foreign key constraint 'FK_Bug_Component'.
Msg 3727, Level 16, State 0, Line 1
Could not drop constraint. See previous errors.

(1 row(s) affected)

(140 row(s) affected)

(140 row(s) affected)
Msg 1779, Level 16, State 0, Line 2
Table 'Component' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.

(1 row(s) affected)
Msg 547, Level 16, State 0, Line 2
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_UserProjects_aspnet_Users". The conflict occurred in database "BugNetBeforeUpgrade", table "dbo.aspnet_Users", column 'UserId'.

(1 row(s) affected)
Msg 547, Level 16, State 0, Line 2
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Bug_FixedInVersionId". The conflict occurred in database "BugNetBeforeUpgrade", table "dbo.Version", column 'VersionID'.

(1 row(s) affected)
Msg 1785, Level 16, State 0, Line 2
Introducing FOREIGN KEY constraint 'FK_Component_Project' on table 'Component' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.

(1 row(s) affected)
Msg 547, Level 16, State 0, Line 2
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_UserRoles_aspnet_Users". The conflict occurred in database "BugNetBeforeUpgrade", table "dbo.aspnet_Users", column 'UserId'.

(1 row(s) affected)

(1 row(s) affected)
Database synchronization script failed
 

 
New Post
6/5/2009 5:42 AM
 

Thought I had worked these errors out with statements already for the user projects table and user roles tables but I will go back to your previous post and use your suggestions.

New script will be up later tonight.

Thanks


Davin Dubeau

follow us on twitter facebook users group google plus
 
New Post
6/15/2009 8:41 AM
 

The following two errors still exist. They are the same as before.

 

Msg 1785, Level 16, State 0, Line 2
Introducing FOREIGN KEY constraint 'FK_Component_Project' on table 'Component' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.


Msg 547, Level 16, State 0, Line 2
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_UserRoles_aspnet_Users". The conflict occurred in database "bugnetbackbeforeupgrade", table "dbo.aspnet_Users", column 'UserId'.

 

 
Previous
 
Next
HomeHomeSupportSupportUpgrading BugNE...Upgrading BugNE...Upgrade to 0.7 RC1 ErrorsUpgrade to 0.7 RC1 Errors


Forum Policy

These Discussion Forums are dedicated to the discussion of the BugNET issue tracker.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising.
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.
5. English language posting only, please.