2014-09-27, 09:58
I'm trying to upgrade my MySQL library going from Frodo 12.0 to Gotham 13.2
The PC with newly installed Gotham creates the myvideos78 and mymusic46 tables but they are empty and Movies and Tv Shows doesn't shop in the in menu in XBMC. I tried dropping the tables in MySQL as per: http://wiki.xbmc.org/index.php?title=MyS...ading_XBMC (Method 2), and XBMC creates them again but keeps them empty.
Advanced settings:
<videodatabase>
<type>mysql</type>
<host>192.168.1.101</host>
<port>3306</port>
<user>xbmcadmin</user>
<pass>pass</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.101</host>
<port>3306</port>
<user>xbmcadmin</user>
<pass>pass</pass>
</musicdatabase>
<videolibrary>
<dateadded>0</dateadded>
</videolibrary>
I used to have a Name tag in the libraries, but removed these. Can this cause the issues?
errors in log:
08:33:17 T:140520209147712 NOTICE: Running database version Addons16
08:33:17 T:140520209147712 NOTICE: Running database version ViewModes6
08:33:17 T:140520209147712 NOTICE: Running database version Textures13
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic46 [1049](Unknown database 'mymusic46')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic45 [1049](Unknown database 'mymusic45')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic44 [1049](Unknown database 'mymusic44')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic43 [1049](Unknown database 'mymusic43')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic42 [1049](Unknown database 'mymusic42')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic41 [1049](Unknown database 'mymusic41')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic40 [1049](Unknown database 'mymusic40')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic39 [1049](Unknown database 'mymusic39')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic38 [1049](Unknown database 'mymusic38')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic37 [1049](Unknown database 'mymusic37')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic36 [1049](Unknown database 'mymusic36')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic35 [1049](Unknown database 'mymusic35')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic34 [1049](Unknown database 'mymusic34')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic33 [1049](Unknown database 'mymusic33')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic32 [1049](Unknown database 'mymusic32')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic31 [1049](Unknown database 'mymusic31')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic30 [1049](Unknown database 'mymusic30')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic29 [1049](Unknown database 'mymusic29')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic28 [1049](Unknown database 'mymusic28')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic27 [1049](Unknown database 'mymusic27')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic26 [1049](Unknown database 'mymusic26')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic25 [1049](Unknown database 'mymusic25')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic24 [1049](Unknown database 'mymusic24')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic23 [1049](Unknown database 'mymusic23')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic22 [1049](Unknown database 'mymusic22')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic21 [1049](Unknown database 'mymusic21')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic20 [1049](Unknown database 'mymusic20')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic19 [1049](Unknown database 'mymusic19')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic18 [1049](Unknown database 'mymusic18')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos78 [1049](Unknown database 'myvideos78')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos77 [1049](Unknown database 'myvideos77')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos76 [1049](Unknown database 'myvideos76')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos75 [1049](Unknown database 'myvideos75')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos74 [1049](Unknown database 'myvideos74')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos73 [1049](Unknown database 'myvideos73')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos72 [1049](Unknown database 'myvideos72')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos71 [1049](Unknown database 'myvideos71')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos70 [1049](Unknown database 'myvideos70')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos69 [1049](Unknown database 'myvideos69')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos68 [1049](Unknown database 'myvideos68')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos67 [1049](Unknown database 'myvideos67')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos66 [1049](Unknown database 'myvideos66')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos65 [1049](Unknown database 'myvideos65')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos64 [1049](Unknown database 'myvideos64')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos63 [1049](Unknown database 'myvideos63')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos62 [1049](Unknown database 'myvideos62')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos61 [1049](Unknown database 'myvideos61')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos60 [1049](Unknown database 'myvideos60')
08:33:50 T:140520209147712 NOTICE: Running database version TV22
08:33:50 T:140520209147712 NOTICE: Running database version Epg7
What can I do to get a successful upgrade of my library?
The PC with newly installed Gotham creates the myvideos78 and mymusic46 tables but they are empty and Movies and Tv Shows doesn't shop in the in menu in XBMC. I tried dropping the tables in MySQL as per: http://wiki.xbmc.org/index.php?title=MyS...ading_XBMC (Method 2), and XBMC creates them again but keeps them empty.
Advanced settings:
<videodatabase>
<type>mysql</type>
<host>192.168.1.101</host>
<port>3306</port>
<user>xbmcadmin</user>
<pass>pass</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.101</host>
<port>3306</port>
<user>xbmcadmin</user>
<pass>pass</pass>
</musicdatabase>
<videolibrary>
<dateadded>0</dateadded>
</videolibrary>
I used to have a Name tag in the libraries, but removed these. Can this cause the issues?
errors in log:
08:33:17 T:140520209147712 NOTICE: Running database version Addons16
08:33:17 T:140520209147712 NOTICE: Running database version ViewModes6
08:33:17 T:140520209147712 NOTICE: Running database version Textures13
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic46 [1049](Unknown database 'mymusic46')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic45 [1049](Unknown database 'mymusic45')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic44 [1049](Unknown database 'mymusic44')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic43 [1049](Unknown database 'mymusic43')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic42 [1049](Unknown database 'mymusic42')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic41 [1049](Unknown database 'mymusic41')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic40 [1049](Unknown database 'mymusic40')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic39 [1049](Unknown database 'mymusic39')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic38 [1049](Unknown database 'mymusic38')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic37 [1049](Unknown database 'mymusic37')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic36 [1049](Unknown database 'mymusic36')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic35 [1049](Unknown database 'mymusic35')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic34 [1049](Unknown database 'mymusic34')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic33 [1049](Unknown database 'mymusic33')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic32 [1049](Unknown database 'mymusic32')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic31 [1049](Unknown database 'mymusic31')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic30 [1049](Unknown database 'mymusic30')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic29 [1049](Unknown database 'mymusic29')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic28 [1049](Unknown database 'mymusic28')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic27 [1049](Unknown database 'mymusic27')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic26 [1049](Unknown database 'mymusic26')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic25 [1049](Unknown database 'mymusic25')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic24 [1049](Unknown database 'mymusic24')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic23 [1049](Unknown database 'mymusic23')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic22 [1049](Unknown database 'mymusic22')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic21 [1049](Unknown database 'mymusic21')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic20 [1049](Unknown database 'mymusic20')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic19 [1049](Unknown database 'mymusic19')
08:33:17 T:140520209147712 ERROR: Unable to open database: MyMusic18 [1049](Unknown database 'mymusic18')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos78 [1049](Unknown database 'myvideos78')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos77 [1049](Unknown database 'myvideos77')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos76 [1049](Unknown database 'myvideos76')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos75 [1049](Unknown database 'myvideos75')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos74 [1049](Unknown database 'myvideos74')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos73 [1049](Unknown database 'myvideos73')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos72 [1049](Unknown database 'myvideos72')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos71 [1049](Unknown database 'myvideos71')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos70 [1049](Unknown database 'myvideos70')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos69 [1049](Unknown database 'myvideos69')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos68 [1049](Unknown database 'myvideos68')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos67 [1049](Unknown database 'myvideos67')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos66 [1049](Unknown database 'myvideos66')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos65 [1049](Unknown database 'myvideos65')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos64 [1049](Unknown database 'myvideos64')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos63 [1049](Unknown database 'myvideos63')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos62 [1049](Unknown database 'myvideos62')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos61 [1049](Unknown database 'myvideos61')
08:33:26 T:140520209147712 ERROR: Unable to open database: MyVideos60 [1049](Unknown database 'myvideos60')
08:33:50 T:140520209147712 NOTICE: Running database version TV22
08:33:50 T:140520209147712 NOTICE: Running database version Epg7
What can I do to get a successful upgrade of my library?