[mwguthrie]

I recently migrated all of my media to a Synology NAS and I love it. Sharing my movies and TV shows throughout my network is working out great, I have MySQL centralizing my library, but I can't get my music to be populated in my library.

First I was fine with not having my music library on my HTPC but I'm having guests in a week and some tunes would be nice so I decided to get this figured out. The steps I took:

* Add a new source (SMB)

* Context menu on the new source -> Scan Item to Library

* It scans through my Music folder on the remote disc

* No effect, music library is completely empty, library mode view option is greyed out

* Go through and make sure ID tags aren't corrupted

* Try to add a specific album (navigate to the subfolder containing the mp3s -> Scan Item to Library)

* It doesn't work

* Starting to get upset

* Copy files to a local drive and try that instead of the NAS

* Add the new local source -> Scan Item to Library

* It doesn't work

* Pull out my hair

If anyone can help I would really appreciate it.


If it matters, I'm running Linux Mint 14 with Gotham

http://pastebin.com/QbMC5QqA log file if you're interested

[Aenima99x]

Here's your problem....drop the old MyMusic db's and you should be able to get it working

19:47:18 T:140592073111424 NOTICE: Attempting to update the database MyMusic46 from version 32 to 46
19:47:18 T:140592073111424 ERROR: SQL: Undefined MySQL error: Code (1060)
Query: ALTER TABLE artist ADD strMusicBrainzArtistID text
19:47:18 T:140592073111424 ERROR: Exception updating database MyMusic46 from version 32 to 46
19:47:18 T:140592073111424 ERROR: Error updating database MyMusic46 from version 32 to 46
19:47:19 T:140592073111424 NOTICE: Old database found - updating from version 32 to 46
19:47:19 T:140592073111424 ERROR: SQL: Can't create database for copy: 'MyMusic32' (1007)
19:47:19 T:140592073111424 ERROR: Unable to copy old database MyMusic32 to new version MyMusic46

[mwguthrie]

I deleted MyMusic*.db in ~/.xbmc/userdata/Database/ and tried to re-scrape the NAS but it doesn't seem to be fixing anything. Should I delete them on every computer connected to the network? Is there anything else I should delete?

[Ned Scott]

You have to delete it on the MySQL server. The local file isn't used anymore, hence the entire reason for using MySQL.

[mwguthrie]

Wow, that's embarrassing. Dropping the databases on the server worked perfectly.

Library is being populated with music right now. Thanks a lot for your help!