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

Forums / General Discussions / Need URGENT HELP

Need URGENT HELP

4 posts, 0 answered
  1. gregory hernandez
    gregory hernandez avatar
    59 posts
    Registered:
    10 Jul 2009
    02 Feb 2012
    Link to this post
    Hi All,

    I am getting the following error on the production server:

    Violation of PRIMARY KEY constraint 'pk_sf_taxonomies'. Cannot insert duplicate key in object 'dbo.sf_taxonomies'. The duplicate key value is (d7831091-e7b1-41b8-9e75-dff32d6a7837).
    The statement has been terminated.

    (See screenshot attached)

    How can I fix this?

    Please HELP.

    Gregory
  2. Steve
    Steve avatar
    3037 posts
    Registered:
    03 Dec 2008
    02 Feb 2012
    Link to this post
    What were you doing when this happened?  Perhaps try backing up the DB and deleting that key from the DB so it won't throw an error trying to insert it?
  3. gregory hernandez
    gregory hernandez avatar
    59 posts
    Registered:
    10 Jul 2009
    02 Feb 2012
    Link to this post
    Hi Steve,
    I backed up the database, but couldn't delete the key due to a reference constraint.
    How should I proceed?
    Thanks in advance,
    Gregory
  4. Steve
    Steve avatar
    3037 posts
    Registered:
    03 Dec 2008
    02 Feb 2012
    Link to this post
    Darn okay...Do you have any idea what caused it, like what were you doing before it happened...did you add a new custom field, were you tagging items, or making a new page?
4 posts, 0 answered