DotNetNuke 5.4.4 upgraded from earlier versions dating back to 4.x.
A particular HTML module throws this error when it is edited and saved is saved. There are 18 versions of the module contents. The edited changes actually are saved.
---------
DotNetNuke.Services.Exceptions.ModuleLoadException: The DELETE statement conflicted with the REFERENCE constraint "FK_HtmlTextLog_HtmlText".
The conflict occurred in database "alticoadvisors", table "dbo.HtmlTextLog", column 'ItemID'. The statement has been terminated. --->
System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_HtmlTextLog_HtmlText". The conflict occurred in database "xxxxxxx", table "dbo.HtmlTextLog", column 'ItemID'. The statement has been terminated.
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.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 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues)
at DotNetNuke.Modules.Html.SqlDataProvider.AddHtmlText(Int32 ModuleID, String Content, Int32 StateID, Boolean IsPublished, Int32 CreatedByUserID, Int32 History)
at DotNetNuke.Modules.Html.HtmlTextController.UpdateHtmlText(HtmlTextInfo objHtmlText, Int32 MaximumVersionHistory)
at DotNetNuke.Modules.Html.EditHtml.cmdSave_Click(Object sender, EventArgs e)
--- End of inner exception stack trace ---
I assume that this is an attempt to delete old copies. I can't find anywhere to specifiy how many copies should be kept.
How do I fix this?