This is my first test for upgrade:

Informazioni	Inizio istruzione SQL: Install.04.00.00.SqlDataProvider file
Avviso	Nell'istruzione SQL risultano le seguenti eccezioni: System.Data.SqlClient.SqlException: There is already an object named 'Blog_Entries' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE TABLE dbo.[Blog_Entries] ( [BlogID] [int] NOT NULL, [EntryID] [int] NOT NULL IDENTITY(1, 1), [Title] [nvarchar] (255) NOT NULL, [Entry] [ntext] NOT NULL, [AddedDate] [datetime] NOT NULL, [Published] [bit] NOT NULL, [Description] [ntext] NULL, [AllowComments] [bit] NULL, [DisplayCopyright] [bit] NOT NULL, [Copyright] [nvarchar] (255) NULL, [PermaLink] [nvarchar] (1024) NULL ) System.Data.SqlClient.SqlException: Table 'Blog_Entries' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Blog_Entries] ADD CONSTRAINT [PK_Blog_Entries_EntryID] PRIMARY KEY CLUSTERED ([EntryID]) System.Data.SqlClient.SqlException: The operation failed because an index or statistics with name 'IX_Blog_Entries_BlogID' already exists on table 'dbo.Blog_Entries'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE NONCLUSTERED INDEX [IX_Blog_Entries_BlogID] ON dbo.[Blog_Entries] ([BlogID]) System.Data.SqlClient.SqlException: The operation failed because an index or statistics with name 'IX_Blog_Entries_AddedDate' already exists on table 'dbo.Blog_Entries'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE NONCLUSTERED INDEX [IX_Blog_Entries_AddedDate] ON dbo.[Blog_Entries] ([AddedDate]) System.Data.SqlClient.SqlException: There is already an object named 'Blog_Comments' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE TABLE dbo.[Blog_Comments] ( [CommentID] [int] NOT NULL IDENTITY(1, 1), [EntryID] [int] NOT NULL, [UserID] [int] NULL, [Comment] [ntext] NOT NULL, [AddedDate] [datetime] NOT NULL, [Title] [nvarchar] (255) NOT NULL, [Approved] [bit] NULL, [Author] [nvarchar] (50) NULL, [Website] [nvarchar] (255) NULL, [Email] [nvarchar] (255) NULL ) System.Data.SqlClient.SqlException: Table 'Blog_Comments' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Blog_Comments] ADD CONSTRAINT [PK_Blog_Comments_CommentID] PRIMARY KEY CLUSTERED ([CommentID]) System.Data.SqlClient.SqlException: The operation failed because an index or statistics with name 'IX_Blog_Comments_EntryID' already exists on table 'dbo.Blog_Comments'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE NONCLUSTERED INDEX [IX_Blog_Comments_EntryID] ON dbo.[Blog_Comments] ([EntryID]) System.Data.SqlClient.SqlException: There is already an object named 'Blog_Settings' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE TABLE dbo.[Blog_Settings] ( [PortalID] [int] NOT NULL, [Key] [nvarchar] (50) NOT NULL, [Value] [nvarchar] (1024) NOT NULL, [TabID] [int] NOT NULL ) System.Data.SqlClient.SqlException: Table 'Blog_Settings' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Blog_Settings] ADD CONSTRAINT [PK_Blog_Settings] PRIMARY KEY CLUSTERED ([PortalID], [TabID], [Key]) System.Data.SqlClient.SqlException: There is already an object named 'Blog_DeleteComment' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Objekt: Gespeicherte Prozedur dbo.Blog_DeleteComment Skriptdatum: 01.03.2005 17:18:18 ******/ CREATE PROCEDURE dbo.Blog_DeleteComment @CommentID int AS DELETE FROM dbo.Blog_Comments WHERE [CommentID] = @CommentID System.Data.SqlClient.SqlException: There is already an object named 'Blog_GetSettings' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_GetSettings @PortalID int, @TabID int AS SELECT [Key], [Value] From dbo.Blog_Settings WHERE PortalID=@PortalID AND TabID=@TabID System.Data.SqlClient.SqlException: There is already an object named 'Blog_DeleteEntry' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Objekt: Gespeicherte Prozedur dbo.Blog_DeleteEntry Skriptdatum: 01.03.2005 17:18:18 ******/ CREATE PROCEDURE dbo.Blog_DeleteEntry @EntryID int AS DELETE FROM dbo.Blog_Entries WHERE [EntryID] = @EntryID System.Data.SqlClient.SqlException: There is already an object named 'Blog_UpdateComment' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_UpdateComment @CommentID int, @EntryID int, @UserID int, @Title nvarchar(255), @Comment ntext, @Author nvarchar(50), @Approved bit, @Website nvarchar(255), @Email nvarchar(255) AS UPDATE dbo.Blog_Comments SET [EntryID] = @EntryID, [UserID] = @UserID, [Title] = @Title, [Comment] = @Comment, [Author] = @Author, [Approved] = @Approved, [AddedDate] = GetUTCDate(), [Website] = @Website, [Email] = @Email WHERE [CommentID] = @CommentID System.Data.SqlClient.SqlException: There is already an object named 'Blog_UpdateSetting' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_UpdateSetting @PortalID int, @TabID int, @Key nvarchar(50), @Value nvarchar(1024) AS set nocount on If EXISTS (SELECT [Key] FROM dbo.Blog_Settings WHERE PortalID=@PortalID AND TabID=@TabID AND [Key]=@Key) UPDATE dbo.Blog_Settings SET [Value] = @Value WHERE PortalID=@PortalID AND TabID=@TabID AND [Key]=@Key ELSE INSERT INTO dbo.Blog_Settings (PortalID, TabID,[Key], [Value]) VALUES (@PortalID, @TabID,@Key, @Value) System.Data.SqlClient.SqlException: There is already an object named 'Blog_AddComment' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_AddComment @EntryID int, @UserID int, @Title nvarchar(255), @Comment ntext, @Author nvarchar(50), @Approved bit, @Website nvarchar(255), @Email nvarchar(255) AS INSERT INTO dbo.Blog_Comments ( [EntryID], [UserID], [Title], [Comment], [Author], [Approved], [AddedDate], [Website], [Email] ) VALUES ( @EntryID, @UserID, @Title, @Comment, @Author, @Approved, GetUTCDate(), @Website, @Email ) select SCOPE_IDENTITY() System.Data.SqlClient.SqlException: There is already an object named 'Blog_Blogs' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE TABLE dbo.[Blog_Blogs] ( [PortalID] [int] NOT NULL, [BlogID] [int] NOT NULL IDENTITY(1, 1), [UserID] [int] NOT NULL, [Title] [nvarchar] (255) NOT NULL, [Description] [nvarchar] (1024) NULL, [Public] [bit] NOT NULL, [AllowComments] [bit] NOT NULL, [AllowAnonymous] [bit] NOT NULL, [LastEntry] [datetime] NULL, [Created] [datetime] NOT NULL DEFAULT (getutcdate()), [ShowFullName] [bit] NOT NULL, [DateFormat] [nvarchar] (50) NOT NULL, [Culture] [nvarchar] (10) NULL, [TimeZone] [int] NOT NULL, [ParentBlogID] [int] NULL DEFAULT ((-1)), [Syndicated] [bit] NOT NULL, [SyndicateIndependant] [bit] NOT NULL, [SyndicationURL] [nvarchar] (1024) NULL, [SyndicationEmail] [nvarchar] (255) NULL, [EmailNotification] [bit] NULL, [AllowTrackbacks] [bit] NULL, [AutoTrackback] [bit] NULL, [MustApproveComments] [bit] NULL, [MustApproveAnonymous] [bit] NULL, [MustApproveTrackbacks] [bit] NULL, [UseCaptcha] [bit] NULL, [EnableTwitterIntegration] [bit] NULL DEFAULT ((0)), [TwitterUsername] [nvarchar] (256) NULL, [TwitterPassword] [nvarchar] (128) NULL, [TweetTemplate] [nvarchar] (256) NULL ) System.Data.SqlClient.SqlException: Table 'Blog_Blogs' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Blog_Blogs] ADD CONSTRAINT [PK_Blog_Blogs_BlogID] PRIMARY KEY CLUSTERED ([BlogID]) System.Data.SqlClient.SqlException: The operation failed because an index or statistics with name 'IX_Blog_Blogs_PortalID' already exists on table 'dbo.Blog_Blogs'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE NONCLUSTERED INDEX [IX_Blog_Blogs_PortalID] ON dbo.[Blog_Blogs] ([PortalID]) System.Data.SqlClient.SqlException: The operation failed because an index or statistics with name 'IX_Blog_Blogs_UserID' already exists on table 'dbo.Blog_Blogs'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE NONCLUSTERED INDEX [IX_Blog_Blogs_UserID] ON dbo.[Blog_Blogs] ([UserID]) System.Data.SqlClient.SqlException: There is already an object named 'Blog_ListBlogs' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_ListBlogs @PortalID int, @ParentBlogID int, @ShowNonPublic bit AS SELECT B.[PortalID], B.[BlogID], B.[ParentBlogID], B.[UserID], U.[UserName], U.[DisplayName] AS UserFullName, B.[Title], B.[Description], B.[Public], B.[AllowComments], B.[AllowAnonymous], B.[LastEntry], B.[Created], B.[Culture], B.[ShowFullname], B.[DateFormat], IsNull(B.[TimeZone],0) AS TimeZone, B.[Syndicated], IsNull(B.[SyndicateIndependant], 0) As SyndicateIndependant, B.[SyndicationURL], B.[SyndicationEmail], B.[EmailNotification], B.[AllowTrackbacks], B.[AutoTrackback], B.[MustApproveComments], B.[MustApproveAnonymous], B.[MustApproveTrackbacks], B.[UseCaptcha], (SELECT Count(BlogID) FROM dbo.Blog_Blogs WHERE ParentBlogID=B.[BlogID]) AS ChildBlogCount, (SELECT Count(EntryID) FROM dbo.Blog_Entries WHERE BlogID=B.[BlogID]) AS BlogPostCount FROM dbo.Blog_Blogs B INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] WHERE B.[PortalID] = @PortalID AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND (B.[ParentBlogID] = @ParentBlogID) ORDER BY B.Title System.Data.SqlClient.SqlException: There is already an object named 'Blog_GetComment' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_GetComment @CommentID int AS SELECT C.[CommentID], C.[EntryID], C.[UserID], C.[Title], C.[Comment], C.[AddedDate], U.[UserName], U.[DisplayName] AS UserFullName, C.[Author], C.[Approved], C.[Website], C.[Email] FROM dbo.Blog_Comments C LEFT JOIN dbo.Users U ON C.[UserID] = U.[UserID] WHERE C.[CommentID] = @CommentID System.Data.SqlClient.SqlException: There is already an object named 'Blog_ListEntriesByPortalByMonth' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_ListEntriesByPortalByMonth @PortalID int, @BlogDate datetime = null, @ShowNonPublic bit = 0, @ShowNonPublished bit=0, @MaxEntries int = 10 AS If @BlogDate IS NULL SET @BlogDate = GetUTCDate() SET rowcount @MaxEntries SELECT U.[UserID], U.[Username], U.[FirstName] + ' ' + U.[LastName] AS UserFullName, E.[EntryID], E.[BlogID], E.[Title], E.[Description], E.[Entry], E.[AddedDate], E.[Published], E.[Copyright], E.[PermaLink], IsNull(E.[AllowComments],B.[AllowComments]) As AllowComments, B.[ParentBlogID], B.[AllowAnonymous], B.[Syndicated] AS BlogSyndicated, B.[Public] AS BlogPublic, B.[SyndicationEmail] as SyndicationEmail, (Select Count(*) FROM dbo.Blog_Comments WHERE EntryID = E.EntryID AND (Approved = 1 OR Approved <> @ShowNonPublic)) As CommentCount FROM dbo.Blog_Blogs B INNER JOIN dbo.Blog_Entries E ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] WHERE B.PortalID = @PortalID AND E.AddedDate BETWEEN DATEADD(month, DATEDIFF(month, 0, @BlogDate), 0) AND @BlogDate AND E.AddedDate <= GetUTCDate() AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) ORDER BY E.AddedDate DESC System.Data.SqlClient.SqlException: There is already an object named 'Blog_SearchByPhraseByBlog' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_SearchByPhraseByBlog @BlogID int, @SearchString nvarchar(255), @ShowNonPublic bit, @ShowNonPublished bit AS set nocount on -- Build Temp Table to hold results CREATE TABLE #SearchResults (EntryID int) declare @like_text nvarchar(257) select @like_text = '%' + @SearchString + '%' INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE (B.[BlogID] = @BlogID OR B.[ParentBlogID] = @BlogID) AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Title] like @like_text INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE (B.[BlogID] = @BlogID OR B.[ParentBlogID] = @BlogID) AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Description] like @like_text INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE (B.[BlogID] = @BlogID OR B.[ParentBlogID] = @BlogID) AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Entry] like @like_text SELECT S.EntryID, Rank = Count(*) INTO #SearchResultsGrouped FROM #SearchResults S GROUP BY S.EntryID SELECT S.EntryID, E.[BlogID], B.[Title] as BlogTitle, E.[Title] As EntryTitle, IsNull(E.[Description], SubString(E.[Entry], 1, 2500)) As Summary, E.[AddedDate], E.[PermaLink], B.[UserID], U.[Username], U.[DisplayName] AS UserFullName, E.Published, S.Rank FROM #SearchResultsGrouped S INNER JOIN dbo.Blog_Entries E ON S.EntryID = E.EntryID INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] Order by S.Rank DESC, E.AddedDate DESC, E.PermaLink DESC set nocount off System.Data.SqlClient.SqlException: There is already an object named 'Blog_ListBlogsByPortal' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_ListBlogsByPortal @PortalID int, @ShowNonPublic bit AS SELECT B.[PortalID], B.[BlogID], B.[ParentBlogID], B.[UserID], U.[UserName], U.[DisplayName] AS UserFullName, B.[Title], B.[Description], B.[Public], B.[AllowComments], B.[AllowAnonymous], B.[LastEntry], B.[Created], B.[Culture], B.[ShowFullname], B.[DateFormat], IsNull(B.[TimeZone],0) AS TimeZone, B.[Syndicated], IsNull(B.[SyndicateIndependant], 0) As SyndicateIndependant, B.[SyndicationURL], B.[SyndicationEmail], B.[EmailNotification], B.[AllowTrackbacks], B.[AutoTrackback], B.[MustApproveComments], B.[MustApproveAnonymous], B.[MustApproveTrackbacks], B.[UseCaptcha], (SELECT Count(BlogID) FROM dbo.Blog_Blogs WHERE ParentBlogID=B.[BlogID]) AS ChildBlogCount FROM dbo.Blog_Blogs B INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] WHERE B.[PortalID] = @PortalID AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) System.Data.SqlClient.SqlException: There is already an object named 'Blog_AddEntry' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_AddEntry @BlogID int, @Title nvarchar(255), @Description ntext, @Entry ntext, @Published bit, @AllowComments bit, @AddedDate datetime, @DisplayCopyright bit, @Copyright nvarchar(256), @PermaLink nvarchar(1024) AS DECLARE @EntryID int UPDATE dbo.Blog_Blogs SET LastEntry = GetUTCDate() WHERE [BlogID] = @BlogID INSERT INTO dbo.Blog_Entries ( [BlogID], [Title], [Description], [Entry], [AddedDate], [Published], [AllowComments], [DisplayCopyright], [Copyright], [PermaLink] ) VALUES ( @BlogID, @Title, @Description, @Entry, @AddedDate, @Published, @AllowComments, @DisplayCopyright, @Copyright, null ) SET @EntryID = SCOPE_IDENTITY() If NOT @PermaLink IS NULL UPDATE dbo.Blog_Entries SET PermaLink=@PermaLink + convert(nvarchar(10),EntryID) WHERE BlogID=@BlogID AND PermaLink IS NULL SELECT @EntryID System.Data.SqlClient.SqlException: There is already an object named 'Blog_Upgrade_ListEntriesByBlog' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_Upgrade_ListEntriesByBlog @BlogID int, @BlogDate datetime = null, @ShowNonPublic bit = 0, @ShowNonPublished bit=0 AS If @BlogDate IS NULL SET @BlogDate = GetUTCDate() SELECT U.[UserID], U.[Username], U.[DisplayName] AS UserFullName, E.[EntryID], E.[BlogID], E.[Title], E.[Description], E.[Entry], E.[AddedDate], E.[Published], E.[Copyright], E.[PermaLink], IsNull(E.[AllowComments],B.[AllowComments]) As AllowComments, (Select Count(*) FROM dbo.NewBlog_Comments WHERE EntryID = E.EntryID) As CommentCount, B.[PortalID] As BlogPortalID, B.[ParentBlogID], B.[Title] As BlogTitle, B.[Description] As BlogDescription, B.[Public] As BlogPublic, B.[AllowComments] As BlogAllowComments, B.[AllowAnonymous] As BlogAllowAnonymous, B.[LastEntry] As BlogLastEntry, B.[Created] As BlogCreated, B.[Culture] As BlogCulture, B.[ShowFullname] As BlogShowFullName, B.[DateFormat] As BlogDateFormat, B.[TimeZone] As BlogTimeZone, B.[Syndicated] As BlogSyndicated, B.[SyndicateIndependant] As BlogSyndicateIndependant FROM dbo.NewBlog_Blogs B INNER JOIN dbo.NewBlog_Entries E ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] WHERE (B.[BlogID] = @BlogID) ORDER BY E.AddedDate DESC System.Data.SqlClient.SqlException: There is already an object named 'Blog_Upgrade_UpdateModuleDefId' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.Blog_Upgrade_UpdateModuleDefId @ModuleDefId int, @ModuleId int as update dbo.Modules set ModuleDefId = @ModuleDefId where ModuleId = @ModuleId System.Data.SqlClient.SqlException: There is already an object named 'Blog_SearchByPhraseByPortal' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_SearchByPhraseByPortal @PortalID int, @SearchString nvarchar(255), @ShowNonPublic bit, @ShowNonPublished bit AS set nocount on -- Build Temp Table to hold results CREATE TABLE #SearchResults (EntryID int) declare @like_text nvarchar(257) select @like_text = '%' + @SearchString + '%' INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Title] like @like_text INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Description] like @like_text INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Entry] like @like_text SELECT S.EntryID, Rank = Count(*) INTO #SearchResultsGrouped FROM #SearchResults S GROUP BY S.EntryID SELECT S.EntryID, E.[BlogID], B.[Title] as BlogTitle, E.[Title] As EntryTitle, IsNull(E.[Description], SubString(E.[Entry], 1, 2500)) As Summary, E.[AddedDate], E.[PermaLink], B.[UserID], U.[Username], U.[DisplayName] AS UserFullName, E.Published, S.Rank FROM #SearchResultsGrouped S INNER JOIN dbo.Blog_Entries E ON S.EntryID = E.EntryID INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] Order by S.Rank DESC, E.AddedDate DESC, E.PermaLink DESC set nocount off System.Data.SqlClient.SqlException: There is already an object named 'Blog_SearchBlogByPhrase' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_SearchBlogByPhrase @PortalID int, @BlogID int, @SearchString nvarchar(255), @ShowNonPublic bit, @ShowNonPublished bit AS set nocount on -- Build Temp Table to hold results CREATE TABLE #SearchResults (EntryID int) declare @like_text nvarchar(257) select @like_text = '%' + @SearchString + '%' IF @BlogID > -1 BEGIN INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND B.[BlogID] = @BlogID AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Title] like @like_text INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND B.[BlogID] = @BlogID AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Description] like @like_text INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND B.[BlogID] = @BlogID AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Entry] like @like_text END ELSE BEGIN INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Title] like @like_text INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Description] like @like_text INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Entry] like @like_text END SELECT S.EntryID, Rank = Count(*) INTO #SearchResultsGrouped FROM #SearchResults S GROUP BY S.EntryID SELECT S.EntryID, E.[BlogID], B.[Title] as BlogTitle, E.[Title] As EntryTitle, IsNull(E.[Description], SubString(E.[Entry], 1, 2500)) As Summary, E.[AddedDate], E.[PermaLink], B.[UserID], U.[Username], U.[DisplayName] AS UserFullName, E.Published, S.Rank FROM #SearchResultsGrouped S INNER JOIN dbo.Blog_Entries E ON S.EntryID = E.EntryID INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] Order by S.Rank DESC, E.AddedDate DESC, E.PermaLink DESC set nocount off System.Data.SqlClient.SqlException: There is already an object named 'Blog_UpdateEntry' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_UpdateEntry @BlogID int, @EntryID int, @Title nvarchar(255), @Description ntext, @Entry ntext, @Published bit, @AllowComments bit, @AddedDate datetime, @DisplayCopyright bit, @Copyright nvarchar(256), @PermaLink nvarchar(1024) AS UPDATE dbo.Blog_Entries SET [BlogID] = @BlogID, [Title] = @Title, [Description] = @Description, [Entry] = @Entry, [Published] = @Published, [AllowComments] = @AllowComments, [AddedDate] = @AddedDate, [DisplayCopyright] = @DisplayCopyright, [Copyright] = @Copyright, [PermaLink] = @PermaLink WHERE [EntryID] = @EntryID If @Published = 1 UPDATE dbo.Blog_Blogs SET [LastEntry] = GetUTCDate() WHERE [BlogID] = @BlogID System.Data.SqlClient.SqlException: There is already an object named 'Blog_GetBlogViewEntryModuleID' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Objekt: Gespeicherte Prozedur dbo.Blog_GetBlogViewEntryModuleID Skriptdatum: 01.03.2005 17:23:45 ******/ CREATE PROCEDURE dbo.Blog_GetBlogViewEntryModuleID @TabID as Integer AS SELECT dbo.TabModules.ModuleID FROM dbo.TabModules INNER JOIN dbo.Modules ON dbo.TabModules.ModuleID = dbo.Modules.ModuleID WHERE dbo.TabModules.TabID=@TabID AND dbo.Modules.ModuleDefID=(SELECT ModuleDefID FROM dbo.ModuleControls WHERE ControlKey = 'View_Entry') System.Data.SqlClient.SqlException: There is already an object named 'Blog_MetaWeblog_Get_DesktopModule_FriendlyName' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.[Blog_MetaWeblog_Get_DesktopModule_FriendlyName] @ModuleDefinition nvarchar(50) AS BEGIN SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SET NOCOUNT ON SELECT DM.FriendlyName FROM dbo.[ModuleDefinitions] MD JOIN dbo.[DesktopModules] DM ON MD.DesktopModuleID = DM.DesktopModuleID WHERE MD.FriendlyName = @ModuleDefinition END System.Data.SqlClient.SqlException: There is already an object named 'Blog_ListEntriesByBlog' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_ListEntriesByBlog @BlogID int, @BlogDate datetime = null, @ShowNonPublic bit = 0, @ShowNonPublished bit=0, @MaxEntries int =10 AS If @BlogDate IS NULL SET @BlogDate = GetUTCDate() SET rowcount @MaxEntries SELECT U.[UserID], U.[Username], U.[FirstName] + ' ' + U.[LastName] AS UserFullName, E.[EntryID], E.[BlogID], E.[Title], E.[Description], E.[Entry], E.[AddedDate], E.[Published], E.[Copyright], E.[PermaLink], IsNull(E.[AllowComments],B.[AllowComments]) As AllowComments, (Select Count(*) FROM dbo.Blog_Comments WHERE EntryID = E.EntryID AND (Approved = 1 OR Approved <> @ShowNonPublic)) As CommentCount, B.[PortalID] As BlogPortalID, B.[ParentBlogID], B.[Title] As BlogTitle, B.[Description] As BlogDescription, B.[Public] As BlogPublic, B.[AllowComments] As BlogAllowComments, B.[AllowAnonymous] As BlogAllowAnonymous, B.[LastEntry] As BlogLastEntry, B.[Created] As BlogCreated, B.[Culture] As BlogCulture, B.[ShowFullname] As BlogShowFullName, B.[DateFormat] As BlogDateFormat, B.[TimeZone] As BlogTimeZone, B.[Syndicated] As BlogSyndicated, B.[SyndicateIndependant] As BlogSyndicateIndependant, B.[SyndicationEmail] As SyndicationEmail FROM dbo.Blog_Blogs B INNER JOIN dbo.Blog_Entries E ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] WHERE (B.[BlogID] = @BlogID OR B.[ParentBlogID] = @BlogID) AND E.AddedDate <=@BlogDate AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) ORDER BY E.AddedDate DESC System.Data.SqlClient.SqlException: There is already an object named 'Blog_GetBlogsByUserName' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_GetBlogsByUserName @PortalID int, @UserName nvarchar(100) AS DECLARE @BlogID int SELECT B.[ParentBlogID], B.[PortalID], B.[BlogID], B.[UserID], U.[UserName], U.[FirstName] + ' ' + U.[LastName] AS UserFullName, B.[Title], B.[Description], B.[Public], B.[AllowComments], B.[AllowAnonymous], B.[LastEntry], B.[Created], B.[Culture], B.[ShowFullname], B.[DateFormat], IsNull(B.[TimeZone],0) AS TimeZone, B.[Syndicated], IsNull(B.[SyndicateIndependant], 0) As SyndicateIndependant, B.[SyndicationURL], B.[SyndicationEmail], B.[EmailNotification], B.[AllowTrackbacks], B.[AutoTrackback], B.[MustApproveComments], B.[MustApproveAnonymous], B.[MustApproveTrackbacks], B.[UseCaptcha], (SELECT Count(BlogID) FROM dbo.Blog_Blogs WHERE ParentBlogID=B.[BlogID]) AS ChildBlogCount FROM dbo.Blog_Blogs B (nolock) INNER JOIN dbo.Users U (nolock) ON B.[UserID] = U.[UserID] WHERE U.UserName = @UserName AND B.PortalID=@PortalID --AND (B.ParentBlogID IS NULL OR B.ParentBlogID=-1) ORDER BY B.[Title] System.Data.SqlClient.SqlException: There is already an object named 'Blog_GetEntry' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_GetEntry @EntryID int, @PortalId int AS SELECT E.[BlogID], E.[EntryID], E.[Title], E.[Description], E.[Entry], E.[AddedDate], E.[Published], E.[DisplayCopyright], E.[Copyright], E.[PermaLink], B.[ParentBlogID], IsNull(E.[AllowComments], B.[AllowComments]) As AllowComments, B.[UserID] FROM dbo.Blog_Entries E JOIN dbo.Blog_Blogs B ON B.BlogID = E.BlogID WHERE E.[EntryID] = @EntryID and B.PortalId = @PortalId System.Data.SqlClient.SqlException: There is already an object named 'Blog_SearchByKeyWordByPortal' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_SearchByKeyWordByPortal @PortalID int, @SearchString nvarchar(255), @ShowNonPublic bit, @ShowNonPublished bit AS DECLARE @separator char(1) SET @separator = ' ' set nocount on -- @SearchString is the array we wish to parse -- @Separator is the separator charactor such as a comma declare @separator_position int -- This is used to locate each separator character declare @search_value nvarchar(255) -- this holds each array value as it is returned declare @like_text nvarchar (257) -- Build my Temp Table to hold results CREATE TABLE #SearchResults (EntryID int) -- For my loop to work I need an extra separator at the end. I always look to the -- left of the separator character for each array value set @SearchString = @SearchString + @separator -- Loop through the string searching for separtor characters WHILE patindex('%' + @separator + '%' , @SearchString) <> 0 BEGIN -- patindex matches the a pattern against a string select @separator_position = patindex('%' + @separator + '%' , @SearchString) select @search_value = left(@SearchString, @separator_position - 1) select @like_text = '%' + @Search_value + '%' INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Title] like @like_text INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Description] like @like_text INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Entry] like @like_text -- This replaces what we just processed with and empty string select @SearchString = stuff(@SearchString, 1, @separator_position, '') END SELECT S.EntryID, Rank = Count(*) INTO #SearchResultsGrouped FROM #SearchResults S GROUP BY S.EntryID SELECT S.EntryID, E.[BlogID], B.[Title] as BlogTitle, E.[Title] As EntryTitle, IsNull(E.[Description], SubString(E.[Entry], 1, 2500)) As Summary, E.[AddedDate], E.[PermaLink], B.[UserID], U.[Username], U.[DisplayName] AS UserFullName, E.Published, S.Rank FROM #SearchResultsGrouped S INNER JOIN dbo.Blog_Entries E ON S.EntryID = E.EntryID INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] Order by S.Rank DESC, E.AddedDate DESC, E.PermaLink DESC set nocount off System.Data.SqlClient.SqlException: There is already an object named 'Blog_ListComments' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_ListComments @EntryID as Int, @ShowNonApproved bit=0 AS SELECT C.[CommentID], C.[EntryID], C.[UserID], C.[Title], C.[Comment], C.[AddedDate], U.[UserName], U.[DisplayName] AS UserFullName, C.[Author], C.[Approved], C.[Website], C.[Email] FROM dbo.Blog_Comments C LEFT JOIN dbo.Users U ON C.[UserID] = U.[UserID] WHERE [EntryID] = @EntryID AND (C.[Approved]=1 OR C.[Approved] <> @ShowNonApproved) System.Data.SqlClient.SqlException: There is already an object named 'Blog_ListAllEntriesByPortal' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_ListAllEntriesByPortal @PortalID int, @ShowNonPublic bit = 0, @ShowNonPublished bit=0 AS SELECT U.[UserID], U.[Username], U.[DisplayName] AS UserFullName, E.[EntryID], E.[BlogID], E.[Title], E.[Description], E.[Entry], E.[AddedDate], E.[Published], E.[Copyright], E.[PermaLink], IsNull(E.[AllowComments],B.[AllowComments]) As AllowComments, B.[ParentBlogID], B.[AllowAnonymous], B.[Syndicated] AS BlogSyndicated, B.[Public] AS BlogPublic, (Select Count(*) FROM dbo.Blog_Comments WHERE EntryID = E.EntryID AND Approved = 1) As CommentCount FROM dbo.Blog_Blogs B INNER JOIN dbo.Blog_Entries E ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] WHERE B.PortalID = @PortalID AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) ORDER BY E.AddedDate DESC System.Data.SqlClient.SqlException: There is already an object named 'Blog_ListAllEntriesByBlog' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_ListAllEntriesByBlog @BlogID int AS SELECT U.[UserID], U.[Username], U.[DisplayName] AS UserFullName, E.[EntryID], E.[BlogID], E.[Title], E.[Description], E.[Entry], E.[AddedDate], E.[Published], E.[Copyright], E.[PermaLink], IsNull(E.[AllowComments],B.[AllowComments]) As AllowComments, (Select Count(*) FROM dbo.Blog_Comments WHERE EntryID = E.EntryID AND Approved = 1 ) As CommentCount, B.[PortalID] As BlogPortalID, B.[ParentBlogID], B.[Title] As BlogTitle, B.[Description] As BlogDescription, B.[Public] As BlogPublic, B.[AllowComments] As BlogAllowComments, B.[AllowAnonymous] As BlogAllowAnonymous, B.[LastEntry] As BlogLastEntry, B.[Created] As BlogCreated, B.[Culture] As BlogCulture, B.[ShowFullname] As BlogShowFullName, B.[DateFormat] As BlogDateFormat, B.[TimeZone] As BlogTimeZone, B.[Syndicated] As BlogSyndicated, B.[SyndicateIndependant] As BlogSyndicateIndependant FROM dbo.Blog_Blogs B INNER JOIN dbo.Blog_Entries E ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] WHERE (B.[BlogID] = @BlogID) ORDER BY E.AddedDate DESC System.Data.SqlClient.SqlException: There is already an object named 'Blog_SearchByKeyWordByBlog' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_SearchByKeyWordByBlog @BlogID int, @SearchString nvarchar(255), @ShowNonPublic bit, @ShowNonPublished bit AS DECLARE @separator char(1) SET @separator = ' ' set nocount on -- @SearchString is the array we wish to parse -- @Separator is the separator charactor such as a comma declare @separator_position int -- This is used to locate each separator character declare @search_value nvarchar(255) -- this holds each array value as it is returned declare @like_text nvarchar (257) -- Build my Temp Table to hold results CREATE TABLE #SearchResults (EntryID int) -- For my loop to work I need an extra separator at the end. I always look to the -- left of the separator character for each array value set @SearchString = @SearchString + @separator -- Loop through the string searching for separtor characters WHILE patindex('%' + @separator + '%' , @SearchString) <> 0 BEGIN -- patindex matches the a pattern against a string select @separator_position = patindex('%' + @separator + '%' , @SearchString) select @search_value = left(@SearchString, @separator_position - 1) select @like_text = '%' + @Search_value + '%' INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE (B.[BlogID] = @BlogID OR B.[ParentBlogID] = @BlogID) AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Title] like @like_text INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE (B.[BlogID] = @BlogID OR B.[ParentBlogID] = @BlogID) AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Description] like @like_text INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE (B.[BlogID] = @BlogID OR B.[ParentBlogID] = @BlogID) AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Entry] like @like_text -- This replaces what we just processed with and empty string select @SearchString = stuff(@SearchString, 1, @separator_position, '') END SELECT S.EntryID, Rank = Count(*) INTO #SearchResultsGrouped FROM #SearchResults S GROUP BY S.EntryID SELECT S.EntryID, E.[BlogID], B.[Title] as BlogTitle, E.[Title] As EntryTitle, IsNull(E.[Description], SubString(E.[Entry], 1, 2500)) As Summary, E.[AddedDate], E.[PermaLink], B.[UserID], U.[Username], U.[DisplayName] AS UserFullName, E.Published, S.Rank FROM #SearchResultsGrouped S INNER JOIN dbo.Blog_Entries E ON S.EntryID = E.EntryID INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] Order by S.Rank DESC, E.AddedDate DESC, E.PermaLink DESC set nocount off System.Data.SqlClient.SqlException: There is already an object named 'Blog_Upgrade_ListComments' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_Upgrade_ListComments @EntryID as Int AS SELECT C.[CommentID], C.[EntryID], C.[UserID], C.[Title], C.[Comment], C.[AddedDate], U.[UserName], U.[DisplayName] AS UserFullName FROM dbo.NewBlog_Comments C LEFT JOIN dbo.Users U ON C.[UserID] = U.[UserID] WHERE [EntryID] = @EntryID System.Data.SqlClient.SqlException: There is already an object named 'Blog_GetBlogMonths' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_GetBlogMonths ( @PortalID int, @BlogID int ) AS If @BlogID > -1 BEGIN SELECT DATEPART(mm, E.AddedDate) as AddedMonth, DATEPART(yy, E.AddedDate) as AddedYear, COUNT(EntryId) AS PostCount FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND (B.BlogID = @BlogID OR B.[ParentBlogID] = @BlogID) AND E.Published=1 group by DATEPART(m, E.AddedDate), DATEPART(yy, E.AddedDate) order by AddedYear DESC, AddedMonth DESC END ELSE BEGIN SELECT DATEPART(mm, E.AddedDate) as AddedMonth, DATEPART(yy, E.AddedDate) as AddedYear, COUNT(EntryId) AS PostCount FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND E.Published=1 group by DATEPART(m, E.AddedDate), DATEPART(yy, E.AddedDate) order by AddedYear DESC, AddedMonth DESC END System.Data.SqlClient.SqlException: There is already an object named 'Blog_GetBlogDaysForMonth' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Objekt: Gespeicherte Prozedur dbo.Blog_GetBlogDaysForMonth Skriptdatum: 01.03.2005 17:23:45 ******/ CREATE PROCEDURE dbo.Blog_GetBlogDaysForMonth ( @PortalID int, @BlogID int, @BlogDate DateTime ) AS DECLARE @BlogMonth int DECLARE @BlogYear int SELECT @BlogMonth = DATEPART(mm, @BlogDate) SELECT @BlogYear = DATEPART(yy, @BlogDate) If @BlogID > -1 BEGIN SELECT E.[EntryID], E.[BlogID], B.[ParentBlogID], E.[Title], E.[AddedDate], U.[Username], DATEPART(mm, E.AddedDate) as AddedMonth, DATEPART(yy, E.AddedDate) as AddedYear FROM dbo.Blog_Blogs B INNER JOIN dbo.Blog_Entries E ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] WHERE B.[PortalID] = @PortalID AND (B.[BlogID] = @BlogID OR B.[ParentBlogID] = @BlogID) AND DATEPART(yy, E.AddedDate) = @BlogYear AND DATEPART(mm, E.AddedDate) = @BlogMonth ORDER BY E.AddedDate END ELSE BEGIN SELECT E.[EntryID], E.[BlogID], B.[ParentBlogID], E.[Title], E.[AddedDate], U.[Username], DATEPART(mm, E.AddedDate) as AddedMonth, DATEPART(yy, E.AddedDate) as AddedYear FROM dbo.Blog_Blogs B INNER JOIN dbo.Blog_Entries E ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] WHERE B.[PortalID] = @PortalID AND DATEPART(yy, E.AddedDate) = @BlogYear AND DATEPART(mm, E.AddedDate) = @BlogMonth ORDER BY E.AddedDate END System.Data.SqlClient.SqlException: There is already an object named 'Blog_SearchBlogByKeyWord' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_SearchBlogByKeyWord @PortalID int, @BlogID int, @SearchString nvarchar(255), @ShowNonPublic bit, @ShowNonPublished bit AS DECLARE @separator char(1) SET @separator = ' ' set nocount on -- @SearchString is the array we wish to parse -- @Separator is the separator charactor such as a comma declare @separator_position int -- This is used to locate each separator character declare @search_value nvarchar(255) -- this holds each array value as it is returned declare @like_text nvarchar (257) -- Build my Temp Table to hold results CREATE TABLE #SearchResults (EntryID int) -- For my loop to work I need an extra separator at the end. I always look to the -- left of the separator character for each array value set @SearchString = @SearchString + @separator -- Loop through the string searching for separtor characters WHILE patindex('%' + @separator + '%' , @SearchString) <> 0 BEGIN -- patindex matches the a pattern against a string select @separator_position = patindex('%' + @separator + '%' , @SearchString) select @search_value = left(@SearchString, @separator_position - 1) select @like_text = '%' + @Search_value + '%' IF @BlogID > -1 BEGIN INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND (B.[BlogID] = @BlogID OR B.[ParentBlogID] = @BlogID) AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Title] like @like_text INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND (B.[BlogID] = @BlogID OR B.[ParentBlogID] = @BlogID) AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Description] like @like_text INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND (B.[BlogID] = @BlogID OR B.[ParentBlogID] = @BlogID) AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Entry] like @like_text END ELSE BEGIN INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Title] like @like_text INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Description] like @like_text INSERT #SearchResults SELECT E.[EntryID] FROM dbo.Blog_Entries E INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] WHERE B.[PortalID] = @PortalID AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) AND E.[Entry] like @like_text END -- This replaces what we just processed with and empty string select @SearchString = stuff(@SearchString, 1, @separator_position, '') END SELECT S.EntryID, Rank = Count(*) INTO #SearchResultsGrouped FROM #SearchResults S GROUP BY S.EntryID SELECT S.EntryID, E.[BlogID], B.[Title] as BlogTitle, E.[Title] As EntryTitle, IsNull(E.[Description], SubString(E.[Entry], 1, 2500)) As Summary, E.[AddedDate], E.[PermaLink], B.[UserID], U.[Username], U.[DisplayName] AS UserFullName, E.Published, S.Rank FROM #SearchResultsGrouped S INNER JOIN dbo.Blog_Entries E ON S.EntryID = E.EntryID INNER JOIN dbo.Blog_Blogs B ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] Order by S.Rank DESC, E.AddedDate DESC, E.PermaLink DESC set nocount off System.Data.SqlClient.SqlException: There is already an object named 'Blog_DeleteBlog' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Objekt: Gespeicherte Prozedur dbo.Blog_DeleteBlog Skriptdatum: 01.03.2005 17:18:18 ******/ CREATE PROCEDURE dbo.Blog_DeleteBlog @BlogID int AS DELETE FROM dbo.Blog_Blogs WHERE ([BlogID] = @BlogID OR [ParentBlogID] = @BlogID) System.Data.SqlClient.SqlException: There is already an object named 'Blog_ListBlogsRootByPortal' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_ListBlogsRootByPortal @PortalID int AS SELECT B.[PortalID], B.[BlogID], B.[ParentBlogID], B.[UserID], U.[UserName], U.[DisplayName] AS UserFullName, B.[Title], B.[Description], B.[Public], B.[AllowComments], B.[AllowAnonymous], B.[LastEntry], B.[Created], B.[Culture], B.[ShowFullname], B.[DateFormat], IsNull(B.[TimeZone],0) AS TimeZone, B.[Syndicated], IsNull(B.[SyndicateIndependant], 0) As SyndicateIndependant, B.[SyndicationURL], B.[SyndicationEmail], B.[EmailNotification], B.[AllowTrackbacks], B.[AutoTrackback], B.[MustApproveComments], B.[MustApproveAnonymous], B.[MustApproveTrackbacks], B.[UseCaptcha], (SELECT Count(BlogID) FROM dbo.Blog_Blogs WHERE ParentBlogID=B.[BlogID]) AS ChildBlogCount FROM dbo.Blog_Blogs B INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] WHERE B.[PortalID] = @PortalID AND ParentBlogID = -1 System.Data.SqlClient.SqlException: Invalid column name 'EnableTwitterIntegration'. Invalid column name 'TwitterUsername'. Invalid column name 'TwitterPassword'. Invalid column name 'TweetTemplate'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_AddBlog @PortalID int, @ParentBlogID int = -1, @UserID int, @Title nvarchar(512), @Description nvarchar(1024), @Public bit, @AllowComments bit, @AllowAnonymous bit, @ShowFullName bit, @Culture nvarchar(10), @DateFormat nvarchar(50), @TimeZone int, @Syndicated bit, @SyndicateIndependant bit, @SyndicationURL nvarchar(1024), @SyndicationEmail nvarchar(255), @EmailNotification bit, @AllowTrackbacks bit, @AutoTrackback bit, @MustApproveComments bit, @MustApproveAnonymous bit, @MustApproveTrackbacks bit, @UseCaptcha bit, @EnableTwitterIntegration bit, @TwitterUsername nvarchar(256), @TwitterPassword nvarchar(128), @TweetTemplate nvarchar(256) AS INSERT INTO dbo.Blog_Blogs ( [PortalID], [ParentBlogID], [UserID], [Title], [Description], [Public], [AllowComments], [AllowAnonymous], [ShowFullName], [Culture], [DateFormat], [TimeZone], [Created], [Syndicated], [SyndicateIndependant], [SyndicationURL], [SyndicationEmail], [EmailNotification], [AllowTrackbacks], [AutoTrackback], [MustApproveComments], [MustApproveAnonymous], [MustApproveTrackbacks], [UseCaptcha], [EnableTwitterIntegration], [TwitterUsername], [TwitterPassword], [TweetTemplate] ) VALUES ( @PortalID, @ParentBlogID, @UserID, @Title, @Description, @Public, @AllowComments, @AllowAnonymous, @ShowFullName, @Culture, @DateFormat, @TimeZone, GetUTCDate(), @Syndicated, @SyndicateIndependant, @SyndicationURL, @SyndicationEmail, @EmailNotification, @AllowTrackbacks, @AutoTrackback, @MustApproveComments, @MustApproveAnonymous, @MustApproveTrackbacks, @UseCaptcha, @EnableTwitterIntegration, @TwitterUsername, @TwitterPassword, @TweetTemplate ) select SCOPE_IDENTITY() System.Data.SqlClient.SqlException: There is already an object named 'Blog_Upgrade_ListBlogs' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_Upgrade_ListBlogs @PortalID int, @ParentBlogID int, @ShowNonPublic bit AS SELECT B.[PortalID], B.[BlogID], B.[ParentBlogID], B.[UserID], U.[UserName], U.[DisplayName] AS UserFullName, B.[Title], B.[Description], B.[Public], B.[AllowComments], B.[AllowAnonymous], B.[LastEntry], B.[Created], B.[Culture], B.[ShowFullname], B.[DateFormat], IsNull(B.[TimeZone],0) AS TimeZone, B.[Syndicated], IsNull(B.[SyndicateIndependant], 0) As SyndicateIndependant, B.[SyndicationURL], B.[SyndicationEmail], B.[EmailNotification], (SELECT Count(BlogID) FROM dbo.NewBlog_Blogs WHERE ParentBlogID=B.[BlogID]) AS ChildBlogCount FROM dbo.NewBlog_Blogs B INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] System.Data.SqlClient.SqlException: Invalid column name 'EnableTwitterIntegration'. Invalid column name 'TwitterUsername'. Invalid column name 'TwitterPassword'. Invalid column name 'TweetTemplate'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_UpdateBlog @PortalID int, @BlogID int, @ParentBlogID int = -1, @UserID int, @Title nvarchar(512), @Description nvarchar(1024), @Public bit, @AllowComments bit, @AllowAnonymous bit, @ShowFullName bit, @Culture nvarchar(10), @DateFormat nvarchar(50), @TimeZone int, @Syndicated bit, @SyndicateIndependant bit, @SyndicationURL nvarchar(1024), @SyndicationEmail nvarchar(255), @EmailNotification bit, @AllowTrackbacks bit, @AutoTrackback bit, @MustApproveComments bit, @MustApproveAnonymous bit, @MustApproveTrackbacks bit, @UseCaptcha bit, @EnableTwitterIntegration bit, @TwitterUsername nvarchar(256), @TwitterPassword nvarchar(128), @TweetTemplate nvarchar(256) AS UPDATE dbo.Blog_Blogs SET [PortalID] = @PortalID, [ParentBlogID] = @ParentBlogID, [UserID] = @UserID, [Title] = @Title, [Description] = @Description, [Public] = @Public, [AllowComments] = @AllowComments, [AllowAnonymous] = @AllowAnonymous, [ShowFullName] = @ShowFullName, [Culture] = @Culture, [DateFormat] = @DateFormat, [TimeZone] = @TimeZone, [Syndicated] = @Syndicated, [SyndicateIndependant] = @SyndicateIndependant, [SyndicationURL] = @SyndicationURL, [SyndicationEmail] = @SyndicationEmail, [EmailNotification] = @EmailNotification, [AllowTrackbacks] = @AllowTrackbacks, [AutoTrackback] = @AutoTrackback, [MustApproveComments] = @MustApproveComments, [MustApproveAnonymous] = @MustApproveAnonymous, [MustApproveTrackbacks] = @MustApproveTrackbacks, [UseCaptcha] = @UseCaptcha, [EnableTwitterIntegration] = @EnableTwitterIntegration, [TwitterUsername] = @TwitterUsername, [TwitterPassword] = @TwitterPassword, [TweetTemplate] = @TweetTemplate WHERE [BlogID] = @BlogID System.Data.SqlClient.SqlException: Invalid column name 'EnableTwitterIntegration'. Invalid column name 'TwitterUsername'. Invalid column name 'TwitterPassword'. Invalid column name 'TweetTemplate'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_GetBlog @BlogID int AS SELECT B.[ParentBlogID], B.[PortalID], B.[BlogID], B.[UserID], U.[UserName], U.[DisplayName] AS UserFullName, B.[Title], B.[Description], B.[Public], B.[AllowComments], B.[AllowAnonymous], B.[LastEntry], B.[Created], B.[Culture], B.[ShowFullname], B.[DateFormat], IsNull(B.[TimeZone],0) AS TimeZone, B.[Syndicated], IsNull(B.[SyndicateIndependant], 0) As SyndicateIndependant, B.[SyndicationURL], B.[SyndicationEmail], B.[EmailNotification], B.[AllowTrackbacks], B.[AutoTrackback], B.[MustApproveComments], B.[MustApproveAnonymous], B.[MustApproveTrackbacks], B.[UseCaptcha], B.[EnableTwitterIntegration], B.[TwitterUsername], B.[TwitterPassword], B.[TweetTemplate], (SELECT Count(BlogID) FROM dbo.Blog_Blogs WHERE ParentBlogID=B.[BlogID]) AS ChildBlogCount FROM dbo.Blog_Blogs B INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] WHERE [BlogID] = @BlogID System.Data.SqlClient.SqlException: There is already an object named 'Blog_ListEntriesByPortalByDay' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_ListEntriesByPortalByDay @PortalID int, @BlogDate datetime = null, @ShowNonPublic bit = 0, @ShowNonPublished bit=0, @MaxEntries int = 10 AS If @BlogDate IS NULL SET @BlogDate = GetUTCDate() SET rowcount @MaxEntries SELECT U.[UserID], U.[Username], U.[FirstName] + ' ' + U.[LastName] AS UserFullName, E.[EntryID], E.[BlogID], E.[Title], E.[Description], E.[Entry], E.[AddedDate], E.[Published], E.[Copyright], E.[PermaLink], IsNull(E.[AllowComments],B.[AllowComments]) As AllowComments, B.[ParentBlogID], B.[AllowAnonymous], B.[Syndicated] AS BlogSyndicated, B.[Public] AS BlogPublic, B.[SyndicationEmail] as SyndicationEmail, (Select Count(*) FROM dbo.Blog_Comments WHERE EntryID = E.EntryID AND (Approved = 1 OR Approved <> @ShowNonPublic)) As CommentCount FROM dbo.Blog_Blogs B INNER JOIN dbo.Blog_Entries E ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] WHERE B.PortalID = @PortalID AND E.AddedDate BETWEEN @BlogDate AND DateAdd( dd, 1, @BlogDate ) AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) ORDER BY E.AddedDate DESC System.Data.SqlClient.SqlException: There is already an object named 'Blog_ListEntriesByPortal' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_ListEntriesByPortal @PortalID int, @BlogDate datetime = null, @ShowNonPublic bit = 0, @ShowNonPublished bit=0, @MaxEntries int = 10 AS If @BlogDate IS NULL SET @BlogDate = GetUTCDate() SET rowcount @MaxEntries SELECT U.[UserID], U.[Username], U.[FirstName] + ' ' + U.[LastName] AS UserFullName, E.[EntryID], E.[BlogID], E.[Title], E.[Description], E.[Entry], E.[AddedDate], E.[Published], E.[Copyright], E.[PermaLink], IsNull(E.[AllowComments],B.[AllowComments]) As AllowComments, B.[ParentBlogID], B.[AllowAnonymous], B.[Syndicated] AS BlogSyndicated, B.[Public] AS BlogPublic, B.[SyndicationEmail] as SyndicationEmail, (Select Count(*) FROM dbo.Blog_Comments WHERE EntryID = E.EntryID AND (Approved = 1 OR Approved <> @ShowNonPublic)) As CommentCount FROM dbo.Blog_Blogs B INNER JOIN dbo.Blog_Entries E ON B.[BlogID] = E.[BlogID] INNER JOIN dbo.Users U ON B.[UserID] = U.[UserID] WHERE B.PortalID = @PortalID AND E.AddedDate <=@BlogDate AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished) AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic) ORDER BY E.AddedDate DESC System.Data.SqlClient.SqlException: There is already an object named 'Blog_GetBlogByUserID' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_GetBlogByUserID @PortalID int, @UserID int AS DECLARE @BlogID int SELECT @BlogID = (SELECT Min(BlogID) FROM dbo.Blog_Blogs WHERE UserID=@UserID AND PortalID=@PortalID AND (ParentBlogID IS NULL OR ParentBlogID=-1)) EXEC dbo.Blog_GetBlog @BlogID System.Data.SqlClient.SqlException: There is already an object named 'Blog_GetBlogByUserName' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /****** Objekt: Gespeicherte Prozedur dbo.Blog_GetBlogByUserName Skriptdatum: 01.03.2005 17:23:45 ******/ CREATE PROCEDURE dbo.Blog_GetBlogByUserName @PortalID int, @UserName nvarchar(100) AS DECLARE @BlogID int SELECT @BlogID = (SELECT BlogID FROM dbo.Blog_Blogs B JOIN dbo.Users U ON B.UserID = U.UserID WHERE U.UserName=@UserName AND B.PortalID=@PortalID AND (B.ParentBlogID IS NULL OR B.ParentBlogID=-1)) EXEC dbo.Blog_GetBlog @BlogID /* SELECT B.[ParentBlogID], B.[PortalID], B.[BlogID], B.[UserID], U.[UserName], U.[DisplayName] AS UserFullName, B.[Title], B.[Description], B.[Public], B.[AllowComments], B.[AllowAnonymous], B.[Syndicated], B.[LastEntry], B.[Created], B.[Culture], B.[ShowFullname], B.[DateFormat], IsNull(B.[TimeZone],0) AS TimeZone, (SELECT Count(BlogID) FROM dbo.Blog_Blogs WHERE ParentBlogID=B.[BlogID]) AS ChildBlogCount FROM dbo.Users U INNER JOIN dbo.Blog_Blogs B ON U.UserID = B.UserID WHERE U.UserName = @UserName AND B.PortalID = @PortalID AND (B.[ParentBlogID] = -1 OR B.[ParentBlogID] IS NULL) */ System.Data.SqlClient.SqlException: There is already an object named 'Blog_MetaWeblogData' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE TABLE dbo.[Blog_MetaWeblogData] ( [TempInstallUrl] [nvarchar] (500) NULL ) System.Data.SqlClient.SqlException: There is already an object named 'Blog_Upgrade_DeleteComment' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_Upgrade_DeleteComment @CommentID int AS DELETE FROM dbo.NewBlog_Comments WHERE [CommentID] = @CommentID System.Data.SqlClient.SqlException: There is already an object named 'Blog_Upgrade_GetSettings' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_Upgrade_GetSettings AS SELECT [PortalID],[Key], [Value] From dbo.NewBlog_Settings System.Data.SqlClient.SqlException: There is already an object named 'Blog_Upgrade_DeleteBlog' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_Upgrade_DeleteBlog @BlogID int AS DELETE FROM dbo.NewBlog_Blogs WHERE ([BlogID] = @BlogID) System.Data.SqlClient.SqlException: There is already an object named 'Blog_Upgrade_DeleteEntry' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_Upgrade_DeleteEntry @EntryID int AS DELETE FROM dbo.NewBlog_Entries WHERE [EntryID] = @EntryID System.Data.SqlClient.SqlException: There is already an object named 'FK_Blog_Blogs_Portals' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Blog_Blogs] WITH NOCHECK ADD CONSTRAINT [FK_Blog_Blogs_Portals] FOREIGN KEY ([PortalID]) REFERENCES dbo.[Portals] ([PortalID]) NOT FOR REPLICATION, CONSTRAINT [FK_Blog_Blogs_Users] FOREIGN KEY ([UserID]) REFERENCES dbo.[Users] ([UserID]) NOT FOR REPLICATION System.Data.SqlClient.SqlException: There is already an object named 'FK_Blog_Comments' in the database. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.[Blog_Comments] ADD CONSTRAINT [FK_Blog_Comments] FOREIGN KEY ([EntryID]) REFERENCES dbo.[Blog_Entries] ([EntryID]) ON DELETE CASCADE ON UPDATE CASCADE
Informazioni	Fine istruzione SQL: Install.04.00.00.SqlDataProvider file

 "..There is already an object named 'Blog_Entries' in the database ...."   Obviously YES ! It's an upgrade or Upgrade is not supported ?

Thanks, Sandro

 

---

Sandro De Matteis Microsoft IT Pro: Enterprise Admin, Enterprise Messaging Admin Technology Specialist: Microsoft Virtualization Dnn portals: http://www.dbdog.it , http://www.royalcrestgoldn.it, http://www.retrieversclub.it