"Waiting for first pageview" on dashboard, but with a visitor count on the sites page.

[benbot]

So i'm a bit confused.
I just got everything wired up, but plausible seems to be telling me 2 different things

Here it says it's waiting for page views:

But here it shows that it already saw two:

I can confirm that the plausible script is available on my page.

I did a search for similar issues and saw that something kind of like this happens when the protocol string is in the domain name, so I ensured that it's not.
Still getting this issue though :(

Any ideas?

[ruslandoga]

👋 @benbot

What version are you using? In v2.0.0 this page is shown when both sites.stats_start_date in plausible_db (PostgreSQL) and min(timestamp) from events_v2 ... in plausible_events_db (ClickHouse) are null.

You can check what sites.stats_start_date is set to in PostgreSQL using a query like this

$ cd hosting
$ docker compose exec plausible_db psql -U postgres -d plausible_db

:) select id, domain, stats_start_date from sites;

And you can check your events and their min date in ClickHouse like this:

$ cd hosting
$ docker compose exec plausible_events_db clickhouse client --database plausible_events_db

:) select site_id, min(timestamp) from events_v2 group by site_id;

[RichardHausgartner]

@ruslandoga , I have the exact same problem as @benbot .

I'm using:

ghcr.io/plausible/community-edition:v2.1.0-rc.0
clickhouse/clickhouse-server:23.3.7.5-alpine

clickhouse container

ac9af7f2fb37 :) select site_id, min(timestamp) from events_v2 group by site_id;

SELECT
    site_id,
    min(timestamp)
FROM events_v2
GROUP BY site_id

Query id: a617b3c9-f341-422b-af66-3460f9034ce4

┌─site_id─┬──────min(timestamp)─┐
│       1 │ 2024-03-05 16:45:44 │
└─────────┴─────────────────────┘

1 row in set. Elapsed: 0.005 sec.

Postgres container

plausible_db=#  select id, domain, stats_start_date from sites;
 id |        domain         | stats_start_date
----+-----------------------+------------------
  1 | mydomain.com |
(1 row)

When doing select * from events_v2 in clickhouse, I see all my events.
What did I wrong in installation? I reset it several times and I deleted the data directories too (I don't use volumes, I map the data to filesystem).

[ruslandoga]

As a quick workaround you can set stats_start_date manually on your site.

update sites set stats_start_date='2024-03-05' where id=1;

[RichardHausgartner]

As a quick workaround you can set stats_start_date manually on your site.

Thank you for your fast reply, @ruslandoga - that helped! (@benbot , FYI!)

Some further information:
I went back to the previous version plausible/analytics:v2.0 because of some bugs in v2.1.0-rc.0 (f.e. email sending).
At v2.0 I have the exact same problem as described in my origin posting, your update statement helped (obviously) too.

Thank you again!