Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumNon-SuperUsers Unable to Upload Files in DNN ForumNon-SuperUsers Unable to Upload Files in DNN Forum
Previous
 
Next
New Post
12/7/2016 8:23 PM
 

Actually it is partially working.  I can upload a document for linking and if I navigate to my folder, I can upload files from there and from there add them to my post.  However, if I click on the image icon and try to do it from the Upload tab, I get the following:

 

Server Error in '/' Application.

Cannot insert duplicate key row in object 'dbo.FolderPermission' with unique index 'IX_FolderPermission_Roles'. The duplicate key value is (-1, 2122, 8).
The statement has been terminated.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.FolderPermission' with unique index 'IX_FolderPermission_Roles'. The duplicate key value is (-1, 2122, 8).
The statement has been terminated.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace: 

[SqlException (0x80131904): Cannot insert duplicate key row in object 'dbo.FolderPermission' with unique index 'IX_FolderPermission_Roles'. The duplicate key value is (-1, 2122, 8).
The statement has been terminated.]
   System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2442126
   System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5736904
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +628
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +3731
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +58
   System.Data.SqlClient.SqlDataReader.get_MetaData() +89
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +379
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +2026
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +375
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53
   System.Data.SqlClient.SqlCommand.ExecuteScalar() +271
   PetaPoco.Database.ExecuteScalar(String sql, Object[] args) +599
   DotNetNuke.Data.PetaPoco.PetaPocoHelper.ExecuteScalar(String connectionString, CommandType type, Int32 timeout, String sql, Object[] args) +95
   DotNetNuke.Data.SqlDataProvider.ExecuteScalar(String procedureName, Object[] commandParameters) +77
   DotNetNuke.Data.DataProvider.AddFolderPermission(Int32 folderId, Int32 permissionId, Int32 roleID, Boolean allowAccess, Int32 userId, Int32 createdByUserID) +237
   DotNetNuke.Security.Permissions.PermissionProvider.SaveFolderPermissions(IFolderInfo folder) +1035
   DotNetNuke.Security.Permissions.FolderPermissionController.SaveFolderPermissions(IFolderInfo folder) +21
   DNNConnect.CKEditorProvider.Browser.Browser.SetUserFolderPermission(IFolderInfo folderInfo, UserInfo currentUserInfo) +439
   DNNConnect.CKEditorProvider.Browser.Browser.GetUserFolderInfo(String startingDir) +436
   DNNConnect.CKEditorProvider.Browser.Browser.StartingDir() +160
   DNNConnect.CKEditorProvider.Browser.Browser.UploadFile(HttpPostedFile file, String command) +804
   DNNConnect.CKEditorProvider.Browser.Browser.Page_Load(Object sender, EventArgs e) +2870
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
   System.Web.UI.Control. (EventArgs e) +95
   System.Web.UI.Control.LoadRecursive() +59
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2952



Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.6.1085.0

 
New Post
12/8/2016 12:51 AM
 
Similar errors have been reported when upgrading older versions to 7+. Is this new or upgraded installation?

Solution appears to be that these entries have been manually deleted.
 
New Post
12/8/2016 12:31 PM
 

It is a new installation of DNN 8.0.3 with Forums 5.0.0.6.

I am at work right now (this site is a volunteer project I work on nights and weekends), so I can't do anything right now, but I will check the table, FolderPermission when I get home to see if something jumps out at me.  Thanks.

 
New Post
12/8/2016 2:59 PM
 
it is a known bug in DNN 8.0.x, you will encounter it as well, when browsing host > Extensions.
I submitted a fix for it, but am not sure, whether it has been accepted by DNN Corp. already.
The fix is also included in my TurboScripts.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
12/8/2016 4:00 PM
 

You come to my rescue again!  

I knew I should have stayed at 7.

I will look at this when I get home.  Thanks!


 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumNon-SuperUsers Unable to Upload Files in DNN ForumNon-SuperUsers Unable to Upload Files in DNN Forum


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out