value too long for type character varying(13)
Request Method: | POST |
---|---|
Request URL: | http://product-open-data.com/search |
Django Version: | 1.9.2 |
Exception Type: | DataError |
Exception Value: | value too long for type character varying(13) |
Exception Location: | /app/.heroku/python/lib/python2.7/site-packages/django/db/backends/utils.py in execute, line 64 |
Python Executable: | /app/.heroku/python/bin/python |
Python Version: | 2.7.11 |
Python Path: | ['/app', '/app/.heroku/python/bin', '/app', '/app/.heroku/python/lib/python27.zip', '/app/.heroku/python/lib/python2.7', '/app/.heroku/python/lib/python2.7/plat-linux2', '/app/.heroku/python/lib/python2.7/lib-tk', '/app/.heroku/python/lib/python2.7/lib-old', '/app/.heroku/python/lib/python2.7/lib-dynload', '/app/.heroku/python/lib/python2.7/site-packages'] |
Server time: | Fri, 28 Sep 2018 03:39:58 +0000 |
/app/.heroku/python/lib/python2.7/site-packages/django/core/handlers/base.py
in get_response
response = self.process_exception_by_middleware(e, request)...
/app/.heroku/python/lib/python2.7/site-packages/django/core/handlers/base.py
in get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)...
/app/browser/views.py
in search_gtin
new_entry.save()...
/app/.heroku/python/lib/python2.7/site-packages/django/db/models/base.py
in save
force_update=force_update, update_fields=update_fields)...
/app/.heroku/python/lib/python2.7/site-packages/django/db/models/base.py
in save_base
updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)...
/app/.heroku/python/lib/python2.7/site-packages/django/db/models/base.py
in _save_table
result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)...
/app/.heroku/python/lib/python2.7/site-packages/django/db/models/base.py
in _do_insert
using=using, raw=raw)...
/app/.heroku/python/lib/python2.7/site-packages/django/db/models/manager.py
in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)...
/app/.heroku/python/lib/python2.7/site-packages/django/db/models/query.py
in _insert
return query.get_compiler(using=using).execute_sql(return_id)...
/app/.heroku/python/lib/python2.7/site-packages/django/db/models/sql/compiler.py
in execute_sql
cursor.execute(sql, params)...
/app/.heroku/python/lib/python2.7/site-packages/django/db/backends/utils.py
in execute
return super(CursorDebugWrapper, self).execute(sql, params)...
/app/.heroku/python/lib/python2.7/site-packages/django/db/backends/utils.py
in execute
return self.cursor.execute(sql, params)...
/app/.heroku/python/lib/python2.7/site-packages/django/db/utils.py
in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)...
/app/.heroku/python/lib/python2.7/site-packages/django/db/backends/utils.py
in execute
return self.cursor.execute(sql, params)...
No GET data
Variable | Value |
---|---|
csrfmiddlewaretoken | u'2ceaqRh6PpcoeRLrTvQNNqKetiMvD7Fz' |
gtin | u'058489720300299500000017' |
No FILES data
Variable | Value |
---|---|
csrftoken | '2ceaqRh6PpcoeRLrTvQNNqKetiMvD7Fz' |
Variable | Value |
---|---|
wsgi.version | (1, 0) |
QUERY_STRING | '' |
SERVER_NAME | '0.0.0.0' |
HTTP_X_FORWARDED_FOR | '128.153.144.27' |
wsgi.multithread | False |
HTTP_ACCEPT_LANGUAGE | 'en-US,en;q=0.5' |
wsgi.run_once | False |
HTTP_TOTAL_ROUTE_TIME | '0' |
SERVER_SOFTWARE | 'gunicorn/19.4.5' |
SCRIPT_NAME | u'' |
HTTP_X_FORWARDED_PROTO | 'http' |
gunicorn.socket | <socket._socketobject object at 0x7f494a8a6050> |
CONTENT_TYPE | 'application/x-www-form-urlencoded' |
wsgi.url_scheme | 'http' |
HTTP_X_REQUEST_ID | 'a8ed99a2-8873-4245-ad09-a40726e7cec4' |
wsgi.multiprocess | True |
CONTENT_LENGTH | '82' |
REMOTE_ADDR | '10.181.92.244' |
HTTP_X_REQUEST_START | '1538105998737' |
HTTP_DNT | '1' |
CSRF_COOKIE | u'2ceaqRh6PpcoeRLrTvQNNqKetiMvD7Fz' |
HTTP_X_FORWARDED_PORT | '80' |
wsgi.errors | <gunicorn.http.wsgi.WSGIErrorsWrapper object at 0x7f49496829d0> |
HTTP_UPGRADE_INSECURE_REQUESTS | '1' |
HTTP_COOKIE | 'csrftoken=2ceaqRh6PpcoeRLrTvQNNqKetiMvD7Fz' |
HTTP_VIA | '1.1 vegur' |
SERVER_PROTOCOL | 'HTTP/1.1' |
HTTP_HOST | 'product-open-data.com' |
REMOTE_PORT | '11126' |
wsgi.input | <gunicorn.http.body.Body object at 0x7f4949682490> |
HTTP_ACCEPT_ENCODING | 'gzip, deflate' |
RAW_URI | '/search' |
HTTP_ACCEPT | 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' |
HTTP_USER_AGENT | 'Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0' |
HTTP_REFERER | 'http://product-open-data.com/search' |
HTTP_CONNECT_TIME | '0' |
REQUEST_METHOD | 'POST' |
HTTP_CONNECTION | 'close' |
wsgi.file_wrapper | '' |
PATH_INFO | u'/search' |
SERVER_PORT | '17054' |
opd.settings
Setting | Value |
---|---|
EMAIL_USE_SSL | False |
TEMPLATE_DEBUG | False |
SECURE_SSL_HOST | None |
CACHES | {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}} |
SECURE_REDIRECT_EXEMPT | [] |
TEMPLATE_STRING_IF_INVALID | '' |
DEFAULT_FROM_EMAIL | 'webmaster@localhost' |
LANGUAGE_COOKIE_DOMAIN | None |
TIME_INPUT_FORMATS | ['%H:%M:%S', '%H:%M:%S.%f', '%H:%M'] |
USE_THOUSAND_SEPARATOR | False |
DEFAULT_CONTENT_TYPE | 'text/html' |
SESSION_COOKIE_SECURE | False |
SECURE_SSL_REDIRECT | False |
SECURE_BROWSER_XSS_FILTER | False |
STATICFILES_FINDERS | ['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder'] |
LOGOUT_URL | '/accounts/logout/' |
ROOT_URLCONF | 'opd.urls' |
LANGUAGE_COOKIE_PATH | '/' |
WSGI_APPLICATION | 'opd.wsgi.application' |
EMAIL_HOST_PASSWORD | u'********************' |
SECURE_HSTS_INCLUDE_SUBDOMAINS | False |
ALLOWED_HOSTS | [] |
DATETIME_FORMAT | 'N j, Y, P' |
MIDDLEWARE_CLASSES | ['django.middleware.security.SecurityMiddleware', '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'] |
X_FRAME_OPTIONS | 'SAMEORIGIN' |
DEFAULT_CHARSET | 'utf-8' |
MESSAGE_STORAGE | 'django.contrib.messages.storage.fallback.FallbackStorage' |
EMAIL_HOST_USER | '' |
SECURE_CONTENT_TYPE_NOSNIFF | False |
LOGGING | {} |
LANGUAGE_COOKIE_AGE | None |
LANGUAGE_CODE | 'en-us' |
ALLOWED_INCLUDE_ROOTS | [] |
SHORT_DATETIME_FORMAT | 'm/d/Y P' |
INTERNAL_IPS | [] |
EMAIL_BACKEND | 'django.core.mail.backends.smtp.EmailBackend' |
DATE_FORMAT | 'N j, Y' |
SESSION_COOKIE_PATH | '/' |
YEAR_MONTH_FORMAT | 'F Y' |
LANGUAGES_BIDI | ['he', 'ar', 'fa', 'ur'] |
DATABASE_ROUTERS | [] |
SESSION_ENGINE | 'django.contrib.sessions.backends.db' |
SESSION_COOKIE_AGE | 1209600 |
FORMAT_MODULE_PATH | None |
TEST_RUNNER | 'django.test.runner.DiscoverRunner' |
AUTH_USER_MODEL | 'auth.User' |
INSTALLED_APPS | ['browser.apps.BrowserConfig', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'django_extensions', 'rest_framework'] |
AUTHENTICATION_BACKENDS | ['django.contrib.auth.backends.ModelBackend'] |
NUMBER_GROUPING | 0 |
PASSWORD_HASHERS | u'********************' |
SESSION_COOKIE_DOMAIN | None |
FILE_UPLOAD_DIRECTORY_PERMISSIONS | None |
DEFAULT_INDEX_TABLESPACE | '' |
SHORT_DATE_FORMAT | 'm/d/Y' |
EMAIL_HOST | 'localhost' |
MANAGERS | [] |
SETTINGS_MODULE | 'opd.settings' |
USE_X_FORWARDED_PORT | False |
TEST_NON_SERIALIZED_APPS | [] |
CSRF_FAILURE_VIEW | 'django.views.csrf.csrf_failure' |
SERVER_EMAIL | 'root@localhost' |
LOGIN_REDIRECT_URL | '/accounts/profile/' |
TEMPLATE_DIRS | [] |
FIXTURE_DIRS | [] |
ABSOLUTE_URL_OVERRIDES | {} |
EMAIL_PORT | 25 |
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'] |
ADMINS | [] |
USE_L10N | True |
USE_I18N | True |
CSRF_COOKIE_SECURE | False |
SESSION_FILE_PATH | None |
FILE_UPLOAD_HANDLERS | ['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler'] |
SESSION_CACHE_ALIAS | 'default' |
AUTH_PASSWORD_VALIDATORS | u'********************' |
FILE_CHARSET | 'utf-8' |
CACHE_MIDDLEWARE_KEY_PREFIX | u'********************' |
MIGRATION_MODULES | {} |
LANGUAGES | [('af', 'Afrikaans'), ('ar', 'Arabic'), ('ast', 'Asturian'), ('az', 'Azerbaijani'), ('bg', 'Bulgarian'), ('be', 'Belarusian'), ('bn', 'Bengali'), ('br', 'Breton'), ('bs', 'Bosnian'), ('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('el', 'Greek'), ('en', 'English'), ('en-au', 'Australian English'), ('en-gb', 'British English'), ('eo', 'Esperanto'), ('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'), ('es-co', 'Colombian Spanish'), ('es-mx', 'Mexican Spanish'), ('es-ni', 'Nicaraguan Spanish'), ('es-ve', 'Venezuelan Spanish'), ('et', 'Estonian'), ('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'), ('fr', 'French'), ('fy', 'Frisian'), ('ga', 'Irish'), ('gd', 'Scottish Gaelic'), ('gl', 'Galician'), ('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'), ('hu', 'Hungarian'), ('ia', 'Interlingua'), ('id', 'Indonesian'), ('io', 'Ido'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('kk', 'Kazakh'), ('km', 'Khmer'), ('kn', 'Kannada'), ('ko', 'Korean'), ('lb', 'Luxembourgish'), ('lt', 'Lithuanian'), ('lv', 'Latvian'), ('mk', 'Macedonian'), ('ml', 'Malayalam'), ('mn', 'Mongolian'), ('mr', 'Marathi'), ('my', 'Burmese'), ('nb', 'Norwegian Bokmal'), ('ne', 'Nepali'), ('nl', 'Dutch'), ('nn', 'Norwegian Nynorsk'), ('os', 'Ossetic'), ('pa', 'Punjabi'), ('pl', 'Polish'), ('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sq', 'Albanian'), ('sr', 'Serbian'), ('sr-latn', 'Serbian Latin'), ('sv', 'Swedish'), ('sw', 'Swahili'), ('ta', 'Tamil'), ('te', 'Telugu'), ('th', 'Thai'), ('tr', 'Turkish'), ('tt', 'Tatar'), ('udm', 'Udmurt'), ('uk', 'Ukrainian'), ('ur', 'Urdu'), ('vi', 'Vietnamese'), ('zh-hans', 'Simplified Chinese'), ('zh-hant', 'Traditional Chinese')] |
USE_X_FORWARDED_HOST | False |
STATIC_URL | '/static/' |
USE_ETAGS | False |
DEFAULT_EXCEPTION_REPORTER_FILTER | 'django.views.debug.SafeExceptionReporterFilter' |
LANGUAGE_COOKIE_NAME | 'django_language' |
DEFAULT_FILE_STORAGE | 'django.core.files.storage.FileSystemStorage' |
SECURE_HSTS_SECONDS | 0 |
DATABASES | {'default': {'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_MAX_AGE': 0, 'ENGINE': 'django.db.backends.postgresql_psycopg2', 'HOST': 'ec2-23-21-249-224.compute-1.amazonaws.com', 'NAME': 'ddf7pcvss76stp', 'OPTIONS': {}, 'PASSWORD': u'********************', 'PORT': 5432, 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIRROR': None, 'NAME': None}, 'TIME_ZONE': None, 'USER': 'utlizhibvgbkmq'}} |
MEDIA_ROOT | '' |
LOGIN_URL | '/accounts/login/' |
TIME_ZONE | 'UTC' |
DEFAULT_TABLESPACE | '' |
THOUSAND_SEPARATOR | ',' |
EMAIL_USE_TLS | False |
TEMPLATE_LOADERS | ['django.template.loaders.filesystem.Loader', 'django.template.loaders.app_directories.Loader'] |
LOGGING_CONFIG | 'logging.config.dictConfig' |
EMAIL_TIMEOUT | None |
CSRF_TRUSTED_ORIGINS | [] |
PREPEND_WWW | False |
CSRF_COOKIE_NAME | 'csrftoken' |
DEBUG_PROPAGATE_EXCEPTIONS | False |
SESSION_EXPIRE_AT_BROWSER_CLOSE | False |
FILE_UPLOAD_PERMISSIONS | None |
LOCALE_PATHS | [] |
IGNORABLE_404_URLS | [] |
BASE_DIR | '/app' |
SECURE_PROXY_SSL_HEADER | None |
PROJECT_ROOT | '/app/opd' |
FILE_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
FIRST_DAY_OF_WEEK | 0 |
CSRF_COOKIE_HTTPONLY | False |
CSRF_COOKIE_DOMAIN | None |
CSRF_HEADER_NAME | 'HTTP_X_CSRFTOKEN' |
EMAIL_SUBJECT_PREFIX | '[Django] ' |
MONTH_DAY_FORMAT | 'F j' |
CSRF_COOKIE_PATH | '/' |
STATICFILES_DIRS | [] |
SIGNING_BACKEND | 'django.core.signing.TimestampSigner' |
SESSION_SAVE_EVERY_REQUEST | False |
APPEND_SLASH | True |
STATICFILES_STORAGE | 'whitenoise.django.GzipManifestStaticFilesStorage' |
CACHE_MIDDLEWARE_ALIAS | 'default' |
CSRF_COOKIE_AGE | 31449600 |
SESSION_COOKIE_HTTPONLY | True |
PASSWORD_RESET_TIMEOUT_DAYS | u'********************' |
STATIC_ROOT | '/app/static/' |
SILENCED_SYSTEM_CHECKS | [] |
FILE_UPLOAD_TEMP_DIR | None |
CACHE_MIDDLEWARE_SECONDS | 600 |
SESSION_SERIALIZER | 'django.contrib.sessions.serializers.JSONSerializer' |
DECIMAL_SEPARATOR | '.' |
FORCE_SCRIPT_NAME | None |
SECRET_KEY | u'********************' |
EMAIL_SSL_CERTFILE | None |
DISALLOWED_USER_AGENTS | [] |
TEMPLATES | [{'APP_DIRS': True, 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': [], 'OPTIONS': {'context_processors': ['django.template.context_processors.debug', 'django.template.context_processors.request', 'django.contrib.auth.context_processors.auth', 'django.contrib.messages.context_processors.messages', 'django.core.context_processors.media']}}] |
EMAIL_SSL_KEYFILE | u'********************' |
USE_TZ | True |
DEBUG | True |
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'] |
SESSION_COOKIE_NAME | 'sessionid' |
MEDIA_URL | 'http://product.okfn.org.s3.amazonaws.com/images/' |
TIME_FORMAT | 'P' |
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'] |
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.