+1-888-365-2779
Try Now
More in this section

Forums / Set-up & Installation / 3.7SP2 to 3.7SP4 update error

3.7SP2 to 3.7SP4 update error

2 posts, 0 answered
  1. Jon
    Jon avatar
    22 posts
    Registered:
    11 Mar 2010
    12 Oct 2010
    Link to this post
    I did a forum search and I'm not seeing this. Figured I ask, here's the error I get after database and user config steps. I can't seem to move past it.

    The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.sf_StagedPageContent' and the index name 'PK_sf_StagedPageContent'. The duplicate key value is (127, 7e3c6cc8-4490-44e1-b750-9628733ae322, 8).
    Could not create constraint. See previous errors.
    The statement has been terminated.

    I did an update to our Release Sitefinity 3.7 SP2
    3.7.2057.2 - standard

    using

    Sitefinity_3_7_2136_standard_NET20_patch
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    12 Oct 2010
    Link to this post
    Hello Jon,

    Try deleting the duplicate row in StagedPageContent

    DELETE FROM StagedPageContent WHERE ID='7e3c6cc8-4490-44e1-b750-9628733ae322' AND Version = '8'

    You could also query [sf_PageBase] to see whether version 8 is latest version of the page.  Removing this version will cause "rollback" over your page and the latest version will become 7.

    No one has reported this problem so far which makes me think that there have been some manual changes to the database.

    Sincerely yours,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
2 posts, 0 answered