Jump to content

Playback Reporting - 500 Internal Server Error


Recommended Posts

snodrog742
Posted

Set up new Linux server - Emby 4.4.0.40 and installed plugin but getting this error under multiple tabs in plugin.  I'm sure I'm missing something simple.

 

post-113517-0-80800600-1585616903_thumb.png

Happy2Play
Posted

Set up new Linux server - Emby 4.4.0.40 and installed plugin but getting this error under multiple tabs in plugin.  I'm sure I'm missing something simple.

 

attachicon.gifScreen Shot 2020-03-30 at 8.07.32 PM.png

What plugin version number?

 

@@TeamB

Posted

the 500 internal server error will be in the server logs.

snodrog742
Posted

Version 1.6.10.1.

 

 

the 500 internal server error will be in the server logs.

2020-03-30 23:25:26.392 Info PlaybackReporting - UserActivityAPI: Default journal_mode for /var/lib/emby/data/playback_reporting.db is delete2020-03-30 23:25:26.396 Error HttpServer: Error processing request	*** Error Report ***	Version: 4.4.0.40	Command line: /opt/emby-server/system/EmbyServer.dll -programdata /var/lib/emby -ffdetect /opt/emby-server/bin/ffdetect -ffmpeg /opt/emby-server/bin/ffmpeg -ffprobe /opt/emby-server/bin/ffprobe -restartexitcode 3 -updatepackage emby-server-rpm_{version}_x86_64.rpm	Operating system: Unix 3.10.0.1062	64-Bit OS: True	64-Bit Process: True	User Interactive: True	Runtime: file:///opt/emby-server/system/System.Private.CoreLib.dll	System.Environment.Version: 3.1.2	Processor count: 24	Program data path: /var/lib/emby	Application directory: /opt/emby-server/system	SQLitePCL.pretty.SQLiteException: Error: no such table: PlaybackActivity - SELECT ItemId, DateCreated AS StartTime, PlayDuration, datetime(DateCreated, '+' || CAST(PlayDuration AS VARCHAR) || ' seconds') AS EndTime FROM PlaybackActivity WHERE EndTime > @start_time	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 playback_reporting.Data.ActivityRepository.GetPlayActivityCounts(Int32 hours)	   at playback_reporting.Api.UserActivityAPI.Get(GetResourceUsageInfo request)	   at Emby.Server.Implementations.Services.ServiceController.Execute(HttpListenerHost appHost, Object requestDto, IRequest req)	   at Emby.Server.Implementations.Services.ServiceHandler.ProcessRequestAsync(HttpListenerHost appHost, IRequest httpReq, IResponse httpRes, RestPath restPath, String responseContentType, CancellationToken cancellationToken)	   at Emby.Server.Implementations.HttpServer.HttpListenerHost.RequestHandler(IRequest httpReq, ReadOnlyMemory`1 urlString, ReadOnlyMemory`1 localPath, CancellationToken cancellationToken)	Source: SQLitePCL.pretty	TargetSite: SQLitePCL.pretty.IStatement PrepareStatement(System.String, System.String ByRef)
snodrog742
Posted

It looks like playback_reporting.db isn't getting created right.

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...