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.