Symfony2 validation exception with unique constraint

Question

I have an entity "Movie" which has a unique constraint through doctrine annotation. Based on the movie entity I have auto generated a CRUD layer. When I now try to add a new movie I get the following exception:

Only field names mapped by Doctrine can be validated for uniqueness.

When the constraint is removed everything works fine. Do somebody has an idea where the problem lays and how I can resolve it?

My guessing is the entity, because it is new, is not sync with the EntityManager and therefore could not check the constraint. Am I'close?

I'm using Symfony 2.0.1 with Doctrine 2.1.1, MySQL as Database.

Thanks,
-lony

The "Movie" Entity:

/**
 * @ORM\Table()
 * @ORM\Entity
 * @ORM\InheritanceType("JOINED")
 * @ORM\DiscriminatorColumn(name="type", type="string")
 * @ORM\DiscriminatorMap({"movie" = "Movie", "series" = "Series"})
 * 
 * @DoctrineAssert\UniqueEntity("title_orginal")
 */
class Movie {

  /**
   * @var integer $id
   *
   * @ORM\Column(name="id", type="integer")
   * @ORM\Id
   * @ORM\GeneratedValue(strategy="AUTO")
   */
  private $id;

  /**
   * @var string $titleOrginal
   *
   * @ORM\Column(name="title_orginal", type="string", length=255, unique="true")
   */
  private $titleOrginal;

  ..

So? Did you solve your problem?

greg0ire
– greg0ire

2011-10-21 10:27:11 +00:00
Commented Oct 21, 2011 at 10:27 — greg0ire
– greg0ire, Commented Oct 21, 2011 at 10:27

greg0ire · Accepted Answer · 2011-10-09 16:17:20Z

3

Your syntax is wrong. Use this:

@DoctrineAssert\UniqueEntity(fields={"title_orginal"})

instead of

@DoctrineAssert\UniqueEntity("title_orginal")

You can then customize the violation message like this :

@DoctrineAssert\UniqueEntity(fields={"title_orginal", message="my.custom.message"})

and translate this message by using a validators.xliff file (it must be named like that). I tell you this because I struggled the other day with it and was obliged to debug to find about this validators.xliff naming convention.

edited Oct 9, 2011 at 16:17

answered Oct 6, 2011 at 9:47

greg0ire

23.3k17 gold badges76 silver badges104 bronze badges

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

2 Comments

lony Over a year ago

Without the @? So if it isn't an annotation what else is it?

greg0ire Over a year ago

With the @, of course. Sorry for the typo. I added your original code to my post so that you can spot the difference more easily.

Bill'o · Accepted Answer · 2012-10-26 08:27:42Z

3

I think there is a small typo:

@DoctrineAssert\UniqueEntity(fields={"title_orginal", message="my.custom.message"})

should be:

@DoctrineAssert\UniqueEntity(fields={"title_orginal"}, message="my.custom.message")

and for several fields

@DoctrineAssert\UniqueEntity(fields={"title_orginal", "field2"}, message="my.custom.message")

edited Oct 26, 2012 at 8:27

answered Oct 26, 2012 at 8:22

Bill'o

5241 gold badge5 silver badges21 bronze badges

Collectives™ on Stack Overflow

Symfony2 validation exception with unique constraint

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related