Calculate user statistics error

[jlficken 3]

I've refreshed the metadata on all libraries with a Movie type, however, I still get this error on 4.7.6.0...any thoughts?

 

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-deb_{version}_amd64.deb
Operating system: Linux version 5.15.60-1-pve (build@proxmox) (gcc (Debian 10.2.1-6) 10.2.1 20210110, GNU ld (GNU Binutils for Debian) 2.35.2) #1 SMP PVE 5.15.60-1 (Mon
Framework: .NET 6.0.2
OS/Process: x64/x64
Runtime: opt/emby-server/system/System.Private.CoreLib.dll
Processor count: 32
Data path: /var/lib/emby
Application path: /opt/emby-server/system
System.NullReferenceException: System.NullReferenceException: Object reference not set to an instance of an object.
at Statistics.Helpers.Calculator.CalculateMovieQualities()
at Statistics.ScheduledTasks.CalculateStatsTask.MediaBrowser.Model.Tasks.IScheduledTask.Execute(CancellationToken cancellationToken, IProgress`1 progress)
at Emby.Server.Implementations.ScheduledTasks.ScheduledTaskWorker.ExecuteInternal(TaskOptions options)
Source: statistics
TargetSite: statistics.Models.Configuration.ValueGroup CalculateMovieQualities()

 

[Luke 42080]

@hackthis02

[Happy2Play 9782]

Known do to rogue Emby unidentified Shows.

Lot of discussu in here above and below my post showing the query to see defective Shows in your database.

 

[jlficken 3]

22 minutes ago, Happy2Play said:

Known do to rogue Emby unidentified Shows.

Lot of discussu in here above and below my post showing the query to see defective Shows in your database.

 

Mine seems to be erroring though on Movies rather than TV shows so would this still apply?

[Happy2Play 9782]

1 minute ago, jlficken said:

Mine seems to be erroring though on Movies rather than TV shows so would this still apply?

It is the exact same error everyone is getting "ValueGroup CalculateMovieQualities()" but has but deletes the rouge TV issue.

[jlficken 3]

4 minutes ago, Happy2Play said:

It is the exact same error everyone is getting "ValueGroup CalculateMovieQualities()" but has but deletes the rouge TV issue.

 

Yeah I just saw that reading through that thread.  I've just done an update on my database for now to set them to non-null values and am running the task so we'll see what happens.

[jlficken 3]

As a data point I ran a delete to remove the 8 records that were returned from the Select query but the task still fails.

[Happy2Play 9782]

Honestly don't know then as that is the only I have been able to find.  Not to say everyones library can be totally different with different issues.  But yes the plugin need to catch BAD Emby info better but I see the plug just going away if it can't be caught.  

Plugin works perfectly on servers that do not have metadata issues.

[jlficken 3]

Deleting those records was a BAD idea as it broke all of the libraries where I deleted records from.  Library scans wouldn't work, media wasn't available, etc.

 

Happily, I have daily backups of my Emby container through Proxmox so I reverted to yesterday's backup.

[Happy2Play 9782]

1 minute ago, jlficken said:

Deleting those records was a BAD idea as it broke all of the libraries where I deleted records from.  Library scans wouldn't work, media wasn't available, etc.

 

Happily, I have daily backups of my Emby container through Proxmox so I reverted to yesterday's backup.

How did you delete, directly in the database?

Delete the items for Emby UI or Move from filesystem.

[jlficken 3]

20 minutes ago, Happy2Play said:

How did you delete, directly in the database?

Delete the items for Emby UI or Move from filesystem.

 

Yeah from the database since I'm just used to SQL.  I learned my lesson 

[Happy2Play 9782]

1 minute ago, jlficken said:

 

Yeah from the database since I'm just used to SQL.  I learned my lesson 

Yep alway have a backup of the db if you plan on manually editing.