Bug report

Required System information

• Node.js version: 20.11.1
• NPM version: 10.2.4
• Strapi version: 4.25.0
• Database: postgres
• Operating system: macos m1 chip (app in docker node:20.11.1-alpine3.19)
• Is your project Javascript or Typescript: Typescript

Describe the bug

Hi all.
When I try to click the duplicate entry button in colletion types, I get an Internal Server Error error on the UI admin panel.
In this case, the following error is displayed in the log:

strapi-1  | [2024-06-13 13:52:28.056] error: update "products_by_region_ep_product_links" as "t1" set "product_by_region_order" = (select max(product_by_region_order) + 1 from "products_by_region_ep_product_links" as "t2" where t2.ep_product_id = t1.ep_product_id) where "t1"."product_by_region_id" = $1 - relation "products_by_region_ep_product_links" does not exist
strapi-1  | error: update "products_by_region_ep_product_links" as "t1" set "product_by_region_order" = (select max(product_by_region_order) + 1 from "products_by_region_ep_product_links" as "t2" where t2.ep_product_id = t1.ep_product_id) where "t1"."product_by_region_id" = $1 - relation "products_by_region_ep_product_links" does not exist

I looked in the database and there is a created table products_by_region_ep_product_links. I also found a ticket that talks about a similar problem: #17672. I did what was recommended there (cleared the strapi_database_schema table) and it didn't help.
Looking at the error, you can understand that he has some problems with relation to another collection type.

Steps to reproduce the behavior

1. Go to 'Content manager'
2. Click on 'Open collection type'
3. Select a line and click the duplicate button

Expected behavior

The recording was successfully duplicated

Screenshots

Code snippets

If applicable, add code samples to help explain your problem.

Additional context

Add any other context about the problem here.