Django create userprofile

[hito koto]

Hi,

i have this error , why ?


(1062, "Duplicate entry '1' for key 'start_work_id'")

Exception Type:	IntegrityError
Exception Value:	(1062, "Duplicate entry '1' for key 'start_work_id'"

[Erik Cederstrand]

Please post your code for the model containing the "start_work" field. Must likely, you have defined the field with unique values and are now trying to create an model instance with a "start_work" foreign key reference that already exists.

Erik

[hito koto]

Ok, Thank you!

So, this is my the full codes;


class Staff(models.Model):
    user = models.OneToOneField(User)
    user_name = models.CharField(max_length=255,)
    first_kana = models.CharField(max_length=255,)
    last_kana  = models.CharField(max_length=255, )
    employee_number = models.CharField(blank=True, max_length=22)
    gender = models.CharField(max_length=6, choices=(('male', '男性'),('female', '女性')), verbose_name="性別" )
    created_at = models.DateTimeField(auto_now_add=True,)
    updated_at = models.DateTimeField(auto_now=True, )
    birthday = models.DateField(null=True, blank=True, )
   

    def __unicode__(self):
        return self.user_name


class Myattendance(models.Model):
    start_work = models.ForeignKey(Staff, verbose_name = "名前")
    get_work_data = models.DateTimeField(default=datetime.now, verbose_name = "出勤時間")

    class Meta:
        ordering = ['-get_work_data']

    def __unicode__(self):
        return unicode(self.start_work)

class Myleavework(models.Model):
    user = models.ForeignKey(Staff, verbose_name = "名前")
    get_off_work_data = models.DateTimeField(default=datetime.now, verbose_name = "退勤時間")

    class Meta:
        ordering = ["-get_off_work_data"]

    def __unicode__(self):
          return unicode(self.user)

This is my the views.py:

@login_required
def myattendance(request):
    if request.POST:
       # attendance = get_object_or_404(Attendence, pk=user_id)
        form = MyattendanceForm(request.POST)
        if form.is_valid():
            form.save()
            return HttpResponse('Ok')
    else:
        form = MyattendanceForm()
    args = {}
    args.update(csrf(request))
    args['form'] = form
    return render_to_response('myattendance.html', args)

@login_required
def myleavework(request):
    if request.POST:
#        leavework = Leavework.objects.get(pk = request.user.id )
        form = MyleaveworkForm(request.POST)
        if form.is_valid():
            form.save()
            return HttpResponse('Ok')
    else:
        form = MyleaveworkForm()
    args = {}
    args.update(csrf(request))
    args['form'] = form
    return render_to_response('myleave.html', args)

This is my the forms.py:

class MyattendanceForm(forms.ModelForm):

    class Meta:
        model = Myattendance


class MyleaveworkForm(forms.ModelForm):

    class Meta:
        model = Myleavework





2014年5月12日月曜日 18時21分45秒 UTC+9 Erik Cederstrand:

[hito koto]

This the error is  came out when edited and saved

2014年5月12日月曜日 18時21分45秒 UTC+9 Erik Cederstrand:

Den 12/05/2014 kl. 10.53 skrev hito koto <hitoko...@gmail.com>:

[Erik Cederstrand]

Den 12/05/2014 kl. 11.38 skrev hito koto <hitoko...@gmail.com>:

> Ok, Thank you!
>
> So, this is my the full codes;

Are you sure your database is in sync with your model? The error message implies that the field is defined with unique=True, but your model doesn't define it so:

start_work = models.ForeignKey(Staff, verbose_name = "名前")

Erik

[Helton Alves]

Reset your database and test again.

Erik

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/26954CFC-061C-4E77-80FD-EA462D2E1704%40cederstrand.dk.

For more options, visit https://groups.google.com/d/optout.

--

Helton Alves 
Desenvolvedor web
Graduado em Sistemas de Informação - FACIMP
Cursando Metodologia do Ensino Superior - INESPO

[hito koto]

Thank you !

I was should be set up unique=True 

2014年5月12日月曜日 18時46分22秒 UTC+9 Erik Cederstrand: