Incorrect order of alters in doctrine:schema:update --force #6118

New Issue

Open

opened 2026-01-22 15:27:03 +01:00 by admin · 3 comments

admin commented 2026-01-22 15:27:03 +01:00

Owner

Copy Link

Originally created by @4n70w4 on GitHub (Dec 5, 2018).

Bug Report

Summary

I changed the yml files for my 2 entityes. I understand now alters occur in alphabetical order?

Current behavior

Then executed:

php bin/console doctrine:generate:entities MyBundle --no-backup

Then try to update db schema:

php bin/console doctrine:schema:update --force

But I get an error:

 Updating database schema...

In AbstractMySQLDriver.php line 126:

  An exception occurred while executing 'ALTER TABLE bonus ADD CONSTRAINT FK_F7569EF741DEE7B9 FOREIGN KEY (user_id) REFERENCES user (id)':

  SQLSTATE[HY000]: General error: 3734 Failed to add the foreign key constraint. Missing column 'id' for constraint 'FK_F7569EF741DEE7B9' in the referenced table 'user'

In PDOConnection.php line 109:

  SQLSTATE[HY000]: General error: 3734 Failed to add the foreign key constraint. Missing column 'id' for constraint 'FK_F7569EF741DEE7B9' in the referenced table 'user'

In PDOConnection.php line 107:

  SQLSTATE[HY000]: General error: 3734 Failed to add the foreign key constraint. Missing column 'id' for constraint 'FK_F7569EF741DEE7B9' in the referenced table 'user'

Because column id in table user need create before create relation from bonus to user.

How to reproduce

Initial only User entity:

MyBundle\Entity\User:
    type: entity
    table: null
    repositoryClass: MyBundle\Repository\UserRepository
    id:
        token:
            type: string
            length: '128'
            unique: true
    fields:
        email:
            type: string
            length: '80'

    lifecycleCallbacks: {  }

php bin/console doctrine:generate:entities MyBundle --no-backup

php bin/console doctrine:schema:update --force

In next version add Bonus entity and change User entity:

MyBundle\Entity\Bonus:
  type: entity
  table: null
  repositoryClass: MyBundle\Repository\BonusRepository
  id:
    id:
      type: integer
      id: true
      generator:
        strategy: AUTO
  manyToOne:
    user:
      targetEntity: MyBundle\Entity\User
  fields:
    value:
      type: decimal
      precision: '14'
      scale: '8'

  lifecycleCallbacks: {  }

MyBundle\Entity\User:
    type: entity
    table: null
    repositoryClass: MyBundle\Repository\UserRepository
    id:
        id:
            type: integer
            nullable: true
            unique: true
            id: true
            generator:
                strategy: AUTO
    fields:
        token:
            type: string
            length: '128'
            unique: true
        email:
            type: string
            length: '80'

    lifecycleCallbacks: {  }

php bin/console doctrine:generate:entities MyBundle --no-backup

php bin/console doctrine:schema:update --force

Expected behavior

I expect the execution of alters in the correct order.

doctrine/annotations                  v1.6.0            Docblock Annotations Parser
doctrine/cache                        v1.8.0            Caching library offering an object-oriented API for many cache backends
doctrine/collections                  v1.5.0            Collections Abstraction library
doctrine/common                       v2.9.0            Common Library for Doctrine projects
doctrine/dbal                         v2.8.0            Database Abstraction Layer
doctrine/doctrine-bundle              1.9.1             Symfony DoctrineBundle
doctrine/doctrine-cache-bundle        1.3.5             Symfony Bundle for Doctrine Cache
doctrine/event-manager                v1.0.0            Doctrine Event Manager component
doctrine/inflector                    v1.3.0            Common String Manipulations with regard to casing and singular/plural rules.
doctrine/instantiator                 1.1.0             A small, lightweight utility to instantiate objects in PHP without invoking their constructors
doctrine/lexer                        v1.0.1            Base library for a lexer that can be used in Top-Down, Recursive Descent Parsers.
doctrine/orm                          v2.6.2            Object-Relational-Mapper for PHP
doctrine/persistence                  v1.0.1            Doctrine Persistence abstractions.
doctrine/reflection                   v1.0.0            Doctrine Reflection component

