github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-03-09 19:52:56 -05:00
Code Issues 250 Packages Projects Releases 53 Wiki Activity

[Bug]: Error when opening uncategorized transactions page #982

New Issue
Closed
opened 2026-02-28 19:27:10 -06:00 by GiteaMirror · 3 comments
GiteaMirror commented 2026-02-28 19:27:10 -06:00
Owner
Copy Link

Originally created by @joel-jeremy on GitHub (Mar 11, 2024).

Verified issue does not already exist?

  • I have searched and found no existing issue

Is this related to GoCardless, Simplefin or another bank-sync provider?

  • I have checked my server logs and could not see any errors there
  • I will be attaching my server logs to this issue
  • I will be attaching my client-side (browser) logs to this issue
  • I understand that this issue will be automatically closed if insufficient information is provided

What happened?

Steps to reproduce:

  1. Add a new transaction with no category / edit an existing transaction to remove category
  2. Click on the n uncategorized transaction button on the top of the page

What error did you receive?

compiler.ts:440 Uncaught (in promise) oT: Field “category” does not exist in table “schedules”

Expression stack:
  $category
  {"category":{"$eq":null}}
  filter([
    {
      "$and": [
        {
          "_account.closed": false
        }
      ]
    },
    {
      "$or": [
        {
          "_account.offbudget": false,
          "category": null,
          "is_parent": false,
          "$or": [
            {
              "payee.transfer_acct.offbudget": true,
              "payee.transfer_acct": null
            }
          ]
        },
        {
          "_payee.transfer_acct.offbudget": false,
          "category": null,
          "is_parent": false,
          "$or": [
            {
              "payee.transfer_acct.offbudget": true,
              "payee.transfer_acct": null
            }
          ]
        }
      ]
    }
  ])

Where are you hosting Actual?

Fly.io

What browsers are you seeing the problem on?

Chrome, Other

Operating System

Windows 11

Originally created by @joel-jeremy on GitHub (Mar 11, 2024). ### Verified issue does not already exist? - [X] I have searched and found no existing issue ### Is this related to GoCardless, Simplefin or another bank-sync provider? - [ ] I have checked my server logs and could not see any errors there - [ ] I will be attaching my server logs to this issue - [ ] I will be attaching my client-side (browser) logs to this issue - [ ] I understand that this issue will be automatically closed if insufficient information is provided ### What happened? Steps to reproduce: 1. Add a new transaction with no category / edit an existing transaction to remove category 2. Click on the `n uncategorized transaction` button on the top of the page ### What error did you receive? ``` compiler.ts:440 Uncaught (in promise) oT: Field “category” does not exist in table “schedules” Expression stack: $category {"category":{"$eq":null}} filter([ { "$and": [ { "_account.closed": false } ] }, { "$or": [ { "_account.offbudget": false, "category": null, "is_parent": false, "$or": [ { "payee.transfer_acct.offbudget": true, "payee.transfer_acct": null } ] }, { "_payee.transfer_acct.offbudget": false, "category": null, "is_parent": false, "$or": [ { "payee.transfer_acct.offbudget": true, "payee.transfer_acct": null } ] } ] } ]) ``` ### Where are you hosting Actual? Fly.io ### What browsers are you seeing the problem on? Chrome, Other ### Operating System Windows 11
GiteaMirror added the regressionbug labels 2026-02-28 19:27:10 -06:00
GiteaMirror commented 2026-02-28 19:27:11 -06:00
Author
Owner
Copy Link

@joel-jeremy commented on GitHub (Mar 11, 2024):

Seems to be related to the change made in https://github.com/actualbudget/actual/pull/2447. Scheduled transactions are now showing up in uncategorized transactions page.

@joel-jeremy commented on GitHub (Mar 11, 2024): Seems to be related to the change made in https://github.com/actualbudget/actual/pull/2447. Scheduled transactions are now showing up in uncategorized transactions page.
GiteaMirror commented 2026-02-28 19:27:11 -06:00
Author
Owner
Copy Link

@MatissJanis commented on GitHub (Mar 12, 2024):

cc @psybers for visibility (but don't feel pressured to work on this)

@MatissJanis commented on GitHub (Mar 12, 2024): cc @psybers for visibility (but don't feel pressured to work on this)
GiteaMirror commented 2026-02-28 19:27:12 -06:00
Author
Owner
Copy Link

@psybers commented on GitHub (Mar 13, 2024):

Ah, yes. Both the demo data and my local data have 0 transactions as uncategorized, so I missed that case.

This does bring up a good point though: automated testing probably should have caught this. Probably need to look at the test suite and see if it can be extended to catch stuff like this.

Maybe the demo data should also be modified to include some uncategorized transactions? As it is, that feature is not being demo'd.

@psybers commented on GitHub (Mar 13, 2024): Ah, yes. Both the demo data and my local data have 0 transactions as uncategorized, so I missed that case. This does bring up a good point though: automated testing probably should have caught this. Probably need to look at the test suite and see if it can be extended to catch stuff like this. Maybe the demo data should also be modified to include some uncategorized transactions? As it is, that feature is not being demo'd.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
AI generated
API
bank sync
budgeting
bug
can’t replicate
dependencies
docker
documentation
electron
experimental feature
feature
feedback
goal templates
good first issue
help wanted
importers
maintenance
needs info
needs testing
needs triage
needs votes
openid
payees
pull-request
Mirrored from GitHub Pull Request
 regression
reports
responsive
rules
schedules
server
✨ merged
split transactions
tech debt
theme
transaction import
transaction reconciliation
transactions
translations
upstream
user interface
✅ approved
wontfix
No Label bug regression
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#982
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?