IntegrityError at /settlement/ips/purchase/400060-15019082607

NOT NULL constraint failed: settlement_order.user_uuid
Request Method: GET
Request URL: https://localhost:8000/settlement/ips/purchase/400060-15019082607
Django Version: 1.9.7
Exception Type: IntegrityError
Exception Value:
NOT NULL constraint failed: settlement_order.user_uuid
Exception Location: /var/www/django/env/keibagp/lib/python3.5/site-packages/django/db/backends/sqlite3/base.py in execute, line 323
Python Executable: /var/www/django/env/keibagp/bin/python3
Python Version: 3.5.1
Python Path:
['/var/www/django/keibagp',
 '/var/www/django/env/keibagp/bin',
 '/var/www/django/env/keibagp/lib/python35.zip',
 '/var/www/django/env/keibagp/lib/python3.5',
 '/var/www/django/env/keibagp/lib/python3.5/plat-x86_64-linux-gnu',
 '/var/www/django/env/keibagp/lib/python3.5/lib-dynload',
 '/usr/lib/python3.5',
 '/usr/lib/python3.5/plat-x86_64-linux-gnu',
 '/var/www/django/env/keibagp/lib/python3.5/site-packages']
Server time: 木, 28 3月 2024 20:49:47 +0900

Traceback Switch to copy-and-paste view



Request information

GET

No GET data

POST

No POST data

FILES

No FILES data

No cookie data

META

Variable Value
HTTP_HOST
'localhost:8000'
PATH_INFO
'/settlement/ips/purchase/400060-15019082607'
wsgi.input
<gunicorn.http.body.Body object at 0x7f766cc4e9b0>
REMOTE_PORT
'34276'
REQUEST_METHOD
'GET'
HTTP_X_FORWARDED_HOST
'www.keiba-gp.net'
wsgi.multiprocess
True
wsgi.file_wrapper
''
REMOTE_ADDR
'127.0.0.1'
wsgi.version
(1, 0)
HTTP_USER_AGENT
'claudebot'
wsgi.multithread
False
HTTP_X_FORWARDED_PROTO
'https'
wsgi.url_scheme
'https'
SERVER_PROTOCOL
'HTTP/1.1'
SERVER_PORT
'8000'
SERVER_SOFTWARE
'gunicorn/19.6.0'
SCRIPT_NAME
''
gunicorn.socket
<socket.socket fd=13, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=0, laddr=('127.0.0.1', 8000), raddr=('127.0.0.1', 34276)>
HTTP_CONNECTION
'Keep-Alive'
QUERY_STRING
''
HTTP_X_FORWARDED_FOR
'44.204.34.64'
HTTP_ACCEPT
'*/*'
HTTP_X_FORWARDED_SERVER
'www.keiba-gp.net'
SERVER_NAME
'0.0.0.0'
RAW_URI
'/settlement/ips/purchase/400060-15019082607'
wsgi.errors
<gunicorn.http.wsgi.WSGIErrorsWrapper object at 0x7f766cc4e390>
wsgi.run_once
False

Settings

Using settings module keibagp.settings

Setting Value
AUTH_USER_MODEL
'auth.User'
CSRF_COOKIE_DOMAIN
None
DEBUG
True
EMAIL_HOST
'localhost'
CACHE_MIDDLEWARE_SECONDS
600
CACHE_MIDDLEWARE_KEY_PREFIX
'********************'
LOCALE_PATHS
[]
EMAIL_USE_SSL
False
SETTINGS_MODULE
'keibagp.settings'
FIRST_DAY_OF_WEEK
0
LOGIN_URL
'/accounts/login/'
SESSION_SERIALIZER
'django.contrib.sessions.serializers.JSONSerializer'
SESSION_COOKIE_PATH
'/'
PACKAGE_NAME_FILEBROWSER
'filebrowser_safe'
SECRET_KEY
'********************'
PROJECT_ROOT
'/var/www/django/keibagp'
CSRF_COOKIE_NAME
'csrftoken'
DEVICE_USER_AGENTS
(('smapho', ('android', 'blackberry', 'iphone', 'ipod', 'windows phone')),
 ('galakei',
  ('docomo',
   'up.browser',
   'softbank',
   'vodafone',
   'j-phone',
   'mot-',
   'willcom',
   'emobile')),
 ('desktop', ('windows', 'macintosh', 'linux', 'ipad')))
