pimcore 11, getting error on dataobject migration

Hi Team,

In the pimcore 10.6 version i have migrated all the classes before upgrading 11,

In the pimcore 11 v , when executing migration command => bin/console doctrine:migrations:migrate, gets dataobjects error as attached below

Im stuck with this from one week, please help me to solve this?

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Bobby Iliev
Site Moderator
Site Moderator badge
January 24, 2024

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:

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!



Try DigitalOcean for free

Click below to sign up and get $200 of credit to try our products over 60 days!

Sign up

Featured on Community

Get our biweekly newsletter

Sign up for Infrastructure as a Newsletter.

Hollie's Hub for Good

Working on improving health and education, reducing inequality, and spurring economic growth? We'd like to help.

Become a contributor

Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.

Welcome to the developer cloud

DigitalOcean makes it simple to launch in the cloud and scale up as you grow — whether you're running one virtual machine or ten thousand.

Learn more
DigitalOcean Cloud Control Panel