Symfony - updating unique column - validation problem

Question

I'm new to Symfony Framework and I ran into a problem with form validation.

I want to update data in DB including unique column, but if unique column is unchanged, an error is returned (An object with the same "domain" already exist."). Domain column must be unique, but user should be able to change it. So, if one user saves his domain name, no one else can use it, but he can change it in future.

It seems like form validation compares unique column not only to other rows, but to itself too. So if user don't change the column and saves form, error is returned.

What validation should I use to preserve column unique, but free to change?

Mathieu Comandon · Accepted Answer · 2011-08-31 14:48:56Z

4

This may be an old question, but I'll add further details on the cause of this error since I also encountered the problem and found a solution.

In my case, the Validator did not return true for the isUpdate() method, this was because the 'id' field was unset.

To avoid this problem, remove the 'id' from the unset fields and change it to a sfWidgetFormInputHidden.

answered Aug 31, 2011 at 14:48

Mathieu Comandon

2021 silver badge8 bronze badges

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

1 Comment

CamelBlues Over a year ago

Yes, I ran into this same problem and simply unsetting my id column in my form's configure fixed it. I did not have to go and explicitly define id as hidden, as that was taken care of in the base class.

DuoSRX · Accepted Answer · 2010-07-02 14:37:30Z

3

If you are using Doctrine and the validator is sfValidatorDoctrineUnique, it should work as intended.

i.e validates if you are updating an object. See line 102.

answered Jul 2, 2010 at 14:37

DuoSRX

4,2093 gold badges28 silver badges32 bronze badges

Comments

Ahmed Abumostafa · Accepted Answer · 2013-04-02 11:19:27Z

2

to make isUpdate() you have to use $this->form->setPostValidator();

$this->validatorSchema->setPostValidator( new sfValidatorDoctrineUnique(array('model' => 'Model', 'column' => 'column_name')) );

answered Apr 2, 2013 at 11:19

Ahmed Abumostafa

2261 silver badge8 bronze badges

Comments

Kaxior · Accepted Answer · 2011-03-22 08:23:14Z

1

You are partly right, but the problem is, if someone want to change other field, while unique, stay the same, then the problem remains. I don't see any way to prevent this, apart from do it by yourself :/

answered Mar 22, 2011 at 8:23

Kaxior

111 bronze badge

Comments

Farid Movsumov · Accepted Answer · 2015-05-11 07:31:04Z

0

You should use merge instead of persist

For Example:

$entityManager = $this->getDoctrine()->getManager();
$loadedBrand = $entityManager->merge($loadedBrand);
$entityManager->flush();

answered May 11, 2015 at 7:31

Farid Movsumov

12.8k8 gold badges75 silver badges98 bronze badges

Collectives™ on Stack Overflow

Symfony - updating unique column - validation problem

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related