[Bug]: Corrupted file after upgrade. #2173

New Issue

GiteaMirror · 2026-02-28T20:05:29-06:00

GiteaMirror commented

2026-02-28 20:05:29 -06:00

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 closed this issue

2026-02-28 20:05:29 -06:00

GiteaMirror commented

2026-02-28 20:05:29 -06:00

@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

@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

@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

@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.