transcoding not work

[abdullah339 2]

Hello everyone, I am facing a problem with transcoding. It does not work when playing the video. @Luke

 

embyserver.txt

Edited August 17, 2024 by abdullah339

[Happy2Play 9781]

Looks like you are having some database issues.

2024-08-17 17:24:44.066 Error SqliteItemRepository: Error saving items
	*** Error Report ***
	Version: 4.8.8.0
	Command line: C:\Users\Admin\AppData\Roaming\Emby-Server\system\EmbyServer.dll -noautorunwebapp
	Operating system: Microsoft Windows 10.0.19045
	Framework: .NET 6.0.30
	OS/Process: x64/x64
	Runtime: C:/Users/Admin/AppData/Roaming/Emby-Server/system/System.Private.CoreLib.dll
	Processor count: 12
	Data path: C:\Users\Admin\AppData\Roaming\Emby-Server\programdata
	Application path: C:\Users\Admin\AppData\Roaming\Emby-Server\system
	SQLitePCL.pretty.SQLiteException: Constraint: FOREIGN KEY constraint failed
	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, String sql)
	   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: Void CheckOk(SQLitePCLEx.sqlite3, Int32)

 

2024-08-17 17:24:44.067 Error BaseItem: Error refreshing item الحلقة 3 9715 E:\emby\show_tv\Arabic\stc\Downtown\Downtown.S01E03.1080p.STC.WEB-DL.AAC2.0.H265-.mkv
	*** Error Report ***
	Version: 4.8.8.0
	Command line: C:\Users\Admin\AppData\Roaming\Emby-Server\system\EmbyServer.dll -noautorunwebapp
	Operating system: Microsoft Windows 10.0.19045
	Framework: .NET 6.0.30
	OS/Process: x64/x64
	Runtime: C:/Users/Admin/AppData/Roaming/Emby-Server/system/System.Private.CoreLib.dll
	Processor count: 12
	Data path: C:\Users\Admin\AppData\Roaming\Emby-Server\programdata
	Application path: C:\Users\Admin\AppData\Roaming\Emby-Server\system
	SQLitePCL.pretty.SQLiteException: Constraint: FOREIGN KEY constraint failed
	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, String sql)
	   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)
	   at Emby.Server.Implementations.Data.SqliteItemRepository.SaveItems(List`1 items, MetadataRefreshOptions metadataRefreshOptions, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.Library.LibraryManager.UpdateItems(List`1 items, BaseItem parent, ItemUpdateType updateReason, Boolean setDateLastSaved, Boolean saveMetadata, MetadataRefreshOptions metadataRefreshOptions, CancellationToken cancellationToken)
	   at Emby.Server.Implementations.Library.LibraryManager.UpdateItem(BaseItem item, BaseItem parent, ItemUpdateType updateReason, MetadataRefreshOptions metadataRefreshOptions)
	   at MediaBrowser.Controller.Entities.BaseItem.UpdateToRepository(ItemUpdateType updateReason, BaseItem parent, MetadataRefreshOptions metadataRefreshOptions)
	   at MediaBrowser.Controller.Entities.BaseItem.UpdateToRepository(ItemUpdateType updateReason, MetadataRefreshOptions metadataRefreshOptions)
	   at Emby.Providers.Manager.MetadataService`2.SaveItem(MetadataResult`1 result, Boolean isFirstRefresh, LibraryOptions libraryOptions, ItemUpdateType reason, IDirectoryService directoryService, MetadataRefreshOptions metadataRefreshOptions, CancellationToken cancellationToken)
	   at Emby.Providers.Manager.MetadataService`2.RefreshMetadata(BaseItem item, MetadataRefreshOptions refreshOptions, BaseItem[] collectionFolders, LibraryOptions libraryOptions, CancellationToken cancellationToken)
	   at MediaBrowser.Controller.Entities.BaseItem.RefreshMetadata(MetadataRefreshOptions options, BaseItem[] collectionFolders, LibraryOptions libraryOptions, CancellationToken cancellationToken)
	   at MediaBrowser.Controller.Entities.BaseItem.RefreshMetadataRecursive(BaseItem[] children, MetadataRefreshOptions refreshOptions, BaseItem[] collectionFolders, LibraryOptions libraryOptions, Boolean recursive, Dictionary`2 newItemIds, IProgress`1 progress, CancellationToken cancellationToken)
	Source: SQLitePCL.pretty
	TargetSite: Void CheckOk(SQLitePCLEx.sqlite3, Int32)

But you appear to have created libraries that are not suppported ie child libraries of parent libraries creating database issues.

	Line  228: 2024-08-17 17:20:34.560 Info LibraryMonitor: E:\emby\Move\Arabic is already being watched by watcher for E:\emby\Move. Adding item 4498

	Line  240: 2024-08-17 17:20:34.563 Info LibraryMonitor: E:\emby\show_tv\Arabic is already being watched by watcher for E:\emby\show_tv. Adding item 6

So you have to remove the Arabic library and provide a different structure for it outside existing libraries.

Edited August 17, 2024 by Happy2Play

[Luke 42079]

@abdullah339has this helped?

[abdullah339 2]

Actually the encryption worked suddenly without any intervention from me. @Luke

I think your review is very useful thank you @Happy2Play
I would like to ask what is the recommended structure to avoid such problems

[Happy2Play 9781]

4 minutes ago, abdullah339 said:

I would like to ask what is the recommended structure to avoid such problems

As long as no library has a path that is part of another library you will be good as there really is no correct answer.

 

[abdullah339 2]

If I want to display all the movies as a section that appears in the emby server, and at the same time I want to divide these movies into Arabic, Indian and Turkish, what is the correct way to do that? @Happy2Play

[Luke 42079]

1 minute ago, abdullah339 said:

If I want to display all the movies as a section that appears in the emby server, and at the same time I want to divide these movies into Arabic, Indian and Turkish, what is the correct way to do that? @Happy2Play

There are several options to do that such as separating by folder, or using tags or collections.

[abdullah339 2]

I use the following:

Emby/

          show_tv/
                     arabic/
                     Turkish/
                     Indian/

Is this structure good? @Luke

 

 

[Happy2Play 9781]

Yes that is good.  Almost any structure is possible you just have to ensure when creating libraries no folder path include a path that already exist in an existing library.

[abdullah339 2]

I first include a library: Emby/show_tv/
Then I create a new library for Arabic and include a path: Emby/show_tv/arabic
Then I create a new library for Hindi and include a path: Emby/show_tv/Turkish
Then I create a new library for Turkish and include a path: Emby/show_tv/Indian

@Happy2Play

 

Is this good or what method do you advise me to follow?

Edited August 26, 2024 by abdullah339

[Happy2Play 9781]

No you add all those folder under Show_TV, so one library with three folder.

If you want three libraries then you would not create the Show_TV library at all.  Each language would be its own library.

Edited August 26, 2024 by Happy2Play

[abdullah339 2]

What if I want to display all libraries and at the same time create the partition that I mentioned to you previously? @Happy2Play

[Happy2Play 9781]

You have two options here

Create a library and point it to 

Emby/show_tv/

or

point it to each language folder  (this method will have no media in root folder show_tv/.

Emby/show_tv/arabic/

Emby/show_tv/Turkish/

Emby/show_tv/Indian/

So no other library can contain any path already used. 

[abdullah339 2]

thank you very much @Happy2Play