Hello all,

I upgraded my app from 3.2.2 to 3.3.7. I got the following error in the upgrade log:

03.02.03.log:

/***************************************************************

System.Data.SqlClient.SqlException:

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_GSW_Files_GSW_Folders". The conflict occurred in database "GSW", table "dbo.GSW_Folders", column 'FolderID'.

ALTER TABLE dbo.GSW_Files ADD CONSTRAINT
 FK_GSW_Files_GSW_Folders FOREIGN KEY
 (FolderID) REFERENCES dbo.GSW_Folders (FolderID)

************************************************************/

I then ran the following statement to verify any integrity  inconsistencies:

SELECT  
  A.*,
  B.FolderID

FROM  GSW_Files AS A

LEFT JOIN GSW_Folders AS B
ON   A.FolderID = B.FolderId

WHERE  B.FolderID IS NULL; 

I discovered that the Files table has several records where FolderID = 0. However the Folders table does not have any record where FolderID = 0.

There are abviously files that are not "part" of a folder. What does this imply about my app?

How can it be fixed?

Thanks