Login at Kodi Home

mwkurt · 2013-05-14, 01:41

Hello,

Windows 7, Eden to Frodo 12.2, Using mySQL DB on a remote server.

I need some help updating to Frodo from Eden. This is using 12.2 over Eden. With Eden, I had all of my movies and TV Shows working fine. If I selected Movies from the Home Screen bar, my movies were shown, the same with TV Shows.

Eden Log File: http://pastebin.com/q4q9jbTA

After installing Frodo 12.2 overtop of Eden, I do not have any movies or TV shows visible. The home screen bar does not have the Movies or TV Shows entries. I know the DB's were created on my server as I can see MyMusic32 and MyVideos75 Databases using HeidiSQL. Looking at the data inside the db, all TVShow and movie information is listed. The DB's look good.

Frodo Log File: http://pastebin.com/yVTETr4L

Can anyone guide me through, help me out or point me in the right direction? I have read all of the information that I thought was relevant, to no avail.

Thanks,
Mark

mwkurt · 2013-05-14, 12:18

Really? No one can look at my logs and try to help me out? Bump.

**Martijn** · 2013-05-14, 12:38

http://wiki.xbmc.org/index.php?title=For...al_conduct nr.6

mwkurt · 2013-05-14, 16:57

Yeah....sorry for being a bit impatient. I have been trying to get Frodo working for 2 days now and am about at my wits end.

Once again sorry.

Mark

saitoh183 · 2013-05-14, 17:33

Dont think your migration worked well

Code:
20:38 T:4504   DEBUG: Mysql execute: CREATE TABLE seasons ( idSeason integer primary key auto_increment , idShow integer, season integer) CHARACTER SET utf8 COLLATE utf8_general_ci

20:38 T:4504   ERROR: SQL: Undefined MySQL error: Code (1050)

                                            Query: CREATE TABLE seasons ( idSeason integer primary key auto_increment , idShow integer, season integer) CHARACTER SET utf8 COLLATE utf8_general_ci

20:38 T:4504   ERROR: Exception updating database MyVideos75 from version 60 to 75

20:38 T:4504   ERROR: Error updating database MyVideos75 from version 60 to 75

20:38 T:4504   DEBUG: Mysql rollback transaction

I would just export my DB from Eden and import it into a fresh DB in Frodo

mwkurt · 2013-05-14, 20:28

Thanks for helping saitoh183.

That brings up another problem I have. I tried exporting from Eden, first into a single file. I pointed Frodo to the exported DB (from within Frodo where it says "Import database" in settings). Frodo did not see the xml file so it wouldn't do the import. I tried exporting to "Multiple files", but that just goes and exports the nfos, images and such back into the folders that contain the movies...right? From there how do I import? I am lost?

Thanks,
Mark

P.S. the thing is, MyVideos75 was created and filled with all of my tvshow and movie information. Yet, Frodo can't see it or use it? I don't get it.

saitoh183 · 2013-05-14, 20:51

Start fresh (drop the current MyVideos75)Export Multiple Files in Eden

before scanning in your data ,in your advancedsettings.xml add

Code:
<videolibrary>

        <importwatchedstate>true</importwatchedstate>

        <importresumepoint>true</importresumepoint>

    </videolibrary>

Then Update library and it will put everything back

mwkurt · (This post was last modified: 2013-05-15, 12:05 by mwkurt.)

Tried this, didn't work. But did create and fill myvideos75 and my music32.

Looks like, according to my log file, Frodo can not connect to my mysql database: http://pastebin.com/K3ceweqx

Nothing has changed and in fact Dharma and Eden both have no problem connecting.

Hopefully someone can come up with something I am not doing or doing right?

Thanks again,
Mark

saitoh183 · 2013-05-15, 04:30

your link doesnt wok

mwkurt · 2013-05-15, 12:06

Fixed it..sorry

saitoh183 · 2013-05-15, 15:53

Code:
28:54 T:1112  NOTICE: Attempting to update the database MyMusic32 from version 18 to 32

28:54 T:1112   ERROR: SQL: Undefined MySQL error: Code (1050)

                                            Query: CREATE TABLE album_artist ( idArtist integer, idAlbum integer, boolFeatured integer, iOrder integer )

                                             CHARACTER SET utf8 COLLATE utf8_general_ci

28:54 T:1112   ERROR: Exception updating database MyMusic32 from version 18 to 32

