How to update to Kodi Nexus / Kodi doesn't see movie library

[Stevesarzi]

Hello,
installed PKC correctly and Kodi seems to sync with Plex library, but no movie library after the sync.
Same procedure in Matrix works perfectly
Tried on Google TV Sont Bravia and on Kodi for Windows on Windows 11.

Thank you
Stefano

[wikewi]

I'm having similar issues. For movies it can be solved by opening directly into the add-on goto movies -> more and All movies. It will show the correct content. However TV shows are completely disconnected. Open any TV show and it will not show the underlying seasons and or episodes. Again opening episodes directly does seem to work if you open directly from the add-on but it seems seasons, episodes and the shows are not connected to each other.

[croneter]

Weird! But I need some logs as I cannot reproduce.

Please enable Kodi debug logging. Then reset the PlexKodiConnect database: go to the PKC-settings, Advanced, "Reset the Kodi DB..." (in red). Only reset the database, no need to start from scratch with the add-on settings.

Then let PKC do its initial sync. Grab the log immediately once it's done. If you can, I'd be very happy to also have a look at the two Kodi databases MyVideos119.db and plex.db under userdata/Database - could you please share these files here on GitHub as well? (you'll upload which movies&shows you have) Find the Kodi userdata folder here

[wikewi]

Thanks for your reply. With your help I actually moved both the MyVideos119.db and plex.db file as well as moved addon_data folder for the plugin it now all works perfectly! I'm fairly sure it has something to do with the upgrade from Matrix -> Nexus. I tried to install Nexus on my shield which was also a clean install and it seemed to work fine. I'd be happy to share the DB files but I'm not too fond of sharing my library publicly here on GitHub. Is there anywhere I can upload the db files to or do you have a mail address for contacting I'm a bit stunned that GitHub doesn't seem to have something as simple as a private message feature. I remember looking at the logs (not debug logs though) and I remember Kodi not reporting anything. It just looks like when you're either opening a tv show Kodi is hitting a dead end.

[croneter]

Aha!

Working Solution

1. Quit Kodi
2. In your Kodi userdata folder userdata/Database delete all the following files:
   • MyVideos*.db
   • MyMusic*.db (if you used PKC to sync music as well)
   • plex.db
3. If at all possible: Start from scratch, don't upgrade Kodi from 19 to 20!

If all else fails, check here: #1359

[ac3nl]

You mean re-installing the add-on?

[wikewi]

Reinstalling the add-on isn't enough from experience, I'm fairly sure I've tried to built in options to erase the entire library from the add-on as well as uninstalling/reinstalling it. Even Kodi's built in option for cleaning the library didn't seem to fix it. From my understanding the MyVideos119.db is a database file that Kodi natively uses to store all the video file information that Kodi saves in its library. Resetting just the add-on will probably not be enough to take care of this issue.

[ac3nl]

So how do i fix it, without starting all,over with my setup?

[croneter]

Try to go to the PKC settings, Advanced, then "Reset the Kodi library..." (In red). You shouldn't need to reset the PKC add-on settings, too, if asked.

[ac3nl]

I have done that allready twice. Didn’t solve the matter.
I syncs, but it doesn’t pick up new things, doesn’t delete things that are gone.
It is stuck with the database from before the migration to nexus.

i am on plex 1.30.2, kodi 20 release , and plexkodiconnect 3.7.0

[vinylity]

I am having the exact same problems as the above poster.

[croneter]

Quit Kodi. Delete MyVideos119.db and plex.db (see above). Does that help?

[ac3nl]

Deleting ALL MyVideo*.db files nd plex.db files did the trick

[vinylity]

It worked for me as well!

[Mycah]

Is this a bug that might get attention or is the workaround the only way this will be resolved?

[ac3nl]

Deleting only 119 did not solve this. in fact i got my library double back
Deleting all the myvideos.db solved it
Same for music, i had to delete all mymusic files

[ParasKPatel]

Deleting ALL MyVideo*.db files nd plex.db files did the trick

Same here!

[croneter]

Is this a bug that might get attention or is the workaround the only way this will be resolved?

I won't fix this. Updating Kodi has always been a hassle from PlexKodiConnect's perspective 😞

[croneter]

Glad you solved it! 🚀

[Mycah]

Is this a bug that might get attention or is the workaround the only way this will be resolved?

I won't fix this. Updating Kodi has always been a hassle from PlexKodiConnect's perspective 😞

Understood, thank you for your response.

[Xaelias]

Is this a bug that might get attention or is the workaround the only way this will be resolved?

I won't fix this. Updating Kodi has always been a hassle from PlexKodiConnect's perspective 😞

Is there really no way to do this (the file deletion) from the plugin itself?
I'm not trying to be contrary but I'm running this on an Nvidia shield, on a USB HDD (encrypted) and it looks like I might not even be able to manually delete these files.

[EDIT] Ok looks like my problem is that these are hidden files... So they would mostly not show up in most tools.
Enabling transfer over local network and using CLI I managed to access the files...
For reference and potentially future me, they're in /internal/Android/data/org.xbmc.kodi/files/.kodi/userdata/Database

[croneter]

@Xaelias If you're lucky, this works, too (as an alternative to manually having to delete files):

• Go to the PKC Settings, Advanced
• Click Reset the Kodi database and optionally reset PlexKodiConnect
• Hit Yes, Yes, Yes to also delete all PKC settings

[leemm]

In your Kodi userdata folder userdata/Database delete all the following files:

• MyVideos*.db
• MyMusic*.db (if you used PKC to sync music as well)
• plex.db

Can confirm this was my issue too. However, I also had to delete TV*.db to resync TV shows correctly.

Thanks @croneter.

[DarkoMir]

Just to add something, I was able to delete those files from kodi itself.
Then reboot and wait for synchronization. Dove

[djl0327]

For whatever reason I'm not able to access the files (MyVideos119.db & Plex.db) I would have to delete. I'm on a Shield and using Solid Explorer, but other File Managers I've tried to use don't let me get to those files either. I've tried enabling hidden files, but I just get a block no matter what I do. Alternatively, resetting the Kodi database through the add-on didn't work, it just screwed up my library more. I'm at a loss of what to do at this point.

[ac3nl]

On Nvidia Shield i was able to delete those files over the network.
In setting-> storage you can enable external access to your files

[croneter]

@djl0327 This does not help?

@Xaelias If you're lucky, this works, too (as an alternative to manually having to delete files):

• Go to the PKC Settings, Advanced
• Click Reset the Kodi database and optionally reset PlexKodiConnect
• Hit Yes, Yes, Yes to also delete all PKC settings

[djl0327]

@djl0327 This does not help?

@Xaelias If you're lucky, this works, too (as an alternative to manually having to delete files):

• Go to the PKC Settings, Advanced
• Click Reset the Kodi database and optionally reset PlexKodiConnect
• Hit Yes, Yes, Yes to also delete all PKC settings

I tried this but did not elect to delete all PKC settings. I'll have to try that and see what happens. I didn't really want to start over as it took a long time to get my setup the way I wanted to but whatever I guess I have no choice.

[croneter]

@djl0327 Take a backup; even screenshots of your settings.

[djl0327]

On Nvidia Shield i was able to delete those files over the network.
In setting-> storage you can enable external access to your files

This actually worked. Was able to access the files through my laptop and delete them. When I started Kodi back up again everything synced and updated.

Thanks for the help

[Mkwanju]

I also have this issue....how are you guys able to delete those files on Tv though? Everytime I try to access them, I get to Kodi and I get the access denies notification. Resetting everything via the plexkodiconnect also doesn't seem to fix anything really. After setting it up again, I get the same media that's not updated.

[djl0327]

I also have this issue....how are you guys able to delete those files on Tv though? Everytime I try to access them, I get to Kodi and I get the access denies notification. Resetting everything via the plexkodiconnect also doesn't seem to fix anything really. After setting it up again, I get the same media that's not updated.

What device are you using? On the Shield I had to enable transfer files over local network and use windows explorer on my laptop to access and delete the files. After that I started Kodi and everything synced again.

[Xaelias]

I also have this issue....how are you guys able to delete those files on Tv though? Everytime I try to access them, I get to Kodi and I get the access denies notification. Resetting everything via the plexkodiconnect also doesn't seem to fix anything really. After setting it up again, I get the same media that's not updated.

Yeah what @djl0327 is saying.
If you provide us with the device you use on your TV, and what computer (windows, linux, macos) you have access to, we can give you a step by step :-)

