Linux [Krypton] Duplicate (invisible) library entries
#1
I'm having this weird problem for a while. It popped up on LibreELEC 7 (Kodi 16) a while ago, but I thought it was a skin problem. I've had a few of the Kodi 17 betas (and now the RC3 with LibreELEC 8 beta 1).

In the library overview, the number of episodes is doubled for a lot of series - and shows a lot of 'unwatched' ones. My default view only shows series with unwatched episodes. All series I have 'finished' have also been showing for a while. When I enter the folder for one of these series, it shows all episodes as watched.

Screenshot:

Image

E.g. Rome has 22 episodes total but is showing 44 (and half 'unwatched'). Sense8 has 12, but shows 24 and half unwatched as well, ... and so on.

It looks like there's something botched in my library; however, multiple cleanups (through the Kodi interface) do not change anything. The files are not there, but Kodi seems to think they are, so I am at loss about how to tackle this. Any tips?

I don't think this is a Linux-specific problem, but since LibreELEC's Linux I put it here. Feel free to move if appropriate.
* MikroTik RB5009UG+S+IN :: ZyXEL GS1900-8HP v1 :: EAP615-Wall v1 :: Netgear GS108T v3 running OpenWrt 23.05
* LibreELEC 11:  HTPC Gigabyte Brix GB-BXA8-5545 with CEC adapter, Sony XR-64A84K :: Desktop AMD Ryzen 7 5800X / Sapphire Nitro+ Radeon 6700XT  / 27" Dell U2717D QHD
* Debian Bookworm x86_64: Celeron G1610, NFS/MariaDB/ZFS server
* Blog
Reply
#2
Anyone? Smile
* MikroTik RB5009UG+S+IN :: ZyXEL GS1900-8HP v1 :: EAP615-Wall v1 :: Netgear GS108T v3 running OpenWrt 23.05
* LibreELEC 11:  HTPC Gigabyte Brix GB-BXA8-5545 with CEC adapter, Sony XR-64A84K :: Desktop AMD Ryzen 7 5800X / Sapphire Nitro+ Radeon 6700XT  / 27" Dell U2717D QHD
* Debian Bookworm x86_64: Celeron G1610, NFS/MariaDB/ZFS server
* Blog
Reply
#3
Bumpity bump.
* MikroTik RB5009UG+S+IN :: ZyXEL GS1900-8HP v1 :: EAP615-Wall v1 :: Netgear GS108T v3 running OpenWrt 23.05
* LibreELEC 11:  HTPC Gigabyte Brix GB-BXA8-5545 with CEC adapter, Sony XR-64A84K :: Desktop AMD Ryzen 7 5800X / Sapphire Nitro+ Radeon 6700XT  / 27" Dell U2717D QHD
* Debian Bookworm x86_64: Celeron G1610, NFS/MariaDB/ZFS server
* Blog
Reply
#4
Nobody? Sad
* MikroTik RB5009UG+S+IN :: ZyXEL GS1900-8HP v1 :: EAP615-Wall v1 :: Netgear GS108T v3 running OpenWrt 23.05
* LibreELEC 11:  HTPC Gigabyte Brix GB-BXA8-5545 with CEC adapter, Sony XR-64A84K :: Desktop AMD Ryzen 7 5800X / Sapphire Nitro+ Radeon 6700XT  / 27" Dell U2717D QHD
* Debian Bookworm x86_64: Celeron G1610, NFS/MariaDB/ZFS server
* Blog
Reply
#5
Do you just have the one Kodi machine?

Have you changed your sources.xml or even the password for an existing source?
Reply
#6
Hi Anastrophe, sorry, I lost track of this. I have multiple Kodi machines, I will double check my sources.xml and password. I just dumped the SQL database and will look through it manually as well.

I also found out some software like SickBeard e.g. that triggers database scans could create duplicate entries as well, I'll have to look into that as well (although there are entries for shows that were there before I started using SickBeard, so...).

Thanks for the tips, will report back.
* MikroTik RB5009UG+S+IN :: ZyXEL GS1900-8HP v1 :: EAP615-Wall v1 :: Netgear GS108T v3 running OpenWrt 23.05
* LibreELEC 11:  HTPC Gigabyte Brix GB-BXA8-5545 with CEC adapter, Sony XR-64A84K :: Desktop AMD Ryzen 7 5800X / Sapphire Nitro+ Radeon 6700XT  / 27" Dell U2717D QHD
* Debian Bookworm x86_64: Celeron G1610, NFS/MariaDB/ZFS server
* Blog
Reply
#7
LOL - what's the chances of this?

http://forum.kodi.tv/showthread.php?tid=...pid2591056
Reply
#8
Well, I had some free time today so I decided to tackle this in earnest. I have exported my MySQL database, wiped the MySQL setup and migrated to MariaDB, and imported the database again (one never knows). Someone suggested I might have stale database credentials on one of my clients (I have two clients total), but they both have these:

Code:
<videodatabase>
   <type>mysql</type>
   <host>(local server IP)</host>
   <port>3306</port>
   <user>kodi</user>
   <pass>kodi</pass>
   <name>kodi_video</name>
 </videodatabase>

That's all pretty default. I also installed and ran the Video Database Cleaner provided in this topic, which looks like it does a more thorough job than the default Kodi database cleaner, but the stale entries persist. The add-on clearly shows which paths are whitelisted, and it found no stale paths. I also have 'Hide watched' disabled, but as mentioned before the stale entries are not listed. One show will e.g. show a total of 138 episodes, 59 unwatched, but every single episode is marked as watched.

I am using SickGear, however it has no access to the database, so that shouldn't interfere with Kodi's scans at startup, or the database altogether. SickGear can interface with Kodi directly but I intentionally did not enable that.

Both the clients are running the latest LibreELEC (8.2.0).

My last resort would be exporting the database in Kodi (with the status files and whatnot) and importing it again, see what that gives; but that's a tedious process (especially with watched status), so I'd rather not. Any suggestion is greatly appreciated.
* MikroTik RB5009UG+S+IN :: ZyXEL GS1900-8HP v1 :: EAP615-Wall v1 :: Netgear GS108T v3 running OpenWrt 23.05
* LibreELEC 11:  HTPC Gigabyte Brix GB-BXA8-5545 with CEC adapter, Sony XR-64A84K :: Desktop AMD Ryzen 7 5800X / Sapphire Nitro+ Radeon 6700XT  / 27" Dell U2717D QHD
* Debian Bookworm x86_64: Celeron G1610, NFS/MariaDB/ZFS server
* Blog
Reply
#9
Bump.

Edit: I just sifted through the MySQL database tables and there are no duplicates listed; ie. a series with e.g. 22 episodes on disk (and as much listed in the database) lists double (44) in the Kodi interface. So there seems to be something wrong between the database and what the Kodi interface displays. I'll wipe the database and re-import all the stuff I guess...
* MikroTik RB5009UG+S+IN :: ZyXEL GS1900-8HP v1 :: EAP615-Wall v1 :: Netgear GS108T v3 running OpenWrt 23.05
* LibreELEC 11:  HTPC Gigabyte Brix GB-BXA8-5545 with CEC adapter, Sony XR-64A84K :: Desktop AMD Ryzen 7 5800X / Sapphire Nitro+ Radeon 6700XT  / 27" Dell U2717D QHD
* Debian Bookworm x86_64: Celeron G1610, NFS/MariaDB/ZFS server
* Blog
Reply

Logout Mark Read Team Forum Stats Members Help
[Krypton] Duplicate (invisible) library entries0