sql-studio icon indicating copy to clipboard operation
sql-studio copied to clipboard

no such module: spellfix1

Open yowmamasita opened this issue 1 year ago • 2 comments

Opening Plex sqlite database:

./sqlite-studio /var/lib/plexmediaserver/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db --address 0.0.0.0:3030
2024-06-17T07:55:25.304260Z  INFO sqlite_studio: found 82 tables in /var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db
2024-06-17T07:55:25.304454Z  INFO Server::run{addr=0.0.0.0:3030}: warp::server: listening on http://0.0.0.0:3030
2024-06-17T07:55:35.726239Z ERROR sqlite_studio::handlers: error while getting database overview: Rusqlite("no such module: spellfix1")

yowmamasita avatar Jun 17 '24 07:06 yowmamasita

Seems like the Plex SQLite database uses the spellfix1 SQLite extension. I will look into this. We might need to support the most common SQLite extensions.

frectonz avatar Jun 17 '24 08:06 frectonz

Any updates on this? Still get the error when trying to open Plex SQLite databases.

robflate avatar Feb 13 '25 12:02 robflate