2013-02-07, 01:42
Hi!
I've searched around the whole www with google for the last 4 h, but wasnt able to find a solution for my problem
Its late and i hope i didn't miss something, so please dont kill me if i was just to blind to see a already posted solution...
Setting:
XBMC (Frodo 12) on 3 diffrent machines, MYSQL Server on Win8 Machine.
Advancedsettings.xml:
Video Libary is working fantastic on all machines.
Problem: Audio Libary doesnt work at all!
no matter from which machine i scan music files into the database, the database still keeps empty.
NOT the "real" Mysql Table, there are all songs written from the scanning process, but in XBMC the Libary mode just dont apear.
here's my xbmc.log after the scanning process:
http://pastebin.com/hJr8gEkx
as you can see, the error seems to be in the lower part of the logfile, for example:
Thats just a small example, some more similar errors in the lower part of the logfile..
Here a picture from the Database-structure. Im a totally DB noob, but for me it seems that the "view"-tables which exist in the movie DB just doesn't exist in the Music DB. to be exact there is not even one single view table in the music DB. Maybee thats the problem?
Uploaded with ImageShack.us
here's what i already testet (with ZERO success):
- completly droped DB and let it reinstall from XBMC (at least 10 times!)
- tried this with and without <name> Tag for the Music-Libary in advancedsettings.xml
- restartet XBMC machine
- restarted Mysql server machine
- tried diffrent audio files
- Tried Frodo 12.0 final AND newest nightly build
When I switch from Mysql to local database, all works great, libary is working.
Video libary is working 100% perfekt and with no problems.
Can someone give me a hint what else I can try?
I guess there are some tables missing, so they are not installed right from XBMC to the db, but I dont know why..
greetings
johho
I've searched around the whole www with google for the last 4 h, but wasnt able to find a solution for my problem
Its late and i hope i didn't miss something, so please dont kill me if i was just to blind to see a already posted solution...
Setting:
XBMC (Frodo 12) on 3 diffrent machines, MYSQL Server on Win8 Machine.
Advancedsettings.xml:
Code:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.0.16</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_videos</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.0.16</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
</advancedsettings>
Video Libary is working fantastic on all machines.
Problem: Audio Libary doesnt work at all!
no matter from which machine i scan music files into the database, the database still keeps empty.
NOT the "real" Mysql Table, there are all songs written from the scanning process, but in XBMC the Libary mode just dont apear.
here's my xbmc.log after the scanning process:
http://pastebin.com/hJr8gEkx
as you can see, the error seems to be in the lower part of the logfile, for example:
Code:
00:00:41 T:4372 DEBUG: GetRecentlyAddedAlbumSongs() query: SELECT songview.* FROM (SELECT idAlbum FROM albumview ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum=recentalbums.idAlbum
00:00:41 T:4372 ERROR: SQL: The table does not exist
Query: SELECT songview.* FROM (SELECT idAlbum FROM albumview ORDER BY idAlbum DESC LIMIT 10) AS recentalbums JOIN songview ON songview.idAlbum=recentalbums.idAlbum
00:00:41 T:4372 ERROR: CMusicDatabase::GetRecentlyAddedAlbumSongs failed
Here a picture from the Database-structure. Im a totally DB noob, but for me it seems that the "view"-tables which exist in the movie DB just doesn't exist in the Music DB. to be exact there is not even one single view table in the music DB. Maybee thats the problem?
Uploaded with ImageShack.us
here's what i already testet (with ZERO success):
- completly droped DB and let it reinstall from XBMC (at least 10 times!)
- tried this with and without <name> Tag for the Music-Libary in advancedsettings.xml
- restartet XBMC machine
- restarted Mysql server machine
- tried diffrent audio files
- Tried Frodo 12.0 final AND newest nightly build
When I switch from Mysql to local database, all works great, libary is working.
Video libary is working 100% perfekt and with no problems.
Can someone give me a hint what else I can try?
I guess there are some tables missing, so they are not installed right from XBMC to the db, but I dont know why..
greetings
johho