[woodjb]

Hello all,

Today I upgraded my XBMCbuntu (11.10) from Eden to Frodo. I was assured by various guides that my Video library would be imported, however it has not. I started by using aptitude to update, then rebooted the machine. Upon reboot, there were no "Movies" or "TV Shows" menu items. I am using samba shares and mysql. My music database shows up.

Code:

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| MyMusic18          |
| MyMusic30          |
| MyMusic32          |
| MyVideos60         |
| MyVideos74         |
| MyVideos75         |
| mysql              |
+--------------------+
8 rows in set (0.00 sec)

Code:

mysql> SHOW GRANTS FOR 'xbmc';
+--------------------------------------------------------------------------------------------------------------+
| Grants for xbmc@%                                                                                            |
+--------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'%' IDENTIFIED BY PASSWORD '*(REDACTED)' |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Code:

<advancedsettings>
  <useddsfanart>true</useddsfanart>
  <cputempcommand>cputemp</cputempcommand>
  <gputempcommand>gputemp</gputempcommand>
  <gui>
    <algorithmdirtyregions>1</algorithmdirtyregions>
    <visualizedirtyregions>false</visualizedirtyregions>
    <nofliptimeout>0</nofliptimeout>
  </gui>
  <samba>
    <clienttimeout>30</clienttimeout>
  </samba>
  <network>
    <disableipv6>true</disableipv6>
    <cachemembuffersize>134217728</cachemembuffersize>
  </network>
  <videodatabase>
    <type>mysql</type>
    <host>192.168.1.50</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>(REDACTED)</pass>
  </videodatabase>
  <musicdatabase>
    <type>mysql</type>
    <host>192.168.1.50</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>(REDACTED)</pass>
  </musicdatabase>
</advancedsettings>

Help?

[woodjb]

If I drop the newer tables, will XBMC try to re-import the next time I start it?

Edit: This actually solved it. I closed xbmc, dropped the newer databases, then re-opened xbmc. It took a bit longer to load, and successfully imported the old databases.

The problem seems to be caused by the fact that I tried connecting XBMC Frodo beta for Android to my central database, and I guess it failed to import the Videos database. Then when I updated my main box to Frodo, it tried to import from the app-created database.

Marking as solved.