Not sure if this is XBian or XBMC issue?
#1
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)
QNAP TS670 NAS - 4x4TB Raided with NFS Support & Central MySQL DB
Pi 3 [Xbian] - Samsung 46" ES7000 Smart TV & HT-E5550 3D BD Sound System
Pi 3 [Xbian]  + Hyperion Ambilight- Samsung 48" Curved UE48JS9000 4k
PowerEthernet T1502 Powerline adapters
Reply
#2
(2014-06-22, 17:48)nsviper Wrote: 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.

Quote:16:33:38 T:3039502880 NOTICE: Raspberry PI firmware version: Mar 19 2014 23:26:47

This is too old and probably responsible for bad audio. Make sure firmware is always updated when moving to a newer xbmc version.
Reply
#3
The audio issue is gone, its the SQL Library stuff i'm more interested in...
QNAP TS670 NAS - 4x4TB Raided with NFS Support & Central MySQL DB
Pi 3 [Xbian] - Samsung 46" ES7000 Smart TV & HT-E5550 3D BD Sound System
Pi 3 [Xbian]  + Hyperion Ambilight- Samsung 48" Curved UE48JS9000 4k
PowerEthernet T1502 Powerline adapters
Reply

Logout Mark Read Team Forum Stats Members Help
Not sure if this is XBian or XBMC issue?0