2014-06-22, 17:48
http://xbmclogs.com/show.php?id=232742
XBian Version 1.0RC2
XBMC 13.1 Git:20140604-84725b0 (Compiled Jun 10 2014)
2 Pi's @ Home - Both Pi's were initially XBian Beta 2 with Frodo, both configured with same sources.xml (2 NFS shares), and MySQL central DB - and both working great.
So I kept 1 running XBian Beta 2 (Frodo), and 2nd one I did a clean install of XBian 1.0 RC2 Gotham XBMC13
Inside MySQL I can see the new database have been created for Gotham and can see they have been populated with all the data from the Frodo databases, however there is no link on XBMC GUI to TV Series or Movies (i.e. no database stuff), I can only see Videos-> Files (will get hold of debug logs re this to see if any issues)
Playback - can browse via files and can play MKV files, but the stuttering on playback and audio crackling is horrible - the same files on the Beta 2 Pi (same network, same sources, same MySQL DB etc) all run perfectly - no stuttering, full 5.1 surround - perfect.
---------------------
That was the initial issues I had with the 2nd Pi. Since then I resolved the stuttering / crackling sound by dropping the Audio to HMDI 2.0 channel (2.1 or anything above and I got horrible sound)
MySQL issues:
Still can't see anything in the databases tho, even although on MySQL I can see:
xbmc_music46
xbmc_video78
The debug log has:
22:29:23 T:3039572512 NOTICE: Running database version Addons16
22:29:23 T:3039572512 NOTICE: Running database version ViewModes6
22:29:23 T:3039572512 NOTICE: Running database version Textures13
22:29:27 T:3039572512 NOTICE: Attempting to update the database xbmc_music46 from version 32 to 46
22:29:28 T:3039572512 ERROR: SQL: Undefined MySQL error: Code (1060)
Query: ALTER TABLE artist ADD strMusicBrainzArtistID text
22:29:28 T:3039572512 ERROR: Exception updating database xbmc_music46 from version 32 to 46
22:29:28 T:3039572512 ERROR: Error updating database xbmc_music46 from version 32 to 46
...
...
22:29:29 T:3039572512 NOTICE: Old database found - updating from version 32 to 46
22:29:29 T:3039572512 ERROR: SQL: Can't create database for copy: 'xbmc_music32' (1007)
But when I look at the tables themselves, I can see that the column strMusicBrainzArtistID (text) already exists.
-----------
So, as a test, I dropped the 2 databases, and rebooted the Pi. I can see the database xbmc_music46 get created and populated from 32, and xbmc_video78 gets created and populated from 75
What I have spotted however, is that the VIEWS are not copied over, so further down the error log you get:
11:34:33 T:2895873088 ERROR: SQL: The table does not exist
Query: select * from movieview ORDER BY dateAdded desc, idMovie desc LIMIT 10
In Music32, there are 3 Views: albumview, artistview, songview - not recreated in Music46
In Video75, there are 4 Views: episodeview, movieview, musicvideoview, tvshowview - not recreated in Video78
Its not a permissions issue as the MySQL user-id XBMC has full access.
Also spotted none of the triggers are in place either...
-----------
I manually recreated the views in Video, and those errors re the views have disappeared, but still the Movies and TV Series won't show on front menu (running default Confluence for now)
XBian Version 1.0RC2
XBMC 13.1 Git:20140604-84725b0 (Compiled Jun 10 2014)
2 Pi's @ Home - Both Pi's were initially XBian Beta 2 with Frodo, both configured with same sources.xml (2 NFS shares), and MySQL central DB - and both working great.
So I kept 1 running XBian Beta 2 (Frodo), and 2nd one I did a clean install of XBian 1.0 RC2 Gotham XBMC13
Inside MySQL I can see the new database have been created for Gotham and can see they have been populated with all the data from the Frodo databases, however there is no link on XBMC GUI to TV Series or Movies (i.e. no database stuff), I can only see Videos-> Files (will get hold of debug logs re this to see if any issues)
Playback - can browse via files and can play MKV files, but the stuttering on playback and audio crackling is horrible - the same files on the Beta 2 Pi (same network, same sources, same MySQL DB etc) all run perfectly - no stuttering, full 5.1 surround - perfect.
---------------------
That was the initial issues I had with the 2nd Pi. Since then I resolved the stuttering / crackling sound by dropping the Audio to HMDI 2.0 channel (2.1 or anything above and I got horrible sound)
MySQL issues:
Still can't see anything in the databases tho, even although on MySQL I can see:
xbmc_music46
xbmc_video78
The debug log has:
22:29:23 T:3039572512 NOTICE: Running database version Addons16
22:29:23 T:3039572512 NOTICE: Running database version ViewModes6
22:29:23 T:3039572512 NOTICE: Running database version Textures13
22:29:27 T:3039572512 NOTICE: Attempting to update the database xbmc_music46 from version 32 to 46
22:29:28 T:3039572512 ERROR: SQL: Undefined MySQL error: Code (1060)
Query: ALTER TABLE artist ADD strMusicBrainzArtistID text
22:29:28 T:3039572512 ERROR: Exception updating database xbmc_music46 from version 32 to 46
22:29:28 T:3039572512 ERROR: Error updating database xbmc_music46 from version 32 to 46
...
...
22:29:29 T:3039572512 NOTICE: Old database found - updating from version 32 to 46
22:29:29 T:3039572512 ERROR: SQL: Can't create database for copy: 'xbmc_music32' (1007)
But when I look at the tables themselves, I can see that the column strMusicBrainzArtistID (text) already exists.
-----------
So, as a test, I dropped the 2 databases, and rebooted the Pi. I can see the database xbmc_music46 get created and populated from 32, and xbmc_video78 gets created and populated from 75
What I have spotted however, is that the VIEWS are not copied over, so further down the error log you get:
11:34:33 T:2895873088 ERROR: SQL: The table does not exist
Query: select * from movieview ORDER BY dateAdded desc, idMovie desc LIMIT 10
In Music32, there are 3 Views: albumview, artistview, songview - not recreated in Music46
In Video75, there are 4 Views: episodeview, movieview, musicvideoview, tvshowview - not recreated in Video78
Its not a permissions issue as the MySQL user-id XBMC has full access.
Also spotted none of the triggers are in place either...
-----------
I manually recreated the views in Video, and those errors re the views have disappeared, but still the Movies and TV Series won't show on front menu (running default Confluence for now)