Hi All,
When playing 4K content on my RPi4, first the screen goes black intermittently, and eventually the HDMI signal to my TV is lost. The video keeps playing, because after a reboot I noticed that multiple episodes of this 4K content were marked as watched. When playing HD content or music everything works fine.
Please advice me on how to resolve this.
Best regards!
I switched to MariaDB10 for my video library, and the views for unwatched and recently added movies are back! 
Thanks for your help Klojum
All the best wishes for 2020!
Today I have exported the MyVideos114 and MyVideos116 databases from MariaDB5 and imported both into MariaDB10, and deleted the older ones. Can you tell me why the databases have a smaller size in MariaDB 10? Did I miss something while exporting?
MariaDB5
MyVideos114 > 23.8 MiB
MyVideos116 > 28.2 MiB
MariaDB10
MyVideos114 > 18.4 MiB
MyVideos116 > 15.0 MiB
Best regards!
As I was not sure what to leave out, I have performed a fresh install on a new sd card, and created a new log:
Klojum I've changed the skin to Estuary, enabled component specific logging for the database component, and created a new log (Connecting...). This one is even bigger (27.7MB) so I can imagine it will take a bit longer to work through it.
I have these video databases for Kodi:
MyVideos75
MyVideos108
MyVideos109
MyVideos110
MyVideos112
MyVideos113
MyVideos114
MyVideos116
As Kodi uses MyVideos116, I've checked which tables and views are present:
Tables
actor
actor_link
art
bookmark
country
country_link
director_link
episode
files
genre
genre_link
movie
movielinktvshow
musicvideo
path
rating
seasons
sets
settings
stacktimes
streamdetails
studio
studio_link
tag
tag_link
tvshow
tvshowlinkpath
uniqueid
version
writer_link
Views
episode_view
movie_vies
musicvideo_view
season_view
tvshowcounts
tvshowlinkpath_minview
tvshow_view
Have found which steps I have to take to migrate the Kodi databases to MariaDB 10, but as some other stuff is also using MariaDB 5 (spotweb/phpmyadmin/wordpress), I also have to look into migrating those.
Best regards!
Klojum Thanks for solving a part of the puzzle. 
Will change the skin and create a new log. I have MariaDB 10 installed on my NAS as well, have to look into how to migrate my databases. As I am pretty busy the coming days, will probably provide the log friday.
Best regards!
Klojum Were you able to download the logfile?
Want to get you all the pieces, but the logfile is too big (16.8MB) for (free) pastebin. Hope this works: Connecting...
You can start by providing the FULL log file, via a pastebin website.
Do you need just the full log, or the debug log?
Hi all,
Yesterday I noticed that in the movies menu that no movies are shown, only in progress movies and movie sets. Seems to be an issue with SQL and/or the playlists, because this is shown in my log:
ERROR: SQL: Missing result set!
ERROR: GetMoviesByWhere failed
ERROR: GetDirectory - Error getting special://skin/playlists/unwatched_movies.xsp
ERROR: SQL: Missing result set!
ERROR: GetMoviesByWhere failed
ERROR: GetDirectory - Error getting special://skin/playlists/recent_movies.xsp
ERROR: SQL: Missing result set!
ERROR: GetMoviesByWhere failed
ERROR: GetDirectory - Error getting special://skin/playlists/random.xsp
How can I further troubleshoot this? Or can I recreate these files?
Best regards!
