hi guys!

Please help me to solve my little problem. I have two tables. Users
and Partners... in the schema.yml file you can see the relation..

rmPartner:
  ...
  relations:
    rmUser: { onDelete: CASCADE, local: contact, foreign: id }

Unfortunately, when I delete a User, symfony deletes his Partner(s),
too. I think onDelete: CASCADE cause this. A removed and run: symfony
doctrine:build --all ... now, when i want to delete a user, a get:

500 | Internal Server Error | Doctrine_Connection_Mysql_Exception
SQLSTATE[HY000]: General error: 1451 Cannot delete or update a parent
row: a foreign key constraint fails (`rm`.`rm_partner`, CONSTRAINT
`rm_partner_contact_rm_user_id` FOREIGN KEY (`contact`) REFERENCES
`rm_user` (`id`))

How can I solve this? What should I do, when i dont want to delete the
related rows?

Thank you in advance!

-- 
If you want to report a vulnerability issue on symfony, please send it to 
security at symfony-project.com

You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en

Reply via email to