I have a site that has been upgraded from DNN5 to DNN7 over a few years. Since I did the DNN7 upgrade the Html module will not save any changes. The event viewer shows the error below. I suspect this is a bug in the SqlDataProviders and should be able to fix by fishing the correct proc out of the scripts. However, it would be a good candidate for a maintenance release in the near future.
UserAgent: Mozilla/5.0 (Windows NT 6.1; rv:18.0) Gecko/20100101 Firefox/18.0
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID: a1774ff7-9eba-4015-9a8a-fc53bbe3f19f
InnerException: Procedure or function AddHtmlText has too many arguments specified.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.
StackTrace:
Message: System.Data.SqlClient.SqlException (0x80131904): Procedure or function AddHtmlText has too many arguments specified. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at PetaPoco.Database.ExecuteScalar[T](String sql, Object[] args) at DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteScalar[T](String connectionString, CommandType type, String sql, Object[] args) at DotNetNuke.Data.SqlDataProvider.ExecuteScalar[T](String procedureName, Object[] commandParameters) at DotNetNuke.Modules.Html.Components.DataProvider.AddHtmlText(Int32 ModuleID, String Content, String Summary, Int32 StateID, Boolean IsPublished, Int32 CreatedByUserID, Int32 History) at DotNetNuke.Modules.Html.HtmlTextController.UpdateHtmlText(HtmlTextInfo htmlContent, Int32 MaximumVersionHistory) at DotNetNuke.Modules.Html.EditHtml.OnSaveClick(Object sender, EventArgs e)
Source:
Server Name: dwin25