API tools faq
paste
Guest User

Upgrade Error Log

a guest
May 1st, 2012
50
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.59 KB | None | 0 0
raw download clone embed print report
  1. System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.CTN_PortalDesktopModules' that match the referencing column list in the foreign key 'FK_CTN_DesktopModulePermission_CTN_PortalDesktopModules'.
  2. Could not create constraint. See previous errors.
  3. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
  4. at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
  5. at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
  6. at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
  7. at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
  8. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
  9. at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
  10. at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
  11.  
  12.  
  13.  
  14. /* Add DesktopModulePermission Table */
  15. /*************************************/
  16.  
  17. IF NOT EXISTS (select * from dbo.sysobjects where id = object_id(N'dbo.[CTN_DesktopModulePermission]') and OBJECTPROPERTY(id, N'IsTable') = 1)
  18. BEGIN
  19. CREATE TABLE dbo.[CTN_DesktopModulePermission]
  20. (
  21. [DesktopModulePermissionID] [int] IDENTITY(1,1) NOT NULL,
  22. [PortalDesktopModuleID] [int] NOT NULL,
  23. [PermissionID] [int] NOT NULL,
  24. [AllowAccess] [bit] NOT NULL,
  25. [RoleID] [int] NULL,
  26. [UserID] [int] NULL,
  27. CONSTRAINT [PK_CTN_DesktopModulePermission] PRIMARY KEY CLUSTERED ([DesktopModulePermissionID] ASC),
  28. CONSTRAINT [IX_CTN_DesktopModulePermission] UNIQUE NONCLUSTERED ( [PortalDesktopModuleID] ASC, [PermissionID] ASC, [RoleID] ASC, [UserID] ASC )
  29. ) ON [PRIMARY]
  30.  
  31. ALTER TABLE dbo.[CTN_DesktopModulePermission]
  32. ADD CONSTRAINT [FK_CTN_DesktopModulePermission_CTN_PortalDesktopModules] FOREIGN KEY([PortalDesktopModuleID]) REFERENCES dbo.[CTN_PortalDesktopModules] ([PortalDesktopModuleID]) ON DELETE CASCADE
  33.  
  34. ALTER TABLE dbo.[CTN_DesktopModulePermission]
  35. ADD CONSTRAINT [FK_CTN_DesktopModulePermission_CTN_Permission] FOREIGN KEY([PermissionID]) REFERENCES dbo.[CTN_Permission] ([PermissionID]) ON DELETE CASCADE
  36. ALTER TABLE dbo.[CTN_DesktopModulePermission]
  37. ADD CONSTRAINT [FK_CTN_DesktopModulePermissionCTN_Users] FOREIGN KEY([UserID]) REFERENCES dbo.[CTN_Users] ([UserID])
  38. END
  39.  
  40.  
  41. System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.CTN_Portals' that match the referencing column list in the foreign key 'FK_CTN_PortalSettings_CTN_Portals'.
  42. Could not create constraint. See previous errors.
  43. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
  44. at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
  45. at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
  46. at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
  47. at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
  48. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
  49. at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
  50. at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
  51.  
  52.  
  53.  
  54. /* Add PortalSettings Table */
  55. /****************************/
  56.  
  57. IF NOT EXISTS (select * from dbo.sysobjects where id = object_id(N'dbo.[CTN_PortalSettings]') and OBJECTPROPERTY(id, N'IsTable') = 1)
  58. BEGIN
  59. CREATE TABLE dbo.[CTN_PortalSettings]
  60. (
  61. [PortalID] [int] NOT NULL,
  62. [SettingName] [nvarchar](50) NOT NULL,
  63. [SettingValue] [nvarchar](2000) NOT NULL,
  64. CONSTRAINT [PKCTN_PortalSettings] PRIMARY KEY CLUSTERED ( [PortalID] ASC, [SettingName] ASC )
  65. )
  66.  
  67. ALTER TABLE dbo.CTN_PortalSettings
  68. ADD CONSTRAINT FK_CTN_PortalSettings_CTN_Portals FOREIGN KEY ( PortalID ) REFERENCES dbo.CTN_Portals ( PortalID ) ON DELETE CASCADE
  69. END
  70.  
  71.  
  72. System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.CTN_Portals' that match the referencing column list in the foreign key 'FK_CTN_PortalLanguages_CTN_Portals'.
  73. Could not create constraint. See previous errors.
  74. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
  75. at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
  76. at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
  77. at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
  78. at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
  79. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
  80. at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
  81. at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
  82.  
  83.  
  84.  
  85. /* Add PortalLanguages Table */
  86. /*****************************/
  87.  
  88. IF NOT EXISTS (select * from dbo.sysobjects where id = object_id(N'dbo.[CTN_PortalLanguages]') and OBJECTPROPERTY(id, N'IsTable') = 1)
  89. BEGIN
  90. CREATE TABLE dbo.[CTN_PortalLanguages]
  91. (
  92. [PortalLanguageID] [int] IDENTITY(1,1) NOT NULL,
  93. [PortalID] [int] NOT NULL,
  94. [LanguageID] [int] NOT NULL,
  95. CONSTRAINT [PK_CTN_PortalLanguages] PRIMARY KEY CLUSTERED ( [PortalLanguageID] ASC )
  96. )
  97.  
  98. ALTER TABLE dbo.[CTN_PortalLanguages] WITH CHECK
  99. ADD CONSTRAINT [FK_CTN_PortalLanguages_CTN_PortalLanguages] FOREIGN KEY([LanguageID]) REFERENCES dbo.[CTN_Languages] ([LanguageID]) ON DELETE CASCADE
  100.  
  101. ALTER TABLE dbo.[CTN_PortalLanguages] WITH CHECK
  102. ADD CONSTRAINT [FK_CTN_PortalLanguages_CTN_Portals] FOREIGN KEY([PortalID]) REFERENCES dbo.[CTN_Portals] ([PortalID]) ON DELETE CASCADE
  103.  
  104. CREATE UNIQUE NONCLUSTERED INDEX IX_CTN_PortalLanguages ON dbo.CTN_PortalLanguages ( PortalID, LanguageID )
  105. END
  106.  
  107.  
  108. System.Data.SqlClient.SqlException: 'PK_EventLogMaster' is not a constraint.
  109. Could not drop constraint. See previous errors.
  110. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
  111. at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
  112. at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
  113. at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
  114. at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
  115. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
  116. at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
  117. at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
  118.  
  119.  
  120.  
  121. /* Fix OobjectQualifier for PK_EventLogMaster */
  122. /**********************************************/
  123.  
  124. ALTER TABLE dbo.CTN_EventLog
  125. DROP CONSTRAINT PK_EventLogMaster
  126.  
  127. ALTER TABLE dbo.CTN_EventLog
  128. ADD CONSTRAINT PK_CTN_EventLog PRIMARY KEY CLUSTERED ( LogGUID )
  129.  
  130.  
  131. System.Data.SqlClient.SqlException: 'FK_CTN_EventLog_CTN_EventLogTypes' is not a constraint.
  132. Could not drop constraint. See previous errors.
  133. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
  134. at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
  135. at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
  136. at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
  137. at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
  138. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
  139. at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
  140. at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
  141.  
  142.  
  143.  
  144. /* Fix OobjectQualifier for PK_EventLogTypes */
  145. /**********************************************/
  146.  
  147. ALTER TABLE dbo.CTN_EventLog
  148. DROP CONSTRAINT FK_CTN_EventLog_CTN_EventLogTypes
  149. ALTER TABLE dbo.CTN_EventLogConfig
  150. DROP CONSTRAINT FK_CTN_EventLogConfig_CTN_EventLogTypes
  151. ALTER TABLE dbo.CTN_EventLogTypes
  152. DROP CONSTRAINT PK_EventLogTypes
  153. ALTER TABLE dbo.CTN_EventLogTypes
  154. ADD CONSTRAINT PK_CTN_EventLogTypes PRIMARY KEY CLUSTERED ( LogTypeKey )
  155. ALTER TABLE dbo.CTN_EventLogConfig
  156. ADD CONSTRAINT FK_CTN_EventLogConfig_CTN_EventLogTypes1 FOREIGN KEY ( LogTypeKey ) REFERENCES dbo.CTN_EventLogTypes ( LogTypeKey ) ON UPDATE NO ACTION ON DELETE NO ACTION
  157. ALTER TABLE dbo.CTN_EventLog
  158. ADD CONSTRAINT FK_CTN_EventLog_CTN_EventLogTypes1 FOREIGN KEY ( LogTypeKey ) REFERENCES dbo.CTN_EventLogTypes ( LogTypeKey ) ON UPDATE NO ACTION ON DELETE NO ACTION
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!