[GH-ISSUE #4157] [Bug]: Update to 25.1.0 failing with sqlite error "SqliteError: no such column: password" #79202

Closed
opened 2026-05-19 02:00:32 -05:00 by GiteaMirror · 1 comment
Owner

Originally created by @rickgardner077 on GitHub (Jan 15, 2025).
Original GitHub issue: https://github.com/actualbudget/actual/issues/4157

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

After updating to 25.1.0 on Docker on Unraid AB does not start. Error log:

/app/node_modules/better-sqlite3/lib/methods/wrappers.js:9
        this[cppdb].exec(sql);
                    ^
SqliteError: no such column: password
    at Database.exec (/app/node_modules/better-sqlite3/lib/methods/wrappers.js:9:14)
    at WrappedDatabase.exec (file:///app/src/db.js:30:20)
    at Migration.up (file:///app/migrations/1718889148000-openid.js:4:24)
    at next (/app/node_modules/migrate/lib/migrate.js:35:45)
    at /app/node_modules/migrate/lib/migrate.js:71:9
    at /app/node_modules/migrate/lib/set.js:84:5
    at FSReqCallback.oncomplete (node:fs:192:23) {
  code: 'SQLITE_ERROR'
}

Node.js v18.20.5

How can we reproduce the issue?

Update to 25.1.0 on Unraid

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

No response

Operating System

Other

Originally created by @rickgardner077 on GitHub (Jan 15, 2025). Original GitHub issue: https://github.com/actualbudget/actual/issues/4157 ### Verified issue does not already exist? - [X] I have searched and found no existing issue ### What happened? After updating to 25.1.0 on Docker on Unraid AB does not start. Error log: ``` /app/node_modules/better-sqlite3/lib/methods/wrappers.js:9 this[cppdb].exec(sql); ^ SqliteError: no such column: password at Database.exec (/app/node_modules/better-sqlite3/lib/methods/wrappers.js:9:14) at WrappedDatabase.exec (file:///app/src/db.js:30:20) at Migration.up (file:///app/migrations/1718889148000-openid.js:4:24) at next (/app/node_modules/migrate/lib/migrate.js:35:45) at /app/node_modules/migrate/lib/migrate.js:71:9 at /app/node_modules/migrate/lib/set.js:84:5 at FSReqCallback.oncomplete (node:fs:192:23) { code: 'SQLITE_ERROR' } Node.js v18.20.5 ``` ### How can we reproduce the issue? Update to 25.1.0 on Unraid ### Where are you hosting Actual? Docker ### What browsers are you seeing the problem on? _No response_ ### Operating System Other
GiteaMirror added the bug label 2026-05-19 02:00:32 -05:00
Author
Owner

@Teprifer commented on GitHub (Jan 15, 2025):

Check out: #3957 - should provide a resolution.

<!-- gh-comment-id:2591977821 --> @Teprifer commented on GitHub (Jan 15, 2025): Check out: #3957 - should provide a resolution.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#79202