No movies shown (only in progress and sets), error in log

MacLeod · December 15, 2019 at 4:07 PM

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!

**Klojum** · December 15, 2019 at 4:40 PM Official Post

Quote from MacLeod

How can I further troubleshoot this?

You can start by providing the FULL log file, via a pastebin website.

There is not much we can do with 3 identical error messages alone.

My first guess would be a corrupted database, but we'll find out once the rest of your log is known.

MacLeod · December 15, 2019 at 6:37 PM

Quote from Klojum

You can start by providing the FULL log file, via a pastebin website.

Do you need just the full log, or the debug log?

**Klojum** · December 15, 2019 at 8:29 PM Official Post

All of it.

You'd too want all the pieces if you were to solve a puzzle, right?

MacLeod · December 15, 2019 at 9:13 PM

Want to get you all the pieces, but the logfile is too big (16.8MB) for (free) pastebin. Hope this works: Connecting...

MacLeod · December 16, 2019 at 8:17 PM

Klojum Were you able to download the logfile?

**Klojum** · December 17, 2019 at 5:05 AM Official Post

Yeah... Although a 17MB log file is not really a joy.

Anyway: 2019-12-15 19:28:03.926 T:1807721344 NOTICE: MYSQL: Connected to version 5.5.62-MariaDB
That's a pretty old version... Any chance you can upgrade it to something more contemporary?

I see several of this one: ERROR: SQL: Missing result set!

But I don't see a query going wrong.

You could also enable the Database component in the logging options.

2019-12-15 19:29:09.848 T:1593762688 ERROR: GetSingleValue - failed on query 'SELECT count(1) FROM movie_view LIMIT 1'

2019-12-15 19:29:09.890 T:1593762688 ERROR: GetSingleValue - failed on query 'SELECT count(playCount) FROM movie_view LIMIT 1'

You may have a corrupted database.

Can you check which tables and views are present on your database server?

And all the 'spam' in your log...

NOTICE: ADDON: skin.estuary.modv2 v3.0.5 installed

It's a skin with lots of added 'features' but the whole package also has been pretty unstable IMO.

Change to the default Estuary skin and restart LibreELEC before providing a new log file.

MacLeod · December 17, 2019 at 10:21 PM

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!

MacLeod · December 20, 2019 at 2:57 PM

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** · December 20, 2019 at 3:27 PM Official Post

All old databases below v114 can be removed, unless you have specific contents in them.

The table and view listing is okay.

If you can run multiple database servers, all you need to do is change the port number(s).

And I cannot download the log file for some reason.

How about you clean it up, I think there is a similar unnecessary amount of 'spam' in it. And then upload it to a normal pastebin website..

MacLeod · December 20, 2019 at 4:05 PM

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:

External Content pastebin.com

Content embedded from external sources will not be displayed without your consent.

Through the activation of external content, you agree that personal data may be transferred to third party platforms. We have provided more information on this in our privacy policy.

MacLeod · December 22, 2019 at 4:08 PM

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!

**Klojum** · December 22, 2019 at 5:54 PM Official Post

Quote from MacLeod

Did I miss something while exporting?

I cannot tell you that. You will have to do a compare between the various dump files and see where things are different.

If those are the total database sizes, then perhaps caching values are different.

MacLeod · December 28, 2019 at 1:04 PM

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!