BugNET

Open source issue tracking & project management

Forums

HomeHomeSupportSupportUpgrading BugNE...Upgrading BugNE...Upgrading from 0.7.942.0 to 0.8.185.0 (RC3) failedUpgrading from 0.7.942.0 to 0.8.185.0 (RC3) failed
Previous
 
Next
New Post
4/22/2010 2:03 AM
 

I was unable to upgrade to the latest release... any suggestions?

Upgrade Status Report

Current Assembly Version: 0.8.185.0

Current Database Version: 0.7.942.0

00:00:00.0100144 - Upgrading To Version: 0.8.185.0
00:00:00.0300432 - Executing Script: 0.8.140.0.SqlDataProvider.sql
Error!

Error Details

File

0.8.140.0.SqlDataProvider.sql

Error

Invalid object name 'dbo.BugNet_Permissions'.



00:00:00.2002880 - Executing Script: 0.8.167.0.SqlDataProvider.sql
Error!

Error Details

File

0.8.167.0.SqlDataProvider.sql

Error

Invalid object name 'dbo.BugNet_StringResources'.



00:00:00.2002880 - Executing Script: 0.8.185.0.SqlDataProvider.sql
Error!

Error Details

File

0.8.185.0.SqlDataProvider.sql

Error

Cannot find the object "BugNet_ProjectMilestones" because it does not exist or you do not have permissions.





Error: RoleDescription

Upgrade Failed!

 
New Post
4/22/2010 4:49 AM
 

I get the same error. It seems the first script that fires is trying to modify tables which dont exist.

0.8.140 is the culprit to start with.... Here is my SQL log from running in SQL Admin studio against a SQL 2005 database. It seems that "BugNet.Schema.SqlDataProvider.sql" is not being run soon enough.

File Name:
0.8.140.0.SqlDataProvider.sql

Errors:
Msg 208, Level 16, State 1, Line 4
Invalid object name 'dbo.BugNet_Permissions'.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_Projects" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_UserProjects" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_Roles" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 3
Invalid object name 'BugNet_UserRoles'.
Msg 208, Level 16, State 1, Line 3
Invalid object name 'BugNet_RolePermissions'.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_ApplicationLog" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 3
Invalid object name 'BugNet_HostSettings'.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_ProjectCustomFields" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_ProjectCustomFieldSelections" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_ProjectCategories" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 11, Line 4
Cannot find the object "BugNet_ProjectMilestones" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 19
Invalid object name 'BugNet_ProjectMilestones'.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_ProjectResolutions" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_ProjectIssueTypes" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_ProjectStatus" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_ProjectPriorities" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 28
Invalid object name 'BugNet_ProjectStatus'.
Msg 1088, Level 16, State 11, Line 1
Cannot find the object "BugNet_Issues" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_ProjectCustomFieldValues" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_IssueNotifications" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_IssueHistory" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_IssueComments" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_IssueAttachments" because it does not exist or you do not have permissions.
Msg 208, Level 16, State 1, Line 4
Invalid object name 'BugNet_RelatedIssues'.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_IssueWorkReports" because it does not exist or you do not have permissions.
Msg 1088, Level 16, State 11, Line 3
Cannot find the object "BugNet_ProjectMailBoxes" because it does not exist or you do not have permissions.
Msg 4701, Level 16, State 1, Line 3
Cannot find the object "BugNet_UserProfiles" because it does not exist or you do not have permissions.
Msg 3902, Level 16, State 1, Line 2
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.


Follow me on twitter: @stewartmoss http://www.twitter.com/stewartmoss
Follow BugNETProject on twitter: @bugnetproject http://www.twitter.com/bugnetproject
 
New Post
4/22/2010 4:58 AM
 

Got A different error after that. It looked like it ran "InstallCommon.sql" and other files. Then i mucked with my connection string and I am back to the original error. It does not matter what I do.


Follow me on twitter: @stewartmoss http://www.twitter.com/stewartmoss
Follow BugNETProject on twitter: @bugnetproject http://www.twitter.com/bugnetproject
 
New Post
4/22/2010 6:38 AM
Accepted Answer 

Somehow the sql script changed or did not get committed properly. 0.8.140 should contain all the script necessary for the 0.7 - 0.8 conversion.

I will modify this and re-release this evening. Till then upgrades from 0.7 will not work.


Davin Dubeau

follow us on twitter facebook users group google plus
 
New Post
4/23/2010 6:20 AM
 

0.8.186 (newest RC3 release) upgraded fine for me. Had to tweak the FCKEditor settings as per the other post.


Follow me on twitter: @stewartmoss http://www.twitter.com/stewartmoss
Follow BugNETProject on twitter: @bugnetproject http://www.twitter.com/bugnetproject
 
Previous
 
Next
HomeHomeSupportSupportUpgrading BugNE...Upgrading BugNE...Upgrading from 0.7.942.0 to 0.8.185.0 (RC3) failedUpgrading from 0.7.942.0 to 0.8.185.0 (RC3) failed


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.