2025-04-09, 11:35 AM
(This post was last modified: 2025-04-09, 11:38 AM by chaos2go. Edited 1 time in total.)
thanks for your Replay , yes i know . I tried it first with the new Final release and hat the same Problem .
Found the Issue ...
Had duplicates in the migrated DB
Make A copy of the DB file in "C:\ProgramData\Jellyfin\Server\data"
use https://sqlitebrowser.org/ --> DB Browser --> open DB file to work with
SELECT Type, Value, COUNT(*) as Anzahl
FROM ItemValues
GROUP BY Type, Value
HAVING COUNT(*) > 1;
Search for entries who ar dublicated
SELECT ROWID, Type, Value
FROM ItemValues
WHERE Type = 3 AND Value = 'Dublicate Value entry ';
as example in my case
SELECT ROWID, Type, Value
FROM ItemValues
WHERE Type = 3 AND Value = 'Ay Yapım';
Next step, delete duplicated ROWID
DELETE FROM ItemValues
WHERE ROWID = one Value of a dubplicatet ROWID here;
example
DELETE FROM ItemValues
WHERE ROWID = 125;
now you can check again with
SELECT Type, Value, COUNT(*) as Anzahl
FROM ItemValues
GROUP BY Type, Value
HAVING COUNT(*) > 1;
repeat for each duplicatet value
safe and make sure that the name of DB file is correct --> start jellyfin again.
give him a bit time to run
"i thought it didn't work, my brother said in the morning he couldn't find the new files ...
so now I did a new scan of the libraries and everything is back to normal. "
cheers , hope it helps others too.
and thanks for the cool community
Found the Issue ...
Had duplicates in the migrated DB
Make A copy of the DB file in "C:\ProgramData\Jellyfin\Server\data"
use https://sqlitebrowser.org/ --> DB Browser --> open DB file to work with
SELECT Type, Value, COUNT(*) as Anzahl
FROM ItemValues
GROUP BY Type, Value
HAVING COUNT(*) > 1;
Search for entries who ar dublicated
SELECT ROWID, Type, Value
FROM ItemValues
WHERE Type = 3 AND Value = 'Dublicate Value entry ';
as example in my case
SELECT ROWID, Type, Value
FROM ItemValues
WHERE Type = 3 AND Value = 'Ay Yapım';
Next step, delete duplicated ROWID
DELETE FROM ItemValues
WHERE ROWID = one Value of a dubplicatet ROWID here;
example
DELETE FROM ItemValues
WHERE ROWID = 125;
now you can check again with
SELECT Type, Value, COUNT(*) as Anzahl
FROM ItemValues
GROUP BY Type, Value
HAVING COUNT(*) > 1;
repeat for each duplicatet value
safe and make sure that the name of DB file is correct --> start jellyfin again.
give him a bit time to run
"i thought it didn't work, my brother said in the morning he couldn't find the new files ...

so now I did a new scan of the libraries and everything is back to normal. "
cheers , hope it helps others too.
and thanks for the cool community