Dashboard New Posts statistics broken

Bug
13

Okay thank you, that is helpful and it indicates that the data itself is missing, and not that there is some error on the frontend :thinking:

The SQL query that backs this report is fairly simple, if you have access to Data Explorer or directly to your DB you can try running and tweaking this and see if it will give you any data:

SELECT 
  COUNT(*) AS "count_all", 
  date(posts.created_at) AS "date_posts_created_at" 
FROM 
  "posts" 
  INNER JOIN "topics" ON "topics"."deleted_at" IS NULL 
  AND "topics"."id" = "posts"."topic_id" 
WHERE 
  "posts"."deleted_at" IS NULL 
  AND (
    topics.archetype <> 'private_message'
  ) 
  AND (
    posts.created_at >= '2025-02-01' 
    AND posts.created_at <= '2025-02-28'
  ) 
  AND "posts"."post_type" = 1 
GROUP BY 
  date(posts.created_at) 
ORDER BY 
  date(posts.created_at)

And here is the report code itself:

I’m afraid it’s kind of tricky to debug this further without having access to your site so I can dig around the database.

1 Like