Info Executing 03.05.00.SqlDataProvider
StartJob Start Sql execution: 03.05.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'Website'. Invalid column name 'Email'. 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_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: Invalid column name 'Website'. Invalid column name 'Email'. 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_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: Invalid column name 'Website'. Invalid column name 'Email'. 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_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: Invalid column name 'Website'. Invalid column name 'Email'. 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_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)
EndJob End Sql execution: 03.05.00.SqlDataProvider file