Creating Transactions Silently Fails

[dirtyworks]

On Debian Stretch, Debian repositories used where possible.

Attempting to add a transaction doesn't seem to work right. Some transactions appear in the view, others do not. For example:

Name: my check
Type: receive
Amount: 2321
Category: Salary & Wages
Date: 2017-07-14

No error message, no new transaction in the web page. However, the database has committed the rows. Since I tried it a couple of different ways, there are a couple of different versions of the same transaction in the database. For example, only one of the rent transactions is rendered in the page, and no income is rendered.

below is "select * from payments"

id name category_id amount type schedule created_at updated_at
1 test rent schedule 16 900 Spend ---/n:start_time: 2017-07-01 00:00:00.000000000 -07:00/n:rrules:/n- :validations: {}/n :rule_type: IceCube::MonthlyRule/n :interval: 999/n:rtimes: []/n:extimes: []/n 2017-07-20 03:57:23.122123 2017-07-20 03:57:23.122123
2 test rent schedule 16 900 Spend ---/n:start_time: 2017-08-01 00:00:00.000000000 -07:00/n:rrules:/n- :validations: {}/n :rule_type: IceCube::MonthlyRule/n :interval: 44/n:rtimes: []/n:extimes: []/n 2017-07-20 03:58:57.785774 2017-07-20 03:58:57.785774
3 test expense schedule 27 833.33 Spend ---/n:start_time: 2017-07-18 00:00:00.000000000 -07:00/n:rrules:/n- :validations: {}/n :rule_type: IceCube::MonthlyRule/n :interval: 44/n:rtimes: []/n:extimes: []/n 2017-07-20 04:02:45.019783 2017-07-20 04:02:45.019783
4 test expense schedule 27 833.33 Spend ---/n:start_time: 2017-07-18 00:00:00.000000000 -07:00/n:rrules:/n- :validations: {}/n :rule_type: IceCube::MonthlyRule/n :interval: 44/n:rtimes: []/n:extimes: []/n 2017-07-20 04:03:42.890531 2017-07-20 04:03:42.890531
5 test expense schedule 27 788.88 Spend ---/n:start_time: 2017-07-18 00:00:00.000000000 -07:00/n:rrules:/n- :validations: {}/n :rule_type: IceCube::MonthlyRule/n :interval: 11/n:rtimes: []/n:extimes: []/n 2017-07-20 04:04:15.645165 2017-07-20 04:04:15.645165
6 test expense schedule 27 633 Spend ---/n:start_time: 2017-07-17 00:00:00.000000000 -07:00/n:rrules:/n- :validations: {}/n :rule_type: IceCube::MonthlyRule/n :interval: 44/n:rtimes: []/n:extimes: []/n 2017-07-20 04:27:28.753658 2017-07-20 04:27:28.753658
7 test expense schedule 27 633 Spend ---/n:start_time: 2017-07-19 21:28:33.000000000 -07:00/n:rrules:/n- :validations: {}/n :rule_type: IceCube::MonthlyRule/n :interval: 44/n:rtimes: []/n:extimes: []/n 2017-07-20 04:28:33.901146 2017-07-20 04:28:33.901146
8 test income schedule 23 2,321 Receive ---/n:start_time: 2017-07-14 00:00:00.000000000 -07:00/n:rrules:/n- :validations: {}/n :rule_type: IceCube::MonthlyRule/n :interval: 99/n:rtimes: []/n:extimes: []/n 2017-07-20 04:32:15.774019 2017-07-20 04:32:15.774019
9 test income schedule 23 2,321 Receive ---/n:start_time: 2017-07-14 00:00:00.000000000 -07:00/n:rrules:/n- :validations: {}/n :rule_type: IceCube::MonthlyRule/n :interval: 44/n:rtimes: []/n:extimes: []/n 2017-07-20 04:33:35.07448 2017-07-20 04:33:35.07448
10 test income schedule 23 2,321 Receive ---/n:start_time: 2017-07-14 00:00:00.000000000 -07:00/n:rrules:/n- :validations: {}/n :rule_type: IceCube::MonthlyRule/n :interval: 4/n:rtimes: []/n:extimes: []/n 2017-07-20 04:35:09.481792 2017-07-20 04:35:09.481792
11 test income schedule 23 2,312 Receive ---/n:start_time: 2017-07-14 00:00:00.000000000 -07:00/n:rrules: []/n:rtimes: []/n:extimes: []/n 2017-07-20 05:11:27.239339 2017-07-20 05:11:27.239339
12 test income schedule 23 2,320 Receive ---/n:start_time: 2017-07-14 00:00:00.000000000 -07:00/n:rrules: []/n:rtimes: []/n:extimes: []/n 2017-07-20 05:15:04.994602 2017-07-20 05:15:04.994602

Wishlist:
The payment gui needs a drop-down box that populates with the names of the accounts to associate where expenses are paid. Adding a column to expense table would not be expensive.

Totally my opinion, the "category" column needs to be the text value, not the ID from the category table. It would make that table very easy to read.