Hi I am having a bit of different problem with the Install Template while running the Site Wizard.  When I run it on 4.5.1 and higher I get the following error

DotNetNuke.Services.Exceptions.PageLoadException: Violation of UNIQUE KEY constraint 'IX_FolderPermission'. Cannot insert duplicate key in object 'dbo.FolderPermission'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_FolderPermission'. Cannot insert duplicate key in object 'dbo.FolderPermission'. 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.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(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)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.AddFolderPermission(Int32 FolderID, Int32 PermissionID, Int32 roleID, Boolean AllowAccess, Int32 UserID)at DotNetNuke.Security.Permissions.FolderPermissionController.AddFolderPermission(FolderPermissionInfo objFolderPermission)at DotNetNuke.Common.Utilities.FileSystemUtils.SetFolderPermission(Int32 PortalId, Int32 FolderId, Int32 PermissionId, Int32 RoleId, String relativePath)at DotNetNuke.Entities.Portals.PortalController.ParseFolderPermissions(XmlNodeList nodeFolderPermissions, Int32 PortalID, Int32 FolderId, String folderPath)at DotNetNuke.Entities.Portals.PortalController.ParseFolders(XmlNode nodeFolders, Int32 PortalId)at DotNetNuke.Entities.Portals.PortalController.ParseTemplate(Int32 PortalId, String TemplatePath, String TemplateFile, Int32 AdministratorId, PortalTemplateModuleAction mergeTabs, Boolean IsNewPortal)at DotNetNuke.Modules.Admin.PortalManagement.SiteWizard.Wizard_FinishButtonClick(Object sender, WizardNavigationEventArgs e)at System.Web.UI.WebControls.Wizard.OnFinishButtonClick(WizardNavigationEventArgs e)at System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e)at System.Web.UI.WebControls.Wizard.WizardChildTable.OnBubbleEvent(Object source, EventArgs args)at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)at System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e)at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)--- End of inner exception stack trace ---

However, when I do the same install on 4.5.0 it works ok!  Could you help me with that?

I just got the same on my 4.8.1

Violation of UNIQUE KEY constraint 'IX_FolderPermission'. Cannot insert duplicate key in object 'FolderPermission'. The statement has been terminated.

I added a folder then added permisions for a user

Ok the issue is with the security around the root folder when using sql database file system. Before you can give a user access to a submenu they have to have access to the above folder tree. So if your adding a file to portal root/<foldername> Then the person your adding has to have access to the portal root folder before you can give them access to the below subfolders.