Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Install problem - Violation of UNIQUE KEY
leafshore
#1 Posted : Sunday, 14 August 2011 6:28:28 AM(UTC)
Rank: Newbie

Joined: 14/08/2011(UTC)
Posts: 1

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
Roger Martin
#2 Posted : Monday, 15 August 2011 11:30:26 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI

Considering that others are able to install it, you must be doing something atypical, but off the top of my head I don't know what that would be. About the best I can suggest is to carefully review the install instructions to verify you are following them exactly.

If you are still stuck, provide detailed repro steps so that I can try to reproduce the issue.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Rss Feed  Atom Feed
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.