28:54 T:1112   ERROR: Error updating database MyMusic32 from version 18 to 32

28:54 T:1112   ERROR: Unable to open database: MyMusic31 [1049](Unknown database 'mymusic31')

28:54 T:1112   ERROR: Unable to open database: MyMusic30 [1049](Unknown database 'mymusic30')

28:54 T:1112   ERROR: Unable to open database: MyMusic29 [1049](Unknown database 'mymusic29')

28:54 T:1112   ERROR: Unable to open database: MyMusic28 [1049](Unknown database 'mymusic28')

28:54 T:1112   ERROR: Unable to open database: MyMusic27 [1049](Unknown database 'mymusic27')

28:54 T:1112   ERROR: Unable to open database: MyMusic26 [1049](Unknown database 'mymusic26')

28:54 T:1112   ERROR: Unable to open database: MyMusic25 [1049](Unknown database 'mymusic25')

28:54 T:1112   ERROR: Unable to open database: MyMusic24 [1049](Unknown database 'mymusic24')

28:54 T:1112   ERROR: Unable to open database: MyMusic23 [1049](Unknown database 'mymusic23')

28:54 T:1112   ERROR: Unable to open database: MyMusic22 [1049](Unknown database 'mymusic22')

28:54 T:1112   ERROR: Unable to open database: MyMusic21 [1049](Unknown database 'mymusic21')

28:54 T:1112   ERROR: Unable to open database: MyMusic20 [1049](Unknown database 'mymusic20')

28:54 T:1112   ERROR: Unable to open database: MyMusic19 [1049](Unknown database 'mymusic19')

28:54 T:1112  NOTICE: Old database found - updating from version 18 to 32

28:54 T:1112   ERROR: SQL: Can't create database for copy: 'MyMusic18' (1007)

28:54 T:1112   ERROR: Unable to copy old database MyMusic18 to new version MyMusic32

28:54 T:1112  NOTICE: Attempting to update the database MyVideos75 from version 60 to 75

28:54 T:1112   ERROR: SQL: Undefined MySQL error: Code (1060)

                                            Query: ALTER TABLE path ADD dateAdded text

28:54 T:1112   ERROR: Exception updating database MyVideos75 from version 60 to 75

28:54 T:1112   ERROR: Error updating database MyVideos75 from version 60 to 75

28:54 T:1112   ERROR: Unable to open database: MyVideos74 [1049](Unknown database 'myvideos74')

28:54 T:1112   ERROR: Unable to open database: MyVideos73 [1049](Unknown database 'myvideos73')

28:54 T:1112   ERROR: Unable to open database: MyVideos72 [1049](Unknown database 'myvideos72')

28:54 T:1112   ERROR: Unable to open database: MyVideos71 [1049](Unknown database 'myvideos71')

28:54 T:1112   ERROR: Unable to open database: MyVideos70 [1049](Unknown database 'myvideos70')

28:54 T:1112   ERROR: Unable to open database: MyVideos69 [1049](Unknown database 'myvideos69')

28:54 T:1112   ERROR: Unable to open database: MyVideos68 [1049](Unknown database 'myvideos68')

28:54 T:1112   ERROR: Unable to open database: MyVideos67 [1049](Unknown database 'myvideos67')

28:54 T:1112   ERROR: Unable to open database: MyVideos66 [1049](Unknown database 'myvideos66')

28:54 T:1112   ERROR: Unable to open database: MyVideos65 [1049](Unknown database 'myvideos65')

28:54 T:1112   ERROR: Unable to open database: MyVideos64 [1049](Unknown database 'myvideos64')

28:54 T:1112   ERROR: Unable to open database: MyVideos63 [1049](Unknown database 'myvideos63')

28:54 T:1112   ERROR: Unable to open database: MyVideos62 [1049](Unknown database 'myvideos62')

28:54 T:1112   ERROR: Unable to open database: MyVideos61 [1049](Unknown database 'myvideos61')

28:54 T:1112  NOTICE: Old database found - updating from version 60 to 75

28:54 T:1112   ERROR: SQL: Can't create database for copy: 'MyVideos60' (1007)

28:54 T:1112   ERROR: Unable to copy old database MyVideos60 to new version MyVideos75

What version of Mysql you using?

mwkurt · 2013-05-15, 21:23

MySQL 5.1

Does that make a difference to Frodo?

Thanks,
Mark

saitoh183 · 2013-05-15, 22:11

try 5.5