Beta Upgrade to Kodi 19...database empty
#1
Hello,
My Android Kodi just upgraded to v19.0 beta.
I use a shared database stored on my NAS.
After upgrade, the kodi ddb went empty.
but my advancedsettings.xml file is still present...and all was fine before upgrade.
Do I have to change something to switch between v18 to v19?
Thanks for your help
J
Reply
#2
@moreje

You must be enrolled in the Beta testers program to be update from v18 to v19 Beta.

Have you restarted Kodi?

Provide a Debug Log which captures a library update. (I know there is nothing there, but run it anyway)
My Signature
Links to : Official:Forum rules (wiki) | Official:Forum rules/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) | Movie universe (wiki) | NFO files (wiki) | Quick start guide (wiki)
Reply
#3
All my 3 android boxes upgraded automatically last night! Not sure thats meant to happen or maybe I signed up to the beta in years gone by Smile

Oh well time to start migrating the 40+ addons I have to python 3! and my default skin mod...

Edit: yes according to google play I am a beta tester, OK bring it on Smile
Reply
#4
(2020-11-22, 01:51)Karellen Wrote: @moreje

You must be enrolled in the Beta testers program to be update from v18 to v19 Beta.

Have you restarted Kodi?

Provide a Debug Log which captures a library update. (I know there is nothing there, but run it anyway)
Hello,
here is the log of my Kodi v19
seems to have a ddb issue...

https://paste.kodi.tv/itahaqutuy.kodi

I explored my MariaDB .... found MyVideos116 and MyVideo119
the 119 seems not to be empty...
thank you for your help
Moreje
Reply
#5
I also lost lot of movies and series when it updated to 19.0. 
Seems like 19.0 dont support rar-files or archive?? Anyone?
Reply
#6
I've droped the Video119 ddb...and then restart kodi.
I got the migration database message...but after completion, it is still empty.
here is the new logfile: https://paste.kodi.tv/asizekuwif.kodi
Thank you for your help
Moreje
Reply
#7
2020-11-24 12:10:21.834 T:31535 ERROR <general>: Unable to open database: MyMusic81 [1049](Unknown database 'MyMusic81')
2020-11-24 12:11:18.575 T:31535 ERROR <general>: Unable to open database: MyVideos115 [1049](Unknown database 'MyVideos115')

Your database server setup has a hiccup. I'm guessing insufficient user rights of the database user 'kodi'.

2020-11-24 12:10:21.813 T:31535 ERROR <general>: SQL: Can't determine list of routines to drop.
This doesn't help either.
Reply
#8
(2020-11-24, 18:41)Klojum Wrote: 2020-11-24 12:10:21.834 T:31535 ERROR <general>: Unable to open database: MyMusic81 [1049](Unknown database 'MyMusic81')
2020-11-24 12:11:18.575 T:31535 ERROR <general>: Unable to open database: MyVideos115 [1049](Unknown database 'MyVideos115')

Your database server setup has a hiccup. I'm guessing insufficient user rights of the database user 'kodi'.

2020-11-24 12:10:21.813 T:31535 ERROR <general>: SQL: Can't determine list of routines to drop.
This doesn't help either.
It was my asumption first but, I checked and kodi user has ALL_PRIVILEGES activated
Image
And the Myvideo119 is effectively created during the migration process, looks like a copy of the MyVideos116, but it does not show up in my kodi
Reply
#9
Show me the listing of all video database tables, views and triggers.
Reply
#10
here it is:

Image
Reply
#11
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
#12
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
#13
(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
#14
(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
#15
(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

Logout Mark Read Team Forum Stats Members Help
Upgrade to Kodi 19...database empty0