Hi, If you can reset the auto increment id then you can do what i do which is a bit of a hack but works.
Follow the instructions here: http://osterman.com/wordpress/2007/09/28/symfony-propel-auto_increment-offset and set the autoincrement to be 1. (This only works when you do build-all-load. Not just data-load) You can then make sure the fixture you put in first is the one you want to have an id of 1 thus. User: superadmin: name: Superadmin email: r...@root.hu login: "1" deleted: "1" Cheers, Paul I add this : On Apr 27, 12:35 pm, saki <sakrame...@gmail.com> wrote: > Hi! > > I have a problem with data fixtures, please help me! I have some data > fixture files with relations and some users in the users.yml. I would > like to set a fix ID for the superadministrator user. The superadmin > definition is the first in the users.yml, however it gets the #3, I > don't know why... > > User: > superadmin: > id: "1" > name: Superadmin > email: r...@root.hu > login: "1" > deleted: "1" > > other users... > > I got SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate > entry '1' for key 'PRIMARY' error, when i add the "id: 1" row to the > definition. How can I solve this? How can I set a fix id for the > superadministrator? > > -- > 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 > athttp://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
