Error in Upgrade from 3.1.1 to 3.2.2

Last post 01-13-2006 4:29 PM by hooligannes97. 0 replies.

Sort Posts:

  • Error in Upgrade from 3.1.1 to 3.2.2

    01-13-2006, 4:29 PM
    • All-Star
      16,504 point All-Star
    • hooligannes97
    • Member since 09-26-2003, 10:57 AM
    • Bolivia
    • Posts 2,917
    • Moderator

    Upgrading a 3.1.1 version to 3.2.2 logged this error in the script for 3.2.1

    System.Data.SqlClient.SqlException: CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 4. Most significant primary key is '3785'.
    Could not create constraint. See previous errors.
    The statement has been terminated.
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
    at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
    at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
    at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)


    ALTER TABLE dbo.SearchItemWord ADD CONSTRAINT
    IX_SearchItemWord UNIQUE NONCLUSTERED (SearchItemID, SearchWordsID) ON [PRIMARY]

    Will anything be crippled as a result in search?

    Do you know the truth when you hear it?
Page 1 of 1 (1 items)