MySQL issues going from Frodo to Gotham
#1
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?
Reply
#2
Okay, so i added the Name tag and it works again. In order to get rid of the name tags (I read somewhere that they shouldn't be used anymore) should I just rename the two tables to the default MyVideos/MyMusic naming convention?
Reply
#3
There's no harm these days in using the name tag. There was an apparent bug for a while, but it doesn't seem to be an issue in v13. They're not required, of course (in which XBMC uses MyVideos/MyMusic as default names), but it won't hurt anything.
Reply

Logout Mark Read Team Forum Stats Members Help
MySQL issues going from Frodo to Gotham0