Posts: 577
Joined: Oct 2017
Reputation:
79
Fuzzard
Team-Kodi Member
Posts: 577
Yes, drop the latest table and on next run Kodi will do the upgrade from your previous v19 tables.
Posts: 2
Joined: Jan 2023
Reputation:
0
Same problem here...
Seems that conversion from myvideos119 to myvideos121 doesn't work.
There are only the tables "db.opt" and "actor.ibd" in myvideos121.
This happens under Android (Google Chromecast TV) and Windows 10.
MariaDB is running on Win 10 Fileserver.
Removing myvideos121 and restart or uninstall/install Kodi 20 -> no change.
Going back to Kodi 19.x -> everything works fine...
Regards
Kaa60
Posts: 2
Joined: Jan 2023
Reputation:
0
This worked for me:
I've made the mistake to stop MariaDB manually and then delete manually the faulty MyVideos121 folder.
This will not work.
After reading a lot about kodi.logs and database-errors I later used the tool HeidiSQL to delete the MyVideos121 database.
This seems to be the correct way.
Next time Kodi 20 started, the database migration worked and Kodi 20 is now running fine.
- I also updated MariaDB to version 10.11.1 but this might not have been the point...
Regards
Kaa60
Posts: 475
Joined: Aug 2004
Reputation:
0
2023-01-21, 17:48
(This post was last modified: 2023-01-21, 17:48 by snowjim.)
In my case I clicked Kodi and notice that it was suddenly a new version that needed updating which stated right away. I'm using a logitech remote and somehow I clicked exit to main menu almost instantly, the second time I started the upgrade did not show and it just froze.
I have read a couple of other posts that had similar problem but I do not know if it was the same reason. If dev would want to make it a bit safer I would suggest : Active Dialog that explains new version and that a critical migration needs to be done and that you need to accept. Much like much other software, specially firmwares. You can probably argue why it is not needed but It would have saved me a couple of hours.
I don't work with MySQL anymore and don't really like it but I have to use it for Kodi. I have had a lot of problems with MySQL both as a dev and with kodi, last time I installed MySQL I had to reinstall it because something something with incompatible versions and backups. Lost data several times over the years, something that are more or less impossible in for example MS SQL. I'm sure that MySQL works great if you use it exactly as intended but you need to invest more time to do that. So, is there a real reason to why I need to update my MySQL? And is it 100% safe? No data loss? If so, what version are you suggesting?
Posts: 861
Joined: Nov 2016
Reputation:
117
wags1
Posting Freak
Posts: 861
Both my Kodi instances on my 2 Shield Pros updated yesterday. I run my DBs (video and music) on a Synology NAS using MariaDB. Everything migrated without a hitch. I’ll run it for a few days to make sure everything is good and then delete the old DBs.
Posts: 861
Joined: Nov 2016
Reputation:
117
wags1
Posting Freak
Posts: 861
Hmm, I just looked at my DB's and I do have a migrated video DB (kodi_video121) plus the old video DB (kodi_video119) but I only have 1 music DB (kodi_music82). Everything seems to be working so does that mean the music DB does not need to be migrated?
Posts: 20
Joined: Jul 2018
Reputation:
0
I just got the 20 update on my Shield and I had the menus using jpg as background images but now the folder that contains the jpg backgrounds shows empty and no backgrounds show on the menus. Anyone else having this?
Posts: 3,514
Joined: Jan 2023
Reputation:
330
missing files on v20 android? look up at the giant blue banner at the top of the page ^^^
if you already have it would be useful to note it