Kodi Community Forum

Full Version: Can't add to Movie Sets with MySQL enabled.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
When I open Kodi up I try to go into a list of just Movie Sets and it just spins with a wheel for a second and then I'm right back to where we started.  When I try to manage a movie and then manage a movie set, I also get the spin wheel before it's back to where we started.  Now regular movie sets still work such as the Tobey MacGuire Spider-man movies.  I can open that set up and it will have the three movies there.  It's when I try to add anything or create a new movie set that it gives me this error.  

Here is the log: https://controlc.com/6c864eb0

Please help.  I almost quite have this the way I like it.  The other items are that since I've enabled MySQL (newest version) and it's syncing across the network library scans are really really slow.  Like if I refresh a TV show for all episodes, it takes 10-15 minutes whereas without Advancedsettings.xml and it' being it's own library it would be 3.
@ozpapa

Please do not bump your thread within the hour.
We are not your personal assistant.
There is a problem with your mysql installation.
Quote: 2020-06-23 08:25:46.172 T:9040 ERROR: SQL: Missing result set!
2020-06-23 08:25:46.173 T:9040 ERROR: CVideoDatabase::GetMoviesByWhere failed

IIRC, the fix is to increase the sort buffer size to something much bigger. Eg,

sql:
[mysqld]

sort_buffer_size = 16M

That needs to go in the configuration file for mysql (my.cnf).