Hi

I am getting the following error message when I click on "Admin Settings" in the forum User Settings:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date:  11/20/2006
Time:  3:06:10 PM
User:  N/A
Computer: HOMECONET
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 11/20/2006 3:06:10 PM
Event time (UTC): 11/20/2006 8:06:10 PM
Event ID: d0eeb6cb3d1d49f3bca05f7f3c665163
Event sequence: 120
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1/Root/dotnet-1-128085260587656250
    Trust level: Full
    Application Virtual Path: /dotnet
    Application Path: C:\Inetpub\wwwroot\dotnet\
    Machine name: HOMECONET
 
Process information:
    Process ID: 4080
    Process name: aspnet_wp.exe
    Account name: HOMECONET\ASPNET
 
Exception information:
    Exception type: SqlException
    Exception message: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ModuleSettings_Modules". The conflict occurred in database "dotnet", table "dbo.Modules", column 'ModuleID'.
The statement has been terminated.
 
Request information:
    Request URL: http://localhost/dotnet/DesktopModules/Forum/Integration/Integration_GalleryAddFile.aspx?tabid=53&mid=0&forummid=369&targetID=dnn_ctr369_Forum_UserSettings_txtSystemAvatar&formname=Form
    Request path: /dotnet/DesktopModules/Forum/Integration/Integration_GalleryAddFile.aspx
    User host address: 127.0.0.1
    User: host
    Is authenticated: True
    Authentication Type: Forms
    Thread account name: HOMECONET\ASPNET
 
Thread information:
    Thread ID: 1
    Thread account name: HOMECONET\ASPNET
    Is impersonating: False
    Stack trace:    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.Gallery.GalleryPreConfig.PreConfig(Int32 ModuleId, Int32 PortalId, Int32 UserId)
   at DotNetNuke.Modules.Gallery.Config..ctor(Int32 ModuleID)
   at DotNetNuke.Modules.Gallery.Config.GetGalleryConfig(Int32 ModuleID)
   at DotNetNuke.Modules.Forum.Integration.GalleryAddFile.Page_Load(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
 
Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

This message is logged in the Event Viewer.  Does anyone has a solution to this problem?  I am using SQL Server Express 2005, DNN 4.3.6.
Thanks, Peter

I want to correct something here.  The error happened when I clicked on "Additional Avatars" icon under forum "User Settings". If someone has this problem install the gallery module if it is not already installed and go to the forum administration and enable avatars under "Gallery & Emotions" link.