Recently added suddenly blank for Movies

[Cartman123]

Something has gone wrong with my two Shields after MySQL/media server was upgraded from ubuntu 18.04 to 20.04.

Everything is working except one function, the "Recently added" information is blank for my Movie collection. The TV collection is showing and updating fine as episodes are added. I changed the scraper used for the Movies and did a refresh of the library. For a short while at the start of the refresh the "Recently added" infomration was showing but before the refresh was done it had gone all blank again. If I use the arrow left to select recently added from Movies I just land on the menu for sources and not a library list.

Any idea what has gone wrong/how to fix? It is the same on both Shields so I'm worried the database has been corrupted.

[amet]

anything in debuglog?

[Cartman123]

I will get one generated/uploaded later today.

[Cartman123]

Log 2Q8LS.log uploaded.

[amet]

seems that server is not returning the Recently Added items...

Code: Select all

23:08:16.377 T:184687428848   DEBUG: CHomeShelfJob::UpdateVideos() - Running HomeShelf screen update
23:08:16.519 T:184687428848   ERROR: SQL: Missing result set!
23:08:16.519 T:184687428848   ERROR: GetMoviesByWhere failed

have a look at the instructions on our MySQL page on how to change cache limit and size, maybe that will help.... I have never seen that error

maybe see the kodi solution also -> https://forum.kodi.tv/showthread.php?ti ... pid2850824

[Cartman123]

The changes in your Wiki are not applicable to MySQL version 8 that is in Ubuntu 20.04 as the syntax has changed.

I found these instructions after a bit of Googling which did fix the issue:

Edit /etc/mysql/mysql.conf.d/mysqld.cnf and add the following line at the bottom:

sort_buffer_size = 1M

Then restart mysql:

systemctl restart mysql

[amet]

Good, that’s the same solution Kodi forum link has