Fresh install of DNN 5.6 on 2008R2 with an SQL 2008 DB. Filestore was permission to allow modify by NETWORK SERVICE account, and default app pool changed to use default service account, which was also granted DBO to the database.
Changed IIS default web-site filestore path to point to DNN folders.
Visit the site, and the install wizard runs and completes with no errors. However, after loggist on as host, and attempt to edit the portal created during the install gives this error, followed by 3 knock-on errors. I also cannot create any new Portals:
AssemblyVersion: 5.6.0
PortalID: 0
PortalName: Elsbunny
UserID: 1
UserName: RedSix
ActiveTabID: 17
ActiveTabName: Portals
RawURL: /Host/Portals/tabid/17/ctl/Edit/mid/321/pid/0/portalid/0/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://localhost/Host/Portals/tabid/17/portalid/0/Default.aspx
UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; .NET4.0C; .NET4.0E)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 905c158d-fa78-4e2c-ac7a-42eaf789c30e
InnerException: Violation of UNIQUE KEY constraint 'IX_DNN_FolderPath'. Cannot insert duplicate key in object 'dbo.DNN_Folders'. The statement has been terminated.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'IX_DNN_FolderPath'. Cannot insert duplicate key in object 'dbo.DNN_Folders'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddFolder(Int32 PortalID, Guid UniqueId, Guid VersionGuid, String FolderPath, Int32 StorageLocation, Boolean IsProtected, Boolean IsCached, DateTime LastUpdated, Int32 createdByUserID) at DotNetNuke.Services.FileSystem.FolderController.AddFolder(FolderInfo folder) at DotNetNuke.Common.Utilities.FileSystemUtils.AddFolder(Int32 PortalId, String relativePath, Int32 StorageLocation) at DotNetNuke.Common.Utilities.FileSystemUtils.AddUserFolder(PortalSettings _PortalSettings, String parentFolder, Int32 StorageLocation, Int32 UserID) at DotNetNuke.Common.Utilities.FileSystemUtils.GetFoldersByUser(Int32 PortalID, Boolean IncludeSecure, Boolean IncludeDatabase, String Permissions) at DotNetNuke.Web.UI.WebControls.DnnFilePicker.LoadFolders() at DotNetNuke.Web.UI.WebControls.DnnFilePicker.AddFolderRow() at DotNetNuke.Web.UI.WebControls.DnnFilePicker.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Control.AddedControl(Control control, Int32 index) at DotNetNuke.UI.Modules.ModuleHost.InjectModuleContent(Control content) at DotNetNuke.UI.Modules.ModuleHost.LoadUpdatePanel() at DotNetNuke.UI.Modules.ModuleHost.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at DotNetNuke.UI.Containers.Container.get_ModuleControl() at DotNetNuke.UI.Containers.Container.ProcessModule() at DotNetNuke.UI.Skins.Pane.InjectModule(ModuleInfo objModule)
|