I got the answer from StackOverflow
<https://stackoverflow.com/a/65377458/13588941>
https://stackoverflow.com/a/65377458/13588941
On Sunday, 20 December 2020 at 09:39:43 UTC+5:30 Sai Maruthi wrote:
> This is the full error.
>
> Internal Server Error: /ticket/create
> Traceback (most recent call last):
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\backends\utils.py",
>
> line 84, in _execute
> return self.cursor.execute(sql, params)
> psycopg2.errors.NotNullViolation: null value in column "user_id" violates
> not-null constraint
> DETAIL: Failing row contains (38, 18, null).
>
>
> The above exception was the direct cause of the following exception:
>
> Traceback (most recent call last):
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\core\handlers\exception.py",
>
> line 47, in inner
> response = get_response(request)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\core\handlers\base.py",
>
> line 179, in _get_response
> response = wrapped_callback(request, *callback_args, **callback_kwargs)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\contrib\auth\decorators.py",
>
> line 21, in _wrapped_view
> return view_func(request, *args, **kwargs)
> File "C:\Users\Sai
> Maruthi\Documents\Dev\lappy\src\accounts\decorators.py", line 20, in
> wrapper_func
> return view_func(request, *args, **kwargs)
> File "C:\Users\Sai Maruthi\Documents\Dev\lappy\src\tickets\views.py",
> line 61, in customer_ticket_create
> Invoice.objects.create(
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\manager.py",
>
> line 85, in manager_method
> return getattr(self.get_queryset(), name)(*args, **kwargs)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\query.py",
>
> line 447, in create
> obj.save(force_insert=True, using=self.db)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\base.py",
>
> line 753, in save
> self.save_base(using=using, force_insert=force_insert,
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\base.py",
>
> line 801, in save_base
> post_save.send(
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\dispatch\dispatcher.py",
>
> line 177, in send
> return [
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\dispatch\dispatcher.py",
>
> line 178, in <listcomp>
> (receiver, receiver(signal=self, sender=sender, **named))
> File "C:\Users\Sai Maruthi\Documents\Dev\lappy\src\invoices\signals.py",
> line 88, in invoice_update_notification
> notification.seen_by.set([ticket.customer, ticket.support,
> ticket.preparation, ticket.filing, ticket.fbar, ticket.itin, ticket.extra])
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\fields\related_descriptors.py",
>
> line 1015, in set
> self.add(*new_objs, through_defaults=through_defaults)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\fields\related_descriptors.py",
>
> line 950, in add
> self._add_items(
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\fields\related_descriptors.py",
>
> line 1130, in _add_items
> self.through._default_manager.using(db).bulk_create([
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\query.py",
>
> line 506, in bulk_create
> returned_columns = self._batched_insert(
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\query.py",
>
> line 1277, in _batched_insert
> self._insert(item, fields=fields, using=self.db,
> ignore_conflicts=ignore_conflicts)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\query.py",
>
> line 1254, in _insert
> return query.get_compiler(using=using).execute_sql(returning_fields)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\sql\compiler.py",
>
> line 1397, in execute_sql
> cursor.execute(sql, params)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\debug_toolbar\panels\sql\tracking.py",
>
> line 198, in execute
> return self._record(self.cursor.execute, sql, params)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\debug_toolbar\panels\sql\tracking.py",
>
> line 133, in _record
> return method(sql, params)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\backends\utils.py",
>
> line 98, in execute
> return super().execute(sql, params)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\backends\utils.py",
>
> line 66, in execute
> return self._execute_with_wrappers(sql, params, many=False,
> executor=self._execute)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\backends\utils.py",
>
> line 75, in _execute_with_wrappers
> return executor(sql, params, many, context)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\backends\utils.py",
>
> line 84, in _execute
> return self.cursor.execute(sql, params)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\utils.py",
> line 90, in __exit__
> raise dj_exc_value.with_traceback(traceback) from exc_value
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\backends\utils.py",
>
> line 84, in _execute
> return self.cursor.execute(sql, params)
> django.db.utils.IntegrityError: null value in column "user_id" violates
> not-null constraint
> DETAIL: Failing row contains (38, 18, null).
>
> ERROR 2020-12-20 09:04:24,130 log 12008 12324 Internal Server Error:
> /ticket/create
> Traceback (most recent call last):
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\backends\utils.py",
>
> line 84, in _execute
> return self.cursor.execute(sql, params)
> psycopg2.errors.NotNullViolation: null value in column "user_id" violates
> not-null constraint
> DETAIL: Failing row contains (38, 18, null).
>
>
> The above exception was the direct cause of the following exception:
>
> Traceback (most recent call last):
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\core\handlers\exception.py",
>
> line 47, in inner
> response = get_response(request)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\core\handlers\base.py",
>
> line 179, in _get_response
> response = wrapped_callback(request, *callback_args, **callback_kwargs)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\contrib\auth\decorators.py",
>
> line 21, in _wrapped_view
> return view_func(request, *args, **kwargs)
> File "C:\Users\Sai
> Maruthi\Documents\Dev\lappy\src\accounts\decorators.py", line 20, in
> wrapper_func
> return view_func(request, *args, **kwargs)
> File "C:\Users\Sai Maruthi\Documents\Dev\lappy\src\tickets\views.py",
> line 61, in customer_ticket_create
> Invoice.objects.create(
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\manager.py",
>
> line 85, in manager_method
> return getattr(self.get_queryset(), name)(*args, **kwargs)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\query.py",
>
> line 447, in create
> obj.save(force_insert=True, using=self.db)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\base.py",
>
> line 753, in save
> self.save_base(using=using, force_insert=force_insert,
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\base.py",
>
> line 801, in save_base
> post_save.send(
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\dispatch\dispatcher.py",
>
> line 177, in send
> return [
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\dispatch\dispatcher.py",
>
> line 178, in <listcomp>
> (receiver, receiver(signal=self, sender=sender, **named))
> File "C:\Users\Sai Maruthi\Documents\Dev\lappy\src\invoices\signals.py",
> line 88, in invoice_update_notification
> notification.seen_by.set([ticket.customer, ticket.support,
> ticket.preparation, ticket.filing, ticket.fbar, ticket.itin, ticket.extra])
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\fields\related_descriptors.py",
>
> line 1015, in set
> self.add(*new_objs, through_defaults=through_defaults)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\fields\related_descriptors.py",
>
> line 950, in add
> self._add_items(
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\fields\related_descriptors.py",
>
> line 1130, in _add_items
> self.through._default_manager.using(db).bulk_create([
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\query.py",
>
> line 506, in bulk_create
> returned_columns = self._batched_insert(
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\query.py",
>
> line 1277, in _batched_insert
> self._insert(item, fields=fields, using=self.db,
> ignore_conflicts=ignore_conflicts)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\query.py",
>
> line 1254, in _insert
> return query.get_compiler(using=using).execute_sql(returning_fields)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\models\sql\compiler.py",
>
> line 1397, in execute_sql
> cursor.execute(sql, params)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\debug_toolbar\panels\sql\tracking.py",
>
> line 198, in execute
> return self._record(self.cursor.execute, sql, params)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\debug_toolbar\panels\sql\tracking.py",
>
> line 133, in _record
> return method(sql, params)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\backends\utils.py",
>
> line 98, in execute
> return super().execute(sql, params)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\backends\utils.py",
>
> line 66, in execute
> return self._execute_with_wrappers(sql, params, many=False,
> executor=self._execute)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\backends\utils.py",
>
> line 75, in _execute_with_wrappers
> return executor(sql, params, many, context)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\backends\utils.py",
>
> line 84, in _execute
> return self.cursor.execute(sql, params)
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\utils.py",
> line 90, in __exit__
> raise dj_exc_value.with_traceback(traceback) from exc_value
> File "C:\Users\Sai
> Maruthi\.virtualenvs\lappy-FT-EdR8P\lib\site-packages\django\db\backends\utils.py",
>
> line 84, in _execute
> return self.cursor.execute(sql, params)
> django.db.utils.IntegrityError: null value in column "user_id" violates
> not-null constraint
> DETAIL: Failing row contains (38, 18, null).
>
> On Sunday, 20 December 2020 at 09:33:16 UTC+5:30 Sai Maruthi wrote:
>
>> 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/1ff87ce9-ccf4-45ad-bbe7-73aa9732401fn%40googlegroups.com.
