OK...

Heres the upgrade on the original 4.03.06 Database with a new frest 4.05.01 installation:

Upgrading DotNetNuke
Current Assembly Version: 04.05.01
Current Database Version: 04.03.06

Upgrade Status Report
00:00:00.515 - Upgrading to Version: 4.5.1
00:00:01.609 -   Executing Script: 04.03.07.SqlDataProvider Error! (see 04.03.07.log for more information)
00:00:03.437 -   Executing Script: 04.04.00.SqlDataProvider Error! (see 04.04.00.log for more information)
00:00:23.718 -   Executing Script: 04.04.01.SqlDataProvider Success
00:00:26.609 -   Executing Script: 04.05.00.SqlDataProvider Error! (see 04.05.00.log for more information)
00:01:08.718 -   Executing Script: 04.05.01.SqlDataProvider Success
00:01:10.531 - Performing General Upgrades

04.03.07.log contains:

System.Data.SqlClient.SqlException: Invalid column name 'UserID'.
Invalid column name 'UserID'.
Invalid column name 'UserID'.
Invalid column name 'IsSuperUser'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

/* remove orphaned users which will appear as SuperUsers in Host / SuperUsers Accounts */
delete
from   dbo.Users
where  UserID in ( select dbo.Users.UserID
  from   dbo.Users
  left outer join dbo.UserPortals on dbo.Users.UserID = dbo.UserPortals.UserID
  where  IsSuperUser = 0
  and dbo.UserPortals.PortalID is null )

04.04.00.log contains:

System.Data.SqlClient.SqlException: Invalid column name 'Email'.
Invalid column name 'UserID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

CREATE VIEW dbo.[vw_Portals]
AS
SELECT    
 PortalID,
 PortalName,
 CASE WHEN LEFT(LOWER(LogoFile), 6) = 'fileid'
  THEN
   (SELECT Folder + FileName 
    FROM Files
    WHERE 'fileid=' + convert(varchar,Files.FileID) = LogoFile
   )
  ELSE
   LogoFile 
  END
 AS LogoFile,
 FooterText,
 ExpiryDate,
 UserRegistration,
 BannerAdvertising,
 AdministratorId,
 Currency,
 HostFee,
 HostSpace,
 PageQuota,
 UserQuota,
 AdministratorRoleId,
 RegisteredRoleId,
 Description,
 KeyWords,
 CASE WHEN LEFT(LOWER(BackgroundFile), 6) = 'fileid'
  THEN
   (SELECT Folder + FileName 
    FROM Files
    WHERE 'fileid=' + convert(varchar,Files.FileID) = BackgroundFile
   )
  ELSE
   BackgroundFile 
  END
 AS BackgroundFile,
    GUID,
    PaymentProcessor,
    ProcessorUserId,
    ProcessorPassword,
    SiteLogHistory,
    Email,
    DefaultLanguage,
    TimezoneOffset,
    AdminTabId,
    HomeDirectory,
    SplashTabId,
    HomeTabId,
 LoginTabId,
 UserTabId,
    (SELECT TabID FROM Tabs WHERE (PortalID IS NULL) AND (ParentId IS NULL)) AS SuperTabId,
 (SELECT RoleName FROM Roles WHERE (RoleID = P.AdministratorRoleId)) AS AdministratorRoleName,
 (SELECT RoleName FROM Roles WHERE (RoleID = P.RegisteredRoleId)) AS RegisteredRoleName
FROM Portals AS P
LEFT OUTER JOIN Users AS U ON P.AdministratorId = U.UserID

Error: Invalid object name 'vw_Portals'.

04.05.00.log contains:

System.Data.SqlClient.SqlException: Foreign key 'FK_TabPermission_Users' references invalid column 'UserID' in referenced table 'dbo.Users'.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

IF (SELECT COLUMNPROPERTY( OBJECT_ID('dbo.[TabPermission]'),'UserID','AllowsNull')) IS Null
 BEGIN
  ALTER TABLE dbo.[TabPermission] ADD
   UserID int NULL

  ALTER TABLE dbo.TabPermission WITH NOCHECK ADD CONSTRAINT
   FK_TabPermission_Users FOREIGN KEY
   (
   UserID
   ) REFERENCES dbo.Users
   (
   UserID
   ) NOT FOR REPLICATION
 END

System.Data.SqlClient.SqlException: Invalid column name 'UserID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

CREATE VIEW dbo.vw_TabPermissions

AS

 SELECT  TP.TabPermissionID,
  TP.TabID,
  P.PermissionID,
  TP.RoleID,
  CASE TP.RoleID
   when -1 then 'All Users'
   when -2 then 'Superuser'
   when -3 then 'Unauthenticated Users'
   else  R.RoleName
  END AS 'RoleName',
  TP.AllowAccess,
  TP.UserID,
  U.Username,
  U.DisplayName,
  P.PermissionCode,
  P.ModuleDefID,
  P.PermissionKey,
  P.PermissionName,
  T.PortalId
 FROM TabPermission AS TP
  INNER JOIN Tabs AS T ON TP.TabID = T.TabID 
  LEFT OUTER JOIN Permission AS P ON TP.PermissionID = P.PermissionID
  LEFT OUTER JOIN Roles AS R ON TP.RoleID = R.RoleID
  LEFT OUTER JOIN Users AS U ON TP.UserID = U.UserID

System.Data.SqlClient.SqlException: Foreign key 'FK_ModulePermissionUsers' references invalid column 'UserID' in referenced table 'dbo.Users'.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

