#23972feat: homepage widget entries chart error

Node Version

23.7.0

NPM/Yarn/PNPM Version

bun

Strapi Version

5.18.1

Operating System

MacOS

Database

Strapi Cloud

Javascript or Typescript

Typescript

Reproduction URL

No response

Bug Description

Homepage widget entries chart error

Steps to Reproduce

I don't know how to reproduce, it is in my homepage

Expected Behavior

I expect it to work same as the link https://github.com/strapi/strapi/pull/23903

Logs

error: select "draft"."document_id", count(distinct "draft"."document_id") as "count" from "popular_products" as "draft" inner join "popular_products" as "published" on "draft"."document_id" = "published"."document_id" and "draft"."updated_at" = "published"."updated_at" and "draft"."published_at" is null and "published"."published_at" is not null limit $1 - column "draft.document_id" must appear in the GROUP BY clause or be used in an aggregate function
error: select "draft"."document_id", count(distinct "draft"."document_id") as "count" from "popular_products" as "draft" inner join "popular_products" as "published" on "draft"."document_id" = "published"."document_id" and "draft"."updated_at" = "published"."updated_at" and "draft"."published_at" is null and "published"."published_at" is not null limit $1 - column "draft.document_id" must appear in the GROUP BY clause or be used in an aggregate function

Code Snippets

No response

Media

No response

Additional information

No response

Confirmation Checklist

• I have checked the existing issues for duplicates.
• I agree to follow this project's Code of Conduct.