(2016-01-24, 03:28)duffmaster33 Wrote: I see. I'll be honest, I am disappointed in this but I get where you are coming from. I did find the Kodi upload log addon and tried that, which showed me that there were many SQL errors when Kodi tried to access my MySQL instance where the metadata is stored. I tried deleting it so Kodi could recreate it from scratch, however that did not resolve the errors (most notably an issue with the tvshow_view view). Is storing metadata on a remote MySQL instance not supported with Kodi on the Shield? Right now this is not a big deal as I only have the one instance of Kodi, but was hoping to have several in the near future (which is why I went to the MySQL database for the metadata on my old HTPC).
FWIW, I deleted my advancedsettings.xml file and rebooted Kodi and immediately the TV Shows link works (though there has been a "Preparing...: 0%" message on the upper right of the screen this entire time and shows with no episodes are still showing up...
For now, it seems my problems are resolved with TV Shows, though I am curious if it is possible to use MySQL for my metadata as I did with my old setup. Thank you.
EDIT: The preparing message finally went away after 10 or so minutes, and I was able to filter my shows down to just the unwatched. So, my only unanswered question is regarding how I can point Kodi to save everything to MySQL as I did on my old HTPC. Thanks!
Ok, so backup. You have a remote server with mySQL installed, and not a local library? i'm assuming you ran through the
wiki article on this before moving your install. I wouldn't think Kodi on Shield/ATV would have any issues connecting to an extenral SQL server, but that makes your "path not found" error when accessing the library make more sense.
I don't know how to troubleshoot mySQL specifically (I set it up once but never actually used it since I only have the one Kodi install for now), but here's what I would do:
- Delete the Kodi app/data from the Shield.
- Download and install either Isengard 15.2 or Jarvis 16.0 RC1 from
this page. 15.2 will enable the context menu when you hold down select, but I moved to 16.0 as of Beta5 and it seems to be working fine.
- Use a file explorer to install the apk you downloaded. Everyone recommends ESFileExplorer but I find X-Plore to work way, way better with a remote.
- Boot up Kodi and let it run its first time config.
- Close Kodi (actually quit out, don't just go back to the Shield Interface.
- Create your advancedsettings.xml file based on
this, and move it the appropriate path.
- Boot up Kodi and check your library, and if the advancedsetting file was built correctly, it should work. If not, time to look at log files and find whatever thread people are using for mySQL stuff here on the forums.
Good luck!