Login at Kodi Home

Ryuuji · (This post was last modified: 2014-12-24, 02:05 by Ryuuji.)

I also have a similar problem. The only library that was imported was my music library. My TV-Show and Movie library was not imported, even trough everything went smooth with the installation. I'm using mysql sharing for the databases. My other xbmc clients running 13.2 still work and can add new videos. I could guess that kodi updates my video libary, but I don't see a progress bar that it is doing so, also my music library was just like that added (boot up kodi for the first time, my music library is there)

Ryuuji · (This post was last modified: 2014-12-24, 02:20 by Ryuuji.)

What do you mean by copy the userdata folder manually? my Kodi installation has the same Databases as my XBMC installations and I also tried it already to just copy/past my userdata folder from my xbmc 13.2 instalations, but it didn't fix it. However my sources where imported, I can see under videos/files all of my video locations but not my video libarys, also they have no contend stetted. I think this is the problem Kodi looses the contend settings like Movies, tv-shows, music videos etc.

Also under Mysql the new libary is showing "myvideos90 and mymusic48"

Jogee · 2014-12-24, 15:19

If you have your library in a mysql database, you're not the first one I read having that problem. Maybe this post will help you.

Be sure you have a backup first, though.

~~Ned Scott~~ · 2014-12-24, 15:47

(2014-12-24, 15:19)Jogee Wrote: If you have your library in a mysql database, you're not the first one I read having that problem. Maybe this post will help you.

Be sure you have a backup first, though.

The presence of older databases shouldn't have any impact on this.

~~Ned Scott~~ · 2014-12-24, 15:49

I've split the thread because Ryuuji clearly has a different issue than FRESH.

guido66 · 2014-12-24, 16:15

Same problem here, mysql music library is fine, movie library is empty. After manually removing the video library, kodi will not fill a new one. Problem is the same on windows and ATV2.

Ryuuji · (This post was last modified: 2014-12-24, 19:37 by Ryuuji.)

Unfortunately I can't test more till Monday because I'm not at home right now.

Thank you Ned Scott for splitting the thread. I thought it would be the same/ a similar problem.

@guido66
Also I'm happy to not be the only one with the problem.

@ Jogee.
I read the linked thread, but I also think that the old databases have no influence with this. I have 5 music and video librarys in mysql because of my long term use of xbmc since before frodo and never had a problem. the newer Xbmc version would just upgrade the librarys to the next number and it went without problems till now.

Ryuuji · (This post was last modified: 2014-12-27, 14:34 by Ryuuji.)

Does anyone know something else?

guido66 · (This post was last modified: 2014-12-27, 16:14 by guido66.)

What I have found out so far:

Kodi will not recognise the contents of the myvideos78 database from version 13.1 (in my case), it falsely reports it's empty:

14:49:07 T:4248 NOTICE: Running database version MyMusic48
14:49:07 T:4248 ERROR: Unable to open database: MyVideos90 [1049](Unknown database 'myvideos90')
14:49:07 T:4248 ERROR: Unable to open database: MyVideos89 [1049](Unknown database 'myvideos89')
14:49:07 T:4248 ERROR: Unable to open database: MyVideos88 [1049](Unknown database 'myvideos88')
14:49:07 T:4248 ERROR: Unable to open database: MyVideos87 [1049](Unknown database 'myvideos87')
14:49:07 T:4248 ERROR: Unable to open database: MyVideos86 [1049](Unknown database 'myvideos86')
14:49:07 T:4248 ERROR: Unable to open database: MyVideos85 [1049](Unknown database 'myvideos85')
14:49:07 T:4248 ERROR: Unable to open database: MyVideos84 [1049](Unknown database 'myvideos84')
14:49:07 T:4248 ERROR: Unable to open database: MyVideos83 [1049](Unknown database 'myvideos83')
14:49:07 T:4248 ERROR: Unable to open database: MyVideos82 [1049](Unknown database 'myvideos82')
14:49:07 T:4248 ERROR: Unable to open database: MyVideos81 [1049](Unknown database 'myvideos81')
14:49:07 T:4248 ERROR: Unable to open database: MyVideos80 [1049](Unknown database 'myvideos80')
14:49:07 T:4248 ERROR: Unable to open database: MyVideos79 [1049](Unknown database 'myvideos79')
14:49:07 T:4248 NOTICE: Old database found - updating from version 78 to 90
14:49:07 T:4248 ERROR: SQL: The source database was unexpectedly empty.
14:49:07 T:4248 ERROR: Unable to copy old database MyVideos78 to new version MyVideos90

