{"action":"created","issue":{"url":"https://api.github.com/repos/cakephp/docs/issues/3163","labels_url":"https://api.github.com/repos/cakephp/docs/issues/3163/labels{/name}","comments_url":"https://api.github.com/repos/cakephp/docs/issues/3163/comments","events_url":"https://api.github.com/repos/cakephp/docs/issues/3163/events","html_url":"https://github.com/cakephp/docs/issues/3163","id":102585736,"number":3163,"title":"DebugKit throws integrity constraint error with mysql connection","user":{"login":"mneil","id":1605808,"avatar_url":"https://avatars.githubusercontent.com/u/1605808?v=3","gravatar_id":"","url":"https://api.github.com/users/mneil","html_url":"https://github.com/mneil","followers_url":"https://api.github.com/users/mneil/followers","following_url":"https://api.github.com/users/mneil/following{/other_user}","gists_url":"https://api.github.com/users/mneil/gists{/gist_id}","starred_url":"https://api.github.com/users/mneil/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mneil/subscriptions","organizations_url":"https://api.github.com/users/mneil/orgs","repos_url":"https://api.github.com/users/mneil/repos","events_url":"https://api.github.com/users/mneil/events{/privacy}","received_events_url":"https://api.github.com/users/mneil/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-08-23T04:06:30Z","updated_at":"2015-08-23T20:09:22Z","closed_at":null,"body":"Every now and then I see a fatal error which appears to be caused by debugkit. Integrity constraint violation. Unable to delete records with foreign key constraint... in the requests table. The root of the problem appears to be that I have \"quoteIdentifiers\" either not set (default false) or set to false explicitly because I just copied the default DB connection. By setting \"quoteIdentifiers\" to true in the connection settings I am able to stop receiving the errors. \r\n\r\nThe debugkit docs http://book.cakephp.org/3.0/en/debug-kit.html should state that, when using a mysql connection defined in the app configuration, \"quoteIdentifiers\" should to be set to true. My configuration looks like:\r\n\r\n```\r\n'debug_kit' => [\r\n            'className' => 'Cake\\Database\\Connection',\r\n            'driver' => 'Cake\\Database\\Driver\\Mysql',\r\n            'persistent' => false,\r\n            'host' => '127.0.0.1',\r\n            'username' => '',\r\n            'password' => '',\r\n            'database' => '',\r\n            'encoding' => 'utf8',\r\n            'timezone' => 'UTC',\r\n            'cacheMetadata' => true,\r\n            'quoteIdentifiers' => true\r\n        ]\r\n```\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/cakephp/docs/issues/comments/133914145","html_url":"https://github.com/cakephp/docs/issues/3163#issuecomment-133914145","issue_url":"https://api.github.com/repos/cakephp/docs/issues/3163","id":133914145,"user":{"login":"markstory","id":24086,"avatar_url":"https://avatars.githubusercontent.com/u/24086?v=3","gravatar_id":"","url":"https://api.github.com/users/markstory","html_url":"https://github.com/markstory","followers_url":"https://api.github.com/users/markstory/followers","following_url":"https://api.github.com/users/markstory/following{/other_user}","gists_url":"https://api.github.com/users/markstory/gists{/gist_id}","starred_url":"https://api.github.com/users/markstory/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/markstory/subscriptions","organizations_url":"https://api.github.com/users/markstory/orgs","repos_url":"https://api.github.com/users/markstory/repos","events_url":"https://api.github.com/users/markstory/events{/privacy}","received_events_url":"https://api.github.com/users/markstory/received_events","type":"User","site_admin":false},"created_at":"2015-08-23T20:09:22Z","updated_at":"2015-08-23T20:09:22Z","body":"What is the exact error you are getting from MySQL? I don't understand how identifier quoting and constraint violations could be linked."}}