TIME_FORMAT
'G:i:s'
GMO_SHOPID
'9200005040389'
SITE_ID
1
CSRF_FAILURE_VIEW
'django.views.csrf.csrf_failure'
SESSION_COOKIE_SECURE
False
DATETIME_INPUT_FORMATS
['%Y-%m-%d %H:%M:%S',
 '%Y-%m-%d %H:%M:%S.%f',
 '%Y-%m-%d %H:%M',
 '%Y-%m-%d',
 '%m/%d/%Y %H:%M:%S',
 '%m/%d/%Y %H:%M:%S.%f',
 '%m/%d/%Y %H:%M',
 '%m/%d/%Y',
 '%m/%d/%y %H:%M:%S',
 '%m/%d/%y %H:%M:%S.%f',
 '%m/%d/%y %H:%M',
 '%m/%d/%y']
EMAIL_PORT
25
LANGUAGE_COOKIE_NAME
'django_language'
SECURE_HSTS_INCLUDE_SUBDOMAINS
False
KEIBAGP_HOSTNAME
'www.keiba-gp.net'
PASSWORD_RESET_TIMEOUT_DAYS
'********************'
SESSION_ENGINE
'django.contrib.sessions.backends.db'
SECURE_SSL_HOST
None
GMO_PASSWORD
'********************'
TEMPLATE_STRING_IF_INVALID
''
DEFAULT_FROM_EMAIL
'webmaster@localhost'
FORCE_SCRIPT_NAME
None
ROOT_URLCONF
'keibagp.urls'
DATABASES
{'default': {'ATOMIC_REQUESTS': False,
             'AUTOCOMMIT': True,
             'CONN_MAX_AGE': 0,
             'ENGINE': 'django.db.backends.sqlite3',
             'HOST': '',
             'NAME': '/var/www/django/keibagp/db.sqlite3',
             'OPTIONS': {},
             'PASSWORD': '********************',
             'PORT': '',
             'TEST': {'CHARSET': None,
                      'COLLATION': None,
                      'MIRROR': None,
                      'NAME': None},
             'TIME_ZONE': None,
             'USER': ''},
 'keiba_ez': {'ATOMIC_REQUESTS': False,
              'AUTOCOMMIT': True,
              'CONN_MAX_AGE': 0,
              'ENGINE': 'mysql.connector.django',
              'HOST': 'keibadb1v',
              'NAME': 'keiba_ez',
              'OPTIONS': {'charset': 'sjis',
                          'collation': 'sjis_japanese_ci',
                          'use_unicode': False},
              'PASSWORD': '********************',
              'PORT': '',
              'TEST': {'CHARSET': None,
                       'COLLATION': None,
                       'MIRROR': None,
                       'NAME': None},
              'TIME_ZONE': None,
              'USER': 'keiba_sp_user'},
 'keiba_sp': {'ATOMIC_REQUESTS': False,
              'AUTOCOMMIT': True,
              'CONN_MAX_AGE': 0,
              'ENGINE': 'mysql.connector.django',
              'HOST': 'keibadb1v',
              'NAME': 'keiba_sp',
              'OPTIONS': {'charset': 'sjis',
                          'collation': 'sjis_japanese_ci',
                          'use_unicode': False},
              'PASSWORD': '********************',
              'PORT': '',
              'TEST': {'CHARSET': None,
                       'COLLATION': None,
                       'MIRROR': None,
                       'NAME': None},
              'TIME_ZONE': None,
              'USER': 'keiba_sp_user'}}
