I have some problems upgrading from 0.67 to 0.7.820.
- First i had the problem where there was no field "Version" in the table "HostSettings"
(problem also in topic 0.67 --> .7 Beta 1)
So i manually added that field.
- Second I would like to suggest some change in the code of "install.aspx.cs"
if (Path.GetFileNameWithoutExtension(File).StartsWith("Install") || Path.GetFileNameWithoutExtension(File).StartsWith("BugNet"))
replace by:
if (Path.GetFileNameWithoutExtension(File).StartsWith("Install") || Path.GetFileNameWithoutExtension(File).StartsWith("BugNet") || Path.GetFileNameWithoutExtension(File).StartsWith("Latest"))
or even inverse the complete statement into:
if ((!Path.GetFileNameWithoutExtension(File).StartsWith("Install") &&
!Path.GetFileNameWithoutExtension(File).StartsWith("BugNet")) &&
!Path.GetFileNameWithoutExtension(File).StartsWith("Latest"))
{
strScriptVersion =
Path.GetFileNameWithoutExtension(File).Substring(0,
Path.GetFileNameWithoutExtension(File).
LastIndexOf("."));
int ScriptVersion = Convert.ToInt32(strScriptVersion.Replace(".", ""));
//check if script file is relevant for upgrade
if (ScriptVersion > DatabaseVersion && ScriptVersion <= AssemblyVersion)
{
arrScriptFiles.Add(File);
}
}
- Third iI had to change the collocation of my database using the folowing query:
"alter database BugNET collate SQL_Latin1_General_CP1_CI_AS"
- Now I'm stuck on the following error when I try to upgrade y system:
Upgrading To Version: 0.7.820.0
Installing Membership Provider... - 00:00:00
Migrating Users... - 00:00:03.9375000
Running Upgrade Script: 0.7.719.0.SqlDataProvider - 00:00:04.0468750
Running Upgrade Script: 0.7.820.0.SqlDataProvider - 00:00:08.0781250
Error!
Error in file:D:\BugNET\Install\dbscripts\0.7.820.0.SqlDataProvider.sql
Message:Cannot insert the value NULL into column 'UserId', table 'BugNET.dbo.UserRoles'; column does not allow nulls. INSERT fails. Adding Administrator to Super Users Role
Upgrade Complete
Any suggestions how i can fix this last error ?