Kodi Community Forum

Kodi Community Forum > Support > General Support > Windows > MySql(mariadb) - Kodi - Unraid Issue
Full Version: MySql(mariadb) - Kodi - Unraid Issue
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

Rodimus

2015-12-13, 00:07
Hi all,

So I finally decided after my main htpc died and I had to rebuild it was time to get a shared database working, we've got 1 PC downstairs, 1 in the study and 1 android fire tv stick in the bedroom and the wife is nagging me to get them all in sync. So far so easy...Huh

I'll try to list everything and make this as easy for you all to tell me where I've gone wrong, I've tried and failed at this on my own a few years back but since I'm planning to run owncloud off my unraid box at some point soon I thought I best get the database sorted.

So first item was I decided to start the database from scratch. Half the played/unwatched markers are a mess anyway.
So...

1 - Unraid, installed 6.1.3 and made the move to dockers instead of plugins!
2 - Installed MariaDB on the server
3 - Installed mysql workbench aimed it at 192.168.0.9 (Unraid) and ran
CREATE USER 'kodi' IDENTIFIED BY 'kodi';
GRANT ALL ON *.* TO 'kodi'
4 - uninstalled and re-installed Kodi (Isenguard last stable) in the study.
Let it run, closed it and then moved in advancesettings.xml
Added the TV source, used NFS so nfs://192.168.0.9/mnt/user/Television
Let it load, marked a bunch as watched and then updated the source again to refresh it to the server...took an age so I went to bed.
5 - This morning I copied the advancesettings.xml onto a new Kodi install downstairs and it doesn't load TV at all.
6 - Gone back to the upstairs machine and TV is gone too. It only shows up under video and doesn't open up when you hit enter, click on it etc. Pressing C doesn't even bring up a menu!

So any idea what I've done?

Lifted from the log but also shows advancesettings.xml

Code:
[b]22:02:26 T:996  NOTICE: Contents of special://xbmc/system/advancedsettings.xml are...
                                            <advancedsettings>
                                              <videodatabase>
                                                <type>mysql</type>
                                                <host>192.168.0.9</host>
                                                <port>3306</port>
                                                <user>kodi</user>
                                                <pass>kodi</pass>
                                              </videodatabase>
                                              <musicdatabase>
                                                <type>mysql</type>
                                                <host>192.168.0.9</host>
                                                <port>3306</port>
                                                <user>kodi</user>
                                                <pass>kodi</pass>
                                              </musicdatabase>
                                              <videolibrary>
                                                <importwatchedstate>true</importwatchedstate>
                                                <importresumepoint>true</importresumepoint>
                                              </videolibrary>
                                            </advancedsettings>
22:02:26 T:996 WARNING: VIDEO database configuration is experimental.
22:02:26 T:996  NOTICE: Loaded settings file from special://profile/advancedsettings.xml
22:02:26 T:996  NOTICE: Contents of special://profile/advancedsettings.xml are...
                                            <advancedsettings>
                                              <videodatabase>
                                                <type>mysql</type>
                                                <host>192.168.0.9</host>
                                                <port>3306</port>
                                                <user>kodi</user>
                                                <pass>kodi</pass>
                                              </videodatabase>
                                              <musicdatabase>
                                                <type>mysql</type>
                                                <host>192.168.0.9</host>
                                                <port>3306</port>
                                                <user>kodi</user>
                                                <pass>kodi</pass>
                                              </musicdatabase>
                                              <videolibrary>
                                                <importwatchedstate>true</importwatchedstate>
                                                <importresumepoint>true</importresumepoint>
                                              </videolibrary>
                                            </advancedsettings>
22:02:26 T:996 WARNING: VIDEO database configuration is experimental.
[/b]

And from the bottom of the log all these errors....

[b]
Code:
22:02:27 T:11736  NOTICE: -->Python Interpreter Initialized<--
22:02:28 T:10364  NOTICE: Previous line repeats 1 times.
22:02:28 T:10364   ERROR: SQL: The table does not exist
                                            Query: select * from movie_view  WHERE ((movie_view.playCount IS NULL OR movie_view.playCount < 1))
