+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Kodi 19 - Does it not creat a new mysql Database (/showthread.php?tid=351260)
Kodi 19 - Does it not creat a new mysql Database - hermann_x5 - 2020-01-25
So, I installed V19 Nightly and it started by migrating my database. I can not find a new database in my mysql server, however. Fortunately V18 still seems to run fine but I am a bit worried if there are new features in the DB that could break functionality with V18 since it did not create a new database as was the case in the past ?
Kodi 19 - Does it not creat a new mysql Database - Karellen - 2020-01-25
To receive meaningful assistance you will need to provide a full debug log.
The instructions are here... debug log (wiki)
If you are using the Basic Method, then ensure the following is applied...
1.Enable debugging in Settings>System Settings>Logging,
2.Restart Kodi
3.Replicate the problem.
4.Upload the log to Kodi Paste Site manually or use the Kodi Logfile Uploader. (wiki) With either method post the link to the log back here.
If you are using the Advanced Method ensure you have correctly created and applied the advancedsettings.xml file (wiki)
In both instances, you should see the word DEBUG throughout the log.
Note: Full logs only. No partial or redacted logs
Do NOT post your logs directly into the forum. Use the Kodi Paste Site. Post the link to your pasted log in the forum
RE: Kodi 19 - Does it not creat a new mysql Database - hermann_x5 - 2020-01-25
(2020-01-25, 22:04)Karellen Wrote: To receive meaningful assistance you will need to provide a full debug log.
The instructions are here... debug log (wiki)
If you are using the Basic Method, then ensure the following is applied...
1.Enable debugging in Settings>System Settings>Logging,
2.Restart Kodi
3.Replicate the problem.
4.Upload the log to Kodi Paste Site manually or use the Kodi Logfile Uploader. (wiki) With either method post the link to the log back here.
If you are using the Advanced Method ensure you have correctly created and applied the advancedsettings.xml file (wiki)
In both instances, you should see the word DEBUG throughout the log.
Note: Full logs only. No partial or redacted logs
Do NOT post your logs directly into the forum. Use the Kodi Paste Site. Post the link to your pasted log in the forum
I was not asking for support, but a simple answer whether Kodi 19 creates a new database or not ...Many thanks !
RE: Kodi 19 - Does it not creat a new mysql Database - Karellen - 2020-01-25
Yes, it creates a new database
RE: Kodi 19 - Does it not creat a new mysql Database - hermann_x5 - 2020-01-26
(2020-01-25, 22:15)Karellen Wrote: Yes, it creates a new database
Ok, thanks...
From the logs it seems that it only migrated the Music database..........
2020-01-25 20:47:47.843 T:24568 NOTICE: Running database version Addons27
2020-01-25 20:47:47.844 T:24568 NOTICE: Running database version ViewModes6
2020-01-25 20:47:47.844 T:24568 NOTICE: Running database version Textures13
2020-01-25 20:47:47.864 T:24568 NOTICE: MYSQL: Connected to version 5.5.62-MariaDB
2020-01-25 20:47:47.868 T:24568 ERROR: Unable to open database: MyMusic73 [1049](Unknown database 'MyMusic73')
2020-01-25 20:47:47.875 T:24568 NOTICE: Old database found - updating from version 72 to 73
2020-01-25 20:49:04.697 T:24568 NOTICE: Attempting to update the database MyMusic73 from version 72 to 73
2020-01-25 20:53:33.160 T:24568 NOTICE: Running database version MyVideos116
2020-01-25 20:53:33.161 T:24568 NOTICE: Running database version TV36
2020-01-25 20:53:33.162 T:24568 NOTICE: Running database version Epg12
while loading the same MyVideos116 for videos.
Is this behaviour correct ?
I just want to understand what the changes in the video database are, if there are any ?
Many thanks !
RE: Kodi 19 - Does it not creat a new mysql Database - Karellen - 2020-01-26
Well it certainly sounds like you are asking for support. So I refer you back to my first post.
You can also search the wiki for "databases"
RE: Kodi 19 - Does it not creat a new mysql Database - DarrenHill - 2020-01-26
Thread moved to OS independent - this is a support request.
Currently Matrix is still using MyVideo116 - https://kodi.wiki/view/Databases#Database_Versions
RE: Kodi 19 - Does it not creat a new mysql Database - hermann_x5 - 2020-01-26
(2020-01-26, 10:00)DarrenHill Wrote: Currently Matrix is still using MyVideo116 - https://kodi.wiki/view/Databases#Database_Versions
actually, that's all I wanted to know. Again: this is NO support request. Thanks.
Does anybody know, whether Matrix will introduce a new db version and when ?
RE: Kodi 19 - Does it not creat a new mysql Database - hermann_x5 - 2020-01-26
(2020-01-26, 10:10)hermann_x5 Wrote:Also, just a small hint, it seems the wiki page is not up-to-date as it says that the Music DB is also still on V72. The MusicDB was migrated to V73 for me...(2020-01-26, 10:00)DarrenHill Wrote: Currently Matrix is still using MyVideo116 - https://kodi.wiki/view/Databases#Database_Versions
actually, that's all I wanted to know. Again: this is NO support request. Thanks.
Does anybody know, whether Matrix will introduce a new db version and when ?
RE: Kodi 19 - Does it not creat a new mysql Database - DarrenHill - 2020-01-26
@hermann_x5 - it will use new versions of each database (as you can see each major revision does so).
But as it's very much alpha (or even pre-alpha) at the moment it's not there yet for videos. I'll have a look at what may need updating in the wiki page.
RE: Kodi 19 - Does it not creat a new mysql Database - hermann_x5 - 2020-01-26
(2020-01-26, 10:39)DarrenHill Wrote: @hermann_x5 - it will use new versions of each database (as you can see each major revision does so).Ok, now, it's clear - many thanks !
But as it's very much alpha (or even pre-alpha) at the moment it's not there yet for videos. I'll have a look at what may need updating in the wiki page.
RE: Kodi 19 - Does it not creat a new mysql Database - black_eagle - 2020-01-26
(2020-01-26, 10:12)hermann_x5 Wrote: The MusicDB was migrated to V73 for me...
This is because the music database now contains extra information relating to box sets that wasn't present in v72. Migration is only needed when something 'extra' has been added to one of the db's such as an extra field or table so if nothing in the video db has changed then it doesn't need to be updated to a new version.
RE: Kodi 19 - Does it not creat a new mysql Database - DarrenHill - 2020-01-26
Confirmed, only the TV and Music db's have been bumped for now (and music will probably change again before full release).
Wiki page updated - thanks for the tip.
RE: Kodi 19 - Does it not creat a new mysql Database - DaveBlake - 2020-01-26
(2020-01-26, 10:12)hermann_x5 Wrote: Also, just a small hint, it seems the wiki page is not up-to-date as it says that the Music DB is also still on V72. The MusicDB was migrated to V73 for me...The wiki was written for v18 (it has a label that says that), and is very unlikely to include the recent v19 changes.
RE: Kodi 19 - Does it not creat a new mysql Database - hermann_x5 - 2020-01-26
(2020-01-26, 11:29)DarrenHill Wrote: Confirmed, only the TV and Music db's have been bumped for now (and music will probably change again before full release).
Wiki page updated - thanks for the tip.
perfect ! thank you !