Hi,

I don't know what's happened.. but my blog missing dbo.Blog_Blogs and dbo.Blog_Settings in Stored Procedures (my database) where aren't presents.

I have tried a new installation module but nothing to do..

What I can solve this problem?

Thank you Antonio,

my error is appeared after site transfer.

I have looked in the (03.03.00) SQLDataProvider file  and I have seen Blog_Blogs SQL scripts only, while I have seen Blog_Settings in (03.01.21) SQLDataProvider file.

Unfortunately, I'm not able to create the procedure.

These are the link where you can quickly see the files:

http://www.etruscancharter.com/mailinglist/public/03.03.00.SqlDataProvider.txt

http://www.etruscancharter.com/mailinglist/public/03.01.21.SqlDataProvider.txt

Can you help me to recover these scripts?

Hi,

I have tried to running those scripts ( changinng >ALTER with CREATE ) in host > sql but I have many errors. This is I can see:

System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'ADD'. Incorrect syntax near 'UseCaptcha'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /* captcha for comments */ CREATE TABLE dbo.Blog_Blogs ADD UseCaptcha bit NULL System.Data.SqlClient.SqlException: Incorrect syntax near 'bit'. Must declare the scalar variable "@AllowTrackbacks". at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.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, @llowTrackbacks bit, @AutoTrackback bit, @MustApproveComments bit, @MustApproveAnonymous bit, @MustApproveTrackbacks bit, @UseCaptcha bit 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 WHERE [BlogID] = @BlogID 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.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_UpdateEntry @BlogID int, @EntryID int, @Title nvarchar(255), @Description nvarchar(1024), @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, /*[AddedDate] = @AddedDate,*/ [AddedDate] = GetUTCDate(), [Published] = @Published, [AllowComments] = @AllowComments, [DisplayCopyright] = @DisplayCopyright, [Copyright] = @Copyright, [PermaLink] = @PermaLink WHERE [EntryID] = @EntryID If @Published = 1 UPDATE dbo.Blog_Blogs SET [LastEntry] = GetUTCDate() WHERE [BlogID] = @BlogID