2010-01-09, 11:33
According to the HTTP API docs at http://wiki.xbmc.org/?title=WebServe...ve_Information
there is a command called "querymusicdatabase"
When I run this command to "select * from genre" in my browser it returns only one genre... "karaoke" of all things:
Can anybody else confirm this behavior? You can look at the data in your sqllite database by installing this sqlite program: http://sqlitebrowser.sourceforge.net/
After you install it, open the file:
C:\Users\<username>\AppData\Roaming\xbmc\userdata \profiles\<xbmcuser>\Database\MyMusic7.db
Please tell me what you find in your database tables? Especially the "genre" table.
From what I can tell, this database is completely empty!
After more research, C:\Users\<username>\AppData\Roaming\xbmc\userdata\Database\xbmc_catalog.db
So, it seems there is a bug in the xbmc code.... the querymusicdatabase command is using the incorrect db file.
Should I log this as a bug?
there is a command called "querymusicdatabase"
When I run this command to "select * from genre" in my browser it returns only one genre... "karaoke" of all things:
Code:
10.168.1.25:8800/xbmcCmds/xbmcHttp?command=querymusicdatabase%28select%20*%20from%20genre%29
Can anybody else confirm this behavior? You can look at the data in your sqllite database by installing this sqlite program: http://sqlitebrowser.sourceforge.net/
After you install it, open the file:
C:\Users\<username>\AppData\Roaming\xbmc\userdata \profiles\<xbmcuser>\Database\MyMusic7.db
Please tell me what you find in your database tables? Especially the "genre" table.
From what I can tell, this database is completely empty!
After more research, C:\Users\<username>\AppData\Roaming\xbmc\userdata\Database\xbmc_catalog.db
So, it seems there is a bug in the xbmc code.... the querymusicdatabase command is using the incorrect db file.
Should I log this as a bug?