collections not displaying

[thelangs 2]

Not sure when this stopped working, but I am on 4.5.2.0..  When I select a "collection" let's say "star trek movies"..  Nothing shows up, the screen is blank, no sub-screen showing all the star trek movies in the collection. This happens for all collections.  I tried it on the web browser of emby and on the shield , same results.

any thoughts ?

[ebr 16187]

Hi.  Can we please look at details of an example?  Specifically the log from when you tried that?

 

[thelangs 2]

Here is a fresh restart log.

Screen 3 - displays the movies with "back to the future" as a boxset

Screen 4 - displays the screen after selecting the boxset

Screen 5 - displays the movies with "group by collection" OFF

This the same results for all boxsets.

hardware_detection-63738346897.txt embyserver.txt

Edited October 15, 2020 by thelangs

[Happy2Play 9783]

@Luke Isn't this a corrupt library.db?

2020-10-15 08:21:36.184 Error HttpServer: Error processing request
	*** Error Report ***
	Version: 4.5.2.0
	Command line: C:\Users\Home Server\AppData\Roaming\Emby-Server\system\EmbyServer.dll
	Operating system: Microsoft Windows 10.0.19041
	Framework: .NET Core 3.1.8
	OS/Process: x64/x64
	Runtime: C:/Users/Home Server/AppData/Roaming/Emby-Server/system/System.Private.CoreLib.dll
	Processor count: 6
	Data path: C:\Users\Home Server\AppData\Roaming\Emby-Server\programdata
	Application path: C:\Users\Home Server\AppData\Roaming\Emby-Server\system
	SQLitePCL.pretty.SQLiteException: Corrupt: database disk image is malformed
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
	   at SQLitePCL.pretty.StatementImpl.MoveNext()
	   at Emby.Sqlite.SqliteExtensions.ExecuteQuery(IStatement This)+MoveNext()
	   at Emby.Server.Implementations.Data.SqliteItemRepository.QueryItemsInTransaction[T](InternalItemsQuery query, IDatabaseConnection db, String[] columnsToSelect, Func`5 rowReaderFn, Boolean singleResult, String methodName)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.GetItemList(InternalItemsQuery query)
	   at Emby.Server.Implementations.Library.LibraryManager.GetItemList(InternalItemsQuery query, BaseItem[] parents)
	   at Emby.Server.Implementations.Library.UserViewManager.GetItemsForLatestItems(User user, LatestItemsQuery request, DtoOptions options)
	   at Emby.Server.Implementations.Library.UserViewManager.GetLatestItems(LatestItemsQuery request, DtoOptions options)
	   at MediaBrowser.Api.UserLibrary.UserLibraryService.Get(GetLatestMedia request)
	   at Emby.Server.Implementations.Services.ServiceController.Execute(HttpListenerHost appHost, Object requestDto, IRequest req)
	   at Emby.Server.Implementations.Services.ServiceHandler.ProcessRequestAsync(HttpListenerHost appHost, IRequest httpReq, IResponse httpRes, 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: Void CheckOk(SQLitePCLEx.sqlite3, Int32)


2020-10-15 08:22:31.200 Error HttpServer: Error processing request
	*** Error Report ***
	Version: 4.5.2.0
	Command line: C:\Users\Home Server\AppData\Roaming\Emby-Server\system\EmbyServer.dll
	Operating system: Microsoft Windows 10.0.19041
	Framework: .NET Core 3.1.8
	OS/Process: x64/x64
	Runtime: C:/Users/Home Server/AppData/Roaming/Emby-Server/system/System.Private.CoreLib.dll
	Processor count: 6
	Data path: C:\Users\Home Server\AppData\Roaming\Emby-Server\programdata
	Application path: C:\Users\Home Server\AppData\Roaming\Emby-Server\system
	SQLitePCL.pretty.SQLiteException: Corrupt: database disk image is malformed
	SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	   at SQLitePCL.pretty.SQLiteException.CheckOk(sqlite3 db, Int32 rc)
	   at SQLitePCL.pretty.StatementImpl.MoveNext()
	   at Emby.Sqlite.SqliteExtensions.ExecuteQuery(IStatement This)+MoveNext()
	   at System.Linq.Enumerable.TryGetFirst[TSource](IEnumerable`1 source, Boolean& found)
	   at System.Linq.Enumerable.First[TSource](IEnumerable`1 source)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.QueryItemsInTransaction[T](InternalItemsQuery query, IDatabaseConnection db, String[] columnsToSelect, Func`5 rowReaderFn, Boolean singleResult, String methodName)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.GetItems(InternalItemsQuery query)
	   at Emby.Server.Implementations.Library.LibraryManager.GetItemsResult(InternalItemsQuery query)
	   at MediaBrowser.Controller.Entities.Movies.BoxSet.GetItemsInternal(InternalItemsQuery query)
	   at MediaBrowser.Controller.Entities.Folder.GetItems(InternalItemsQuery query)
	   at MediaBrowser.Controller.Entities.Folder.GetRecursiveChildCount(User user)
	   at MediaBrowser.Controller.Entities.Folder.FillUserDataDtoValues(UserItemDataDto dto, BaseItemDto itemDto, User user, DtoOptions options)
	   at Emby.Server.Implementations.Library.UserDataManager.GetUserDataDto(BaseItem item, BaseItemDto itemDto, User user, DtoOptions options)
	   at Emby.Server.Implementations.Dto.DtoService.AttachUserSpecificInfo(BaseItemDto dto, BaseItem item, User user, DtoOptions options)
	   at Emby.Server.Implementations.Dto.DtoService.GetBaseItemDtoInternal(BaseItem item, DtoOptions options, User user)
	   at Emby.Server.Implementations.Dto.DtoService.GetBaseItemDto(BaseItem item, DtoOptions options, User user)
	   at MediaBrowser.Api.UserLibrary.UserLibraryService.Get(GetItem request)
	   at Emby.Server.Implementations.Services.ServiceController.GetTaskResult(Task task)
	   at Emby.Server.Implementations.Services.ServiceHandler.ProcessRequestAsync(HttpListenerHost appHost, IRequest httpReq, IResponse httpRes, 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: Void CheckOk(SQLitePCLEx.sqlite3, Int32)

 

Edited October 15, 2020 by Happy2Play

[Luke 42083]

Yes it is. Please see my response here:

Thanks.

[thelangs 2]

renaming the library.db and rescanning fixed the problem.

Thanks

Note. the library has moved to /programdata/data..  Correct ?

[Happy2Play 9783]

3 minutes ago, thelangs said:

renaming the library.db and rescanning fixed the problem.

Thanks

Note. the library has moved to /programdata/data..  Correct ?

That path is OS specific, but yes that folder contains the library.db.

Note that database contains all your userdata also to creating a new one will loose all watched/resume data.

If you use the server configuration backup plugin you have the ability to restore that specific information.