{"action":"closed","issue":{"url":"https://api.github.com/repos/ledgersmb/LedgerSMB/issues/2421","repository_url":"https://api.github.com/repos/ledgersmb/LedgerSMB","labels_url":"https://api.github.com/repos/ledgersmb/LedgerSMB/issues/2421/labels{/name}","comments_url":"https://api.github.com/repos/ledgersmb/LedgerSMB/issues/2421/comments","events_url":"https://api.github.com/repos/ledgersmb/LedgerSMB/issues/2421/events","html_url":"https://github.com/ledgersmb/LedgerSMB/issues/2421","id":196814989,"number":2421,"title":"1.5 Error deleting draft AP Transactions","user":{"login":"nick-prater","id":1817335,"avatar_url":"https://avatars.githubusercontent.com/u/1817335?v=3","gravatar_id":"","url":"https://api.github.com/users/nick-prater","html_url":"https://github.com/nick-prater","followers_url":"https://api.github.com/users/nick-prater/followers","following_url":"https://api.github.com/users/nick-prater/following{/other_user}","gists_url":"https://api.github.com/users/nick-prater/gists{/gist_id}","starred_url":"https://api.github.com/users/nick-prater/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nick-prater/subscriptions","organizations_url":"https://api.github.com/users/nick-prater/orgs","repos_url":"https://api.github.com/users/nick-prater/repos","events_url":"https://api.github.com/users/nick-prater/events{/privacy}","received_events_url":"https://api.github.com/users/nick-prater/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-12-21T00:18:01Z","updated_at":"2016-12-21T16:10:55Z","closed_at":"2016-12-21T16:10:55Z","body":"Having entered some draft AP Transactions, I attempted to delete them. This resulted in errors:\r\n\r\nERROR: update or delete on table \"acc_trans\" violates foreign key constraint \"cr_report_max_ac_id_fkey\" on table \"cr_report\" DETAIL: Key (entry_id)=(6425) is still referenced from table \"cr_report\". CONTEXT: SQL statement \"DELETE FROM acc_trans WHERE trans_id = in_id\" PL/pgSQL function draft_delete(integer) line 9 at SQL statement: SELECT * FROM \"public\".\"draft_delete\"(?) at /home/nick/perl5/perlbrew/perls/perl-5.24.0/lib/site_perl/5.24.0/PGObject.pm line 359.\r\n\r\nThis is similar, but different to previously fixed bug #2380, where deletes need to be cascaded for a number of tables referencing acc_trans.\r\n\r\nPR for consideration to follow shortly."}}
{"actor":{"display_login":"nick-prater"}}