github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-07-16 15:14:02 -05:00
Code Issues 3.0k Packages Projects Releases 58 Wiki Activity

[GH-ISSUE #5103] [Bug]: <CompileError: Field "$oneof" does not exist in table "categories"> when applying budget template to category #16413

New Issue
Closed
opened 2026-04-14 19:30:55 -05:00 by GiteaMirror · 1 comment
GiteaMirror commented 2026-04-14 19:30:55 -05:00
Owner
Copy Link

Originally created by @ljrafols on GitHub (Jun 4, 2025).
Original GitHub issue: https://github.com/actualbudget/actual/issues/5103

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

When applying a template on a group of categories, the action fails with the following error on the console:

Server Log: [Exception] [CompileError: Field “$oneof” does not exist in table “categories”

Expression stack:
  $$oneof
  {"$oneof":"541836f1-e756-4473-a5d0-6c1d3f06c7fa"}
  filter({
    "$oneof": [
      "541836f1-e756-4473-a5d0-6c1d3f06c7fa",
      "af375fd4-d759-46b3-bffe-74a856151d57",
      "d4b0f075-3343-4408-91ed-fae94f74e5bf",
      "29ec2c58-8cd3-42fe-9187-7b5dfe0f70a6"
    ]
  })]

Image

The templates I passed when checking through the budget options for that month.

How can we reproduce the issue?

This error seems to be reproducible within my own budget file and a sample budget file. My own budget file was created July 2024 or so, hosted on an Actual Docker instance; the issue reproduction sample is fresh from my v25.6.0 Windows desktop app created locally.
Here is a link to the sample budget I created for validating this is not an issue with my specific budget file:
2025-06-04-actual-bug-report.zip

To reproduce:

  1. Create a sample budget file with some fake information.
  2. Enable the experimental feature "goal templates"
  3. In one of the categories under "Usual Expenses", enter "#template-1 1234"
  4. In another category under "Usual Expenses", enter "#template 12 up to 34"
  5. In the category group "Usual Expenses" (not the whole budget) dropdown, click "Apply budget templates"
  6. It will fail with the aforementioned error in the dev console log

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Desktop App (Electron)

Operating System

Windows 11

Originally created by @ljrafols on GitHub (Jun 4, 2025). Original GitHub issue: https://github.com/actualbudget/actual/issues/5103 ### Verified issue does not already exist? - [x] I have searched and found no existing issue ### What happened? When applying a template on a group of categories, the action fails with the following error on the console: ``` Server Log: [Exception] [CompileError: Field “$oneof” does not exist in table “categories” Expression stack: $$oneof {"$oneof":"541836f1-e756-4473-a5d0-6c1d3f06c7fa"} filter({ "$oneof": [ "541836f1-e756-4473-a5d0-6c1d3f06c7fa", "af375fd4-d759-46b3-bffe-74a856151d57", "d4b0f075-3343-4408-91ed-fae94f74e5bf", "29ec2c58-8cd3-42fe-9187-7b5dfe0f70a6" ] })] ``` ![Image](https://github.com/user-attachments/assets/9579ac05-67e0-48e6-9a4c-e1a1c99619b6) The templates I passed when checking through the budget options for that month. ### How can we reproduce the issue? This error seems to be reproducible within my own budget file and a sample budget file. My own budget file was created July 2024 or so, hosted on an Actual Docker instance; the issue reproduction sample is fresh from my v25.6.0 Windows desktop app created locally. Here is a link to the sample budget I created for validating this is not an issue with my specific budget file: [2025-06-04-actual-bug-report.zip](https://github.com/user-attachments/files/20599069/2025-06-04-actual-bug-report.zip) To reproduce: 1. Create a sample budget file with some fake information. 2. Enable the experimental feature "goal templates" 3. In one of the categories under "Usual Expenses", enter "#template-1 1234" 4. In another category under "Usual Expenses", enter "#template 12 up to 34" 5. In the category group "Usual Expenses" (not the whole budget) dropdown, click "Apply budget templates" 6. It will fail with the aforementioned error in the dev console log ### Where are you hosting Actual? Docker ### What browsers are you seeing the problem on? Desktop App (Electron) ### Operating System Windows 11
GiteaMirror added the goal templatesbug labels 2026-04-14 19:30:55 -05:00
GiteaMirror commented 2026-04-14 19:30:56 -05:00
Author
Owner
Copy Link

@thrunkmo commented on GitHub (Jun 5, 2025):

Getting the same error. Applying templates to the entire budget works, but not to individual groups:

Image

index.ts:2 [Exception] CompileError: Field “$oneof” does not exist in table “categories." From my dev console:

Expression stack:
  $$oneof
  {"$oneof":"2fab4d0c-d687-4325-a4f8-69be8be80975"}
  filter({
    "$oneof": [
      "2fab4d0c-d687-4325-a4f8-69be8be80975",
      "2dcd3f6f-e7f4-4dc8-921a-de12e3ce4c3b",
      "1cbaaf71-134a-41da-b410-4ed948063cc7",
      "4407b8c7-084c-4c08-9cd1-9ca66b9471c5",
      "b50a3ac4-5b64-41aa-8f73-683efed09cb5",
      "1c96898f-b8d2-4f49-b32c-1e7ffc680188",
      "6913c75c-13e5-41dc-a710-2fd3c9d83176",
      "6bfe2697-6cbf-413d-a374-966fb2b2730b",
      "12b6d02d-3b52-430a-b185-b712e0837f0d",
      "2d1dbf37-587e-4b6e-9e73-71fb161d6809",
      "8620b071-79ba-4bd0-bfdd-0048023f5c46",
      "a724f1bc-44fa-43f1-9cb4-f5668befcb2e",
      "78fbd5ef-fbbf-40d0-b20c-e6d43d180b1f",
      "6bdc705f-e2fd-482b-a225-f7d49ea5e281",
      "bcd48c11-f183-43ec-8219-956a7aae7362",
      "0e62ec18-f789-400a-8613-68dcf67efaa6"
    ]
  })
<!-- gh-comment-id:2944126463 --> @thrunkmo commented on GitHub (Jun 5, 2025): Getting the same error. Applying templates to the entire budget works, but not to individual groups: ![Image](https://github.com/user-attachments/assets/eb1e8c42-0179-4d4c-b7fc-09141a45f226) index.ts:2 [Exception] CompileError: Field “$oneof” does not exist in table “categories." From my dev console: ``` Expression stack: $$oneof {"$oneof":"2fab4d0c-d687-4325-a4f8-69be8be80975"} filter({ "$oneof": [ "2fab4d0c-d687-4325-a4f8-69be8be80975", "2dcd3f6f-e7f4-4dc8-921a-de12e3ce4c3b", "1cbaaf71-134a-41da-b410-4ed948063cc7", "4407b8c7-084c-4c08-9cd1-9ca66b9471c5", "b50a3ac4-5b64-41aa-8f73-683efed09cb5", "1c96898f-b8d2-4f49-b32c-1e7ffc680188", "6913c75c-13e5-41dc-a710-2fd3c9d83176", "6bfe2697-6cbf-413d-a374-966fb2b2730b", "12b6d02d-3b52-430a-b185-b712e0837f0d", "2d1dbf37-587e-4b6e-9e73-71fb161d6809", "8620b071-79ba-4bd0-bfdd-0048023f5c46", "a724f1bc-44fa-43f1-9cb4-f5668befcb2e", "78fbd5ef-fbbf-40d0-b20c-e6d43d180b1f", "6bdc705f-e2fd-482b-a225-f7d49ea5e281", "bcd48c11-f183-43ec-8219-956a7aae7362", "0e62ec18-f789-400a-8613-68dcf67efaa6" ] }) ```
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
tech-support
theme
transaction import
transaction reconciliation
transactions
translations
upstream
user interface
✅ approved
wontfix
No Label bug goal templates
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#16413
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?