I received an sql error when applying roles to the Gallery module.
Environment: VWD, Sql 2005 Express, Win 2K
(plus AngelOnlines modification)
Action:
1) Gallery Page > Configuration > +Feature Settings > Download Roles > Add/Remove iicon
This opens the "Gallery Data Lookup -- Web Page Dialog" window
Put anything or nothing in the Find text field > Press Go
The following error appears
AssemblyVersion:
04.00.02
Method:
System.Data.SqlClient.SqlConnection.OnError
FileName:
FileLineNumber: 0
FileColumnNumber: 0
PortalID:
0
PortalName: WannaSki
UserID: 1
UserName:
host
ActiveTabID: 55
ActiveTabName:
Gallery
AbsoluteURL:
/WannaSki/DesktopModules/Gallery/Popup/popupdata.aspx
AbsoluteURLReferrer:
http://localhost:4352/WannaSki/DesktopModules/Gallery/Popup/PopupSelectMulti.aspx?datasource=gallery&objectclasses=102&tabid=55&mid=0
ExceptionGUID:
cde80a5b-17c8-4112-b395-553704600476
DefaultDataProvider:
DotNetNuke.Data.SqlDataProvider,
DotNetNuke.SqlDataProvider
InnerException: Unhandled Error:
Message: System.Exception: Unhandled Error: --->
System.Web.HttpUnhandledException: Exception of type
'System.Web.HttpUnhandledException' was thrown. --->
System.Data.SqlClient.SqlException: The INSERT statement conflicted with the
FOREIGN KEY constraint "FK_ModuleSettings_Modules". The conflict occurred in
database "WannaSki", 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.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.PopupControl.CreateChildControls() 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
---
StackTrace:
Source:
Server Name:
COTTER-4B
|