mssql.initial.sql script has errors

[stuckinthemud]

I'm trying to get RC set up on MS SQL 2005 and having some issues with the script.

Firstly, the init DB button used during install doesn't seem to work, so the script needs to be run manually.

In some CREATEs, the "TEXTIMAGE_ON " statement is invalid as the appropriate column types don't exist.

The format of the FK creation is wrong.

Code Select Expand

ALTER TABLE [dbo].[contacts] ADD
    FOREIGN KEY ([FK_contacts_user_id]) REFERENCES [dbo].[users] ([user_id])
    ON DELETE CASCADE ON UPDATE CASCADE
GO
should be

Code Select Expand

ALTER TABLE [dbo].[contacts] ADD [FK_contacts_user_id]
    FOREIGN KEY ([user_id]) REFERENCES [dbo].[users] ([user_id])
    ON DELETE CASCADE ON UPDATE CASCADE
GO

Also the very last FK, which adds a second FK to contactgroupmembers, fails with a "may cause cycles or multiple cascade paths" error.



Does anyone have a script that works?


Appreciate that RC is strongly biased towards MySQL (as are most open source projects), but support is provided for MSSQL so would have hoped things would work.



Jim

[SKaero]

I think its been fixed in the SVN.

[alec]

Actually "may cause cycles or multiple cascade paths" issue is not fixed. It waits for some mssql guru.

[stuckinthemud]

I think its been fixed in the SVN.

Script works, but it's missing the tables [contactgroups] and [contactgroupmembers]. I've merged the old ad new versions and got a script that's working, so all OK at the moment



Jim

[iwayneo]

I am having issues with the mssql script too. I'll try and have a look. I'd have hoped that since the script is included in a stable build - it would be production ready?

If no one has already fixed this then I'll see what I can do.