Skip to Content
It is currently September 27th, 2022, 12:28 pm

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 8 posts ] 
Author Message
PostPosted: August 16th, 2022, 5:13 pm 
Offline
Junior User
Junior User

Joined: January 31st, 2009, 9:43 pm
Posts: 70
Team,
I am getting the below error message in the Sam Broadcaster event log window. Here's the snippet from the event log file attached. Does anyone know if a similar issue has been reported or occurring at your end?

Code:
E 2022-08-12 09:08:15 [TOUCH] Touch error: <br />
<b>Fatal error</b>: Uncaught exception 'Exception' with message 'TDB.Abort: num_rows: No valid result set.' in /usr/jaws/framework/class.db.php:644
Stack trace:
#0 /usr/jaws/framework/class.db.php(1217): TDB-&gt;Abort('num_rows: No va...')
#1 /usr/jaws/modules/audiorealm.com/core/class.touch.php(126): TDB-&gt;num_rows()
#2 /usr/jaws/modules/audiorealm.com/core/class.touch.php(623): TTouch-&gt;MemberLoginCheck('*******', '******', Array)
#3 /usr/jaws/modules/audiorealm.com/core/class.touch.php(730): TTouch-&gt;ProcessTouch(Array, Array, Array, Array, Array, NULL)
#4 /usr/jaws/modules/audiorealm.com/web/sam2/yp.php(29): TTouch_XML-&gt;XMLProcess('&lt;TOUCH&gt;&lt;applica...')
#5 {main}
thrown in <b>/usr/jaws/framework/class.db.php</b> on line <b>644</b><br />
N 2022-08-12 09:11:56 [DECK A] Various - Vaada Vaada Female (2:37)
E 2022-08-12 09:12:13 [TOUCH] Touch error: <br />
<b>Fatal error</b>: Uncaught exception 'Exception' with message 'TDB.Abort: num_rows: No valid result set.' in /usr/jaws/framework/class.db.php:644

E 2022-08-12 09:27:22 [TOUCH] Touch error: 503, Service Unavailable


Attachments:
Capture.PNG
Capture.PNG [ 18.36 KiB | Viewed 640 times ]

_________________
http://www.tamilragam.com
Top
 Profile  
Reply with quote  
PostPosted: August 20th, 2022, 11:14 am 
Offline
New User
New User

Joined: February 22nd, 2019, 1:20 pm
Posts: 24
It's an AudioRealm error => Your SAM cannot connect to AudioRealm.com. AudioRealm is currently down or very slow in connectivity.


Top
 Profile  
Reply with quote  
PostPosted: August 20th, 2022, 4:32 pm 
Offline
Junior User
Junior User

Joined: January 31st, 2009, 9:43 pm
Posts: 70
Thank you, very strange as Spacial has responded to my ticket stating it is my network issues. I have done all I could with my router and ordered a new one. Even my ISP has confirmed several times there are no issues with my network. The issues occurred only recently.

_________________
http://www.tamilragam.com


Top
 Profile  
Reply with quote  
PostPosted: August 24th, 2022, 4:02 am 
Offline
New User
New User

Joined: July 11th, 2020, 3:13 am
Posts: 7
We seem to have an invalid SSL issue and it wont update to the latest sam broadcaster software. any suggestions on how to fix this?

_________________
Grow your stations revenue with [url]AdStichr.com[/url]


Top
 Profile  
Reply with quote  
PostPosted: August 24th, 2022, 3:42 pm 
Offline
Junior User
Junior User

Joined: April 27th, 2020, 6:15 pm
Posts: 40
AudioRealm going down is VERY common. We get that error on a regular basis, sometimes days on end, then it will disappear for a while. Since AudioRealm was only to proxy requests, and we now handle requests with a custom API, we just ignore it and it does not ever effect our broadcast.

what version of SAM do you need? there's a list of all versions here -
https://sam-broadcaster.informer.com/versions/


Top
 Profile  
Reply with quote  
PostPosted: September 2nd, 2022, 2:34 am 
Offline
Junior User
Junior User

Joined: January 31st, 2009, 9:43 pm
Posts: 70
Mine is 2022.4 and yes agree the error was related to Audioreleam. Can you please help me understand your statement
Quote:
we now handle requests with a custom API

Appreciate any help on this as it may be worthwhile to see alternate solutions.

_________________
http://www.tamilragam.com


Top
 Profile  
Reply with quote  
PostPosted: September 11th, 2022, 8:33 am 
Offline
SVS Member
SVS Member

Joined: May 8th, 2004, 9:00 am
Posts: 10572
Location: Denver, CO
radiomedia wrote:
We seem to have an invalid SSL issue and it wont update to the latest sam broadcaster software. any suggestions on how to fix this?
Fixed with Aug 2022 update. 2202.4

You can find it here viewtopic.php?f=20&t=28106&start=15#p246445

_________________
- Rob Oyler, SVS
Image


Top
 Profile  
Reply with quote  
PostPosted: September 17th, 2022, 3:59 pm 
Offline
Junior User
Junior User

Joined: April 27th, 2020, 6:15 pm
Posts: 40
@cheekycroak - here's an alternative for handling requests -

The url that SamPHPweb uses is this -

Code:
http://${serverIp}:${samPort}/req/?songID=${songId}&host=${host}


serverip - the ip of the server/computer the software is running on
samPort - the port SAM requests is listening on (default 1221)
songID - id of the song requested
host - ip of the request.headers.origin (must be whitelisted in SAM)

We do not use either SAM's php or html files. Here's what we did -

Connect express server to website to handle requests.
Capture songid of chosen song - pass it to the express server
Use ssl proxy from express to SAM (we use Quadrastatic), whitelist the Quadrastatic URL in SAM.

works like a charm.

The only issue we really had was that the request response from SAM is XML, not JSON, so we had to do a little XML->JSON parsing for the frontend response code/message contained in the XML to tell the user the proper information (error or success)


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: Bing [Bot] and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group