[stramoski]

I'm using mysql for my library to sync between several machines (android on my phone, FireTV sticks, and windows pcs) and they are all experiencing the same issue.

When I select "Recently Added", whether on the TV or Movies section, kodi navigates to the "root" of that section instead. I.e., I select recently added in the movies section and am just directed to the menu with "Recently Added", "Genres", "Titles", etc.

I've turned on logging, but I am not sure what to do.

I tried recreating my entire MySQL library, but the problem just came right back.

https://paste.kodi.tv/raw/hiyedanede

[Klojum]

2020-12-19 14:55:47.671 T:6740 NOTICE: Disabled debug logging due to GUI setting. Level 0.
Always restart Kodi when enabling debugging, so more details will be shown from the start.

2020-12-19 14:55:52.304 T:6740 NOTICE: MYSQL: Connected to version 8.0.22-0ubuntu0.20.10.2
..
2020-12-19 14:55:54.642 T:6396 ERROR: SQL: Missing result set!
2020-12-19 14:55:58.284 T:6740 ERROR: CVideoDatabase::GetMoviesByWhere failed
2020-12-19 14:55:58.541 T:4144 ERROR: CVideoDatabase::GetTvShowsByWhere failed

MySQL 8.0 can have its nags, and apparently retrieving the 'Recently added' listings is a problem.

Can you enable the Database component in the debugging section, restart Kodi, reproduce the error(s), and provide a new debug log file?

[DaveBlake]

Solution to ERROR: SQL: Missing result set! and MySQL 8.0 given here https://forum.kodi.tv/showthread.php?tid=357217

Cause of the error is in MySQL solved by changing the sort_buffer_size setting