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

[Bug]: Corrupted file after upgrade. #2173

New Issue
Closed
opened 2026-02-28 20:05:29 -06:00 by GiteaMirror · 4 comments
GiteaMirror commented 2026-02-28 20:05:29 -06:00
Owner
Copy Link

Originally created by @pe1uca on GitHub (Jun 4, 2025).

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

I upgraded from 24.10.1 to 25.6.0, the UI tried to be refreshed, but it just showed a spinner, when trying to access the web page again and open my file a pop-up appeared with "We had an unknown error"
In the browser's console I see this error "Error updating budget Error: error in view v_transactions_internal: no such column: _.raw_synced_data"

How can we reproduce the issue?

  • Start from server 24.10.1
  • Upgrade to 25.6.0
  • Ctrl+F5 on the browser.
  • See some red notifications and a green one about updating the client.
  • Click to update the client.
  • See the notification just stays with the spinner in the button.
  • Open actual in a new tab with browser's console.
  • Try to open the same file.
  • See the pop-up "We had an unknown error", and several messages in the console with "Error updating budget Error: error in view v_transactions_internal: no such column: _.raw_synced_data"

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Firefox

Operating System

Linux

Originally created by @pe1uca on GitHub (Jun 4, 2025). ### Verified issue does not already exist? - [x] I have searched and found no existing issue ### What happened? I upgraded from `24.10.1` to `25.6.0`, the UI tried to be refreshed, but it just showed a spinner, when trying to access the web page again and open my file a pop-up appeared with "We had an unknown error" In the browser's console I see this error "Error updating budget Error: error in view v_transactions_internal: no such column: _.raw_synced_data" ### How can we reproduce the issue? - Start from server `24.10.1` - Upgrade to `25.6.0` - Ctrl+F5 on the browser. - See some red notifications and a green one about updating the client. - Click to update the client. - See the notification just stays with the spinner in the button. - Open actual in a new tab with browser's console. - Try to open the same file. - See the pop-up "We had an unknown error", and several messages in the console with "Error updating budget Error: error in view v_transactions_internal: no such column: _.raw_synced_data" ### Where are you hosting Actual? Docker ### What browsers are you seeing the problem on? Firefox ### Operating System Linux
GiteaMirror added the bug label 2026-02-28 20:05:29 -06:00
GiteaMirror commented 2026-02-28 20:05:29 -06:00
Author
Owner
Copy Link

@youngcw commented on GitHub (Jun 4, 2025):

try doing single updates instead of a bunch of versions all at once

@youngcw commented on GitHub (Jun 4, 2025): try doing single updates instead of a bunch of versions all at once
GiteaMirror commented 2026-02-28 20:05:30 -06:00
Author
Owner
Copy Link

@pe1uca commented on GitHub (Jun 4, 2025):

Will do, once I can recover the data.
Going back to the original version says Rejection: Error: Missing migration file: 1718889148000-openid.js

@pe1uca commented on GitHub (Jun 4, 2025): Will do, once I can recover the data. Going back to the original version says `Rejection: Error: Missing migration file: 1718889148000-openid.js`
GiteaMirror commented 2026-02-28 20:05:30 -06:00
Author
Owner
Copy Link

@pe1uca commented on GitHub (Jun 4, 2025):

Found a backup of the server's data, but when I try to open the file in browser I get this
This budget cannot be loaded with this version of the app. Make sure the app is up-to-date. Do you want to load a backup?

@pe1uca commented on GitHub (Jun 4, 2025): Found a backup of the server's data, but when I try to open the file in browser I get this `This budget cannot be loaded with this version of the app. Make sure the app is up-to-date. Do you want to load a backup?`
GiteaMirror commented 2026-02-28 20:05:31 -06:00
Author
Owner
Copy Link

@pe1uca commented on GitHub (Jun 4, 2025):

Ah, seems this was already reported in the discord server, the issue is with the version 25.3.1.
https://discord.com/channels/937901803608096828/1351308507789529098/1351308507789529098

First I recovered my data from the backup, and had to clear the storage of the browser, having downgraded to my original version.
I upgraded to version 25.2.1, which is the version before the message about the repo actual-server, and everything went fine.
Then to 25.3.1 and the same error appeared: Failed running __global!accounts-balance! Error: no such column: _.raw_synced_data

I had to clear the browser's storage for the file to open.
Upgraded to 25.6.0 and everything good.

Still, the button on the notification "Click the button below to reload and apply the update." keeps spinning indefinitely.

@pe1uca commented on GitHub (Jun 4, 2025): Ah, seems this was already reported in the discord server, the issue is with the version `25.3.1`. https://discord.com/channels/937901803608096828/1351308507789529098/1351308507789529098 First I recovered my data from the backup, and had to clear the storage of the browser, having downgraded to my original version. I upgraded to version [`25.2.1`](https://actualbudget.org/docs/releases/#2521), which is the version before the message about the repo `actual-server`, and everything went fine. Then to [`25.3.1`](https://actualbudget.org/docs/releases/#2531) and the same error appeared: `Failed running __global!accounts-balance! Error: no such column: _.raw_synced_data` I had to clear the browser's storage for the file to open. Upgraded to `25.6.0` and everything good. Still, the button on the notification "Click the button below to reload and apply the update." keeps spinning indefinitely.
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
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#2173
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?