[Mkwanju]

I also have this issue....how are you guys able to delete those files on Tv though? Everytime I try to access them, I get to Kodi and I get the access denies notification. Resetting everything via the plexkodiconnect also doesn't seem to fix anything really. After setting it up again, I get the same media that's not updated.

What device are you using? On the Shield I had to enable transfer files over local network and use windows explorer on my laptop to access and delete the files. After that I started Kodi and everything synced again.

Not on the shield. I am using the Sony X750h TV.

[Mkwanju]

I also have this issue....how are you guys able to delete those files on Tv though? Everytime I try to access them, I get to Kodi and I get the access denies notification. Resetting everything via the plexkodiconnect also doesn't seem to fix anything really. After setting it up again, I get the same media that's not updated.

Yeah what @djl0327 is saying. If you provide us with the device you use on your TV, and what computer (windows, linux, macos) you have access to, we can give you a step by step :-)

I use the TV itself,(sony x750h which is running android 9 I think) nothing more at the moment. As for the computer I use both the linux and Windows system. More comfortable with windows though.

[Xaelias]

I use the TV itself,(sony x750h which is running android 9 I think) nothing more at the moment. As for the computer I use both the linux and Windows system. More comfortable with windows though.

Arf yeah that's... less than ideal.
I don't think the TV will let you mess with the file system. Which means that... uninstalling / reinstalling kodi might be the only option? I assume (I obviously haven't tried) it would work but you would need to reconfigure the whole thing...
Note that there is an addon to backup the config (don't backup the DB in this case of course). Which might help putting things back together faster.

[DarkoMir]

I also have this issue....how are you guys able to delete those files on Tv though? Everytime I try to access them, I get to Kodi and I get the access denies notification. Resetting everything via the plexkodiconnect also doesn't seem to fix anything really. After setting it up again, I get the same media that's not updated.

Yeah what @djl0327 is saying. If you provide us with the device you use on your TV, and what computer (windows, linux, macos) you have access to, we can give you a step by step :-)

