[GH-ISSUE #1174] May I ask if 1.15.5 can be upgraded to the latest version? How can I complete the data migration? #482

New issue

Closed

opened 2026-02-25 23:34:19 +03:00 by kerem · 2 comments

kerem commented

2026-02-25 23:34:19 +03:00

Owner

Originally created by @iihorse on GitHub (Dec 6, 2025).
Original GitHub issue: https://github.com/go-shiori/shiori/issues/1174

hello， My image version is 1.15.5, and the mounted 'archive' folder is 20.2G. It uses the default SQLite database and the shiori.db file is 58.8M. When I upgraded the image version to 'latest', the container could not start properly and the backend error was: FATA[2025-12-06T16:20:06Z] Error running migration error="failed to run migrations: 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: constraint failed: FOREIGN KEY constraint failed (787)"。
May I ask if 1.15.5 can be upgraded to the latest version? How can I complete the data migration?

Originally created by @iihorse on GitHub (Dec 6, 2025). Original GitHub issue: https://github.com/go-shiori/shiori/issues/1174 hello， My image version is 1.15.5, and the mounted 'archive' folder is 20.2G. It uses the default SQLite database and the shiori.db file is 58.8M. When I upgraded the image version to 'latest', the container could not start properly and the backend error was: FATA[2025-12-06T16:20:06Z] Error running migration error="failed to run migrations: 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: constraint failed: FOREIGN KEY constraint failed (787)"。 May I ask if 1.15.5 can be upgraded to the latest version? How can I complete the data migration?

kerem closed this issue

2026-02-25 23:34:19 +03:00

kerem commented

2026-02-25 23:34:19 +03:00

Author

Owner

@MatthewGP commented on GitHub (Dec 9, 2025):

@iihorse I think you will need to upgrade to v1.5.4 first. If that doesn't auto migrate for you, you may need to read Sqlite migration to FTS5 and try that.

After you upgrade to 1.5.4, I would suggest you then update to v1.6.3, next 1.7.4, and finally 1.8.0. I don't believe you 'must' do those intermediate step upgrades, but I personally would just to make sure any changes made in a feature release are applied.

@MatthewGP commented on GitHub (Dec 9, 2025): @iihorse I think you will need to upgrade to [v1.5.4](https://github.com/go-shiori/shiori/releases/tag/v1.5.4) first. If that doesn't auto migrate for you, you may need to read [Sqlite migration to FTS5](https://github.com/go-shiori/shiori-utils/tree/main/cmd/migration/sqlite-fts4-fts5) and try that. After you upgrade to 1.5.4, I would suggest you then update to v1.6.3, next 1.7.4, and finally 1.8.0. I don't believe you 'must' do those intermediate step upgrades, but I personally would just to make sure any changes made in a feature release are applied.

kerem commented

2026-02-25 23:34:19 +03:00

Author

Owner

@iihorse commented on GitHub (Dec 10, 2025):

It works, Finally! Thanks bro, great work.

@iihorse commented on GitHub (Dec 10, 2025): It works, Finally! Thanks bro, great work.

kerem referenced this issue

2026-02-25 23:34:53 +03:00

[PR #482] [CLOSED] Draft: Use GORM to maintain multi-database layer #609