Originally created by @4n70w4 on GitHub (Dec 5, 2018). ### Bug Report #### Summary I changed the yml files for my 2 entityes. I understand now alters occur in alphabetical order? #### Current behavior Then executed: `php bin/console doctrine:generate:entities MyBundle --no-backup` Then try to update db schema: `php bin/console doctrine:schema:update --force` But I get an error: ``` Updating database schema... In AbstractMySQLDriver.php line 126: An exception occurred while executing 'ALTER TABLE bonus ADD CONSTRAINT FK_F7569EF741DEE7B9 FOREIGN KEY (user_id) REFERENCES user (id)': SQLSTATE[HY000]: General error: 3734 Failed to add the foreign key constraint. Missing column 'id' for constraint 'FK_F7569EF741DEE7B9' in the referenced table 'user' In PDOConnection.php line 109: SQLSTATE[HY000]: General error: 3734 Failed to add the foreign key constraint. Missing column 'id' for constraint 'FK_F7569EF741DEE7B9' in the referenced table 'user' In PDOConnection.php line 107: SQLSTATE[HY000]: General error: 3734 Failed to add the foreign key constraint. Missing column 'id' for constraint 'FK_F7569EF741DEE7B9' in the referenced table 'user' ``` Because column id in table user need create before create relation from bonus to user. #### How to reproduce Initial only User entity: ``` MyBundle\Entity\User: type: entity table: null repositoryClass: MyBundle\Repository\UserRepository id: token: type: string length: '128' unique: true fields: email: type: string length: '80' lifecycleCallbacks: { } ``` `php bin/console doctrine:generate:entities MyBundle --no-backup` `php bin/console doctrine:schema:update --force` In next version add Bonus entity and change User entity: ``` MyBundle\Entity\Bonus: type: entity table: null repositoryClass: MyBundle\Repository\BonusRepository id: id: type: integer id: true generator: strategy: AUTO manyToOne: user: targetEntity: MyBundle\Entity\User fields: value: type: decimal precision: '14' scale: '8' lifecycleCallbacks: { } ``` ``` MyBundle\Entity\User: type: entity table: null repositoryClass: MyBundle\Repository\UserRepository id: id: type: integer nullable: true unique: true id: true generator: strategy: AUTO fields: token: type: string length: '128' unique: true email: type: string length: '80' lifecycleCallbacks: { } ``` `php bin/console doctrine:generate:entities MyBundle --no-backup` `php bin/console doctrine:schema:update --force` #### Expected behavior I expect the execution of alters in the correct order. ``` doctrine/annotations v1.6.0 Docblock Annotations Parser doctrine/cache v1.8.0 Caching library offering an object-oriented API for many cache backends doctrine/collections v1.5.0 Collections Abstraction library doctrine/common v2.9.0 Common Library for Doctrine projects doctrine/dbal v2.8.0 Database Abstraction Layer doctrine/doctrine-bundle 1.9.1 Symfony DoctrineBundle doctrine/doctrine-cache-bundle 1.3.5 Symfony Bundle for Doctrine Cache doctrine/event-manager v1.0.0 Doctrine Event Manager component doctrine/inflector v1.3.0 Common String Manipulations with regard to casing and singular/plural rules. doctrine/instantiator 1.1.0 A small, lightweight utility to instantiate objects in PHP without invoking their constructors doctrine/lexer v1.0.1 Base library for a lexer that can be used in Top-Down, Recursive Descent Parsers. doctrine/orm v2.6.2 Object-Relational-Mapper for PHP doctrine/persistence v1.0.1 Doctrine Persistence abstractions. doctrine/reflection v1.0.0 Doctrine Reflection component ```

admin commented 2026-01-22 15:27:04 +01:00

Author

Owner

Copy Link

@4n70w4 commented on GitHub (Dec 5, 2018):

Also in this case command generate incorrect alter for user.id:

ALTER TABLE user ADD id INT AUTO_INCREMENT NOT NULL;

And got error:

Error Code: 1075. Incorrect table definition; there can be only one auto column and it must be defined as a key

Correct alter like this:

ALTER TABLE user ADD id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id);

@4n70w4 commented on GitHub (Dec 5, 2018): Also in this case command generate incorrect alter for user.id: `ALTER TABLE user ADD id INT AUTO_INCREMENT NOT NULL;` And got error: `Error Code: 1075. Incorrect table definition; there can be only one auto column and it must be defined as a key` Correct alter like this: `ALTER TABLE user ADD id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (`id`);`

admin commented 2026-01-22 15:27:04 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Dec 5, 2018):

