I've found another solution:
1. schema.yml -> onDelete: CASCADE -> SET NULL
2.1. check if the foreign key fields have NULL(=FALSE) attribute, now
you have to change it to TRUE...
2. symfony doctrine:build --all
3. works fine :)
thank you for your help!
On Mar 19, 10:45 am, Lea Hänsenberger <baerne...@gmail.com> wrote:
> before the line where you delete the user. Probably you have to save the
> partner after unlinking and before deleting the user.
>
> On Mar 19, 2010, at 10:12 , saki wrote:
>
> > thank you! where can I put the unlink row?
>
> > On Mar 18, 7:35 pm, Lea Hänsenberger <baerne...@gmail.com> wrote:
> >> hi,
> >> there's still a partner with a foreign key pointing to the user you want
> >> to delete. you should first unlink the user from the partner:
> >> $partner->unlink('rmUser',$user_id);
>
> >> Then you should be able to delete the user object.
>
> >> cheers,
> >> Lea
>
> >> On Mar 18, 2010, at 13:19 , saki wrote:
>
> >>> 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
>
> > --
> > 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
>
> > To unsubscribe from this group, send email to
> > symfony-users+unsubscribegooglegroups.com or reply to this email with the
> > words "REMOVE ME" as the subject.
--
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
To unsubscribe from this group, send email to
symfony-users+unsubscribegooglegroups.com or reply to this email with the words
"REMOVE ME" as the subject.
