mirror of
https://github.com/actualbudget/actual.git
synced 2026-07-15 22:54:03 -05:00
[Bug]: SqliteError: no such column: categories2.group #2414
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/actual#2414
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @Phil89a on GitHub (Aug 23, 2025).
Verified issue does not already exist?
What happened?
Trying to pull all transactions and the account, category and category group name using ActualQL using
Fails on the category.group.name - remove category.group.name and it works
When it fails I get the below error returned. I assume this a bug ?
How can we reproduce the issue?
Try executing the above query using aqlQuery.
Where are you hosting Actual?
Docker
What browsers are you seeing the problem on?
Safari
Operating System
Mac OSX
@MatissJanis commented on GitHub (Sep 27, 2025):
Easier reproduction:
@Phil89a commented on GitHub (Nov 8, 2025):
Hi - is this suppose to be fixed now ?
Running against latest release and I am still getting the error with category.group.name - "error": "no such column: categories2.group"
`error
SELECT v_transactions_internal_alive.id AS id, v_transactions_internal_alive.is_parent AS is_parent, v_transactions_internal_alive.is_child AS is_child, v_transactions_internal_alive.parent_id AS parent_id, accounts1.id AS account, categories2.id AS category, v_transactions_internal_alive.amount AS amount, payees3.id AS payee, v_transactions_internal_alive.notes AS notes, v_transactions_internal_alive.date AS date, v_transactions_internal_alive.imported_id AS imported_id, v_transactions_internal_alive.error AS error, v_transactions_internal_alive.imported_payee AS imported_payee, v_transactions_internal_alive.starting_balance_flag AS starting_balance_flag, v_transactions_internal_alive.transfer_id AS transfer_id, v_transactions_internal_alive.sort_order AS sort_order, v_transactions_internal_alive.cleared AS cleared, v_transactions_internal_alive.reconciled AS reconciled, v_transactions_internal_alive.tombstone AS tombstone, schedules4.id AS schedule, v_transactions_internal_alive.raw_synced_data AS raw_synced_data, v_transactions_internal_alive.id AS id, accounts1.name AS "account.name", categories2.name AS "category.name", category_groups5.name AS "category.group.name", v_transactions_internal_alive.amount AS amount, payees3.name AS "payee.name", v_transactions_internal_alive.notes AS notes, v_transactions_internal_alive.date AS date, v_transactions_internal_alive.cleared AS cleared, v_transactions_internal_alive.reconciled AS reconciled, schedules4.id AS schedule, v_transactions_internal_alive.transfer_id AS transfer_id, v_transactions_internal_alive.raw_synced_data AS raw_synced_data FROM v_transactions_internal_alive
LEFT JOIN accounts accounts1 ON accounts1.id = v_transactions_internal_alive.account AND accounts1.tombstone = 0
LEFT JOIN categories categories2 ON categories2.id = v_transactions_internal_alive.category AND categories2.tombstone = 0
LEFT JOIN payees payees3 ON payees3.id = v_transactions_internal_alive.payee AND payees3.tombstone = 0
LEFT JOIN schedules schedules4 ON schedules4.id = v_transactions_internal_alive.schedule AND schedules4.tombstone = 0
LEFT JOIN category_groups category_groups5 ON category_groups5.id = categories2."group" AND category_groups5.tombstone = 0
WHERE ((accounts1.offbudget = 0
AND categories2.is_income = 1)) AND v_transactions_internal_alive.is_parent = 0 AND v_transactions_internal_alive.tombstone = 0
`
@MatissJanis commented on GitHub (Nov 8, 2025):
No, this has not been fixed. The issue will be closed once it is patched.
@Phil89a commented on GitHub (Nov 8, 2025):
Thanks still learning how this ticket system works :-)