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/aed1f37a-3581-42af-943b-29e942aa294an%40googlegroups.com.
