I’m migrating to Strapi 5, since there’s no docs regarding database breaking changes, I’m trying to start my Strapi app with existing database from Strapi 4. However I’m facing the following error:
MigrationError: Migration 5.0.0-02-created-document-id (up) failed: Original error:
SELECT "strategies".id as id, string_agg(DISTINCT "inv_strategy_id"::character varying, ',') as other_ids
FROM "strategies"
LEFT JOIN "strategies_localizations_links" ON "strategies".id = "strategies_localizations_links"."strategy_id"
WHERE document_id IS NULL
GROUP BY "strategies".id, "strategy_id"
LIMIT 1;
column reference "strategy_id" is ambiguous
From the SQL, we can see it references strategy_id in GROUP BY but it does not know from which table this column lives. Is it something wrong with the Strapi 5 migration script?
This topic has been created from a Discord post (1301757273063948349) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord