{"action":"opened","issue":{"url":"https://api.github.com/repos/test4gloirin/m/issues/3778","repository_url":"https://api.github.com/repos/test4gloirin/m","labels_url":"https://api.github.com/repos/test4gloirin/m/issues/3778/labels{/name}","comments_url":"https://api.github.com/repos/test4gloirin/m/issues/3778/comments","events_url":"https://api.github.com/repos/test4gloirin/m/issues/3778/events","html_url":"https://github.com/test4gloirin/m/issues/3778","id":326375595,"number":3778,"title":"0007666:\ncan't delete user that is linked to an employee","user":{"login":"test4gloirin","id":39583038,"avatar_url":"https://avatars1.githubusercontent.com/u/39583038?v=4","gravatar_id":"","url":"https://api.github.com/users/test4gloirin","html_url":"https://github.com/test4gloirin","followers_url":"https://api.github.com/users/test4gloirin/followers","following_url":"https://api.github.com/users/test4gloirin/following{/other_user}","gists_url":"https://api.github.com/users/test4gloirin/gists{/gist_id}","starred_url":"https://api.github.com/users/test4gloirin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/test4gloirin/subscriptions","organizations_url":"https://api.github.com/users/test4gloirin/orgs","repos_url":"https://api.github.com/users/test4gloirin/repos","events_url":"https://api.github.com/users/test4gloirin/events{/privacy}","received_events_url":"https://api.github.com/users/test4gloirin/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"test4gloirin","id":39583038,"avatar_url":"https://avatars1.githubusercontent.com/u/39583038?v=4","gravatar_id":"","url":"https://api.github.com/users/test4gloirin","html_url":"https://github.com/test4gloirin","followers_url":"https://api.github.com/users/test4gloirin/followers","following_url":"https://api.github.com/users/test4gloirin/following{/other_user}","gists_url":"https://api.github.com/users/test4gloirin/gists{/gist_id}","starred_url":"https://api.github.com/users/test4gloirin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/test4gloirin/subscriptions","organizations_url":"https://api.github.com/users/test4gloirin/orgs","repos_url":"https://api.github.com/users/test4gloirin/repos","events_url":"https://api.github.com/users/test4gloirin/events{/privacy}","received_events_url":"https://api.github.com/users/test4gloirin/received_events","type":"User","site_admin":false},"assignees":[{"login":"test4gloirin","id":39583038,"avatar_url":"https://avatars1.githubusercontent.com/u/39583038?v=4","gravatar_id":"","url":"https://api.github.com/users/test4gloirin","html_url":"https://github.com/test4gloirin","followers_url":"https://api.github.com/users/test4gloirin/followers","following_url":"https://api.github.com/users/test4gloirin/following{/other_user}","gists_url":"https://api.github.com/users/test4gloirin/gists{/gist_id}","starred_url":"https://api.github.com/users/test4gloirin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/test4gloirin/subscriptions","organizations_url":"https://api.github.com/users/test4gloirin/orgs","repos_url":"https://api.github.com/users/test4gloirin/repos","events_url":"https://api.github.com/users/test4gloirin/events{/privacy}","received_events_url":"https://api.github.com/users/test4gloirin/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/test4gloirin/m/milestones/167","html_url":"https://github.com/test4gloirin/m/milestone/167","labels_url":"https://api.github.com/repos/test4gloirin/m/milestones/167/labels","id":3373188,"number":167,"title":"Joey (2012.10.3)","description":null,"creator":{"login":"test4gloirin","id":39583038,"avatar_url":"https://avatars1.githubusercontent.com/u/39583038?v=4","gravatar_id":"","url":"https://api.github.com/users/test4gloirin","html_url":"https://github.com/test4gloirin","followers_url":"https://api.github.com/users/test4gloirin/followers","following_url":"https://api.github.com/users/test4gloirin/following{/other_user}","gists_url":"https://api.github.com/users/test4gloirin/gists{/gist_id}","starred_url":"https://api.github.com/users/test4gloirin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/test4gloirin/subscriptions","organizations_url":"https://api.github.com/users/test4gloirin/orgs","repos_url":"https://api.github.com/users/test4gloirin/repos","events_url":"https://api.github.com/users/test4gloirin/events{/privacy}","received_events_url":"https://api.github.com/users/test4gloirin/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":33,"state":"closed","created_at":"2018-05-24T14:41:40Z","updated_at":"2018-05-25T04:17:21Z","due_on":null,"closed_at":"2018-05-24T14:41:40Z"},"comments":0,"created_at":"2018-05-25T04:17:21Z","updated_at":"2018-05-25T04:17:21Z","closed_at":null,"author_association":"OWNER","body":"**Reported by pschuele on 10 Jan 2013 16:39**\n\n**Version:** Joey (2012.10.2)\n\ncan&#039;t delete user that is linked to an employee\r\n\r\n- remove employee, too\r\nOR\r\n- remove fk constraint hr_employee::account_id--accounts::id\r\n\r\ncheck hr_employee::supervisor_id--accounts::id, too\n\n**Additional information:** [request] =&gt; {&quot;jsonrpc&quot;:&quot;2.0&quot;,&quot;method&quot;:&quot;Admin.deleteUsers&quot;,&quot;params&quot;:{&quot;ids&quot;:[&quot;79f231b5d1e8db0961a513ee0ad23e878b7bfe48&quot;]},&quot;id&quot;:8}\r\n    [response] =&gt; {&quot;code&quot;:-32000,&quot;message&quot;:&quot;SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`tine20`.`tine20_humanresources_employee`, CONSTRAINT `tine20_hr_employee::account_id--accounts::id` FOREIGN KEY (`account_id`) REFERENCES `tine20_accounts` (`id`))&quot;,&quot;data&quot;:{&quot;message&quot;:&quot;SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`tine20`.`tine20_humanresources_employee`, CONSTRAINT `tine20_hr_employee::account_id--accounts::id` FOREIGN KEY (`account_id`) REFERENCES `tine20_accounts` (`id`))&quot;,&quot;code&quot;:0,&quot;trace&quot;:[{&quot;file&quot;:&quot;.../library/Zend/Db/Statement.php&quot;,&quot;line&quot;:284,&quot;function&quot;:&quot;_execute&quot;,&quot;class&quot;:&quot;Zend_Db_Statement_Pdo&quot;,&quot;type&quot;:&quot;-&gt;&quot;},{&quot;file&quot;:&quot;.../library/Zend/Db/Adapter/Abstract.php&quot;,&quot;line&quot;:468,&quot;function&quot;:&quot;execute&quot;,&quot;class&quot;:&quot;Zend_Db_Statement&quot;,&quot;type&quot;:&quot;-&gt;&quot;},{&quot;file&quot;:&quot;.../library/Zend/Db/Adapter/Pdo/Abstract.php&quot;,&quot;line&quot;:238,&quot;function&quot;:&quot;query&quot;,&quot;class&quot;:&quot;Zend_Db_Adapter_Abstract&quot;,&quot;type&quot;:&quot;-&gt;&quot;},{&quot;file&quot;:&quot;.../library/Zend/Db/Adapter/Abstract.php&quot;,&quot;line&quot;:633,&quot;function&quot;:&quot;query&quot;,&quot;class&quot;:&quot;Zend_Db_Adapter_Pdo_Abstract&quot;,&quot;type&quot;:&quot;-&gt;&quot;},{&quot;file&quot;:&quot;.../Zend/Db/Table/Abstract.php&quot;,&quot;line&quot;:1163,&quot;function&quot;:&quot;delete&quot;,&quot;class&quot;:&quot;Zend_Db_Adapter_Abstract&quot;,&quot;type&quot;:&quot;-&gt;&quot;},{&quot;file&quot;:&quot;.../Tinebase/User/Sql.php&quot;,&quot;line&quot;:862,&quot;function&quot;:&quot;delete&quot;,&quot;class&quot;:&quot;Zend_Db_Table_Abstract&quot;,&quot;type&quot;:&quot;-&gt;&quot;},{&quot;file&quot;:&quot;.../Tinebase/User/Sql.php&quot;,&quot;line&quot;:813,&quot;function&quot;:&quot;deleteUserInSqlBackend&quot;,&quot;class&quot;:&quot;Tinebase_User_Sql&quot;,&quot;type&quot;:&quot;-&gt;&quot;},{&quot;file&quot;:&quot;.../Admin/Controller/User.php&quot;,&quot;line&quot;:345,&quot;function&quot;:&quot;deleteUser&quot;,&quot;class&quot;:&quot;Tinebase_User_Sql&quot;,&quot;type&quot;:&quot;-&gt;&quot;},{&quot;file&quot;:&quot;.../Admin/Frontend/Json.php&quot;,&quot;line&quot;:411,&quot;function&quot;:&quot;delete&quot;,&quot;class&quot;:&quot;Admin_Controller_User&quot;,&quot;type&quot;:&quot;-&gt;&quot;},{&quot;function&quot;:&quot;deleteUsers&quot;,&quot;class&quot;:&quot;Admin_Frontend_Json&quot;,&quot;type&quot;:&quot;-&gt;&quot;},{&quot;file&quot;:&quot;.../library/Zend/Server/Abstract.php&quot;,&quot;line&quot;:232,&quot;function&quot;:&quot;call_user_func_array&quot;},{&quot;file&quot;:&quot;.../Zend/Json/Server.php&quot;,&quot;line&quot;:558,&quot;function&quot;:&quot;_dispatch&quot;,&quot;class&quot;:&quot;Zend_Server_Abstract&quot;,&quot;type&quot;:&quot;-&gt;&quot;},{&quot;file&quot;:&quot;.../Zend/Json/Server.php&quot;,&quot;line&quot;:197,&quot;function&quot;:&quot;_handle&quot;,&quot;class&quot;:&quot;Zend_Json_Server&quot;,&quot;type&quot;:&quot;-&gt;&quot;},{&quot;file&quot;:&quot;.../Tinebase/Server/Json.php&quot;,&quot;line&quot;:208,&quot;function&quot;:&quot;handle&quot;,&quot;class&quot;:&quot;Zend_Json_Server&quot;,&quot;type&quot;:&quot;-&gt;&quot;},{&quot;file&quot;:&quot;.../Tinebase/Server/Json.php&quot;,&quot;line&quot;:78,&quot;function&quot;:&quot;_handle&quot;,&quot;class&quot;:&quot;Tinebase_Server_Json&quot;,&quot;type&quot;:&quot;-&gt;&quot;},{&quot;file&quot;:&quot;.../Tinebase/Core.php&quot;,&quot;line&quot;:229,&quot;function&quot;:&quot;handle&quot;,&quot;class&quot;:&quot;Tinebase_Server_Json&quot;,&quot;type&quot;:&quot;-&gt;&quot;},{&quot;file&quot;:&quot;.../index.php&quot;,&quot;line&quot;:17,&quot;function&quot;:&quot;dispatchRequest&quot;,&quot;class&quot;:&quot;Tinebase_Core&quot;,&quot;type&quot;:&quot;::&quot;}]}}\r\n    [traceHTML] =&gt; .../library/Zend/Db/Statement.php(284): Zend_Db_Statement_Pdo-&gt;_execute()\r\n.../library/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement-&gt;execute()\r\n.../library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract-&gt;query()\r\n.../library/Zend/Db/Adapter/Abstract.php(633): Zend_Db_Adapter_Pdo_Abstract-&gt;query()\r\n.../Zend/Db/Table/Abstract.php(1163): Zend_Db_Adapter_Abstract-&gt;delete()\r\n.../Tinebase/User/Sql.php(862): Zend_Db_Table_Abstract-&gt;delete()\r\n.../Tinebase/User/Sql.php(813): Tinebase_User_Sql-&gt;deleteUserInSqlBackend()\r\n.../Admin/Controller/User.php(345): Tinebase_User_Sql-&gt;deleteUser()\r\n.../Admin/Frontend/Json.php(411): Admin_Controller_User-&gt;delete()\r\n[internal function]: Admin_Frontend_Json-&gt;deleteUsers()\r\n.../library/Zend/Server/Abstract.php(232): call_user_func_array()\r\n.../Zend/Json/Server.php(558): Zend_Server_Abstract-&gt;_dispatch()\r\n.../Zend/Json/Server.php(197): Zend_Json_Server-&gt;_handle()\r\n.../Tinebase/Server/Json.php(208): Zend_Json_Server-&gt;handle()\r\n.../Tinebase/Server/Json.php(78): Tinebase_Server_Json-&gt;_handle()\r\n.../Tinebase/Core.php(229): Tinebase_Server_Json-&gt;handle()\r\n.../index.php(17): Tinebase_Core::dispatchRequest()\r\n\r\n    [msg] =&gt; SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`tine20`.`tine20_humanresources_employee`, CONSTRAINT `tine20_hr_employee::account_id--accounts::id` FOREIGN KEY (`account_id`) REFERENCES `tine20_accounts` (`id`))\r\n\n"}}
{"actor":{"display_login":"test4gloirin"}}