Here is more detail of the message (db name hidden). 

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ModuleSettings_Modules".  The conflict occured in database "mydatabase", table "dbo.Modules", column 'ModuleID'. The statement has been terminated

I am getting the same error and found out that it comes from the fact that the popup window is loading with the wrong argument as the modul id mid argument is allways set to 0.

Here is the full error comming from the event viewer with the section of the query string highlighted (in my case the module id should have been in the five hundred):

AssemblyVersion: 04.05.03
PortalID: 0
PortalName: PeerMomentum.com
UserID: 1
UserName: host
ActiveTabID: 79
ActiveTabName: Photo Albums
RawURL: /DesktopModules/Gallery/Popup/popupdata.aspx?datasource=gallery&objectclasses=101&tabid=79&mid=0&objectclass=101&location=&searchvalue=register
AbsoluteURL: /DesktopModules/Gallery/Popup/popupdata.aspx
AbsoluteURLReferrer: http://www.peermomentum.com/DesktopModules/Gallery/Popup/PopupSelectSingle.aspx?datasource=gallery&objectclasses=101&tabid=79&mid=0
UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; Media Center PC 4.0)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 01b08d1a-ed2d-4d45-af31-7bd54f0bf7fd
InnerException: Unhandled Error:
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: System.Exception: Unhandled Error: ---> System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Data.SqlClient.SqlException: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_ModuleSettings_Modules'. The conflict occurred in database 'peermomentumcom', 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.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.Gallery.PopupControls.PopupGalleryData..ctor(PopupData Popup) at DotNetNuke.Modules.Gallery.PopupControls.PopupData.CreateObject() at DotNetNuke.Modules.Gallery.PopupControls.PopupData.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at DotNetNuke.Modules.Gallery.PopupControls.PopupControl.EnsureChildControls() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.desktopmodules_gallery_popup_popupdata_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --- End of inner exception stack trace ---
Source:
Server Name: SCI-1-1

---

Vesrion 4.09.02 (03/13/2009)

Learning how to best support the PeerMomentum.com community with DNN. Please contact me if you know of any good stable and skinable social networking/user profile modules.

Thank you all for the great contribution!

Yep.. Those are 2 of the bugs in the beta gallery module. 

The first is with the module ID not being loaded correctly on the lookup screen.  The fix for this was to patch the ControlLookup.ascx.vb  Page_load event to load the module ID, with code like:

 

If ModuleID = 0 AndAlso Not Request.QueryString("mid") Is Nothing Then

ModuleID = Int16.Parse(Request.QueryString(

 

"mid"))End If

Then in the actual code that looks up the download roles to determine if the person has access, there was a bug where it was trying to lookup the roles by the ID, but DNN required it to be by name.  So you need to convert the ID to a name, and then check it.  This fix was in the config.vb  HasDownloadPermission() function.