Symfony2 Doctrine2 mapping from existing database (exception)

Question

I've already got a MySQL database therefore I wish to create mapping meta data from the existing database.

php app/console doctrine:mapping:convert xml ./src/MainBundle/Resources/config/doctrine/metadata/orm --from-database --force

However I got the following exception

[Doctrine\ORM\Mapping\MappingException] 
Property "customerid" in "Accountcustomer" was already declared, but it must be declared only once

I haven't used customerId in any primary / composite key anywhere else in the database however I've used it as a foreign key several times.

However I do not know how having customerId in a composite key or another primary key could affect this.

This error was is stating that there are duplicate (or more) Foreign keys on the same table. Keeping just 1 FK fixes the problem. — pdolinaj
– pdolinaj, Commented Apr 4, 2016 at 11:38

Szendvics · Accepted Answer · 2011-08-18 08:40:55Z

6

Unfortunately Doctrine 2.0 does not support primary keys as foreign keys... Check the link: http://www.doctrine-project.org/docs/orm/2.0/en/reference/limitations-and-known-issues.html

answered Aug 18, 2011 at 8:40

Szendvics

923 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

FMaz008 Over a year ago

Ok, but I have the exact same error with doctrine:schema:create, on an empty database...

Matt Over a year ago

This still does not work on Doctrine 2.1 (the reverse engineering part)

jxmallett · Accepted Answer · 2018-09-25 22:52:20Z

4

Another solution:

Drop all the foreign keys, Then it will work :) .

i know it is not recommended but it helped me. and generated Entities were working fine.

To drop all the foreign keys:

run this sql query -

MySQL

SELECT concat('ALTER TABLE ', TABLE_NAME, ' DROP FOREIGN KEY ', CONSTRAINT_NAME, ';') 
FROM information_schema.key_column_usage 
WHERE CONSTRAINT_SCHEMA = 'db_name' AND referenced_table_name IS NOT NULL;

PostgreSQL

SELECT concat('ALTER TABLE ', table_name, ' DROP CONSTRAINT IF EXISTS ', constraint_name, ';')
FROM information_schema.key_column_usage
WHERE constraint_schema = 'public' AND constraint_catalog = 'one' AND constraint_name LIKE '%_fkey';

and then run the resulted sql query again.

edited Sep 25, 2018 at 22:52

jxmallett

4,2231 gold badge30 silver badges36 bronze badges

answered Apr 23, 2015 at 9:19

vivekfyi

2,5151 gold badge27 silver badges30 bronze badges

2 Comments

pdolinaj Over a year ago

Not a good solution to remove all foreign keys. The error was obviously stating that there were duplicate (or more) Foreign keys on the same table. Keeping just 1 FK fixes the problem.

BlitZ Over a year ago

I would mention, that database backup procedure reprecaution might be necessary. +1 Helped.

ureyni · Accepted Answer · 2018-08-13 11:01:49Z

i got same error. i generate entity from exists database.

php bin/console doctrine:mapping:import App\\Entity annotation --path=src/Entity --force --verbose --no-interaction

error message is 'Property "vacancy" in "User" was already declared, but it must be declared'

I found the cause of the error when debugging the doctrine

if there is relation between one table and more than one table with manytomany and Column name is same on relate table there is relation User table and vacancy_a,vacancy_b on vacancy_id column name.

select C.COLUMN_NAME,C.TABLE_NAME,K.* from information_schema.KEY_COLUMN_USAGE K inner join information_schema.`COLUMNS` C on (C.TABLE_NAME = K.TABLE_NAME and C.TABLE_SCHEMA = K.TABLE_SCHEMA) where K.TABLE_SCHEMA='schema_name' and K.REFERENCED_TABLE_NAME='**user**' and C.COLUMN_NAME='**vacancy**_id' order by C.COLUMN_NAME

Result of Query is relate column and table.

Solution : Rename to column name

ALTER TABLE vacancy_a CHANGE vacany_id vacancy_a_id int(11);

dom · Accepted Answer · 2015-08-06 17:27:49Z

0

I got the same error and i noticed i had some double key (constraint) for single relationships in the db. Removing it, everythings worked fine.

answered Aug 6, 2015 at 17:27

dom

2112 silver badges4 bronze badges

Collectives™ on Stack Overflow

Symfony2 Doctrine2 mapping from existing database (exception)

4 Answers 4

2 Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related