Possible bug with “Automatically merge series”

[UrkSomeSetup 0]

I have encountered a possible bug with “Automatically merge series that are spread across multiple folders” as this dose not seem to work

So just some preface my original server died (hardware issue) so I am in the process of rebuilding on the current server, I have set out the folders as so that there are separate folders for each of the media types and format each containing folders separated by age rating. (not sure I explained that very well) so see below:

Animated Films
Animated Films (Raw)
Animated Series
Animated Series (Raw)
Anime Films
Anime Films (Raw)
Anime Series
Anime Series (Raw)
Live Action Films
Live Action Films (Raw)
Live Action Series
Live Action Series (Raw)

each of these contains the following folders:

U
PG
12
15
18

The Raw folders contain Raw Rips waiting to be encoded I did this so I can get everything up and running again quickly, the over folders contains the already encoded ones as its easer to point a macro (for encoding) at a folder than trying to differentiate between files in a folder.

The sub-folders are separated by age for parental control reason (emby seems to struggle in this regard). So the library points to each sub-folder e.g. \Animated Series\15\

Now the issue I am encountering is that the encoded and raw episodes are showing up as a two separate series the below screen shot shows one is the first season fully encoded the other is the second season Raw rip.

Server Specs are as follow:

Server: QNAP HS-264
Operating system: QTS 5.1.6.2722
Emby version: 4.8.7.0

Any help would be greatly appreciated.

[Abobader 3464]

Hello UrkSomeSetup,

** This is an auto reply **

Please wait for someone from staff support or our members to reply to you.

It's recommended to provide more info, as it explain in this thread:

Thank you.

Emby Team

[Happy2Play 9782]

Is this the only show not merging?

Have you ensured they both have the same providerid at Show/Series level?

 

[UrkSomeSetup 0]

most anime only have one season so this it the first occurrence I have checked the metadata both mach screen shot of both side by side (Left Season one, right Season Two):

I tried copying on of the other series the first season of bleach from raw to the other folder so now season one exists in both "\Animated Series\15\Bleach\Season 01\" and "\Animated Series (Raw)\15\Season 01\" then the same thing happened:

 

[Happy2Play 9782]

Only thing I can think is toggling the library merge option off and back on and do a scan.

[UrkSomeSetup 0]

I disabled the option waited a minute before turning it back an and did a "Scan Library Files" and nothing changed.

[Happy2Play 9782]

May need to see server logs but I have been testing most of the day on a series that requires merging do to unsupported structure so I know it works on current stable and beta.

[UrkSomeSetup 0]

hope this i right the most recent log

embyserver.txt

[Happy2Play 9782]

Dev will probably have to comment as you have database issues.  You have lots of these errors.

2024-05-27 19:52:36.515 Error SqliteItemRepository: Error saving items
	*** Error Report ***
	Version: 4.8.7.0
	Command line: /share/CACHEDEV1_DATA/.qpkg/EmbyServer/system/EmbyServer.dll -programdata /share/CACHEDEV1_DATA/.qpkg/EmbyServer/programdata -ffdetect /share/CACHEDEV1_DATA/.qpkg/EmbyServer/bin/ffdetect -ffmpeg /share/CACHEDEV1_DATA/.qpkg/EmbyServer/bin/ffmpeg -ffprobe /share/CACHEDEV1_DATA/.qpkg/EmbyServer/bin/ffprobe -defaultdirectory /share/CACHEDEV1_DATA/Public -updatepackage emby-server-qnap_{version}_x86_64.qpkg
	Operating system: Linux version 5.10.60-qnap (root@U16BuildServer174) (x86_64-QNAP-linux-gnu-gcc (toolchain config: [gcc-4.9.2 binutils-2.25 glibc-2.21]) 4.9.2, GNU ld
	Framework: .NET 6.0.25
	OS/Process: x64/x64
	Runtime: share/CACHEDEV1_DATA/.qpkg/EmbyServer/system/System.Private.CoreLib.dll
	Processor count: 4
	Data path: /share/CACHEDEV1_DATA/.qpkg/EmbyServer/programdata
	Application path: /share/CACHEDEV1_DATA/.qpkg/EmbyServer/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)

May need to see you how you library folders are configured also.

[UrkSomeSetup 0]

The Libraries are as follows:

Animated Films:

\Animated Films (Raw)\12
\Animated Films (Raw)\15
\Animated Films (Raw)\18
\Animated Films (Raw)\PG
\Animated Films (Raw)\U
\Animated Films\12
\Animated Films\15
\Animated Films\18
\Animated Films\PG
\Animated Films\U

Anime Films:

\Anime Films (Raw)\12
\Anime Films (Raw)\15
\Anime Films (Raw)\18
\Anime Films (Raw)\PG
\Anime Films (Raw)\U
\Anime Films\12
\Anime Films\15
\Anime Films\18
\Anime Films\PG
\Anime Films\U

Animated Movies:

\Animated Films\12
\Animated Films\15
\Animated Films\18
\Animated Films\PG
\Animated Films\U
\Anime Films\12
\Anime Films\15
\Anime Films\18
\Anime Films\PG
\Anime Films\U

Animated Series:

\Animated Series (Raw)\12
\Animated Series (Raw)\15
\Animated Series (Raw)\18
\Animated Series (Raw)\PG
\Animated Series (Raw)\U
\Animated Series\12
\Animated Series\15
\Animated Series\18
\Animated Series\PG
\Animated Series\U

Anime Series:

\Anime Series (Raw)\12
\Anime Series (Raw)\15
\Anime Series (Raw)\18
\Anime Series (Raw)\PG
\Anime Series (Raw)\U
\Anime Series\12
\Anime Series\15
\Anime Series\18
\Anime Series\PG
\Anime Series\U

Animated Shows:

\Animated Series\12
\Animated Series\15
\Animated Series\18
\Animated Series\PG
\Animated Series\U
\Anime Series\12
\Anime Series\15
\Anime Series\18
\Anime Series\PG
\Anime Series\U

Live Action Films:

\Live Action Films (Raw)\12
\Live Action Films (Raw)\15
\Live Action Films (Raw)\18
\Live Action Films (Raw)\PG
\Live Action Films (Raw)\U
\Live Action Films\12
\Live Action Films\15
\Live Action Films\18
\Live Action Films\PG
\Live Action Films\U

Live Action Series:

\Live Action Series (Raw)\12
\Live Action Series (Raw)\15
\Live Action Series (Raw)\18
\Live Action Series (Raw)\PG
\Live Action Series (Raw)\U
\Live Action Series\12
\Live Action Series\15
\Live Action Series\18
\Live Action Series\PG
\Live Action Series\U

Hope This Help