Reverse mapping from database

[gao]

Hello. I have a database with this tables:

users:
email VARCHAR(100) PK
password VARCHAR(128)
session_id VARCHAR(45)


user_profile:
email VARCHAR(100) PK FK(users.email)
name VARCHAR(255)

When I execute the command:
php app/console doctrine:mapping:convert yml ./src/Test/AccountsBundle/Resources/config/doctrine/metadata/orm --from-database --force

I get the error:
[Doctrine\ORM\Mapping\MappingException]
Property "email" in "UserProfile" was already declared, but it must be declared only once


Any idea?

Regards

[jfgrissom]

Hi Gao,

I googled and found this:
http://www.doctrine-project.org/jira/br ... y-tabpanel

They say, "It's because a foreign key is a component of the primary key."

If I understand what they are saying... simply change your primary key on user_profile. (make it an id instead of an email.)

To test my theory out... If you can do it... change your PK on the user_profile.

Generally foreign key constraints are not primary/super keys of the constrained table...

As an example:
sometable
id
name

someOtherTable
id
someTable.id (This is the constrained field.)

In this way you can create other tables with the foreign keys of both and it can still be referrenced by it's own id.

yetAnotherTable
id
someTable.id (field constrained to someTable's id)
someOtherTable.id (field constrained to someOtherTable's id)

Hope this helps!

[lunix]

I had the same issue and followed the above steps and everything worked out. Thanks much