2013-09-21, 07:14
Hi,
I'm using XBMC Frodo 12.2 on Windows 7 and planning on setting up a 2nd Windows machine. In prep for this, I thought I'd try changing my current install to use MySQL instead of local database.
After following the Wiki steps to create the xbmc user in MySQL and then configure the advancedsettings.xml I fired up XBMC and re-scanned my Video library (Movies and TV Shows) to let it create and populate the MySQL databases. So I now have a myvideos75 and mymusic32 schema in MySQL and if I dive into the various tables (e.g. Actors, genre, movie, etc.) in myvideos75 I can see them full of data so it looks like the library scan from XBMC has nicely populated the database (30 tables in the myvideos75 schema).
Where I'm having problems, is having XBMC actually read this data back. I'm getting nothing back in all library views (recent movies, movies-> titles, TV Shows-> titles, etc.)
Now, I've seen the banner on the Wiki advising users reporting issues with MySQL 5.6, and yes, as it happens, I'm using MySQL 5.6.13.
Are devs wanting debug logs for this issue for further investigation (which I can collect and post) or are these 'known issues' and I should sit and wait for an updated release of XBMC? Or try a specific monthly milestone build?
Thanks!
I'm using XBMC Frodo 12.2 on Windows 7 and planning on setting up a 2nd Windows machine. In prep for this, I thought I'd try changing my current install to use MySQL instead of local database.
After following the Wiki steps to create the xbmc user in MySQL and then configure the advancedsettings.xml I fired up XBMC and re-scanned my Video library (Movies and TV Shows) to let it create and populate the MySQL databases. So I now have a myvideos75 and mymusic32 schema in MySQL and if I dive into the various tables (e.g. Actors, genre, movie, etc.) in myvideos75 I can see them full of data so it looks like the library scan from XBMC has nicely populated the database (30 tables in the myvideos75 schema).
Where I'm having problems, is having XBMC actually read this data back. I'm getting nothing back in all library views (recent movies, movies-> titles, TV Shows-> titles, etc.)
Now, I've seen the banner on the Wiki advising users reporting issues with MySQL 5.6, and yes, as it happens, I'm using MySQL 5.6.13.
Are devs wanting debug logs for this issue for further investigation (which I can collect and post) or are these 'known issues' and I should sit and wait for an updated release of XBMC? Or try a specific monthly milestone build?
Thanks!