"Something went wrong." when selcting last 90+ days

[sandroshu]

Hi,

When I want to check more than 90 days stat I get "Something went wrong" all over the dash (under a particular website, so not on the main dashboard but that doesn't work either).

When I check mysql processes I see this:

|  14 | umami           | 172.17.0.3:38416 | umami | Execute |  142 | executing              | select
      date_format(convert_tz(website_event.created_at,'+00:00','+02:00'), '%Y-%m-01') x,
     |
|  15 | umami           | 172.17.0.3:38432 | umami | Execute |  142 | executing              | select
      date_format(convert_tz(website_event.created_at,'+00:00','+02:00'), '%Y-%m-01') x,
     |
|  16 | umami           | 172.17.0.3:38438 | umami | Execute |  142 | executing              | select
      sum(t.c) as "pageviews",
      count(distinct t.session_id) as "visitors",
      count( |

Checking mysqltuner I get this:

Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    join_buffer_size (> 16.0M, or always use indexes with JOINs)

16M for join_buffer is crazy, increasing it to 128M does not solve this either, it just eats up all system memory.

What index should I add to solve this issue? I don't really want to mess with the database since db/schema updates should be carried out by the umami container on it's own, if I tinker with it it will probably fail in the future.