Migration core::5.0.0-discard-drafts (up): Migration from Strapi v4 to v5 Fails Due to Missing Table in Database
### Node Version

v20.18.0

### NPM/Yarn/PNPM Version

10.8.2

### Strapi Version

5.10.0

### Operating System

MacOS

### Database

MySQL

### Javascript or Typescript

Typescript

### Reproduction URL

_No response_

### Bug Description

While migrating from Strapi v4 to v5, the migration process fails with the following error:
```bash
MigrationError: Migration core::5.0.0-discard-drafts (up) failed: Original error: select distinct `t0`.`document_id`, `t0`.`locale`,
`t1`.`season_id` as `__strapiseason_id` from `stories_clusters` as `t0`
left join `stories_clusters_season_lnk` as `t1` on `t0`.`id` = `t1`.`stories_cluster_id`
where (`t1`.`season_id` in (1)) - Table 'hg_old.stories_clusters_season_lnk' doesn't exist
at /Users/user/dev/kcms/strapi-project/node_modules/umzug/lib/umzug.js:169:27
```

### Steps to Reproduce

Upgrade Strapi from v4 to v5 following the official migration guide.

Run yarn develop to run migrations on database

Observe the error related to the missing table stories_clusters_season_lnk

### Expected Behavior

The migration process should complete successfully without missing table errors.

### Logs

```shell

```

### Code Snippets

_No response_

### Media

_No response_

### Additional information

_No response_

### Confirmation Checklist

- [x] I have checked the existing [issues](https://github.com/strapi/strapi/issues) for duplicates.
- [x] I agree to follow this project's [Code of Conduct](https://github.com/strapi/strapi/blob/develop/CODE_OF_CONDUCT.md).