But shouldn’t I be able to access the share directly through Files, even if the TV Shows and Movies paths aren’t working correctly?
Edit: In fact, the SMB shares that aren’t associated with the actual scanned library are accessible… So it looks like you’re right…
My shared database is not looking great, seems there’s only one database and it’s named information_schema… I thought when I set it up all those moons ago, I had another database in there for XBMC (at the time)… But all was well (synchronized across Pi devices) until this update.
Is there a way to downgrade to the January release until I can get to the bottom of this so that the wifey can carry on using the TV in the interim?
You should actually have the old versions (lower number) and the new versions of the databases in mysql. I suggest you shutdown both mediacenters sudo systemctl stop mediacenter.
Then delete the v16 databases (e.g. MyVideos99) after you ensure you have a correct v15.2 database (e.g. MyVideos93). Details here http://kodi.wiki/view/Database_versions
Then start the mediacenter on one of the boxes (sudo systemctl start mediacenter) and wait till it has upgraded the database successfully (tail -f .kodi/temp/kodi.log) before starting the second one.
Well actually reading your response again it seems you are not having any database at all so a downgrade would also not help. Only way to temporary get it working is to disable the mysql database in Kodi and it will create local databases.
Well it’s hard to say how you lost your database. But I would like to crosscheck one point. in the log it shows an IP address of 22.214.171.124. Do you really use a MYSQL server that is accessible via public IP addreess? If yes and using standard user names you should not be surprised that things can go wrong.
So you use Public IP addresses in your LAN, not the best setup I would say.
Well if you use a MYSQL database make backups regular and especially before an upgrade. But once again a database normally doesn’t just disappear. Suggest you check your mysql logs also if you have bin-logs enabled you might can get the database back from there.
Well being a rebel and making technically illogical setups (like some other big companies have done in the past) is two different pairs of shoes.
Could it be a user permission problem? Because it can not be that you only have information_shema. You at least need a mysql database otherwise you could not login.
Try to login with the root user to validate the user permissions for your xbmc user.
Just odd that it worked before the update and worked enough to create the MyVideos99 database. Is it possible to drop that database and reboot the Pi to have OSMC attempt to recreate it based on the old MyVideos93 again or is that a no-go now?
Yes it is possible if you are sure the MyVideos93 is fully ok. Just you would have to delete all newly created databases not only MyVideos.
Also as I wrote earlier before deleting them shutdown all mediacenters that access them and then first start with one media center and wait for it to finish.
It worked! I think, ultimately, the issue was that I updated both Pi devices simultaneously. They must have both attempted to create the new databases simultaneously or conflicted in some way and it prevented the new databases from forming correctly (theory).
Dropping MyMusic56 and MyVideos99, then launching only one of the Pi devices, I am now seeing entries in my Movies / TV Shows sections and can access the shares through my Files menu. No loss of watched status (phew)!
Apologies for the stupidity, I can only hope this helps some other schlub down the line who Googles a similar issue. Thank you again for your help, @fzinken.