仪表盘新帖统计数据损坏

错误
13

好的，谢谢，这很有帮助，它表明数据本身丢失了，而不是前端有什么错误 :thinking:

此报告背后的 SQL 查询非常简单，如果您可以访问 Data Explorer 或直接访问数据库，您可以尝试运行并调整此查询，看看它是否能为您提供任何数据：

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)

这是报告代码本身：

恐怕在无法访问您的站点进行数据库挖掘的情况下，进一步调试会有些棘手。

1 个赞