Locations are broken after 2.1 update

Past Issues Searched

[X] I have searched open and closed issues to make sure that the bug has not yet been reported

Issue is a Bug Report

[X] This is a bug report and not a feature request, nor asking for self-hosted support

Using official Plausible Cloud hosting or self-hosting?

Self-hosting

Describe the bug

Hi, after I updated plausible to version 2.1, no locations are being displayed anymore. The following error appears in the logs:

Code: 47. DB::Exception: Identifier 's0.region' cannot be resolved from table with name s0. In scope SELECT toUInt64(round(uniq(s0.user_id) * any(_sample_factor))) AS visitors, s0.region FROM sessions_v2 AS s0 WHERE (((s0.site_id = _CAST(76, 'Int64')) AND (s0.start >= _CAST(1714946400, 'DateTime'))) AND (s0.start < _CAST(1717624800, 'DateTime'))) AND (s0.region != '') GROUP BY s0.region ORDER BY uniq(s0.user_id) DESC, s0.region ASC LIMIT _CAST(0, 'Int64'), _CAST(9, 'Int64'). (UNKNOWN_IDENTIFIER) (version 24.3.3.102 (official build))

Expected behavior

The locations should be displayed again.

Screenshots

No response

Environment

- OS: Ubuntu 22.04.1 LTS
- Browser: Chrome
- Browser Version: 125.0.6422.141

plausible / analytics