Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Critical Errors on File Manager...Critical Errors on File Manager...
Previous
 
Next
New Post
10/13/2011 10:19 AM
 
CBOSS Inc.


Joined: 3/31/2010
Posts: 466
I have a site with DNN 5.6.3 - Having a lot of issues with the file manager...

When I try to Synchronize the files... it can be set to recursive or not I will get the following error:

A critical error has occurred.
The DELETE statement conflicted with the REFERENCE constraint "FK_DNN_Files_DNN_Folders". The conflict occurred in database "DNN_OUPS", table "dbo.DNN_Files", column 'FolderID'. The statement has been terminated.

This is an issue because when I drag a new folder to the site root on my server - I cannot see it here unless I can sync the folders. I have tried resetting the application, I have cleared my cache and even reset IIS.

Why am I getting this error? It was also doing odd things before where it would duplicate sub folders in the file manager... they were not showing up on the server so I could not delete them in DNN (they did not actually exist.

Can I delete the file table in the database and have the site resync with the fie structure on the web server? Seems like there is something wrong.

Any help would be greatly appreciated.
 
New Post
10/14/2011 4:29 AM
 
cathal connolly


cathal connolly's Avatar

www.cathal.co.uk
Joined: 4/9/2003
Posts: 9676
hello,
it would appear that you have something breaking referential integrity - i would recommend you check for the folders table for identically named folders (i have seen an issue where a folder was in as "cathal/" and "cathal" - folders should end in a / so the "cathal" without caused the issue, removing it resolved)

If there is nothing apparent there then you will need to check the database query to see what breaks the referential integrity i.e. write a query from files to folders (a left outer join) to see if a file has a folderid that does not exist - if you find some delete the records.

Finally, I would be way about clearing out the files table as there are entries that are used by the host and other portals - and you may also break linkclick links to files.
Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
10/14/2011 3:11 PM
 
CBOSS Inc.


Joined: 3/31/2010
Posts: 466
The trailing slash issue was the culprti.. all is fixed now! Thanks!
 
 Page 1 of 1
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Critical Errors on File Manager...Critical Errors on File Manager...


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