IF (SELECT COLUMNPROPERTY( OBJECT_ID('dbo.[ModulePermission]'),'UserID','AllowsNull')) IS Null
 BEGIN
  ALTER TABLE dbo.[ModulePermission] ADD
   UserID int NULL

  ALTER TABLE dbo.ModulePermission WITH NOCHECK ADD CONSTRAINT
   FK_ModulePermissionUsers FOREIGN KEY
   (
   UserID
   ) REFERENCES dbo.Users
   (
   UserID
   ) NOT FOR REPLICATION
 END

System.Data.SqlClient.SqlException: Invalid column name 'UserID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

CREATE VIEW dbo.vw_ModulePermissions
AS
SELECT    
 MP.ModulePermissionID,
 MP.ModuleID,
 P.PermissionID,
 MP.RoleID,
 CASE MP.RoleID
  when -1 then 'All Users'
  when -2 then 'Superuser'
  when -3 then 'Unauthenticated Users'
  else  R.RoleName
 END AS 'RoleName',
 MP.AllowAccess,
 MP.UserID,
 U.Username,
 U.DisplayName,
 P.PermissionCode,
 P.ModuleDefID,
 P.PermissionKey,
 P.PermissionName
FROM ModulePermission AS MP
 LEFT OUTER JOIN Permission AS P ON MP.PermissionID = P.PermissionID
 LEFT OUTER JOIN Roles AS R ON MP.RoleID = R.RoleID
 LEFT OUTER JOIN Users AS U ON MP.UserID = U.UserID

System.Data.SqlClient.SqlException: Foreign key 'FK_FolderPermissionUsers' references invalid column 'UserID' in referenced table 'dbo.Users'.
Could not create constraint. See previous errors.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

IF (SELECT COLUMNPROPERTY( OBJECT_ID('dbo.[FolderPermission]'),'UserID','AllowsNull')) IS Null
 BEGIN
  ALTER TABLE dbo.[FolderPermission] ADD
   UserID int NULL

  ALTER TABLE dbo.FolderPermission WITH NOCHECK ADD CONSTRAINT
   FK_FolderPermissionUsers FOREIGN KEY
   (
   UserID
   ) REFERENCES dbo.Users
   (
   UserID
   ) NOT FOR REPLICATION
 END

System.Data.SqlClient.SqlException: Invalid column name 'UserID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

CREATE VIEW dbo.vw_FolderPermissions
AS
SELECT    
 FP.FolderPermissionID,
 F.FolderID,
 F.FolderPath,
 P.PermissionID,
 FP.RoleID,
 CASE FP.RoleID
  when -1 then 'All Users'
  when -2 then 'Superuser'
  when -3 then 'Unauthenticated Users'
  else  R.RoleName
 END AS 'RoleName',
 FP.AllowAccess,
 FP.UserID,
 U.Username,
 U.DisplayName,
 P.PermissionCode,
 P.PermissionKey,
 P.PermissionName,
 F.PortalID
FROM FolderPermission AS FP
 LEFT OUTER JOIN Folders AS F ON FP.FolderID = F.FolderID
 LEFT OUTER JOIN Permission AS P ON FP.PermissionID = P.PermissionID
 LEFT OUTER JOIN Roles AS R ON FP.RoleID = R.RoleID
 LEFT OUTER JOIN Users AS U ON FP.UserID = U.UserID

System.Data.SqlClient.SqlException: Invalid column name 'Email'.
Invalid column name 'UserID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

CREATE VIEW dbo.[vw_Portals]
AS
 SELECT    
  PortalID,
  PortalName,
  CASE WHEN LEFT(LOWER(LogoFile), 6) = 'fileid'
   THEN
    (SELECT Folder + FileName 
     FROM Files
     WHERE 'fileid=' + convert(varchar,Files.FileID) = LogoFile
    )
   ELSE
    LogoFile 
   END
  AS LogoFile,
  FooterText,
  ExpiryDate,
  UserRegistration,
  BannerAdvertising,
  AdministratorId,
  Currency,
  HostFee,
  HostSpace,
  PageQuota,
  UserQuota,
  AdministratorRoleId,
  RegisteredRoleId,
  Description,
  KeyWords,
  CASE WHEN LEFT(LOWER(BackgroundFile), 6) = 'fileid'
   THEN
    (SELECT Folder + FileName 
     FROM Files
     WHERE 'fileid=' + convert(varchar,Files.FileID) = BackgroundFile
    )
   ELSE
    BackgroundFile 
   END
  AS BackgroundFile,
  GUID,
  PaymentProcessor,
  ProcessorUserId,
  ProcessorPassword,
  SiteLogHistory,
  Email,
  DefaultLanguage,
  TimezoneOffset,
  AdminTabId,
  HomeDirectory,
  SplashTabId,
  HomeTabId,
  LoginTabId,
  UserTabId,
  (SELECT TOP 1 TabID FROM Tabs WHERE (PortalID IS NULL) AND (ParentId IS NULL)) AS SuperTabId,
  (SELECT TOP 1 RoleName FROM Roles WHERE (RoleID = P.AdministratorRoleId)) AS AdministratorRoleName,
  (SELECT TOP 1 RoleName FROM Roles WHERE (RoleID = P.RegisteredRoleId)) AS RegisteredRoleName
 FROM Portals AS P
 LEFT OUTER JOIN Users AS U ON P.AdministratorId = U.UserID

Im really in alot of trouble with this....if anyone can help, please!! :)

Cheers,

Ky

Ok, so rundown is...

Original site and DB no longer work for unknown reason.

When installed 4.05.01 with old database, get errors during the upgrade process.

Original site installs fine on a blank DB.

Upgraded (4.05.01) site installs fine on a blank DB...

So, somewhere down the line, the DB has been corrupted, as even restoring from the backup before I played with it causes errors!!

Anyone know of any scripts/utilities which can rip the content out of a dead DNN database and port it across to a new one?