balbes
  • Posts: 73
  • Joined: 21/07/2009
Quote:


FILE:
mssql/constraints.sql

ERROR:
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.yaf_Thanks' and the index name 'IX_yaf_Thanks'. The duplicate key value is ( 297, 98 ).
Could not create constraint. See previous errors.
The statement has been terminated.

STATEMENT:
if not exists(select * from dbo.sysindexes where id=object_id('[dbo].[yaf_Thanks]') and name='IX_yaf_Thanks')
alter table [dbo].[yaf_Thanks] add constraint IX_yaf_Thanks unique nonclustered([ThanksFromUserID],[ThanksToUserID])


mir scheissegal
Sponsor
bbobb
  • Posts: 1558
  • Joined: 21/10/2008
I'll fix it it's my fault:wink: .
Update:
Should be fixed in svn r3037

Forum Jump  
  • 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.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved