07.02.01.log.resources

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ObjectData'.
Invalid column name 'ObjectData'.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script)
ClientConnectionId:35cd05c2-7bd2-49be-ba7d-444b90d0bd32

CREATE PROCEDURE dbo.[CoreMessaging_AddSubscription]
@UserId INT ,
@PortalId INT ,
@SubscriptionTypeId INT ,
@ObjectKey NVARCHAR(255) ,
@Description NVARCHAR(255),
@ModuleId INT ,
@TabId INT,
@ObjectData NVARCHAR(MAX)
AS
BEGIN
DECLARE @SubscriptionId INT = NULL

SELECT TOP 1 @SubscriptionId = SubscriptionId
FROM dbo.CoreMessaging_Subscriptions
WHERE UserId = @UserId
AND (( @PortalId is null and PortalId is null) or (PortalId = @PortalId))
AND SubscriptionTypeId = @SubscriptionTypeID
AND ObjectKey = @ObjectKey
AND ((@ModuleId is null and ModuleId is null ) or (ModuleId = @ModuleId))
AND ((@TabId is null and TabId is null ) or (TabId = @TabId))

IF (@SubscriptionId IS NULL)
BEGIN
INSERT INTO dbo.CoreMessaging_Subscriptions
( UserId ,
PortalId ,
SubscriptionTypeId ,
ObjectKey ,
Description,
CreatedOnDate ,
ModuleId ,
TabId,
ObjectData
)
VALUES ( @UserId ,
@PortalId ,
@SubscriptionTypeId ,
@ObjectKey ,
@Description,
GETUTCDATE() ,
@ModuleId ,
@TabId,
@ObjectData
)

SELECT SCOPE_IDENTITY() AS [SubscriptionId]
END
ELSE
BEGIN
UPDATE dbo.CoreMessaging_Subscriptions
SET UserId = @UserId ,
PortalId = @PortalId ,
SubscriptionTypeId = @SubscriptionTypeId ,
ObjectKey = @ObjectKey ,
Description = @Description ,
ModuleId = @ModuleId ,
TabId = @TabId,
ObjectData = @ObjectData
WHERE SubscriptionId = @SubscriptionId

SELECT @SubscriptionId AS [SubscriptionId]
END
END

07.04.00.log.resources