v0.6.7.0 -> - Upgrading problems

BugNET Forums

Forum Support Upgrading probl... v0.6.7.0 ->

5/21/2007 4:17 PM

	pozi
3 posts

v0.6.7.0 ->

Following exception occured during upgrade:

[NullReferenceException: Object reference not set to an instance of an object.] BugNET.Install.Install.UpgradeBugNET() +201 BugNET.Install.Install.UpgradeApplication() +387 BugNET.Install.Install.Page_Load(Object sender, EventArgs e) +270 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

5/26/2007 7:03 AM

	admin
641 posts
bugnetproject.com

Re: v0.6.7.0 ->

I think the version may be missing from the database in this instance.

You will need access to the database and need to add a row to the HostSettings table called Version with a value 0.6.7.

Check out this thread as well.

Davin Dubeau
BugNET - Core Developer

5/29/2007 4:14 PM

	pozi
3 posts

Re: v0.6.7.0 ->

Thank you, yes, that was the problem.

But new problem occurred (see below). I think I must change collation, but I don't know on which tables and columns.

(BTW: IMHO, upgrade scripts should run in transaction, now when upgrade process fails, database is in inconsistent state.)

Output:

Upgrading To Version: 0.7.832.0

Installing Membership Provider... - 00:00:00.0156250
Migrating Users... - 00:00:04.1718750
Running Upgrade Script: 0.7.719.0.SqlDataProvider - 00:00:04.3437500
Error!

Error in file:H:\Home\WU_003353_8cc162d90a4e2e0c4de38bba866cf49c\Webs\setupstudio.net\www\bugnet\Install\dbscripts\0.7.719.0.SqlDataProvider.sql
Message:Cannot resolve the collation conflict between "Slovak_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

Running Upgrade Script: 0.7.820.0.SqlDataProvider - 00:00:05.1250000
Error!

Error in file:H:\Home\WU_003353_8cc162d90a4e2e0c4de38bba866cf49c\Webs\setupstudio.net\www\bugnet\Install\dbscripts\0.7.820.0.SqlDataProvider.sql
Message:Cannot find the object "dbo.ProjectRoles" because it does not exist or you do not have permissions.

Running Upgrade Script: 0.7.832.0.SqlDataProvider - 00:00:05.2343750

Upgrade Complete

5/30/2007 1:49 AM

	BC
40 posts

Re: v0.6.7.0 ->

Pozi,
the answer is in the same thread as in the second post,
you should tke a look at the third part:

- Third iI had to change the collocation of my database using the folowing query:
"alter database BugNET collate SQL_Latin1_General_CP1_CI_AS"

This should make the update work,

also make sure there is user called "Admin",
if you don't have that user, you should change the username of the superuser to "Admin" (in the database) before updating,
afterwards you can change back to something else.

5/30/2007 2:03 PM

	pozi
3 posts

Re: v0.6.7.0 ->

Thank you, I did it.

But now, there is another error (see bellow). In database, I see BugNet_Role_CreateNewRole procedure with 3 parameters, but in the script there is procedure with 4 parameters (create procedure and exec too). I don't know why. Also I noticed that, there is nearly half of procedures with dbo scheme and another half with databasename scheme after running update script.

Upgrading To Version: 0.7.832.0

Installing Membership Provider... - 00:00:00.0312500
Migrating Users... - 00:00:07.2187500
Running Upgrade Script: 0.7.719.0.SqlDataProvider - 00:00:07.5781250
Running Upgrade Script: 0.7.820.0.SqlDataProvider - 00:01:06.1406250
Error!

Error in file:H:\Home\WU_003353_8cc162d90a4e2e0c4de38bba866cf49c\Webs\setupstudio.net\www\bugnet\Install\dbscripts\0.7.820.0.SqlDataProvider.sql
Message:Procedure or function BugNet_Role_CreateNewRole has too many arguments specified.

Running Upgrade Script: 0.7.832.0.SqlDataProvider - 00:01:11.7031250

Upgrade Complete

Page 1 of 1

Forum

Support

Upgrading probl...

v0.6.7.0 ->

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.