v18 Android - Sql music Database does not update - after upgrade (V17-> V18)
#1
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
Reply
#2
(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.
Got a Kodi problem? Provide us with a full Debug log (wiki) || Usefull pages: First time user (wiki) || Troubleshooting (wiki) || Free content (wiki) || Forum rules (wiki) || VPN policy (wiki)
Reply
#3
(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...
Reply
#4
(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.
My Signature
Links to : Forum rules (wiki) | Banned_Add-ons (wiki) | Debug Log (wiki)
Links to : HOW-TO:Create_Music_Library (wiki) | HOW-TO:Create_Video_Library (wiki) || Artwork (wiki) | Basic_controls (wiki) | Import-export_library (wiki) | Movie_sets (wiki) | NFO_files (wiki) | Quick start guide (wiki)
Reply
#5
(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
Reply
#6
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.
Got a Kodi problem? Provide us with a full Debug log (wiki) || Usefull pages: First time user (wiki) || Troubleshooting (wiki) || Free content (wiki) || Forum rules (wiki) || VPN policy (wiki)
Reply
#7
(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.
Reply
#8
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.
Got a Kodi problem? Provide us with a full Debug log (wiki) || Usefull pages: First time user (wiki) || Troubleshooting (wiki) || Free content (wiki) || Forum rules (wiki) || VPN policy (wiki)
Reply
 
Thread Rating:
  • 0 Vote(s) - 0 Average



Logout Mark Read Team Forum Stats Members Help
Android - Sql music Database does not update - after upgrade (V17-> V18)00