Hello guys, Please take a look of this code. I want to update the data, But it's giving me this erro

U03DBF2H9DY

Hello guys, Please take a look of this code. I want to update the data, But it's giving me this error. Could you help me in it?

fsmeier

The exception says there is already an entry with the same value in the table

U03DBF2H9DY

Yes, And I want update that value.

U01LKKBK97T

Seems that the SchoolTransfer doesn't have the idSchool property set. You probably want to update an existing school in db instead of creating a new one. But without the id being set, it doesn't know which entity to update and rather will create another one.

U03DBF2H9DY

idSchool is available there.

fsmeier

either that what Kay says or the saveSchool implementation is not differentiating between create and update

U01LKKBK97T

I'd suggest to debug into SchoolFacade. Should be easy to find out.

U03DBF2H9DY

How can I update those value?

U03DBF2H9DY

Ok.

U01LKKBK97T

Another reason might be a unique constraint on the name column.

U03DBF2H9DY

Is it right for update functionality?

U01LKKBK97T

Please get familiar with debugging instead of posting dumps.

U01LKKBK97T

And check the schema.xml file for a unique constraint on the name column and remove, if you don't need it.

U03DBF2H9DY

Ok.

U03DBF2H9DY

I have removed the unique constraint but it still giving me same error.

fsmeier

the unique constraint seems to be not your main problem. if you updated the schema-file you should not forget to run propel:install

fsmeier

please look for SchoolFacade.php - there must be a method saveSchool

fsmeier

which likely uses the entityManager directly or a writer-helper class

fsmeier

and please, like Kay mentioned: get familiar how to use xdebug in visual studio code