Published Entries Not Visible After Migration from Strapi 4.25.17 to 5.5

System Information
  • Strapi Version:
  • Operating System:
  • Database:
  • Node Version:
  • NPM Version:
  • Yarn Version:

Hi Strapi team,

We’ve recently migrated our application from Strapi 4.25.11 to Strapi 5.5, and we’re experiencing an issue where published entries are not visible in our API responses, though they exist in the database.

Details:

  • Database verification shows we have 256 total entries:

  • 153 published entries (published_at IS NOT NULL)

  • 103 draft entries (published_at IS NULL)

  • In the API responses, we can only see the draft entries

  • We’ve verified the data integrity in PostgreSQL directly

  • The published entries are present in the database with valid published_at timestamps

  • We’ve tried modifying our controller to explicitly query for published entries using publishedAt: { $notNull: true }

  • Permissions are properly set in the admin panel

can you help?

1 Like

Hi BS_boom,

I am experiencing the same issue. This is most likely because your 153 published entries don’t have a draft counterpart. I am not sure how you migrated your data, but I used the import / export method. I’ve created an issue on Github if you’re interested.