crazybbs 24 Posted November 23, 2019 Share Posted November 23, 2019 (edited) 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 November 23, 2019 by crazybbs Link to comment Share on other sites More sharing options...
Luke 36887 Posted November 23, 2019 Share Posted November 23, 2019 What version did you have before? Link to comment Share on other sites More sharing options...
crazybbs 24 Posted November 23, 2019 Author Share Posted November 23, 2019 (edited) The last stable version before this one I always keep this server on stable channel so 4.2.1.0 Edited November 23, 2019 by crazybbs Link to comment Share on other sites More sharing options...
Luke 36887 Posted November 23, 2019 Share Posted November 23, 2019 Thanks. Link to comment Share on other sites More sharing options...
dack64 0 Posted November 25, 2019 Share Posted November 25, 2019 Same problem after update. Many empty folders on my lg tv (netcast) via dlna. Link to comment Share on other sites More sharing options...
Luke 36887 Posted November 29, 2019 Share Posted November 29, 2019 This error has been resolved in 4.3.0.30. Thanks. 1 Link to comment Share on other sites More sharing options...
dack64 0 Posted November 29, 2019 Share Posted November 29, 2019 (edited) This error has been resolved in 4.3.0.30. Thanks.the problem is still not resolved.embyserver.txt Edited November 29, 2019 by dack64 Link to comment Share on other sites More sharing options...
Luke 36887 Posted November 29, 2019 Share Posted November 29, 2019 the problem is still not resolved. Please see how to report a problem. Thanks. Link to comment Share on other sites More sharing options...
crazybbs 24 Posted November 30, 2019 Author Share Posted November 30, 2019 (edited) For me it's resolved thank you for the Quick fix @@Luke Edited November 30, 2019 by crazybbs Link to comment Share on other sites More sharing options...
Luke 36887 Posted November 30, 2019 Share Posted November 30, 2019 Thanks for the feedback. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now