Hi list,

 

Has anyone seen & hopefully fixed this problem when upgrading to either 1791 (as per below) or 1807:

 

2005-06-27 14:26:08,851 24687 [2396] WARN  Rainbow  - ExecuteScript Failed: ALTER TABLE [rb_BlogStats] ADD

            CONSTRAINT [FK_rb_BlogStats_rb_Modules] FOREIGN KEY

            (

                        [ModuleID]

            ) REFERENCES [rb_Modules] (

                        [ModuleID]

            ) ON DELETE CASCADE

Exception: System.Data.SqlClient.SqlException

Message: ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_rb_BlogStats_rb_Modules'. The conflict occurred in database 'rb.staging', table 'rb_Modules', column 'ModuleID'.

Source: .Net SqlClient Data Provider

   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   at Rainbow.Helpers.DBHelper.ExecuteScript(String scriptPath, SqlConnection myConnection, Boolean useTransaction)

 

2005-06-27 14:26:08,866 24703 [2396] WARN  Rainbow  - Exception in UpdateDatabaseCommand installing module: C:\**********\rb.staging\Rainbow15Release\DesktopModules\Blog\install.xml

Exception: System.Exception

Message: Error occurred:<P>ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_rb_BlogStats_rb_Modules'. The conflict occurred in database 'longterm.staging', table 'rb_Modules', column 'ModuleID'.<br>ALTER TABLE [rb_BlogStats] ADD

            CONSTRAINT [FK_rb_BlogStats_rb_Modules] FOREIGN KEY

            (

                        [ModuleID]

            ) REFERENCES [rb_Modules] (

                        [ModuleID]

            ) ON DELETE CASCADE</P>

Source: Rainbow.Modules.Blog

   at Rainbow.DesktopModules.Blog.Install(IDictionary stateSaver)

   at Rainbow.Helpers.ModuleInstall.Install(String friendlyName, String desktopSource, String mobileSource, Boolean install)

 

 

Ed.