Re: [Rainbowportal-devel] Upgrade blues

[Emmanuele De A. <ma...@gm...>]

Need to double check that contrain does not existis, it tries to add it 2 t=
imes.
Please fix it and commit the fix.
See other scripts... search for  ALTER TABLE....
A good one is latest articles module on dev.
Manu


On 6/27/05, Ed Daniel <ra...@es...> wrote:
> =20
> =20
>=20
> Hi list,=20
>=20
>  =20
>=20
> Has anyone seen & hopefully fixed this problem when upgrading to either 1=
791
> (as per below) or 1807:=20
>=20
>  =20
>=20
> 2005-06-27 14:26:08,851 24687 [2396] WARN  Rainbow  - ExecuteScript Faile=
d:
> ALTER TABLE [rb_BlogStats] ADD=20
>=20
>             CONSTRAINT [FK_rb_BlogStats_rb_Modules] FOREIGN KEY=20
>=20
>             (=20
>=20
>                         [ModuleID]=20
>=20
>             ) REFERENCES [rb_Modules] (=20
>=20
>                         [ModuleID]=20
>=20
>             ) ON DELETE CASCADE=20
>=20
> Exception: System.Data.SqlClient.SqlException=20
>=20
> Message: ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constra=
int
> 'FK_rb_BlogStats_rb_Modules'. The conflict occurred in database
> 'rb.staging', table 'rb_Modules', column 'ModuleID'.=20
>=20
> Source: .Net SqlClient Data Provider=20
>=20
>    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()=20
>=20
>    at Rainbow.Helpers.DBHelper.ExecuteScript(String
> scriptPath, SqlConnection myConnection, Boolean useTransaction)=20
>=20
>  =20
>=20
> 2005-06-27 14:26:08,866 24703 [2396] WARN  Rainbow  - Exception in
> UpdateDatabaseCommand installing module:
> C:\**********\rb.staging\Rainbow15Release\DesktopModules\Blog\install.xml
>=20
> Exception: System.Exception=20
>=20
> Message: Error occurred:<P>ALTER TABLE statement conflicted with COLUMN
> FOREIGN KEY constraint 'FK_rb_BlogStats_rb_Modules'. The conflict occurre=
d
> in database 'longterm.staging', table 'rb_Modules', column
> 'ModuleID'.<br>ALTER TABLE [rb_BlogStats] ADD=20
>=20
>             CONSTRAINT [FK_rb_BlogStats_rb_Modules] FOREIGN KEY=20
>=20
>             (=20
>=20
>                         [ModuleID]=20
>=20
>             ) REFERENCES [rb_Modules] (=20
>=20
>                         [ModuleID]=20
>=20
>             ) ON DELETE CASCADE</P>=20
>=20
> Source: Rainbow.Modules.Blog=20
>=20
>    at Rainbow.DesktopModules.Blog.Install(IDictionary
> stateSaver)=20
>=20
>    at Rainbow.Helpers.ModuleInstall.Install(String
> friendlyName, String desktopSource, String mobileSource, Boolean install)=
=20
>=20
>  =20
>=20
>  =20
>=20
> Ed.=20
>=20
>