[raadoo]

I cannot see Movie and TV Libraries after installing Krypton beta1. Music DB was upgraded and library can be seen. But movies are not available. Here is part from log file:

Code:

T:3116 NOTICE: Running database version Addons26 22:12:55 T:3116 DEBUG: CDatabaseManager::Initialize, updating databases... 22:12:55 T:3116 NOTICE: Running database version ViewModes6 22:12:55 T:3116 NOTICE: Running database version Textures13 22:12:55 T:3116 INFO: MYSQL: Connected to version 5.5.47-MariaDB 22:12:56 T:3116 NOTICE: Running database version MyMusic60 22:12:56 T:3116 NOTICE: Attempting to update the database MyVideos107 from version 99 to 107 22:12:56 T:3116 DEBUG: Mysql Start transaction 22:12:56 T:3116 DEBUG: Mysql execute: ALTER TABLE seasons ADD userrating INTEGER 22:12:56 T:3116 ERROR: SQL: [MyVideos107] Undefined MySQL error: Code (1060)

Query: ALTER TABLE seasons ADD userrating INTEGER

22:12:56 T:3116 ERROR: Exception updating database MyVideos107 from version 99 to 107 22:12:56 T:3116 ERROR: Error updating database MyVideos107 from version 99 to 107 22:12:56 T:3116 DEBUG: Mysql rollback transaction 22:12:56 T:3116 ERROR: Unable to open database: MyVideos106 [1049](Unknown database 'MyVideos106') 22:12:56 T:3116 ERROR: Unable to open database: MyVideos105 [1049](Unknown database 'MyVideos105') 22:12:56 T:3116 ERROR: Unable to open database: MyVideos104 [1049](Unknown database 'MyVideos104') 22:12:56 T:3116 ERROR: Unable to open database: MyVideos103 [1049](Unknown database 'MyVideos103') 22:12:56 T:3116 ERROR: Unable to open database: MyVideos102 [1049](Unknown database 'MyVideos102') 22:12:56 T:3116 ERROR: Unable to open database: MyVideos101 [1049](Unknown database 'MyVideos101') 22:12:56 T:3116 ERROR: Unable to open database: MyVideos100 [1049](Unknown database 'MyVideos100') 22:12:56 T:3116 NOTICE: Old database found - updating from version 99 to 107 22:12:56 T:3116 ERROR: SQL: Can't create database for copy: 'MyVideos99' (1007) 22:12:56 T:3116 ERROR: Unable to copy old database MyVideos99 to new version MyVideos107 22:12:56 T:3116 NOTICE: Running database version TV29 22:12:56 T:3116 NOTICE: Running database version Epg11 22:12:56 T:3116 DEBUG: CDatabaseManager::Initialize, updating databases... DONE 22:12:56 T:3116 DEBUG: DPMS: supported power-saving modes: OFF STANDBY 22:12:56

I also submitted a bug http://trac.kodi.tv/ticket/16884 but I'd like to solve a problem and start to use beta Kodi.

2nd question - is it possible to use different versions of Kodi which require different version of db. In my case Kodi Krypton beta1 and the last version of Openelec

[bilgepump]

2nd question - is it possible to use different versions of Kodi which require different version of db. In my case Kodi Krypton beta1 and the last version of Openelec

I have several computers. I installed Krypton to "have a look at it" on one computer, but I still had Jarvis on another computer. Both worked - although obviously they weren't sharing watched status.

[phate89]

Did you use an altered mysql database? Because error 1060 is an error you get if you try to add a column that already exist.. Can you try to delete the new database (MyVideos107) and post again the log of the database update?

is it possible to use different versions of Kodi which require different version of db. In my case Kodi Krypton beta1 and the last version of Openelec

You can but they will stay as 2 different databases
For example: you add a movie from krypton beta1 -> the jarvis version won't have that movie
you watch a movie in jarvis version -> in the krypton is still unwatched

And when you will eventually update jarvis to krypton you will have for both the krypton database and changes to jarvis database will be lost..

[fbacher]

Encountered same problem migrating from Kodi 16.1 to 17 Beta2. I use mysql as my database. The first time this occurred I did not capture the kodi.log file. I dropped MyVideos107 and then restarted kodi. This time I captured the following from the log:

17:11:43 T:140272247281792 NOTICE: Running database version MyMusic60
17:11:43 T:140272247281792 ERROR: Unable to open database: MyVideos107 [1049](Unknown database 'MyVideos107')
17:11:43 T:140272247281792 ERROR: Unable to open database: MyVideos106 [1049](Unknown database 'MyVideos106')
17:11:43 T:140272247281792 ERROR: Unable to open database: MyVideos105 [1049](Unknown database 'MyVideos105')
17:11:43 T:140272247281792 NOTICE: Old database found - updating from version 104 to 107
17:12:42 T:140272247281792 NOTICE: Attempting to update the database MyVideos107 from version 99 to 107
17:12:42 T:140272247281792 ERROR: SQL: [MyVideos107] Undefined MySQL error: Code (1060)
Query: ALTER TABLE seasons ADD userrating INTEGER
17:12:42 T:140272247281792 ERROR: Exception updating database MyVideos107 from version 99 to 107
17:12:42 T:140272247281792 ERROR: Error updating database MyVideos107 from version 99 to 107
17:12:42 T:140272247281792 ERROR: Unable to open database: MyVideos103 [1049](Unknown database 'MyVideos103')
17:12:42 T:140272247281792 ERROR: Unable to open database: MyVideos102 [1049](Unknown database 'MyVideos102')
17:12:42 T:140272247281792 ERROR: Unable to open database: MyVideos101 [1049](Unknown database 'MyVideos101')
17:12:42 T:140272247281792 ERROR: Unable to open database: MyVideos100 [1049](Unknown database 'MyVideos100')
17:12:42 T:140272247281792 NOTICE: Old database found - updating from version 99 to 107
17:12:42 T:140272247281792 ERROR: SQL: Can't create database for copy: 'MyVideos99' (1007)
17:12:42 T:140272247281792 ERROR: Unable to copy old database MyVideos99 to new version MyVideos107
17:12:42 T:140272247281792 NOTICE: Running database version TV29

I'm running mysql 5.6.31 on Ubuntu 15.10. I verified that the offending column, userrating already exists in table seasons in the previous version of the database, MyVideos104. I will manually delete the column and see what other changes are required. I could then manually migrate MyVideos104 to MyVideos107. If it gets too much I'll figure out how to dump the schema in sqlite and then compare with the mysql database.