Jump to content

Emby dlna stopped working on Emby stable 4.3.0.26


crazybbs

Recommended Posts

Hi ,

 

Emby automatically updated to 4.3.0.26 last night and i'm unable to play anything from my netcast lg blueray player. 

 

I can connect to dlna server and browse main folder ( like movies, genre, tv shows) but if I enter any folder containing something to play it's spinning indefinitely.

 

from server logs I see this problem (full log in attachment):

 

2019-11-23 12:33:44.863 Debug HttpServer: HTTP Response 200 to 192.168.51.122. Time: 2ms. http://192.168.51.3:8096/dlna/18aa2928f2da46918a29d93809b5df93/contentdirectory/control
2019-11-23 12:33:45.368 Debug HttpServer: HTTP POST http://192.168.51.3:8096/dlna/18aa2928f2da46918a29d93809b5df93/contentdirectory/control. UserAgent: LG-BDP Linux/2.6.35 UPnP/1.0 DLNADOC/1.50 LGE_DLNA_SDK/1.5.0
2019-11-23 12:33:45.369 Debug Dlna: Found matching device profile: LG 50LB6500-UM
2019-11-23 12:33:45.369 Debug Dlna: Control request. Headers: HOST=192.168.51.3:8096, CONTENT-LENGTH=744, CONTENT-TYPE=text/xml; charset="utf-8", SOAPACTION="urn:schemas-upnp-org:service:ContentDirectory:1#Browse", USER-AGENT=LG-BDP Linux/2.6.35 UPnP/1.0 DLNADOC/1.50 LGE_DLNA_SDK/1.5.0
2019-11-23 12:33:45.369 Debug Dlna: Received control request Browse
2019-11-23 12:33:45.369 Error Dlna: Error processing control request
*** Error Report ***
Version: 4.3.0.26
Command line: C:\Users\Main\AppData\Roaming\MediaBrowser-Server\system\EmbyServer.dll -noautorunwebapp
Operating system: Microsoft Windows NT 6.2.9200.0
64-Bit OS: True
64-Bit Process: True
User Interactive: True
Runtime: file:///C:/Users/Main/AppData/Roaming/MediaBrowser-Server/system/System.Private.CoreLib.dll
Processor count: 8
Program data path: C:\Users\Main\AppData\Roaming\MediaBrowser-Server
Application directory: C:\Users\Main\AppData\Roaming\MediaBrowser-Server\system
SQLitePCL.pretty.SQLiteException: Error: near "OFFSET": syntax error - select A.data,A.Id,A.StartDate,A.EndDate,A.CommunityRating,A.CustomRating,A.IndexNumber,A.IsLocked,A.PreferredMetadataLanguage,A.PreferredMetadataCountryCode,A.Width,A.Height,A.DateLastRefreshed,A.Name,A.Path,A.PremiereDate,A.Overview,A.ParentIndexNumber,A.ProductionYear,A.OfficialRating,A.ForcedSortName,A.RunTimeTicks,A.Size,A.Container,A.DateCreated,A.DateModified,A.guid,A.Genres,A.ParentId,A.IsInMixedFolder,A.DateLastSaved,A.LockedFields,A.Studios,A.Tags,A.OriginalTitle,A.IsVirtualItem,A.SeriesName,A.Album,A.AlbumId,A.SeriesId,A.PresentationUniqueKey,A.InheritedParentalRatingValue,A.Tagline,A.ProviderIds,A.Images,A.ProductionLocations,A.TotalBitrate,A.ExternalId,A.SeriesPresentationUniqueKey,A.DisplayOrder,A.ThreeDFormat,UserDatas.Rating,UserDatas.IsFavorite,UserDatas.Played,UserDatas.PlayCount,UserDatas.PlaybackPositionTicks,UserDatas.LastPlayedDateInt,UserDatas.AudioStreamIndex,UserDatas.SubtitleStreamIndex from MediaItems A left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And (UserDatas.UserId=@UserId) where type=@@type AND IsVirtualItem=@IsVirtualItem AND TopParentId in (1559650,9999,10000,10001,10085,10086,10087,10088,10089,112317,6243,6244,6245,10075,10076,10077,10078,100464,1559771,6246,1307830,112318,72765,10079,10080,10081,10082,112353,10403,10083,10084,103315,1307832,1307835,11240,112351,3637479) AND SeriesPresentationUniqueKey=@SeriesPresentationUniqueKey Group by PresentationUniqueKey ORDER BY SortName collate NATURALSORT ASC OFFSET 109
SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
   at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement(String sql, String& tail)
   at SQLitePCL.pretty.DatabaseConnection.PrepareStatement(IDatabaseConnection This, String sql)
   at Emby.Server.Implementations.Data.SqliteItemRepository.QueryItemsInTransaction[T](InternalItemsQuery query, IDatabaseConnection db, String[] columnsToSelect, Func`5 rowReaderFn, Boolean singleResult, String methodName)
   at Emby.Server.Implementations.Data.SqliteItemRepository.GetItemList(InternalItemsQuery query)
   at MediaBrowser.Controller.Entities.TV.Series.GetSeasonEpisodes(Season parentSeason, InternalItemsQuery query)
   at MediaBrowser.Controller.Entities.TV.Series.GetSeasonEpisodes(Season parentSeason, InternalItemsQuery query, BaseItem[] allSeriesEpisodes)
   at MediaBrowser.Controller.Entities.Folder.GetItems(InternalItemsQuery query)
   at Emby.Dlna.ContentDirectory.ControlHandler.GetUserItems(BaseItem item, Nullable`1 stubType, User user, SortCriteria sort, Nullable`1 startIndex, Nullable`1 limit)
   at Emby.Dlna.ContentDirectory.ControlHandler.HandleBrowse(IDictionary`2 sparams, User user, String deviceId)
   at Emby.Dlna.ContentDirectory.ControlHandler.GetResult(ReadOnlySpan`1 methodName, IDictionary`2 methodParams)
   at Emby.Dlna.Service.BaseControlHandler.ProcessControlRequestInternal(ControlRequest request)
   at Emby.Dlna.Service.BaseControlHandler.ProcessControlRequest(ControlRequest request)
Source: SQLitePCL.pretty
TargetSite: SQLitePCL.pretty.IStatement PrepareStatement(System.String, System.String ByRef)
 
 
Thank you,

 

 

 

embyserver.txt

Edited by crazybbs
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...