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. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserState stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserState 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.ExecuteADO (String SQL) at DotNetNuke.Data.SqlDataProvider.Execute (String , Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_AddComment @EntryID int, @UserID int, @ nvarchar(255), @Comment ntext, @Author nvarchar(50), @Approved bit, @Website nvarchar(255), @Email nvarchar(255) AS INSERT INTO dbo.Blog_Comments ( [EntryID], [UserID], [ ], [Comment], [Author], [Approved], [AddedDate], [Website], [Email] ) VALUES ( @EntryID, @UserID, @ , @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. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserState stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserState 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.ExecuteADO (String SQL) at DotNetNuke.Data.SqlDataProvider.Execute (String , Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_UpdateComment @CommentID int, @EntryID int, @UserID int, @ 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, [ ] = @ , [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. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserState stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserState 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.ExecuteADO (String SQL) at DotNetNuke.Data.SqlDataProvider.Execute (String , Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_GetComment @CommentID int AS SELECT C.[CommentID], C.[EntryID], C.[UserID], C.[ ], 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. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserState stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserState 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.ExecuteADO (String SQL) at DotNetNuke.Data.SqlDataProvider.Execute (String , Boolean UseTransactions) CREATE PROCEDURE dbo.Blog_ListComments @EntryID as Int, @ShowNonApproved bit=0 AS SELECT C.[CommentID], C.[EntryID], C.[UserID], C.[ ], 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
继续阅读与本文标签相同的文章
-
从台积电病毒事件看工控安全
2026-05-25栏目: 教程
-
IE Developer Toolbar工具栏显示灰色无法使用的解决办法
2026-05-25栏目: 教程
-
重新打开文件传输管理器(FTM)
2026-05-25栏目: 教程
-
同时使用XmlSerializer和WCF的DataContractSerializer
2026-05-25栏目: 教程
-
个人开发环境解决方案
2026-05-25栏目: 教程
