Beta Upgrade to Kodi 19...database empty
#16
Hello everyone,

Same here, 2 devices, both upgraded. Database empty. Any playback attempt directly from the files causes complete crash.

UPDATE:

Mysql user had no privilege to create databases (not sure why though!)

Now everything seems to be fine. Thanks.
Reply
#17
I've tested to change the name of the ddb in Advancedsettings.xml file....
new ddb is created, so my Kodi user has the requested privileges....
but it is still empty...
don't know what to do to get my library back Sad

MyVideos119 explored with phpmyadmin shows lots of tables not empty, the paths are here, etc....
I don't understand why it is not showing up in my kodi Sad
Reply
#18
(2020-11-24, 22:59)VictorMSK Wrote: Hello everyone,

Same here, 2 devices, both upgraded. Database empty. Any playback attempt directly from the files causes complete crash.

UPDATE:

Mysql user had no privilege to create databases (not sure why though!)

Now everything seems to be fine. Thanks.
I also have complete crash when trying to play directly the files
But I checked my user, he has all privileges activated....
Reply
#19
(2020-11-26, 00:18)moreje Wrote:
(2020-11-24, 22:59)VictorMSK Wrote: Hello everyone,

Same here, 2 devices, both upgraded. Database empty. Any playback attempt directly from the files causes complete crash.

UPDATE:

Mysql user had no privilege to create databases (not sure why though!)

Now everything seems to be fine. Thanks.
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.
Reply
#20
(2020-11-26, 00:26)VictorMSK Wrote:
(2020-11-26, 00:18)moreje Wrote:
(2020-11-24, 22:59)VictorMSK Wrote: Hello everyone,

Same here, 2 devices, both upgraded. Database empty. Any playback attempt directly from the files causes complete crash.

UPDATE:

Mysql user had no privilege to create databases (not sure why though!)

Now everything seems to be fine. Thanks.
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 Sad
changing SQL user to root change nothing Sad
Reply
#21
(2020-11-26, 01:09)moreje Wrote:
(2020-11-26, 00:26)VictorMSK Wrote:
(2020-11-26, 00:18)moreje Wrote: 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 Sad
changing SQL user to root change nothing Sad

Nobody can help me? Sad
Reply
#22
(2020-11-24, 22:38)moreje Wrote: here it is:

Sorry my eyes cannot decypher such small screen shots.
Try using imgur instead, as ibb seems to scale down screen shots.
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
#23
(2020-11-26, 18:17)Klojum Wrote:
(2020-11-24, 22:38)moreje Wrote: 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!
Image
Reply
#24
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 Wink
Reply



Logout Mark Read Team Forum Stats Members Help
Upgrade to Kodi 19...database empty0
This forum uses Lukasz Tkacz MyBB addons.