Tried to install DMX 5.2.9 on my DNN installation on the server running plesk, and cant seem to be able to install it no matter what I do.

On the same server had other dnn install but not set up by plesk and had no issues there what so ever.
I am really puzzled by this. Has anyone got any idea why might that be happening?

Event viewer shows the following:
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UpdateNotification' in the database. 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() 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 DotNetNuke_1.DMX_UpdateNotification @UserId Int, @LogId Int, @PortalId Int, @Sent DateTime, @Template NVarChar (100) AS UPDATE DotNetNuke_1.DMX_Notifications SET [PortalId] = @PortalId, [Sent] = @Sent, [Template] = @Template WHERE [UserId] = @UserId AND [LogId] = @LogId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetSubscription' in the database. 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() 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 DotNetNuke_1.DMX_GetSubscription @UserId Int, @EntryId Int AS SELECT * FROM DotNetNuke_1.DMX_Subscriptions WHERE [UserId] = @UserId AND [EntryId] = @EntryId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddEntry' in the database. 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() 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 DotNetNuke_1.DMX_AddEntry @Author NVarChar(500), @CollectionId Int, @Created DateTime, @Deleted Bit, @Entry NVarChar (255), @EntryType NVarChar (150), @FileSize BIGINT, @IsApproved Bit, @Keywords NVarChar (255), @LastModified DateTime, @LastVersionId Int, @LockedBy Int, @LockedUntil DateTime, @LockKey UNIQUEIDENTIFIER, @MD5Hash NVarChar(50), @OriginalFileName NVarChar (255), @Owner Int, @Path NVarChar (255), @PermissionsOnlyByAdmin Bit, @PortalId Int, @State NVarChar (50), @Version Int, @VersionsToKeep Int, @WorkflowId NVarChar (50) AS INSERT INTO DotNetNuke_1.DMX_Entries ( [Author], [CollectionId], [Created], [Deleted], [Entry], [EntryType], [FileSize], [IsApproved], [Keywords], [LastModified], [LastVersionId], [LockedBy], [LockedUntil], [LockKey], [MD5Hash], [OriginalFileName], [Owner], [Path], [PermissionsOnlyByAdmin], [PortalId], [State], [Version], [VersionsToKeep], [WorkflowId] ) VALUES ( @Author, @CollectionId, @Created, @Deleted, @Entry, @EntryType, @FileSize, @IsApproved, @Keywords, @LastModified, @LastVersionId, @LockedBy, @LockedUntil, @LockKey, @MD5Hash, @OriginalFileName, @Owner, @Path, @PermissionsOnlyByAdmin, @PortalId, @State, @Version, @VersionsToKeep, @WorkflowId ) select SCOPE_IDENTITY() System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeleteLogType' in the database. 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() 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 DotNetNuke_1.DMX_DeleteLogType @PortalId Int, @LogTypeKey NVarChar (20) AS DELETE FROM DotNetNuke_1.DMX_LogTypes WHERE [PortalId] = @PortalId AND [LogTypeKey] = @LogTypeKey System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_SetLastModified' in the database. 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() 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 DotNetNuke_1.DMX_SetLastModified @PortalId Int, @EntryId Int AS DECLARE @CollectionId INT SELECT @CollectionId = (SELECT CollectionId FROM DotNetNuke_1.DMX_Entries WHERE EntryId=@EntryId) IF @CollectionId>0 EXEC DotNetNuke_1.DMX_SetLastModified @PortalId, @CollectionId UPDATE DotNetNuke_1.DMX_Entries SET LastModified=GETDATE() WHERE EntryId=@EntryId AND PortalId=@PortalId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddNotification' in the database. 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() 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 DotNetNuke_1.DMX_AddNotification @UserId Int, @LogId Int, @PortalId Int, @Sent DateTime, @Template NVarChar (100) AS INSERT INTO DotNetNuke_1.DMX_Notifications ( [UserId], [LogId], PortalId, Sent, Template ) VALUES ( @UserId, @LogId, @PortalId, @Sent, @Template ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeleteAttribute' in the database. 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() 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 DotNetNuke_1.DMX_DeleteAttribute @AttributeId Int AS BEGIN DELETE FROM DMX_EntryAttributes WHERE AttributeId=@AttributeId DELETE FROM DotNetNuke_1.DMX_Attributes WHERE [AttributeId] = @AttributeId END System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetEntry' in the database. 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() 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 DotNetNuke_1.DMX_GetEntry @EntryId Int, @PortalId int, @Locale NVarChar(10) AS SELECT e.*, ISNULL((SELECT [Text] FROM DotNetNuke_1.DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale=@Locale), (SELECT [Text] FROM DotNetNuke_1.DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale='')) Title, ISNULL((SELECT [Text] FROM DotNetNuke_1.DMX_LongTexts WHERE TypeKey='ENT' AND SubTypeKey='REMARKS' AND ObjectId=e.EntryId AND Locale=@Locale), (SELECT [Text] FROM DotNetNuke_1.DMX_LongTexts WHERE TypeKey='ENT' AND SubTypeKey='REMARKS' AND ObjectId=e.EntryId AND Locale='')) Remarks FROM DotNetNuke_1.DMX_Entries e WHERE [EntryId] = @EntryId AND [PortalId] = @PortalId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UpdateLog' in the database. 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() 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 DotNetNuke_1.DMX_UpdateLog @id Int, @Action NVarChar (20), @Datime DateTime, @EntId Int, @UserId Int AS UPDATE DotNetNuke_1.DMX_Log SET [Action] = @Action, [Datime] = @Datime, [EntId] = @EntId, [UserId] = @UserId WHERE [id] = @id System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetParentChain' in the database. 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() 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 DotNetNuke_1.DMX_GetParentChain @PortalId Int, @EntryId Int, @Locale NVarChar(10) AS DECLARE @CollectionId INT SELECT @CollectionId = (SELECT CollectionId FROM DotNetNuke_1.DMX_Entries WHERE EntryId=@EntryId) IF @CollectionId>0 EXEC DotNetNuke_1.DMX_GetParentChain @PortalId, @CollectionId, @Locale SELECT e.*, ISNULL((SELECT [Text] FROM DotNetNuke_1.DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale=@Locale), (SELECT [Text] FROM DotNetNuke_1.DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale='')) Title FROM DotNetNuke_1.DMX_Entries e WHERE [EntryId] = @EntryId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_MoveEntry' in the database. 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() 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 DotNetNuke_1.DMX_MoveEntry @PortalId Int, @EntryId Int, @NewCollectionId INT AS UPDATE DotNetNuke_1.DMX_Entries SET CollectionId=@NewCollectionId WHERE LastVersionId=@EntryId AND PortalId=@PortalId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_MoveAllEntries' in the database. 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() 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 DotNetNuke_1.DMX_MoveAllEntries @PortalId Int, @OldCollectionId Int, @NewCollectionId Int AS UPDATE DotNetNuke_1.DMX_Entries SET [CollectionId] = @NewCollectionId WHERE [CollectionId] = @OldCollectionId AND [PortalId] = @PortalId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UpdateAttribute' in the database. 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() 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 DotNetNuke_1.DMX_UpdateAttribute @AttributeId Int, @Addon NVarChar (50), @ControlToLoad NVarChar (255), @EntryTypes NVarChar (255), @IsPrivate Bit, @Name NVarChar (50), @PortalId Int, @Required Bit, @ResourceFile NVarChar (255), @Values NVarChar (2000), @ValueType NVarChar (30), @ViewOrder Int AS UPDATE DotNetNuke_1.DMX_Attributes SET [Addon] = @Addon, [ControlToLoad] = @ControlToLoad, [EntryTypes] = @EntryTypes, [IsPrivate] = @IsPrivate, [Name] = @Name, [PortalId] = @PortalId, [Required] = @Required, [ResourceFile] = @ResourceFile, [Values] = @Values, [ValueType] = @ValueType, [ViewOrder] = @ViewOrder WHERE [AttributeId] = @AttributeId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddPermission' in the database. 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() 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 DotNetNuke_1.DMX_AddPermission @Addon NVarChar (50), @PermissionKey NVarChar (20), @PortalId Int, @ResourceFile NVarChar (255) AS INSERT INTO DotNetNuke_1.DMX_Permissions ( [Addon], [PermissionKey], [PortalId], [ResourceFile] ) VALUES ( @Addon, @PermissionKey, @PortalId, @ResourceFile ) select SCOPE_IDENTITY() System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UpdateLogType' in the database. 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() 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 DotNetNuke_1.DMX_UpdateLogType @PortalId Int, @LogTypeKey NVarChar (20), @AttachFile Bit, @CustomSend Bit, @NotifyApprovers NVarChar (100), @NotifyAudit BIT, @NotifyEditors NVarChar (100), @NotifyOwner NVarChar (100), @NotifySelf NVarChar (100), @NotifySubscribers NVarChar (100), @ResourceFile NVarChar (150) AS UPDATE DotNetNuke_1.DMX_LogTypes SET [AttachFile] = @AttachFile, [CustomSend] = @CustomSend, [NotifyApprovers] = @NotifyApprovers, [NotifyAudit] = @NotifyAudit, [NotifyEditors] = @NotifyEditors, [NotifyOwner] = @NotifyOwner, [NotifySelf] = @NotifySelf, [NotifySubscribers] = @NotifySubscribers, [ResourceFile] = @ResourceFile WHERE [PortalId] = @PortalId AND [LogTypeKey] = @LogTypeKey System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetAttributesByPortal' in the database. 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() 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 DotNetNuke_1.DMX_GetAttributesByPortal @PortalId Int AS SELECT a.*, ad.Description AS AddonsDescription FROM DotNetNuke_1.DMX_Addons ad INNER JOIN DotNetNuke_1.DMX_Attributes a ON ad.AddonKey = a.Addon WHERE a.PortalId = @PortalId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddSubscription' in the database. 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() 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 DotNetNuke_1.DMX_AddSubscription @UserId Int, @EntryId Int, @LastAccess DateTime AS INSERT INTO DotNetNuke_1.DMX_Subscriptions ( [UserId], [EntryId], LastAccess ) VALUES ( @UserId, @EntryId, @LastAccess ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetPermissionPermission' in the database. 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() 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 DotNetNuke_1.DMX_GetPermissionPermission @PermissionId Int, @RoleId Int AS SELECT * FROM DotNetNuke_1.DMX_PermissionPermissions WHERE [PermissionId] = @PermissionId AND [RoleId] = @RoleId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UnifySetPermission' in the database. 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() 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 DotNetNuke_1.DMX_UnifySetPermission @PortalId INT, @UnifyingUserId INT, @CollectionId INT, @PermissionKey NVARCHAR(20), @RoleId INT, @UserId INT AS BEGIN DECLARE @Id INT SELECT @Id = MIN(e.EntryId) FROM DotNetNuke_1.DMX_Entries e INNER JOIN (SELECT DISTINCT ep.EntryId FROM DotNetNuke_1.DMX_EntryPermissions ep INNER JOIN DotNetNuke_1.DMX_Permissions pt ON pt.PermissionId=ep.PermissionId LEFT JOIN DotNetNuke_1.UserRoles r ON r.RoleId=ep.RoleId WHERE pt.PermissionKey='EDIT' AND (ep.UserId=@UnifyingUserId OR r.UserId=@UnifyingUserId OR ep.RoleId=-1)) perm ON perm.EntryId=e.EntryId WHERE e.CollectionId=@CollectionId DECLARE @PermissionId INT SELECT @PermissionId = PermissionId FROM DotNetNuke_1.DMX_Permissions WHERE PermissionKey=@PermissionKey AND PortalId=@PortalId DECLARE @EntryType NVARCHAR(100) WHILE @Id IS NOT NULL BEGIN SELECT @EntryType = EntryType FROM DotNetNuke_1.DMX_Entries WHERE EntryId=@Id IF (SELECT COUNT(*) FROM DotNetNuke_1.DMX_PermissionEntrytypes WHERE PermissionId=@PermissionId AND @EntryType LIKE EntryType+'%') = 1 BEGIN IF NOT EXISTS(SELECT * FROM DotNetNuke_1.DMX_EntryPermissions WHERE [EntryId]=@Id AND [PermissionId]=@PermissionId AND [RoleId]=@RoleId AND [UserId]=@UserId AND [AllowAccess]=1 AND [PortalId]=@PortalId) INSERT INTO DotNetNuke_1.DMX_EntryPermissions ([EntryId], [PermissionId], [RoleId], [UserId], [AllowAccess], [Expires], [PortalId]) VALUES (@Id, @PermissionId, @RoleId, @UserId, 1, NULL, @PortalId) END EXEC DotNetNuke_1.DMX_UnifySetPermission @PortalId, @UnifyingUserId, @Id, @PermissionKey, @RoleId, @UserId SELECT @Id = MIN(e.EntryId) FROM DotNetNuke_1.DMX_Entries e INNER JOIN (SELECT DISTINCT ep.EntryId FROM DotNetNuke_1.DMX_EntryPermissions ep INNER JOIN DotNetNuke_1.DMX_Permissions pt ON pt.PermissionId=ep.PermissionId LEFT JOIN DotNetNuke_1.UserRoles r ON r.RoleId=ep.RoleId WHERE pt.PermissionKey='EDIT' AND (ep.UserId=@UnifyingUserId OR r.UserId=@UnifyingUserId OR ep.RoleId=-1)) perm ON perm.EntryId=e.EntryId WHERE e.CollectionId=@CollectionId AND e.EntryId>@Id END END System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UpdateEntryAttribute' in the database. 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() 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 DotNetNuke_1.DMX_UpdateEntryAttribute @EntryId Int, @AttributeId Int, @Value NVarChar (2000) AS UPDATE DotNetNuke_1.DMX_EntryAttributes SET [Value] = @Value WHERE [EntryId] = @EntryId AND [AttributeId] = @AttributeId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddCategory' in the database. 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() 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 DotNetNuke_1.DMX_AddCategory @ParentId Int, @PortalId Int, @ViewOrder Int AS INSERT INTO DotNetNuke_1.DMX_Categories ( [ParentId], [PortalId], [ViewOrder] ) VALUES ( @ParentId, @PortalId, @ViewOrder ) select SCOPE_IDENTITY() System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_FindAddonByName' in the database. 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() 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 DotNetNuke_1.DMX_FindAddonByName @Name NVarChar (50) AS SELECT * FROM DotNetNuke_1.DMX_Addons WHERE [Name] = @Name System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UpdateLongText' in the database. 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() 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 DotNetNuke_1.DMX_UpdateLongText @TypeKey NVarChar (3), @SubTypeKey NVarChar (20), @ObjectId Int, @Locale NVarChar (6), @Text NVarChar(MAX) AS UPDATE DotNetNuke_1.DMX_LongTexts SET [Text] = @Text WHERE [TypeKey] = @TypeKey AND [SubTypeKey] = @SubTypeKey AND [ObjectId] = @ObjectId AND [Locale] = @Locale System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddEntryPermission' in the database. 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() 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 DotNetNuke_1.DMX_AddEntryPermission @EntryId Int, @PermissionId Int, @RoleId Int, @UserId Int, @AllowAccess Bit, @Expires DateTime, @PortalId Int AS INSERT INTO DotNetNuke_1.DMX_EntryPermissions ( [EntryId], [PermissionId], [RoleId], [UserId], AllowAccess, Expires, PortalId ) VALUES ( @EntryId, @PermissionId, @RoleId, @UserId, @AllowAccess, @Expires, @PortalId ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeletePermissionPermission' in the database. 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() 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 DotNetNuke_1.DMX_DeletePermissionPermission @PermissionId Int, @RoleId Int AS DELETE FROM DotNetNuke_1.DMX_PermissionPermissions WHERE [PermissionId] = @PermissionId AND [RoleId] = @RoleId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetEntriesByUser' in the database. 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() 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 DotNetNuke_1.DMX_GetEntriesByUser @Owner Int, @IncludeDeleted BIT AS SELECT e.* FROM DotNetNuke_1.DMX_Entries e WHERE e.Owner = @Owner AND ((NOT e.Deleted = 1) OR (@IncludeDeleted = 1)) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeleteNotification' in the database. 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() 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 DotNetNuke_1.DMX_DeleteNotification @UserId Int, @LogId Int AS DELETE FROM DotNetNuke_1.DMX_Notifications WHERE [UserId] = @UserId AND [LogId] = @LogId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddEntryAttribute' in the database. 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() 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 DotNetNuke_1.DMX_AddEntryAttribute @EntryId Int, @AttributeId Int, @Value NVarChar (2000) AS INSERT INTO DotNetNuke_1.DMX_EntryAttributes ( [EntryId], [AttributeId], Value ) VALUES ( @EntryId, @AttributeId, @Value ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetEntriesByPortal' in the database. 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() 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 DotNetNuke_1.DMX_GetEntriesByPortal @PortalId Int, @IncludeDeleted BIT, @Locale NVarChar(10) AS SELECT e.*, ISNULL((SELECT [Text] FROM DotNetNuke_1.DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale=@Locale), (SELECT [Text] FROM DotNetNuke_1.DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale='')) Title, ISNULL((SELECT [Text] FROM DotNetNuke_1.DMX_LongTexts WHERE TypeKey='ENT' AND SubTypeKey='REMARKS' AND ObjectId=e.EntryId AND Locale=@Locale), (SELECT [Text] FROM DotNetNuke_1.DMX_LongTexts WHERE TypeKey='ENT' AND SubTypeKey='REMARKS' AND ObjectId=e.EntryId AND Locale='')) Remarks FROM DotNetNuke_1.DMX_Entries e WHERE e.PortalId = @PortalId AND ((NOT e.Deleted = 1) OR (@IncludeDeleted = 1)) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddAttribute' in the database. 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() 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 DotNetNuke_1.DMX_AddAttribute @Addon NVarChar (50), @ControlToLoad NVarChar (255), @EntryTypes NVarChar (255), @IsPrivate Bit, @Name NVarChar (50), @PortalId Int, @Required Bit, @ResourceFile NVarChar (255), @Values NVarChar (2000), @ValueType NVarChar (30), @ViewOrder Int AS INSERT INTO DotNetNuke_1.DMX_Attributes ( [Addon], [ControlToLoad], [EntryTypes], [IsPrivate], [Name], [PortalId], [Required], [ResourceFile], [Values], [ValueType], [ViewOrder] ) VALUES ( @Addon, @ControlToLoad, @EntryTypes, @IsPrivate, @Name, @PortalId, @Required, @ResourceFile, @Values, @ValueType, @ViewOrder ) select SCOPE_IDENTITY() System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetEntryAttribute' in the database. 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() 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 DotNetNuke_1.DMX_GetEntryAttribute @EntryId Int, @AttributeId Int AS SELECT ea.[EntryId], ea.[Value], a.* FROM DotNetNuke_1.DMX_EntryAttributes ea INNER JOIN DotNetNuke_1.DMX_Attributes a ON ea.AttributeId=a.AttributeId WHERE ea.[EntryId] = @EntryId AND ea.[AttributeId] = @AttributeId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetAttributesByAddon' in the database. 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() 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 DotNetNuke_1.DMX_GetAttributesByAddon @Addon NVarChar (50) AS SELECT * FROM DotNetNuke_1.DMX_Attributes a WHERE a.Addon = @Addon System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetApprovedEntry' in the database. 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() 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 DotNetNuke_1.DMX_GetApprovedEntry @LastVersionId Int, @PortalId int, @Locale NVarChar(10) AS SELECT e.*, ISNULL((SELECT [Text] FROM DotNetNuke_1.DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale=@Locale), (SELECT [Text] FROM DotNetNuke_1.DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale='')) Title, ISNULL((SELECT [Text] FROM DotNetNuke_1.DMX_LongTexts WHERE TypeKey='ENT' AND SubTypeKey='REMARKS' AND ObjectId=e.EntryId AND Locale=@Locale), (SELECT [Text] FROM DotNetNuke_1.DMX_LongTexts WHERE TypeKey='ENT' AND SubTypeKey='REMARKS' AND ObjectId=e.EntryId AND Locale='')) Remarks FROM DotNetNuke_1.DMX_Entries e WHERE [LastVersionId] = @LastVersionId AND e.Version=(SELECT MAX(Version) FROM DotNetNuke_1.DMX_Entries WHERE LastVersionId=e.LastVersionId AND IsApproved=1) AND [PortalId] = @PortalId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetAttribute' in the database. 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() 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 DotNetNuke_1.DMX_GetAttribute @AttributeId Int, @PortalId int AS SELECT * FROM DotNetNuke_1.DMX_Attributes WHERE [AttributeId] = @AttributeId AND [PortalId] = @PortalId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeletePermission' in the database. 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() 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 DotNetNuke_1.DMX_DeletePermission @PermissionId Int AS DELETE FROM DotNetNuke_1.DMX_Permissions WHERE [PermissionId] = @PermissionId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetEntryAttributesByEntry' in the database. 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() 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 DotNetNuke_1.DMX_GetEntryAttributesByEntry @EntryId Int AS SELECT ea.[EntryId], ea.[Value], a.* FROM DotNetNuke_1.DMX_EntryAttributes ea INNER JOIN DotNetNuke_1.DMX_Attributes a ON ea.AttributeId=a.AttributeId WHERE ea.EntryId = @EntryId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_IsEntryPermissionByAdmin' in the database. 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() 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 DotNetNuke_1.DMX_IsEntryPermissionByAdmin @PortalId Int, @EntryId Int AS IF EXISTS(SELECT PermissionsOnlyByAdmin FROM DotNetNuke_1.DMX_Entries WHERE EntryId=@EntryId AND PermissionsOnlyByAdmin=1) SELECT 1 ELSE DECLARE @Path VARCHAR(2000) SELECT @Path = ';'+(SELECT Path FROM DotNetNuke_1.DMX_Entries WHERE EntryId=@EntryId)+';' IF EXISTS(SELECT PermissionsOnlyByAdmin FROM DotNetNuke_1.DMX_Entries WHERE PermissionsOnlyByAdmin=1 AND @Path LIKE '%;'+CAST(EntryId AS VARCHAR(10))+';%') SELECT 1 ELSE SELECT 0 System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeleteLog' in the database. 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() 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 DotNetNuke_1.DMX_DeleteLog @id Int AS DELETE FROM DotNetNuke_1.DMX_Log WHERE [id] = @id System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetExtension' in the database. 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() 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 DotNetNuke_1.DMX_GetExtension @PortalId Int, @ExtensionKey NVarChar (50) AS SELECT * FROM DotNetNuke_1.DMX_Extensions WHERE [PortalId] = @PortalId AND [ExtensionKey] = @ExtensionKey System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeleteEntryAttributesByEntry' in the database. 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() 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 DotNetNuke_1.DMX_DeleteEntryAttributesByEntry @EntryId Int AS DELETE FROM DotNetNuke_1.DMX_EntryAttributes WHERE EntryID=@EntryID System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddAddon' in the database. 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() 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 DotNetNuke_1.DMX_AddAddon @AddonKey NVarChar (50), @Availability NVarChar (255), @Controller NVarChar (255), @Description NVarChar (255), @Features Int, @Installed DateTime, @Name NVarChar (50) AS INSERT INTO DotNetNuke_1.DMX_Addons ( [AddonKey], [Availability], [Controller], [Description], [Features], [Installed], [Name] ) VALUES ( @AddonKey, @Availability, @Controller, @Description, @Features, @Installed, @Name ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetLongText' in the database. 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() 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 DotNetNuke_1.DMX_GetLongText @TypeKey NVarChar (3), @SubTypeKey NVarChar (20), @ObjectId Int, @Locale NVarChar (6) AS SELECT * FROM DotNetNuke_1.DMX_LongTexts WHERE [TypeKey] = @TypeKey AND [SubTypeKey] = @SubTypeKey AND [ObjectId] = @ObjectId AND [Locale] = @Locale System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetEntryAttributesByAttribute' in the database. 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() 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 DotNetNuke_1.DMX_GetEntryAttributesByAttribute @AttributeId Int AS SELECT ea.[EntryId], ea.[Value], a.* FROM DotNetNuke_1.DMX_EntryAttributes ea INNER JOIN DotNetNuke_1.DMX_Attributes a ON ea.AttributeId=a.AttributeId WHERE ea.AttributeId = @AttributeId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddEntryCategory' in the database. 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() 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 DotNetNuke_1.DMX_AddEntryCategory @EntryId Int, @CategoryId Int AS INSERT INTO DotNetNuke_1.DMX_EntryCategories ( [EntryId], [CategoryId] ) VALUES ( @EntryId, @CategoryId ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetEntryCategoriesByCategory' in the database. 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() 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 DotNetNuke_1.DMX_GetEntryCategoriesByCategory @CategoryId Int AS SELECT * FROM DotNetNuke_1.DMX_EntryCategories WHERE CategoryId = @CategoryId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeleteCategory' in the database. 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() 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 DotNetNuke_1.DMX_DeleteCategory @id Int AS DELETE FROM DotNetNuke_1.DMX_Categories WHERE [id] = @id System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_RenameEntry' in the database. 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() 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 DotNetNuke_1.DMX_RenameEntry @PortalId Int, @EntryId Int, @Locale NVarChar(10), @NewName nvarchar(255) AS IF EXISTS(SELECT EntryId FROM DotNetNuke_1.DMX_Entries WHERE EntryId=@EntryId AND PortalId=@PortalId) BEGIN DELETE FROM DotNetNuke_1.DMX_ShortTexts WHERE ObjectId=@EntryId AND TypeKey='ENT' AND SubTypeKey='TITLE' AND Locale=@Locale INSERT INTO DotNetNuke_1.DMX_ShortTexts (ObjectId, TypeKey, SubTypeKey, Locale, Text) VALUES (@EntryId, 'ENT', 'TITLE', @Locale, @NewName) END System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetPermissionEntrytypesByPermission' in the database. 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() 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 DotNetNuke_1.DMX_GetPermissionEntrytypesByPermission @PermissionId Int AS SELECT * FROM DotNetNuke_1.DMX_PermissionEntrytypes WHERE PermissionId = @PermissionId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetLogType' in the database. 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() 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 DotNetNuke_1.DMX_GetLogType @PortalId Int, @LogTypeKey NVarChar (20) AS SELECT lt.* FROM DotNetNuke_1.DMX_LogTypes lt WHERE [PortalId] = @PortalId AND [LogTypeKey] = @LogTypeKey System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UpdateShortText' in the database. 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() 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 DotNetNuke_1.DMX_UpdateShortText @TypeKey NVarChar (3), @SubTypeKey NVarChar (20), @ObjectId Int, @Locale NVarChar (6), @Text NVarChar (255) AS UPDATE DotNetNuke_1.DMX_ShortTexts SET [Text] = @Text WHERE [TypeKey] = @TypeKey AND [SubTypeKey] = @SubTypeKey AND [ObjectId] = @ObjectId AND [Locale] = @Locale System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetPermissionsByPortal' in the database. 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() 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 DotNetNuke_1.DMX_GetPermissionsByPortal @PortalId Int AS SELECT * FROM DotNetNuke_1.DMX_Permissions WHERE PortalId = @PortalId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'vw_DMX_ActiveUserRoles' in the database. 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() 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 DotNetNuke_1.vw_DMX_ActiveUserRoles AS SELECT ur.* FROM DotNetNuke_1.UserRoles ur WHERE ISNULL(ur.EffectiveDate, DATEADD(day, -1, GETDATE())) < GETDATE() AND ISNULL(ur.ExpiryDate, DATEADD(day, 1, GETDATE())) > GETDATE() System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_FindEntry' in the database. 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() 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 DotNetNuke_1.DMX_FindEntry @PortalId Int, @SearchText nvarchar(255), @Locale nvarchar(10) AS SELECT e.*, ISNULL((SELECT [Text] FROM DotNetNuke_1.DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale=@Locale), (SELECT [Text] FROM DotNetNuke_1.DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale='')) Title, ISNULL((SELECT [Text] FROM DotNetNuke_1.DMX_LongTexts WHERE TypeKey='ENT' AND SubTypeKey='REMARKS' AND ObjectId=e.EntryId AND Locale=@Locale), (SELECT [Text] FROM DotNetNuke_1.DMX_LongTexts WHERE TypeKey='ENT' AND SubTypeKey='REMARKS' AND ObjectId=e.EntryId AND Locale='')) Remarks FROM DotNetNuke_1.DMX_Entries e WHERE PortalId=@PortalId AND (OriginalFilename LIKE '%'+@SearchText+'%' OR Keywords LIKE '%'+@SearchText+'%' OR EXISTS (SELECT * FROM DotNetNuke_1.DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=e.EntryId AND Locale=@Locale AND Text LIKE '%'+@SearchText+'%')) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeleteSubscription' in the database. 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() 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 DotNetNuke_1.DMX_DeleteSubscription @UserId Int, @EntryId Int AS DELETE FROM DotNetNuke_1.DMX_Subscriptions WHERE [UserId] = @UserId AND [EntryId] = @EntryId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeleteAddon' in the database. 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() 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 DotNetNuke_1.DMX_DeleteAddon @AddonKey NVarChar (50) AS DELETE FROM DotNetNuke_1.DMX_Addons WHERE [AddonKey] = @AddonKey System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeletePermissionEntrytype' in the database. 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() 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 DotNetNuke_1.DMX_DeletePermissionEntrytype @PermissionId Int, @EntryType NVarChar (100) AS DELETE FROM DotNetNuke_1.DMX_PermissionEntrytypes WHERE [PermissionId] = @PermissionId AND [EntryType] = @EntryType System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeleteLongText' in the database. 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() 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 DotNetNuke_1.DMX_DeleteLongText @TypeKey NVarChar (3), @SubTypeKey NVarChar (20), @ObjectId Int, @Locale NVarChar (6) AS DELETE FROM DotNetNuke_1.DMX_LongTexts WHERE [TypeKey] = @TypeKey AND [SubTypeKey] = @SubTypeKey AND [ObjectId] = @ObjectId AND [Locale] = @Locale System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetCategory' in the database. 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() 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 DotNetNuke_1.DMX_GetCategory @id Int, @PortalId Int, @Locale NVarChar(10) AS SELECT c.*, ISNULL((SELECT [Text] FROM DotNetNuke_1.DMX_ShortTexts WHERE TypeKey='CAT' AND SubTypeKey='NAME' AND ObjectId=c.id AND Locale=@Locale), (SELECT [Text] FROM DotNetNuke_1.DMX_ShortTexts WHERE TypeKey='CAT' AND SubTypeKey='NAME' AND ObjectId=c.id AND Locale='')) Name FROM DotNetNuke_1.DMX_Categories c WHERE c.PortalId = @PortalId AND c.id = @id System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetEntryCategoriesByEntry' in the database. 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() 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 DotNetNuke_1.DMX_GetEntryCategoriesByEntry @EntryId Int AS SELECT * FROM DotNetNuke_1.DMX_EntryCategories WHERE EntryId = @EntryId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetPermissionEntrytype' in the database. 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() 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 DotNetNuke_1.DMX_GetPermissionEntrytype @PermissionId Int, @EntryType NVarChar (100) AS SELECT * FROM DotNetNuke_1.DMX_PermissionEntrytypes WHERE [PermissionId] = @PermissionId AND [EntryType] = @EntryType System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UpdateSubscription' in the database. 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() 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 DotNetNuke_1.DMX_UpdateSubscription @UserId Int, @EntryId Int, @LastAccess DateTime AS UPDATE DotNetNuke_1.DMX_Subscriptions SET [LastAccess] = @LastAccess WHERE [UserId] = @UserId AND [EntryId] = @EntryId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetExtensionsByPortal' in the database. 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() 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 DotNetNuke_1.DMX_GetExtensionsByPortal @PortalId Int AS SELECT * FROM DotNetNuke_1.DMX_Extensions WHERE PortalId = @PortalId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UpdatePermission' in the database. 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() 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 DotNetNuke_1.DMX_UpdatePermission @PermissionId Int, @Addon NVarChar (50), @PermissionKey NVarChar (20), @PortalId Int, @ResourceFile NVarChar (255) AS UPDATE DotNetNuke_1.DMX_Permissions SET [Addon] = @Addon, [PermissionKey] = @PermissionKey, [PortalId] = @PortalId, [ResourceFile] = @ResourceFile WHERE [PermissionId] = @PermissionId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_FindAttributeByName' in the database. 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() 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 DotNetNuke_1.DMX_FindAttributeByName @Name NVarChar (50), @PortalId int AS SELECT * FROM DotNetNuke_1.DMX_Attributes WHERE [Name] = @Name AND [PortalId] = @PortalId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeleteEntryCategory' in the database. 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() 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 DotNetNuke_1.DMX_DeleteEntryCategory @EntryId Int, @CategoryId Int AS DELETE FROM DotNetNuke_1.DMX_EntryCategories WHERE [EntryId] = @EntryId AND [CategoryId] = @CategoryId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UpdatePaths' in the database. 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() 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 DotNetNuke_1.DMX_UpdatePaths @PortalID INT, @EntryId INT = NULL AS BEGIN -- NULLIFY what is 'dirty' IF @EntryId is NULL BEGIN UPDATE DotNetNuke_1.DMX_Entries SET [Path]=NULL WHERE PortalID = @PortalID END ELSE BEGIN DECLARE @OldPath VARCHAR(2000) SELECT @OldPath = (SELECT [Path] FROM DotNetNuke_1.DMX_Entries WHERE EntryId=@EntryId) UPDATE DotNetNuke_1.DMX_Entries SET [Path]=NULL WHERE [Path] LIKE @OldPath + '%' AND PortalID = @PortalID END -- If we have any root items with NULL we set the [Path] for these UPDATE DotNetNuke_1.DMX_Entries SET [Path] = '0;' + Cast(EntryId as NVARCHAR(32)) + ';' WHERE CollectionId=0 And PortalId=@PortalId AND [Path] IS NULL -- As long as we find items that are nullified but whose parents are not NULL, we set the path for them WHILE EXISTS (SELECT 'X' FROM DotNetNuke_1.DMX_Entries WHERE PortalId=@PortalId AND [Path] IS NULL AND EXISTS (SELECT 'X' FROM DotNetNuke_1.DMX_Entries e1 WHERE e1.[Path] IS NOT NULL AND e1.EntryID=DotNetNuke_1.DMX_Entries.CollectionID)) BEGIN UPDATE DotNetNuke_1.DMX_Entries SET [Path] = (SELECT e2.[Path] + CAST(DotNetNuke_1.DMX_Entries.EntryId AS NVARCHAR(32)) + ';' FROM DotNetNuke_1.DMX_Entries e2 WHERE e2.EntryID=DotNetNuke_1.DMX_Entries.CollectionID) WHERE DotNetNuke_1.DMX_Entries.PortalId=@PortalId AND [Path] IS NULL AND EXISTS (SELECT 'X' FROM DotNetNuke_1.DMX_Entries e3 WHERE e3.[Path] IS NOT NULL AND e3.EntryID=DotNetNuke_1.DMX_Entries.CollectionID) END; END System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetEntryCategory' in the database. 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() 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 DotNetNuke_1.DMX_GetEntryCategory @EntryId Int, @CategoryId Int AS SELECT * FROM DotNetNuke_1.DMX_EntryCategories WHERE [EntryId] = @EntryId AND [CategoryId] = @CategoryId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetAddon' in the database. 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() 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 DotNetNuke_1.DMX_GetAddon @AddonKey NVarChar (50) AS SELECT * FROM DotNetNuke_1.DMX_Addons WHERE [AddonKey] = @AddonKey System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UpdateExtension' in the database. 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() 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 DotNetNuke_1.DMX_UpdateExtension @PortalId Int, @ExtensionKey NVarChar (50), @AccessRights NVarChar (255), @Addon NVarChar (50), @ControlToLoad NVarChar (255), @Custom NVarChar (400), @DownloadUrl NVarChar (255), @EntryTypes NVarChar (255), @Icon16 NVarChar (100), @Icon32 NVarChar (100), @IsPrivate Bit, @MimeType NVarChar (50), @NodePattern NVarChar (50), @ResourceFile NVarChar (255), @SettingsControl NVarChar (250), @ViewByDefault Bit AS UPDATE DotNetNuke_1.DMX_Extensions SET [AccessRights] = @AccessRights, [Addon] = @Addon, [ControlToLoad] = @ControlToLoad, [Custom] = @Custom, [DownloadUrl] = @DownloadUrl, [EntryTypes] = @EntryTypes, [Icon16] = @Icon16, [Icon32] = @Icon32, [IsPrivate] = @IsPrivate, [MimeType] = @MimeType, [NodePattern] = @NodePattern, [ResourceFile] = @ResourceFile, [SettingsControl] = @SettingsControl, [ViewByDefault] = @ViewByDefault WHERE [PortalId] = @PortalId AND [ExtensionKey] = @ExtensionKey System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetLogTypes' in the database. 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() 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 DotNetNuke_1.DMX_GetLogTypes @PortalId Int AS SELECT lt.* FROM DotNetNuke_1.DMX_LogTypes lt WHERE [PortalId] = @PortalId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UpdateEntry' in the database. 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() 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 DotNetNuke_1.DMX_UpdateEntry @EntryId Int, @Author NVarChar(500), @CollectionId Int, @Created DateTime, @Deleted Bit, @Entry NVarChar (255), @EntryType NVarChar (150), @FileSize BIGINT, @IsApproved Bit, @Keywords NVarChar (255), @LastModified DateTime, @LastVersionId Int, @LockedBy Int, @LockedUntil DateTime, @LockKey UNIQUEIDENTIFIER, @MD5Hash NVarChar(50), @OriginalFileName NVarChar (255), @Owner Int, @Path NVarChar (255), @PermissionsOnlyByAdmin Bit, @PortalId Int, @State NVarChar (50), @Version Int, @VersionsToKeep Int, @WorkflowId NVarChar (50) AS UPDATE DotNetNuke_1.DMX_Entries SET [Author] = @Author, [CollectionId] = @CollectionId, [Created] = @Created, [Deleted] = @Deleted, [Entry] = @Entry, [EntryType] = @EntryType, [FileSize] = @FileSize, [IsApproved] = @IsApproved, [Keywords] = @Keywords, [LastModified] = @LastModified, [LastVersionId] = @LastVersionId, [LockedBy] = @LockedBy, [LockedUntil] = @LockedUntil, [LockKey] = @LockKey, [MD5Hash] = @MD5Hash, [OriginalFileName] = @OriginalFileName, [Owner] = @Owner, [Path] = @Path, [PermissionsOnlyByAdmin] = @PermissionsOnlyByAdmin, [PortalId] = @PortalId, [State] = @State, [Version] = @Version, [VersionsToKeep] = @VersionsToKeep, [WorkflowId] = @WorkflowId WHERE [EntryId] = @EntryId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddPermissionEntrytype' in the database. 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() 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 DotNetNuke_1.DMX_AddPermissionEntrytype @PermissionId Int, @EntryType NVarChar (100) AS INSERT INTO DotNetNuke_1.DMX_PermissionEntrytypes ( [PermissionId], [EntryType] ) VALUES ( @PermissionId, @EntryType ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetAddonsWithFeature' in the database. 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() 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 DotNetNuke_1.DMX_GetAddonsWithFeature @Feature INT AS SELECT * FROM DotNetNuke_1.DMX_Addons WHERE ISNULL([Features], 0) & @Feature = @Feature System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UpdateCategory' in the database. 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() 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 DotNetNuke_1.DMX_UpdateCategory @id Int, @ParentId Int, @PortalId Int, @ViewOrder Int AS UPDATE DotNetNuke_1.DMX_Categories SET [ParentId] = @ParentId, [PortalId] = @PortalId, [ViewOrder] = @ViewOrder WHERE [id] = @id System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddPermissionPermission' in the database. 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() 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 DotNetNuke_1.DMX_AddPermissionPermission @PermissionId Int, @RoleId Int AS INSERT INTO DotNetNuke_1.DMX_PermissionPermissions ( [PermissionId], [RoleId] ) VALUES ( @PermissionId, @RoleId ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetSubscriptionsByUser' in the database. 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() 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 DotNetNuke_1.DMX_GetSubscriptionsByUser @UserId Int AS SELECT * FROM DotNetNuke_1.DMX_Subscriptions WHERE UserId = @UserId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddExtension' in the database. 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() 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 DotNetNuke_1.DMX_AddExtension @PortalId Int, @ExtensionKey NVarChar (50), @AccessRights NVarChar (255), @Addon NVarChar (50), @ControlToLoad NVarChar (255), @Custom NVarChar (400), @DownloadUrl NVarChar (255), @EntryTypes NVarChar (255), @Icon16 NVarChar (100), @Icon32 NVarChar (100), @IsPrivate Bit, @MimeType NVarChar (50), @NodePattern NVarChar (50), @ResourceFile NVarChar (255), @SettingsControl NVarChar (250), @ViewByDefault Bit AS INSERT INTO DotNetNuke_1.DMX_Extensions ( [PortalId], [ExtensionKey], AccessRights, Addon, ControlToLoad, Custom, DownloadUrl, EntryTypes, Icon16, Icon32, IsPrivate, MimeType, NodePattern, ResourceFile, SettingsControl, ViewByDefault ) VALUES ( @PortalId, @ExtensionKey, @AccessRights, @Addon, @ControlToLoad, @Custom, @DownloadUrl, @EntryTypes, @Icon16, @Icon32, @IsPrivate, @MimeType, @NodePattern, @ResourceFile, @SettingsControl, @ViewByDefault ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetShortTexts' in the database. 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() 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 DotNetNuke_1.DMX_GetShortTexts @TypeKey NVarChar (3), @SubTypeKey NVarChar (20), @ObjectId Int AS SELECT [Locale], [ObjectId], [SubTypeKey], [Text], [TypeKey] FROM DotNetNuke_1.DMX_ShortTexts WHERE [TypeKey] = @TypeKey AND [SubTypeKey] = @SubTypeKey AND [ObjectId] = @ObjectId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddLongText' in the database. 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() 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 DotNetNuke_1.DMX_AddLongText @TypeKey NVarChar (3), @SubTypeKey NVarChar (20), @ObjectId Int, @Locale NVarChar (6), @Text NVarChar(MAX) AS INSERT INTO DotNetNuke_1.DMX_LongTexts ( [TypeKey], [SubTypeKey], [ObjectId], [Locale], Text ) VALUES ( @TypeKey, @SubTypeKey, @ObjectId, @Locale, @Text ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeleteEntryAttribute' in the database. 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() 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 DotNetNuke_1.DMX_DeleteEntryAttribute @EntryId Int, @AttributeId Int AS DELETE FROM DotNetNuke_1.DMX_EntryAttributes WHERE [EntryId] = @EntryId AND [AttributeId] = @AttributeId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetPermission' in the database. 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() 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 DotNetNuke_1.DMX_GetPermission @PermissionId Int, @PortalId int AS SELECT * FROM DotNetNuke_1.DMX_Permissions WHERE [PermissionId] = @PermissionId AND [PortalId] = @PortalId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetNotification' in the database. 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() 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 DotNetNuke_1.DMX_GetNotification @UserId Int, @LogId Int, @PortalId int AS SELECT [LogId], [PortalId], [Sent], [Template], [UserId] FROM DotNetNuke_1.DMX_Notifications WHERE [UserId] = @UserId AND [LogId] = @LogId AND [PortalId] = @PortalId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeleteEntry' in the database. 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() 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 DotNetNuke_1.DMX_DeleteEntry @EntryId Int AS DELETE FROM DotNetNuke_1.DMX_Entries WHERE [EntryId] = @EntryId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddShortText' in the database. 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() 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 DotNetNuke_1.DMX_AddShortText @TypeKey NVarChar (3), @SubTypeKey NVarChar (20), @ObjectId Int, @Locale NVarChar (6), @Text NVarChar (255) AS INSERT INTO DotNetNuke_1.DMX_ShortTexts ( [TypeKey], [SubTypeKey], [ObjectId], [Locale], Text ) VALUES ( @TypeKey, @SubTypeKey, @ObjectId, @Locale, @Text ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetExtensionsByAddon' in the database. 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() 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 DotNetNuke_1.DMX_GetExtensionsByAddon @Addon NVarChar (50) AS SELECT * FROM DotNetNuke_1.DMX_Extensions WHERE Addon = @Addon System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMXDAV_URLEncode' in the database. 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() 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 DotNetNuke_1.DMXDAV_URLEncode(@String VARCHAR(4000)) RETURNS VARCHAR(8000) AS BEGIN DECLARE @URLEncodedString VARCHAR(8000) SELECT @URLEncodedString='' SELECT @URLEncodedString=@URLEncodedString + CASE WHEN theChar LIKE '[A-Za-z0-9()''*-._!/]' THEN theChar ELSE '%' + substring ('0123456789ABCDEF',(ASCII(theChar) / 16)+1,1) + SUBSTRING('0123456789ABCDEF',(ASCII(theChar) % 16)+1,1) END FROM (SELECT [theChar]=SUBSTRING(@string,number,1) FROM DotNetNuke_1.DMXDAV_Numbers WHERE Number <= LEN(@String)) CHARACTERARRAY RETURN @URLEncodedString END System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetShortText' in the database. 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() 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 DotNetNuke_1.DMX_GetShortText @TypeKey NVarChar (3), @SubTypeKey NVarChar (20), @ObjectId Int, @Locale NVarChar (6) AS SELECT * FROM DotNetNuke_1.DMX_ShortTexts WHERE [TypeKey] = @TypeKey AND [SubTypeKey] = @SubTypeKey AND [ObjectId] = @ObjectId AND [Locale] = @Locale System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetUnsentNotifications' in the database. 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() 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 DotNetNuke_1.DMX_GetUnsentNotifications @PortalId int, @UserId Int AS SELECT n.* FROM DotNetNuke_1.DMX_Notifications n WHERE n.[UserId] = @UserId AND n.[PortalId] = @PortalId AND n.[Sent] IS NULL System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddLog' in the database. 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() 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 DotNetNuke_1.DMX_AddLog @Action NVARCHAR (20), @Datime DateTime, @EntId Int, @UserId Int AS INSERT INTO DotNetNuke_1.DMX_Log ( [Action], [Datime], [EntId], [UserId] ) VALUES ( @Action, @Datime, @EntId, @UserId ) select SCOPE_IDENTITY() System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeleteExtension' in the database. 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() 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 DotNetNuke_1.DMX_DeleteExtension @PortalId Int, @ExtensionKey NVarChar (50) AS DELETE FROM DotNetNuke_1.DMX_Extensions WHERE [PortalId] = @PortalId AND [ExtensionKey] = @ExtensionKey System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_AddLogType' in the database. 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() 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 DotNetNuke_1.DMX_AddLogType @PortalId Int, @LogTypeKey NVarChar (20), @AttachFile Bit, @CustomSend Bit, @NotifyApprovers NVarChar (100), @NotifyAudit BIT, @NotifyEditors NVarChar (100), @NotifyOwner NVarChar (100), @NotifySelf NVarChar (100), @NotifySubscribers NVarChar (100), @ResourceFile NVarChar (150) AS INSERT INTO DotNetNuke_1.DMX_LogTypes ( [PortalId], [LogTypeKey], AttachFile, CustomSend, NotifyApprovers, NotifyAudit, NotifyEditors, NotifyOwner, NotifySelf, NotifySubscribers, ResourceFile ) VALUES ( @PortalId, @LogTypeKey, @AttachFile, @CustomSend, @NotifyApprovers, @NotifyAudit, @NotifyEditors, @NotifyOwner, @NotifySelf, @NotifySubscribers, @ResourceFile ) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetPermissionPermissionsByRole' in the database. 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() 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 DotNetNuke_1.DMX_GetPermissionPermissionsByRole @RoleId Int AS SELECT * FROM DotNetNuke_1.DMX_PermissionPermissions WHERE RoleId = @RoleId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeleteShortText' in the database. 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() 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 DotNetNuke_1.DMX_DeleteShortText @TypeKey NVarChar (3), @SubTypeKey NVarChar (20), @ObjectId Int, @Locale NVarChar (6) AS DELETE FROM DotNetNuke_1.DMX_ShortTexts WHERE [TypeKey] = @TypeKey AND [SubTypeKey] = @SubTypeKey AND [ObjectId] = @ObjectId AND [Locale] = @Locale System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_DeleteEntryPermission' in the database. 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() 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 DotNetNuke_1.DMX_DeleteEntryPermission @EntryId Int, @PermissionId Int, @RoleId Int, @UserId Int AS DELETE FROM DotNetNuke_1.DMX_EntryPermissions WHERE [EntryId] = @EntryId AND [PermissionId] = @PermissionId AND [RoleId] = @RoleId AND [UserId] = @UserId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMXDAV_GetExtension' in the database. 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() 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 DotNetNuke_1.DMXDAV_GetExtension (@Filename NVARCHAR(200)) RETURNS NVARCHAR(10) AS BEGIN IF @Filename IS NOT NULL IF @Filename<>'' DECLARE @POS INT SELECT @POS = LEN(@Filename)-1 DECLARE @CHR NVARCHAR(1) SELECT @CHR = SUBSTRING(@Filename,@POS,1) WHILE @CHR<>'.' AND @POS>1 BEGIN SELECT @POS = @POS-1 SELECT @CHR = SUBSTRING(@Filename,@POS,1) END IF @POS > 1 RETURN SUBSTRING(@Filename,@POS,LEN(@Filename)-@POS+1) RETURN '' END System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UpdateAddon' in the database. 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() 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 DotNetNuke_1.DMX_UpdateAddon @AddonKey NVarChar (50), @Availability NVarChar (255), @Controller NVarChar (255), @Description NVarChar (255), @Features Int, @Installed DateTime, @Name NVarChar (50) AS UPDATE DotNetNuke_1.DMX_Addons SET [Availability] = @Availability, [Controller] = @Controller, [Description] = @Description, [Features] = @Features, [Installed] = @Installed, [Name] = @Name WHERE [AddonKey] = @AddonKey System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetUserPermissions' in the database. 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() 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 DotNetNuke_1.DMX_GetUserPermissions @EntryId Int, @PortalId Int, @UserId Int AS SELECT DISTINCT p.PermissionKey FROM DotNetNuke_1.DMX_EntryPermissions ep INNER JOIN DotNetNuke_1.DMX_Permissions p ON ep.PermissionId=p.PermissionId LEFT JOIN DotNetNuke_1.vw_DMX_ActiveUserRoles ur ON ep.RoleId=ur.RoleID LEFT JOIN DotNetNuke_1.Users u ON u.UserId=@UserId WHERE ep.EntryId=@EntryId AND ep.PortalId=@PortalId AND p.PortalId=@PortalId AND (ep.RoleID=-1 OR ur.UserId=@UserId OR ep.UserId=@UserId OR u.IsSuperUser=1) System.Data.SqlClient.SqlException (0x80131904): An insufficient number of arguments were supplied for the procedure or function DotNetNuke_1.DMXDAV_GetPath. 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() 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 DotNetNuke_1.DMXDAV_GetPath (@EntryId INT, @PortalId INT) RETURNS NVARCHAR(4000) AS BEGIN DECLARE @res NVARCHAR(4000) IF EXISTS (SELECT EntryId FROM DotNetNuke_1.DMX_Entries WHERE EntryId=@EntryId AND PortalId=@PortalId) BEGIN DECLARE @collection INT SELECT @collection = CollectionId FROM DotNetNuke_1.DMX_Entries WHERE EntryId=@EntryId AND PortalId=@PortalId DECLARE @name NVARCHAR(2000) SELECT @name = [Text] FROM DotNetNuke_1.DMX_ShortTexts WHERE TypeKey='ENT' AND SubTypeKey='TITLE' AND ObjectId=@EntryId AND Locale='' DECLARE @orig NVARCHAR(300) SELECT @orig = OriginalFilename FROM DotNetNuke_1.DMX_Entries WHERE EntryId=@EntryId AND PortalId=@PortalId AND LEFT(EntryType,4)='File' SELECT @res = DotNetNuke_1.DMXDAV_GetPath(@collection, @PortalId)+'/'+@name+DotNetNuke_1.DMXDAV_GetExtension(@orig) END ELSE SELECT @res = '' RETURN @res END System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetLogsByPortal' in the database. 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() 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 DotNetNuke_1.DMX_GetLogsByPortal @PortalId Int AS SELECT l.*, lt.*, u.* FROM DotNetNuke_1.DMX_Log l INNER JOIN DotNetNuke_1.DMX_Entries e ON l.EntId=e.EntryId INNER JOIN DotNetNuke_1.DMX_LogTypes lt ON l.Action=lt.LogTypeKey AND lt.PortalId=e.PortalId INNER JOIN DotNetNuke_1.Users u ON u.UserId=l.UserId WHERE e.PortalId = @PortalId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetEntryPermissionsByEntry' in the database. 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() 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 DotNetNuke_1.DMX_GetEntryPermissionsByEntry @EntryId Int AS SELECT ep.*, p.[Addon], p.[PermissionKey], p.[ResourceFile], r.[RoleName], u.[UserName], u.[DisplayName] FROM DotNetNuke_1.DMX_EntryPermissions ep INNER JOIN DotNetNuke_1.DMX_Permissions p ON ep.PermissionId = p.PermissionId LEFT JOIN DotNetNuke_1.Roles r ON ep.RoleId = r.RoleId LEFT JOIN DotNetNuke_1.Users u ON ep.UserId = u.UserId WHERE ep.EntryId = @EntryId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetLogsByUser' in the database. 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() 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 DotNetNuke_1.DMX_GetLogsByUser @UserId Int AS SELECT l.*, lt.*, u.* FROM DotNetNuke_1.DMX_Log l INNER JOIN DotNetNuke_1.DMX_Entries e ON l.EntId=e.EntryId INNER JOIN DotNetNuke_1.DMX_LogTypes lt ON l.Action=lt.LogTypeKey AND lt.PortalId=e.PortalId INNER JOIN DotNetNuke_1.Users u ON u.UserId=l.UserId WHERE l.UserId = @UserId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_RemoveDeadPermissions' in the database. 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() 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 DotNetNuke_1.DMX_RemoveDeadPermissions AS DELETE FROM DotNetNuke_1.DMX_EntryPermissions WHERE (NOT EXISTS(SELECT * FROM DotNetNuke_1.Roles r WHERE r.RoleId=DotNetNuke_1.DMX_EntryPermissions.RoleId) AND RoleId>-1 AND UserId=-10) OR (NOT EXISTS(SELECT * FROM DotNetNuke_1.Users s WHERE s.UserId=DotNetNuke_1.DMX_EntryPermissions.UserId) AND UserId>-1 AND RoleId=-1) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetCategoriesByPortal' in the database. 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() 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 DotNetNuke_1.DMX_GetCategoriesByPortal @PortalId Int, @Locale NVarChar(10) AS SELECT c.*, ISNULL((SELECT [Text] FROM DotNetNuke_1.DMX_ShortTexts WHERE TypeKey='CAT' AND SubTypeKey='NAME' AND ObjectId=c.id AND Locale=@Locale), (SELECT [Text] FROM DotNetNuke_1.DMX_ShortTexts WHERE TypeKey='CAT' AND SubTypeKey='NAME' AND ObjectId=c.id AND Locale='')) Name FROM DotNetNuke_1.DMX_Categories c WHERE c.PortalId = @PortalId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetLog' in the database. 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() 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 DotNetNuke_1.DMX_GetLog @id Int AS SELECT l.*, lt.*, u.* FROM DotNetNuke_1.DMX_Log l INNER JOIN DotNetNuke_1.DMX_Entries e ON l.EntId=e.EntryId INNER JOIN DotNetNuke_1.DMX_LogTypes lt ON l.Action=lt.LogTypeKey AND lt.PortalId=e.PortalId INNER JOIN DotNetNuke_1.Users u ON u.UserId=l.UserId WHERE l.[id] = @id System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetPermissionPermissionsByPermission' in the database. 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() 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 DotNetNuke_1.DMX_GetPermissionPermissionsByPermission @PermissionId Int AS SELECT pp.*, r.Description AS RolesDescription FROM DotNetNuke_1.Roles r INNER JOIN DotNetNuke_1.DMX_PermissionPermissions pp ON r.RoleID = pp.RoleId WHERE pp.PermissionId = @PermissionId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetLogByTime' in the database. 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() 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 DotNetNuke_1.DMX_GetLogByTime @PortalId Int, @StartTime DATETIME, @EndTime DATETIME AS SELECT l.*, lt.*, u.* FROM DotNetNuke_1.DMX_Log l INNER JOIN DotNetNuke_1.DMX_Entries e ON l.EntId=e.EntryId INNER JOIN DotNetNuke_1.DMX_LogTypes lt ON l.Action=lt.LogTypeKey AND lt.PortalId=e.PortalId INNER JOIN DotNetNuke_1.Users u ON u.UserId=l.UserId WHERE e.PortalId = @PortalId AND l.Datime >= @StartTime AND l.Datime < @EndTime System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UnifyPermissions' in the database. 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() 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 DotNetNuke_1.DMX_UnifyPermissions @PortalId Int, @EntryId Int, @UserId INT AS DECLARE @BasePath VARCHAR(2000) SELECT @BasePath = (SELECT [Path] FROM DotNetNuke_1.DMX_Entries WHERE EntryId=@EntryId) IF EXISTS (select [name] from tempdb..sysobjects where [name] LIKE '#ToChange%') DROP TABLE #ToChange; CREATE TABLE #ToChange (EntryId INT, [Path] VARCHAR(2000), EntryType nvarchar(150)); INSERT INTO #ToChange (EntryId, [Path], EntryType) SELECT e.EntryId, e.[Path], e.EntryType FROM DotNetNuke_1.DMX_Entries e INNER JOIN (SELECT DISTINCT ep.EntryId FROM DotNetNuke_1.DMX_EntryPermissions ep INNER JOIN DotNetNuke_1.DMX_Permissions pt ON pt.PermissionId=ep.PermissionId LEFT JOIN DotNetNuke_1.vw_DMX_ActiveUserRoles r ON r.RoleId=ep.RoleId WHERE pt.PermissionKey='EDIT' AND (ep.UserId=@UserId OR r.UserId=@UserId OR ep.RoleId=-1)) perm ON perm.EntryId=e.EntryId WHERE PortalId=@PortalId AND [Path] LIKE @BasePath+'_%'; IF EXISTS (select [name] from tempdb..sysobjects where [name] LIKE '#NewPerms%') DROP TABLE #NewPerms; CREATE TABLE #NewPerms ( [AllowAccess] [bit] NULL, [EntryId] [int] NOT NULL, [Expires] [datetime] NULL, [PermissionId] [int] NOT NULL, [PortalId] [int] NOT NULL, [RoleId] [int] NOT NULL, [UserId] [int] NOT NULL, [EntryType] nvarchar(150)) INSERT INTO #NewPerms (AllowAccess, EntryId, Expires, PermissionId, PortalId, RoleId, UserId, EntryType) SELECT ep.AllowAccess, ep.EntryId, ep.Expires, ep.PermissionId, ep.PortalId, ep.RoleId, ep.UserId, pet.EntryType FROM DotNetNuke_1.DMX_EntryPermissions ep INNER JOIN DotNetNuke_1.DMX_PermissionEntryTypes pet ON pet.PermissionId=ep.PermissionId WHERE ep.EntryId=@EntryId DELETE FROM DotNetNuke_1.DMX_EntryPermissions WHERE EntryId IN (SELECT EntryId FROM #ToChange); INSERT INTO DotNetNuke_1.DMX_EntryPermissions (AllowAccess, EntryId, Expires, PermissionId, PortalId, RoleId, UserId) SELECT ep.AllowAccess, tc.EntryId, ep.Expires, ep.PermissionId, ep.PortalId, ep.RoleId, ep.UserId FROM #NewPerms ep INNER JOIN #ToChange tc ON tc.EntryType LIKE ep.EntryType+'%'; DROP TABLE #NewPerms; DROP TABLE #ToChange; System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetLogsByEntry' in the database. 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() 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 DotNetNuke_1.DMX_GetLogsByEntry @EntId Int AS SELECT l.*, u.DisplayName FROM DotNetNuke_1.Users u INNER JOIN DotNetNuke_1.DMX_Log l ON u.UserID = l.UserId WHERE l.EntId = @EntId ORDER BY l.Datime DESC System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_ResetPermissions' in the database. 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() 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 DotNetNuke_1.DMX_ResetPermissions @PortalId Int, @EntryId Int AS DECLARE @AdminRoleId INT SELECT @AdminRoleId = (SELECT AdministratorRoleId FROM DotNetNuke_1.Portals WHERE PortalId=@PortalId); DECLARE @BasePath VARCHAR(2000) SELECT @BasePath = (SELECT [Path] FROM DotNetNuke_1.DMX_Entries WHERE EntryId=@EntryId); DELETE DotNetNuke_1.DMX_EntryPermissions FROM DotNetNuke_1.DMX_EntryPermissions ep INNER JOIN DotNetNuke_1.DMX_Entries e ON e.EntryId=ep.EntryId WHERE e.PortalId=@PortalId AND e.[Path] LIKE @BasePath+'%'; INSERT INTO DotNetNuke_1.DMX_EntryPermissions (AllowAccess, EntryId, Expires, PermissionId, PortalId, RoleId, UserId) SELECT 1, e.EntryId, NULL, p.PermissionId, 0, @AdminRoleId, -10 FROM DotNetNuke_1.DMX_Entries e, DotNetNuke_1.DMX_Permissions p WHERE e.PortalId=@PortalId AND e.[Path] LIKE @BasePath+'%' AND (NOT e.EntryType LIKE 'Collection%') AND (p.PermissionKey = 'EDIT' OR p.PermissionKey = 'VIEW'); INSERT INTO DotNetNuke_1.DMX_EntryPermissions (AllowAccess, EntryId, Expires, PermissionId, PortalId, RoleId, UserId) SELECT 1, e.EntryId, NULL, p.PermissionId, 0, @AdminRoleId, -10 FROM DotNetNuke_1.DMX_Entries e, DotNetNuke_1.DMX_Permissions p WHERE e.PortalId=@PortalId AND e.[Path] LIKE @BasePath+'%' AND e.EntryType LIKE 'Collection%' AND (p.PermissionKey = 'EDIT' OR p.PermissionKey = 'VIEW' OR p.PermissionKey = 'ADD'); System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_UnifyRemovePermission' in the database. 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() 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 DotNetNuke_1.DMX_UnifyRemovePermission @PortalId INT, @UnifyingUserId INT, @CollectionId INT, @PermissionKey NVARCHAR(20) AS BEGIN DECLARE @Id INT SELECT @Id = MIN(e.EntryId) FROM DotNetNuke_1.DMX_Entries e INNER JOIN (SELECT DISTINCT ep.EntryId FROM DotNetNuke_1.DMX_EntryPermissions ep INNER JOIN DotNetNuke_1.DMX_Permissions pt ON pt.PermissionId=ep.PermissionId LEFT JOIN DotNetNuke_1.UserRoles r ON r.RoleId=ep.RoleId WHERE pt.PermissionKey='EDIT' AND (ep.UserId=@UnifyingUserId OR r.UserId=@UnifyingUserId OR ep.RoleId=-1)) perm ON perm.EntryId=e.EntryId WHERE e.CollectionId=@CollectionId DECLARE @PermissionId INT SELECT @PermissionId = PermissionId FROM DotNetNuke_1.DMX_Permissions WHERE PermissionKey=@PermissionKey AND PortalId=@PortalId DECLARE @AdminRoleId INT SELECT @AdminRoleId=AdministratorRoleId FROM DotNetNuke_1.Portals WHERE PortalId=@PortalId WHILE @Id IS NOT NULL BEGIN DELETE FROM DotNetNuke_1.DMX_EntryPermissions FROM DotNetNuke_1.DMX_EntryPermissions ep WHERE ep.EntryId=@Id AND ep.PermissionId=@PermissionId AND NOT (ep.RoleId=@AdminRoleId AND (@PermissionKey='VIEW' OR @PermissionKey='EDIT' OR @PermissionKey='ADD')) AND (@PermissionKey<>'EDIT' OR (SELECT COUNT(*) FROM DotNetNuke_1.UserRoles r WHERE r.UserId=@UnifyingUserId AND r.RoleId=ep.RoleId)=0) AND (@PermissionKey<>'EDIT' OR ep.UserId <> @UnifyingUserId) EXEC DotNetNuke_1.DMX_UnifyRemovePermission @PortalId, @UnifyingUserId, @Id, @PermissionKey SELECT @Id = MIN(e.EntryId) FROM DotNetNuke_1.DMX_Entries e INNER JOIN (SELECT DISTINCT ep.EntryId FROM DotNetNuke_1.DMX_EntryPermissions ep INNER JOIN DotNetNuke_1.DMX_Permissions pt ON pt.PermissionId=ep.PermissionId LEFT JOIN DotNetNuke_1.UserRoles r ON r.RoleId=ep.RoleId WHERE pt.PermissionKey='EDIT' AND (ep.UserId=@UnifyingUserId OR r.UserId=@UnifyingUserId OR ep.RoleId=-1)) perm ON perm.EntryId=e.EntryId WHERE e.CollectionId=@CollectionId AND e.EntryId>@Id END END System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetSubscriptionsByEntry' in the database. 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() 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 DotNetNuke_1.DMX_GetSubscriptionsByEntry @EntryId Int AS SELECT s.*, u.DisplayName FROM DotNetNuke_1.Users u INNER JOIN DotNetNuke_1.DMX_Subscriptions s ON u.UserID = s.UserId WHERE s.EntryId = @EntryId System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_GetUsersToNotify' in the database. 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() 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 DotNetNuke_1.DMX_GetUsersToNotify @PortalId int AS SELECT u.* FROM DotNetNuke_1.Users u WHERE EXISTS (SELECT COUNT(*) FROM DotNetNuke_1.DMX_Notifications n WHERE n.[UserId] = u.UserId AND n.[PortalId] = @PortalId AND n.[Sent] IS NULL) System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'DMX_SetDeleteRecursive' in the database. 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() 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 DotNetNuke_1.DMX_SetDeleteRecursive @PortalId Int, @EntryId Int, @Delete BIT AS DECLARE @Path VARCHAR(2000) SET @Path = (SELECT [Path] FROM DotNetNuke_1.DMX_Entries WHERE EntryId=@EntryId AND PortalId=@PortalId)+'%'; DISABLE TRIGGER DotNetNuke_1.DMX_EntryUpdatePath ON DotNetNuke_1.DMX_Entries; UPDATE DotNetNuke_1.DMX_Entries SET Deleted=@Delete WHERE PortalId=@PortalId AND (LastVersionId=@EntryId OR [Path] LIKE @Path); ENABLE TRIGGER DotNetNuke_1.DMX_EntryUpdatePath ON DotNetNuke_1.DMX_Entries;

You've tried to install it twice. Most likely you had a failed install before. You will manually need to clean the failed install before trying again. This means removing all DMX_ prefixed tables/functions/procedures/views from the database.

Peter

Hi Peter

The interesting thing is that this came up during first attempt to install. Anyway what I have done is removed all DB entries together with all files on the server followed by another attempt to install the module but with the same effect.
I have even tred installing newer version of the module *6.0.2 but again, the same array of errors...

Hi,

If you look at the very first error it says: "There is already an object named 'DMX_UpdateNotification' in the database". So in the database there is already this stored procedure. There is no other module that has this stored procedure. Only DMX has it. So if it was already there, then DMX was already installed.
All the other errors are the very same type of message.

Peter