I was wondering where the log file was, looked everywhere. Here it is:
System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_Files_Folders' in the database.
Could not create constraint. See previous errors.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
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)
ALTER TABLE nicebloke.[Files] ADD
CONSTRAINT [FK_Files_Portals] FOREIGN KEY ([PortalId]) REFERENCES nicebloke.[Portals] ([PortalID]),
CONSTRAINT [FK_Files_Folders] FOREIGN KEY ([FolderID]) REFERENCES nicebloke.[Folders] ([FolderID]) ON DELETE CASCADE
It is gobbledygook to me I am afraid. The dite seems to be working fine though. Thanks for you inputs.