Ok, I have been having issues with this problem for over a month now and haven't been able to find any resolutions for it that don't involved destroying the entire database and rebuilding it.  I have found dozens of instances of this exact error message for about 3-4 different modules that are all problems with "The INSERT statement conflicted with the FOREIGN KEY constraint <insert module here>".  The worst part is that not a single one of the threads has found a resolution to the problem.  I have found problems from DNN 3.0 up to the recent versions and not a single person seems to have found a resolution.

I have found after my original post in here (that didn't get any answers) that my events module is doing the same thing, although I don't have the exact message on this.

Does anyone have any ideas on how to fix this short of deleting the entire site and rebuilding it?

Error: Edit FAQs is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_FAQs_Modules". The conflict occurred in database "dotnetnuke", table "dbo.Modules", column 'ModuleID'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_FAQs_Modules". The conflict occurred in database "dotnetnuke", table "dbo.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.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.FAQs.SqlDataProvider.AddFAQ(Int32 ModuleId, String UserName, String Question, String Answer) at DotNetNuke.Modules.FAQs.FAQsController.AddFAQ(FAQsInfo objFAq) at DotNetNuke.Modules.FAQs.EditFAQs.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---

I'm having issues with both the Events modules and the FAQ module, although the listed error was just the FAQ module.  I'm using the 4.4.0 version and the modules were the ones that came with the package.

The funny thing is that I have two different websites that are using the EXACT same code, and one of them is working great, and the other one is having issues with FAQs and Events.  It would make me tend to think that it was doing something funky with the database, but I'm really not sure.