Django "Column 'email_id' cannot be null"

Question

"Column 'email_id' cannot be null" This is the error I am getting when I try to fill the form when a user is logged in form will be accessible only to logged in users to update their day to day work.
This is the model:

class User(AbstractBaseUser):
 sys_id = models.AutoField(primary_key=True, blank=True)
 email = models.EmailField(
    verbose_name='email address',
    max_length=255,
    unique=True,
 )
 first_name = models.CharField(max_length=50,blank=True,null=True)
 last_name = models.CharField(max_length=50,blank=True,null=True)
 address = models.TextField(max_length=300,blank=True,null=True)
 DOB = models.DateField('Date of Birth', blank=True, null=True)
 DOJ = models.DateTimeField(auto_now=True)
 active = models.BooleanField(default=True)
 staff = models.BooleanField(default=False) 
 admin = models.BooleanField(default=False)

class services(models.Model):
 taskid = models.AutoField(primary_key=True, blank=True)
 client = models.CharField(max_length=50,blank=True,null=True)
 project = models.CharField(max_length=50,blank=True,null=True)
 taskTime = models.DateTimeField('Task Time', blank=True, null=True)
 hours = models.TimeField(blank=True, null=True)
 minutes = models.TimeField(blank=True, null=True)
 Description = models.TextField(max_length=300,blank=True,null=True)
 email = models.OneToOneField(User, on_delete=models.CASCADE)

This is Form:

class ServiceForm(forms.ModelForm):
class Meta:
    model = services
    fields = ('client','project','taskTime','hours','minutes','Description')

This is View:

@login_required
def service(request):
  if request.method == 'POST':
      user_form = ServiceForm(data=request.POST)
      if user_form.is_valid():
          user_form.email = request.user.email
          user_form.save()
      else:
          print(user_form.errors)
  else:
      user_form = ServiceForm()
  return render(request, 'service.html', {
    'user_form':user_form})

My main Problem is that user login and tries to create a service or his work details user id should automatically be assigned to the service model. Pls, help me to solve this problem.
My problem is when I create the task its has username as email and should automatically assign to it when I create the task it'not happening as mentioned duplicate it differs assigning username when creating the first form is easy but my question is I am creating another form when user logins and that user id should be assigned to this form by default.

You should patch the `email` with `user_form.instance.email = request.user.email`. — Willem Van Onsem, Aug 22 '18 at 07:01
Also, you've declared `email` to be a `OneToOneField` to `User`, but you're trying to set its value to `user.email`. — Kevin Christopher Henry, Aug 22 '18 at 07:03
Possible duplicate of [ModelForm with OneToOneField in Django](https://stackoverflow.com/questions/27832076/modelform-with-onetoonefield-in-django) — Brown Bear, Aug 22 '18 at 07:03
please read the https://django-best-practices.readthedocs.io/en/latest/code.html — Brown Bear, Aug 22 '18 at 07:04
@WillemVanOnsem i am getting this error when I use this "'[email protected]'": "services.email" must be a "User" instance. — Naga Teja, Aug 22 '18 at 07:22
@BearBrown i did not understand the possible of duplicate because i am using seperate form this form is accessible only when user logins and username is email its should automatically assign to DB when user create the his task — Naga Teja, Aug 22 '18 at 07:25
@KevinChristopherHenry yes email is OneToOneField but value should be assigned automatically when he tries to create task — Naga Teja, Aug 22 '18 at 07:32

score 0 · Answer 1 · answered Aug 22 '18 at 07:09

0

You should prepopulate your form with the required information. Because email is a OneToOne relation to User (confusing naming there!), you should use the request.user object, not the email address:

  user_form = ServiceForm(data=request.POST, initial={'email': request.user})

answered Aug 22 '18 at 07:09

Selcuk

57,004
12
102
110

I am getting the same error as before “Column 'email_id' cannot be null” – Naga Teja Aug 22 '18 at 07:26
@NagaTeja You should add `email` to the `fields` list in your form. – Selcuk Aug 28 '18 at 23:53

Django "Column 'email_id' cannot be null"

1 Answers1