{"id":15838,"date":"2022-10-13T06:22:33","date_gmt":"2022-10-13T00:52:33","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/"},"modified":"2022-10-13T06:22:33","modified_gmt":"2022-10-13T00:52:33","slug":"solved-doctrine-2-gedmosoftdeleteable-and-unique-fields","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/","title":{"rendered":"[Solved] Doctrine 2 @Gedmo\\SoftDeleteable and unique fields"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-33536372\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"33536372\" data-parentid=\"33533761\" data-score=\"3\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>Do you know what means &#8220;soft delete&#8221;? It means that every &#8220;delete&#8221; operation will be converted to SQL that only set some <code>deleted<\/code> flag to <code>true<\/code>. And if you will insert another row with the same value of unique field that have soft deleted row you will get this message.<\/p>\n<p>You have two ways to solve this problem:<\/p>\n<ul>\n<li>Make your unique index with two columns: your original unique field and <code>deleted<\/code> flag. Then you will get this error only when you try to add row with the existing unique fields values only for not soft deleted.<\/li>\n<li>Avoid making this violation: you should exclude the possibility to add row that duplicates another in unique fields.<\/li>\n<\/ul>\n<p>The second one is the best approach IMHO.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">1<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Doctrine 2 @Gedmo\\SoftDeleteable and unique fields <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] Do you know what means &#8220;soft delete&#8221;? It means that every &#8220;delete&#8221; operation will be converted to SQL that only set some deleted flag to true. And if you will insert another row with the same value of unique field that have soft deleted row you will get this message. You have two ways &#8230; <a title=\"[Solved] Doctrine 2 @Gedmo\\SoftDeleteable and unique fields\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/\" aria-label=\"More on [Solved] Doctrine 2 @Gedmo\\SoftDeleteable and unique fields\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[1276,340,580],"class_list":["post-15838","post","type-post","status-publish","format-standard","hentry","category-solved","tag-doctrine-orm","tag-mysql","tag-symfony"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Doctrine 2 @Gedmo\\SoftDeleteable and unique fields - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Doctrine 2 @Gedmo\\SoftDeleteable and unique fields - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Do you know what means &#8220;soft delete&#8221;? It means that every &#8220;delete&#8221; operation will be converted to SQL that only set some deleted flag to true. And if you will insert another row with the same value of unique field that have soft deleted row you will get this message. You have two ways ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-13T00:52:33+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Doctrine 2 @Gedmo\\\\SoftDeleteable and unique fields\",\"datePublished\":\"2022-10-13T00:52:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/\"},\"wordCount\":135,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"doctrine-orm\",\"mysql\",\"symfony\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/\",\"name\":\"[Solved] Doctrine 2 @Gedmo\\\\SoftDeleteable and unique fields - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-10-13T00:52:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Doctrine 2 @Gedmo\\\\SoftDeleteable and unique fields\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Doctrine 2 @Gedmo\\SoftDeleteable and unique fields - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Doctrine 2 @Gedmo\\SoftDeleteable and unique fields - JassWeb","og_description":"[ad_1] Do you know what means &#8220;soft delete&#8221;? It means that every &#8220;delete&#8221; operation will be converted to SQL that only set some deleted flag to true. And if you will insert another row with the same value of unique field that have soft deleted row you will get this message. You have two ways ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/","og_site_name":"JassWeb","article_published_time":"2022-10-13T00:52:33+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Doctrine 2 @Gedmo\\SoftDeleteable and unique fields","datePublished":"2022-10-13T00:52:33+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/"},"wordCount":135,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["doctrine-orm","mysql","symfony"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/","url":"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/","name":"[Solved] Doctrine 2 @Gedmo\\SoftDeleteable and unique fields - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-10-13T00:52:33+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-doctrine-2-gedmosoftdeleteable-and-unique-fields\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Doctrine 2 @Gedmo\\SoftDeleteable and unique fields"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/15838","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=15838"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/15838\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=15838"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=15838"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=15838"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}