Hi
I am trying to install Gallery Server pro on a Windows 2003 SP2 server with SQL Express 2008 R2.
When I run the install guide against the SQL express I always get:
Violation of UNIQUE KEY constraint 'UC_gs_MimeType_FileExtension'. Cannot insert duplicate key in object 'dbo.gs_MimeType'. The statement has been terminated.
on the SQL query:
/* Table gs_MimeType */
INSERT INTO dbo.[gs_MimeType] ([FileExtension], [MimeTypeValue], [BrowserMimeTypeValue]) VALUES ('.afl','video/animaflex',''); INSERT INTO dbo.[gs_MimeType] ([FileExtension], [MimeTypeValue], [BrowserMimeTypeValue]) VALUES ('.aif','audio/aiff','');
INSERT INTO dbo.[gs_MimeType] ([FileExtension], [MimeTypeValue], [BrowserMimeTypeValue]) VALUES ('.aifc','audio/aiff','')....
The table gs_MimeType is updated with the values so to me it seems like it tries to do the updates twise. After this error I can't go any further.
I have tried severar times with new and empty databases but with no luck.
How do I get around or through this problem?
/Thomas