Shiori won't start - database problem?

Data

• Shiori version: 1.74
• Database Engine: SQLite
• Operating system: Windows 10 Pro
• CLI/Web interface/Web Extension: CLI (but nothing else is working either, since server won't start)

Describe the bug / actual behavior

When I try to start the server from the command line using this .bat file:

e:
set SHIORI_DIR = [my preferred db location]
cd [location where shiori.exe is]
shiori --portable
shiori server -p [myportnumber]

I get this error message: time="2025-09-23T02:30:36-04:00" level=fatal msg="Error running migration" error="failed to run migration from 0.4.0 to 0.5.0: failed to run transaction: failed to execute migration 0.4.0 to 0.5.0: SQL logic error: no such column: modified (1)"

Shiori had been working previously, but I suddenly got this startup error, suggesting there is some confusion between Shiori and my database.

Expected behavior

Shiori server should start as usual

To Reproduce

see above

Screenshots

If applicable, add screenshots to help explain your problem.

Notes

I have tried the following (with no improvement)

1. Restore shiori.db from a recent backup
2. Power-cycle computer
3. Use a SQLite browser to see if there's some database problem I can see (for example, there is no column named "modified (1)" or anything similar
4. I ran sqlite3 and did a .dump of the database - so whatever is going on with it, sqlite can still read it.
5. Renamed shori.db to something else to prevent it from being used
6. Start Shiori again
7. It starts and creates a new, empty database (no "modified (1)" column there, either.
8. Conclusion: there is some mismatch in expectations between the Shiori code and the database, but I can't figure out what it might be. Error mentions SQL and migration. I'm not migrating anything (I've only ever used 1.74, for example and don't use SQLite for anything else).