Status column in Content Manager not displaying "Published" status
## Bug report

### Required System information

<!-- Please ensure you are using the Node LTS version (18, 20, or 22) -->
<!-- Strapi v3 is no longer supported, please update to Strapi v4 -->
<!-- If you are reporting a frontend bug please provide error logs after setting STRAPI_ENFORCE_SOURCEMAPS=true in your .env -->
<!-- This environment variable makes frontend errors easier to read and trace -->

- Node.js version: v20.18.0
- NPM version: pnpm/9.13.2 (npm/v10.9.0)
- Strapi version: 5.6.0
- Database: MySQL, MariaDB 11.5.2 
- Operating system: Debian Linux 12
- Is your project Javascript or Typescript: Javascript

### Describe the bug

After upgrading and migrating successfuly from Strapi v4 to v5 now in the content manager all publications show as "draft" in the CMS but they are actually published. Inside each publication it does show its correct state.

### Steps to reproduce the behavior

1. Create an item and set it as published.
2. Create another item and leave it as draft (just to check the issue)
3. Go back to the content manager list view and see that the "Status" column shows draft for both published and draft publications.

### Expected behavior

The column should show the correct status for "PUBLISHED" and "DRAFT" publications.

### Screenshots

![Strapi Issue](https://github.com/user-attachments/assets/15d28af6-c404-4ca5-946e-03d402fa1586)

### Additional info
Previously I used the plugin "strapi-plugin-publisher", it could have messed up the config or database somehow?
