pimcore 11, getting error on dataobject migration

Hello there,

The error message from the screenshot indicates a missing column in your database schema, which is often the result of changes in the database structure between different versions of Pimcore.

Did you follow all of the steps from the v10 to v11 upgrade guide here:

https://pimcore.com/docs/platform/Pimcore/Installation_and_Upgrade/Updating_Pimcore/V10_to_V11/#rebuild-classes-objectbricks-fieldcollections-and-customlayouts

One of the steps indicates to make sure you’ve ran the following commands to rebuild the classes, objectBricks, fieldCollections and customLayouts:

bin/console doctrine:migration:exec 'Pimcore\Bundle\CoreBundle\Migrations\Version20230412105530'

If you’ve done all of that already, here are some other suggestions that come to my mind:

1. Backup Your Database: Before proceeding with any migration or modification, ensure you have a complete backup of your database. This will allow you to restore your data in case anything goes wrong.

2. Review Database Schema Changes:

   • Pimcore 11 might have introduced changes in the database schema which are not compatible with your current database structure.
   • Check the Pimcore migration scripts or release notes for any changes in the database schema between version 10.6 and 11.

3. Update Database Schema:

   • Run the command bin/console doctrine:schema:update --force to update the database schema. This will apply any missing database schema changes that are required for Pimcore 11.

4. Clear Cache:

   • Clear the cache in Pimcore using bin/console cache:clear. Sometimes, outdated cache can cause issues during migrations.

5. Re-run Migration:

   • After making these changes, try running bin/console doctrine:migrations:migrate again.

Database migrations can be complex, and issues like these are not uncommon. Always make sure to backup your database first!

Let me know if you encounter any further issues!

Best,

Bobby