Just did a clean install of DNN 4.6.1. I created the domain, the database, database user, mailbox, copied the DNN installation files, ammended web.config, altered user rights and started the DNN installation proces. After the basic installation I added the optional modules that come with DNN 4.6.1. This is all standard, i have done so thirty times with multiple DNN versions.up to 4.5.X. Aftewards, without adding/changing anything to the default installation, I just added a page with the feedback module. So far so good.
However, when I try to change the settings of the feedback module and click update I return to the feedback form but nothing seems to have changed. When I look at the settings indeed nothing has changed. When I look in event viewer I see the entry below. The Insert statement failed so this explains why i don't see changes. Why the insert failed is not clear to me. This should not happen.
This is clearly a bug. I have seen a few other forum entries with people that have similar issues. Not only the feedback module is bugged by this, it looks like all modules that have module specific settings have the same problem.
Is there a workarround (i.e.?
==//==
ModuleId: 372
ModuleDefId: 107
FriendlyName: Feedback
ModuleControlSource: DesktopModules/Feedback/Feedback.ascx
AssemblyVersion: 04.06.01
PortalID: 0
PortalName: My Website
UserID: 1
UserName: host
ActiveTabID: 54
ActiveTabName: Contact
RawURL: /Contact/tabid/54/ctl/Module/ModuleId/372/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.mijnhomepage.nu/Contact/tabid/54/ctl/Module/ModuleId/372/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; nl; rv:1.8.1.7) Gecko/20070914 Firefox/2.0.0.7
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 66dde03f-54c1-42ba-ab9c-5afcbd59dfa4
InnerException: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_ModuleSettings_Modules'. The conflict occurred in database 'MijnHomePage', table 'Modules', column 'ModuleID'. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_ModuleSettings_Modules'. The conflict occurred in database 'MijnHomePage', table 'Modules', column 'ModuleID'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_ModuleSettings_Modules'. The conflict occurred in database 'MijnHomePage', table 'Modules', column 'ModuleID'. 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModuleSetting(Int32 ModuleId, String SettingName, String SettingValue) at DotNetNuke.Entities.Modules.ModuleController.UpdateModuleSetting(Int32 ModuleId, String SettingName, String SettingValue) at DotNetNuke.Modules.Feedback.Settings.UpdateSettings() --- End of inner exception stack trace ---
Source:
Server Name: CHAMPAGNE