georgeb
New Member Posts:1
|
11/12/2009 2:22 PM |
|
tried to install your DMX module and i get this....hers the errors
|
StartJob |
Starting Installation |
Info |
Starting Installation - Bring2mind\DMX |
Info |
Starting Installation - Script |
Info |
Begin Sql execution |
Info |
Folder Created - C:\Inetpub\ColemanPortal\DesktopModules\Bring2mind\DMX\ |
Info |
Created - Install.05.00.00.SqlDataProvider |
Info |
Executing Install.05.00.00.SqlDataProvider |
Info |
Start Sql execution: Install.05.00.00.SqlDataProvider file |
Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 7: Incorrect syntax near 'max'. 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 TABLE dbo.[CP_DMX_LongTexts] ( [Locale] [nvarchar] (6) NOT NULL, [ObjectId] [int] NOT NULL, [SubTypeKey] [nvarchar] (20) NOT NULL, [Text] [nvarchar] (max) NOT NULL, [TypeKey] [nvarchar] (3) NOT NULL ) System.Data.SqlClient.SqlException: Cannot alter table 'dbo.CP_DMX_LongTexts' because this table does not exist in database 'ColemanPortal'. 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) ALTER TABLE dbo.[CP_DMX_LongTexts] ADD CONSTRAINT [PK_CP_DMX_LongTexts] PRIMARY KEY CLUSTERED ([Locale], [ObjectId], [SubTypeKey], [TypeKey]) System.Data.SqlClient.SqlException: Line 8: Incorrect syntax near 'MAX'. Must declare the variable '@Text'. 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.CP_DMX_UpdateLongText @TypeKey NVarChar (3), @SubTypeKey NVarChar (20), @ObjectId Int, @Locale NVarChar (6), @Text NVarChar(MAX) AS UPDATE dbo.CP_DMX_LongTexts SET [Text] = @Text WHERE [TypeKey] = @TypeKey AND [SubTypeKey] = @SubTypeKey AND [ObjectId] = @ObjectId AND [Locale] = @Locale System.Data.SqlClient.SqlException: Line 8: Incorrect syntax near 'MAX'. Must declare the variable '@Text'. 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.CP_DMX_AddLongText @TypeKey NVarChar (3), @SubTypeKey NVarChar (20), @ObjectId Int, @Locale NVarChar (6), @Text NVarChar(MAX) AS INSERT INTO dbo.CP_DMX_LongTexts ( [TypeKey], [SubTypeKey], [ObjectId], [Locale], Text ) VALUES ( @TypeKey, @SubTypeKey, @ObjectId, @Locale, @Text ) System.Data.SqlClient.SqlException: Line 10: Incorrect syntax near 'DISABLE'. Line 17: Incorrect syntax near 'ENABLE'. 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.CP_DMX_SetDeleteRecursive @PortalId Int, @EntryId Int, @Delete BIT AS DECLARE @Path VARCHAR(2000) SET @Path = (SELECT [Path] FROM dbo.CP_DMX_Entries WHERE EntryId=@EntryId AND PortalId=@PortalId)+'%'; DISABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; UPDATE dbo.CP_DMX_Entries SET Deleted=@Delete WHERE PortalId=@PortalId AND (LastVersionId=@EntryId OR [Path] LIKE @Path); ENABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; System.Data.SqlClient.SqlException: Line 17: Incorrect syntax near 'DISABLE'. Line 20: Incorrect syntax near 'ENABLE'. Line 24: Incorrect syntax near 'DISABLE'. Line 40: Incorrect syntax near 'ENABLE'. 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 TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries AFTER INSERT, UPDATE AS DECLARE @EntryId INT DECLARE @PortalId INT DECLARE @RowCount INT SELECT @RowCount=(SELECT COUNT(*) FROM INSERTED) IF @RowCount=1 BEGIN SELECT @EntryId = (SELECT EntryId FROM INSERTED); SELECT @PortalId = (SELECT PortalId FROM INSERTED); DISABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; EXEC dbo.CP_DMX_UpdatePaths @PortalId, @EntryId; EXEC dbo.CP_DMX_SetLastModified @PortalId, @EntryId; ENABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; END ELSE BEGIN DISABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; DECLARE cursorX CURSOR FOR SELECT EntryId, PortalID FROM INSERTED BEGIN OPEN cursorX FETCH cursorX INTO @EntryId, @PortalId WHILE @@fetch_status=0 BEGIN FETCH cursorX INTO @EntryId, @PortalId; EXEC dbo.CP_DMX_UpdatePaths @PortalId, @EntryId; EXEC dbo.CP_DMX_SetLastModified @PortalId, @EntryId; END; CLOSE cursorX; DEALLOCATE cursorX; ENABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; END; END |
Info |
End Sql execution: Install.05.00.00.SqlDataProvider file |
Info |
Created - 05.00.01.SqlDataProvider |
Info |
Executing 05.00.01.SqlDataProvider |
Info |
Start Sql execution: 05.00.01.SqlDataProvider file |
Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 17: Incorrect syntax near 'DISABLE'. Line 20: Incorrect syntax near 'ENABLE'. Line 36: Incorrect syntax near 'DISABLE'. Line 39: Incorrect syntax near 'ENABLE'. 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 TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries AFTER INSERT, UPDATE AS DECLARE @EntryId INT DECLARE @PortalId INT DECLARE @RowCount INT SELECT @RowCount=(SELECT COUNT(*) FROM INSERTED) IF @RowCount=1 BEGIN SELECT @EntryId = (SELECT EntryId FROM INSERTED); SELECT @PortalId = (SELECT PortalId FROM INSERTED); DISABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; EXEC dbo.CP_DMX_UpdatePaths @PortalId, @EntryId; EXEC dbo.CP_DMX_SetLastModified @PortalId, @EntryId; ENABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; END ELSE BEGIN DECLARE cursorX CURSOR FOR SELECT INSERTED.EntryId, INSERTED.PortalID FROM INSERTED INNER JOIN DELETED ON INSERTED.EntryId= DELETED.EntryId WHERE INSERTED.CollectionId <> DELETED.EntryId; BEGIN OPEN cursorX FETCH cursorX INTO @EntryId, @PortalId WHILE @@fetch_status=0 BEGIN FETCH cursorX INTO @EntryId, @PortalId; DISABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; EXEC dbo.CP_DMX_UpdatePaths @PortalId, @EntryId; EXEC dbo.CP_DMX_SetLastModified @PortalId, @EntryId; ENABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; END; CLOSE cursorX; DEALLOCATE cursorX; END; END |
Info |
End Sql execution: 05.00.01.SqlDataProvider file |
Info |
Created - 05.00.02.SqlDataProvider |
Info |
Executing 05.00.02.SqlDataProvider |
Info |
Start Sql execution: 05.00.02.SqlDataProvider file |
Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 11: Incorrect syntax near 'DISABLE'. Line 19: Incorrect syntax near 'ENABLE'. 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.CP_DMX_LockEntry @PortalId Int, @EntryId Int, @LockedUntil DateTime, @LockedBy Int, @LockKey UNIQUEIDENTIFIER AS DISABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; UPDATE dbo.CP_DMX_Entries SET [LockedBy] = @LockedBy, [LockedUntil] = @LockedUntil, [LockKey] = @LockKey WHERE ([EntryId] = @EntryId OR LastVersionId=@EntryId) AND [PortalId] = @PortalId; ENABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; System.Data.SqlClient.SqlException: Line 8: Incorrect syntax near 'DISABLE'. Line 16: Incorrect syntax near 'ENABLE'. 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.CP_DMX_UnLockEntry @PortalId Int, @EntryId Int AS DISABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; UPDATE dbo.CP_DMX_Entries SET [LockedBy] = -1, [LockedUntil] = GETDATE(), [LockKey] = NULL WHERE ([EntryId] = @EntryId OR LastVersionId=@EntryId) AND [PortalId] = @PortalId; ENABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'WITH'. Line 17: Incorrect syntax near ')'. 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 FUNCTION dbo.CP_DMX_Split (@s varchar(512), @sep char(1)) RETURNS table AS RETURN ( WITH Pieces(pn, start, stop) AS ( SELECT 1, 1, CHARINDEX(@sep, @s) UNION ALL SELECT pn + 1, stop + 1, CHARINDEX(@sep, @s, stop + 1) FROM Pieces WHERE stop > 0 ) SELECT pn, SUBSTRING(@s, start, CASE WHEN stop > 0 THEN stop-start ELSE 512 END) AS s FROM Pieces ) |
Info |
End Sql execution: 05.00.02.SqlDataProvider file |
Info |
Created - 05.00.03.SqlDataProvider |
Info |
Executing 05.00.03.SqlDataProvider |
Info |
Start Sql execution: 05.00.03.SqlDataProvider file |
Info |
End Sql execution: 05.00.03.SqlDataProvider file |
Info |
Created - 05.01.00.SqlDataProvider |
Info |
Executing 05.01.00.SqlDataProvider |
Info |
Start Sql execution: 05.01.00.SqlDataProvider file |
Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 6: Incorrect syntax near '('. 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 NONCLUSTERED INDEX IX_CP_DMX_Entries_CollectionID ON dbo.CP_DMX_Entries ( CollectionId ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] System.Data.SqlClient.SqlException: Line 7: Incorrect syntax near 'INCLUDE'. 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 NONCLUSTERED INDEX IX_CP_UserRoles_DMX ON dbo.CP_UserRoles ( [RoleID] ASC ) INCLUDE ([UserID], [ExpiryDate], [EffectiveDate]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY] System.Data.SqlClient.SqlException: Line 14: Incorrect syntax near 'INCLUDE'. 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 NONCLUSTERED INDEX IX_CP_DMX_Entries_Data1 ON dbo.CP_DMX_Entries ( [LastVersionId] ASC, [EntryId] ASC, [CollectionId] ASC, [Deleted] ASC, [IsApproved] ASC, [Owner] ASC, [Version] ASC, [EntryType] ASC ) INCLUDE ([Author], [Entry], [FileSize], [Created], [Keywords], [LastModified], [LockedBy], [LockedUntil], [LockKey], [MD5Hash], [OriginalFileName], [PortalId], [State], [VersionsToKeep], [WorkflowId], [Path], [PermissionsOnlyByAdmin]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY] System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'WITH'. 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.CP_DMX_GetAttributeListForEntry @PortalId INT, @CollectionId INT, @EntryId INT, @EntryType NVARCHAR(50), @IncludePrivate BIT, @Locale NVARCHAR(10) AS WITH tmp(EntryId , CollectionId ) AS (SELECT e1.EntryId, e1.CollectionId FROM dbo.CP_DMX_Entries e1 WHERE e1.EntryId=@CollectionId AND e1.InheritAttributes=1 UNION ALL SELECT e.EntryId, e.CollectionId FROM dbo.CP_DMX_Entries e INNER JOIN tmp ON e.EntryId=tmp.CollectionId WHERE e.InheritAttributes=1) SELECT ea.[EntryId], ea.[Value], a.*, ISNULL((SELECT [Text] FROM dbo.CP_DMX_ShortTexts WHERE TypeKey='ATT' AND SubTypeKey='NAME' AND ObjectId=a.AttributeId AND Locale=@Locale), (SELECT [Text] FROM dbo.CP_DMX_ShortTexts WHERE TypeKey='ATT' AND SubTypeKey='NAME' AND ObjectId=a.AttributeId AND Locale='')) Name, CAST ((CASE WHEN (NOT EXISTS(SELECT * FROM dbo.CP_DMX_AttributeEntrytypes WHERE AttributeId=a.AttributeId) OR EXISTS(SELECT * FROM dbo.CP_DMX_AttributeEntrytypes WHERE AttributeId=a.AttributeId AND @EntryType LIKE EntryType+'%')) THEN 1 ELSE 0 END) AS BIT) AS Applies FROM dbo.CP_DMX_Attributes a LEFT JOIN (SELECT * FROM dbo.CP_DMX_EntryAttributes WHERE EntryId = @EntryId) ea ON ea.AttributeId=a.AttributeId LEFT JOIN tmp ON tmp.CollectionId=a.CollectionId WHERE a.PortalId=@PortalId AND (a.IsPrivate=0 OR @IncludePrivate=1) AND (a.CollectionId=-1 OR (NOT tmp.CollectionId IS NULL) OR a.CollectionId=@CollectionId) System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'WITH'. 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.CP_DMX_GetAttributes @PortalId INT, @CollectionId INT, @IncludePrivate BIT, @Locale NVARCHAR(10) AS WITH tmp(EntryId , CollectionId ) AS (SELECT e1.EntryId, e1.CollectionId FROM dbo.CP_DMX_Entries e1 WHERE e1.EntryId=@CollectionId AND e1.InheritAttributes=1 UNION ALL SELECT e.EntryId, e.CollectionId FROM dbo.CP_DMX_Entries e INNER JOIN tmp ON e.EntryId=tmp.CollectionId WHERE e.InheritAttributes=1) SELECT a.*, ISNULL((SELECT [Text] FROM dbo.CP_DMX_ShortTexts WHERE TypeKey='ATT' AND SubTypeKey='NAME' AND ObjectId=a.AttributeId AND Locale=@Locale), (SELECT [Text] FROM dbo.CP_DMX_ShortTexts WHERE TypeKey='ATT' AND SubTypeKey='NAME' AND ObjectId=a.AttributeId AND Locale='')) Name FROM dbo.CP_DMX_Attributes a LEFT JOIN tmp ON tmp.CollectionId=a.CollectionId WHERE a.PortalId=@PortalId AND (a.IsPrivate=0 OR @IncludePrivate=1) AND (a.CollectionId=-1 OR (NOT tmp.CollectionId IS NULL) OR a.CollectionId=@CollectionId) System.Data.SqlClient.SqlException: Line 17: Incorrect syntax near 'DISABLE'. Line 19: Incorrect syntax near 'ENABLE'. Line 36: Incorrect syntax near 'DISABLE'. Line 38: Incorrect syntax near 'ENABLE'. 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 TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries AFTER INSERT, UPDATE AS DECLARE @EntryId INT DECLARE @PortalId INT DECLARE @RowCount INT SELECT @RowCount=(SELECT COUNT(*) FROM INSERTED) IF @RowCount=1 BEGIN SELECT @EntryId = (SELECT EntryId FROM INSERTED); SELECT @PortalId = (SELECT PortalId FROM INSERTED); DISABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; EXEC dbo.CP_DMX_UpdatePaths @PortalId, @EntryId; ENABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; EXEC dbo.CP_DMX_SetLastModified @PortalId, @EntryId; END ELSE BEGIN DECLARE cursorX CURSOR FOR SELECT INSERTED.EntryId, INSERTED.PortalID FROM INSERTED INNER JOIN DELETED ON INSERTED.EntryId= DELETED.EntryId WHERE INSERTED.CollectionId <> DELETED.EntryId; BEGIN OPEN cursorX FETCH cursorX INTO @EntryId, @PortalId WHILE @@fetch_status=0 BEGIN FETCH cursorX INTO @EntryId, @PortalId; DISABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; EXEC dbo.CP_DMX_UpdatePaths @PortalId, @EntryId; ENABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; EXEC dbo.CP_DMX_SetLastModified @PortalId, @EntryId; END; CLOSE cursorX; DEALLOCATE cursorX; END; END System.Data.SqlClient.SqlException: Line 16: Incorrect syntax near 'DISABLE'. Line 22: Incorrect syntax near 'ENABLE'. 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.CP_DMX_SetLastModified @PortalId Int, @EntryId Int, @LastModified DATETIME = NULL AS BEGIN DECLARE @entrypath VARCHAR(4000) SET @entrypath = (SELECT [Path] FROM dbo.CP_DMX_Entries WHERE EntryId = @EntryId); IF @LastModified IS NULL SET @LastModified = GETDATE(); DISABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; UPDATE dbo.CP_DMX_Entries SET LastModified=@LastModified WHERE PortalId=@PortalId AND @entrypath LIKE [Path]+'%' AND EntryId=LastVersionId; ENABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; END System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'TOP'. 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) -- delete duplicates from scheduler DECLARE @cnt int, @TypeFullName as varchar(200) DECLARE dupCursor CURSOR FAST_FORWARD FOR SELECT TypeFullName, COUNT(TypeFullName) AS Cnt FROM dbo.CP_Schedule GROUP BY TypeFullName HAVING COUNT(TypeFullName) > 1 AND TypeFullName LIKE 'Bring2mind%' OPEN dupCursor FETCH NEXT FROM dupCursor INTO @TypeFullName, @cnt WHILE @@FETCH_STATUS = 0 BEGIN DELETE TOP (@cnt-1) FROM dbo.CP_Schedule WHERE TypeFullName = @TypeFullName FETCH NEXT FROM dupCursor INTO @TypeFullName, @cnt END CLOSE dupCursor DEALLOCATE dupCursor |
Info |
End Sql execution: 05.01.00.SqlDataProvider file |
Info |
Created - 05.01.01.SqlDataProvider |
Info |
Executing 05.01.01.SqlDataProvider |
Info |
Start Sql execution: 05.01.01.SqlDataProvider file |
Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'WITH'. 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.CP_DMX_GetAttributeListForEntry @PortalId INT, @CollectionId INT, @EntryId INT, @EntryType NVARCHAR(50), @IncludePrivate BIT, @Locale NVARCHAR(10) AS WITH tmp(EntryId , CollectionId ) AS (SELECT e1.EntryId, e1.CollectionId FROM dbo.CP_DMX_Entries e1 WHERE e1.EntryId=@CollectionId AND e1.InheritAttributes=1 UNION ALL SELECT e.EntryId, e.CollectionId FROM dbo.CP_DMX_Entries e INNER JOIN tmp ON e.EntryId=tmp.CollectionId WHERE e.InheritAttributes=1) SELECT ea.[EntryId], ea.[Value], a.*, ISNULL((SELECT [Text] FROM dbo.CP_DMX_ShortTexts WHERE TypeKey='ATT' AND SubTypeKey='NAME' AND ObjectId=a.AttributeId AND Locale=@Locale), (SELECT [Text] FROM dbo.CP_DMX_ShortTexts WHERE TypeKey='ATT' AND SubTypeKey='NAME' AND ObjectId=a.AttributeId AND Locale='')) Name, CAST ((CASE WHEN (NOT EXISTS(SELECT * FROM dbo.CP_DMX_AttributeEntrytypes WHERE AttributeId=a.AttributeId) OR EXISTS(SELECT * FROM dbo.CP_DMX_AttributeEntrytypes WHERE AttributeId=a.AttributeId AND @EntryType LIKE EntryType+'%')) THEN 1 ELSE 0 END) AS BIT) AS Applies FROM dbo.CP_DMX_Attributes a LEFT JOIN (SELECT * FROM dbo.CP_DMX_EntryAttributes WHERE EntryId = @EntryId) ea ON ea.AttributeId=a.AttributeId LEFT JOIN tmp ON tmp.CollectionId=a.CollectionId WHERE a.PortalId=@PortalId AND (a.IsPrivate=0 OR @IncludePrivate=1) AND (a.CollectionId=-1 OR (NOT tmp.CollectionId IS NULL) OR a.CollectionId=@CollectionId) ORDER BY CASE a.CollectionId WHEN -1 THEN 0 ELSE 1 END, a.ViewOrder |
Info |
End Sql execution: 05.01.01.SqlDataProvider file |
Info |
Created - 05.01.02.SqlDataProvider |
Info |
Executing 05.01.02.SqlDataProvider |
Info |
Start Sql execution: 05.01.02.SqlDataProvider file |
Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid object name 'dbo.CP_DMX_LongTexts'. 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) -- clean up Remarks that were filled with   by the HTML editor DELETE FROM dbo.CP_DMX_LongTexts WHERE [Text]='  ' System.Data.SqlClient.SqlException: Line 12: Incorrect syntax near 'DISABLE'. Line 17: Incorrect syntax near 'ENABLE'. 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.CP_DMX_SetLastModified @PortalId Int, @EntryId Int, @LastModified DATETIME = NULL AS BEGIN IF @LastModified IS NULL SET @LastModified = GETDATE(); DISABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; UPDATE dbo.CP_DMX_Entries SET LastModified=@LastModified WHERE PortalId=@PortalId AND EntryId=@EntryId; ENABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; END System.Data.SqlClient.SqlException: Line 5: Incorrect syntax near 'DISABLE'. Line 9: Incorrect syntax near 'ENABLE'. 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) -- repair missing LastModified where they are NULL BEGIN DISABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; UPDATE dbo.CP_DMX_Entries SET LastModified = (SELECT MAX(l.Datime) FROM dbo.CP_DMX_Log l WHERE l.EntId=EntryId) WHERE LastModified IS NULL; ENABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; END |
Info |
End Sql execution: 05.01.02.SqlDataProvider file |
Info |
Created - 05.01.03.SqlDataProvider |
Info |
Executing 05.01.03.SqlDataProvider |
Info |
Start Sql execution: 05.01.03.SqlDataProvider file |
Warning |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 16: Incorrect syntax near 'DISABLE'. Line 21: Incorrect syntax near 'ENABLE'. 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.CP_DMX_SetLastModified @PortalId Int, @EntryId Int, @LastModified DATETIME = NULL AS BEGIN DECLARE @entrypath VARCHAR(4000) SET @entrypath = (SELECT [Path] FROM dbo.CP_DMX_Entries WHERE EntryId = @EntryId); IF @LastModified IS NULL SET @LastModified = GETDATE(); DISABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; UPDATE dbo.CP_DMX_Entries SET LastModified=@LastModified WHERE PortalId=@PortalId AND @entrypath LIKE [Path]+'%'; ENABLE TRIGGER dbo.CP_DMX_EntryUpdatePath ON dbo.CP_DMX_Entries; END |
Info |
End Sql execution: 05.01.03.SqlDataProvider file |
Info |
Created - Uninstall.SqlDataProvider |
Info |
Finished Sql execution |
Info |
Component installed successfully - Script |
Info |
Starting Installation - Cleanup |
Info |
Processing Cleanup File - 4.0.0 |
Info |
Completed Processing of Cleanup File - 4.0.0 |
Info |
Component installed successfully - Cleanup |
|
|
|
|
|
|