We are having 2 issues with the file manager:

1. When we upload a zip with the a folder structure in the zip that matches the location it will be decompressed we get the error:
"The INSERT statement conflicted with the FOREIGN KEY constraint "FK_FolderPermission_Folders". The conflict occurred in database "PfDNN2", table "dbo.Folders", column 'FolderID'. The statement has been terminated."

Our clients want to be able to upload updates to a particular directory structure, so they are uploading zips with new files in a matching structure hoping to add the files to the existing structure, but get the above error.

2. In Firefox, when you expand your folder selection on the left longer than the area of the file manager the file manager does not grow to allow you to see the expanded files. IE this behavior works fine.

Thanks in advance.

4.5.1

Hi All,

RAD Upload consistently reproduces this error too. I am on 4.53. Here's the error. Did anyone find any resolution to this yet? I'll post if I find one.

Dave Gerding

 

DotNetNuke.Services.Exceptions.ModuleLoadException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_FolderPermission_Folders". The conflict occurred in database "Vroom1.5", table "dbo.Folders", column 'FolderID'. The statement has been terminated. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_FolderPermission_Folders". The conflict occurred in database "Vroom1.5", table "dbo.Folders", column 'FolderID'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.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.Common.Utilities.FileSystemUtils.SetFolderPermissions(Int32 PortalId, Int32 FolderId, String relativePath) at DotNetNuke.Common.Utilities.FileSystemUtils.AddFolder(Int32 PortalId, String relativePath, Int32 StorageLocation) at DotNetNuke.Common.Utilities.FileSystemUtils.AddFolder(PortalSettings _PortalSettings, String parentFolder, String newFolder, Int32 StorageLocation) at Telerik.DNN.Modules.RadUpload.RadUpload.CreateFolder(String path, String folder) at Telerik.DNN.Modules.RadUpload.RadUpload.GetUploadPath() at Telerik.DNN.Modules.RadUpload.RadUpload.btnSubmit_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---