22:02:28 T:10364   ERROR: CVideoDatabase::GetMoviesByWhere failed
22:02:28 T:10364   ERROR: SQL: The table does not exist
                                            Query: select * from episode_view  WHERE ((episode_view.playCount IS NULL OR episode_view.playCount < 1))
22:02:28 T:10364   ERROR: CVideoDatabase::GetEpisodesByWhere failed
22:02:28 T:10364   ERROR: SQL: The table does not exist
                                            Query: select * from musicvideo_view
22:02:28 T:10364   ERROR: CVideoDatabase::GetMusicVideosByWhere failed
22:02:28 T:10364   ERROR: SQL: The table does not exist
                                            Query: SELECT albumview.* FROM albumview  WHERE albumview.strReleaseType = 'album'
22:02:28 T:10364   ERROR: CMusicDatabase::GetAlbumsByWhere () failed
22:02:28 T:10364   ERROR: SQL: The table does not exist
                                            Query: SELECT artistview.* FROM artistview  WHERE (artistview.idArtist IN (SELECT song_artist.idArtist FROM song_artist) OR artistview.idArtist IN (SELECT album_artist.idArtist FROM album_artist)) and artistview.strArtist != '' and artistview.strArtist <> 'Various artists'
22:02:28 T:10364   ERROR: CMusicDatabase::GetArtistsByWhere failed
22:02:28 T:10364   ERROR: SQL: The table does not exist
                                            Query: SELECT songview.* FROM songview  WHERE ((CAST(songview.iTimesPlayed as DECIMAL(5,1)) < 1))
22:02:28 T:10364   ERROR: CMusicDatabase::GetSongsByWhere() failed
22:02:28 T:11508  NOTICE: Thread FileCache start, auto delete: false
22:02:28 T:10364   ERROR: SQL: The table does not exist
                                            Query: select * from movie_view  WHERE (movie_view.idFile  IN (SELECT DISTINCT idFile FROM bookmark WHERE type = 1))
22:02:28 T:10364   ERROR: CVideoDatabase::GetMoviesByWhere failed
22:02:28 T:10364   ERROR: SQL: The table does not exist
                                            Query: SELECT * FROM tvshow_view  WHERE ( ((tvshow_view.watchedcount > 0 AND tvshow_view.watchedcount < tvshow_view.totalCount) OR (tvshow_view.watchedcount = 0 AND EXISTS (SELECT 1 FROM episode_view WHERE episode_view.idShow = tvshow_view.idShow AND episode_view.resumeTimeInSeconds > 0))))
22:02:28 T:10364   ERROR: CVideoDatabase::GetTvShowsByWhere failed
22:02:28 T:10364   ERROR: SQL: The table does not exist
                                            Query: SELECT albumview.* FROM albumview  WHERE albumview.strReleaseType = 'album'
22:02:28 T:10364   ERROR: CMusicDatabase::GetAlbumsByWhere () failed
22:02:28 T:10364   ERROR: SQL: The table does not exist
                                            Query: select * from musicvideo_view
22:02:28 T:10364   ERROR: CVideoDatabase::GetMusicVideosByWhere failed
22:02:28 T:10364   ERROR: SQL: The table does not exist
                                            Query: select * from movie_view  WHERE ((movie_view.playCount IS NULL OR movie_view.playCount = 0))
22:02:28 T:10364   ERROR: CVideoDatabase::GetMoviesByWhere failed
22:02:28 T:10364   ERROR: SQL: The table does not exist
                                            Query: select * from episode_view  WHERE ((episode_view.playCount IS NULL OR episode_view.playCount < 1))
22:02:28 T:10364   ERROR: CVideoDatabase::GetEpisodesByWhere failed
22:02:28 T:10364   ERROR: SQL: The table does not exist
                                            Query: select * from musicvideo_view
22:02:28 T:10364   ERROR: CVideoDatabase::GetMusicVideosByWhere failed
22:02:28 T:10364   ERROR: SQL: The table does not exist
                                            Query: SELECT albumview.* FROM albumview  WHERE albumview.strReleaseType = 'album'
