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...Upgrading DNN P...Upgrading DNN P...Upgrade issue on SQL performing Upgrade from 5.6.3 to 6.0 (2982)Upgrade issue on SQL performing Upgrade from 5.6.3 to 6.0 (2982)
Previous
 
Next
New Post
7/25/2011 1:13 PM
 
Matthias Schlomann


Joined: 8/10/2003
Posts: 3594
I got this SQL exception running upgrade DNN 5.6.3 to 6.0.0 (2982).  The issue happends about a missing search if the object already exists. 


(I have translate the german error message to english)

System.Data.SqlClient.SqlException (0x80131904): The object with the name 'FK_Files_Folders' allready exists on the Database.
The Foringkey could not be created. See below errors:
   bei System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
   bei System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
   bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   bei System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   bei DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   bei DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)



ALTER TABLE djhundi1963.[Files] ADD
 CONSTRAINT [FK_Files_Portals] FOREIGN KEY ([PortalId]) REFERENCES username.[Portals] ([PortalID]),
 CONSTRAINT [FK_Files_Folders] FOREIGN KEY ([FolderID]) REFERENCES username.[Folders] ([FolderID]) ON DELETE CASCADE




Regards
Matthias
DNN MVP
www.aarsys.de
Metro7 Skin
ShoutCastStats Module for DNN
 
New Post
7/25/2011 4:38 PM
 
Ash Prasad

Ash Prasad's Avatar

Joined: 9/18/2009
Posts: 310
Someone else also reported the same issue. Please have a read. I am not sure what the root cause is though.
Ash Prasad
Director of Engineering
DNN Corp.
 
New Post
7/26/2011 5:19 AM
 
Matthias Schlomann


Joined: 8/10/2003
Posts: 3594
Hi Ash,

thanks for the link t the other reported issue.  I asume that it could be happend with the Parallels Plesk, about I have also installed Plesk V. 10.2.  I want to be look over this issue on my maschine and into the T-SQL script to become more info about this issue.

Best regards

Matthias
Regards
Matthias
DNN MVP
www.aarsys.de
Metro7 Skin
ShoutCastStats Module for DNN
 
 Page 1 of 1
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...Upgrade issue on SQL performing Upgrade from 5.6.3 to 6.0 (2982)Upgrade issue on SQL performing Upgrade from 5.6.3 to 6.0 (2982)


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