When I try to assign a new owner to a private Gallery I get an error message after doing the lookup. The error message is as follows:
Server Error in '/us' Application
Runtime Error
Description: An application error occured on the server. The current custom error settings for this application prevent blah blah blah.
From the Logs the details are as follows:
AssemblyVersion: 04.03.04
PortalID: 0
PortalName: Global Data Resource Management Group
UserID: 1
UserName: host
ActiveTabID: 65
ActiveTabName: Craig Irvin's Blog
RawURL: /us/DesktopModules/Gallery/Popup/popupdata.aspx?datasource=gallery&objectclasses=101&tabid=65&mid=0&objectclass=101&location=&searchvalue=craig.irvin
AbsoluteURL: /us/DesktopModules/Gallery/Popup/popupdata.aspx
AbsoluteURLReferrer: https://www.gdrmg.com/us/DesktopModules/Gallery/Popup/PopupSelectSingle.aspx?datasource=gallery&objectclasses=101&tabid=65&mid=0
UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 1.1.4322)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 10e04492-325b-48db-b03f-1d894fba0c82
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_dnn_ModuleSettings_dnn_Modules'. The conflict occurred in database 'DB_83847', table 'dnn_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: WHECNSSL03
To help troubleshoot as much as possible I tried the following:
1. Tried FireFox to see if it might be a IE issue but I'm not even able to click on the Lookup Icon.
2. Removed the Gallery from Module Definitions and readded it.
3. Downgraded from Gallery 3.0.12 to 3.0.11, which made things worse =)
Thanks for the help in advance,
Craig Irvin