So I removed myvideos78 folder and tried to create a new library from scratch:

14:55:08 T:4228 NOTICE: Running database version MyMusic48
14:55:08 T:4228 ERROR: Unable to open database: MyVideos90 [1049](Unknown database 'myvideos90')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos89 [1049](Unknown database 'myvideos89')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos88 [1049](Unknown database 'myvideos88')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos87 [1049](Unknown database 'myvideos87')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos86 [1049](Unknown database 'myvideos86')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos85 [1049](Unknown database 'myvideos85')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos84 [1049](Unknown database 'myvideos84')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos83 [1049](Unknown database 'myvideos83')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos82 [1049](Unknown database 'myvideos82')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos81 [1049](Unknown database 'myvideos81')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos80 [1049](Unknown database 'myvideos80')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos79 [1049](Unknown database 'myvideos79')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos78 [1049](Unknown database 'myvideos78')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos77 [1049](Unknown database 'myvideos77')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos76 [1049](Unknown database 'myvideos76')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos75 [1049](Unknown database 'myvideos75')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos74 [1049](Unknown database 'myvideos74')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos73 [1049](Unknown database 'myvideos73')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos72 [1049](Unknown database 'myvideos72')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos71 [1049](Unknown database 'myvideos71')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos70 [1049](Unknown database 'myvideos70')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos69 [1049](Unknown database 'myvideos69')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos68 [1049](Unknown database 'myvideos68')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos67 [1049](Unknown database 'myvideos67')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos66 [1049](Unknown database 'myvideos66')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos65 [1049](Unknown database 'myvideos65')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos64 [1049](Unknown database 'myvideos64')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos63 [1049](Unknown database 'myvideos63')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos62 [1049](Unknown database 'myvideos62')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos61 [1049](Unknown database 'myvideos61')
14:55:08 T:4228 ERROR: Unable to open database: MyVideos60 [1049](Unknown database 'myvideos60')
14:55:08 T:4228 ERROR: SQL: Undefined MySQL error: Code (1050)
Query: CREATE TABLE version (idVersion integer, iCompressCount integer)
CHARACTER SET utf8 COLLATE utf8_general_ci
14:55:08 T:4228 ERROR: CDatabase::CreateDatabase unable to create database:0

So, there is an error with MySQL. Since the music library is fine I don't think the error is caused by mysql.

A slight correction:

The old myvideos78 was indeed empty. So I placed the old one back and tried again:

15:10:45 T:7640 NOTICE: Old database found - updating from version 78 to 90
15:10:45 T:7640 ERROR: Unable to copy old database MyVideos78 to new version MyVideos90

So Kodi will not read the old video database and it will not create a new one from scratch.

guido66 · 2014-12-27, 17:31

I have more than one path to videos. Could this be the cause of my problem?

Like mentioned in this thread: http://forum.kodi.tv/showthread.php?tid=210661

Ryuuji · 2014-12-27, 19:36

I also have multiple video sources. Also my Files are hosted on a WHS 2011 over smb shares. When I'm back home on Monday I will test the new nightlys and install them.

guido66 · 2014-12-27, 21:23

Same setup here, WHS2011 and smb shares.

I tried 2 things:

1: I removed al but one video sources and tried to create a new library. No luck for me
2: I installed the latest nightly, still didn't work for me

guido66 · 2014-12-28, 12:53

Things are going from bad to terrible.

Kodi now constanly crashes on startup on my iPad and atv2.

The same happens on my windows 8.1 pc's. The only way I can get it working there is stop mysql, remove myvideos90 folder and restart mysql every single time!

Wish I could go back to 13.1 or 13.2, but I cannot find them.

**Martijn** · 2014-12-28, 12:58

get us crashlogs so devs can look at it. "it crashes" doesn't tell us anything

guido66 · (This post was last modified: 2014-12-28, 13:07 by Martijn.)

This is from one of the windows 8.1 installs, when trying to start kodi with myvideos90 in place: