FOREIGN KEY constraint failed

[DIlIMBEK TURANOV]

Environment:


Request Method: POST
Request URL: http://127.0.0.1:8000/checkout/

Django Version: 2.0.3
Python Version: 3.5.2
Installed Applications:
['django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.messages',
 'django.contrib.staticfiles',
 'landing',
 'products',
 'orders']
Installed Middleware:
['django.middleware.security.SecurityMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.clickjacking.XFrameOptionsMiddleware']



Traceback:

File "/home/den/HTML_Projects/HTML5/test_project/venv/lib/python3.5/site-packages/django/db/backends/base/base.py" in _commit
  239.                 return self.connection.commit()

The above exception (FOREIGN KEY constraint failed) was the direct cause of the following exception:

File "/home/den/HTML_Projects/HTML5/test_project/venv/lib/python3.5/site-packages/django/core/handlers/exception.py" in inner
  35.             response = get_response(request)

File "/home/den/HTML_Projects/HTML5/test_project/venv/lib/python3.5/site-packages/django/core/handlers/base.py" in _get_response
  128.                 response = self.process_exception_by_middleware(e, request)

File "/home/den/HTML_Projects/HTML5/test_project/venv/lib/python3.5/site-packages/django/core/handlers/base.py" in _get_response
  126.                 response = wrapped_callback(request, *callback_args, **callback_kwargs)

File "/home/den/HTML_Projects/HTML5/test_project/orders/views.py" in checkout
  59.             order = Order.objects.create(user=user, customer_name=name, customer_phone=phone, status_id=1)

File "/home/den/HTML_Projects/HTML5/test_project/venv/lib/python3.5/site-packages/django/db/models/manager.py" in manager_method
  82.                 return getattr(self.get_queryset(), name)(*args, **kwargs)

File "/home/den/HTML_Projects/HTML5/test_project/venv/lib/python3.5/site-packages/django/db/models/query.py" in create
  417.         obj.save(force_insert=True, using=self.db)

File "/home/den/HTML_Projects/HTML5/test_project/orders/models.py" in save
  47.         super(Order, self).save(*args, **kwargs)

File "/home/den/HTML_Projects/HTML5/test_project/venv/lib/python3.5/site-packages/django/db/models/base.py" in save
  729.                        force_update=force_update, update_fields=update_fields)

File "/home/den/HTML_Projects/HTML5/test_project/venv/lib/python3.5/site-packages/django/db/models/base.py" in save_base
  759.             updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)

File "/home/den/HTML_Projects/HTML5/test_project/venv/lib/python3.5/site-packages/django/db/transaction.py" in __exit__
  212.                         connection.commit()

File "/home/den/HTML_Projects/HTML5/test_project/venv/lib/python3.5/site-packages/django/db/backends/base/base.py" in commit
  261.         self._commit()

File "/home/den/HTML_Projects/HTML5/test_project/venv/lib/python3.5/site-packages/django/db/backends/base/base.py" in _commit
  239.                 return self.connection.commit()

File "/home/den/HTML_Projects/HTML5/test_project/venv/lib/python3.5/site-packages/django/db/utils.py" in __exit__
  89.                 raise dj_exc_value.with_traceback(traceback) from exc_value

File "/home/den/HTML_Projects/HTML5/test_project/venv/lib/python3.5/site-packages/django/db/backends/base/base.py" in _commit
  239.                 return self.connection.commit()

Exception Type: IntegrityError at /checkout/
Exception Value: FOREIGN KEY constraint failed

[Christophe Pettus]

> On Apr 7, 2018, at 12:27, DIlIMBEK TURANOV <dili...@gmail.com> wrote:
> File "/home/den/HTML_Projects/HTML5/test_project/orders/views.py" in checkout
> 59. order = Order.objects.create(user=user, customer_name=name, customer_phone=phone, status_id=1)

You're most likely creating an Order object that has a foreign key, but that foreign key isn't properly set.

--
-- Christophe Pettus
x...@thebuild.com