I use the TV itself,(sony x750h which is running android 9 I think) nothing more at the moment. As for the computer I use both the linux and Windows system. More comfortable with windows though.

@Mkwanju dirty workaround. I deleted those files directly from the file manager of kodi. I use a Xiaomi TV and had the same problem as you.
On the main screen of Kodi go on the gear in the upper left, then file manager, click on the first voice (profile directory or similar), then Database and here we go!!! Delete all MyVideos*.db, MyMusic*.db and plex.db.
Reboot and a new synchronization will start

[Mkwanju]

I use the TV itself,(sony x750h which is running android 9 I think) nothing more at the moment. As for the computer I use both the linux and Windows system. More comfortable with windows though.

Arf yeah that's... less than ideal. I don't think the TV will let you mess with the file system. Which means that... uninstalling / reinstalling kodi might be the only option? I assume (I obviously haven't tried) it would work but you would need to reconfigure the whole thing... Note that there is an addon to backup the config (don't backup the DB in this case of course). Which might help putting things back together faster.

Someone provided a solution below your reply and it has worked.

[Mkwanju]

I also have this issue....how are you guys able to delete those files on Tv though? Everytime I try to access them, I get to Kodi and I get the access denies notification. Resetting everything via the plexkodiconnect also doesn't seem to fix anything really. After setting it up again, I get the same media that's not updated.

Yeah what @djl0327 is saying. If you provide us with the device you use on your TV, and what computer (windows, linux, macos) you have access to, we can give you a step by step :-)

I use the TV itself,(sony x750h which is running android 9 I think) nothing more at the moment. As for the computer I use both the linux and Windows system. More comfortable with windows though.

@Mkwanju dirty workaround. I deleted those files directly from the file manager of kodi. I use a Xiaomi TV and had the same problem as you. On the main screen of Kodi go on the gear in the upper left, then file manager, click on the first voice (profile directory or similar), then Database and here we go!!! Delete all MyVideos*.db, MyMusic*.db and plex.db. Reboot and a new synchronization will start

This has solved my problem. Thanks a lot....everything seems to be working well atm.

[DarkoMir]

Ok, guys. Another problem, but same problem.

All seems to work, but I noticed that sync doesn't work.
If I delete those files all goes ok, but if I see something on another device, the next time I open this device nothing seems synchronized.

I have to delete files and so on.
Anybody?

[ac3nl]

After deleting the db files and syncing, everything worked as before. Deleting files on the server are instantly synced to plexkodiconnect. So i don't have this problem you discribe

[DarkoMir]

After deleting the db files and syncing, everything worked as before. Deleting files on the server are instantly synced to plexkodiconnect. So i don't have this problem you discribe

Try to watch something on another device and then return to the one with the original problem.
Mine can't resynchronize to upgrade watching informazion

[DarkoMir]

After deleting the db files and syncing, everything worked as before. Deleting files on the server are instantly synced to plexkodiconnect. So i don't have this problem you discribe

Try to watch something on another device and then return to the one with the original problem.
Mine can't resynchronize to upgrade watching informazion

Ok, @croneter, nothing to do with pkc.
For some reason my tv doesn't exit from kodi.
If I force close kodi and the reopen, all is synchronized.