{"id":7568,"date":"2025-09-11T08:41:38","date_gmt":"2025-09-11T05:41:38","guid":{"rendered":"https:\/\/www.inetmar.com\/blog\/?p=7568"},"modified":"2025-09-11T10:09:01","modified_gmt":"2025-09-11T07:09:01","slug":"db-query-failed-sqlstate23000-integrity-constraint-violation-hatasi-cozumu","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/db-query-failed-sqlstate23000-integrity-constraint-violation-hatasi-cozumu\/","title":{"rendered":"DB query failed: SQLSTATE[23000]: Integrity constraint violation Hatas\u0131 \u00c7\u00f6z\u00fcm\u00fc"},"content":{"rendered":"<p>Son zamanlarda s\u0131k\u00e7a rastlanan <strong>Error: DB query failed:<\/strong> <strong>SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry &#8216;X&#8217; for key &#8216;PRIMARY&#8217;, query was: replace<\/strong> hatas\u0131 genellikle Plesk panel \u00fczerinde alan ad\u0131, eposta eklerken veya paketi upgrade\/downgrade yaparken kar\u015f\u0131n\u0131za \u00e7\u0131kabilir bu hatay\u0131 \u00e7\u00f6z\u00fcmlemek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izleyebilirsiniz.<\/p>\n<h2>\u00c7\u00f6z\u00fcm 1<\/h2>\n<p>Plesk Panele giri\u015f yapal\u0131m. <strong>&#8220;Ara\u00e7lar ve Ayarlar&#8221;<\/strong> b\u00f6l\u00fcm\u00fcndeki <strong>&#8220;Te\u015fhis ve Onar\u0131m&#8221;<\/strong> k\u0131sm\u0131na t\u0131klayal\u0131m.<br \/>\n<a href=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/05\/pp1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7575\" src=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/05\/pp1-300x188.png\" alt=\"Error: DB query failed: SQLSTATE[23000]: Integrity constraint violation\" width=\"816\" height=\"511\" srcset=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/05\/pp1-300x188.png 300w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/05\/pp1-768x481.png 768w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/05\/pp1.png 938w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><\/a><\/p>\n<p>A\u00e7\u0131lan sayfada <strong>Plesk Veritaban\u0131<\/strong> k\u0131sm\u0131ndaki<strong> &#8220;Onar&#8221;<\/strong> se\u00e7ene\u011fine t\u0131klayarak database onar\u0131m\u0131n\u0131 tamamland\u0131ktan sonra hata \u00e7\u00f6z\u00fcmlenecektir.<\/p>\n<p><a href=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/05\/pp2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7576\" src=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/05\/pp2-300x240.png\" alt=\"DB query failed: SQLSTATE[23000]: Integrity constraint violation\" width=\"756\" height=\"604\" srcset=\"https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/05\/pp2-300x240.png 300w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/05\/pp2-1024x820.png 1024w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/05\/pp2-768x615.png 768w, https:\/\/www.inetmar.com\/blog\/wp-content\/uploads\/2024\/05\/pp2.png 1090w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><\/a><\/p>\n<h2>\u00c7\u00f6z\u00fcm 2<\/h2>\n<p>Sunucunuza ba\u011flan\u0131n ard\u0131ndan komut sat\u0131r\u0131na a\u015fa\u011f\u0131daki komutu uygulayarak onarma i\u015flemini ba\u015flat\u0131n.<\/p>\n<p><code>plesk repair db<\/code><\/p>\n<p style=\"text-align: center;\">\u0130\u015flem bukadar \ud83d\ude42 Daha fazla i\u00e7erik i\u00e7in <a href=\"https:\/\/www.inetmar.com\/\" target=\"_blank\" rel=\"noopener\">blog<\/a> sayfam\u0131z\u0131 ziyaret edebilirsiniz.<\/p>\n<p><a class=\"waffle-rich-text-link\" href=\"https:\/\/www.inetmar.com\/hosting\/windows-reseller-hosting\/\">Windows Reseller Hosting<\/a> se\u00e7eneklerimizi de\u011ferlendirin.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Son zamanlarda s\u0131k\u00e7a rastlanan Error: DB query failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry &#8216;X&#8217; for key &#8216;PRIMARY&#8217;, query was: replace hatas\u0131 genellikle Plesk panel \u00fczerinde alan ad\u0131, eposta eklerken veya paketi upgrade\/downgrade yaparken&#46;&#46;&#46;<\/p>\n","protected":false},"author":2,"featured_media":7585,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54,10,26],"tags":[],"class_list":["post-7568","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysqlserver","category-plesk","category-sql-server"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/7568","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/comments?post=7568"}],"version-history":[{"count":25,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/7568\/revisions"}],"predecessor-version":[{"id":14623,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/7568\/revisions\/14623"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/7585"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=7568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=7568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=7568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}