Announcement

Collapse
No announcement yet.

Error when listening to radio stations

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error when listening to radio stations

    Hi,

    I get this error when listening to radiostations:
    okt-31 17:35:15 Sonos Error Type = Learned
    okt-31 17:35:15 Sonos Error MetaData = P7 Klemobject.item.audioItem.audioBroadcastSA_RINCON65031_
    okt-31 17:35:15 Sonos Error URI = x-sonosapi-stream:s129804?sid=254&flags=8224&sn=0
    okt-31 17:35:15 Sonos Error Name = Learned - P7 Klem
    okt-31 17:35:15 Sonos Error UpdateRadioStationsInfo unable write this record for zoneplayer = Loftstue with error - SQL logic error or missing database no such table: RadioStations
    okt-31 17:35:05 Sonos Error Type = Learned
    okt-31 17:35:05 Sonos Error MetaData = P7 Klemobject.item.audioItem.audioBroadcastSA_RINCON65031_
    okt-31 17:35:05 Sonos Error URI = x-sonosapi-stream:s129804?sid=254&flags=8224&sn=0
    okt-31 17:35:05 Sonos Error Name = Learned - P7 Klem
    okt-31 17:35:05 Sonos Error UpdateRadioStationsInfo unable write this record for zoneplayer = Loftstue with error - SQL logic error or missing database no such table: RadioStations
    Anyone know why?

  • #2
    Also get these errors when trying to BuildDB:
    okt-31 17:48:47 Sonos Error ParentID = FV:2
    okt-31 17:48:47 Sonos Error Id = FV:2/2
    okt-31 17:48:47 Sonos Error URI = x-sonosapi-stream:s129804?sid=254&flags=8224&sn=0
    okt-31 17:48:47 Sonos Error Artist = P7 Klem
    okt-31 17:48:47 Sonos Error Album =
    okt-31 17:48:47 Sonos Error Name = Favorites
    okt-31 17:48:47 Sonos Error BuildSpecificObjectDB unable write this record for zoneplayer = Kjøkken with ObjectDBName = Favorites and error - constraint failed column Id is not unique
    okt-31 17:48:47 Sonos Error ParentID = FV:2
    okt-31 17:48:47 Sonos Error Id = FV:2/0
    okt-31 17:48:47 Sonos Error URI = x-sonosapi-stream:s47450?sid=254&flags=8224&sn=0
    okt-31 17:48:47 Sonos Error Artist = NRK P1 Trøndelag
    okt-31 17:48:47 Sonos Error Album =
    okt-31 17:48:47 Sonos Error Name = Favorites
    okt-31 17:48:47 Sonos Error BuildSpecificObjectDB unable write this record for zoneplayer = Kjøkken with ObjectDBName = Favorites and error - constraint failed column Id is not unique
    okt-31 17:48:47 Sonos Error ParentID = FV:2
    okt-31 17:48:47 Sonos Error Id = FV:2/1
    okt-31 17:48:47 Sonos Error URI = x-rincon-cpcontainer:1004206cspotify%3aalbum%3a1Jwx5oQiRF96U30SFhslRl ?sid=9&flags=8300&sn=1
    okt-31 17:48:47 Sonos Error Artist = Barnas Superjul - Musikken Fra Julekalenderen
    okt-31 17:48:47 Sonos Error Album =
    okt-31 17:48:47 Sonos Error Name = Favorites
    okt-31 17:48:47 Sonos Error BuildSpecificObjectDB unable write this record for zoneplayer = Kjøkken with ObjectDBName = Favorites and error - constraint failed column Id is not unique
    okt-31 17:48:47 Sonos Error ParentID = SQ:
    okt-31 17:48:47 Sonos Error Id = SQ:2
    okt-31 17:48:47 Sonos Error URI = file:///jffs/settings/savedqueues.rsq#2
    okt-31 17:48:47 Sonos Error Artist = Merete
    okt-31 17:48:47 Sonos Error Album =
    okt-31 17:48:47 Sonos Error Name = All Playlists
    okt-31 17:48:47 Sonos Error BuildSonosPlaylistDB unable write this record for zoneplayer = Kjøkken with error - constraint failed column Id is not unique
    okt-31 17:48:47 Sonos Error ParentID = SQ:
    okt-31 17:48:47 Sonos Error Id = SQ:1
    okt-31 17:48:47 Sonos Error URI = file:///jffs/settings/savedqueues.rsq#1
    okt-31 17:48:47 Sonos Error Artist = Kvelds Lydbok
    okt-31 17:48:47 Sonos Error Album =
    okt-31 17:48:47 Sonos Error Name = All Playlists
    okt-31 17:48:47 Sonos Error BuildSonosPlaylistDB unable write this record for zoneplayer = Kjøkken with error - constraint failed column Id is not unique
    okt-31 17:48:47 Sonos Error ParentID = SQ:
    okt-31 17:48:47 Sonos Error Id = SQ:0
    okt-31 17:48:47 Sonos Error URI = file:///jffs/settings/savedqueues.rsq#0
    okt-31 17:48:47 Sonos Error Artist = Eine & Ingvild
    okt-31 17:48:47 Sonos Error Album =
    okt-31 17:48:47 Sonos Error Name = All Playlists
    okt-31 17:48:47 Sonos Error BuildSonosPlaylistDB unable write this record for zoneplayer = Kjøkken with error - constraint failed column Id is not unique
    okt-31 17:48:46 Sonos Error Error in CreateTrackDatabase for zoneplayer = Kjøkken with error = SQL logic error or missing database table Tracks already exists

    Comment


    • #3
      Originally posted by Groot View Post
      Also get these errors when trying to BuildDB:
      which PI version are you on? Is this running on Windows or Linux (different SQL DLL!!).

      Seen a DB getting corrupt over the years but this seems to indicate both the MusicDB and the RadioStationDB to have problems. I do see the International Characters here at play. Has this ever worked?

      One thing you can do is to delete the DBs. So stop HS. Go to <Hs root>\html\Sonos\MusicDB and delete all files in there. Restart HS and now either play a radiostation or rebuild the MusicDB.

      If all fails, maybe copy the DB somewhere before you delete them and post them so I can try to see if there is some corruption going on.

      Dirk

      Comment


      • #4
        Originally posted by dcorsus View Post

        which PI version are you on? Is this running on Windows or Linux (different SQL DLL!!).

        Seen a DB getting corrupt over the years but this seems to indicate both the MusicDB and the RadioStationDB to have problems. I do see the International Characters here at play. Has this ever worked?

        One thing you can do is to delete the DBs. So stop HS. Go to <Hs root>\html\Sonos\MusicDB and delete all files in there. Restart HS and now either play a radiostation or rebuild the MusicDB.

        If all fails, maybe copy the DB somewhere before you delete them and post them so I can try to see if there is some corruption going on.

        Dirk
        Thanks for your reply.

        I'm on 3.1.0.26.
        Have never used the plugin before. But did as you suggested. Deleted the DBs. And now it seems to work without any problem.

        Only thing that I can see now, is that these buttons don't work/show anything:
        Genres Artists Albums Tracks

        Comment


        • #5
          Originally posted by Groot View Post

          Only thing that I can see now, is that these buttons don't work/show anything:
          Genres Artists Albums Tracks
          did you create the music dB ? Help file to be found clicking on tools->help->sonos
          click on control (Sonos master device on device management page) then click build musicdb

          Dirk

          Comment


          • #6
            Originally posted by dcorsus View Post

            did you create the music dB ? Help file to be found clicking on tools->help->sonos
            click on control (Sonos master device on device management page) then click build musicdb

            Dirk
            Yes, after I deleted the DBs and created a new one. Everything seams to work as it should. Except these buttons. The other buttons, Favorites, Radiostations, works
            But maybe they only work when I have a library of mp3's?

            Comment


            • #7
              Originally posted by Groot View Post

              Yes, after I deleted the DBs and created a new one. Everything seams to work as it should. Except these buttons. The other buttons, Favorites, Radiostations, works
              But maybe they only work when I have a library of mp3's?
              Are there errors in the log file when you click on these buttons? It seems to indicate that do NOT have a musicDB or you have nothing stored on your Sonos. This PI is oblivious to whatever content format the Sonos player has in its DB, be it MP3 or anything else.

              In case of doubt or errors, turn the debug flag on, do whatever it is that doesn't work and post the debug log. You CANNOT post too much !!!

              Dirk

              Comment


              • #8
                Originally posted by dcorsus View Post

                Are there errors in the log file when you click on these buttons? It seems to indicate that do NOT have a musicDB or you have nothing stored on your Sonos. This PI is oblivious to whatever content format the Sonos player has in its DB, be it MP3 or anything else.

                In case of doubt or errors, turn the debug flag on, do whatever it is that doesn't work and post the debug log. You CANNOT post too much !!!

                Dirk
                There is no errors.
                This is from the log after pressing the Genres button:

                okt-31 21:04:37 Sonos SaveNavSettingstoINIFile called for Zoneplayer = Loftstue with ClientID = 0
                okt-31 21:04:37 Sonos LoadNavigationBox called for Player = Loftstue and has 1 entries in the NavigationBox
                okt-31 21:04:37 Sonos MyTcpListener.DoAccept Received data = ;&gt;x-sonosapi-stream:s47450?sid=254&amp;amp;flags=8224&amp;amp;sn=0&lt;/res&gt;&lt;r:streamContent&gt;&lt;/r:streamContent&gt;&lt;r:radioShowMd&gt;&lt;/r:radioShowMd&gt;&lt;upnp:albumArtURI&gt;/getaa?s=1&amp;amp;u=x-sonosapi-stream%3as47450%3fsid%3d254%26flags%3d8224%26sn%3d0&lt;/upnp:albumArtURI&gt;&lt;dc:title&gt;x-sonosapi-stream:s47450?sid=254&amp;amp;flags=8224&amp;amp;sn=0&lt;/dc:title&gt;&lt;upnp:class&gt;object.item&lt;/upnp:class&gt;&lt;/item&gt;&lt;/DIDL-Lite&gt;"/><r:NextTrackURI val=""/><r:NextTrackMetaData val=""/><r:EnqueuedTransportURI val="x-sonosapi-stream:s47450?sid=254&amp;flags=8224&amp;sn=0"/><r:EnqueuedTransportURIMetaData val="&lt;DIDL-Lite xmlns:dc=&quot;http://purl.org/dc/elements/1.1/&quot; xmlns:upnp=&quot;urn:schemas-upnp-org:metadata-1-0/upnp/&quot; xmlns:r=&quot;urn:schemas-rinconnetworks-com:metadata-1-0/&quot; xmlns=&quot;urn:schemas-upnp-org:metadata-1-0/DIDL-Lite/&quot;&gt;&lt;item id=&quot;-1&quot; parentID=&quot;-1&quot; restricted=&quot;true&quot;&gt;&lt;dc:title&gt;NRK P1 Trøndelag&lt;/dc:title&gt;&lt;upnp:class&gt;object.item.audioItem.audioBro adcast&lt;/upnp:class&gt;&lt;desc id=&quot;cdudn&quot; nameSpace=&quot;urn:schemas-rinconnetworks-com:metadata-1-0/&quot;&gt;SA_RINCON65031_&lt;/desc&gt;&lt;/item&gt;&lt;/DIDL-Lite&gt;"/><PlaybackStorageMedium val="NETWORK"/><AVTransportURI val="x-sonosapi-stream:s47450?sid=254&amp;flags=8224&amp;sn=0"/><AVTransportURIMetaData val="&lt;DIDL-Lite xmlns:dc=&quot;http://purl.org/dc/elements/1.1/&quot; xmlns:upnp=&quot;urn:schemas-upnp-org:metadata-1-0/upnp/&quot; xmlns:r=&quot;urn:schemas-rinconnetworks-com:metadata-1-0/&quot; xmlns=&quot;urn:schemas-upnp-org:metadata-1-0/DIDL-Lite/&quot;&gt;&lt;item id=&quot;-1&quot; parentID=&quot;-1&quot; restricted=&quot;true&quot;&gt;&lt;dc:title&gt;NRK P1 Trøndelag&lt;/dc:title&gt;&lt;upnp:class&gt;object.item.audioItem.audioBro adcast&lt;/upnp:class&gt;&lt;desc id=&quot;cdudn&quot; nameSpace=&quot;urn:schemas-rinconnetworks-com:metadata-1-0/&quot;&gt;SA_RINCON65031_&lt;/desc&gt;&lt;/item&gt;&lt;/DIDL-Lite&gt;"/><NextAVTransportURI val=""/><NextAVTransportURIMetaData val=""/><CurrentTransportActions val="Set, Stop, Play"/><r:CurrentValidPlayModes val=""/><r:MuseSessions val=""/><rirectControlClientID val=""/><rirectControlIsSuspended val="0"/><rirectControlAccountID val=""/><TransportStatus val="OK"/><r:SleepTimerGeneration val="0"/><r:AlarmRunning val="0"/><r:SnoozeRunning val="0"/><r:RestartPending val="0"/><TransportPlaySpeed val="NOT_IMPLEMENTED"/><CurrentMediaDuration val="NOT_IMPLEMENTED"/><RecordStorageMedium val="NOT_IMPLEMENTED"/><PossiblePlaybackStorageMedia val="NONE, NETWORK"/><PossibleRecordStorageMedia val="NOT_IMPLEMENTED"/><RecordMediumWriteStatus val="NOT_IMPLEMENTED"/><CurrentRecordQualityMode val="NOT_IMPLEMENTED"/><PossibleRecordQualityModes val="NOT_IMPLEMENTED"/></InstanceID></Event>
                okt-31 21:04:37 Sonos LoadNavigationBox called for Player = Loftstue and GenerateDiv= True
                okt-31 21:04:37 Sonos GetGenres called for Zone - Loftstue returned 0 genres
                okt-31 21:04:37 Sonos GetGenres called for Zone - Loftstue and iPodDBName =
                okt-31 21:04:37 Sonos postBackProc issued Genres command for Zoneplayer = Loftstue with Value = Submit
                okt-31 21:04:37 Sonos postBackProc for PlayerControl for Player = Loftstue found Value = Submit
                okt-31 21:04:37 Sonos postBackProc for PlayerControl for Player = Loftstue found Key = ButGenres
                okt-31 21:04:37 Sonos postBackProc for PlayerControl for Player = Loftstue found Value = ButGenres
                okt-31 21:04:37 Sonos postBackProc for PlayerControl for Player = Loftstue found Key = id
                okt-31 21:04:37 Sonos postBackProc for PlayerControl for Player = Loftstue found Value = on
                okt-31 21:04:37 Sonos postBackProc for PlayerControl for Player = Loftstue found Key = Label-RINCON
                okt-31 21:04:37 Sonos postBackProc for PlayerControl for Player = Loftstue found Value = 0
                okt-31 21:04:37 Sonos postBackProc for PlayerControl for Player = Loftstue found Key = clientid
                okt-31 21:04:37 Sonos MyTcpListener.DoAccept Received data = NOTIFY /RINCON_B8E9378EA8E601400_MR/urn:upnp-org:serviceId:AVTransport HTTP/1.1 HOST: 192.168.1.226:64675 CONNECTION: close CONTENT-TYPE: text/xml CONTENT-LENGTH: 5025 NT: upnp:event NTS: upnpropchange SID: uuid:RINCON_B8E9378EA8E601400_sub0000004110 SEQ: 13 <Event xmlns="urn:schemas-upnp-org:metadata-1-0/AVT/" xmlns:r="urn:schemas-rinconnetworks-com:metadata-1-0/"><InstanceID val="0"><TransportState val="STOPPED"/><CurrentPlayMode val="NORMAL"/><CurrentCrossfadeMode val="0"/><NumberOfTracks val="3"/><CurrentTrack val="1"/><CurrentSection val="0"/><CurrentTrackURI val="x-rincon-mp3radio://http://lyd.nrk.no/nrk_radio_p1_trondelag_mp3_h"/><CurrentTrackDuration val="0:00:00"/><CurrentTrackMetaData val="&lt;DIDL-Lite xmlns:dc=&quot;http://purl.org/dc/elements/1.1/&quot; xmlns:upnp=&quot;urn:schemas-upnp-org:metadata-1-0/upnp/&quot; xmlns:r=&quot;urn:schemas-rinconnetworks-com:metadata-1-0/&quot; xmlns=&quot;urn:schemas-upnp-org:metadata-1-0/DIDL-Lite/&quot;&gt;&lt;item id=&quot;-1&quot; parentID=&quot;-1&quot; restricted=&quot;true&quot;&gt;&lt;res protocolInfo=&quot;sonos.com-http:*:*:*&quot
                okt-31 21:04:37 Sonos MyTcpListener.DoAccept active on HostAddress = 192.168.1.226 and HostIPPort = 64675 and RemoteAddress = 192.168.1.246 and remoteIPPort = 36127
                Also got a warning:
                okt-31 21:04:56 Sonos Warning MyTcpListener.DoAccept Received a data but did not send a response

                If this tells you anything :P

                Comment


                • #9
                  Originally posted by Groot View Post
                  If this tells you anything :P
                  Not a lot ....

                  So first question, do you have anything "discovered" on your Sonos player? So I'm not talking about services like XM or Pandora, Napster etc. I'm referring to tracks available on your local network that Sonos has discovered and you can browse, select and play? It is that content that will show in the PI. If Sonos has nothing, neither will this PI.
                  This PI cannot navigate "external to Sonos" content, so you cannot use this PI say to navigate Pandora. The interface Sonos provides does NOT provide that function.

                  Comment


                  • #10
                    Originally posted by dcorsus View Post

                    Not a lot ....

                    So first question, do you have anything "discovered" on your Sonos player? So I'm not talking about services like XM or Pandora, Napster etc. I'm referring to tracks available on your local network that Sonos has discovered and you can browse, select and play? It is that content that will show in the PI. If Sonos has nothing, neither will this PI.
                    This PI cannot navigate "external to Sonos" content, so you cannot use this PI say to navigate Pandora. The interface Sonos provides does NOT provide that function.
                    I see. Then it was as i suspected.
                    I don't have a locally media library with music. I only stream from spotify.
                    So that is the problem(that's not a problem)

                    Then everything is working as it should.

                    Comment


                    • #11
                      Originally posted by Groot View Post

                      Then everything is working as it should.
                      Indeed.

                      Comment

                      Working...
                      X