[moreje]

I also have complete crash when trying to play directly the files
But I checked my user, he has all privileges activated....

Did you check the logs? You may also try to use root account to see if it helps.

yes the logs show sql errors:

Code:

INFO <general>: Attempting to update the database MyVideos119 from version 116 to 119
2020-11-25 23:48:01.501 T:19119   ERROR <general>: SQL: Can't determine list of routines to drop.
2020-11-25 23:48:01.502 T:19119   ERROR <general>: Exception updating database MyVideos119 from version 116 to 119
2020-11-25 23:48:01.502 T:19119   ERROR <general>: Error updating database MyVideos119 from version 116 to 119
2020-11-25 23:48:01.508 T:19119   ERROR <general>: Unable to open database: MyVideos118 [1049](Unknown database 'MyVideos118')
2020-11-25 23:48:01.514 T:19119   ERROR <general>: Unable to open database: MyVideos117 [1049](Unknown database 'MyVideos117')
2020-11-25 23:48:01.521 T:19119    INFO <general>: Old database found - updating from version 116 to 119
2020-11-25 23:48:01.523 T:19119   ERROR <general>: SQL: Can't create database for copy: 'MyVideos116' (1007)
2020-11-25 23:48:01.524 T:19119   ERROR <general>: Unable to copy old database MyVideos116 to new version MyVideos119

but can't find why
changing SQL user to root change nothing

Nobody can help me?

[Klojum]

here it is:

Sorry my eyes cannot decypher such small screen shots.
Try using imgur instead, as ibb seems to scale down screen shots.

[moreje]

here it is:

Sorry my eyes cannot decypher such small screen shots.
Try using imgur instead, as ibb seems to scale down screen shots.

sorry, hope it's better now!

[moreje]

Well, thank you for looking for that, but stop searching...I've opted out from beta program.... and rolled back to 18.9...
see you later on stable

[wwessel]

For those who have the same problem with the database: Just try to run mysql_upgrade.
This helped me with my installation...

[Klojum]

Just try to run mysql_upgrade.

And this made your mysql installation go from which version to which version?
"Go upgrade" is a little too vague of a solution for me.

[domax]

Just try to run mysql_upgrade.

And this made your mysql installation go from which version to which version?
"Go upgrade" is a little too vague of a solution for me.

I was facing the same issue on Kodi v19 final. 

on my  mariadb  ran  the following commands.  
donald@ubuntu:~$ docker exec -it mariadb /bin/bash
root@mariadb:/# mysql_upgrade -h127.0.0.1 -P 3306 --protocol=tcp -uroot -p

After this the database upgrade was successful.

My mariadb docker updates automatically to newer versions, but apparently the mysql_upgrade (which does some sort of update on all databases), never ran. 
the tip to run mysql_upgrade was the solution for me, might help others facing the same issue.

[HipToday]

For those who have the same problem with the database: Just try to run mysql_upgrade.
This helped me with my installation...

Awesome, this did the trick for me as well, thanks!

[kricker]

For those who have the same problem with the database: Just try to run mysql_upgrade.
This helped me with my installation...

Awesome, this did the trick for me as well, thanks!

This happened on my Android TV as well. I had to run the upgrade procedure above and then run Kodi Matrix from a windows box which properly upgraded the DB and everything was working again. I tried upgrading the DB from the Android TV unit after running the database upgrade and it still failed. I droppped the databases and then did it from the Windows system, which took a long time, but it worked and all is well again.

[HipToday]

For those who have the same problem with the database: Just try to run mysql_upgrade.
This helped me with my installation...

Awesome, this did the trick for me as well, thanks!

This happened on my Android TV as well. I had to run the upgrade procedure above and then run Kodi Matrix from a windows box which properly upgraded the DB and everything was working again. I tried upgrading the DB from the Android TV unit after running the database upgrade and it still failed. I droppped the databases and then did it from the Windows system, which took a long time, but it worked and all is well again.

