v3.0.1

[mikecao]

This is a patch release that fixes many bugs.

Fixes

• Password managers unable to detect email field on login form Password managers unable to detect email field on login form #3735
• Support local timezone for date period Support local timezone for date period #3733
• Event data raw query failure Event data raw query failure #3732
• Website Stats API Call returns null in some fields Website Stats API Call returns null in some fields #3712
• Loop when login page not accessed directly Loop when login page not accessed directly #3703
• Geo-location tracking (Country) broken in v3.0, showing "Unknown" for majority of visitors Geo-location tracking (Country) broken in v3.0, showing "Unknown" for majority of visitors (Worked fine in v2.19.0) #3701
• UX – Prevent exporting empty datasets 🧩 UX – Prevent exporting empty datasets #3699
• Events view for "Today" doesn't show all hourly columns Events view for "Today" doesn't show all hourly columns #3697
• Realtime activity view basically unusable on mobile Realtime activity view basically unusable on mobile #3694
• No Revenue showing after update to 3.0.0 No Revenue showing after update to 3.0.0 #3692
• Deprecated timezone 'Asia/Saigon' causes PostgreSQL error in Umami (chart shows empty) Deprecated timezone 'Asia/Saigon' causes PostgreSQL error in Umami (chart shows empty) #3691
• Support local timezone for date period Support local timezone for date period #3733
• Long links are cut off Long links are cut off #3680
• Queries fail with Asia/Calcutta timezone → Postgres 22023 / Prisma P2010 (Umami 2.19.0) Queries fail with Asia/Calcutta timezone → Postgres 22023 / Prisma P2010 (Umami 2.19.0) #3660
• Location statistics broken when tracking IPv6 clients Location statistics broken when tracking IPv6 clients #3616
• Invalid reference to FROM-clause entry for table "session_data" at character 362 ERROR: invalid reference to FROM-clause entry for table "session_data" at character 362 #3545

Thanks

@Maxime-J @Mintimate @prince0xdev @mathis5711

---

This discussion was created from the release v3.0.1.

[appotry]

WARNING PostgreSQL warning: identifier "idx_16513_website_event_website_id_created_at_referrer_domain_idx" will be truncated to "idx_16513_website_event_website_id_created_at_referrer_domain_i"

Will this warning cause bugs or affect usage?

pgloader \
>     mysql://umami:xxx@ip:3306/umami \
>     pgsql://umami:xxx@ip:5432/umami
2025-11-22T03:25:19.054000Z LOG pgloader version "3.6.10~devel"
2025-11-22T03:25:19.303998Z LOG Migrating from #<MYSQL-CONNECTION mysql://umami@ip:3306/umami {1005E11D03}>
2025-11-22T03:25:19.303998Z LOG Migrating into #<PGSQL-CONNECTION pgsql://umami@ip:5432/umami {1005FD70F3}>
2025-11-22T03:25:35.684882Z WARNING PostgreSQL warning: identifier "idx_16513_website_event_website_id_created_at_referrer_domain_idx" will be truncated to "idx_16513_website_event_website_id_created_at_referrer_domain_i"
2025-11-22T03:25:54.097753Z LOG report summary reset
              table name     errors       rows      bytes      total time
------------------------  ---------  ---------  ---------  --------------
         fetch meta data          0         92                     0.685s
          Create Schemas          0          0                     0.003s
        Create SQL Types          0          0                     0.007s
           Create tables          0         26                     0.068s
          Set Table OIDs          0         13                     0.010s
------------------------  ---------  ---------  ---------  --------------
     umami.website_event          0     291114    93.1 MB         13.178s
        umami.event_data          0      31138     4.6 MB          1.799s
           umami.website          0          6     1.1 kB          1.660s
            umami."user"          0          2     0.3 kB          2.344s
            umami.report          0          1     0.4 kB          2.817s
           umami.segment          0          0                     3.019s
              umami.team          0          1     0.1 kB          4.097s
           umami.session          0     137626    20.1 MB         13.675s
umami._prisma_migrations          0         13     2.2 kB          1.060s
         umami.team_user          0          2     0.3 kB          0.371s
        umami._event_old          0          0                     3.196s
           umami.revenue          0          0                     0.365s
      umami.session_data          0          0                     0.527s
------------------------  ---------  ---------  ---------  --------------
 COPY Threads Completion          0          4                    27.221s
          Create Indexes          0         79                  3m58.143s
  Index Build Completion          0         79                     4.818s
         Reset Sequences          0          1                     0.228s
            Primary Keys          0         13                     1.022s
     Create Foreign Keys          0          0                     0.000s
         Create Triggers          0          0                     0.001s
        Install Comments          0          0                     0.001s
------------------------  ---------  ---------  ---------  --------------
       Total import time          ✓     459903   117.7 MB       4m31.434s