IntegrityError插入或更新表“ orders_order”违反外键约束 [英] IntegrityError Insert or update on table "orders_order" violates foreign key constraint "

问题描述

我正在尝试在Django 1.7中构建一个电子商务网站，除了尝试使用结帐时，其他所有东西都可以正常工作。我不确定它是否正在执行此操作，因为它可以在我的本地主机上正常工作，但是当我尝试在webfaction上进行部署时却不能。
非常感谢

I am trying to build an ecommerce site in Django 1.7 everything works except when I try to use the checkout, I got the following error. I am not sure wht it is doing this as it works fine on my localhost but not when I try to deploy on webfaction. Many thanks

Environment:


Request Method: GET
Request URL: http://myshoppingapp.com/checkout/

Django Version: 1.7.1
Python Version: 2.7.9
Installed Applications:
('django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.messages',
 'django.contrib.staticfiles',
 'accounts',
 'carts',
 'marketing',
 'orders',
 'products',
 'localflavor',
 'stripe')
Installed Middleware:
('django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.auth.middleware.SessionAuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.clickjacking.XFrameOptionsMiddleware',
 'marketing.middleware.DisplayMarketing')


Traceback:
File "/home/jamessmith/webapps/myshoppingapp/lib/python2.7/Django-1.7.1-py2.7.egg/django/core/handlers/base.py" in get_response
  111.                     response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/home/jamessmith/webapps/myshoppingapp/lib/python2.7/Django-1.7.1-py2.7.egg/django/contrib/auth/decorators.py" in _wrapped_view
  22.                 return view_func(request, *args, **kwargs)
File "/home/jamessmith/webapps/myshoppingapp/src/orders/views.py" in checkout
  55.       new_order.save()
File "/home/jamessmith/webapps/myshoppingapp/lib/python2.7/Django-1.7.1-py2.7.egg/django/db/models/base.py" in save
  591.                        force_update=force_update, update_fields=update_fields)
File "/home/jamessmith/webapps/myshoppingapp/lib/python2.7/Django-1.7.1-py2.7.egg/django/db/models/base.py" in save_base
  619.             updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "/home/jamessmith/webapps/myshoppingapp/lib/python2.7/Django-1.7.1-py2.7.egg/django/db/transaction.py" in __exit__
  339.                         connection.commit()
File "/home/jamessmith/webapps/myshoppingapp/lib/python2.7/Django-1.7.1-py2.7.egg/django/db/backends/__init__.py" in commit
  176.         self._commit()
File "/home/jamessmith/webapps/myshoppingapp/lib/python2.7/Django-1.7.1-py2.7.egg/django/db/backends/__init__.py" in _commit
  145.                 return self.connection.commit()
File "/home/jamessmith/webapps/myshoppingapp/lib/python2.7/Django-1.7.1-py2.7.egg/django/db/utils.py" in __exit__
  94.                 six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/home/jamessmith/webapps/myshoppingapp/lib/python2.7/Django-1.7.1-py2.7.egg/django/db/backends/__init__.py" in _commit
  145.                 return self.connection.commit()

Exception Type: IntegrityError at /checkout/
Exception Value: insert or update on table "orders_order" violates foreign key constraint "billing_address_id_41625ebca5013523_fk_accounts_useraddress_id"
DETAIL:  Key (billing_address_id)=(1) is not present in table "accounts_useraddress".

推荐答案

重要细节在此行：

DETAIL:  Key (billing_address_id)=(1) is not present in table "accounts_useraddress".

问题是您正在尝试将订单与尚不存在的账单地址链接数据库。

The problem is that you are trying to link an order with a billing address which is not yet present in the database.

在您的代码中，您需要先确保将帐单地址保存到数据库，然后再尝试保存与外键相关的对象。

In your code you'll need to make sure that the billing address is saved to the database before you try and save an object that is related to it by foreign key.

这篇关于IntegrityError插入或更新表“ orders_order”违反外键约束的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！