Hello,
I found out that during the scanning of music library there are several errors in kodi.log. Errors are like these:
21:46:36.840 T:1405088672 ERROR: SQL: [MyMusic60] Undefined MySQL error: Code (1054)
Query: SELECT DISTINCT song_genre.idGenre, Genre.strGenre FROM song_artist JOIN song ON song_artist.idSong = song
.idSong JOIN song_genre ON song.idSong = song_genre.idSong JOIN genre ON song_genre.idGenre = genre.idGenre WHERE song_artist.idArtist = 1 ORDER BY song_genr
e.idGenre
21:46:36.842 T:1405088672 ERROR: GetGenresByArtist(1) failed
21:46:36.843 T:1405088672 ERROR: SQL: [MyMusic60] Undefined MySQL error: Code (1054)
Query: SELECT DISTINCT song_genre.idGenre, Genre.strGenre FROM song_artist JOIN song ON song_artist.idSong = song
.idSong JOIN song_genre ON song.idSong = song_genre.idSong JOIN genre ON song_genre.idGenre = genre.idGenre WHERE song_artist.idArtist = 2 ORDER BY song_genr
e.idGenre
21:46:36.844 T:1
I ran this statement againts MySQL in phpAdmin and found out that there is a wrong table name after DISTINCT. Filltered collum is Genre.strGenre but should be with low char at start, i.e. genre.strGenre
Release : LibreELEC (Milhouse) – Version: devel-20161224210557-#1224-gdc61a12 [Build #1224] on RPi3
MySQL : Run on Synology, 5.5.53-MariaDB
Database was created automatically by Kodi.
It seems that the problem cause nothing but exists. Could somebody check it?
Thanks