[BUG]: emby无法访问，报Sqlite: 1 - no such column: Album

[pan1560]

提交检查

• 我已经搜索过 Issues，没有找到类似问题
• 我已经使用百度或谷歌搜索过，没有找到类似问题
• 我已经检查过常见问题，没有找到类似问题

描述 bug

docker-compose部署alist+emby，alist启动运行正常，元数据正常，emby启动报错。
完整错误可查看附件

error.log

重现步骤

No response

预期行为

No response

截图

No response

日志

Error App: Error creating StrmAssistant.Plugin
	*** Error Report ***
	Version: 4.8.10.0
	Command line: /system/EmbyServer.dll -programdata /config -ffdetect /bin/ffdetect -ffmpeg /bin/ffmpeg -ffprobe /bin/ffprobe -restartexitcode 3
	Operating system: Linux version 6.12.15-orbstack-00304-gd0ddcf70447d (orbstack@builder) (ClangBuiltLinux clang version 19.1.4 (https://github.com/llvm/llvm-project.git
	Framework: .NET 6.0.31
	OS/Process: arm64/arm64
	Runtime: system/System.Private.CoreLib.dll
	Processor count: 10
	Data path: /config
	Application path: /system
	SimpleInjector.ActivationException: SimpleInjector.ActivationException: No registration for type Plugin could be found and an implicit registration could not be made. Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	 ---> Error: no such column: Album - select type,Id,StartDate,EndDate,IsMovie,IsSeries,IsKids,IsSports,IsNews,IsRepeat,IsNew,IsPremiere,IsLive,CommunityRating,CustomRating,IndexNumber,IsLocked,PreferredMetadataLanguage,PreferredMetadataCountryCode,Width,Height,DateLastRefreshed,Name,Path,PremiereDate,Overview,ParentIndexNumber,ProductionYear,OfficialRating,SortName,RunTimeTicks,Size,Container,DateCreated,DateModified,guid,ParentId,IsInMixedFolder,DateLastSaved,LockedFields,OriginalTitle,CriticRating,SeriesName,Album,AlbumId,SeriesId,PresentationUniqueKey,Tagline,ProviderIds,Images,ProductionLocations,TotalBitrate,ExtraType,ExternalId,SeriesPresentationUniqueKey,Status,DisplayOrder,ThreeDFormat,ChannelNumber,RemoteTrailers,SortIndexNumber,SortParentIndexNumber,IndexNumberEnd,IsPublic from MediaItems where Id=15569
	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.GetItemByIdInternal(IDatabaseConnection db, Int64 id)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.GetItemById(Int64 id)
	   at Emby.Server.Implementations.Library.LibraryManager.GetItemById(Int64 id)
	   at System.Linq.Enumerable.SelectArrayIterator`2.MoveNext()
	   at System.Linq.Enumerable.WhereEnumerableIterator`1.ToArray()
	   at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
	   at MediaBrowser.Controller.Entities.UserRootFolder.GetItemsInternal(InternalItemsQuery query)
	   at MediaBrowser.Controller.Entities.Folder.GetItems(InternalItemsQuery query)
	   at MediaBrowser.Controller.Entities.Folder.GetChildren(InternalItemsQuery query)
	   at Emby.Server.Implementations.Library.LibraryManager.GetVirtualFolders(User user, Boolean includeRefreshState)
	   at Emby.Server.Implementations.Library.LibraryManager.GetVirtualFolders()
	   at StrmAssistant.Common.LibraryApi.UpdateLibraryPathsInScope(String currentScope)
	   at StrmAssistant.Common.LibraryApi..ctor(ILibraryManager libraryManager, IFileSystem fileSystem, IMediaMountManager mediaMountManager, IProviderManager providerManager, IUserManager userManager)
	   at StrmAssistant.Plugin..ctor(IApplicationHost applicationHost, IApplicationPaths applicationPaths, ILogManager logManager, IFileSystem fileSystem, ILibraryManager libraryManager, ISessionManager sessionManager, IItemRepository itemRepository, INotificationManager notificationManager, ILibraryMonitor libraryMonitor, IMediaSourceManager mediaSourceManager, IMediaMountManager mediaMountManager, IProviderManager providerManager, IMediaProbeManager mediaProbeManager, ILocalizationManager localizationManager, IUserManager userManager, IUserDataManager userDataManager, IFfmpegManager ffmpegManager, IMediaEncoder mediaEncoder, IJsonSerializer jsonSerializer, IHttpClient httpClient, IServerApplicationHost serverApplicationHost, IServerConfigurationManager configurationManager, ITaskManager taskManager)
	   at lambda_method52(Closure )
	   at SimpleInjector.InstanceProducer.BuildAndReplaceInstanceCreatorAndCreateFirstInstance()
	   at SimpleInjector.InstanceProducer.GetInstance()
	   --- End of inner exception stack trace ---
	   at SimpleInjector.InstanceProducer.GetInstance()
	   at SimpleInjector.Container.GetInstanceFromProducer(InstanceProducer instanceProducer, Type serviceType)
	   at SimpleInjector.Container.GetInstanceForRootType(Type serviceType)
	   at SimpleInjector.Container.GetInstance(Type serviceType)
	   at Emby.Server.Implementations.ApplicationHost.CreateInstanceSafe(Tuple`2 typeInfo)
	Source: SimpleInjector
	TargetSite: System.Object GetInstance()
	InnerException: SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
	Source: SQLitePCL.pretty
	TargetSite: SQLitePCL.pretty.IStatement PrepareStatement(System.String, System.ReadOnlySpan`1[System.Byte] ByRef)
	   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.GetItemByIdInternal(IDatabaseConnection db, Int64 id)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.GetItemById(Int64 id)
	   at Emby.Server.Implementations.Library.LibraryManager.GetItemById(Int64 id)
	   at System.Linq.Enumerable.SelectArrayIterator`2.MoveNext()
	   at System.Linq.Enumerable.WhereEnumerableIterator`1.ToArray()
	   at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
	   at MediaBrowser.Controller.Entities.UserRootFolder.GetItemsInternal(InternalItemsQuery query)
	   at MediaBrowser.Controller.Entities.Folder.GetItems(InternalItemsQuery query)
	   at MediaBrowser.Controller.Entities.Folder.GetChildren(InternalItemsQuery query)
	   at Emby.Server.Implementations.Library.LibraryManager.GetVirtualFolders(User user, Boolean includeRefreshState)
	   at Emby.Server.Implementations.Library.LibraryManager.GetVirtualFolders()
	   at StrmAssistant.Common.LibraryApi.UpdateLibraryPathsInScope(String currentScope)
	   at StrmAssistant.Common.LibraryApi..ctor(ILibraryManager libraryManager, IFileSystem fileSystem, IMediaMountManager mediaMountManager, IProviderManager providerManager, IUserManager userManager)
	   at StrmAssistant.Plugin..ctor(IApplicationHost applicationHost, IApplicationPaths applicationPaths, ILogManager logManager, IFileSystem fileSystem, ILibraryManager libraryManager, ISessionManager sessionManager, IItemRepository itemRepository, INotificationManager notificationManager, ILibraryMonitor libraryMonitor, IMediaSourceManager mediaSourceManager, IMediaMountManager mediaMountManager, IProviderManager providerManager, IMediaProbeManager mediaProbeManager, ILocalizationManager localizationManager, IUserManager userManager, IUserDataManager userDataManager, IFfmpegManager ffmpegManager, IMediaEncoder mediaEncoder, IJsonSerializer jsonSerializer, IHttpClient httpClient, IServerApplicationHost serverApplicationHost, IServerConfigurationManager configurationManager, ITaskManager taskManager)
	   at lambda_method52(Closure )
	   at SimpleInjector.InstanceProducer.BuildAndReplaceInstanceCreatorAndCreateFirstInstance()
	   at SimpleInjector.InstanceProducer.GetInstance()

设备 (请填写以下信息)

Mac

其他信息

环境：MacOS M4 + OrbStack

[fabulouslevis]

+1

[fabulouslevis]

一样的问题 感觉是新的config有问题

[wyp-g]

数据库初始化的脚本估计不对，少了个字段

[monlor]

应该是最新的emby跟小雅的数据不兼容了

[monlor]

尝试执行脚本更新一下试试

[fabulouslevis]

用了笨方法 在metadata容器 执行 sqlite3 /media/config/data/library.db "ALTER TABLE MediaItems ADD Album TEXT" emby就能打开了

[pan1560]

尝试执行脚本更新一下试试

谢谢回复，尝试按照 @fabulouslevis 的方式已打开，目前没看到有什么问题。

[huanggx1991]

按照@fabulouslevis 的方式在容器内执行命令报字段已存在，重新刷新下emby页面突然打开了…… 奇怪的问题，感谢提供思路。

[smith1000]

用了笨方法 在metadata容器 执行 sqlite3 /media/config/data/library.db "ALTER TABLE MediaItems ADD Album TEXT" emby就能打开了

感谢大佬提供的思路，修改之后，重启容器就可以了

[alwaystest]

应该是最新的emby跟小雅的数据不兼容了

config.mp4 是基于 4.9.0.42，大家自行先去更新emby的版本。

看起来需要更新一下 Emby 镜像的构建版本了