Hi, i tried to install application to shared hosting server, when i wanted to connect database , it always appeared this error message and until now i cannot solve the problem. May i know how to solve the problem.

Thanks in advance and appreciate all the help you all may provide.


ERROR: An error occurred: [DataConnection.ExecuteQuery]: Query: CREATE TABLE [CMS_Avatar] ( [AvatarID] int NOT NULL IDENTITY(1, 1), [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] 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 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 INDEX [IX_CMS_Avatar_AvatarType_AvatarIsCustom] ON [CMS_Avatar] ([AvatarType], [AvatarIsCustom]) WITH ( FILLFACTOR = 80) ON [PRIMARY] : caused exception: Line 6: Incorrect syntax near 'max'. Line 47: Incorrect syntax near '('. Line 51: Incorrect syntax near '('. Line 55: Incorrect syntax near '('.