sezsat 0 Posted October 23, 2021 Share Posted October 23, 2021 (edited) Hi emby devs, we have an issue for a user in emby for apple tv, it was working 2 days ago, now after logging in, home screen is loading status only, when you go to the next tab the favorites, its ok but on Home screen its blank. i have attached the emby server log file for you guys. also i have tried the following: delete the emby app on apple tv and reinstall reboot the emby server reboot qnap but still not working, but account is working fine when logged in on an android tv box, web browser and on iOS (iphone/ipad) home screen works fine, but not working only in apple tv. embyserver (4).txt Edited October 23, 2021 by sezsat Link to comment Share on other sites More sharing options...
sezsat 0 Posted October 23, 2021 Author Share Posted October 23, 2021 tried restoring a previous server config backup which includes users, but now all users even the admin user when logged in, the home screen is just blank. also tried reinstalling the emby server in qnap, still same issue. now all users have blank home screen. Link to comment Share on other sites More sharing options...
sezsat 0 Posted October 23, 2021 Author Share Posted October 23, 2021 (edited) hi devs, i got this error where invoking scan library files 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.DeleteItems(Int64[] ids) at Emby.Server.Implementations.Data.SqliteItemRepository.DeleteItems(BaseItem[] items) at Emby.Server.Implementations.Library.LibraryManager.DeleteItem(BaseItem item, DeleteOptions options, BaseItem parent, Boolean notifyParentItem) at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal(IProgress`1 progress, CancellationToken cancellationToken, Boolean recursive, Boolean refreshChildMetadata, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService) at MediaBrowser.Controller.Entities.Folder.ValidateSubFolders(BaseItem[] children, IDirectoryService directoryService, IProgress`1 progress, CancellationToken cancellationToken) at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal(IProgress`1 progress, CancellationToken cancellationToken, Boolean recursive, Boolean refreshChildMetadata, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService) at MediaBrowser.Controller.Entities.Folder.ValidateSubFolders(BaseItem[] children, IDirectoryService directoryService, IProgress`1 progress, CancellationToken cancellationToken) at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal(IProgress`1 progress, CancellationToken cancellationToken, Boolean recursive, Boolean refreshChildMetadata, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService) at MediaBrowser.Controller.Entities.Folder.ValidateSubFolders(BaseItem[] children, IDirectoryService directoryService, IProgress`1 progress, CancellationToken cancellationToken) at MediaBrowser.Controller.Entities.Folder.ValidateChildrenInternal(IProgress`1 progress, CancellationToken cancellationToken, Boolean recursive, Boolean refreshChildMetadata, MetadataRefreshOptions refreshOptions, IDirectoryService directoryService) at Emby.Server.Implementations.Library.LibraryManager.PerformLibraryValidation(IProgress`1 progress, CancellationToken cancellationToken) at Emby.Server.Implementations.Library.LibraryManager.ValidateMediaLibraryInternal(IProgress`1 progress, CancellationToken cancellationToken) at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options) embyserver (5).txt Edited October 23, 2021 by sezsat Link to comment Share on other sites More sharing options...
sezsat 0 Posted October 23, 2021 Author Share Posted October 23, 2021 (edited) hi devs, i am getting this error after manually invoking configuration backup. 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.SqliteUserDataRepository.GetAllUserData(Int64 internalUserId) at Emby.Server.Implementations.Library.UserDataManager.GetAllUserData(Int64 userId) at MBBackup.ServerEntryPoint.BackupUserData(User user, String dest) at MBBackup.ServerEntryPoint.ExecuteBackup(BackupProfile settings, CancellationToken cancellationToken, IProgress`1 progress, Boolean isAuto) at MBBackup.Entities.ScheduledBackupTask.Execute(CancellationToken cancellationToken, IProgress`1 progress) at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options) embyserver (5).txt Edited October 23, 2021 by sezsat Link to comment Share on other sites More sharing options...
Luke 37060 Posted October 23, 2021 Share Posted October 23, 2021 Hi, please go through this: https://support.emby.media/support/solutions/articles/44002210894-corrupt-database And let us know if it helps. Thanks. Link to comment Share on other sites More sharing options...
Happy2Play 8281 Posted October 23, 2021 Share Posted October 23, 2021 Unfortunately per other topics you will need to reset/new database, the last section of the KB above. SQLitePCL.pretty.SQLiteException: Error: cannot rollback - no transaction is active And you have this also SQLitePCL.pretty.SQLiteException: Corrupt: database disk image is malformed But please backup or rename the library.db as it container userdata. If you do not use the Server Configuration Backup plugin we couple possibly salvage the userdatas table from corrupt database. Link to comment Share on other sites More sharing options...
Luke 37060 Posted October 23, 2021 Share Posted October 23, 2021 By the way I've merged all of your topics as they're all connected to this. Thanks. Link to comment Share on other sites More sharing options...
sezsat 0 Posted October 24, 2021 Author Share Posted October 24, 2021 14 hours ago, Happy2Play said: Unfortunately per other topics you will need to reset/new database, the last section of the KB above. SQLitePCL.pretty.SQLiteException: Error: cannot rollback - no transaction is active And you have this also SQLitePCL.pretty.SQLiteException: Corrupt: database disk image is malformed But please backup or rename the library.db as it container userdata. If you do not use the Server Configuration Backup plugin we couple possibly salvage the userdatas table from corrupt database. i did use the server configuration backup plugin, tried to restore from the backups, but unfortunately, the issue persisted and that now the scan library is not working anymore, anyway, i will just have to remove all libraries and re-create each of them. thank you guys Link to comment Share on other sites More sharing options...
Luke 37060 Posted October 24, 2021 Share Posted October 24, 2021 Did you start with a fresh database file as the help topic suggests? Link to comment Share on other sites More sharing options...
sezsat 0 Posted October 25, 2021 Author Share Posted October 25, 2021 hi @Luke yes i started a fresh emby server and restore the whole server config from a backup server that i have. all good now. just have a minor issue with the collections, it doesn't generate its own display image in the home screen. Link to comment Share on other sites More sharing options...
Luke 37060 Posted October 25, 2021 Share Posted October 25, 2021 Thanks for the feedback. Link to comment Share on other sites More sharing options...
Happy2Play 8281 Posted October 25, 2021 Share Posted October 25, 2021 8 hours ago, sezsat said: just have a minor issue with the collections, it doesn't generate its own display image in the home screen. Do you have errors in your log pointing to \data\collections? Link to comment Share on other sites More sharing options...
sezsat 0 Posted October 26, 2021 Author Share Posted October 26, 2021 15 hours ago, Happy2Play said: Do you have errors in your log pointing to \data\collections? yeah, i checked the log, could not find a part of the path (pointing to the collections), how to i point it to the correct path? Link to comment Share on other sites More sharing options...
Luke 37060 Posted October 26, 2021 Share Posted October 26, 2021 Please attach the log file here. Thanks Link to comment Share on other sites More sharing options...
Happy2Play 8281 Posted October 26, 2021 Share Posted October 26, 2021 5 hours ago, Luke said: Please attach the log file here. Thanks multiple topics but log can be found here. https://emby.media/community/index.php?/topic/102855-re-create-collections-in-emby-server-for-qnap/&do=findComment&comment=1082182 Link to comment Share on other sites More sharing options...
sezsat 0 Posted October 27, 2021 Author Share Posted October 27, 2021 all good now, what i did was removed emby server from my qnap. do a fresh install, restore a backup config from another backup qnap. also was able to figure out how to fix the collection with no display image generated on the home screen due to the backup from another qnap uses a different OS and directory. thank you @Happy2Play took me some familiarization, as i am using qnap, used filezilla to figure out what to do, collections now have its own image after copying the data from a backup qnap. all good. thank you. had to copy from this backup qnap: /share/CACHEDEV1_DATA/.qpkg/EmbyServer/programdata/data/collections to this main qnap: /share/ZFS530_DATA/.qpkg/EmbyServer/programdata/data/collections Link to comment Share on other sites More sharing options...
sezsat 0 Posted October 27, 2021 Author Share Posted October 27, 2021 (edited) sorry double post Edited October 27, 2021 by sezsat Link to comment Share on other sites More sharing options...
Luke 37060 Posted October 28, 2021 Share Posted October 28, 2021 Thanks for the feedback. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now