Upgrading from Craft v4.13.3 to the latest 4.x fails on migrations

[dolphiq-allard]

Hey Guys,

I am trying to run the critical update from v4.13.3 to the latest v4 version, however, the upgrade fails on the first migration it is running: General error: 1828 Cannot drop column 'sessionId': needed in a foreign key constraint 'fk_ieahqvsldpubpfdxylhpyjjqoseerzghvlvg'

I can fix this migration manually, however, then it fails on the second migration. My guess is that it will fail on a lot of migrations. Any clues on how to upgrade without the system failing?

Cheers,
Allard

[brandonkelly]

The only migration that touches a sessionId column in Craft 4 is m210121_145800_asset_indexing_changes, which is one of the initial Craft 4.0.0 migrations. So it should have already been run if you are already on v4.13.3.

Check your migrations DB table. Do you see a row for m210121_145800_asset_indexing_changes in there?

[dolphiq-allard]

Thanks for your quick reply. No that row is not there

[brandonkelly]

That table keeps a record of which migrations have been run. Nothing in Craft will ever delete rows in it, unless a migration is rolled back, which is typically not possible, including with this particular migration:

cms/src/migrations/m210121_145800_asset_indexing_changes.php

Lines 48 to 49 in 819f12b

	echo "m210121_145800_asset_indexing_changes cannot be reverted.\n";
	return false;

So I’m not really sure how you got in this situation, but it sounds like some (all?) rows in the table were manually deleted, or maybe someone manually created a database dump that didn’t include the table data?

Assuming this is the only table with missing data, you can fix by manually re-adding all the missing rows. Here’s all of the migrations that should be there on Craft 4.13.3: https://github.com/craftcms/cms/tree/4.13.3/src/migrations (except Install). For each migration, set track to craft, and just enter some arbitrary timestamp for applyTime, dateCreated and dateUpdated. You can use https://www.uuidgenerator.net/version4 to bulk-generate a bunch of UUIDs for the uid column.

[dolphiq-allard]

Thanks much, will fix it like this!