@4n70w4 can you please bump the dependencies and try again? Just need to make sure latest stable is affected as well.

@Ocramius commented on GitHub (Dec 5, 2018): @4n70w4 can you please bump the dependencies and try again? Just need to make sure latest stable is affected as well.

admin commented 2026-01-22 15:27:05 +01:00

Author

Owner

Copy Link

@4n70w4 commented on GitHub (Dec 5, 2018):

Ok, updated to:

doctrine/annotations                  v1.6.0            Docblock Annotations Parser
doctrine/cache                        v1.8.0            Caching library offering an object-oriented API for many cache backends
doctrine/collections                  v1.5.0            Collections Abstraction library
doctrine/common                       v2.10.0           PHP Doctrine Common project is a library that provides additional functionality that other Doctrine projects depend on such as better refl...
doctrine/dbal                         v2.9.0            Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management.
doctrine/doctrine-bundle              1.10.0            Symfony DoctrineBundle
doctrine/doctrine-cache-bundle        1.3.5             Symfony Bundle for Doctrine Cache
doctrine/event-manager                v1.0.0            Doctrine Event Manager component
doctrine/inflector                    v1.3.0            Common String Manipulations with regard to casing and singular/plural rules.
doctrine/instantiator                 1.1.0             A small, lightweight utility to instantiate objects in PHP without invoking their constructors
doctrine/lexer                        v1.0.1            Base library for a lexer that can be used in Top-Down, Recursive Descent Parsers.
doctrine/orm                          v2.6.3            Object-Relational-Mapper for PHP
doctrine/persistence                  v1.1.0            The Doctrine Persistence project is a set of shared interfaces and functionality that the different Doctrine object mappers share.
doctrine/reflection                   v1.0.0            Doctrine Reflection component

Problem with Error Code: 1075. Incorrect table definition; there can be only one auto column and it must be defined as a key solved.

But case from topic not solved.

php bin/console doctrine:schema:update --force --dump-sql

The following SQL statements will be executed:

     CREATE TABLE bonus (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, value NUMERIC(14, 8) NOT NULL, INDEX IDX_F7569EF741DEE7B9 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB;
     ALTER TABLE bonus ADD CONSTRAINT FK_F7569EF741DEE7B9 FOREIGN KEY (user_id) REFERENCES user (id);
     ALTER TABLE user ADD id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id);

Alter with constraint before alter with foreign field.

@4n70w4 commented on GitHub (Dec 5, 2018): Ok, updated to: ``` doctrine/annotations v1.6.0 Docblock Annotations Parser doctrine/cache v1.8.0 Caching library offering an object-oriented API for many cache backends doctrine/collections v1.5.0 Collections Abstraction library doctrine/common v2.10.0 PHP Doctrine Common project is a library that provides additional functionality that other Doctrine projects depend on such as better refl... doctrine/dbal v2.9.0 Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management. doctrine/doctrine-bundle 1.10.0 Symfony DoctrineBundle doctrine/doctrine-cache-bundle 1.3.5 Symfony Bundle for Doctrine Cache doctrine/event-manager v1.0.0 Doctrine Event Manager component doctrine/inflector v1.3.0 Common String Manipulations with regard to casing and singular/plural rules. doctrine/instantiator 1.1.0 A small, lightweight utility to instantiate objects in PHP without invoking their constructors doctrine/lexer v1.0.1 Base library for a lexer that can be used in Top-Down, Recursive Descent Parsers. doctrine/orm v2.6.3 Object-Relational-Mapper for PHP doctrine/persistence v1.1.0 The Doctrine Persistence project is a set of shared interfaces and functionality that the different Doctrine object mappers share. doctrine/reflection v1.0.0 Doctrine Reflection component ``` Problem with `Error Code: 1075. Incorrect table definition; there can be only one auto column and it must be defined as a key` solved. But case from topic not solved. `php bin/console doctrine:schema:update --force --dump-sql` The following SQL statements will be executed: ``` CREATE TABLE bonus (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, value NUMERIC(14, 8) NOT NULL, INDEX IDX_F7569EF741DEE7B9 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET UTF8 COLLATE UTF8_unicode_ci ENGINE = InnoDB; ALTER TABLE bonus ADD CONSTRAINT FK_F7569EF741DEE7B9 FOREIGN KEY (user_id) REFERENCES user (id); ALTER TABLE user ADD id INT AUTO_INCREMENT NOT NULL, ADD PRIMARY KEY (id); ``` Alter with constraint before alter with foreign field.

