Developer forum

Forum » CMS - Standard features » Primary Key constraint

Primary Key constraint

E-mail notifications
Terri Donahue
Terri Donahue
Reply
Posted on 10/08/2017 21:06:35

I am trying to add a new Glossary_Item and am receiving this error:

Violation of PRIMARY KEY constraint 'PK__ItemType__3214EC073F47FEF2'. Cannot insert duplicate key in object 'dbo.ItemType_Glossary_Item'.
The statement has been terminated.

I was able to successfully create 1 and the ID automatically generated was 30. All other numbers between 31 and 39 are already assigned. Is there a way for me to set a new seed value for ID (the primary key) to stop this problem from occuring? The highest used ID value in this table is 71 so I would need to set it higher than that.

Thanks,


Replies

 
Nicolai Pedersen
Posted on 11/08/2017 09:02:06
Reply
This post has been marked as an answer

Hi Terri

Take a look at the data in ItemTypeId table. Find the record where [ItemType]=Glossary

BR Nicolai

Votes for this answer: 1
 
Terri Donahue
Terri Donahue
Posted on 11/08/2017 14:58:17
Reply

Thanks Nicolai. I knew there was a table for it just totally overlooked that one.

 

You must be logged in to post in the forum