i cant search anything

[lvminghan 0]

i cant get anything when i search, the log shows http/1.0 Response 500 to host

 

 

*** Error Report ***

Version: 4.8.9.0

Command line: /system/EmbyServer.dll -programdata /config -ffdetect /bin/ffdetect -ffmpeg /bin/ffmpeg -ffprobe /bin/ffprobe -restartexitcode 3

Operating system: Linux version 6.6.51+rpt-rpi-v8 (serge@raspberrypi.com) (gcc-12 (Debian 12.2.0-14) 12.2.0, GNU ld (GNU Binutils for Debian) 2.40) #1 SMP PREEMPT Debia

Framework: .NET 6.0.31

OS/Process: arm64/arm64

Runtime: system/System.Private.CoreLib.dll

Processor count: 4

Data path: /config

Application path: /system

SQLitePCL.pretty.SQLiteException: Error: no such tokenizer: simple - select count(*) OVER() AS TotalRecordCount,A.type,A.Id,A.StartDate,A.EndDate,A.IsMovie,A.IsSeries,A.IsKids,A.IsSports,A.IsNews,A.IsRepeat,A.IsNew,A.IsPremiere,A.IsLive,A.IndexNumber,A.Name,A.Path,A.ParentIndexNumber,A.ProductionYear,A.RunTimeTicks,A.ParentId,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.Images,A.ExternalId,A.SeriesPresentationUniqueKey,A.Status,A.ChannelNumber,A.SortIndexNumber,A.SortParentIndexNumber,A.IndexNumberEnd,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlaybackPositionTicks,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex,(Select ShareLevel from UserItemShares join AncestorIds2 on AncestorIds2.AncestorId=UserItemShares.ItemId where UserItemShares.UserId=1 and UserItemShares.ShareLevel not null and AncestorIds2.ItemId=A.Id order by Distance limit 1) as ShareLevel from MediaItems A join fts_search9 on A.Id=fts_search9.RowId and fts_search9 match @SearchTerm left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And UserDatas.UserId=1 where A.Type in (1,2,5,6,8,9,10,11,12,13,14,15,16,18,19,20,21,22,23,24,25,26,27,28,29,34) AND (A.Type in (1,2,5,6,8,9,10,11,12,13,14,15,16,18,19,20,21,22,23,24,25,26,28,29,34) OR Coalesce(A.EndDate, 0)>=1739618196) AND (Coalesce(ShareLevel, 0) > 0 OR A.Type in (1,2,9,12,13,14,21,22,23,29,34) OR A.IsPublic=1) AND A.ExtraType is null AND (A.Id in (select ItemLinks2.LinkedId From ItemLinks2 join MediaItems MediaItemsInnerItemLinks on MediaItemsInnerItemLinks.Id=ItemLinks2.ItemId and MediaItemsInnerItemLinks.ExtraType is null where ItemLinks2.Type in (6,4,7,3,2,0,1,5) AND ItemLinks2.ItemId in (select itemid from ancestorids2 where AncestorId=112653)) OR id in ( select linkedid from itemlinks2 where itemid in (select ItemLinks2.LinkedId From ItemLinks2 join MediaItems MediaItemsInnerItemLinks on MediaItemsInnerItemLinks.Id=ItemLinks2.ItemId and MediaItemsInnerItemLinks.ExtraType is null where ItemLinks2.ItemId in (select itemid from ancestorids2 where AncestorId=112653))) OR A.Type in (1,2,5,6,8,10,11,15,16,18,19,20,23,24,25,26,27,28)) Group by (Select Case When A.Type = 27 Then A.SeriesPresentationUniqueKey Else A.PresentationUniqueKey End) ORDER BY A.Type in (1,2,14,21,22,23,27,29,34) ASC,A.Type=23 ASC,Rank ASC,MIN(A.StartDate) ASC LIMIT 50

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.QueryItemsInTransaction[T](InternalItemsQuery query, IDatabaseConnection db, String[] columnsToSelect, Boolean filterColumns, String[] groupBy, Func`5 rowReaderFn, String methodName)

at Emby.Server.Implementations.Data.SqliteItemRepository.GetItems(InternalItemsQuery query)

at MediaBrowser.Controller.Entities.UserRootFolder.GetItemsInternal(InternalItemsQuery query)

at MediaBrowser.Controller.Entities.Folder.GetItems(InternalItemsQuery query)

at Emby.Api.UserLibrary.ItemsService.GetQueryResult(GetItems request, DtoOptions dtoOptions, User user)

at Emby.Api.UserLibrary.ItemsService.GetItems(GetItems request)

at Emby.Api.UserLibrary.ItemsService.Get(GetItems request)

at Emby.Server.Implementations.Services.ServiceController.Execute(HttpListenerHost appHost, Object requestDto, IRequest req, Type serviceType)

at Emby.Server.Implementations.Services.ServiceHandler.ProcessRequestAsync(HttpListenerHost httpHost, IServerApplicationHost appHost, IRequest httpReq, IResponse httpRes, IStreamHelper streamHelper, RestPath restPath, String responseContentType, CancellationToken cancellationToken)

at Emby.Server.Implementations.HttpServer.HttpListenerHost.RequestHandler(IRequest httpReq, ReadOnlyMemory`1 urlString, ReadOnlyMemory`1 localPath, CancellationToken cancellationToken)

Source: SQLitePCL.pretty

TargetSite: SQLitePCL.pretty.IStatement PrepareStatement(System.String, System.ReadOnlySpan`1[System.Byte] ByRef)

 

