I could not find the log file 04.05.00. The last log file was 04.04.00 log. I assume when I it was errased when I went back to version 4.4.

Dumb question: How do you read the log file. I did not find any place in DNN so I used a file manager from my ISP (webhost4life), but when I tried to open the file it would not open.

John

I reinstalled DNN 4.5.1 and here is the Log file for 4.5.0. We would really appreciate any help.

Thanks, John

System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.Users' that match the referencing column list in the foreign key 'FK_TabPermission_Users'.
Could not create constraint. See previous errors.
   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 COLUMNPROPERTY( OBJECT_ID('dbo.[TabPermission]'),'UserID','AllowsNull')) IS Null
 BEGIN
  ALTER TABLE dbo.[TabPermission] ADD
   UserID int NULL

  ALTER TABLE dbo.TabPermission WITH NOCHECK ADD CONSTRAINT
   FK_TabPermission_Users FOREIGN KEY
   (
   UserID
   ) REFERENCES dbo.Users
   (
   UserID
   ) NOT FOR REPLICATION
 END

System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.Users' that match the referencing column list in the foreign key 'FK_ModulePermissionUsers'.
Could not create constraint. See previous errors.
   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 COLUMNPROPERTY( OBJECT_ID('dbo.[ModulePermission]'),'UserID','AllowsNull')) IS Null
 BEGIN
  ALTER TABLE dbo.[ModulePermission] ADD
   UserID int NULL

  ALTER TABLE dbo.ModulePermission WITH NOCHECK ADD CONSTRAINT
   FK_ModulePermissionUsers FOREIGN KEY
   (
   UserID
   ) REFERENCES dbo.Users
   (
   UserID
   ) NOT FOR REPLICATION
 END

System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.Users' that match the referencing column list in the foreign key 'FK_FolderPermissionUsers'.
Could not create constraint. See previous errors.
   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 COLUMNPROPERTY( OBJECT_ID('dbo.[FolderPermission]'),'UserID','AllowsNull')) IS Null
 BEGIN
  ALTER TABLE dbo.[FolderPermission] ADD
   UserID int NULL

  ALTER TABLE dbo.FolderPermission WITH NOCHECK ADD CONSTRAINT
   FK_FolderPermissionUsers FOREIGN KEY
   (
   UserID
   ) REFERENCES dbo.Users
   (
   UserID
   ) NOT FOR REPLICATION
 END