Yeah, I should have mentioned I had to drop databases too. Just the newest ones, "MyVideos119" and "MyMusic82", that were created in the first attempt to migrate though. Then exiting/restarting Kodi (on my Chromecast with Google TV) was able to migrate successfully.

[rfrank]

I was having the same issue after upgrading from Kodi 18.9 to 19.0 on Ubuntu 20.04

mysql_upgrade didn't work for me as it's deprecated as of MySQL 8.0.16.

Digging through the kodi.log I found

ERROR <general>: SQL: [MyVideos119] Undefined MySQL error: Code (1419)

There was a very similar error relating to the music database as well.

It seems MySQL error 1419 means 'You do not have the SUPER privilege and binary logging is enabled'

So, I granted the kodi MySQL user SUPER privilege (and dropped the relevant databases) then restarted Kodi and it worked fine - libraries back available again and no crashes when playing media.

I've since revoked the SUPER privilege for the kodi MySQL user - my hunch being it was only necessary in the process of updating the database from one version of Kodi to the next - and everything seems to be continuing to work without any issues (including adding and removing sources from the library etc).

[tfonias74]

I was having the same issue after upgrading from Kodi 18.9 to 19.0 on Ubuntu 20.04

mysql_upgrade didn't work for me as it's deprecated as of MySQL 8.0.16.

Digging through the kodi.log I found

ERROR <general>: SQL: [MyVideos119] Undefined MySQL error: Code (1419)

There was a very similar error relating to the music database as well.

It seems MySQL error 1419 means 'You do not have the SUPER privilege and binary logging is enabled'

So, I granted the kodi MySQL user SUPER privilege (and dropped the relevant databases) then restarted Kodi and it worked fine - libraries back available again and no crashes when playing media.

I've since revoked the SUPER privilege for the kodi MySQL user - my hunch being it was only necessary in the process of updating the database from one version of Kodi to the next - and everything seems to be continuing to work without any issues (including adding and removing sources from the library etc).

Hello, I have the same issue.. can you provide the command to grand these priviledge?

[Freeco]

So, I granted the kodi MySQL user SUPER privilege (and dropped the relevant databases) then restarted Kodi and it worked fine - libraries back available again and no crashes when playing media.

Thanks, this indeed fixed my issue that Kodi would fail to query movie_view after the upgrade from v18 to v19.
--> Granting the user SUPER privilege, dropping the MyMusic82 and MyVideos119 DBs and starting Kodi again did the trick.
I now see both 'tables' and 'views' under the corresponding DBs, where previously there were no views.

[tfonias74]

So, I granted the kodi MySQL user SUPER privilege (and dropped the relevant databases) then restarted Kodi and it worked fine - libraries back available again and no crashes when playing media.

Thanks, this indeed fixed my issue that Kodi would fail to query movie_view after the upgrade from v18 to v19.
--> Granting the user SUPER privilege, dropping the MyMusic82 and MyVideos119 DBs and starting Kodi again did the trick.
I now see both 'tables' and 'views' under the corresponding DBs, where previously there were no views.

can you provide the command to grand these priviledge?

[sIRwa2]

So, I granted the kodi MySQL user SUPER privilege (and dropped the relevant databases) then restarted Kodi and it worked fine - libraries back available again and no crashes when playing media.

Thanks, this indeed fixed my issue that Kodi would fail to query movie_view after the upgrade from v18 to v19.
--> Granting the user SUPER privilege, dropping the MyMusic82 and MyVideos119 DBs and starting Kodi again did the trick.
I now see both 'tables' and 'views' under the corresponding DBs, where previously there were no views.

can you provide the command to grand these priviledge?

i think if your user is GRANT ALL, thats the same as super. https://mariadb.com/kb/en/show-grants/


For all other users looking into this thread, dont know if it helps, but i think i fixed it with running this on the linux server hosting the mariadb.. (so, dont log into mariadb with the msql command!!)

> mysql_upgrade -u kodi -h 192.168.0.110 -p --force

one@debianone:~$ mysql_upgrade -u kodi -h 192.168.0.110 -p --force

change your user and IP adress obviously