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 kodi log but also shows advancesettings.xml

 

[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 kodi log all these errors....(full log is attached)

 

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
[/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 koid 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 and the more I think about it must be the cause of the issue!?

 

EDIT: The log won't attach, crashes the forum page and tries to open a new thread page. Rather odd but the overall gist of the issue is in the above, it repeats the no sql table over and over...

This is more an alternate suggestion - why don't you just install EMBY as a docker, which handles a DB install for multi KOdi Clients along with auto meta data downloading, multi users for watched tracking parental controls etc?

 

I use EMBY as the back end - along with a couple of KODI clients runing on Chrome Boxes, plus some EMBY clients running on amazon Fire TVs.

Hey,

 

I'm thinking I might try that at this rate, it's the wanting opencloud at a later date that's put me off.

 

I spent ages staring at error logs the last few days and all I can think is that it's the kodi output to the database that's causing it....but I'm stumped.