[GH-ISSUE #540] Error running migration: SQL logic error: no such module: fts4 (1) in line 0: ALTER TABLE bookmark #302

New issue

Closed

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

kerem commented

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

Owner

Originally created by @idc77 on GitHub (Nov 28, 2022).
Original GitHub issue: https://github.com/go-shiori/shiori/issues/540

Data

Shiori version: 1.5.3
Database Engine: ?
Operating system: Gentoo
CLI/Web interface/Web Extension: ?

Describe the bug / actual behavior

I upgraded from an older version to v1.5.3
After logging in to the web interface, after I shori migrate and ran shiori serve -a 127.0.0.1 -p 13000 --portable the webui displays the message Error running migration: SQL logic error: no such module: fts4 (1) in line 0: ALTER TABLE bookmark and all my bookmarks are gone.

What is fts4? Why is the module missing? Why wasn't it missing before the upgrade?

Expected behavior

No errors message and all bookmarks present

To Reproduce

Steps to reproduce the behavior:
see above

Screenshots

Notes

[ebuild   R    ] dev-db/sqlite-3.39.4:3::gentoo  USE="icu readline -debug -doc -secure-delete -static-libs -tcl -test -tools" ABI_X86="(64) -32 (-x32)" 0 KiB

Originally created by @idc77 on GitHub (Nov 28, 2022). Original GitHub issue: https://github.com/go-shiori/shiori/issues/540 ## Data - **Shiori version**: 1.5.3 - **Database Engine**: ? - **Operating system**: Gentoo - **CLI/Web interface/Web Extension**: ? ## Describe the bug / actual behavior I upgraded from an older version to v1.5.3 After logging in to the web interface, after I `shori migrate` and ran `shiori serve -a 127.0.0.1 -p 13000 --portable` the webui displays the message `Error running migration: SQL logic error: no such module: fts4 (1) in line 0: ALTER TABLE bookmark` and all my bookmarks are gone. What is fts4? Why is the module missing? Why wasn't it missing before the upgrade? ## Expected behavior No errors message and all bookmarks present ## To Reproduce Steps to reproduce the behavior: see above ## Screenshots ## Notes ``` [ebuild R ] dev-db/sqlite-3.39.4:3::gentoo USE="icu readline -debug -doc -secure-delete -static-libs -tcl -test -tools" ABI_X86="(64) -32 (-x32)" 0 KiB ```

kerem

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

closed this issue
added the
resolution:duplicate
label

kerem commented

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

Author

Owner

@idc77 commented on GitHub (Nov 28, 2022):

# sqlite3 ext4
SQLite version 3.39.4 2022-09-29 15:55:41
Enter ".help" for usage hints.
sqlite> pragma compile_options;
ATOMIC_INTRINSICS=1
COMPILER=gcc-11.3.0
DEFAULT_AUTOVACUUM
DEFAULT_CACHE_SIZE=-2000
DEFAULT_FILE_FORMAT=4
DEFAULT_JOURNAL_SIZE_LIMIT=-1
DEFAULT_MMAP_SIZE=0
DEFAULT_PAGE_SIZE=4096
DEFAULT_PCACHE_INITSZ=20
DEFAULT_RECURSIVE_TRIGGERS
DEFAULT_SECTOR_SIZE=4096
DEFAULT_SYNCHRONOUS=2
DEFAULT_WAL_AUTOCHECKPOINT=1000
DEFAULT_WAL_SYNCHRONOUS=2
DEFAULT_WORKER_THREADS=0
ENABLE_API_ARMOR
ENABLE_BYTECODE_VTAB
ENABLE_COLUMN_METADATA
ENABLE_DBPAGE_VTAB
ENABLE_DBSTAT_VTAB
ENABLE_EXPLAIN_COMMENTS
ENABLE_FTS3
ENABLE_FTS3_PARENTHESIS
ENABLE_FTS4
ENABLE_FTS5
ENABLE_GEOPOLY
ENABLE_HIDDEN_COLUMNS
ENABLE_ICU
ENABLE_MATH_FUNCTIONS
ENABLE_MEMSYS5
ENABLE_NORMALIZE
ENABLE_OFFSET_SQL_FUNC
ENABLE_PREUPDATE_HOOK
ENABLE_RBU
ENABLE_RTREE
ENABLE_SESSION
ENABLE_STMTVTAB
ENABLE_STMT_SCANSTATUS
ENABLE_UNKNOWN_SQL_FUNCTION
ENABLE_UNLOCK_NOTIFY
ENABLE_UPDATE_DELETE_LIMIT
HAVE_ISNAN
MALLOC_SOFT_LIMIT=1024
MAX_ATTACHED=10
MAX_COLUMN=2000
MAX_COMPOUND_SELECT=500
MAX_DEFAULT_PAGE_SIZE=8192
MAX_EXPR_DEPTH=1000
MAX_FUNCTION_ARG=127
MAX_LENGTH=1000000000
MAX_LIKE_PATTERN_LENGTH=50000
MAX_MMAP_SIZE=0x7fff0000
MAX_PAGE_COUNT=1073741823
MAX_PAGE_SIZE=65536
MAX_SQL_LENGTH=1000000000
MAX_TRIGGER_DEPTH=1000
MAX_VARIABLE_NUMBER=32766
MAX_VDBE_OP=250000000
MAX_WORKER_THREADS=8
MUTEX_PTHREADS
SOUNDEX
SYSTEM_MALLOC
TEMP_STORE=1
THREADSAFE=1
USE_URI
sqlite>

@idc77 commented on GitHub (Nov 28, 2022): ``` # sqlite3 ext4 SQLite version 3.39.4 2022-09-29 15:55:41 Enter ".help" for usage hints. sqlite> pragma compile_options; ATOMIC_INTRINSICS=1 COMPILER=gcc-11.3.0 DEFAULT_AUTOVACUUM DEFAULT_CACHE_SIZE=-2000 DEFAULT_FILE_FORMAT=4 DEFAULT_JOURNAL_SIZE_LIMIT=-1 DEFAULT_MMAP_SIZE=0 DEFAULT_PAGE_SIZE=4096 DEFAULT_PCACHE_INITSZ=20 DEFAULT_RECURSIVE_TRIGGERS DEFAULT_SECTOR_SIZE=4096 DEFAULT_SYNCHRONOUS=2 DEFAULT_WAL_AUTOCHECKPOINT=1000 DEFAULT_WAL_SYNCHRONOUS=2 DEFAULT_WORKER_THREADS=0 ENABLE_API_ARMOR ENABLE_BYTECODE_VTAB ENABLE_COLUMN_METADATA ENABLE_DBPAGE_VTAB ENABLE_DBSTAT_VTAB ENABLE_EXPLAIN_COMMENTS ENABLE_FTS3 ENABLE_FTS3_PARENTHESIS ENABLE_FTS4 ENABLE_FTS5 ENABLE_GEOPOLY ENABLE_HIDDEN_COLUMNS ENABLE_ICU ENABLE_MATH_FUNCTIONS ENABLE_MEMSYS5 ENABLE_NORMALIZE ENABLE_OFFSET_SQL_FUNC ENABLE_PREUPDATE_HOOK ENABLE_RBU ENABLE_RTREE ENABLE_SESSION ENABLE_STMTVTAB ENABLE_STMT_SCANSTATUS ENABLE_UNKNOWN_SQL_FUNCTION ENABLE_UNLOCK_NOTIFY ENABLE_UPDATE_DELETE_LIMIT HAVE_ISNAN MALLOC_SOFT_LIMIT=1024 MAX_ATTACHED=10 MAX_COLUMN=2000 MAX_COMPOUND_SELECT=500 MAX_DEFAULT_PAGE_SIZE=8192 MAX_EXPR_DEPTH=1000 MAX_FUNCTION_ARG=127 MAX_LENGTH=1000000000 MAX_LIKE_PATTERN_LENGTH=50000 MAX_MMAP_SIZE=0x7fff0000 MAX_PAGE_COUNT=1073741823 MAX_PAGE_SIZE=65536 MAX_SQL_LENGTH=1000000000 MAX_TRIGGER_DEPTH=1000 MAX_VARIABLE_NUMBER=32766 MAX_VDBE_OP=250000000 MAX_WORKER_THREADS=8 MUTEX_PTHREADS SOUNDEX SYSTEM_MALLOC TEMP_STORE=1 THREADSAFE=1 USE_URI sqlite> ```

kerem commented

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

Author

Owner

@idc77 commented on GitHub (Nov 28, 2022):

https://github.com/go-shiori/shiori-utils/tree/main/cmd/migration/sqlite-fts4-fts5

Seriously, this could've been made

MORE APPARENT ON THE README AT THE TOP OF THE PAGE

instead of wasting 30 minutes of my life

@idc77 commented on GitHub (Nov 28, 2022): https://github.com/go-shiori/shiori-utils/tree/main/cmd/migration/sqlite-fts4-fts5 Seriously, this could've been made # MORE APPARENT ON THE README AT THE TOP OF THE PAGE instead of wasting 30 minutes of my life

kerem referenced this issue

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

[PR #368] [MERGED] feat: async content download when creating via api #577