It would be handy also to dump out the sql statement that Doctrine is using to check what it's sending to the db with (in your model) ->getSql() It maybe that the user_id is being set to 0 rather than null. If this is the case then replace the value with Doctrine_Null.
-----Original Message----- From: symfony-users@googlegroups.com [mailto:symfony-us...@googlegroups.com] On Behalf Of Tom Haskins-Vaughan Sent: 20 May 2009 05:08 To: symfony-users@googlegroups.com Subject: [symfony-users] Re: Doctrine problem trying to add null relation object Thanks, David. I already have cart::id and buyer_id is nullable by default. Any other suggestions? David Ashwood wrote: > Throw in a cart_id and mark the buyer_id as nullable. > > -----Original Message----- > From: symfony-users@googlegroups.com [mailto:symfony-us...@googlegroups.com] > On Behalf Of Tom Haskins-Vaughan > Sent: 19 May 2009 22:01 > To: symfony-users@googlegroups.com > Subject: [symfony-users] Doctrine problem trying to add null relation object > > > symfony 1.2 > > Hi, > > I have the following shopping cart class: > > Cart: > actAs: [Timestampable] > columns: > buyer_id: { type: integer(4) } > is_default: { type: boolean, default: false } > relations: > Buyer: > class: sfGuardUser > local: buyer_id > foreign: id > > Now, when someone visits the site, and before logging in, I need to > creat a new Cart with no buyer id. But When I try to do this I get: > > 500 | Internal Server Error | Doctrine_Validator_Exception > Validation failed in class sfGuardUser > > 1 field had validation error: > > * 1 validator failed on username (notnull) > > So, I assume Doctrine is trying to create a new sfGuardUser to add to > the cart. But I want the buyer_id to be null until s/he logs in. > > Any ideas? > > Thanks. > > Tom > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
