[Bug]: Crash at launch due to database schema mismatch

[omnizach]

Verified issue does not already exist?

• I have searched and found no existing issue
• I will be providing steps how to reproduce the bug (in most cases this will also mean uploading a demo budget file)

What happened?

Using the Docker and the latest release (24.12.0), the container crashes when starting. The error in the log is:

Checking if there are any migrations to run for direction "up"...

/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

Confusingly, there is no migration named 1718889148000-openid that I could find, so I can't get any further in debugging this.

I attempted to downgrade back to 24.11.0, but this broke the client due to the server version being ahead of the client. So, I'm stuck with a non-working deployment.

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Firefox

Operating System

Windows 11

[matt-fidd]

There are some instructions on how to resolve this on the Discord, you can join with this link: https://discord.gg/FnHPqj8j and the thread is https://discord.com/channels/937901803608096828/1310791130492702740