I am starting from scratch on a W2K3 server with SQL 2005 and after getting past all the db connection issues I am now stuck with this one error:
Upgrade Status Report
00:00:00.015 - Upgrading to Version: 4.5.1
00:00:00.046 - Executing Script: 04.04.01.SqlDataProvider Error! (see 04.04.01.log for more information)
00:00:00.171 - Executing Script: 04.05.00.SqlDataProvider Error! (see 04.05.00.log for more information)
00:00:00.937 - Executing Script: 04.05.01.SqlDataProvider Error! (see 04.05.01.log for more information)
00:00:01.078 - Performing General Upgrades
My question is obviously what is causing this but also why is it upgrading a new install?
The error log is as follows:
04.04.01.log
System.Data.SqlClient.SqlException: Invalid column name 'PortalId'.
Invalid column name 'PortalId'.
Invalid column name 'RoleId'.
Invalid column name 'PortalId'.
Invalid column name 'RoleGroupId'.
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 procedure dbo.[DBR_GetPortalRoles]
@PortalId int
AS
SELECT R.RoleId,
R.PortalId,
R.RoleGroupId,
R.RoleName,
R.Description,
'ServiceFee' = case when convert(int,R.ServiceFee) <> 0 then R.ServiceFee else null end,
'BillingPeriod' = case when convert(int,R.ServiceFee) <> 0 then R.BillingPeriod else null end,
'BillingFrequency' = case when convert(int,R.ServiceFee) <> 0 then L1.Text else '' end,
'TrialFee' = case when R.TrialFrequency <> 'N' then R.TrialFee else null end,
'TrialPeriod' = case when R.TrialFrequency <> 'N' then R.TrialPeriod else null end,
'TrialFrequency' = case when R.TrialFrequency <> 'N' then L2.Text else '' end,
'IsPublic' = case when R.IsPublic = 1 then 'True' else 'False' end,
'AutoAssignment' = case when R.AutoAssignment = 1 then 'True' else 'False' end,
RSVPCode,
IconFile
FROM dbo.DBR_Roles R
LEFT OUTER JOIN dbo.DBR_Lists L1 ON R.BillingFrequency = L1.Value
LEFT OUTER JOIN dbo.DBR_Lists L2 ON R.TrialFrequency = L2.Value
WHERE ( PortalId = @PortalId OR PortalId is null )
AND L1.ListName='Frequency'
AND L2.ListName='Frequency'
ORDER BY R.RoleName
System.Data.SqlClient.SqlException: Must declare the scalar variable "@PortalID".
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 procedure dbo.[DBR_GetModuleByDefinition]
@PortalId int,
@FriendlyName nvarchar(128)
AS
SELECT DBR_vw_Modules.*
FROM DBR_vw_Modules
INNER JOIN DBR_ModuleDefinitions as MD ON DBR_vw_Modules.ModuleDefID = MD.ModuleDefID
WHERE ((PortalId = @PortalId) or (PortalId is null and @PortalID is null))
AND MD.FriendlyName = @FriendlyName
AND IsDeleted = 0
System.Data.SqlClient.SqlException: Invalid column name 'PortalId'.
Invalid column name 'RoleId'.
Invalid column name 'RoleId'.
Invalid column name 'RoleId'.
Invalid column name 'UserId'.
Invalid column name 'RoleId'.
Invalid column name 'RoleId'.
Invalid column name 'UserId'.
Invalid column name 'UserRoleId'.
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 procedure dbo.[DBR_GetServices]
@PortalId int,
@UserId int = null
AS
SELECT RoleId,
R.RoleName,
R.Description,
'ServiceFee' = case when convert(int,R.ServiceFee) <> 0 then R.ServiceFee else null end,
'BillingPeriod' = case when convert(int,R.ServiceFee) <> 0 then R.BillingPeriod else null end,
'BillingFrequency' = case when convert(int,R.ServiceFee) <> 0 then R.BillingFrequency else '' end,
'TrialFee' = case when R.TrialFrequency <> 'N' then R.TrialFee else null end,
'TrialPeriod' = case when R.TrialFrequency <> 'N' then R.TrialPeriod else null end,
'TrialFrequency' = case when R.TrialFrequency <> 'N' then R.TrialFrequency else '' end,
'ExpiryDate' = ( select ExpiryDate from dbo.DBR_UserRoles where dbo.DBR_UserRoles.RoleId = R.RoleId and dbo.DBR_UserRoles.UserId = @UserId ),
'Subscribed' = ( select UserRoleId from dbo.DBR_UserRoles where dbo.DBR_UserRoles.RoleId = R.RoleId and dbo.DBR_UserRoles.UserId = @UserId )
from dbo.DBR_Roles R
where R.PortalId = @PortalId
and R.IsPublic = 1
System.Data.SqlClient.SqlException: Invalid column name 'PortalId'.
Invalid column name 'PortalId'.
Invalid column name 'RoleId'.
Invalid column name 'PortalId'.
Invalid column name 'RoleGroupId'.
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 procedure dbo.[DBR_GetPortalRoles]
@PortalId int
AS
SELECT R.RoleId,
R.PortalId,
R.RoleGroupId,
R.RoleName,
R.Description,
'ServiceFee' = case when convert(int,R.ServiceFee) <> 0 then R.ServiceFee else null end,
'BillingPeriod' = case when convert(int,R.ServiceFee) <> 0 then R.BillingPeriod else null end,
'BillingFrequency' = case when convert(int,R.ServiceFee) <> 0 then L1.Text else '' end,
'TrialFee' = case when R.TrialFrequency <> 'N' then R.TrialFee else null end,
'TrialPeriod' = case when R.TrialFrequency <> 'N' then R.TrialPeriod else null end,
'TrialFrequency' = case when R.TrialFrequency <> 'N' then L2.Text else '' end,
'IsPublic' = case when R.IsPublic = 1 then 'True' else 'False' end,
'AutoAssignment' = case when R.AutoAssignment = 1 then 'True' else 'False' end,
RSVPCode,
IconFile
FROM dbo.DBR_Roles R
LEFT OUTER JOIN dbo.DBR_Lists L1 ON R.BillingFrequency = L1.Value
LEFT OUTER JOIN dbo.DBR_Lists L2 ON R.TrialFrequency = L2.Value
WHERE ( R.PortalId = @PortalId OR R.PortalId is null )
AND L1.ListName='Frequency'
AND L2.ListName='Frequency'
ORDER BY R.RoleName
System.Data.SqlClient.SqlException: Must declare the scalar variable "@PortalID".
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 procedure dbo.[DBR_GetFolderPermissionsByPortal]
@PortalId int
AS
SELECT *
FROM DBR_vw_FolderPermissions
WHERE PortalID = @PortalID OR (PortalId IS NULL AND @PortalId IS NULL)
System.Data.SqlClient.SqlException: Invalid column name 'RoleGroupId'.
Invalid column name 'RoleGroupId'.
Invalid column name 'PortalId'.
Invalid column name 'RoleId'.
Invalid column name 'PortalId'.
Invalid column name 'RoleGroupId'.
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 PROCEDURE dbo.DBR_GetRolesByGroup
@RoleGroupId int,
@PortalId int
AS
SELECT R.RoleId,
R.PortalId,
R.RoleGroupId,
R.RoleName,
R.Description,
'ServiceFee' = case when convert(int,R.ServiceFee) <> 0 then R.ServiceFee else null end,
'BillingPeriod' = case when convert(int,R.ServiceFee) <> 0 then R.BillingPeriod else null end,
'BillingFrequency' = case when convert(int,R.ServiceFee) <> 0 then L1.Text else '' end,
'TrialFee' = case when R.TrialFrequency <> 'N' then R.TrialFee else null end,
'TrialPeriod' = case when R.TrialFrequency <> 'N' then R.TrialPeriod else null end,
'TrialFrequency' = case when R.TrialFrequency <> 'N' then L2.Text else '' end,
'IsPublic' = case when R.IsPublic = 1 then 'True' else 'False' end,
'AutoAssignment' = case when R.AutoAssignment = 1 then 'True' else 'False' end,
R.RSVPCode,
R.IconFile
FROM DBR_Roles R
LEFT OUTER JOIN DBR_Lists L1 on R.BillingFrequency = L1.Value
LEFT OUTER JOIN DBR_Lists L2 on R.TrialFrequency = L2.Value
WHERE (RoleGroupId = @RoleGroupId OR (RoleGroupId IS NULL AND @RoleGroupId IS NULL))
AND R.PortalId = @PortalId
ORDER BY R.RoleName
System.Data.SqlClient.SqlException: Invalid column name 'PortalId'.
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.DBR_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 DBR_TabPermission AS TP
INNER JOIN DBR_Tabs AS T ON TP.TabID = T.TabID
LEFT OUTER JOIN DBR_Permission AS P ON TP.PermissionID = P.PermissionID
LEFT OUTER JOIN DBR_Roles AS R ON TP.RoleID = R.RoleID
LEFT OUTER JOIN DBR_Users AS U ON TP.UserID = U.UserID
System.Data.SqlClient.SqlException: Invalid column name 'DesktopModuleId'.
Invalid column name 'DesktopModuleId'.
Invalid column name 'PortalId'.
Invalid column name 'PortalDesktopModuleId'.
Invalid column name 'DesktopModuleId'.
Invalid column name 'ispremium'.
Invalid column name 'isadmin'.
Invalid column name 'businesscontrollerclass'.
Invalid column name 'foldername'.
Invalid column name 'modulename'.
Invalid column name 'supportedfeatures'.
Invalid column name 'compatibleversions'.
Invalid column name 'dependencies'.
Invalid column name 'permissions'.
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 PROCEDURE dbo.DBR_GetDesktopModulesByPortal
@PortalId int
AS
SELECT distinct(DBR_DesktopModules.DesktopModuleId) AS DesktopModuleId,
DBR_DesktopModules.FriendlyName,
DBR_DesktopModules.Description,
DBR_DesktopModules.Version,
DBR_DesktopModules.ispremium,
DBR_DesktopModules.isadmin,
DBR_DesktopModules.businesscontrollerclass,
DBR_DesktopModules.foldername,
DBR_DesktopModules.modulename,
DBR_DesktopModules.supportedfeatures,
DBR_DesktopModules.compatibleversions,
DBR_DesktopModules.dependencies,
DBR_DesktopModules.permissions
FROM DBR_DesktopModules
LEFT OUTER JOIN DBR_PortalDesktopModules on DBR_DesktopModules.DesktopModuleId = DBR_PortalDesktopModules.DesktopModuleId
WHERE IsAdmin = 0
AND ( IsPremium = 0 OR (PortalId = @PortalId AND PortalDesktopModuleId IS NOT Null))
ORDER BY FriendlyName
System.Data.SqlClient.SqlException: Invalid column name 'DesktopModuleId'.
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 PROCEDURE dbo.DBR_UpdateDesktopModule
@DesktopModuleId int,
@ModuleName nvarchar(128),
@FolderName nvarchar(128),
@FriendlyName nvarchar(128),
@Description nvarchar(2000),
@Version nvarchar(8),
@IsPremium bit,
@IsAdmin bit,
@BusinessController nvarchar(200),
@SupportedFeatures int,
@CompatibleVersions nvarchar(500),
@Dependencies nvarchar(400),
@Permissions nvarchar(400)
AS
UPDATE DBR_DesktopModules
SET ModuleName = @ModuleName,
FolderName = @FolderName,
FriendlyName = @FriendlyName,
Description = @Description,
Version = @Version,
IsPremium = @IsPremium,
IsAdmin = @IsAdmin,
BusinessControllerClass = @BusinessController,
SupportedFeatures = @SupportedFeatures,
CompatibleVersions = @CompatibleVersions,
Dependencies = @Dependencies,
Permissions = @Permissions
WHERE DesktopModuleId = @DesktopModuleId
System.Data.SqlClient.SqlException: Invalid column name 'ModuleControlId'.
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 PROCEDURE dbo.DBR_GetModuleControl
@ModuleControlId int
AS
SELECT *
FROM DBR_ModuleControls
WHERE ModuleControlId = @ModuleControlId
System.Data.SqlClient.SqlException: Must declare the scalar variable "@ModuleDefID".
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 PROCEDURE dbo.DBR_GetModuleControlByKeyAndSrc
@ModuleDefId int,
@ControlKey nvarchar(50),
@ControlSrc nvarchar(256)
AS
SELECT *
FROM DBR_ModuleControls
WHERE ((ModuleDefId is null and @ModuleDefId is null) or (ModuleDefID = @ModuleDefID))
AND ((ControlKey is null and @ControlKey is null) or (ControlKey = @ControlKey))
AND ((ControlSrc is null and @ControlSrc is null) or (ControlSrc = @ControlSrc))
System.Data.SqlClient.SqlException: Invalid column name 'ModuleDefId'.
Invalid column name 'ModuleDefId'.
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 PROCEDURE dbo.DBR_GetModuleControls
@ModuleDefId int
AS
SELECT *
FROM DBR_ModuleControls
WHERE ((ModuleDefId is null and @ModuleDefId is null) or (ModuleDefId = @ModuleDefId))
ORDER BY ControlKey, ViewOrder
System.Data.SqlClient.SqlException: Invalid column name 'ModuleDefId'.
Invalid column name 'ModuleDefId'.
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 PROCEDURE dbo.DBR_GetModuleControlsByKey
@ControlKey nvarchar(50),
@ModuleDefId int
AS
SELECT *
FROM DBR_ModuleControls
WHERE ((ControlKey is null and @ControlKey is null) or (ControlKey = @ControlKey))
AND ((ModuleDefId is null and @ModuleDefId is null) or (ModuleDefId = @ModuleDefId))
AND ControlType >= -1
ORDER BY ViewOrder
System.Data.SqlClient.SqlException: Must declare the scalar variable "@ModuleDefId".
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 PROCEDURE dbo.DBR_UpdateModuleControl
@ModuleControlId int,
@ModuleDefID int,
@ControlKey nvarchar(50),
@ControlTitle nvarchar(50),
@ControlSrc nvarchar(256),
@IconFile nvarchar(100),
@ControlType int,
@ViewOrder int,
@HelpUrl nvarchar(200),
@SupportsPartialRendering bit
AS
UPDATE DBR_ModuleControls
SET
ModuleDefId = @ModuleDefId,
ControlKey = @ControlKey,
ControlTitle = @ControlTitle,
ControlSrc = @ControlSrc,
IconFile = @IconFile,
ControlType = @ControlType,
ViewOrder = ViewOrder,
HelpUrl = @HelpUrl,
SupportsPartialRendering = @SupportsPartialRendering
WHERE ModuleControlId = @ModuleControlId
System.Data.SqlClient.SqlException: Invalid column name 'TabId'.
Invalid column name 'TabModuleId'.
Invalid column name 'FileID'.
Invalid column name 'ModuleControlId'.
Invalid column name 'HelpURL'.
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.[DBR_vw_Modules]
AS
SELECT
M.PortalID,
TM.TabId,
TM.TabModuleId,
M.ModuleID,
M.ModuleDefID,
TM.ModuleOrder,
TM.PaneName,
M.ModuleTitle,
TM.CacheTime,
TM.Alignment,
TM.Color,
TM.Border,
CASE WHEN LEFT(LOWER(TM.IconFile), 6) = 'fileid'
THEN
(SELECT Folder + FileName
FROM DBR_Files
WHERE 'fileid=' + convert(varchar,DBR_Files.FileID) = TM.IconFile
)
ELSE
TM.IconFile
END
AS IconFile,
M.AllTabs,
TM.Visibility,
M.IsDeleted,
M.Header,
M.Footer,
M.StartDate,
M.EndDate,
TM.ContainerSrc,
TM.DisplayTitle,
TM.DisplayPrint,
TM.DisplaySyndicate,
M.InheritViewPermissions,
DM.DesktopModuleID,
DM.FriendlyName,
DM.Description,
DM.Version,
DM.IsPremium,
DM.IsAdmin,
DM.BusinessControllerClass,
DM.FolderName,
DM.ModuleName,
DM.SupportedFeatures,
DM.CompatibleVersions,
DM.Dependencies,
DM.Permissions,
MD.DefaultCacheTime,
MC.ModuleControlId,
MC.ControlSrc,
MC.ControlType,
MC.ControlTitle,
MC.HelpURL,
MC.SupportsPartialRendering
FROM DBR_ModuleDefinitions AS MD
INNER JOIN DBR_Modules AS M ON MD.ModuleDefID = M.ModuleDefID
INNER JOIN DBR_DesktopModules AS DM ON MD.DesktopModuleID = DM.DesktopModuleID
INNER JOIN DBR_ModuleControls AS MC ON MD.ModuleDefID = MC.ModuleDefID
LEFT OUTER JOIN DBR_Tabs AS T
INNER JOIN DBR_TabModules AS TM ON T.TabID = TM.TabID
ON M.ModuleID = TM.ModuleID
WHERE (MC.ControlKey IS NULL)
System.Data.SqlClient.SqlException: Invalid column name 'FileID'.
Invalid column name 'FileID'.
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.[DBR_vw_Portals]
AS
SELECT
PortalID,
PortalName,
CASE WHEN LEFT(LOWER(LogoFile), 6) = 'fileid'
THEN
(SELECT Folder + FileName
FROM DBR_Files
WHERE 'fileid=' + convert(varchar,DBR_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 DBR_Files
WHERE 'fileid=' + convert(varchar,DBR_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 DBR_Tabs WHERE (PortalID IS NULL) AND (ParentId IS NULL)) AS SuperTabId,
(SELECT TOP 1 RoleName FROM DBR_Roles WHERE (RoleID = P.AdministratorRoleId)) AS AdministratorRoleName,
(SELECT TOP 1 RoleName FROM DBR_Roles WHERE (RoleID = P.RegisteredRoleId)) AS RegisteredRoleName
FROM DBR_Portals AS P
LEFT OUTER JOIN DBR_Users AS U ON P.AdministratorId = U.UserID
System.Data.SqlClient.SqlException: Invalid column name 'PortalId'.
Invalid column name 'PortalId'.
Invalid column name 'PropertyDefinitionId'.
Invalid column name 'PortalId'.
Invalid column name 'ModuleDefId'.
Invalid column name 'PropertyDefinitionId'.
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 PROCEDURE dbo.DBR_AddPropertyDefinition
@PortalId int,
@ModuleDefId int,
@DataType int,
@DefaultValue ntext,
@PropertyCategory nvarchar(50),
@PropertyName nvarchar(50),
@Required bit,
@ValidationExpression nvarchar(100),
@ViewOrder int,
@Visible bit,
@Length int
AS
DECLARE @PropertyDefinitionId int
SELECT @PropertyDefinitionId = PropertyDefinitionId
FROM DBR_ProfilePropertyDefinition
WHERE (PortalId = @PortalId OR (PortalId IS NULL AND @PortalId IS NULL))
AND PropertyName = @PropertyName
IF @PropertyDefinitionId is null
BEGIN
INSERT DBR_ProfilePropertyDefinition (
PortalId,
ModuleDefId,
Deleted,
DataType,
DefaultValue,
PropertyCategory,
PropertyName,
Required,
ValidationExpression,
ViewOrder,
Visible,
Length
)
VALUES (
@PortalId,
@ModuleDefId,
0,
@DataType,
@DefaultValue,
@PropertyCategory,
@PropertyName,
@Required,
@ValidationExpression,
@ViewOrder,
@Visible,
@Length
)
SELECT @PropertyDefinitionId = SCOPE_IDENTITY()
END
ELSE
BEGIN
UPDATE DBR_ProfilePropertyDefinition
SET DataType = @DataType,
ModuleDefId = @ModuleDefId,
DefaultValue = @DefaultValue,
PropertyCategory = @PropertyCategory,
Required = @Required,
ValidationExpression = @ValidationExpression,
ViewOrder = @ViewOrder,
Deleted = 0,
Visible = @Visible,
Length = @Length
WHERE PropertyDefinitionId = @PropertyDefinitionId
END
SELECT @PropertyDefinitionId
System.Data.SqlClient.SqlException: Invalid column name 'PropertyDefinitionId'.
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 PROCEDURE dbo.DBR_UpdatePropertyDefinition
@PropertyDefinitionId int,
@DataType int,
@DefaultValue nvarchar(50),
@PropertyCategory nvarchar(50),
@PropertyName nvarchar(50),
@Required bit,
@ValidationExpression nvarchar(100),
@ViewOrder int,
@Visible bit,
@Length int
AS
UPDATE DBR_ProfilePropertyDefinition
SET DataType = @DataType,
DefaultValue = @DefaultValue,
PropertyCategory = @PropertyCategory,
PropertyName = @PropertyName,
Required = @Required,
ValidationExpression = @ValidationExpression,
ViewOrder = @ViewOrder,
Visible = @Visible,
Length = @Length
WHERE PropertyDefinitionId = @PropertyDefinitionId
System.Data.SqlClient.SqlException: Invalid column name 'TabId'.
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 procedure dbo.[DBR_UpdateTabOrder]
@TabId int,
@TabOrder int,
@Level int,
@ParentId int,
@TabPath nvarchar(255)
AS
UPDATE DBR_Tabs
SET
TabOrder = @TabOrder,
[Level] = @Level,
ParentId = @ParentId,
TabPath = @TabPath
WHERE TabId = @TabId
04.05.01.log
System.Data.SqlClient.SqlException: Invalid column name 'FileID'.
Invalid column name 'FileID'.
Invalid column name 'FileID'.
Invalid column name 'FileID'.
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)
/* add unique constraint to Files table */
IF NOT EXISTS (select * from dbo.sysobjects where id = object_id(N'dbo.[IX_DBR_FileName]') and OBJECTPROPERTY(id, N'IsConstraint') = 1)
BEGIN
declare @FolderID int
declare @FileName nvarchar(100)
declare @FileID int
declare @MinFileID int
select @FolderID = min(FolderID)
from DBR_Folders
while @FolderID is not null
begin
/* check for duplicate Filenames */
select @FileName = null
select @FileName = FileName
from DBR_Files
where FolderID = @FolderID
group by FileName
having COUNT(*) > 1
/* if duplicates exist */
if @FileName is not null
begin
/* iterate through the duplicates */
select @FileID = min(FileID)
from DBR_Files
where FolderID = @FolderID
and FileName = @FileName
/* save min FileID */
select @MinFileID = @FileID
while @FileID is not null
begin
if @FileID <> @MinFileID
begin
/* remove duplicate file */
delete
from DBR_Files
where FileID = @FileID
end
select @FileID = min(FileID)
from DBR_Files
where FolderID = @FolderID
and FileName = @FileName
and FileID > @FileID
end
end
select @FolderID = min(FolderID)
from DBR_Folders
where FolderID > @FolderID
end
ALTER TABLE dbo.DBR_Files ADD CONSTRAINT
IX_DBR_FileName UNIQUE NONCLUSTERED
(
FolderID,
FileName
) ON [PRIMARY]
END
HELP PLEASE!
PS is the search function on these forums going to ever work?