admin referenced this issue 2026-01-22 16:06:08 +01:00

[PR #6513] #6118 Remove `EntityManager#flush($entity)` and `UnitOfWork#commit($entity)` functionality #10012

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

3.6.x

2.20.x

dependabot/github_actions/2.20.x/doctrine/dot-github/dot-github/workflows/composer-lint.yml-14.0.0

3.7.x

4.0.x

2.21.x

old-prototype-3.x

3.6.2

3.6.1

3.6.0

2.20.9

3.5.8

3.5.7

3.5.6

3.5.5

2.20.8

3.5.4

3.5.3

2.20.7

3.5.2

2.20.6

3.5.1

3.5.0

3.4.4

3.4.3

3.4.2

2.20.5

3.4.1

3.4.0

3.3.4

2.20.4

3.3.3

2.20.3

3.3.2

2.20.2

3.3.1

2.20.1

3.3.0

3.2.3

2.20.0

2.19.8

3.2.2

2.19.7

3.2.1

2.19.6

3.2.0

3.1.4

3.1.3

2.19.5

3.1.2

2.19.4

3.1.1

2.19.3

2.19.2

2.19.1

3.1.0

2.19.0

3.0.3

2.18.3

3.0.2

2.18.2

3.0.1

2.18.1

3.0.0

2.18.0

2.17.5

3.0.0-RC1

2.17.4

2.17.3

2.17.2

2.17.1

3.0.0-beta2

2.17.0

2.16.3

3.0.0-beta1

2.16.2

2.16.1

2.16.0

2.15.5

2.15.4

2.15.3

2.15.2

2.15.1

2.15.0

2.14.3

2.14.2

2.14.1

2.14.0

2.13.5

2.13.4

2.13.3

2.13.2

2.13.1

2.13.0

2.12.4

2.12.3

2.12.2

2.12.1

2.12.0

2.11.3

2.11.2

2.11.1

2.11.0

2.10.5

2.10.4

2.10.3

2.10.2

2.10.1

2.10.0

2.9.6

2.9.5

2.9.4

2.9.3

2.9.2

2.9.1

2.9.0

2.8.5

2.8.4

2.8.3

2.8.2

2.8.1

2.8.0

2.7.5

2.7.4

v2.7.3

v2.7.2

v2.7.1

v2.7.0

v2.6.6

v2.6.5

v2.6.4

v2.6.3

v2.6.2

v2.6.1

v2.6.0

v2.5.14

v2.5.13

v2.5.12

v2.5.11

v2.5.10

v2.5.9

v2.5.8

v2.5.7

v2.5.6

v2.5.5

v2.5.4

v2.5.3

v2.5.2

v2.4.8

v2.5.1

v2.5.0

v2.5.0-RC2

v2.5.0-RC1

v2.5.0-beta1

v2.5.0-alpha2

v2.5.0-alpha1

v2.4.7

v2.4.6

v2.4.5

v2.4.4

v2.4.3

v2.3.6

v2.4.2

2.3.5

v2.4.1

v2.4.0

2.4.0-RC2

2.4.0-RC1

2.4.0-BETA2

2.3.4

2.3.3

2.4.0-BETA1

2.3.2

2.3.1

2.3.0

2.3.0-RC4

2.3.0-RC3

2.3.0-RC2

2.2.3

2.3.0-RC1

2.3.0-BETA1

2.1.7

2.2.2

2.2.1

2.1.6

2.2.0

2.2.0-RC1

2.2.0-BETA2

2.2.0-BETA1

2.1.5

2.1.4

2.1.3

2.1.2

2.1.1

2.0.7

2.1.0

2.1.0RC3

2.1.0RC2

2.1.0RC1

2.0.6

2.1.0BETA1

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

2.0.0RC2

2.0.0RC1

2.0.0-BETA4

2.0.0-BETA3

2.0.0-BETA2

2.0.0-BETA1

Labels

Clear labels

BC Break

Bug

Can't Fix

Deprecation

Documentation

DQL

Duplicate

Failing Test

Hacktoberfest

Improvement

Improvement

Incomplete

Invalid

Missing Tests

New Feature

PR Created

pull-request

Mirrored from GitHub Pull Request

Question

Regression

Status: Waiting feedback

Waiting feedback

WIP

Won't Fix

No Label

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

admin

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#6118