actualbudget / actual

A local-first personal finance app
https://actualbudget.org
MIT License
14.24k stars 1.14k forks source link

[Bug]: Update from 23.10 stopped working #1773

Closed andreapx closed 1 year ago

andreapx commented 1 year ago

Verified issue does not already exist?

What happened?

I've pulled the last docker container and when I start it in theweb UI I see "Files" and I can select "My Finances" (underneath it I see "Synching), but when I click on it a popup appers saying We had an unknown problem opening “My-Finances-0de3a9f”. In the log I just see actualbudget | Listening on :::5006..., nothing else.

What error did you receive?

We had an unknown problem opening “My-Finances-0de3a9f”.

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Firefox

Operating System

Linux

salvachiese commented 1 year ago

Hi, Same issue also working docker, try to open GUI in MacOS Sonoma with Safari, and same error "unknown problem opening ....." Same equipment with Brave works good. The issue with Safari begins after the upgrade to 23.10

Kadenar commented 1 year ago

Same issue being seen here after upgrading to latest docker image in Unraid..

Error updating Error: no such table: migrations

Error occurs inside of function - loadBudget(id) as part of the await updateVersion() try catch block. Delving deeper into stack, it appears to error in migrations.ts -> getAppliedMigrations() when executing sqlite query:

const rows = await sqlite.runQuery<{ id: number }>(
    db,
    'SELECT * FROM __migrations__ ORDER BY id ASC',
    [],
    true,
  );
MixTecnico commented 1 year ago

from here the same with centos

nodejs 16 and above same problem

first installation!

Kadenar commented 1 year ago

Clear your cookies for the site and it fixes the issue. Found the solution on their Discord as other users were running into it. Worked for me as well.

image

MixTecnico commented 1 year ago

from here the same with centos

nodejs 16 and above same problem

first installation!

mod security in my case

MatissJanis commented 1 year ago

Thanks for the report.

Is anyone able to provide reproduction instructions?

Kadenar commented 1 year ago

@MatissJanis This issue is resolved by the end user just clearing their cookies / site data.

andreapx commented 1 year ago

Clear your cookies for the site and it fixes the issue. Found the solution on their Discord as other users were running into it. Worked for me as well.

Thanks a lot!!!

Neosaurus commented 2 months ago

I'm having this issue on the new version of the MacOS app after updating. Web GUI still works fine. All are on the latest versions of Actual. Not sure how to clear cookies from the MacOS app