Until two days ago, I used Kodi 20 with MariaDB 10.3.2 from my Nvidia Shield device without problems. After the update to Kodi 21, MyVideos121 migrated to MyVideos131 and Kodi started scanning. All movies and tvshows are found and can be accessed, but no information is stored. After scanning, the content references on the folders are lost as well.
I have a feeling the migration didn’t go well. When inspecting the database, I noticed that MyVideos121 has views besides tables, but MyVideos131 only has tables but no views. I removed the databases to migrate again, but the resulting database is the same. I’m unable to find an “upgrade” log which could provide information on any migration issues.
Just to be certain, I removed advancedsettings.xml to confirm that Kodi can still create a database with information. Just not a MySQL database.
I have the kodi.log at https://paste.kodi.tv/sogikemaka.kodi
The line `2024-04-26 20:54:57.143 T:22366 error <general>: SQL: Can’t determine list of routines to drop.` is suspicious to me…
Did anyone else have this issue?
Is there an upgrade log available somewhere?