mirror of
https://github.com/actualbudget/actual.git
synced 2026-03-10 20:23:07 -05:00
[Bug]: We had an unknown problem opening "<local actual file>" #1301
Closed
opened 2026-02-28 19:39:26 -06:00 by GiteaMirror
·
25 comments
No Branch/Tag Specified
master
matiss/oxlint-no-floating-promises-require-array-sort-compare
ai/custom-theme-dual-prefs
claude/fix-simplefin-batch-sync-O8LcD
matiss/fix-6804
claude/fix-simplefin-ssrf-T31gX
claude/release-notes-validation-X7rvR
add-claude-github-actions-1772738270730
react-query-rules
react-query-useSchedules
matiss/separate-lint-format
dependabot/npm_and_yarn/ajv-6.14.0
cursor/sync-performance-notification-9899
react-query-prefs
matiss/chunked-sync-and-progress-ux
v26.2.1
copilot/sub-pr-6880
fix-react-query-clear-on-close-budget
copilot/sub-pr-6140
feat/auto-note
feat/scoped-bank-sync
cursor/desktop-transactions-react-table-1d0c
fix-exhaustive-deps-App
copilot/fix-find-replace-bug
release/v26.2.0-pre
matiss/browser-tests
mobile-fix-drag-and-drop-across-groups
budget-table-v2
PayeeAutocomplete2
pglite
bugfix/plugins/fix-plugins-sw
feat/plugins/plugins-core-package
prerelease
matiss/unicode-minus-fix
cursor/fix-actual-github-issue-6206-gemini-3-pro-preview-9c37
TransactionFormPage
cursor/implement-mortgage-and-loan-account-type-78ca
tests-update-fill-with-pressSequentially
mobile/link-modal
deps/25.11
cursor/fix-update-vrt-apply-ci-job-dispatch-b324
sync-server-plugins
cursor/propose-patch-for-github-issue-5680-2a18
fix/compiler-preserve-inner-dollar-escapes
cursor/analyze-actual-budget-issue-and-propose-fix-5b70
coderabbitai/docstrings/0c070e5
cursor/add-wip-prefix-and-comment-to-prs-d78d
jfdoming/08-21-auto-focus-on-navigate-in-all-browsers
show-totals-on-mobile-budget-banners
allow-child-transactions-make-transfer
mobile-calculator-keyboard
payee-geolocation
enhance/restore_scroll_position
dm-fix-second-click-on-mobile-new-transaction-2
scrollToLocationBudget
alert-autofix-38
tsconfig-composite
mobile-fix-uncategorized-transactions-on-tracking-budgets
server-budget-handlers
fix-sql-injection-in-cleanup-template
non-chrome-draggable-workaround
mobile-budget-page-swipe-navigation
ts-db-all
stable
dark-theme-with-brand-colors
fix-mobile-delete-group
ts-db-select
UnderKoen/reconcile-context-menu
master-before-server-merge
v25.2.1
ts-runQuery
rename-redux-hooks
UnderKoen/3557-persist-state-in-history
remove-redux-CLOSE_BUDGET
fix-exhaustive-deps-errors-FinancesApp
redux-toolkit-createSlice-backup
accounts-function-component
ts-useSplitsExpanded
loot-core-server-package
useTransactios-in-TransactionEdit
react-aria-input
move-redux-to-desktop-client
QueryState-type
fix-themes-applied-late
mobile-vrts
revert-3295-spendingCardFix
react-aria-button-4
split-payee-on-mobile
twk3/pin-apis-crdt
notes-tag-autocomplete
ts-LoadBackup
dnd-kit
package-upgrades
v26.3.0
v26.2.1
v26.2.0
v26.1.0
v25.12.0
v25.11.0
v25.10.0
v25.9.0
v25.8.0
v25.7.1
v25.7.0
v25.6.1
v25.6.0
v25.5.0
v25.4.0
v25.3.1
v25.3.0
v25.2.1
v25.2.0
v25.1.0
v24.12.0
v24.11.0
v24.10.1
v24.10.0
v24.9.0
v24.8.0
v24.7.0
v24.6.0
v24.5.0
v24.4.0
v24.3.0
v24.2.0
v24.1.0
v23.12.0
v23.11.0
v23.10.0
v23.9.0
v23.8.1
v23.8.0
v23.7.2
v23.7.1
v23.7.0
v23.6.0
v23.5.0
v23.4.2
v23.4.1
v23.4.0
v23.3.2
v23.3.0
v23.2.9
v23.2.5
v23.1.12
v22.12.9
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
regression
reports
responsive
rules
schedules
server
✨ merged
split transactions
tech debt
theme
transaction import
transaction reconciliation
transactions
translations
upstream
user interface
✅ approved
wontfix
Mirrored from GitHub Pull Request
No Label
bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/actual#1301
Reference in New Issue
Block a user
Blocking a user prevents them from interacting with repositories, such as opening or commenting on pull requests or issues. Learn more about blocking 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 @ghost on GitHub (Aug 4, 2024).
Verified issue does not already exist?
What happened?
This is my local actual db that I use to manage my finances.

