2023-03-23, 19:06
I'm a bit stumped here. Ever since upgrading to Kodi 20, I am having issues with sql. Kodi logs in fine and updated the db when I watch a video/tv show and everything seems normal until I logout. Once I click the logout, kodi immediately freezes. No additional lines in the log (even with verbose all the way up). When I force quit kodi and then open it back up, It has me logged in to the Master profile instead of the one I was logged into. I can log out of it and log into the profile I was in and everything seems normal again until I try to log out. Logs show I am connected to nick-movies and nick-music schemas just as intended. I tried dropping the tables and letting kodi recreate them, same result. I also tried removing the <name> tag and letting it create the basic movies121 db (which won't be an option for me but wanted to test), same result. If I delete the advancedsettings.xml file from that profile and restart then everything logs out just fine. Is anyone else experiencing this? Here is my file
python:<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.xx.xx</host>
<port>3306</port>
<user>kodi</user>
<pass>*******</pass>
<name>nick-movies</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.64</host>
<port>3306</port>
<user>kodi</user>
<pass>*******</pass>
<name>nick-music</name>
</musicdatabase>
</advancedsettings>