Firefly III
Replies: 1 comment 5 replies
-
|
|
Beta Was this translation helpful? Give feedback.
-
|
The account type (4) also appears to be valid: mysql> select * from account_types where ID = 4; |
Beta Was this translation helpful? Give feedback.
-
|
I see:
That would mean the expected account type would be an asset account. I think that's why it fails. |
Beta Was this translation helpful? Give feedback.
-
|
Ok. I'll pass that info over to my accountant (wife!) and will report back. We appreciate the quick response! |
Beta Was this translation helpful? Give feedback.
-
|
So we've deleted and recreated the errant recurring transaction with the transaction type set to Withdrawal. Hopefully it'll run correctly next month. Would this suggest that some additional input validation is needed for the source/destination account types at the time the recurring transaction is created? In any case, many thanks for the quick replies. Coffee will be heading your way shortly :) |
Beta Was this translation helpful? Give feedback.
-
Which should be in place, but I will debug this further for sure, thanks! :D |
Beta Was this translation helpful? Give feedback.
-
Before I parcel this up as a bug report, I thought I'd throw this out here in case it's user error.
Basically the overnight firefly-iii:cron job failed while to process recurring transactions because it was unable to find a destination account. I re-ran it this morning with debug enabled. Here's the output (slightly redacted to remove account info):
[2024-05-01 09:26:15] production.DEBUG: 2024-05-01 IS today (2024-05-01)
[2024-05-01 09:26:15] production.DEBUG: Now in TransactionGroupFactory::create()
[2024-05-01 09:26:15] production.DEBUG: Now in TransactionJournalFactory::create()
[2024-05-01 09:26:15] production.DEBUG: Start of TransactionJournalFactory::create()
[2024-05-01 09:26:15] production.DEBUG: Now creating journal 1/1
[2024-05-01 09:26:15] production.DEBUG: The hash is: 4ec53db2916c2be3321aab7d264b81dc97ea665b08a6a762fed69c502dc90176 {"type":"transfer","date":"2024-05-01 00:00:00","user":2,"currency_id":3,"currency_code":null,"description":"Building society","amount":"50.000000000000","budget_id":null,"budget_name":null,"category_id":12,"category_name":null,"source_id":4,"source_name":null,"destination_id":207,"destination_name":null,"foreign_currency_id":null,"foreign_currency_code":null,"foreign_amount":"","reconciled":false,"identifier":0,"recurrence_id":42,"order":0,"notes":"Created from recurring transaction "Building society reg saver" (#42)","tags":["Reg saver"],"piggy_bank_id":null,"piggy_bank_name":null,"bill_id":null,"bill_name":null,"recurrence_total":0,"recurrence_count":1,"recurrence_date":"2024-05-01 00:00:00"}
[2024-05-01 09:26:15] production.DEBUG: In errorIfDuplicate(4ec53db2916c2be3321aab7d264b81dc97ea665b08a6a762fed69c502dc90176)
[2024-05-01 09:26:15] production.DEBUG: Now looking for a transaction type.
[2024-05-01 09:26:15] production.DEBUG: Tried to search for "transfer", came up with "Transfer". Will return it.
[2024-05-01 09:26:15] production.DEBUG: Now in findCurrencyNull()
[2024-05-01 09:26:15] production.DEBUG: Final result: GBP
[2024-05-01 09:26:15] production.DEBUG: Now in findCurrencyNull()
[2024-05-01 09:26:15] production.DEBUG: Searching for currency with code ...
[2024-05-01 09:26:15] production.DEBUG: Found nothing
[2024-05-01 09:26:15] production.DEBUG: Now in FireflyIII\Factory\TransactionJournalFactory::validateAccounts
[2024-05-01 09:26:15] production.DEBUG: Transaction type for validator is now "Transfer".
[2024-05-01 09:26:15] production.DEBUG: Now in AccountValidator::validateSource() {"id":4,"name":null,"iban":null,"number":null}
[2024-05-01 09:26:15] production.DEBUG: Now in validateTransferSource {"id":4,"name":null,"iban":null,"number":null}
[2024-05-01 09:26:15] production.DEBUG: Now in findExistingAccount {"id":4,"name":null,"iban":null,"number":null}
[2024-05-01 09:26:15] production.DEBUG: The search will be reversed!
[2024-05-01 09:26:15] production.DEBUG: ID: Found Asset account account #4 ("Cahoot", IBAN "")
[2024-05-01 09:26:15] production.DEBUG: AccountValidator source is set to #4: "Cahoot" (Asset account)
[2024-05-01 09:26:15] production.DEBUG: Valid source!
[2024-05-01 09:26:15] production.DEBUG: Source seems valid.
[2024-05-01 09:26:15] production.DEBUG: Now in AccountValidator::validateDestination() {"id":207,"name":null,"iban":null,"number":null}
[2024-05-01 09:26:15] production.DEBUG: Now in validateTransferDestination {"id":207,"name":null,"iban":null,"number":null}
[2024-05-01 09:26:15] production.DEBUG: Now in findExistingAccount {"id":207,"name":null,"iban":null,"number":null}
[2024-05-01 09:26:15] production.DEBUG: The search will be reversed!
[2024-05-01 09:26:15] production.DEBUG: Found nothing!
[2024-05-01 09:26:15] production.ERROR: Could not validate source or destination.
[2024-05-01 09:26:15] production.ERROR: Destination: Could not find a valid destination account when searching for ID "207" or name "".
[2024-05-01 09:26:15] production.ERROR: The createJournal() method returned NULL. This may indicate an error.
[2024-05-01 09:26:15] production.WARNING: Group repository caught group factory with an exception!
[2024-05-01 09:26:15] production.ERROR: Created zero transaction journals.
As I understand it, this claims that the account with ID=207 does not exist. However:
mysql> select * from accounts where ID = 207;
+-----+---------------------+---------------------+------------+---------+---------------+-----------------+------------------------+-----------------+------+--------+-----------+-------+
| id | created_at | updated_at | deleted_at | user_id | user_group_id | account_type_id | name | virtual_balance | iban | active | encrypted | order |
+-----+---------------------+---------------------+------------+---------+---------------+-----------------+------------------------+-----------------+------+--------+-----------+-------+
| 207 | 2024-04-04 22:01:29 | 2024-04-04 22:01:29 | NULL | 2 | 2 | 4 | regular saver| NULL | NULL | 1 | 0 | 0 |
+-----+---------------------+---------------------+------------+---------+---------------+-----------------+------------------------+-----------------+------+--------+-----------+-------+
1 row in set (0.00 sec)
Is there any additional debugging I can do here to track down the source of the problem?
Beta Was this translation helpful? Give feedback.
All reactions