django.db.utils.IntegrityError: null value in column "user_id" violates not-null constraint

Hello everyone,

I have created the following model in my Project.

User = settings.AUTH_USER_MODEL

Discount_Type=(

    ('$', '$'),

    ('%', '%'),

)

class Invoice(models.Model):

    ticket          = models.OneToOneField(Ticket,  related_name='invoice', blank=True,null=True, on_delete=models.CASCADE)

    updated_by      = models.ForeignKey(User, null=True, blank=True, related_name='invoice_editor', on_delete=models.SET_NULL)

    date_created    = models.DateTimeField(auto_now_add=True)

    date_updated    = models.DateTimeField(auto_now=True)

    is_paid        = models.BooleanField(default=False)

    

    federal_price = models.DecimalField(default=20.00, max_digits=6, decimal_places=2)

    federal_qty = models.PositiveIntegerField(default=1)

    federal_amount = models.DecimalField(null=True, blank=True, max_digits=6, decimal_places=2)

    state_price = models.DecimalField(default=20.00, max_digits=6, decimal_places=2)

    state_qty = models.PositiveIntegerField(default=1)

    state_amount = models.DecimalField(null=True, blank=True, max_digits=6, decimal_places=2)

    discount = models.DecimalField(default=0.00, max_digits=6, decimal_places=2)

    discount_type  = models.CharField(default='$', max_length=5, choices=Discount_Type)

    discount_value = models.DecimalField(null=True, blank=True, max_digits=6, decimal_places=2)

    amount_payable = models.DecimalField(null=True, blank=True, max_digits=6, decimal_places=2)

    def __str__(self):

        return str(self.amount_payable)

    class Meta:

        ordering = ['-date_updated']

class Ticket(models.Model):

    tax_year        = models.CharField(max_length=50, choices=Tax_Years, default='2020')

    service         = models.CharField(max_length=50, choices=Services, default='Tax Filing')

    description     = models.TextField(max_length=1000, blank=True)

    # Customer

    customer        = models.ForeignKey(User, related_name='ticket_customer', on_delete=models.CASCADE)

My forms.py

class TicketCreateForm(forms.ModelForm):

    class Meta:

        model = Ticket

        fields = ('tax_year', 'service', 'description',)

        widgets = {

          'tax_year': forms.Select(attrs={'class': 'form-control'}),

          'service': forms.Select(attrs={'class': 'form-control'}),

          'description': forms.Textarea(attrs={'rows':3, 'cols':60, 'class':'form-control'}),

        }

My Views.py

def customer_ticket_create(request):

    form = TicketCreateForm()

    if request.method == 'POST':

        form = TicketCreateForm(request.POST or None)

        if form.is_valid():

            ticket = form.save(commit=False)

            ticket.customer = request.user  

            ticket.save()

            Invoice.objects.create( ticket=ticket, updated_by=request.user)

            return redirect('customer_home')

But I'm getting  django.db.utils.IntegrityError: "user_id" violates not-null constraint.

This error is because of  Invoice.objects.create(ticket=ticket, updated_by=request.user)

Without this line, my view is working fine. Not sure why the view is not able to create Invoice. Can someone please help me.

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/6a04a497-721c-42dc-8649-137c6b5a56f3n%40googlegroups.com.