|
innotech
-
10/22/2011 11:37:47 AM
Problem installing
Hello to everybody,
I easily installed kentico v5.5 r2 on my vps and everything went ok. Now I am trying to install the free version of Kentico 6 on the same server with the same settings and while creating the db schema, I get this error:
ERROR: An error occurred: [DataConnection.ExecuteQuery]: Query: CREATE TABLE [CMS_Avatar] ( [AvatarID] [int] IDENTITY(1, 1) NOT NULL, [AvatarName] [nvarchar](200) NULL, [AvatarFileName] [nvarchar](200) NOT NULL, [AvatarFileExtension] [nvarchar](10) NOT NULL, [AvatarBinary] [varbinary](max) NULL, [AvatarType] [nvarchar](50) NOT NULL, [AvatarIsCustom] [bit] NOT NULL, [AvatarGUID] [uniqueidentifier] NOT NULL, [AvatarLastModified] [datetime] NOT NULL, [AvatarMimeType] [nvarchar](100) NOT NULL, [AvatarFileSize] [int] NOT NULL, [AvatarImageHeight] [int] NULL, [AvatarImageWidth] [int] NULL, [DefaultMaleUserAvatar] [bit] NULL, [DefaultFemaleUserAvatar] [bit] NULL, [DefaultGroupAvatar] [bit] NULL, [DefaultUserAvatar] [bit] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] ALTER TABLE [CMS_Avatar] ADD CONSTRAINT [PK_CMS_Avatar] PRIMARY KEY NONCLUSTERED ([AvatarID]) WITH FILLFACTOR=80 ON [PRIMARY] ALTER TABLE [CMS_Avatar] ADD CONSTRAINT [DEFAULT_CMS_Avatar_DefaultFemaleUserAvatar] DEFAULT ((0)) FOR [DefaultFemaleUserAvatar] ALTER TABLE [CMS_Avatar] ADD CONSTRAINT [DEFAULT_CMS_Avatar_DefaultGroupAvatar] DEFAULT ((0)) FOR [DefaultGroupAvatar] ALTER TABLE [CMS_Avatar] ADD CONSTRAINT [DEFAULT_CMS_Avatar_DefaultMaleUserAvatar] DEFAULT ((0)) FOR [DefaultMaleUserAvatar] ALTER TABLE [CMS_Avatar] ADD CONSTRAINT [DEFAULT_CMS_Avatar_DefaultUserAvatar] DEFAULT ((0)) FOR [DefaultUserAvatar] CREATE NONCLUSTERED INDEX [IX_CMS_Avatar_AvatarGUID] ON [CMS_Avatar] ([AvatarGUID]) WITH ( FILLFACTOR = 80) ON [PRIMARY] CREATE CLUSTERED INDEX [IX_CMS_Avatar_AvatarName] ON [CMS_Avatar] ([AvatarName]) WITH ( FILLFACTOR = 80) ON [PRIMARY] CREATE NONCLUSTERED INDEX [IX_CMS_Avatar_AvatarType_AvatarIsCustom] ON [CMS_Avatar] ([AvatarType], [AvatarIsCustom]) WITH ( FILLFACTOR = 80) ON [PRIMARY] : caused exception: There is already an object named 'CMS_Avatar' in the database.
The strange thing is that I installed it more than once and get the same error, though with 5.5 everything goes fine. I tried manually creating the db, creating it with dotnetpanel and so on. The server is Windows 2008 and SQL 2008.
any ideas?
Thanks
|