[GH-ISSUE #432] Error after update 0.12.8 #270

New issue

Closed

opened 2026-02-25 23:33:50 +03:00 by kerem · 2 comments

kerem commented

2026-02-25 23:33:50 +03:00

Owner

Originally created by @rbdevr on GitHub (Jun 1, 2022).
Original GitHub issue: https://github.com/go-shiori/shiori/issues/432

Hi all,

I'm getting the following error when accessing the main page since updating to version 0.12.8.
None of my bookmarks appear.

ERROR

failed to fetch count: SQL logic error: no such module: fts4 (1) (500)

No saved bookmarks yet :(
*

I'm using Shiori with the following parameters:

./shiori serve -p 8523 --webroot /shiori

I'm using Shiori behind apache with ProxyPass.

ProxyPreserveHost on
ProxyRequests off

<Location "/shiori">
Require all granted
ProxyPass http://localhost:8523/shiori
ProxyPassReverse http://localhost:8523/shiori
<//Location> (misstype to avoid message begging hidden

Let me know if you need any more information.

Cheers

Originally created by @rbdevr on GitHub (Jun 1, 2022). Original GitHub issue: https://github.com/go-shiori/shiori/issues/432 Hi all, I'm getting the following error when accessing the main page since updating to version 0.12.8. None of my bookmarks appear. * ERROR failed to fetch count: SQL logic error: no such module: fts4 (1) (500) No saved bookmarks yet :( * I'm using Shiori with the following parameters: ./shiori serve -p 8523 --webroot /shiori I'm using Shiori behind apache with ProxyPass. ProxyPreserveHost on ProxyRequests off <Location "/shiori"> Require all granted ProxyPass http://localhost:8523/shiori ProxyPassReverse http://localhost:8523/shiori <//Location> (misstype to avoid message begging hidden Let me know if you need any more information. Cheers

kerem

2026-02-25 23:33:50 +03:00

closed this issue
added the
component:backend

database:sqlite

tag:stale
labels

kerem commented

2026-02-25 23:33:50 +03:00

Author

Owner

@fmartingr commented on GitHub (Jun 2, 2022):

Hello @rbdevr. Shiori 1.5.1 included a breaking change in the SQLite implementation, if you're upgrading from an earlier release you need to use this tool to upgrade the content database from fts4 to fts5.

No data loss is expected, but as always, make a backup first just in case.

Please let me know if this fixes your issue.

@fmartingr commented on GitHub (Jun 2, 2022): Hello @rbdevr. Shiori 1.5.1 [included a breaking change](https://github.com/go-shiori/shiori/releases/tag/v1.5.1) in the SQLite implementation, if you're upgrading from an earlier release you need to use [this tool](https://github.com/go-shiori/shiori-utils/tree/main/cmd/migration/sqlite-fts4-fts5) to upgrade the content database from fts4 to fts5. No data loss is expected, but as always, make a backup first just in case. Please let me know if this fixes your issue.

kerem commented

2026-02-25 23:33:50 +03:00

Author

Owner

@stale[bot] commented on GitHub (Jul 23, 2022):

This issue has been automatically marked as stale because it has not had any activity for quite some time.
It will be closed if no further activity occurs.
Thank you for your contributions.

@stale[bot] commented on GitHub (Jul 23, 2022): This issue has been automatically marked as stale because it has not had any activity for quite some time. It will be closed if no further activity occurs. Thank you for your contributions.

kerem referenced this issue

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

[PR #379] [CLOSED] FTS5 migration #580