[BUG] Error 500 on Statistics

[mptpro]

Describe the bug
When clicking on "Statistics" I get the 500 screen

Screenshots

Error logs
If you have any error logs, paste them here:

Yamtrack version: Version: v0.24.6

File "/usr/local/lib/python3.12/site-packages/django/db/models/query.py", line 1949, in _fetch_all
self._result_cache = list(self._iterable_class(self))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/db/models/query.py", line 216, in iter
for row in compiler.results_iter(
^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/db/models/sql/compiler.py", line 1572, in results_iter
results = self.execute_sql(
^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/db/models/sql/compiler.py", line 1623, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py", line 79, in execute
return self._execute_with_wrappers(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py", line 92, in _execute_with_wrappers
return executor(sql, params, many, context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py", line 100, in _execute
with self.db.wrap_database_errors:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/db/utils.py", line 91, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py", line 105, in _execute
return self.cursor.execute(sql, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/db/backends/sqlite3/base.py", line 360, in execute
return super().execute(query, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
django.db.utils.DataError: string or blob too big
192.168.86.33 - - [11/Jul/2025:19:37:19 -0700] "GET /statistics HTTP/1.1" 500 3942 "http://192.168.86.23:8961/accounts/login/?next=/statistics" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36"
192.168.86.33 - - [11/Jul/2025:19:37:19 -0700] "GET /static/css/main.css?1751836699 HTTP/1.1" 200 14585 "http://192.168.86.23:8961/statistics" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36"
192.168.86.33 - - [11/Jul/2025:19:37:19 -0700] "GET /static/js/libraries/htmx-2.0.4.min.js HTTP/1.1" 200 19272 "http://192.168.86.23:8961/statistics" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36"
192.168.86.33 - - [11/Jul/2025:19:37:19 -0700] "GET /static/js/mediaStatusDateHandler.js?1751836699 HTTP/1.1" 200 810 "http://192.168.86.23:8961/statistics" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36"
192.168.86.33 - - [11/Jul/2025:19:37:19 -0700] "GET /static/js/libraries/alpinejs-3.14.9.min.js HTTP/1.1" 200 18455 "http://192.168.86.23:8961/statistics" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36"
192.168.86.33 - - [11/Jul/2025:19:37:19 -0700] "GET /static/js/libraries/lazysizes-5.3.2.min.js HTTP/1.1" 200 3738 "http://192.168.86.23:8961/statistics" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36"
192.168.86.33 - - [11/Jul/2025:19:37:19 -0700] "GET /static/favicon/favicon.ico HTTP/1.1" 200 15086 "http://192.168.86.23:8961/statistics" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36"
192.168.86.33 - - [11/Jul/2025:19:38:29 -0700] "GET / HTTP/1.1" 200 11919 "http://192.168.86.23:8961/statistics" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36"
[2025-07-11 19:38:33 -0700] [40980] [INFO] Nugget9910 - Retrieved media from 2024-07-11 00:00:00-07:00 to 2025-07-11 23:59:59.999999-07:00
[2025-07-11 19:38:33 -0700] [40980] [ERROR] Internal Server Error: /statistics
Traceback (most recent call last):
File "/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py", line 105, in _execute
return self.cursor.execute(sql, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/db/backends/sqlite3/base.py", line 360, in execute
return super().execute(query, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
sqlite3.DataError: string or blob too big
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.12/site-packages/django/core/handlers/exception.py", line 55, in inner
response = get_response(request)
^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/core/handlers/base.py", line 197, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/views/decorators/http.py", line 64, in inner
return func(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/yamtrack/app/views.py", line 817, in statistics
activity_data = stats.get_activity_data(request.user, start_date, end_date)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/yamtrack/app/statistics.py", line 414, in get_activity_data
combined_data = get_filtered_historical_data(start_date_aligned, end_date, user)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/yamtrack/app/statistics.py", line 545, in get_filtered_historical_data
combined_data.extend(data)
File "/usr/local/lib/python3.12/site-packages/django/db/models/query.py", line 384, in iter
self._fetch_all()
File "/usr/local/lib/python3.12/site-packages/django/db/models/query.py", line 1949, in _fetch_all
self._result_cache = list(self._iterable_class(self))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/db/models/query.py", line 216, in iter
for row in compiler.results_iter(
^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/db/models/sql/compiler.py", line 1572, in results_iter
results = self.execute_sql(
^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/db/models/sql/compiler.py", line 1623, in execute_sql
cursor.execute(sql, params)
File "/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py", line 79, in execute
return self._execute_with_wrappers(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py", line 92, in _execute_with_wrappers
return executor(sql, params, many, context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py", line 100, in _execute
with self.db.wrap_database_errors:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/db/utils.py", line 91, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/usr/local/lib/python3.12/site-packages/django/db/backends/utils.py", line 105, in _execute
return self.cursor.execute(sql, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.12/site-packages/django/db/backends/sqlite3/base.py", line 360, in execute
return super().execute(query, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
django.db.utils.DataError: string or blob too big
192.168.86.33 - - [11/Jul/2025:19:38:33 -0700] "GET /statistics HTTP/1.1" 500 3942 "http://192.168.86.23:8961/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36"

[FuzzyGrim]

Hi, could you try the Docker image created from the pull request to see if it fixes it? In your docker-compose.yml file:

image: ghcr.io/fuzzygrim/yamtrack:pr-727

[mptpro]

That work @FuzzyGrim ! Thank you!

Te image won't automatically update now to the newest available though, correct?

[FuzzyGrim]

You're correct, I'll write here when I create the next release.

[FuzzyGrim]

Merged to the stable image with v0.24.7