issues with adding new content

[icegoddess222 8]

hi ive recently been having a few issues with emby,

 

i have this bug whenever i add new content that it will appear blank like this

and this new content will never load any image or anything and when i click on it

it takes me to a random non existent music page where if i try to play it

 

this error occurs on all new media added to the server and persists until i restart the server and then things will properly identify and be playable, but after a few hours the behavior returns

 

 

is there some way to essentially reinstall the server to hopefully repair any issues without losing all my settings and having to manually reinviting all my users?

 

[Luke 42078]

Hi there, please attach the Emby server log from when the problem occurred:

How to Report a Problem

Thanks!

 

[icegoddess222 8]

hi ive uploaded the logs to a rar here

https://www.mediafire.com/file/rskeelf4r0otcub/server_logs.rar/file

 

i can upload the individual logs too if needed but just did a rar since there were multiple files and wasnt sure which was the most important to upload

[Happy2Play 9780]

Dev will have to comment but looks like this database is having issues.

2025-05-20 10:21:07.748 Info App: Sqlite: 266 - os_win.c:48766: (23) winRead(C:\Users\media\AppData\Roaming\Emby-Server\programdata\data\library.db) - Data error (cyclic redundancy check).
2025-05-20 10:21:07.748 Info App: Sqlite: 266 - statement aborts at 39: [select A.type,A.Id,A.IndexNumber,A.Name,A.Path,A.ParentIndexNumber,A.ProductionYear,A.RunTimeTicks,A.ParentId,A.Album,A.AlbumId,A.Images,UserDatas.IsFavorite,UserDatas.Played,UserDatas
2025-05-20 10:21:07.751 Info App: Sqlite: 1 - statement aborts at 1: [ROLLBACK TRANSACTION] cannot rollback - no transaction is active
2025-05-20 10:21:07.752 Error Server: Error processing request
	*** Error Report ***
	Version: 4.8.11.0
	Command line: C:\Users\media\AppData\Roaming\Emby-Server\system\EmbyServer.dll -noautorunwebapp
	Operating system: Microsoft Windows 10.0.19045
	Framework: .NET 6.0.36
	OS/Process: x64/x64
	Runtime: C:/Users/media/AppData/Roaming/Emby-Server/system/System.Private.CoreLib.dll
	Processor count: 8
	Data path: C:\Users\media\AppData\Roaming\Emby-Server\programdata
	Application path: C:\Users\media\AppData\Roaming\Emby-Server\system
	SQLitePCL.pretty.SQLiteException: Error: cannot rollback - no transaction is active
	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 SQLitePCL.pretty.DatabaseConnection.Execute(IDatabaseConnection This, ReadOnlySpan`1 sqlUtf8)
	   at SQLitePCL.pretty.DatabaseConnection.RollbackTransaction(IDatabaseConnection This)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.GetItemList(InternalItemsQuery query)
	   at Emby.Server.Implementations.Library.LibraryManager.GetItemList(InternalItemsQuery query)
	   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 Emby.Api.UserLibrary.UserLibraryService.Get(GetLatestMedia 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: Void CheckOk(SQLitePCLEx.sqlite3, Int32)

 

2025-05-19 05:55:28.749 Info App: Sqlite: 1 - at most 64 tables in a join in "select A.Id from MediaItems A join fts_search9 on A.Id=fts_search9.RowId and fts_search9 match @SearchTerm and length(A.Name) = 25 Join ItemLinks2 ItemLinksAllAlbumArtistIds0 on
2025-05-19 05:55:28.750 Error SqliteItemRepository: Error saving items
	*** Error Report ***
	Version: 4.8.11.0
	Command line: C:\Users\media\AppData\Roaming\Emby-Server\system\EmbyServer.dll -noautorunwebapp
	Operating system: Microsoft Windows 10.0.19045
	Framework: .NET 6.0.36
	OS/Process: x64/x64
	Runtime: C:/Users/media/AppData/Roaming/Emby-Server/system/System.Private.CoreLib.dll
	Processor count: 8
	Data path: C:\Users\media\AppData\Roaming\Emby-Server\programdata
	Application path: C:\Users\media\AppData\Roaming\Emby-Server\system
	SQLitePCL.pretty.SQLiteException: Error: at most 64 tables in a join - select A.Id from MediaItems A join fts_search9 on A.Id=fts_search9.RowId and fts_search9 match @SearchTerm and length(A.Name) = 25 Join ItemLinks2 ItemLinksAllAlbumArtistIds0 on ItemLinksAllAlbumArtistIds0.ItemId=A.Id and ItemLinksAllAlbumArtistIds0.LinkedId=92320 and ItemLinksAllAlbumArtistIds0.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds1 on ItemLinksAllAlbumArtistIds1.ItemId=A.Id and ItemLinksAllAlbumArtistIds1.LinkedId=226302 and ItemLinksAllAlbumArtistIds1.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds2 on ItemLinksAllAlbumArtistIds2.ItemId=A.Id and ItemLinksAllAlbumArtistIds2.LinkedId=226303 and ItemLinksAllAlbumArtistIds2.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds3 on ItemLinksAllAlbumArtistIds3.ItemId=A.Id and ItemLinksAllAlbumArtistIds3.LinkedId=224459 and ItemLinksAllAlbumArtistIds3.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds4 on ItemLinksAllAlbumArtistIds4.ItemId=A.Id and ItemLinksAllAlbumArtistIds4.LinkedId=224466 and ItemLinksAllAlbumArtistIds4.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds5 on ItemLinksAllAlbumArtistIds5.ItemId=A.Id and ItemLinksAllAlbumArtistIds5.LinkedId=226304 and ItemLinksAllAlbumArtistIds5.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds6 on ItemLinksAllAlbumArtistIds6.ItemId=A.Id and ItemLinksAllAlbumArtistIds6.LinkedId=96602 and ItemLinksAllAlbumArtistIds6.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds7 on ItemLinksAllAlbumArtistIds7.ItemId=A.Id and ItemLinksAllAlbumArtistIds7.LinkedId=226305 and ItemLinksAllAlbumArtistIds7.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds8 on ItemLinksAllAlbumArtistIds8.ItemId=A.Id and ItemLinksAllAlbumArtistIds8.LinkedId=224641 and ItemLinksAllAlbumArtistIds8.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds9 on ItemLinksAllAlbumArtistIds9.ItemId=A.Id and ItemLinksAllAlbumArtistIds9.LinkedId=226306 and ItemLinksAllAlbumArtistIds9.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds10 on ItemLinksAllAlbumArtistIds10.ItemId=A.Id and ItemLinksAllAlbumArtistIds10.LinkedId=92925 and ItemLinksAllAlbumArtistIds10.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds11 on ItemLinksAllAlbumArtistIds11.ItemId=A.Id and ItemLinksAllAlbumArtistIds11.LinkedId=99233 and ItemLinksAllAlbumArtistIds11.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds12 on ItemLinksAllAlbumArtistIds12.ItemId=A.Id and ItemLinksAllAlbumArtistIds12.LinkedId=226307 and ItemLinksAllAlbumArtistIds12.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds13 on ItemLinksAllAlbumArtistIds13.ItemId=A.Id and ItemLinksAllAlbumArtistIds13.LinkedId=222042 and ItemLinksAllAlbumArtistIds13.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds14 on ItemLinksAllAlbumArtistIds14.ItemId=A.Id and ItemLinksAllAlbumArtistIds14.LinkedId=93638 and ItemLinksAllAlbumArtistIds14.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds15 on ItemLinksAllAlbumArtistIds15.ItemId=A.Id and ItemLinksAllAlbumArtistIds15.LinkedId=93177 and ItemLinksAllAlbumArtistIds15.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds16 on ItemLinksAllAlbumArtistIds16.ItemId=A.Id and ItemLinksAllAlbumArtistIds16.LinkedId=93621 and ItemLinksAllAlbumArtistIds16.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds17 on ItemLinksAllAlbumArtistIds17.ItemId=A.Id and ItemLinksAllAlbumArtistIds17.LinkedId=93622 and ItemLinksAllAlbumArtistIds17.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds18 on ItemLinksAllAlbumArtistIds18.ItemId=A.Id and ItemLinksAllAlbumArtistIds18.LinkedId=226308 and ItemLinksAllAlbumArtistIds18.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds19 on ItemLinksAllAlbumArtistIds19.ItemId=A.Id and ItemLinksAllAlbumArtistIds19.LinkedId=224754 and ItemLinksAllAlbumArtistIds19.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds20 on ItemLinksAllAlbumArtistIds20.ItemId=A.Id and ItemLinksAllAlbumArtistIds20.LinkedId=116419 and ItemLinksAllAlbumArtistIds20.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds21 on ItemLinksAllAlbumArtistIds21.ItemId=A.Id and ItemLinksAllAlbumArtistIds21.LinkedId=226309 and ItemLinksAllAlbumArtistIds21.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds22 on ItemLinksAllAlbumArtistIds22.ItemId=A.Id and ItemLinksAllAlbumArtistIds22.LinkedId=226310 and ItemLinksAllAlbumArtistIds22.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds23 on ItemLinksAllAlbumArtistIds23.ItemId=A.Id and ItemLinksAllAlbumArtistIds23.LinkedId=224497 and ItemLinksAllAlbumArtistIds23.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds24 on ItemLinksAllAlbumArtistIds24.ItemId=A.Id and ItemLinksAllAlbumArtistIds24.LinkedId=226311 and ItemLinksAllAlbumArtistIds24.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds25 on ItemLinksAllAlbumArtistIds25.ItemId=A.Id and ItemLinksAllAlbumArtistIds25.LinkedId=226312 and ItemLinksAllAlbumArtistIds25.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds26 on ItemLinksAllAlbumArtistIds26.ItemId=A.Id and ItemLinksAllAlbumArtistIds26.LinkedId=94209 and ItemLinksAllAlbumArtistIds26.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds27 on ItemLinksAllAlbumArtistIds27.ItemId=A.Id and ItemLinksAllAlbumArtistIds27.LinkedId=226313 and ItemLinksAllAlbumArtistIds27.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds28 on ItemLinksAllAlbumArtistIds28.ItemId=A.Id and ItemLinksAllAlbumArtistIds28.LinkedId=224506 and ItemLinksAllAlbumArtistIds28.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds29 on ItemLinksAllAlbumArtistIds29.ItemId=A.Id and ItemLinksAllAlbumArtistIds29.LinkedId=94247 and ItemLinksAllAlbumArtistIds29.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds30 on ItemLinksAllAlbumArtistIds30.ItemId=A.Id and ItemLinksAllAlbumArtistIds30.LinkedId=226314 and ItemLinksAllAlbumArtistIds30.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds31 on ItemLinksAllAlbumArtistIds31.ItemId=A.Id and ItemLinksAllAlbumArtistIds31.LinkedId=226315 and ItemLinksAllAlbumArtistIds31.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds32 on ItemLinksAllAlbumArtistIds32.ItemId=A.Id and ItemLinksAllAlbumArtistIds32.LinkedId=226316 and ItemLinksAllAlbumArtistIds32.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds33 on ItemLinksAllAlbumArtistIds33.ItemId=A.Id and ItemLinksAllAlbumArtistIds33.LinkedId=226317 and ItemLinksAllAlbumArtistIds33.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds34 on ItemLinksAllAlbumArtistIds34.ItemId=A.Id and ItemLinksAllAlbumArtistIds34.LinkedId=226318 and ItemLinksAllAlbumArtistIds34.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds35 on ItemLinksAllAlbumArtistIds35.ItemId=A.Id and ItemLinksAllAlbumArtistIds35.LinkedId=222508 and ItemLinksAllAlbumArtistIds35.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds36 on ItemLinksAllAlbumArtistIds36.ItemId=A.Id and ItemLinksAllAlbumArtistIds36.LinkedId=226319 and ItemLinksAllAlbumArtistIds36.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds37 on ItemLinksAllAlbumArtistIds37.ItemId=A.Id and ItemLinksAllAlbumArtistIds37.LinkedId=95014 and ItemLinksAllAlbumArtistIds37.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds38 on ItemLinksAllAlbumArtistIds38.ItemId=A.Id and ItemLinksAllAlbumArtistIds38.LinkedId=226320 and ItemLinksAllAlbumArtistIds38.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds39 on ItemLinksAllAlbumArtistIds39.ItemId=A.Id and ItemLinksAllAlbumArtistIds39.LinkedId=146473 and ItemLinksAllAlbumArtistIds39.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds40 on ItemLinksAllAlbumArtistIds40.ItemId=A.Id and ItemLinksAllAlbumArtistIds40.LinkedId=226321 and ItemLinksAllAlbumArtistIds40.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds41 on ItemLinksAllAlbumArtistIds41.ItemId=A.Id and ItemLinksAllAlbumArtistIds41.LinkedId=226322 and ItemLinksAllAlbumArtistIds41.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds42 on ItemLinksAllAlbumArtistIds42.ItemId=A.Id and ItemLinksAllAlbumArtistIds42.LinkedId=95455 and ItemLinksAllAlbumArtistIds42.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds43 on ItemLinksAllAlbumArtistIds43.ItemId=A.Id and ItemLinksAllAlbumArtistIds43.LinkedId=96756 and ItemLinksAllAlbumArtistIds43.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds44 on ItemLinksAllAlbumArtistIds44.ItemId=A.Id and ItemLinksAllAlbumArtistIds44.LinkedId=226323 and ItemLinksAllAlbumArtistIds44.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds45 on ItemLinksAllAlbumArtistIds45.ItemId=A.Id and ItemLinksAllAlbumArtistIds45.LinkedId=224559 and ItemLinksAllAlbumArtistIds45.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds46 on ItemLinksAllAlbumArtistIds46.ItemId=A.Id and ItemLinksAllAlbumArtistIds46.LinkedId=226324 and ItemLinksAllAlbumArtistIds46.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds47 on ItemLinksAllAlbumArtistIds47.ItemId=A.Id and ItemLinksAllAlbumArtistIds47.LinkedId=222062 and ItemLinksAllAlbumArtistIds47.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds48 on ItemLinksAllAlbumArtistIds48.ItemId=A.Id and ItemLinksAllAlbumArtistIds48.LinkedId=95955 and ItemLinksAllAlbumArtistIds48.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds49 on ItemLinksAllAlbumArtistIds49.ItemId=A.Id and ItemLinksAllAlbumArtistIds49.LinkedId=93634 and ItemLinksAllAlbumArtistIds49.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds50 on ItemLinksAllAlbumArtistIds50.ItemId=A.Id and ItemLinksAllAlbumArtistIds50.LinkedId=93074 and ItemLinksAllAlbumArtistIds50.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds51 on ItemLinksAllAlbumArtistIds51.ItemId=A.Id and ItemLinksAllAlbumArtistIds51.LinkedId=226325 and ItemLinksAllAlbumArtistIds51.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds52 on ItemLinksAllAlbumArtistIds52.ItemId=A.Id and ItemLinksAllAlbumArtistIds52.LinkedId=226326 and ItemLinksAllAlbumArtistIds52.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds53 on ItemLinksAllAlbumArtistIds53.ItemId=A.Id and ItemLinksAllAlbumArtistIds53.LinkedId=226327 and ItemLinksAllAlbumArtistIds53.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds54 on ItemLinksAllAlbumArtistIds54.ItemId=A.Id and ItemLinksAllAlbumArtistIds54.LinkedId=94658 and ItemLinksAllAlbumArtistIds54.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds55 on ItemLinksAllAlbumArtistIds55.ItemId=A.Id and ItemLinksAllAlbumArtistIds55.LinkedId=226328 and ItemLinksAllAlbumArtistIds55.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds56 on ItemLinksAllAlbumArtistIds56.ItemId=A.Id and ItemLinksAllAlbumArtistIds56.LinkedId=97432 and ItemLinksAllAlbumArtistIds56.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds57 on ItemLinksAllAlbumArtistIds57.ItemId=A.Id and ItemLinksAllAlbumArtistIds57.LinkedId=226329 and ItemLinksAllAlbumArtistIds57.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds58 on ItemLinksAllAlbumArtistIds58.ItemId=A.Id and ItemLinksAllAlbumArtistIds58.LinkedId=226330 and ItemLinksAllAlbumArtistIds58.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds59 on ItemLinksAllAlbumArtistIds59.ItemId=A.Id and ItemLinksAllAlbumArtistIds59.LinkedId=124898 and ItemLinksAllAlbumArtistIds59.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds60 on ItemLinksAllAlbumArtistIds60.ItemId=A.Id and ItemLinksAllAlbumArtistIds60.LinkedId=226331 and ItemLinksAllAlbumArtistIds60.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds61 on ItemLinksAllAlbumArtistIds61.ItemId=A.Id and ItemLinksAllAlbumArtistIds61.LinkedId=226332 and ItemLinksAllAlbumArtistIds61.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds62 on ItemLinksAllAlbumArtistIds62.ItemId=A.Id and ItemLinksAllAlbumArtistIds62.LinkedId=224583 and ItemLinksAllAlbumArtistIds62.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds63 on ItemLinksAllAlbumArtistIds63.ItemId=A.Id and ItemLinksAllAlbumArtistIds63.LinkedId=96384 and ItemLinksAllAlbumArtistIds63.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds64 on ItemLinksAllAlbumArtistIds64.ItemId=A.Id and ItemLinksAllAlbumArtistIds64.LinkedId=226333 and ItemLinksAllAlbumArtistIds64.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds65 on ItemLinksAllAlbumArtistIds65.ItemId=A.Id and ItemLinksAllAlbumArtistIds65.LinkedId=226334 and ItemLinksAllAlbumArtistIds65.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds66 on ItemLinksAllAlbumArtistIds66.ItemId=A.Id and ItemLinksAllAlbumArtistIds66.LinkedId=226335 and ItemLinksAllAlbumArtistIds66.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds67 on ItemLinksAllAlbumArtistIds67.ItemId=A.Id and ItemLinksAllAlbumArtistIds67.LinkedId=226336 and ItemLinksAllAlbumArtistIds67.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds68 on ItemLinksAllAlbumArtistIds68.ItemId=A.Id and ItemLinksAllAlbumArtistIds68.LinkedId=226337 and ItemLinksAllAlbumArtistIds68.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds69 on ItemLinksAllAlbumArtistIds69.ItemId=A.Id and ItemLinksAllAlbumArtistIds69.LinkedId=226338 and ItemLinksAllAlbumArtistIds69.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds70 on ItemLinksAllAlbumArtistIds70.ItemId=A.Id and ItemLinksAllAlbumArtistIds70.LinkedId=226339 and ItemLinksAllAlbumArtistIds70.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds71 on ItemLinksAllAlbumArtistIds71.ItemId=A.Id and ItemLinksAllAlbumArtistIds71.LinkedId=226340 and ItemLinksAllAlbumArtistIds71.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds72 on ItemLinksAllAlbumArtistIds72.ItemId=A.Id and ItemLinksAllAlbumArtistIds72.LinkedId=224613 and ItemLinksAllAlbumArtistIds72.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds73 on ItemLinksAllAlbumArtistIds73.ItemId=A.Id and ItemLinksAllAlbumArtistIds73.LinkedId=226341 and ItemLinksAllAlbumArtistIds73.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds74 on ItemLinksAllAlbumArtistIds74.ItemId=A.Id and ItemLinksAllAlbumArtistIds74.LinkedId=226342 and ItemLinksAllAlbumArtistIds74.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds75 on ItemLinksAllAlbumArtistIds75.ItemId=A.Id and ItemLinksAllAlbumArtistIds75.LinkedId=224619 and ItemLinksAllAlbumArtistIds75.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds76 on ItemLinksAllAlbumArtistIds76.ItemId=A.Id and ItemLinksAllAlbumArtistIds76.LinkedId=224626 and ItemLinksAllAlbumArtistIds76.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds77 on ItemLinksAllAlbumArtistIds77.ItemId=A.Id and ItemLinksAllAlbumArtistIds77.LinkedId=226343 and ItemLinksAllAlbumArtistIds77.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds78 on ItemLinksAllAlbumArtistIds78.ItemId=A.Id and ItemLinksAllAlbumArtistIds78.LinkedId=99473 and ItemLinksAllAlbumArtistIds78.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds79 on ItemLinksAllAlbumArtistIds79.ItemId=A.Id and ItemLinksAllAlbumArtistIds79.LinkedId=224634 and ItemLinksAllAlbumArtistIds79.Type=1 Join ItemLinks2 ItemLinksAllAlbumArtistIds80 on ItemLinksAllAlbumArtistIds80.ItemId=A.Id and ItemLinksAllAlbumArtistIds80.LinkedId=226344 and ItemLinksAllAlbumArtistIds80.Type=1 where A.Type=12 ORDER BY Rank ASC LIMIT 1
	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.GetInternalItemIdsListInTransaction(InternalItemsQuery query, IDatabaseConnection connection)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.CreateItemByNameId[T](IDatabaseConnection db, String name, LinkedItemInfo[] albumArtists, Nullable`1 dateCreated, ProviderIdDictionary identifiableProviderIds, Dictionary`2 additionalProviderIds, String imageUrl, MetadataRefreshOptions metadataRefreshOptions)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveAlbumIfNeeded(IDatabaseConnection db, BaseItem item, LinkedItemInfo[] albumArtists, MetadataRefreshOptions metadataRefreshOptions)
	   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)

 

 

[Luke 42078]

Hi, do you have an album that has a massive number of album artists attached to it?

[icegoddess222 8]

i do have a music library on my server and it does feature multiple albums with multiple album artists, like for example the soundtrack for 'Bomb Rush Cyberfunk' has the album artist set to: "2 Mello; Bxtreme; Charodey Jeddy; Color Plus; cyber milk chan; Doctor Lazer; Dom McLennon; Ethan Goldhammer; GRRL; Hideki Naganuma; kidkanevil; KiloWatts; Klaus Veen; Legove; Leopard Davinci; Louis 707; Olli; Proux; Reso; Sebastian Knight; SKALP; SkyBlew; soia; Swami Sound; wev"

im sure there would be some album artist names that are longer to but thats a quick example i knew of off the top of my head.

 

do you think removing the music library would fix the issue?

[Luke 42078]

On 5/22/2025 at 2:35 PM, icegoddess222 said:

do you think removing the music library would fix the issue?

I suppose it could be something to try, yes. Then let a scan complete after removing, and then try adding it back. Please let us know if that helps.

[icegoddess222 8]

i tried removing the folder and it did not fix the issue

 

i had another issue that was affecting my server that caused Next Up (Legacy) to not populate/appear, so i just decided to reformat the computer entirely and reinstall everything 

[Luke 42078]

OK thanks for following up.