22:02:28 T:10364   ERROR: CMusicDatabase::GetAlbumsByWhere () failed
22:02:28 T:9028  NOTICE: Thread FileCache start, auto delete: false
22:02:28 T:4408  NOTICE: Previous line repeats 2 times.
22:02:28 T:4408  NOTICE: Thread JobWorker start, auto delete: true
22:02:28 T:4240  NOTICE: Thread LanguageInvoker start, auto delete: false
22:02:28 T:8632  NOTICE: Thread JobWorker start, auto delete: true
22:02:28 T:8612  NOTICE: Thread RSSReader start, auto delete: false
22:02:28 T:10364   ERROR: SQL: The table does not exist
                                            Query: select * from movie_view  WHERE ((movie_view.playCount IS NULL OR movie_view.playCount < 1))
22:02:28 T:10364   ERROR: CVideoDatabase::GetMoviesByWhere failed
22:02:28 T:10364   ERROR: SQL: The table does not exist
                                            Query: select * from episode_view  WHERE ((episode_view.playCount IS NULL OR episode_view.playCount < 1))
22:02:28 T:10364   ERROR: CVideoDatabase::GetEpisodesByWhere failed
22:02:28 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT songview.* FROM (SELECT idAlbum FROM albumview ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum=recentalbums.idAlbum
22:02:28 T:4408   ERROR: CMusicDatabase::GetRecentlyAddedAlbumSongs failed
22:02:28 T:4408   ERROR: SQL: The table does not exist
                                            Query: select * from albumview where strAlbum != '' order by idAlbum desc limit 10
22:02:28 T:4408   ERROR: CMusicDatabase::GetRecentlyAddedAlbums failed
22:02:29 T:10364   ERROR: SQL: The table does not exist
                                            Query: select * from musicvideo_view
22:02:29 T:10364   ERROR: CVideoDatabase::GetMusicVideosByWhere failed
22:02:29 T:10364   ERROR: SQL: The table does not exist
                                            Query: SELECT albumview.* FROM albumview  WHERE albumview.strReleaseType = 'album'
22:02:29 T:10364   ERROR: CMusicDatabase::GetAlbumsByWhere () failed
22:02:29 T:4408   ERROR: SQL: The table does not exist
                                            Query: select * from movie_view  ORDER BY dateAdded desc, idMovie desc LIMIT 10
22:02:29 T:4408   ERROR: CVideoDatabase::GetMoviesByWhere failed
22:02:29 T:4408   ERROR: SQL: The table does not exist
                                            Query: select * from episode_view  ORDER BY dateAdded desc, idEpisode desc LIMIT 10
22:02:29 T:4408   ERROR: CVideoDatabase::GetEpisodesByWhere failed
22:02:29 T:4408   ERROR: SQL: The table does not exist
                                            Query: select * from musicvideo_view  ORDER BY dateAdded desc, idMVideo desc LIMIT 10
22:02:29 T:4408   ERROR: CVideoDatabase::GetMusicVideosByWhere failed
22:02:29 T:10364   ERROR: SQL: The table does not exist
                                            Query: SELECT artistview.* FROM artistview  WHERE (artistview.idArtist IN (SELECT song_artist.idArtist FROM song_artist) OR artistview.idArtist IN (SELECT album_artist.idArtist FROM album_artist)) and artistview.strArtist != '' and artistview.strArtist <> 'Various artists'
22:02:29 T:10364   ERROR: CMusicDatabase::GetArtistsByWhere failed
22:02:29 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM songview LIMIT 1
22:02:29 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM songview LIMIT 1'
22:02:29 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT count(distinct strAlbum) FROM songview LIMIT 1
22:02:29 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(distinct strAlbum) FROM songview LIMIT 1'
22:02:29 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT count(distinct strArtists) FROM songview LIMIT 1
22:02:29 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(distinct strArtists) FROM songview LIMIT 1'
22:02:29 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM tvshow_view LIMIT 1
22:02:29 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM tvshow_view LIMIT 1'
22:02:29 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM movie_view LIMIT 1
22:02:29 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM movie_view LIMIT 1'
22:02:29 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT count(playCount) FROM movie_view LIMIT 1
22:02:29 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(playCount) FROM movie_view LIMIT 1'
22:02:29 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM musicvideo_view LIMIT 1
22:02:29 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM musicvideo_view LIMIT 1'
22:02:29 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT count(playCount) FROM musicvideo_view LIMIT 1
22:02:29 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(playCount) FROM musicvideo_view LIMIT 1'
22:02:29 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(watchedcount) FROM tvshow_view LIMIT 1
22:02:29 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(watchedcount) FROM tvshow_view LIMIT 1'
22:02:29 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(totalcount) FROM tvshow_view LIMIT 1
22:02:29 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(totalcount) FROM tvshow_view LIMIT 1'
22:02:29 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1
22:02:29 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1'
22:02:29 T:10364   ERROR: SQL: The table does not exist
                                            Query: SELECT songview.* FROM songview  WHERE ((CAST(songview.iTimesPlayed as DECIMAL(5,1)) < 1))
22:02:29 T:10364   ERROR: CMusicDatabase::GetSongsByWhere() failed
22:02:29 T:4240  NOTICE: -->Python Interpreter Initialized<--
22:02:29 T:9192  NOTICE: Thread FileCache start, auto delete: false
22:02:33 T:9168  NOTICE: Previous line repeats 1 times.
22:02:33 T:9168  NOTICE: Thread BackgroundLoader start, auto delete: false
22:02:35 T:3444  NOTICE: Thread LanguageInvoker start, auto delete: false
22:02:35 T:3460   ERROR: SQL: The table does not exist
                                            Query: SELECT songview.* FROM (SELECT idAlbum FROM albumview ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum=recentalbums.idAlbum
22:02:35 T:3460   ERROR: CMusicDatabase::GetRecentlyAddedAlbumSongs failed
22:02:35 T:3460   ERROR: SQL: The table does not exist
                                            Query: select * from albumview where strAlbum != '' order by idAlbum desc limit 10
22:02:35 T:3460   ERROR: CMusicDatabase::GetRecentlyAddedAlbums failed
22:02:35 T:3460   ERROR: SQL: The table does not exist
                                            Query: select * from movie_view  ORDER BY dateAdded desc, idMovie desc LIMIT 10
22:02:35 T:3460   ERROR: CVideoDatabase::GetMoviesByWhere failed
22:02:35 T:3460   ERROR: SQL: The table does not exist
                                            Query: select * from episode_view  ORDER BY dateAdded desc, idEpisode desc LIMIT 10
22:02:35 T:3460   ERROR: CVideoDatabase::GetEpisodesByWhere failed
22:02:35 T:3460   ERROR: SQL: The table does not exist
                                            Query: select * from musicvideo_view  ORDER BY dateAdded desc, idMVideo desc LIMIT 10
22:02:35 T:3460   ERROR: CVideoDatabase::GetMusicVideosByWhere failed
22:02:35 T:3460   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM songview LIMIT 1
22:02:35 T:3460   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM songview LIMIT 1'
22:02:35 T:3460   ERROR: SQL: The table does not exist
                                            Query: SELECT count(distinct strAlbum) FROM songview LIMIT 1
22:02:35 T:3460   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(distinct strAlbum) FROM songview LIMIT 1'
22:02:35 T:3460   ERROR: SQL: The table does not exist
                                            Query: SELECT count(distinct strArtists) FROM songview LIMIT 1
22:02:35 T:3460   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(distinct strArtists) FROM songview LIMIT 1'
22:02:35 T:3460   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM tvshow_view LIMIT 1
22:02:35 T:3460   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM tvshow_view LIMIT 1'
22:02:35 T:3460   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM movie_view LIMIT 1
22:02:35 T:3460   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM movie_view LIMIT 1'
22:02:35 T:3460   ERROR: SQL: The table does not exist
                                            Query: SELECT count(playCount) FROM movie_view LIMIT 1
22:02:35 T:3460   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(playCount) FROM movie_view LIMIT 1'
22:02:35 T:3460   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM musicvideo_view LIMIT 1
22:02:35 T:3460   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM musicvideo_view LIMIT 1'
22:02:35 T:3460   ERROR: SQL: The table does not exist
                                            Query: SELECT count(playCount) FROM musicvideo_view LIMIT 1
22:02:35 T:3460   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(playCount) FROM musicvideo_view LIMIT 1'
22:02:35 T:3460   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(watchedcount) FROM tvshow_view LIMIT 1
22:02:35 T:3460   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(watchedcount) FROM tvshow_view LIMIT 1'
22:02:35 T:3460   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(totalcount) FROM tvshow_view LIMIT 1
22:02:35 T:3460   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(totalcount) FROM tvshow_view LIMIT 1'
22:02:35 T:3460   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1
22:02:35 T:3460   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1'
22:02:35 T:3444  NOTICE: -->Python Interpreter Initialized<--
22:02:35 T:10364   ERROR: SQL: The table does not exist
                                            Query: select * from movie_view  WHERE ((movie_view.playCount IS NULL OR movie_view.playCount < 1))
22:02:35 T:10364   ERROR: CVideoDatabase::GetMoviesByWhere failed
22:02:35 T:10364   ERROR: SQL: The table does not exist
                                            Query: select * from episode_view  WHERE ((episode_view.playCount IS NULL OR episode_view.playCount < 1))
22:02:35 T:10364   ERROR: CVideoDatabase::GetEpisodesByWhere failed
22:02:35 T:10364   ERROR: SQL: The table does not exist
                                            Query: select * from musicvideo_view
22:02:35 T:10364   ERROR: CVideoDatabase::GetMusicVideosByWhere failed
22:02:35 T:10364   ERROR: SQL: The table does not exist
                                            Query: SELECT albumview.* FROM albumview  WHERE albumview.strReleaseType = 'album'
22:02:35 T:10364   ERROR: CMusicDatabase::GetAlbumsByWhere () failed
22:02:35 T:10364   ERROR: SQL: The table does not exist
                                            Query: SELECT artistview.* FROM artistview  WHERE (artistview.idArtist IN (SELECT song_artist.idArtist FROM song_artist) OR artistview.idArtist IN (SELECT album_artist.idArtist FROM album_artist)) and artistview.strArtist != '' and artistview.strArtist <> 'Various artists'
22:02:35 T:10364   ERROR: CMusicDatabase::GetArtistsByWhere failed
22:02:35 T:10364   ERROR: SQL: The table does not exist
                                            Query: SELECT songview.* FROM songview  WHERE ((CAST(songview.iTimesPlayed as DECIMAL(5,1)) < 1))
22:02:35 T:10364   ERROR: CMusicDatabase::GetSongsByWhere() failed
22:02:35 T:996   ERROR: SQL: The table does not exist
                                            Query: select count(idSong) as NumSongs from songview
22:02:35 T:996   ERROR: CMusicDatabase::GetSongsCount() failed
22:02:40 T:996   ERROR: XFILE::CDirectory::GetDirectory - Error getting C:\Program Files (x86)\Kodi\sounds\
22:02:40 T:996   ERROR: XFILE::CDirectory::GetDirectory - Error getting special://xbmc/sounds/
22:02:41 T:996   ERROR: XFILE::CDirectory::GetDirectory - Error getting C:\Program Files (x86)\Kodi\sounds\
22:02:41 T:996   ERROR: XFILE::CDirectory::GetDirectory - Error getting special://xbmc/sounds/
22:02:43 T:996   ERROR: XFILE::CDirectory::GetDirectory - Error getting C:\Program Files (x86)\Kodi\sounds\
22:02:43 T:996   ERROR: XFILE::CDirectory::GetDirectory - Error getting special://xbmc/sounds/
22:02:43 T:996   ERROR: XFILE::CDirectory::GetDirectory - Error getting C:\Program Files (x86)\Kodi\sounds\
22:02:43 T:996   ERROR: XFILE::CDirectory::GetDirectory - Error getting special://xbmc/sounds/
22:02:43 T:996   ERROR: XFILE::CDirectory::GetDirectory - Error getting C:\Program Files (x86)\Kodi\sounds\
22:02:43 T:996   ERROR: XFILE::CDirectory::GetDirectory - Error getting special://xbmc/sounds/
22:02:45 T:996   ERROR: SQL: The table does not exist
                                            Query: SELECT movie_view.idSet,COUNT(1) AS c FROM movie_view JOIN sets ON sets.idSet = movie_view.idSet GROUP BY movie_view.idSet HAVING c>1
22:02:45 T:996   ERROR: CVideoDatabase::HasSets failed
22:02:45 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT songview.* FROM (SELECT idAlbum FROM albumview ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum=recentalbums.idAlbum
22:02:45 T:4408   ERROR: CMusicDatabase::GetRecentlyAddedAlbumSongs failed
22:02:45 T:4408   ERROR: SQL: The table does not exist
                                            Query: select * from albumview where strAlbum != '' order by idAlbum desc limit 10
22:02:45 T:4408   ERROR: CMusicDatabase::GetRecentlyAddedAlbums failed
22:02:45 T:4408   ERROR: SQL: The table does not exist
                                            Query: select * from movie_view  ORDER BY dateAdded desc, idMovie desc LIMIT 10
22:02:45 T:4408   ERROR: CVideoDatabase::GetMoviesByWhere failed
22:02:45 T:4408   ERROR: SQL: The table does not exist
                                            Query: select * from episode_view  ORDER BY dateAdded desc, idEpisode desc LIMIT 10
22:02:45 T:4408   ERROR: CVideoDatabase::GetEpisodesByWhere failed
22:02:45 T:4408   ERROR: SQL: The table does not exist
                                            Query: select * from musicvideo_view  ORDER BY dateAdded desc, idMVideo desc LIMIT 10
22:02:45 T:4408   ERROR: CVideoDatabase::GetMusicVideosByWhere failed
22:02:45 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM songview LIMIT 1
22:02:45 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM songview LIMIT 1'
22:02:45 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT count(distinct strAlbum) FROM songview LIMIT 1
22:02:45 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(distinct strAlbum) FROM songview LIMIT 1'
22:02:45 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT count(distinct strArtists) FROM songview LIMIT 1
22:02:45 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(distinct strArtists) FROM songview LIMIT 1'
22:02:45 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM tvshow_view LIMIT 1
22:02:45 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM tvshow_view LIMIT 1'
22:02:45 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM movie_view LIMIT 1
22:02:45 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM movie_view LIMIT 1'
22:02:45 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT count(playCount) FROM movie_view LIMIT 1
22:02:45 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(playCount) FROM movie_view LIMIT 1'
22:02:45 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM musicvideo_view LIMIT 1
22:02:45 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM musicvideo_view LIMIT 1'
22:02:45 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT count(playCount) FROM musicvideo_view LIMIT 1
22:02:45 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(playCount) FROM musicvideo_view LIMIT 1'
22:02:45 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(watchedcount) FROM tvshow_view LIMIT 1
22:02:45 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(watchedcount) FROM tvshow_view LIMIT 1'
22:02:45 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(totalcount) FROM tvshow_view LIMIT 1
22:02:45 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(totalcount) FROM tvshow_view LIMIT 1'
22:02:45 T:4408   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1
22:02:45 T:4408   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1'
22:02:48 T:4172  NOTICE: Thread BackgroundLoader start, auto delete: false
22:02:55 T:996  NOTICE: Previous line repeats 1 times.
22:02:55 T:996   ERROR: SQL: The table does not exist
                                            Query: SELECT COUNT(*) FROM episode_view WHERE strPath = 'nfs://192.168.0.9/mnt/user/Television/'
22:02:55 T:996   ERROR: exception in CApplication::FrameMove()
22:02:57 T:996   ERROR: SQL: The table does not exist
                                            Query: SELECT COUNT(*) FROM episode_view WHERE strPath LIKE 'nfs://192.168.0.9/mnt/user/Television/Breathless (2013)/'
22:02:57 T:996   ERROR: exception in CApplication::FrameMove()
22:03:41 T:7436  NOTICE: Thread JobWorker start, auto delete: true
22:03:41 T:4500  NOTICE: Thread BackgroundLoader start, auto delete: false
22:03:42 T:996  NOTICE: Previous line repeats 1 times.
22:03:42 T:996   ERROR: Unable to activate the previous window
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT songview.* FROM (SELECT idAlbum FROM albumview ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum=recentalbums.idAlbum
22:03:42 T:7436   ERROR: CMusicDatabase::GetRecentlyAddedAlbumSongs failed
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: select * from albumview where strAlbum != '' order by idAlbum desc limit 10
22:03:42 T:7436   ERROR: CMusicDatabase::GetRecentlyAddedAlbums failed
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: select * from movie_view  ORDER BY dateAdded desc, idMovie desc LIMIT 10
22:03:42 T:7436   ERROR: CVideoDatabase::GetMoviesByWhere failed
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: select * from episode_view  ORDER BY dateAdded desc, idEpisode desc LIMIT 10
22:03:42 T:7436   ERROR: CVideoDatabase::GetEpisodesByWhere failed
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: select * from musicvideo_view  ORDER BY dateAdded desc, idMVideo desc LIMIT 10
22:03:42 T:7436   ERROR: CVideoDatabase::GetMusicVideosByWhere failed
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM songview LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM songview LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT count(distinct strAlbum) FROM songview LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(distinct strAlbum) FROM songview LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT count(distinct strArtists) FROM songview LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(distinct strArtists) FROM songview LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM tvshow_view LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM tvshow_view LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM movie_view LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM movie_view LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT count(playCount) FROM movie_view LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(playCount) FROM movie_view LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM musicvideo_view LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM musicvideo_view LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT count(playCount) FROM musicvideo_view LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(playCount) FROM musicvideo_view LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(watchedcount) FROM tvshow_view LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(watchedcount) FROM tvshow_view LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(totalcount) FROM tvshow_view LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(totalcount) FROM tvshow_view LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1'
22:03:42 T:988  NOTICE: Thread JobWorker start, auto delete: true
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT songview.* FROM (SELECT idAlbum FROM albumview ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum=recentalbums.idAlbum
22:03:42 T:7436   ERROR: CMusicDatabase::GetRecentlyAddedAlbumSongs failed
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: select * from albumview where strAlbum != '' order by idAlbum desc limit 10
22:03:42 T:7436   ERROR: CMusicDatabase::GetRecentlyAddedAlbums failed
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: select * from movie_view  ORDER BY dateAdded desc, idMovie desc LIMIT 10
22:03:42 T:7436   ERROR: CVideoDatabase::GetMoviesByWhere failed
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: select * from episode_view  ORDER BY dateAdded desc, idEpisode desc LIMIT 10
22:03:42 T:7436   ERROR: CVideoDatabase::GetEpisodesByWhere failed
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: select * from musicvideo_view  ORDER BY dateAdded desc, idMVideo desc LIMIT 10
22:03:42 T:7436   ERROR: CVideoDatabase::GetMusicVideosByWhere failed
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM songview LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM songview LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT count(distinct strAlbum) FROM songview LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(distinct strAlbum) FROM songview LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT count(distinct strArtists) FROM songview LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(distinct strArtists) FROM songview LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM tvshow_view LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM tvshow_view LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM movie_view LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM movie_view LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT count(playCount) FROM movie_view LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(playCount) FROM movie_view LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM musicvideo_view LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM musicvideo_view LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT count(playCount) FROM musicvideo_view LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(playCount) FROM musicvideo_view LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(watchedcount) FROM tvshow_view LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(watchedcount) FROM tvshow_view LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(totalcount) FROM tvshow_view LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(totalcount) FROM tvshow_view LIMIT 1'
22:03:42 T:7436   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1
22:03:42 T:7436   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1'
22:03:51 T:996  NOTICE: WakeOnAccess - Enabled:TRUE
22:03:51 T:988   ERROR: SQL: The table does not exist
                                            Query: SELECT songview.* FROM (SELECT idAlbum FROM albumview ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum=recentalbums.idAlbum
22:03:51 T:988   ERROR: CMusicDatabase::GetRecentlyAddedAlbumSongs failed
22:03:51 T:988   ERROR: SQL: The table does not exist
                                            Query: select * from albumview where strAlbum != '' order by idAlbum desc limit 10
22:03:51 T:988   ERROR: CMusicDatabase::GetRecentlyAddedAlbums failed
22:03:51 T:988   ERROR: SQL: The table does not exist
                                            Query: select * from movie_view  ORDER BY dateAdded desc, idMovie desc LIMIT 10
22:03:51 T:988   ERROR: CVideoDatabase::GetMoviesByWhere failed
22:03:51 T:988   ERROR: SQL: The table does not exist
                                            Query: select * from episode_view  ORDER BY dateAdded desc, idEpisode desc LIMIT 10
22:03:51 T:988   ERROR: CVideoDatabase::GetEpisodesByWhere failed
22:03:51 T:988   ERROR: SQL: The table does not exist
                                            Query: select * from musicvideo_view  ORDER BY dateAdded desc, idMVideo desc LIMIT 10
22:03:51 T:988   ERROR: CVideoDatabase::GetMusicVideosByWhere failed
22:03:51 T:988   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM songview LIMIT 1
22:03:51 T:988   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM songview LIMIT 1'
22:03:51 T:988   ERROR: SQL: The table does not exist
                                            Query: SELECT count(distinct strAlbum) FROM songview LIMIT 1
22:03:51 T:988   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(distinct strAlbum) FROM songview LIMIT 1'
22:03:51 T:988   ERROR: SQL: The table does not exist
                                            Query: SELECT count(distinct strArtists) FROM songview LIMIT 1
22:03:51 T:988   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(distinct strArtists) FROM songview LIMIT 1'
22:03:51 T:988   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM tvshow_view LIMIT 1
22:03:51 T:988   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM tvshow_view LIMIT 1'
22:03:51 T:988   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM movie_view LIMIT 1
22:03:51 T:988   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM movie_view LIMIT 1'
22:03:51 T:988   ERROR: SQL: The table does not exist
                                            Query: SELECT count(playCount) FROM movie_view LIMIT 1
22:03:51 T:988   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(playCount) FROM movie_view LIMIT 1'
22:03:51 T:988   ERROR: SQL: The table does not exist
                                            Query: SELECT count(1) FROM musicvideo_view LIMIT 1
22:03:51 T:988   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(1) FROM musicvideo_view LIMIT 1'
22:03:51 T:988   ERROR: SQL: The table does not exist
                                            Query: SELECT count(playCount) FROM musicvideo_view LIMIT 1
22:03:51 T:988   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT count(playCount) FROM musicvideo_view LIMIT 1'
22:03:51 T:988   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(watchedcount) FROM tvshow_view LIMIT 1
22:03:51 T:988   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(watchedcount) FROM tvshow_view LIMIT 1'
22:03:51 T:988   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(totalcount) FROM tvshow_view LIMIT 1
22:03:51 T:988   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(totalcount) FROM tvshow_view LIMIT 1'
22:03:51 T:988   ERROR: SQL: The table does not exist
                                            Query: SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1
22:03:51 T:988   ERROR: CDatabase::GetSingleValue - failed on query 'SELECT sum(watchedcount = totalcount) FROM tvshow_view LIMIT 1'
22:03:54 T:7436   ERROR: CNetworkInterfaceWin32::GetHostMacAddress - SendArp failed with error (67)
22:03:54 T:7436  NOTICE: CWakeOnAccess::SaveMACDiscoveryResult - Mac discovered for host '192.168.0.9' -> '00:11:3B:15:3D:02'
22:03:58 T:7008  NOTICE: Thread BackgroundLoader start, auto delete: false
22:03:59 T:996   ERROR: SQL: The table does not exist
                                            Query: SELECT COUNT(*) FROM episode_view WHERE strPath = 'nfs://192.168.0.9/mnt/user/Television/'
22:03:59 T:996   ERROR: exception in CApplication::FrameMove()
22:03:59 T:996   ERROR: SQL: The table does not exist
                                            Query: SELECT COUNT(*) FROM episode_view WHERE strPath LIKE 'nfs://192.168.0.9/mnt/user/Television/Breathless (2013)/'
22:03:59 T:996   ERROR: exception in CApplication::FrameMove()
[/b]

Which is making me think I've screwed the pooch on the database but I have no idea how!?

Also I've tried to remove and readd the database on the first machine, it's doing it, but it never shows up to watch....

Thanks to everyone who helps, this is driving me mad. My database skills are weak!

idgforum

2018-12-25, 11:39
Lucky you I get this:

MariaDB [(none)]> CREATE USER 'kodi' IDENTIFIED BY 'kodi';
ERROR 1396 (HY000): Operation CREATE USER failed for 'kodi'@'%'
MariaDB [(none)]>

Klojum

2018-12-25, 13:24
@Rodimus: Please follow the read bold red text above the Post Reply button next time before splashing larger log outputs directly onto the forum.

john.hind

2018-12-25, 13:55
One thought. When you entered the lines into Mariadb did you include the semi-colon at the end? Without it nothing gets set-up.
Kodi Community Forum > Support > General Support > Windows > MySql(mariadb) - Kodi - Unraid Issue