{"id":853,"date":"2016-02-09T09:50:45","date_gmt":"2016-02-09T08:50:45","guid":{"rendered":"http:\/\/webpiraten.de\/?p=853"},"modified":"2016-02-09T09:50:45","modified_gmt":"2016-02-09T08:50:45","slug":"sql-general-error-1553-cannot-drop-index-xyz-needed-in-a-foreign-key-constraint","status":"publish","type":"post","link":"https:\/\/webpiraten.de\/index.php\/frameworks\/sql-general-error-1553-cannot-drop-index-xyz-needed-in-a-foreign-key-constraint\/","title":{"rendered":"SQL General error &#8211; 1553 Cannot drop index XYZ needed in a foreign key constraint"},"content":{"rendered":"<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\n\/\/ show indexes of table\r\nSHOW CREATE TABLE news;\r\n\r\n\/\/ shows something like this\r\n...\r\nCONSTRAINT `FK_3A51546D12469DE2` FOREIGN KEY (`category_id`) REFERENCES `news_category` (`id`),\r\n...\r\n\r\n\/\/ drop index\r\nALTER TABLE news DROP FOREIGN KEY FK_3A51546D12469DE2;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\/\/ show indexes of table SHOW CREATE TABLE news; \/\/ shows something like this &#8230; CONSTRAINT `FK_3A51546D12469DE2` FOREIGN KEY (`category_id`) REFERENCES `news_category` (`id`), &#8230; \/\/ drop index ALTER TABLE news DROP FOREIGN KEY FK_3A51546D12469DE2;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[121,53,3,11,567],"tags":[616,614,298,615,617,514,634,38],"class_list":["post-853","post","type-post","status-publish","format-standard","hentry","category-debugging","category-doctrine-orm","category-frameworks","category-mysql","category-symfony2","tag-alter-table","tag-constraint","tag-drop","tag-foreign-key","tag-general-error","tag-index","tag-mysql","tag-sql"],"_links":{"self":[{"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/posts\/853","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/comments?post=853"}],"version-history":[{"count":1,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/posts\/853\/revisions"}],"predecessor-version":[{"id":854,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/posts\/853\/revisions\/854"}],"wp:attachment":[{"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/media?parent=853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/categories?post=853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webpiraten.de\/index.php\/wp-json\/wp\/v2\/tags?post=853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}