Emby Server

[EthanChan1 0]

My emby can't remove and change the media library

embyserver.txt

[Happy2Play 9459]

Were you ever on beta server?

2025-04-14 21:13:14.240 Info App: Sqlite: 1 - no such tokenizer: simple in "insert into fts_search9 (RowId, Name, OriginalTitle, SeriesName, Album) values (@Id,@Name,@OriginalTitle,@SeriesName,@Album)"
2025-04-14 21:13:14.240 Error SqliteItemRepository: Error saving items
	*** Error Report ***
	Version: 4.8.11.0
	Command line: /volume1/@appstore/EmbyServer/system/EmbyServer.dll -programdata /var/packages/EmbyServer/var -ffdetect /var/packages/EmbyServer/target/bin/ffdetect -ffmpeg /var/packages/EmbyServer/target/bin/ffmpeg -ffprobe /var/packages/EmbyServer/target/bin/ffprobe -nolocalportconfig -ignore_vaapi_enabled_flag -pidfile /var/packages/EmbyServer/var/EmbyServer.pid -defaultdirectory /volume1/Public -updatepackage emby-server-synology72_{version}_x86_64.spk -noautorunwebapp
	Operating system: Linux version 4.4.302+ (root@build5) (gcc version 12.2.0 (GCC) ) #69057 SMP Sat Sep 23 21:48:04 CST 2023
	Framework: .NET 6.0.36
	OS/Process: x64/x64
	Runtime: volume1/@appstore/EmbyServer/system/System.Private.CoreLib.dll
	Processor count: 4
	Data path: /var/packages/EmbyServer/var
	Application path: /volume1/@appstore/EmbyServer/system
	SQLitePCL.pretty.SQLiteException: Error: no such tokenizer: simple - insert into fts_search9 (RowId, Name, OriginalTitle, SeriesName, Album) values (@Id,@Name,@OriginalTitle,@SeriesName,@Album)
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, ReadOnlySpan`1& tail)
	   at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItemsInTranscation(IDatabaseConnection db, List`1 tuples, MetadataRefreshOptions metadataRefreshOptions)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, MetadataRefreshOptions metadataRefreshOptions, Action`1 afterSave, Boolean disableForeignKeys, CancellationToken cancellationToken)
	Source: SQLitePCL.pretty
	TargetSite: SQLitePCL.pretty.IStatement PrepareStatement(System.String, System.ReadOnlySpan`1[System.Byte] ByRef)
	
