SELECT error reported by miniDLNA for UPnP requests [#19321]

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: SELECT error reported by miniDLNA for UPnP requests [#19321]

Re: SELECT error reported by miniDLNA for UPnP requests [#19321]

by Peke » Mon Aug 14, 2023 3:53 pm

Hi,
THX, added to bug, I wish that there is more standards on search queries :(

Re: SELECT error reported by miniDLNA for UPnP requests [#19321]

by jmondlnakey » Mon Aug 14, 2023 1:00 pm

Thanks for the feeback. Log ID AW9YZKPPSY was sent.

Re: SELECT error reported by miniDLNA for UPnP requests [#19321]

by Peke » Sun Aug 13, 2023 5:39 pm

Hi,
When you get that error use ☰ -> ? -> Send logs and write log id here for reference so that we can see why MMA query fail.

Re: SELECT error reported by miniDLNA for UPnP requests

by jmondlnakey » Sun Aug 13, 2023 1:17 am

I would like to add that after a year the current Android MM 2.0.0.1095 (pro) still cannot search neither minidlna nor another DLNA server like minimServer on Raspberry, and exactly the same "prepare failed: near ":author": syntax error" is displayed in the log.

With an extensive music selection on a server this hampers daily use quite a bit and reduces MM down to a non-intelligent "just play a preselected list or folder content" player :(

Re: SELECT error reported by miniDLNA for UPnP requests

by Peke » Tue Aug 23, 2022 8:18 pm

Hi,
That is why bug is opened for analyze and correction, for me it looks like MM5 do not even query upnp:author and thus no issues? We will see what MMA logs will show.

Re: SELECT error reported by miniDLNA for UPnP requests

by edoli » Tue Aug 23, 2022 5:54 pm

Ok, so it looks like MM desktop latest version can talk to miniDLNA and get itself understood well, while MM android version not and that should be accepted as not a bug. Got that.
Thanks.

Re: SELECT error reported by miniDLNA for UPnP requests

by Peke » Tue Aug 23, 2022 5:33 pm

Hi,
that is exactly what I am talking about, MMA do not send SQL calls to miniDLNA it just sends standard Search message to DLNA server to return list of tracks for specific search.

It is standardized back in 2010 (Page. 249) See current standard at http://upnp.org/specs/av/UPnP-av-Conten ... ervice.pdf where on page 172 upnp:author is explained. d.author does not exist as it is internally made in miniDLNA. So bug is definitely in miniDLNA "sql.c:88/upnpsoap.c:123: warn: Returning UPnPError 708: Unsupported" where it doesn't support the standards listed in above document.

Also that is the reason why I asked you to test with MM5 DLNA server or in the matter any other DLNA server not miniDLNA. You said you use both MMA and MM5 for accessing and browsing miniDLNA so does it even asks for author listing?

EDIT: To confirm above miniDLNA really do not support handle "upnp:author" as clearly seen at https://github.com/keenetic/minidlna/bl ... upnpsoap.c from line 201-214 and 376-384 sorry, but answer for this should be comming from miniDLNA devs also because d.author also do not exist in DB structure (I think, as I am not miniDLNA dev and based on upnpsoap.c).

Re: SELECT error reported by miniDLNA for UPnP requests

by edoli » Tue Aug 23, 2022 4:52 pm

Yes, I am using MM not as DLNA server, but to access a miniDLNA server on the network.
The problem is therefore with the sSL requests sent by MM to miniDLNA, not viceversa. Apologies if that was not clear from the beginning - the error is the error I read in the miniDLNA server log on Raspberry.

That is the reason it looked so odd to me you asked the log of MM DLNA server - none is running.

Re: SELECT error reported by miniDLNA for UPnP requests

by Peke » Tue Aug 23, 2022 1:03 pm

Hi,
Ok I moved it to Android Section.

Also I created https://www.ventismedia.com/mantis/view.php?id=19321 for us to analyze and check difference.

A question for you, are you saying that MM5 access miniDLNA?

Re: SELECT error reported by miniDLNA for UPnP requests

by edoli » Tue Aug 23, 2022 5:21 am

OK,
misidentification by my side. sorry for this.
I understood that the error is originated by MM Android (currently using version 1.4.3.950) not by MM desktop (I am using both)
So it looks like the SQL statement is shaped differently if comes from MM android or desktop - definitely sound like a bug to me then.

I submitted an Android log, id DPHCECFKFI

Not sure if an admin can help relocating this bug to the Android section of the forum.
Thanks!

Re: SELECT error reported by miniDLNA for UPnP requests

by Peke » Mon Aug 22, 2022 6:47 pm

edoli wrote: Mon Aug 22, 2022 5:27 pm do you mean what happens when MM tries to access bubble UPnP DLNA server?
I meant bubble UPnP access MM5 DLNA server.

Can yo make screenshots in MM and create debug log as described here https://www.mediamonkey.com/forum/viewt ... 30&t=86643 while access miniDLNA?

Re: SELECT error reported by miniDLNA for UPnP requests

by edoli » Mon Aug 22, 2022 5:27 pm

do you mean what happens when MM tries to access bubble UPnP DLNA server?
I shold see if there is a log of database in bubble UPnP DLNA server.

Just to reinforce my impression is an issue with MM, I tried with Hificast, and no errors logged in the miniDLNA database log.
Tried with Windows Media Player too. No errors there too.

So I really doubt this is a coincidence.

I guess it should not be difficult to understand if that upnp:artist thing is a slipup in programming or not. :-?

Re: SELECT error reported by miniDLNA for UPnP requests

by Peke » Mon Aug 22, 2022 5:07 pm

Hi,
Not so sure. How Bubble UPnP for Android behaves when you try to access MM5 as DLNA server?

Asking if that differs or you may have problems it is possible to have DLNA standard issues that needs to be reviewed.

Re: SELECT error reported by miniDLNA for UPnP requests

by edoli » Mon Aug 22, 2022 1:22 pm

Thank you so much!
That helps a lot narrowing the issue. I'll go pestering the guys there then :D

However - I can observe that performing exactly the same search using another client, namely Bubble UPnP for Android, causes no errors in miniDLNA - so I'm not really sure it's the right diagnosis.

Appreciate your amazing support anyway.
Take care

REEDIT:
observing the SQL, there is indeed something weird to me. all fields are referenced using the table alias d for table DETAILS, except for author, referenced as upnp:author instead of d.author.
Not sure if this is correct.

Re: SELECT error reported by miniDLNA for UPnP requests

by Peke » Sun Aug 21, 2022 7:02 pm

Hi,
That error is not MM one but MiniDLNA See https://github.com/keenetic/minidlna/bl ... upnpsoap.c

Are you sure that version you use supports DLNA search correctly?

You are not the only one, but search not found any current Solution.

I would suggest asking on their forum and also make sure you are using latest Beta from https://www.mediamonkey.com/forum/viewt ... 86639&sd=d

Top