Products

Solutions

Resources

Partners

Community

About

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 ForumsGalleryGalleryCannot insert duplicate key in object Cannot insert duplicate key in object 'dbo.Folders'.
Previous
 
Next
New Post
8/30/2010 6:18 PM
 
The gallery seems to work OK except that every time someone starts the page it is on, an event is logged. The highlights of this event are:

Message: System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_FolderPath'. Cannot insert duplicate key in object 'dbo.Folders'. The statement has been terminated. at...DotNetNuke.Common.Utilities.FileSystemUtils.AddFolder(PortalSettings _PortalSettings, String parentFolder, String newFolder) at DotNetNuke.Modules.Gallery.GalleryFolder.CreateRootFolders(String albumURL, Boolean addSourceAndThumb)

The database table "Folders" looks OK for this portal so far as I can see.
Can anyone tell me what folders it keeps trying to create?
Or, how to get rid of this error?
Or, what information you need to further consider this?
Thanks.
 
New Post
8/30/2010 6:42 PM
 
Although you did not indicate which version of DotNetNuke you are running, I am assuming that it is the latest, 5.05.00. If so, this is known issue in both Gallery 04.03.00 and 04.03.01 RC due to a change in the core FolderController.AddFolder method which in earlier versions of DotNetNuke first performed a check to determine if the folder information had already been added to the database. I am hoping to post a 04.03.02 RC version of Gallery up on CodePlex late this week to correct this issue and a few other minor ones. In the meantime, there is no work around for this issue.

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
New Post
9/10/2010 5:45 AM
 
Hello Bill I am on 5.5.0 and getting the same error. I am wondering when we can expect the fix?

Regards
 
New Post
9/13/2010 3:01 AM
 
Hello Bill,
 
   I am on 5.5.0 and getting the same error. I am wondering when we can expect the fix?  I need to give soe feedback to a customer

Regards
Rhys
 
New Post
9/13/2010 2:39 PM
 
I have fixed the issues affecting compatibility with DNN 5.05.00 and am in the process of fixing a few minor issues that were entered earlier in the Gallery issue tracker. I hope to finish those, repackage a the 04.03.02 Beta version of the module, do some more testing and finally upload the new package to the CodePlex Gallery project downloads before tomorrow (Eastern time zone) morning. Note that this will be a beta release and should not be used on critical live production sites until it passes DotNetNuke core extension release testing.

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsGalleryGalleryCannot insert duplicate key in object Cannot insert duplicate key in object 'dbo.Folders'.


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