I’ve not come across this before. I noticed tonight that the MySQL data that’s being shared with my RPis isn’t being shown or updated on my Vero. The same advancedsettings.xml file I’ve always dumped onto a clean install remains the same unchanged file, so it’s not that. That’s been working fine for the past number of years. In fact, last time I reinstalled the Vero when I downgraded everything to the latest v18 image it was definitely working fine then, I always check.
Reinstalled the Vero from scratch completely again just now as I had also noticed juddering on MKV and HEVC files and thought that might fix it, it didn’t unfortunately. And still no MySQL info showing.
All of the devices are on v18.
I’ve checked this is working correctly on a couple of the RPis and it is.
To get a better understanding of the problem you are experiencing we need more information from you. The best way to get this information is for you to upload logs that demonstrate your problem. You can learn more about how to submit a useful support request here.
Depending on the used skin you have to set the settings-level to standard or higher, in summary:
enable debug logging at settings->system->logging
reboot the OSMC device twice(!)
reproduce the issue
upload the log set (all configs and logs!) either using the Log Uploader method within the My OSMC menu in the GUI or the ssh method invoking command grab-logs -A
publish the provided URL from the log set upload, here
Thanks for your understanding. We hope that we can help you get up and running again shortly.
osmc@MediaRoom:~$ mysql --user=xbmc --password=xbmc -h 192.168.0.151
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.73-log Source distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [(none)]>
Which is the videoDB for v18? I know I would have a newer one that’s no longer required after the downgrade.
MySQL [(none)]> use xbmc_music72;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MySQL [xbmc_music72]> show tables;
+------------------------+
| Tables_in_xbmc_music72 |
+------------------------+
| album |
| album_artist |
| album_source |
| albumartistview |
| albumview |
| art |
| artist |
| artistview |
| audiobook |
| discography |
| genre |
| infosetting |
| path |
| role |
| song |
| song_artist |
| song_genre |
| songartistview |
| songview |
| source |
| source_path |
| version |
| versiontagscan |
+------------------------+
23 rows in set (0.002 sec)