Upgrading to pimcore 5.6 breaks on two different Pim installations and can be reproduced. The problem seems to exist within the migrations.
It seems to happen when you have a block types. We have a Product class with a “videos” block and an “images” block in which you can add videos and images respectively. When upgrading through composer everything goes fine until the migrations are kicked off.
in object_query_3 (the product table) it says it can’t drop the videos column. However before the upgrade there actually was a videos column. So it seems that two migrations try to remove the same column, and fail the second time. Because looking at the table after it failed, the videos column isn’t there anymore.
Any ways to fix this?