Community rating decimal places.

[elechtma]

Great plug-in!
I’m using the modern template.
I’ve noticed that there are 3 decimal places for the community rating. This takes up unnecessary real-estate.
Is there anyway to make it just a single decimal place?

[Yoffr]

Hello,

Just to add a possible hypothesis regarding the root cause and a potential fix.

On systems using non-US cultures (e.g. fr-FR), decimal values such as CommunityRating are formatted with a comma (e.g. 8,3).
When these values are inserted into SQLite, this results in an invalid INSERT statement and triggers the error:

“SQLiteException: 14 values for 13 columns”.

Hypothesis: the plugin is converting numeric values to strings using the current CultureInfo instead of an invariant one.

Potential solution: when building SQL INSERT statements, format numeric values (double/decimal) using CultureInfo.InvariantCulture, for example:

value.ToString(CultureInfo.InvariantCulture)

This would ensure a dot decimal separator (8.3) regardless of system or Jellyfin language settings and should prevent the SQLite error on non-US locales.

This is only a hypothesis based on logs and locale behavior, but it seems consistent with the reported symptoms.
Let me know if more logs or testing would be helpful.