EMAIL_HOST_PASSWORD
'********************'
DEFAULT_CONTENT_TYPE
'text/html'
USE_X_FORWARDED_PORT
False
DEBUG_PROPAGATE_EXCEPTIONS
False
CSRF_HEADER_NAME
'HTTP_X_CSRFTOKEN'
NUMBER_GROUPING
0
USE_TZ
False
LOGGING_CONFIG
'logging.config.dictConfig'
DATE_FORMAT
'Y年n月j日'
FILE_CHARSET
'utf-8'
DEFAULT_CHARSET
'utf-8'
MIGRATION_MODULES
{}
USE_X_FORWARDED_HOST
False
LANGUAGE_CODE
'ja'
DISALLOWED_USER_AGENTS
[]
MANAGERS
[]
CACHES
{'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}
DEV_SERVER
False
DATABASE_ROUTERS
['keibagp.dbrouter.DBRouter']
FOLLOW_STATICFILES_URLPATTERNS
True
STATICFILES_FINDERS
['django.contrib.staticfiles.finders.FileSystemFinder',
 'django.contrib.staticfiles.finders.AppDirectoriesFinder']
EMAIL_USE_TLS
False
INSTALLED_APPS
('mezzanine.boot',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.redirects',
 'django.contrib.sessions',
 'django.contrib.sites',
 'django.contrib.sitemaps',
 'mezzanine.conf',
 'mezzanine.core',
 'mezzanine.generic',
 'mezzanine.pages',
 'mezzanine.blog',
 'mezzanine.forms',
 'mezzanine.galleries',
 'mezzanine.twitter',
 'mezzanine.mobile',
 'skin',
 'gunicorn',
 'import_export',
 'keiba_sp',
 'keiba_ez',
 'galakei',
 'advman',
 'api',
 'website',
 'settlement',
 'w1v',
 'filebrowser_safe',
 'grappelli_safe',
 'django.contrib.admin',
 'django.contrib.staticfiles',
 'django_comments')
CSRF_COOKIE_PATH
'/'
SESSION_EXPIRE_AT_BROWSER_CLOSE
True
SESSION_SAVE_EVERY_REQUEST
False
CSRF_COOKIE_HTTPONLY
False
OPTIONAL_APPS
('debug_toolbar',
 'django_extensions',
 'compressor',
 'filebrowser_safe',
 'grappelli_safe')
DECIMAL_SEPARATOR
'.'
STATIC_ROOT
'/var/www/django/keibagp/keibagp/static'
SESSION_FILE_PATH
None
AUTHENTICATION_BACKENDS
['mezzanine.core.auth_backends.MezzanineBackend']
FILE_UPLOAD_MAX_MEMORY_SIZE
2621440
SHORT_DATETIME_FORMAT
'Y/m/d G:i:s'
SESSION_COOKIE_AGE
1209600
EMAIL_BACKEND
'django.core.mail.backends.smtp.EmailBackend'
LOGGING
{'formatters': {'all': {'format': '%(asctime)s||%(levelname)s||%(module)s||%(process)d||%(thread)d||%(message)s'}},
 'handlers': {'console': {'class': 'logging.StreamHandler',
                          'formatter': 'all',
                          'level': 'DEBUG'},
              'file_no_rotation': {'class': 'logging.FileHandler',
                                   'filename': '/tmp/file_no_rotation.log',
                                   'formatter': 'all',
                                   'level': 'DEBUG'},
              'file_size_rotation': {'backupCount': 10,
                                     'class': 'logging.handlers.RotatingFileHandler',
                                     'filename': '/tmp/file_size_rotation.log',
                                     'formatter': 'all',
                                     'level': 'DEBUG',
                                     'maxBytes': 1048576},
              'file_time_rotation': {'backupCount': 30,
                                     'class': 'logging.handlers.TimedRotatingFileHandler',
                                     'filename': '/tmp/file_time_rotation.log',
                                     'formatter': 'all',
                                     'interval': 1,
                                     'level': 'DEBUG',
                                     'when': 'D'}},
 'loggers': {'keibagp.middleware': {'handlers': ['console'], 'level': 'INFO'},
             'settlement.providers.ips': {'handlers': ['console'],
                                          'level': 'INFO'},
             'settlement.providers.netcash': {'handlers': ['console'],
                                              'level': 'INFO'},
             'settlement.views.ips_views': {'handlers': ['console'],
                                            'level': 'INFO'},
             'website.models': {'handlers': ['console'], 'level': 'INFO'}},
 'version': 1}
LANGUAGE_COOKIE_AGE
None
USE_ETAGS
False
FILE_UPLOAD_TEMP_DIR
None
SECURE_REDIRECT_EXEMPT
[]
LOGGING_PATH
'/tmp/'
DJANGO_VERSION
(1, 9, 7, 'final', 0)
PREPEND_WWW
False
SESSION_COOKIE_HTTPONLY
True
DEFAULT_FILE_STORAGE
'django.core.files.storage.FileSystemStorage'
LANGUAGES_BIDI
['he', 'ar', 'fa', 'ur']
USE_THOUSAND_SEPARATOR
False
CSRF_COOKIE_SECURE
False
X_FRAME_OPTIONS
'SAMEORIGIN'
DATE_INPUT_FORMATS
['%Y-%m-%d',
 '%m/%d/%Y',
 '%m/%d/%y',
 '%b %d %Y',
 '%b %d, %Y',
 '%d %b %Y',
 '%d %b, %Y',
 '%B %d %Y',
 '%B %d, %Y',
 '%d %B %Y',
 '%d %B, %Y']
ADMINS
[]
FILE_UPLOAD_HANDLERS
['django.core.files.uploadhandler.MemoryFileUploadHandler',
 'django.core.files.uploadhandler.TemporaryFileUploadHandler']
TEMPLATE_DIRS
[]
FIXTURE_DIRS
[]
PASSWORD_HASHERS
'********************'
SESSION_COOKIE_DOMAIN
None
MEDIA_ROOT
'/var/www/django/keibagp/media'
THOUSAND_SEPARATOR
','
USE_L10N
False
SECURE_PROXY_SSL_HEADER
('HTTP_X_FORWARDED_PROTO', 'https')
SESSION_COOKIE_SAMESITE
'None'
TEMPLATE_LOADERS
['django.template.loaders.filesystem.Loader',
 'django.template.loaders.app_directories.Loader']
EMAIL_SSL_KEYFILE
'********************'
ALLOWED_HOSTS
['*']
COMMENTS_APP
'mezzanine.generic'
TESTING
False
PROJECT_APP
'keibagp'
DEFAULT_INDEX_TABLESPACE
''
STATIC_URL
'/static/'
PACKAGE_NAME_GRAPPELLI
'grappelli_safe'
SESSION_CACHE_ALIAS
'default'
STATICFILES_DIRS
[]
EMAIL_TIMEOUT
None
SERVER_EMAIL
'root@localhost'
IPS_SUCCESS_CODE
'THANKS'
GRAPPELLI_INSTALLED
True
TEST_NON_SERIALIZED_APPS
[]
TEMPLATES
[{'APP_DIRS': True,
  'BACKEND': 'django.template.backends.django.DjangoTemplates',
  'DIRS': ['/var/www/django/keibagp/templates'],
  'OPTIONS': {'builtins': ['mezzanine.template.loader_tags'],
              'context_processors': ['django.contrib.auth.context_processors.auth',
                                     'django.contrib.messages.context_processors.messages',
                                     'django.template.context_processors.debug',
                                     'django.template.context_processors.i18n',
                                     'django.template.context_processors.static',
                                     'django.template.context_processors.media',
                                     'django.template.context_processors.request',
                                     'django.template.context_processors.tz',
                                     'mezzanine.conf.context_processors.settings',
                                     'mezzanine.pages.context_processors.page']}}]
MEDIA_URL
'/media/'
SHORT_DATE_FORMAT
'Y/m/d'
MIDDLEWARE_CLASSES
('django_cookies_samesite.middleware.CookiesSameSite',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.locale.LocaleMiddleware',
 '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',
 'mezzanine.core.request.CurrentRequestMiddleware',
 'mezzanine.core.middleware.RedirectFallbackMiddleware',
 'keibagp.middleware.SetDeviceMiddleware',
 'keibagp.middleware.TemplateForDeviceMiddleware',
 'mezzanine.core.middleware.TemplateForHostMiddleware',
 'mezzanine.core.middleware.AdminLoginInterfaceSelectorMiddleware',
 'mezzanine.core.middleware.SitePermissionMiddleware',
 'mezzanine.pages.middleware.PageMiddleware',
 'keibagp.middleware.OutputCharasetMiddleware',
 'keibagp.middleware.SetUUIDMiddleware')
FORMAT_MODULE_PATH
None
CACHE_MIDDLEWARE_ALIAS
'default'
INTERNAL_IPS
[]
LOGIN_REDIRECT_URL
'/accounts/profile/'
NEVERCACHE_KEY
'********************'
MONTH_DAY_FORMAT
'n月j日'
SECURE_HSTS_SECONDS
0
APPEND_SLASH
True
BASE_DIR
'/var/www/django/keibagp'
WSGI_APPLICATION
None
TEMPLATE_CONTEXT_PROCESSORS
['django.contrib.auth.context_processors.auth',
 'django.template.context_processors.debug',
 'django.template.context_processors.i18n',
 'django.template.context_processors.media',
 'django.template.context_processors.static',
 'django.template.context_processors.tz',
 'django.contrib.messages.context_processors.messages']
TIME_INPUT_FORMATS
['%H:%M:%S', '%H:%M:%S.%f', '%H:%M']
AUTH_PASSWORD_VALIDATORS
'********************'
SECURE_BROWSER_XSS_FILTER
False
USE_I18N
True
TEST_RUNNER
'django.test.runner.DiscoverRunner'
SESSION_COOKIE_NAME
'sessionid'
EMAIL_HOST_USER
''
CSRF_COOKIE_AGE
31449600
EMAIL_SUBJECT_PREFIX
'[Django] '
PROJECT_APP_PATH
'/var/www/django/keibagp/keibagp'
ALLOWED_INCLUDE_ROOTS
[]
SIGNING_BACKEND
'django.core.signing.TimestampSigner'
FILE_UPLOAD_DIRECTORY_PERMISSIONS
None
DATETIME_FORMAT
'Y年n月j日G:i:s'
DEFAULT_TABLESPACE
''
TINYMCE_SETUP_JS
'/static/js/tinymce_setup.js'
LANGUAGE_COOKIE_PATH
'/'
STATICFILES_STORAGE
'django.contrib.staticfiles.storage.StaticFilesStorage'
EMAIL_SSL_CERTFILE
None
NETCASH_SHOPID
'3LY'
SILENCED_SYSTEM_CHECKS
[]
SECURE_SSL_REDIRECT
False
CSRF_TRUSTED_ORIGINS
['keiba-gp.net', 'www.keiba-gp.net']
LANGUAGES
(('ja', ''),)
DEFAULT_EXCEPTION_REPORTER_FILTER
'django.views.debug.SafeExceptionReporterFilter'
SECURE_CONTENT_TYPE_NOSNIFF
False
LOGOUT_URL
'/accounts/logout/'
MESSAGE_STORAGE
'django.contrib.messages.storage.cookie.CookieStorage'
TIME_ZONE
'Asia/Tokyo'
FILE_UPLOAD_PERMISSIONS
420
LANGUAGE_COOKIE_DOMAIN
None
IGNORABLE_404_URLS
[]
DEVICE_DEFAULT
'desktop'
YEAR_MONTH_FORMAT
'Y年n月'
TEMPLATE_DEBUG
False
ABSOLUTE_URL_OVERRIDES
{}
USE_MODELTRANSLATION
False

You're seeing this error because you have DEBUG = True in your Django settings file. Change that to False, and Django will display a standard page generated by the handler for this status code.