I tried the file manager sync (recursive) for syncronising ftp files with dnn
it didnt work and gave me the following error
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_FolderPermission_Folders'. The conflict occurred in database 'DB_xxxxx', table 'Folders', column 'FolderID'. The statement has been terminated.
Then i checked update logs and find the following issue under 4.03.03 log
Pls help me
System.Data.SqlClient.SqlException: ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_ProfilePropertyDefinition_Portals'. The conflict occurred in database 'DB_xxxx', table 'Portals', column 'PortalID'.
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 NOT EXISTS ( SELECT * FROM sysobjects WHERE id = object_id(N'FK_ProfilePropertyDefinition_Portals') AND OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE dbo.ProfilePropertyDefinition
ADD CONSTRAINT FK_ProfilePropertyDefinition_Portals FOREIGN KEY (PortalID) REFERENCES dbo.Portals (PortalID) ON DELETE CASCADE