2012-10-19, 07:29
Okay I'm hoping this is a simple fix. I'm running the latest stable release of XBMC Eden on a Windows 7 x64 dedicated machine. The video library works fine, but the music one isn't cooperating. I can add the source, and scan the music into the library but I am unable to enable library mode. A quick look at the log with debugging turned on has a whole bunch of ERROR: SQL: The table does not exist. I have cleaned the table, deleted and readded the source, dropped the table from MySQL, let XBMC recreate it, and tried rescanning numerous times and it doesn't cooperate.
Log one: https://matthewh12.privatepaste.com/010bc4d88e
I found if I run this:
create view songview as select song.idSong as idSong, song.strExtraArtists as strExtraArtists, song.strExtraGenres as strExtraGenres, strTitle, iTrack, iDuration, song.iYear as iYear, dwFileNameCRC, strFileName, strMusicBrainzTrackID, strMusicBrainzArtistID, strMusicBrainzAlbumID, strMusicBrainzAlbumArtistID, strMusicBrainzTRMID, iTimesPlayed, iStartOffset, iEndOffset, lastplayed, rating, comment, song.idAlbum as idAlbum, strAlbum, strPath, song.idArtist as idArtist, strArtist, song.idGenre as idGenre, strGenre, strThumb, iKaraNumber, iKaraDelay, strKaraEncoding from song join album on song.idAlbum=album.idAlbum join path on song.idPath=path.idPath join artist on song.idArtist=artist.idArtist join genre on song.idGenre=genre.idGenre join thumb on song.idThumb=thumb.idThumb left outer join karaokedata on song.idSong=karaokedata.idSong;
Which I found in another thread, it will now scan and add the artists and allow me to turn on library mode. I can go into Artists but clicking them does nothing. Clicking Albums says: REMOTE SHARE: Path not found or invalid. I've checked, and verified that my music folders are accessible and readable just fine. I can go into file mode and play them without issue as well. Going to Songs works, and gives me a list of the songs scanned in so far. Years is broken, it shows a list but clicking them does nothing. Same with Top 100. Recently Added/Recently Played does the same as albums Path not found or invalid.
Log two: https://matthewh12.privatepaste.com/fdd7d4486d
Only thing I can think of is for some reason, something in MySQL isn't getting created properly, and I'm not sure how to manually create and/or fix it.
Thanks for any help you can provide!
--Matt
Log one: https://matthewh12.privatepaste.com/010bc4d88e
I found if I run this:
create view songview as select song.idSong as idSong, song.strExtraArtists as strExtraArtists, song.strExtraGenres as strExtraGenres, strTitle, iTrack, iDuration, song.iYear as iYear, dwFileNameCRC, strFileName, strMusicBrainzTrackID, strMusicBrainzArtistID, strMusicBrainzAlbumID, strMusicBrainzAlbumArtistID, strMusicBrainzTRMID, iTimesPlayed, iStartOffset, iEndOffset, lastplayed, rating, comment, song.idAlbum as idAlbum, strAlbum, strPath, song.idArtist as idArtist, strArtist, song.idGenre as idGenre, strGenre, strThumb, iKaraNumber, iKaraDelay, strKaraEncoding from song join album on song.idAlbum=album.idAlbum join path on song.idPath=path.idPath join artist on song.idArtist=artist.idArtist join genre on song.idGenre=genre.idGenre join thumb on song.idThumb=thumb.idThumb left outer join karaokedata on song.idSong=karaokedata.idSong;
Which I found in another thread, it will now scan and add the artists and allow me to turn on library mode. I can go into Artists but clicking them does nothing. Clicking Albums says: REMOTE SHARE: Path not found or invalid. I've checked, and verified that my music folders are accessible and readable just fine. I can go into file mode and play them without issue as well. Going to Songs works, and gives me a list of the songs scanned in so far. Years is broken, it shows a list but clicking them does nothing. Same with Top 100. Recently Added/Recently Played does the same as albums Path not found or invalid.
Log two: https://matthewh12.privatepaste.com/fdd7d4486d
Only thing I can think of is for some reason, something in MySQL isn't getting created properly, and I'm not sure how to manually create and/or fix it.
Thanks for any help you can provide!
--Matt