Hello, I attempted a test upgrade of my 4.0.3 site to 4.3.5 and had 2 apparently related errors in 2 different SQL upgrade scripts. Before I attempt to resolve, I am wondering if anyone else has seen the same or similar error and what a possible resolution is.

In the 04.00.04.log file it indicates an error altering the Folders table

System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_{objectqualifier}Files_{objectqualifier}Folders". The conflict occurred in database "DBName", table "dbo.{objectqualifier}Folders", column 'FolderID'.

Using this SQL:

If (SELECT {databaseOwner}{objectQualifier}fn_GetVersion(3,2,3)) = 0
 BEGIN
  ALTER TABLE {databaseOwner}{objectQualifier}Files ADD CONSTRAINT
   FK_{objectQualifier}Files_{objectQualifier}Folders FOREIGN KEY
   (
   FolderID
   ) REFERENCES {databaseOwner}{objectQualifier}Folders
   (
   FolderID
   )
 END

And in the 4.03.01 log:

System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_{objectqualifier}Files_{objectqualifier}Folders". The conflict occurred in database "DBName", table "dbo.{objectqualifier}Folders", column 'FolderID'.

Using this SQL:

/* This tries to apply a foreign key on the files/folders tables */
/*****************************************************************/

IF NOT EXISTS ( SELECT * FROM sysobjects WHERE id = object_id(N'FK_{objectQualifier}Files_{objectQualifier}Folders') AND OBJECTPROPERTY(id, N'IsForeignKey') = 1)
 BEGIN
  ALTER TABLE {databaseOwner}{objectQualifier}Files ADD CONSTRAINT
   FK_{objectQualifier}Files_{objectQualifier}Folders FOREIGN KEY
   (
   FolderID
   ) REFERENCES {databaseOwner}{objectQualifier}Folders
   (
   FolderID
   )
 END

Any thoughts or recommendations are appreciated.

Thank you,

Rob Ralston

---

Rob Ralston, SilverBullet Technologies LLC, www.silverbullettech.com

G'day Rob.
Yes I just did the same upgrade yesterday and got the same errors?
e.g. 04.00.04.log

---

System.Data.SqlClient.SqlException: ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_Files_Folders'. The conflict occurred in database 'DNN_SmartSpeak_Dev', table 'Folders', column 'FolderID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
   at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)

If (SELECT dbo.fn_GetVersion(3,2,3)) = 0
    BEGIN
        ALTER TABLE dbo.Files ADD CONSTRAINT
            FK_Files_Folders FOREIGN KEY
            (
            FolderID
            ) REFERENCES dbo.Folders
            (
            FolderID
            )
    END

---

I have only upgraded my development site.
Did you find a fix and do the errors stop any parts of the site from working? I don't want to upgrade my prodution site if the errors will bring it down.

Anyone else encountered this problem?

I logged this into Gemini: http://support.dotnetnuke.com/issue/ViewIssue.aspx?id=4165

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN