[mdh99]

So I updated to Kodi 16, over the top of Kodi 15.2, and I lose "Movies" and "TV Shows" from the home screen. They're not hidden, they're even greyed out in the "hide menu" options.

Install Kodi 15.2 over the top of 16 and they come back. Music library is okay.

Same issue on:
- Nexus 9(with skin; re-Touched),
- Nexus 5(with skin; re-Touched),
- Nexus Player(with skin; Arctic Zephyr) and my
- Windows 10 desktop(with skin; stock).

Only non-standard thing about my setup is run a central DB on my NAS, but that's setup as per the Kodi Wiki.

[scott967]

I'm guessing your database didn't update correctly. The Kodi 15 databases must still be there and working. I don't do mySQL so can't help on how to troubleshoot, but I suspect you need to drop the new databases and try again. Posting a debug log to pastebin or xbmclogs would probably help.

scott s.
.

[Derek]

At work i deal with big SQL databases and they dont take that long to re-initialise from scratch so maybe an option.

[mdh99]

Okay, so it should be safe to drop database "MyVideos99" and just re-launch Kodi 16?

Code:

13:34:21 T:9044  NOTICE: Running database version Addons20
13:34:21 T:9044  NOTICE: Running database version ViewModes6
13:34:21 T:9044  NOTICE: Running database version Textures13
13:34:21 T:9044  NOTICE: Running database version MyMusic56
13:34:21 T:9044  NOTICE: Attempting to update the database MyVideos99 from version 93 to 99
13:34:21 T:9044   ERROR: SQL: [MyVideos99] Undefined MySQL error: Code (1060)
                                            Query: ALTER TABLE movie ADD userrating integer
13:34:21 T:9044   ERROR: Exception updating database MyVideos99 from version 93 to 99
13:34:21 T:9044   ERROR: Error updating database MyVideos99 from version 93 to 99
13:34:21 T:9044   ERROR: Unable to open database: MyVideos98 [1049](Unknown database 'MyVideos98')
13:34:21 T:9044   ERROR: Unable to open database: MyVideos97 [1049](Unknown database 'MyVideos97')
13:34:21 T:9044   ERROR: Unable to open database: MyVideos96 [1049](Unknown database 'MyVideos96')
13:34:21 T:9044   ERROR: Unable to open database: MyVideos95 [1049](Unknown database 'MyVideos95')
13:34:21 T:9044   ERROR: Unable to open database: MyVideos94 [1049](Unknown database 'MyVideos94')
13:34:21 T:9044  NOTICE: Old database found - updating from version 93 to 99
13:34:21 T:9044   ERROR: SQL: Can't create database for copy: 'MyVideos93' (1007)
13:34:21 T:9044   ERROR: Unable to copy old database MyVideos93 to new version MyVideos99
13:34:21 T:9044  NOTICE: Running database version TV29
13:34:21 T:9044  NOTICE: Running database version Epg11

[Derek]

WO WO make sure you backup and make sure its safe i dont want a hit out on me

[mdh99]

Worked.

Manually dropped the Kodi 16 DB and relaunched Kodi 16.
Kodi looked to be frozen on the splash screen, but I just left it as the last line of the log was "NOTICE: Old database found - updating from version 93 to 99". Took about 10mins.

[Derek]

nice one

[mdh99]

Not sure where the bottleneck was; NAS was just slow to create the DB copy/upgrade.

[cheuk5]

How come missing
System>Settings>Music>Karaoke>"Enable Karaoke support"

[mdh99]

How come missing
System>Settings>Music>Karaoke>"Enable Karaoke support"

This isn't related to my post. I've change the title and marked it as solved.

However, "Karaoke support has been completely removed as it wasn’t functional" - https://kodi.tv/kodi-16-0-jarvis-mark-xvi/

[Derek]

Oh never noticed but i use that at new year sometimes

[scott967]

Not sure where the bottleneck was; NAS was just slow to create the DB copy/upgrade.

IIRC they put some sort of optimization code in the upgrade to the new database and that takes some time to run when the new db is initialized. I assume the new db performs better than the Kodi 15 one.

scott s.
.

[mdh99]

Not sure where the bottleneck was; NAS was just slow to create the DB copy/upgrade.

IIRC they put some sort of optimization code in the upgrade to the new database and that takes some time to run when the new db is initialized. I assume the new db performs better than the Kodi 15 one.

scott s.
.