2025-04-14 21:13:14.241 Error App: Error refreshing metadata for library USA 76757
	*** Error Report ***
	Version: 4.8.11.0
	Command line: /volume1/@appstore/EmbyServer/system/EmbyServer.dll -programdata /var/packages/EmbyServer/var -ffdetect /var/packages/EmbyServer/target/bin/ffdetect -ffmpeg /var/packages/EmbyServer/target/bin/ffmpeg -ffprobe /var/packages/EmbyServer/target/bin/ffprobe -nolocalportconfig -ignore_vaapi_enabled_flag -pidfile /var/packages/EmbyServer/var/EmbyServer.pid -defaultdirectory /volume1/Public -updatepackage emby-server-synology72_{version}_x86_64.spk -noautorunwebapp
	Operating system: Linux version 4.4.302+ (root@build5) (gcc version 12.2.0 (GCC) ) #69057 SMP Sat Sep 23 21:48:04 CST 2023
	Framework: .NET 6.0.36
	OS/Process: x64/x64
	Runtime: volume1/@appstore/EmbyServer/system/System.Private.CoreLib.dll
	Processor count: 4
	Data path: /var/packages/EmbyServer/var
	Application path: /volume1/@appstore/EmbyServer/system
	SQLitePCL.pretty.SQLiteException: Error: no such tokenizer: simple - insert into fts_search9 (RowId, Name, OriginalTitle, SeriesName, Album) values (@Id,@Name,@OriginalTitle,@SeriesName,@Album)
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, ReadOnlySpan`1& tail)
	   at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItemsInTranscation(IDatabaseConnection db, List`1 tuples, MetadataRefreshOptions metadataRefreshOptions)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, MetadataRefreshOptions metadataRefreshOptions, Action`1 afterSave, Boolean disableForeignKeys, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, MetadataRefreshOptions metadataRefreshOptions, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.Library.LibraryManager.UpdateItems(List`1 items, BaseItem parent, ItemUpdateType updateReason, Boolean setDateLastSaved, Boolean saveMetadata, MetadataRefreshOptions metadataRefreshOptions, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.Library.LibraryManager.UpdateItems(List`1 items, BaseItem parent, ItemUpdateType updateReason, MetadataRefreshOptions metadataRefreshOptions, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.Library.LibraryManager.UpdateItem(BaseItem item, BaseItem parent, ItemUpdateType updateReason, MetadataRefreshOptions metadataRefreshOptions)
	   at MediaBrowser.Controller.Entities.BaseItem.UpdateToRepository(ItemUpdateType updateReason, BaseItem parent, MetadataRefreshOptions metadataRefreshOptions)
	   at MediaBrowser.Controller.Entities.BaseItem.UpdateToRepository(ItemUpdateType updateReason, MetadataRefreshOptions metadataRefreshOptions)
	   at Emby.Providers.Manager.MetadataService`2.SaveItem(MetadataResult`1 result, Boolean isFirstRefresh, LibraryOptions libraryOptions, ItemUpdateType reason, IDirectoryService directoryService, MetadataRefreshOptions metadataRefreshOptions, CancellationToken cancellationToken)
	   at Emby.Providers.Manager.MetadataService`2.RefreshMetadata(BaseItem item, MetadataRefreshOptions refreshOptions, BaseItem[] collectionFolders, LibraryOptions libraryOptions, CancellationToken cancellationToken)
	   at MediaBrowser.Controller.Entities.BaseItem.RefreshMetadata(MetadataRefreshOptions options, BaseItem[] collectionFolders, LibraryOptions libraryOptions, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.Library.LibraryManager.ValidateTopLibraryFolders(IDirectoryService directoryService, CancellationToken cancellationToken)
	Source: SQLitePCL.pretty
	TargetSite: SQLitePCL.pretty.IStatement PrepareStatement(System.String, System.ReadOnlySpan`1[System.Byte] ByRef)

But look similar to the issue in this topic.

 

[EthanChan1 0]

no i dont have test server

[Happy2Play 9459]

Dev will have to comment further as it may be that plugin related also.

But will guess you will need to do the same as the other poster modifying the db.

[Luke 40142]

Have you ever installed the StrmAssistant plugin?

[EthanChan1 0]

1 hour ago, Luke said:

您是否安装过 StrmAssistant 插件？

Sure，I've already installed it, could that be the problem?

[Luke 40142]

On 4/20/2025 at 1:17 AM, EthanChan1 said:

Sure，I've already installed it, could that be the problem?

Yes I think so, and to make matters worse, it might have altered the Emby database in a way that won't be fixed just by removing the StrmAssistant plugin. You might have to make a fresh start.

[EthanChan1 0]

On 2025/4/22 at AM10点02分, Luke said:

是的，我认为是这样。更糟糕的是，它可能已经修改了 Emby 数据库，而仅仅移除 StrmAssistant 插件是无法修复的。你可能需要重新开始。

I do an uninstall and it says I can't remove the media library.

[EthanChan1 0]

On 4/22/2025 at 10:02 AM, Luke said:

Yes I think so, and to make matters worse, it might have altered the Emby database in a way that won't be fixed just by removing the StrmAssistant plugin. You might have to make a fresh start.

Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.

[Luke 40142]

16 minutes ago, EthanChan1 said:

I do an uninstall and it says I can't remove the media library.

To make a fresh start you also need to delete the server data folder:

Emby Server Data Folder

[waitalone_cn 0]

https://github.com/sjtuross/StrmAssistant/wiki/中文搜索增强
 

Maybe the link above will help you, I also encountered this and I tried to recover.

See Option 1 and Option 2 at the bottom.