After the latest update (v24.8.0) which I downloaded from the GitHub repository, the application fails to read my database and gives me an error.

Even if I try to create a new local actual file, it is still giving me the same error as shown in the screenshot above. I have installed the previous version for now since that is not giving me an error (v24.7.0)
Where are you hosting Actual?
Desktop App (Electron)
What browsers are you seeing the problem on?
Other
Operating System
Mac OSX
@josecannete commented on GitHub (Aug 4, 2024):
Same problem here, I've downgraded to 2.4.7.
@psybers commented on GitHub (Aug 6, 2024):
This is a duplicate of #2705.
@MatissJanis commented on GitHub (Aug 6, 2024):
@psybers that's a very similar bug, but I think the root cause might be different.
#2705 - CI runners building bad osx images (both intel and m1)
#3199 - my local build (we're not using the CI runner builds for the releases/downloads page due to #2705) - works on intel, broken on m1 since 24.8.0
@Gazook89 commented on GitHub (Aug 6, 2024):
I have this same issue. I just got started with Actual for the first time last night so I can't comment on changes over time, but will be going with the previous version for now.
On MacOS, Silicon, M3 Pro
@haufhun commented on GitHub (Aug 6, 2024):
Same issue here as well
@MikesGlitch commented on GitHub (Aug 6, 2024):
Would anyone be able to reproduce the error on the latest build and then run the following steps:
If you can paste the contents of the console in here it will help those of us without a mac.
@olets commented on GitHub (Aug 6, 2024):
On Sonoma 14.5, F5 after opening the developer tools doesn't trigger a reload for me. I can trigger a reload by
(no console messages to share because I'm on 24.7.0. Waiting for #2907 so I can make a backup before trying an upgrade)
@MikesGlitch commented on GitHub (Aug 9, 2024):
Note: i've posted this message here as well as they seem like similar issues - https://github.com/actualbudget/actual/issues/2705
I've got a fresh build up here: https://github.com/actualbudget/actual/actions/runs/10319828575?pr=3220
I'm looking for 2 testers, one with a x64 machine and one with an arm64 machine.
I'm expecting the x64 machine to work and the arm64 machine to fail - but want to double check before I try anything else.
For the testers:
@psybers commented on GitHub (Aug 9, 2024):
@MikesGlitch x86 works
@ghost commented on GitHub (Aug 9, 2024):
@MikesGlitch The x64 is working on my M1 Pro but the arm64 is not.
@MikesGlitch commented on GitHub (Aug 9, 2024):
Sweet - can you try this one with your arm64 cpu?
https://github.com/actualbudget/actual/actions/runs/10322929844?pr=3220
@ghost commented on GitHub (Aug 10, 2024):
@MikesGlitch
Getting this error for the arm64. The other one (x64) is working.
@MikesGlitch commented on GitHub (Aug 10, 2024):
Thanks for checking. I think this may have to do with this: https://github.com/electron-userland/electron-builder/issues/8191
The article says you can get around it by running this command on your mac, can you give it a go?
It says it has something to do with app notarization, which we plan on fixing but need to make sure the builds are functioning first.
@kennydrobnack commented on GitHub (Aug 11, 2024):
I tried this and had to use the xattr -c command on the .app to get around the error message saying the app is damaged.
After I got into the console logs, it's pretty clear what's going on. Some part of the app is using Intel bits instead of arm. I triple checked to make sure the app I was running is the Apple Silicon version.
Here's the full error message:
console.error('Server Log:', "[Exception] Error: dlopen(/var/folders/3q/f_7507pn20d28hc11nlvntb80000gn/T/.com.actualbudget.actual.aULCS0, 0x0001): tried: '/var/folders/3q/f_7507pn20d28hc11nlvntb80000gn/T/.com.actualbudget.actual.aULCS0' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64e' or 'arm64')), '/System/Volumes/Preboot/Cryptexes/OS/var/folders/3q/f_7507pn20d28hc11nlvntb80000gn/T/.com.actualbudget.actual.aULCS0' (no such file), '/var/folders/3q/f_7507pn20d28hc11nlvntb80000gn/T/.com.actualbudget.actual.aULCS0' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64e' or 'arm64')), '/private/var/folders/3q/f_7507pn20d28hc11nlvntb80000gn/T/.com.actualbudget.actual.aULCS0' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64e' or 'arm64')), '/System/Volumes/Preboot/Cryptexes/OS/private/var/folders/3q/f_7507pn20d28hc11nlvntb80000gn/T/.com.actualbudget.actual.aULCS0' (no such file), '/private/var/folders/3q/f_7507pn20d28hc11nlvntb80000gn/T/.com.actualbudget.actual.aULCS0' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64e' or 'arm64'))\n at process.func [as dlopen] (node:electron/js2c/node_init:2:2214)\n at Module._extensions..node (node:internal/modules/cjs/loader:1489:18)\n at Object.func [as .node] (node:electron/js2c/node_init:2:2441)\n at Module.load (node:internal/modules/cjs/loader:1214:32)\n at Module._load (node:internal/modules/cjs/loader:1030:12)\n at c._load (node:electron/js2c/node_init:2:13672)\n at Module.require (node:internal/modules/cjs/loader:1242:19)\n at require (node:internal/modules/helpers:176:18)\n at bindings (/Applications/Actual.app/Contents/Resources/app.asar/node_modules/bindings/bindings.js:112:48)\n at new Database (/Applications/Actual.app/Contents/Resources/app.asar/node_modules/better-sqlite3/lib/database.js:48:64) {\n code: 'ERR_DLOPEN_FAILED'\n}\n")
@MikesGlitch commented on GitHub (Aug 11, 2024):
I noticed a electron-rebuild was saying it succeeded when it didn't do anything. I think I fixed it.
Can someone try this one on an arm64 cpu? https://github.com/actualbudget/actual/actions/runs/10339466938?pr=3220
@kennydrobnack commented on GitHub (Aug 11, 2024):
I haven't had a chance to put it through its paces, but it is able to open a budget from my Actual server. Looks like it's fixed. Thanks!
EDIT to add: I still had to do the xattr -c thing to get around the "app is damaged" error. Sorry I forgot to mention that earlier.
@melz commented on GitHub (Aug 12, 2024):
Just tried this the arm64 on a M2. I also had to execute the
xattr -ccommand on the .app to get around the error message saying the app is damaged but it does work after.@MikesGlitch commented on GitHub (Aug 12, 2024):
I have a PR up with the fix, thanks for the help everyone! 🚀
@MikesGlitch commented on GitHub (Aug 12, 2024):
Fixed by https://github.com/actualbudget/actual/pull/3220
@asherljh commented on GitHub (Sep 26, 2024):
Hi there, I'm running v24.9.0 but am still running into this issue. Interestingly, I encounter "We had an unknown problem opening "My-Finances-79046ea" on Firefox on my AMD computer, and my Xiaomi 14, but not on Firefox on my Zenfone 9.
On my computer, it works in the Actual desktop app.
If I create a new file / import my data from the Actual exported .zip, I will be able to access the file for a short while but after I refresn the page a few times I will end up with the error again. Any help? Thanks!
Edit: May have figured it out, I deleted and re-imported a file with the same name across all devices while some (e.g. maybe my old phone, or a chrome tab I used to test it) still had the file open. I deleted the file and made sure i closed Actual on all my devices, synced it, and imported the file back. Seems to be working for now. Sorry for the trouble. Love the app!
@T3chGuy77 commented on GitHub (Apr 18, 2025):
This issue is not fixed or resolved. I still have it on the current version.
@MikesGlitch commented on GitHub (Apr 18, 2025):
What do you see when you open devtools? It's under the View menu > Toggle developer tools.
Can you copy and paste the error here?
@mehrmoudi commented on GitHub (May 18, 2025):
I just ran into this issue. It doesn't happen the first time I open the budget and it downloads it. But every time after it keeps happening. I have to clear browser data/cache to be able to work with my budget.
I see the following message in the console:
Versions:
App: v25.5.0 | Server: v25.5.0@MuffinBeast commented on GitHub (May 26, 2025):
Just installed ActualServer, v25.5.0 on unraid, and started using it today for the first time - ran into this error when trying to get back into my file.
This is my output from Firefox dev tools:
Error updating Error: table preferences already exists
handleError http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:6
exec http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:6
execQuery http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:16
execQuery http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:301
1723665565000 http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:297
applyJavaScript http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:301
applyMigration http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:301
kcab.worker.b147f857d4768d8c57e5.js:304:10987
[Exception] Error: table preferences already exists
handleError http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:6
exec http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:6
execQuery http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:16
execQuery http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:301
1723665565000 http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:297
applyJavaScript http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:301
applyMigration http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:301
kcab.worker.b147f857d4768d8c57e5.js:16:206248
Error updating budget My-Finances-ea433d7 Error: table preferences already exists
handleError http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:6
exec http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:6
execQuery http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:16
execQuery http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:301
1723665565000 http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:297
applyJavaScript http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:301
applyMigration http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:301
kcab.worker.b147f857d4768d8c57e5.js:104:2662
Error updating budget Error: table preferences already exists
handleError http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:6
exec http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:6
execQuery http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:16
execQuery http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:301
1723665565000 http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:297
applyJavaScript http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:301
applyMigration http://10.0.0.2:5006/kcab/kcab.worker.b147f857d4768d8c57e5.js:301
kcab.worker.b147f857d4768d8c57e5.js:304:11242
triggering sync because of visibility change
@MikesGlitch commented on GitHub (May 26, 2025):
Just so everyone knows, that error in that screenshot in the description is a catch-all error. The initial issue here was to do with how better-sqlite was built - which is fixed.
To keep our Github clean(ish) and to give your issues more attention, can you please open a new issue with the information form the devtools logs. There's no point in adding comments to this Issue becuase there's loads of potential problems related to this one user-facing error. We can't tackle them all in one issue.
@MuffinBeast That one looks like a migration error. First thing to do is ensure you have HTTPS setup/running from localhost.