Error: relation "collection_groups_collection_id_group_id" does not exist when updating version from 0.71

[milotiger]

When trying to update from v0.71.0 to v0.76.2; I got the migration error, please see below

[api] info: [database] Running migrations... 
[api] info: [database] Migrating 20230921071140-rename-collection-groups.js... 
[api] Migration 20230921071140-rename-collection-groups.js (up) failed: Original error: relation "collection_groups_collection_id_group_id" does not exist

To Reproduce
Update from v0.71.0 to v0.76.2

Expected behavior
The database will be migrated successfully and the app will be updated

Screenshots

Outline (please complete the following information):

• Install: [self hosted]
• Version: [Update from v0.71.0 to v0.76.2]

[linear[bot]]

OLN-394 Error: relation "collection_groups_collection_id_group_id" does not exist when updating version from 0.71

[tommoor]

I'm probably not going to be able to fix anything here as this version is over 6 months old, I'd recommend looking at your database relationships and renaming it so that it does exist. Perhaps the migration failed part way?

[milotiger]

I'm probably not going to be able to fix anything here as this version is over 6 months old, I'd recommend looking at your database relationships and renaming it so that it does exist. Perhaps the migration failed part way?

Yes, I will try to fix it manually, thanks so much for your great work man!