Kodi Community Forum

Full Version: Android - Sql music Database does not update - after upgrade (V17-> V18)
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi,

I tried the new V18 version on Android (with Synology/My Sql-MariaDB ).
All works well only the music menu.
When i launch the music menu. Kodi failed

In the log, i've :
2019-04-13 12:07:53.977 T:6417  NOTICE: Old database found - updating from version 60 to 72
2019-04-13 12:07:53.985 T:6417   ERROR: SQL: Can't create database for copy: 'MyMusic60' (1007)
2019-04-13 12:07:53.989 T:6417   ERROR: Unable to copy old database MyMusic60 to new version MyMusic72

All passwords working well.

Any idea ?

Thanks a lot
(2019-04-13, 14:48)Gilb-r Wrote: [ -> ]Any idea ?

With only 3 lines of the total debug log (wiki) file? Eh, nope. Smile
First guess: your database upgrade went wrong due to insufficient database user rights.

Enable debugging, and also enable the Database component in the debugging section. Then restart Kodi for a clean log.
Upload your log file to https://paste.kodi.tv/ and we may see what the culprit is.
(2019-04-13, 16:01)Klojum Wrote: [ -> ]
(2019-04-13, 14:48)Gilb-r Wrote: [ -> ]Any idea ?

With only 3 lines of the total debug log (wiki) file? Eh, nope. Smile
First guess: your database upgrade went wrong due to insufficient database user rights.

Enable debugging, and also enable the Database component in the debugging section. Then restart Kodi for a clean log.
Upload your log file to https://paste.kodi.tv/ and we may see what the culprit is. 
Hi,
you are right, this the fully log : i upload le og in paste.kodi : do you see it
I think i've all the right on my account because it's works well videos database...
(2019-04-15, 12:46)Gilb-r Wrote: [ -> ]i upload le og in paste.kodi : do you see it
No, we do not see it. You have to provide the link.

Copy the address in the address bar and post it into a post.
(2019-04-15, 12:49)Karellen Wrote: [ -> ]
(2019-04-15, 12:46)Gilb-r Wrote: [ -> ]i upload le og in paste.kodi : do you see it
No, we do not see it. You have to provide the link.

Copy the address in the address bar and post it into a post. 
Here it is :
xakajadeko.kodi (paste)
Thanks
Code:
2019-04-15 12:32:13.541 T:20567 NOTICE: MYSQL: Connected to version 10.3.7-MariaDB
2019-04-15 12:32:13.691 T:20567 ERROR: Can't update database MyMusic72 from version 0 - it's too old
2019-04-15 12:32:13.719 T:20567 ERROR: Unable to open database: MyMusic71 [1049](Unknown database 'MyMusic71')
2019-04-15 12:32:13.763 T:20567 ERROR: Unable to open database: MyMusic70 [1049](Unknown database 'MyMusic70')
...
2019-04-15 12:32:14.133 T:20567 NOTICE: Old database found - updating from version 60 to 72
2019-04-15 12:32:14.172 T:20567 ERROR: SQL: Can't create database for copy: 'MyMusic60' (1007)
2019-04-15 12:32:14.176 T:20567 ERROR: Unable to copy old database MyMusic60 to new version MyMusic72

It's clear enough as far as I can see. Try doing a mysqldump backup of the MyMusic60 database, have Kodi create a new music database, and restore the backup in it.
(2019-04-15, 13:38)Klojum Wrote: [ -> ]
Code:
2019-04-15 12:32:13.541 T:20567 NOTICE: MYSQL: Connected to version 10.3.7-MariaDB
2019-04-15 12:32:13.691 T:20567 ERROR: Can't update database MyMusic72 from version 0 - it's too old
2019-04-15 12:32:13.719 T:20567 ERROR: Unable to open database: MyMusic71 [1049](Unknown database 'MyMusic71')
2019-04-15 12:32:13.763 T:20567 ERROR: Unable to open database: MyMusic70 [1049](Unknown database 'MyMusic70')
...
2019-04-15 12:32:14.133 T:20567 NOTICE: Old database found - updating from version 60 to 72
2019-04-15 12:32:14.172 T:20567 ERROR: SQL: Can't create database for copy: 'MyMusic60' (1007)
2019-04-15 12:32:14.176 T:20567 ERROR: Unable to copy old database MyMusic60 to new version MyMusic72

It's clear enough as far as I can see. Try doing a mysqldump backup of the MyMusic60 database, have Kodi create a new music database, and restore the backup in it.
Thanks, i will try your answer.
2019-04-15 12:32:14.172 T:20567 ERROR: SQL: Can't create database for copy: 'MyMusic60' (1007)
Looking at it again... This is kind of weird. Perhaps your kodi database user does not have full privileges for creating a new database.

2019-04-15 12:32:13.691 T:20567 ERROR: Can't update database MyMusic72 from version 0 - it's too old
But then again, this is strange as well. Version 0 ?

Better update the SQL server first.