{"action":"created","issue":{"url":"https://api.github.com/repos/zikula/core/issues/2884","repository_url":"https://api.github.com/repos/zikula/core","labels_url":"https://api.github.com/repos/zikula/core/issues/2884/labels{/name}","comments_url":"https://api.github.com/repos/zikula/core/issues/2884/comments","events_url":"https://api.github.com/repos/zikula/core/issues/2884/events","html_url":"https://github.com/zikula/core/issues/2884","id":156134229,"number":2884,"title":"Unable to delete categories - Integrity constraint violation","user":{"login":"shefik","id":274862,"avatar_url":"https://avatars.githubusercontent.com/u/274862?v=3","gravatar_id":"","url":"https://api.github.com/users/shefik","html_url":"https://github.com/shefik","followers_url":"https://api.github.com/users/shefik/followers","following_url":"https://api.github.com/users/shefik/following{/other_user}","gists_url":"https://api.github.com/users/shefik/gists{/gist_id}","starred_url":"https://api.github.com/users/shefik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/shefik/subscriptions","organizations_url":"https://api.github.com/users/shefik/orgs","repos_url":"https://api.github.com/users/shefik/repos","events_url":"https://api.github.com/users/shefik/events{/privacy}","received_events_url":"https://api.github.com/users/shefik/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/zikula/core/labels/Bug","name":"Bug","color":"e102d8"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/zikula/core/milestones/20","html_url":"https://github.com/zikula/core/milestones/1.4.3","labels_url":"https://api.github.com/repos/zikula/core/milestones/20/labels","id":1572760,"number":20,"title":"1.4.3","description":"Third service release for 1.4.x series","creator":{"login":"craigh","id":350048,"avatar_url":"https://avatars.githubusercontent.com/u/350048?v=3","gravatar_id":"","url":"https://api.github.com/users/craigh","html_url":"https://github.com/craigh","followers_url":"https://api.github.com/users/craigh/followers","following_url":"https://api.github.com/users/craigh/following{/other_user}","gists_url":"https://api.github.com/users/craigh/gists{/gist_id}","starred_url":"https://api.github.com/users/craigh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/craigh/subscriptions","organizations_url":"https://api.github.com/users/craigh/orgs","repos_url":"https://api.github.com/users/craigh/repos","events_url":"https://api.github.com/users/craigh/events{/privacy}","received_events_url":"https://api.github.com/users/craigh/received_events","type":"User","site_admin":false},"open_issues":26,"closed_issues":43,"state":"open","created_at":"2016-02-09T15:30:01Z","updated_at":"2016-07-13T07:10:24Z","due_on":"2016-08-30T22:00:00Z","closed_at":null},"comments":1,"created_at":"2016-05-22T04:27:59Z","updated_at":"2016-07-13T07:31:08Z","closed_at":null,"body":"| Q                 | A\r\n| ----------------- | ---\r\n| Zikula Version    | 1.3.2\r\n| PHP Version       | 5.6\r\n\r\n### Expected behavior\r\n\r\nUsing the UI, delete a category here:\r\n\r\n`/categories/admin/view`\r\n\r\n### Actual behavior\r\n\r\nError thrown:\r\n\r\n`An exception occurred while executing 'DELETE FROM categories_category WHERE id = ?' with params [42]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`database_name`.`categories_category`, CONSTRAINT `FK_D0B2B0F8727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `categories_category` (`id`))`\r\n\r\n### Steps to reproduce\r\n\r\nInstall the Pages module, and then try to delete the parent category \"Pages\", along with its subcategories."},"comment":{"url":"https://api.github.com/repos/zikula/core/issues/comments/232278108","html_url":"https://github.com/zikula/core/issues/2884#issuecomment-232278108","issue_url":"https://api.github.com/repos/zikula/core/issues/2884","id":232278108,"user":{"login":"Guite","id":277531,"avatar_url":"https://avatars.githubusercontent.com/u/277531?v=3","gravatar_id":"","url":"https://api.github.com/users/Guite","html_url":"https://github.com/Guite","followers_url":"https://api.github.com/users/Guite/followers","following_url":"https://api.github.com/users/Guite/following{/other_user}","gists_url":"https://api.github.com/users/Guite/gists{/gist_id}","starred_url":"https://api.github.com/users/Guite/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Guite/subscriptions","organizations_url":"https://api.github.com/users/Guite/orgs","repos_url":"https://api.github.com/users/Guite/repos","events_url":"https://api.github.com/users/Guite/events{/privacy}","received_events_url":"https://api.github.com/users/Guite/received_events","type":"User","site_admin":false},"created_at":"2016-07-13T07:31:07Z","updated_at":"2016-07-13T07:31:07Z","body":"Any idea how to approach this @zikula/contributors "}}
{"actor":{"display_login":"Guite"}}