2025-02-15 19:16:36.687 Info Server: http/1.0 Response 500 to host9. Time: 12ms. GET http://host1/emby/Users/40a02f8503ce4de49d58331a282dcea1/Items?Fields=BasicSyncInfo,CanDelete,PrimaryImageAspectRatio,ProductionYear,Status,EndDate&StartIndex=0&SortBy=SortName&SortOrder=Ascending&EnableImageTypes=Primary,Backdrop,Thumb&ImageTypeLimit=1&Recursive=true&SearchTerm=变形金刚&GroupProgramsBySeries=true&Limit=50&X-Emby-Client=Emby Web&X-Emby-Device-Name=Chrome Windows&X-Emby-Device-Id=44866b26-48bd-4d47-8a9b-c99b18a57ca1&X-Emby-Client-Version=4.8.9.0&X-Emby-Token=x_secret5_x&X-Emby-Language=zh-cn

2025-02-15 19:16:36.689 Error Server: Error processing requestembyserver.txtembyserver.txt

embyserver.txt

[Abobader 3464]

Hello lvminghan,

** This is an auto reply **

Please wait for someone from staff support or our members to reply to you.

It's recommended to provide more info, as it explain in this thread:

Thank you.

Emby Team

[lvminghan 0]

[ebr 16184]

Try this: Corrupt Database

[Happy2Play 9780]

Did you downgrade your server from 4.8.10.0 to 4.8.9.0?  Is there a reason you are on a older server version?

You have quite a few failed plugins and may explain your db issues but dev would have to elaborate on overall changes.  But currently it would appear your db has issues or is toast.

[lvminghan 0]

I reinstalled EMBY, downloaded all the data again, and it's still the same

[lvminghan 0]

All videos can be watched normally, but the search function cannot be used

[ebr 16184]

4 hours ago, lvminghan said:

I reinstalled EMBY, downloaded all the data again, and it's still the same

Hi.  Did you uninstall everything first?

[lvminghan 0]

yes

[Happy2Play 9780]

Might need to see new server logs but reinstalling will not do anything unless you deleted the previous programdata folder as you need a NEW db and reinstalling does not do that.

[lvminghan 0]

I have deleted all the data and reinstalled EMBY, but still cannot search. I have attached the latest logs

embyserver 2.txt

[Luke 42078]

Hi,  how exactly did you install Emby Server?

[Luke 42078]

Quote

I have deleted all the data

What data exactly did you delete?

[lvminghan 0]

docker compose, I deleted all the data about emby and you can assume that I reinstalled it with a new system。

• If there is a problem with the database, why can I still watch the video

[Luke 42078]

What data exactly, where?

[Luke 42078]

And what docker container is it? 

[lvminghan 0]

[lvminghan 0]

What data do I need to delete

[Luke 42078]

I would delete the entire /data folder

[Luke 42078]

14 hours ago, Luke said:

And what docker container is it?